GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 5 gaps > 7 days: 04/22/2025 to 05/01/2025 (9 days), 05/19/2025 to 05/27/2025 (8 days), 08/18/2025 to 08/27/2025 (9 days), 09/18/2025 to 09/29/2025 (11 days), 12/18/2025 to 12/29/2025 (11 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-11-05 | MRS B BOUND 500000001659281709 INV. 434 309393 10 05NOV25 13:01 | mrs b bound 500000001439097353 fourkeys-inv.416 309393 10 130ct24 12:22 | Sundry Expenses | 0.0% | GBP 352.01 | GBP 0.00 | GBP 352.01 | GBP 100191.03 | |
|
Client:
mrs b bound 500000001439097353 fourkeys-inv.416 309393 10 130ct24 12:22
Category:
Sundry Expenses
VAT %:
0.0%
Net Amount:
GBP 352.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-07 | SCOTT BAILEY SCOTT BAILEY RENT 59070442372010000N 162015 10 07NOV25 07:04 | scott bailey scott bailey rent 52081031629225000n 162015 10 070ct24 08:10 | Sales | 0.0% | GBP 550.00 | GBP 0.00 | GBP 550.00 | GBP 100741.03 | |
|
Client:
scott bailey scott bailey rent 52081031629225000n 162015 10 070ct24 08:10
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 550.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-10 | ELECTRICAL SOLUTIO 400000001665857104 SI-1416 090129 10 08NOV25 10:02 | ELECTRICAL SOLUTIO | Other Expense | 0.0% | GBP 1462.07 | GBP 0.00 | GBP 1462.07 | GBP 99278.96 | |
|
Client:
ELECTRICAL SOLUTIO
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 1462.07
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-12 | A RICHARDSON 49 HONEY LANE 300000001666627817 309294 10 12NOV25 15:20 | a richardson 49 honey lane 100000001345126266 309294 10 15may24 09:32 | Sales | 0.0% | GBP 1050.00 | GBP 0.00 | GBP 1050.00 | GBP 100328.96 | |
|
Client:
a richardson 49 honey lane 100000001345126266 309294 10 15may24 09:32
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1050.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-18 | HOLDER STEPHEN RENT FP25321040095101 071096 30 18NOV25 00:26 | holder stephen rent fp24322046943519 071096 30 18nov24 01:13 | Sales | 0.0% | GBP 1000.00 | GBP 0.00 | GBP 1000.00 | GBP 101328.96 | |
|
Client:
holder stephen rent fp24322046943519 071096 30 18nov24 01:13
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 1000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-18 | SERVICE CHARGES REF : 469037241 | service charges ref : 424095040 | Bank charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 101320.46 | |
|
Client:
service charges ref : 424095040
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-24 | HENLEY HEATING AND 500000001669590208 40351 089016 10 24NOV25 10:02 | henley heating and 200000001457399291 inv. 35770 089016 10 22nov24 13:49 | Repairs and Maintenance | 0.0% | GBP 3732.00 | GBP 0.00 | GBP 3732.00 | GBP 97588.46 | |
|
Client:
henley heating and 200000001457399291 inv. 35770 089016 10 22nov24 13:49
Category:
Repairs and Maintenance
VAT %:
0.0%
Net Amount:
GBP 3732.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-24 | HENLEY HEATING AND 400000001674444646 40353 089016 10 24NOV25 10:05 | henley heating and 200000001457399291 inv. 35770 089016 10 22nov24 13:49 | Repairs and Maintenance | 0.0% | GBP 217.01 | GBP 0.00 | GBP 217.01 | GBP 97371.45 | |
|
Client:
henley heating and 200000001457399291 inv. 35770 089016 10 22nov24 13:49
Category:
Repairs and Maintenance
VAT %:
0.0%
Net Amount:
GBP 217.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-24 | HENLEY HEATING AND 400000001674445518 40361 089016 10 24NOV25 10:06 | henley heating and 200000001457399291 inv. 35770 089016 10 22nov24 13:49 | Repairs and Maintenance | 0.0% | GBP 156.00 | GBP 0.00 | GBP 156.00 | GBP 97215.45 | |
|
Client:
henley heating and 200000001457399291 inv. 35770 089016 10 22nov24 13:49
Category:
Repairs and Maintenance
VAT %:
0.0%
Net Amount:
GBP 156.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-27 | VERONICA DALLAS 53 HONEY LANE HUBX5716A52A7DCCA4 090127 30 27NOV25 00:06 | VERONICA DALLAS | Other Expense | 0.0% | GBP 600.00 | GBP 0.00 | GBP 600.00 | GBP 97815.45 | |
|
Client:
VERONICA DALLAS
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 600.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-27 | A DALLAS 53 HONEY LANE | norris paige rent 57 honey lane fp24275016377539 070246 10 010ct24 07:45 | Sales | 0.0% | GBP 600.00 | GBP 0.00 | GBP 600.00 | GBP 98415.45 | |
|
Client:
norris paige rent 57 honey lane fp24275016377539 070246 10 010ct24 07:45
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 600.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-27 | DRAIN SURGEONS GRO 100000001662488674 INV-0731 087199 10 27NOV25 15:50 | drain surgeons uk 100000001518513631 inv-37483 207103 10 20mar25 16:17 | Repairs and Maintenance | 0.0% | GBP 648.00 | GBP 0.00 | GBP 648.00 | GBP 97767.45 | |
|
Client:
drain surgeons uk 100000001518513631 inv-37483 207103 10 20mar25 16:17
Category:
Repairs and Maintenance
VAT %:
0.0%
Net Amount:
GBP 648.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-27 | OAKLEY WOOD MASTER 400000001676510265 FB25.04.2188 204545 10 27NOV25 16:04 | oakley wood master 200000001375174408 fb24.01.1949 204545 10 02jul24 09:25 | Repairs and Maintenance | 0.0% | GBP 3000.00 | GBP 0.00 | GBP 3000.00 | GBP 94767.45 | |
|
Client:
oakley wood master 200000001375174408 fb24.01.1949 204545 10 02jul24 09:25
Category:
Repairs and Maintenance
VAT %:
0.0%
Net Amount:
GBP 3000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-01 | PAIGE NORRIS RENT 57 HONEY LANE 77891445762260210 070246 10 30NOV25 18:19 | PAIGE NORRIS | Other Expense | 0.0% | GBP 750.00 | GBP 0.00 | GBP 750.00 | GBP 95517.45 | |
|
Client:
PAIGE NORRIS
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 750.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-01 | L FRANCIS LINDSEY FRANCIS | l francis lindsey francis | Sales | 0.0% | GBP 660.00 | GBP 0.00 | GBP 660.00 | GBP 96177.45 | |
|
Client:
l francis lindsey francis
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-01 | GILBEY A. GILBEY | gilbey a. gilbey | Sales | 0.0% | GBP 525.00 | GBP 0.00 | GBP 525.00 | GBP 96702.45 | |
|
Client:
gilbey a. gilbey
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 525.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-01 | BROWNLIE D. BROWNLIE | brownlie d. brownlie | Sales | 0.0% | GBP 550.00 | GBP 0.00 | GBP 550.00 | GBP 97252.45 | |
|
Client:
brownlie d. brownlie
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 550.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-01 | GREENAWAY JULIE CROOK FP25334041224994 070436 30 01DEC25 03:10 | greenaway julie crook fp24305045382545 070436 30 01nov24 03:11 | Sales | 0.0% | GBP 525.00 | GBP 0.00 | GBP 525.00 | GBP 97777.45 | |
|
Client:
greenaway julie crook fp24305045382545 070436 30 01nov24 03:11
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 525.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-01 | SYMONDS SW SYMONDS S W RP4672165895849900 200109 30 01DEC25 03:52 | symonds sw symonds s w rp4672165599210400 200109 30 02apr24 03:59 | Sales | 0.0% | GBP 440.00 | GBP 0.00 | GBP 440.00 | GBP 98217.45 | |
|
Client:
symonds sw symonds s w rp4672165599210400 200109 30 02apr24 03:59
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 440.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-01 | DOW SA DOW S A RP4672165895431600 200109 30 01DEC25 03:52 | dow sa dow s a rp4672165686974900 200109 30 010ct24 03:05 | Sales | 0.0% | GBP 475.00 | GBP 0.00 | GBP 475.00 | GBP 98692.45 | |
|
Client:
dow sa dow s a rp4672165686974900 200109 30 010ct24 03:05
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 475.00
VAT Amount:
GBP 0.00
|
|||||||||