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-06-02 | GILBEY A. GILBEY | gilbey a. gilbey | Sales | 0.0% | GBP 525.00 | GBP 0.00 | GBP 525.00 | GBP 102914.69 | |
|
Client:
gilbey a. gilbey
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 525.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-02 | BROWNLIE D. BROWNLIE | brownlie d. brownlie | Sales | 0.0% | GBP 550.00 | GBP 0.00 | GBP 550.00 | GBP 103464.69 | |
|
Client:
brownlie d. brownlie
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 550.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-02 | GREENAWAY JULIE CROOK FP25152044768049 070436 30 02JUN25 02:46 | greenaway julie crook fp24305045382545 070436 30 01nov24 03:11 | Sales | 0.0% | GBP 525.00 | GBP 0.00 | GBP 525.00 | GBP 103989.69 | |
|
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-06-02 | SYMONDS SW SYMONDS S W RP4672165804929200 200109 30 02JUN25 03:13 | symonds sw symonds s w rp4672165599210400 200109 30 02apr24 03:59 | Sales | 0.0% | GBP 440.00 | GBP 0.00 | GBP 440.00 | GBP 104429.69 | |
|
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-06-02 | DOW SA DOW S A RP4672165804502900 200109 30 02JUN25 03:14 | dow sa dow s a rp4672165686974900 200109 30 010ct24 03:05 | Sales | 0.0% | GBP 475.00 | GBP 0.00 | GBP 475.00 | GBP 104904.69 | |
|
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
|
|||||||||
| 2025-06-02 | GERVALD BELA 37 READING RD FP25152045310232 070806 30 02JUN25 04:01 | gervald bela 37 reading rd fp25061059414238 070806 30 03mar25 04:15 | Sales | 0.0% | GBP 770.00 | GBP 0.00 | GBP 770.00 | GBP 105674.69 | |
|
Client:
gervald bela 37 reading rd fp25061059414238 070806 30 03mar25 04:15
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 770.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-03 | TOM SAVAGE 300000001574389980 2502 309626 10 03JUN25 11:04 | tom savage 100000001510218467 2438 309626 10 05mar25 09:56 | Repairs and Maintenance | 0.0% | GBP 10536.00 | GBP 0.00 | GBP 10536.00 | GBP 95138.69 | |
|
Client:
tom savage 100000001510218467 2438 309626 10 05mar25 09:56
Category:
Repairs and Maintenance
VAT %:
0.0%
Net Amount:
GBP 10536.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-04 | HENLEY HEATING AND 400000001576312420 INV. 36980 089016 10 04JUN25 08:31 | henley heating and 200000001457399291 inv. 35770 089016 10 22nov24 13:49 | Repairs and Maintenance | 0.0% | GBP 234.00 | GBP 0.00 | GBP 234.00 | GBP 94904.69 | |
|
Client:
henley heating and 200000001457399291 inv. 35770 089016 10 22nov24 13:49
Category:
Repairs and Maintenance
VAT %:
0.0%
Net Amount:
GBP 234.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-06 | SCOTT BAILEY SCOTT BAILEY RENT 64053157232585000N 162015 10 06JUN25 05:31 | scott bailey scott bailey rent 52081031629225000n 162015 10 070ct24 08:10 | Sales | 0.0% | GBP 550.00 | GBP 0.00 | GBP 550.00 | GBP 95454.69 | |
|
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-06-12 | A RICHARDSON 49 HONEY LANE 400000001580992676 309294 10 12JUN25 17:47 | a richardson 49 honey lane 100000001345126266 309294 10 15may24 09:32 | Sales | 0.0% | GBP 1050.00 | GBP 0.00 | GBP 1050.00 | GBP 96504.69 | |
|
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-06-16 | J & L FREEMAN 500000001578044564 4KEYS 011001 10 16JUN25 09:31 | j & l freeman 100000001371943101 4keys 011001 10 05jul24 09:44 | Current Acct - Felicity | 0.0% | GBP 9287.50 | GBP 0.00 | GBP 9287.50 | GBP 87217.19 | |
|
Client:
j & l freeman 100000001371943101 4keys 011001 10 05jul24 09:44
Category:
Current Acct - Felicity
VAT %:
0.0%
Net Amount:
GBP 9287.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-16 | MRS. ELEANOR E REI 500000001578045139 4KEYS 309191 10 16JUN25 09:32 | mrs. eleanor e rei 600000001380845582 4keys 309191 10 05jul24 09:47 | Current Acct - EE | 0.0% | GBP 9287.50 | GBP 0.00 | GBP 9287.50 | GBP 77929.69 | |
|
Client:
mrs. eleanor e rei 600000001380845582 4keys 309191 10 05jul24 09:47
Category:
Current Acct - EE
VAT %:
0.0%
Net Amount:
GBP 9287.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-17 | SERVICE CHARGES REF : 456918511 | service charges ref : 424095040 | Bank charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 77921.19 | |
|
Client:
service charges ref : 424095040
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-18 | HOLDER STEPHEN RENT FP25168046043444 071096 30 18JUN25 01:06 | holder stephen rent fp24322046943519 071096 30 18nov24 01:13 | Sales | 0.0% | GBP 1000.00 | GBP 0.00 | GBP 1000.00 | GBP 78921.19 | |
|
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-06-23 | MRS B BOUND 400000001586697807 INV. 428 309393 10 23JUN25 11:28 | mrs b bound 500000001439097353 fourkeys-inv.416 309393 10 130ct24 12:22 | Sundry Expenses | 0.0% | GBP 346.62 | GBP 0.00 | GBP 346.62 | GBP 78574.57 | |
|
Client:
mrs b bound 500000001439097353 fourkeys-inv.416 309393 10 130ct24 12:22
Category:
Sundry Expenses
VAT %:
0.0%
Net Amount:
GBP 346.62
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-27 | VERONICA DALLAS 53 HONEY LANE HUBXB8FB468884DD74 090127 30 27JUN25 00:15 | VERONICA DALLAS | Other Expense | 0.0% | GBP 600.00 | GBP 0.00 | GBP 600.00 | GBP 79174.57 | |
|
Client:
VERONICA DALLAS
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 600.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-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 79774.57 | |
|
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-06-30 | PAIGE NORRIS RENT 57 HONEY LANE 54912790989852372 070246 10 29JUN25 20:22 | PAIGE NORRIS | Other Expense | 0.0% | GBP 750.00 | GBP 0.00 | GBP 750.00 | GBP 80524.57 | |
|
Client:
PAIGE NORRIS
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 750.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-01 | DOW SA DOW S A RP4672165819679500 200109 30 01JUL25 02:39 | dow sa dow s a rp4672165686974900 200109 30 010ct24 03:05 | Sales | 0.0% | GBP 475.00 | GBP 0.00 | GBP 475.00 | GBP 83259.57 | |
|
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
|
|||||||||
| 2025-07-01 | SYMONDS SW SYMONDS S W RP4672165820033000 200109 30 01JUL25 02:45 | symonds sw symonds s w rp4672165599210400 200109 30 02apr24 03:59 | Sales | 0.0% | GBP 440.00 | GBP 0.00 | GBP 440.00 | GBP 83699.57 | |
|
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
|
|||||||||