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-05-01 | BROWNLIE D. BROWNLIE | brownlie d. brownlie | Sales | 0.0% | GBP 550.00 | GBP 0.00 | GBP 550.00 | GBP 106815.37 | |
|
Client:
brownlie d. brownlie
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 550.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | GREENAWAY JULIE CROOK FP25120053552783 070436 30 01MAY25 03:00 | greenaway julie crook fp24305045382545 070436 30 01nov24 03:11 | Sales | 0.0% | GBP 525.00 | GBP 0.00 | GBP 525.00 | GBP 107340.37 | |
|
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-05-01 | DOW SA DOW S A RP4672165789299100 200109 30 01MAY25 03:27 | dow sa dow s a rp4672165686974900 200109 30 010ct24 03:05 | Sales | 0.0% | GBP 475.00 | GBP 0.00 | GBP 475.00 | GBP 107815.37 | |
|
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-05-01 | SYMONDS SW SYMONDS S W RP4672165789660400 200109 30 01MAY25 03:27 | symonds sw symonds s w rp4672165599210400 200109 30 02apr24 03:59 | Sales | 0.0% | GBP 440.00 | GBP 0.00 | GBP 440.00 | GBP 108255.37 | |
|
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-05-01 | GERVALD BELA 37 READING RD FP25120054254515 070806 30 01MAY25 04:11 | gervald bela 37 reading rd fp25061059414238 070806 30 03mar25 04:15 | Sales | 0.0% | GBP 770.00 | GBP 0.00 | GBP 770.00 | GBP 109025.37 | |
|
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-05-01 | NORRIS PAIGE RENT 57 HONEY LANE FP25121006862677 070246 10 01MAY25 07:10 | norris paige rent 57 honey lane fp24275016377539 070246 10 010ct24 07:45 | Sales | 0.0% | GBP 750.00 | GBP 0.00 | GBP 750.00 | GBP 109775.37 | |
|
Client:
norris paige rent 57 honey lane fp24275016377539 070246 10 010ct24 07:45
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 750.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-06 | SLADE LEGAL CLIE LAND - WATERLOO CL ACCESS MF000220D27585E900 207114 40 06MAY25 03:27 | SLADE LEGAL | Other Expense | 0.0% | GBP 4298.40 | GBP 0.00 | GBP 4298.40 | GBP 114073.77 | |
|
Client:
SLADE LEGAL
Category:
Other Expense
VAT %:
0.0%
Net Amount:
GBP 4298.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-06 | SCOTT BAILEY SCOTT BAILEY RENT 29183750118134000N 162015 10 06MAY25 18:37 | scott bailey scott bailey rent 52081031629225000n 162015 10 070ct24 08:10 | Sales | 0.0% | GBP 550.00 | GBP 0.00 | GBP 550.00 | GBP 114623.77 | |
|
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-05-07 | TOM SAVAGE 600000001555315926 2473 309626 10 07MAY25 12:35 | tom savage 100000001510218467 2438 309626 10 05mar25 09:56 | Repairs and Maintenance | 0.0% | GBP 2496.00 | GBP 0.00 | GBP 2496.00 | GBP 112127.77 | |
|
Client:
tom savage 100000001510218467 2438 309626 10 05mar25 09:56
Category:
Repairs and Maintenance
VAT %:
0.0%
Net Amount:
GBP 2496.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-07 | OAKLEY WOOD MASTER 300000001558992733 FB.25.01.2055 204545 10 07MAY25 12:39 | oakley wood master 200000001375174408 fb24.01.1949 204545 10 02jul24 09:25 | Repairs and Maintenance | 0.0% | GBP 1556.93 | GBP 0.00 | GBP 1556.93 | GBP 110570.84 | |
|
Client:
oakley wood master 200000001375174408 fb24.01.1949 204545 10 02jul24 09:25
Category:
Repairs and Maintenance
VAT %:
0.0%
Net Amount:
GBP 1556.93
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-07 | MRS B BOUND 400000001560422091 INV. 426 309393 10 07MAY25 12:40 | mrs b bound 500000001439097353 fourkeys-inv.416 309393 10 130ct24 12:22 | Sundry Expenses | 0.0% | GBP 329.45 | GBP 0.00 | GBP 329.45 | GBP 110241.39 | |
|
Client:
mrs b bound 500000001439097353 fourkeys-inv.416 309393 10 130ct24 12:22
Category:
Sundry Expenses
VAT %:
0.0%
Net Amount:
GBP 329.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-08 | HENLEY HEATING AND | 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 110085.39 | |
|
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-05-13 | A RICHARDSON 49 HONEY LANE 100000001549483566 309294 10 13MAY25 00:50 | a richardson 49 honey lane 100000001345126266 309294 10 15may24 09:32 | Sales | 0.0% | GBP 1050.00 | GBP 0.00 | GBP 1050.00 | GBP 111135.39 | |
|
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-05-19 | HOLDER STEPHEN RENT FP25138057185088 071096 30 19MAY25 01:08 | holder stephen rent fp24322046943519 071096 30 18nov24 01:13 | Sales | 0.0% | GBP 1000.00 | GBP 0.00 | GBP 1000.00 | GBP 112135.39 | |
|
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-05-19 | SERVICE CHARGES REF : 454497681 | service charges ref : 424095040 | Bank charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 101590.89 | |
|
Client:
service charges ref : 424095040
Category:
Bank charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-19 | TOM SAVAGE 300000001565605515 2489 309626 10 19MAY25 17:22 | tom savage 100000001510218467 2438 309626 10 05mar25 09:56 | Repairs and Maintenance | 0.0% | GBP 10536.00 | GBP 0.00 | GBP 10536.00 | GBP 101599.39 | |
|
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-05-27 | P.A.PALMER 500000001564912626 53 HONEY LANE 200109 10 24MAY25 10:24 | norris paige rent 57 honey lane fp24275016377539 070246 10 010ct24 07:45 | Sales | 0.0% | GBP 40.00 | GBP 0.00 | GBP 40.00 | GBP 101550.89 | |
|
Client:
norris paige rent 57 honey lane fp24275016377539 070246 10 010ct24 07:45
Category:
Sales
VAT %:
0.0%
Net Amount:
GBP 40.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-29 | GESNERS PROPERTY M 100000001558640584 53 HONEY LANE FEES 200109 10 29MAY25 16:21 | gesners property m 600000001344464382 49 honey lane fee 200109 10 08may24 18:03 | Repairs and Maintenance | 0.0% | GBP 571.20 | GBP 0.00 | GBP 571.20 | GBP 100979.69 | |
|
Client:
gesners property m 600000001344464382 49 honey lane fee 200109 10 08may24 18:03
Category:
Repairs and Maintenance
VAT %:
0.0%
Net Amount:
GBP 571.20
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 | 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
|
|||||||||