GPT Analysis: Excel data processed directly from structured columns; Balance Analysis: Statement incomplete: Balance difference of £26970.66 exceeds acceptable tolerance (£0.1). Calculated closing balance: £-9642.11, Stated closing balance: £17328.55; Date Gap Analysis: Found 1 gap > 7 days: 01/06/2025 to 01/16/2025 (10 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-02-21 | H.C.C COUNCIL TAX 247562 | Council | Rates | 0.0% | GBP 2697.87 | GBP 0.00 | GBP 2697.87 | GBP 4886.98 | |
|
Client:
Council
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 2697.87
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-24 | PNET5182871-1 PNET5182871-1 | pnet5182871-1 pnet5182871-1 | Subscriptions | 0.0% | GBP 24.99 | GBP 0.00 | GBP 24.99 | GBP 5983.42 | |
|
Client:
pnet5182871-1 pnet5182871-1
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 24.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-24 | BOOKING.COM BV NO.JYCJZ02GTWLPGFI | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 821.43 | GBP 0.00 | GBP 821.43 | GBP 6008.41 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 821.43
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-28 | NEWTOWN ROAD (HERE | newtown road (here | Property management and service charges | 0.0% | GBP 68.00 | GBP 0.00 | GBP 68.00 | GBP 5915.42 | |
|
Client:
newtown road (here
Category:
Property management and service charges
VAT %:
0.0%
Net Amount:
GBP 68.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-03 | ZEPHRY HOMELOANS ZBR00001/860075608 | zephry homeloans zbr00001/860075608 | Home Loan | 0.0% | GBP 227.00 | GBP 0.00 | GBP 227.00 | GBP 6356.85 | |
|
Client:
zephry homeloans zbr00001/860075608
Category:
Home Loan
VAT %:
0.0%
Net Amount:
GBP 227.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-03 | EDF ENERGY A-B4F04F07-001 | edf energy a-b4f04f07-001 | Light and heat | 0.0% | GBP 54.16 | GBP 0.00 | GBP 54.16 | GBP 6583.85 | |
|
Client:
edf energy a-b4f04f07-001
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 54.16
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-03 | TV LICENCE MBP 4254618094 | TV LICENCE | Subscriptions | 0.0% | GBP 33.90 | GBP 0.00 | GBP 33.90 | GBP 6638.01 | |
|
Client:
TV LICENCE
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 33.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-03 | DWR CYMRU WELSH WA 5416805701 | dwr cymru welsh wa 5416805701 | Water Rates | 0.0% | GBP 12.50 | GBP 0.00 | GBP 12.50 | GBP 6671.91 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 12.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-03 | BOOKING.COM BV NO.LXHSMJRQEWQSWFD | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 768.99 | GBP 0.00 | GBP 768.99 | GBP 6684.41 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 768.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-05 | NIGHTINGA NIGHTINGALE 043619938002503001 404039 10 05MAR25 20:08 | NIGHTINGA NIGHTINGALE | Rent | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 6386.85 | |
|
Client:
NIGHTINGA NIGHTINGALE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-07 | L PRENTICE GUY PRENTICE 200000001517010759 309414 10 07MAR25 20:21 | L PRENTICE GUY | Rent | 0.0% | GBP 833.33 | GBP 0.00 | GBP 833.33 | GBP 6085.54 | |
|
Client:
L PRENTICE GUY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 833.33
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-07 | HAMPSHIRE TRUST BA 40094687 | HAMPSHIRE TRUST | New loan | 0.0% | GBP 1134.64 | GBP 0.00 | GBP 1134.64 | GBP 5252.21 | |
|
Client:
HAMPSHIRE TRUST
Category:
New loan
VAT %:
0.0%
Net Amount:
GBP 1134.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-10 | The Farmers Boy In CD 8312 | THE FARMERS | Travel expenses | 0.0% | GBP 95.10 | GBP 0.00 | GBP 95.10 | GBP 5991.36 | |
|
Client:
THE FARMERS
Category:
Travel expenses
VAT %:
0.0%
Net Amount:
GBP 95.10
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-10 | BESECURE 100000001512351210 SI-14437 308055 10 08MAR25 20:22 | BESECURE | Repairs and maintenance | 0.0% | GBP 120.00 | GBP 0.00 | GBP 120.00 | GBP 5965.54 | |
|
Client:
BESECURE
Category:
Repairs and maintenance
VAT %:
0.0%
Net Amount:
GBP 120.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-10 | BOOKING.COM BV NO.U8FL6J2UGEYXSMC | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.92 | GBP 0.00 | GBP 120.92 | GBP 6086.46 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.92
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-12 | DVLA VEHICLE TAX CD 8312 | dvla vehicle tax cd 8312 03mar24 | Vehicle Running costs | 0.0% | GBP 385.00 | GBP 0.00 | GBP 385.00 | GBP 5706.62 | |
|
Client:
dvla vehicle tax cd 8312 03mar24
Category:
Vehicle Running costs
VAT %:
0.0%
Net Amount:
GBP 385.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-12 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 100.26 | GBP 0.00 | GBP 100.26 | GBP 6091.62 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 100.26
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-17 | BOOKING.COM BV NO.DLDK4DC0N5QJGBU | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 377.16 | GBP 0.00 | GBP 377.16 | GBP 6544.07 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 377.16
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-17 | E PARR EMILY PARR 100000001516272653 309606 10 16MAR25 10:46 | E PARR EMILY | Rent | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 5806.62 | |
|
Client:
E PARR EMILY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-17 | BOOKING.COM BV NO.3KF9LMKJXZYTWVA | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 360.29 | GBP 0.00 | GBP 360.29 | GBP 6166.91 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 360.29
VAT Amount:
GBP 0.00
|
|||||||||