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-10-31 | NEWTOWN ROAD (HERE | newtown road (here | Property management and service charges | 0.0% | GBP 75.00 | GBP 0.00 | GBP 75.00 | GBP 14579.58 | |
|
Client:
newtown road (here
Category:
Property management and service charges
VAT %:
0.0%
Net Amount:
GBP 75.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-31 | BOOKING.COM BV NO.AX4UTA9QERRVZD7 | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 142.61 | GBP 0.00 | GBP 142.61 | GBP 14654.58 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 142.61
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-31 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 134.77 | GBP 0.00 | GBP 134.77 | GBP 14511.97 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 134.77
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | CJ COTTERELL 400000001663020395 CLEANING 070806 10 03NOV25 14:45 | COTTERELL CLEANING | Cleaning | 0.0% | GBP 50.00 | GBP 0.00 | GBP 50.00 | GBP 14172.45 | |
|
Client:
COTTERELL CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 50.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | ZEPHRY HOMELOANS ZBR00001/860075608 | zephry homeloans zbr00001/860075608 | Home Loan | 0.0% | GBP 227.00 | GBP 0.00 | GBP 227.00 | GBP 14222.45 | |
|
Client:
zephry homeloans zbr00001/860075608
Category:
Home Loan
VAT %:
0.0%
Net Amount:
GBP 227.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | EDF ENERGY A-B4F04F07-001 | edf energy a-b4f04f07-001 | Light and heat | 0.0% | GBP 129.52 | GBP 0.00 | GBP 129.52 | GBP 14449.45 | |
|
Client:
edf energy a-b4f04f07-001
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 129.52
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | DWR CYMRU WELSH WA 5513220001 | dwr cymru welsh wa 5416805701 | Water Rates | 0.0% | GBP 60.00 | GBP 0.00 | GBP 60.00 | GBP 14578.97 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | TV LICENCE MBP 4254618094 | TV LICENCE | Subscriptions | 0.0% | GBP 14.12 | GBP 0.00 | GBP 14.12 | GBP 14638.97 | |
|
Client:
TV LICENCE
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 14.12
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-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 14653.09 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 12.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | BOOKING.COM BV NO.0TA7JERERV8ZKQN | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.01 | GBP 0.00 | GBP 120.01 | GBP 14665.59 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-04 | BOOKING.COM BV NO.93OZJGRMNMQ9RES | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 219.48 | GBP 0.00 | GBP 219.48 | GBP 14511.94 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 219.48
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-04 | BOOKING.COM BV NO.2W7JRGCC1DJYGSY | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.01 | GBP 0.00 | GBP 120.01 | GBP 14292.46 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-05 | CJ COTTERELL 400000001664120738 CLEANING 070806 10 05NOV25 12:38 | COTTERELL CLEANING | Cleaning | 0.0% | GBP 40.00 | GBP 0.00 | GBP 40.00 | GBP 15030.89 | |
|
Client:
COTTERELL CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 40.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-05 | STRIPE PAYMENTS UK STRIPE XP8231878985598305 185008 10 05NOV25 08:20 | Other | Other Expenses | 0.0% | GBP 29.05 | GBP 0.00 | GBP 29.05 | GBP 15070.89 | |
|
Client:
Other
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 29.05
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-05 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 289.79 | GBP 0.00 | GBP 289.79 | GBP 15041.84 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 289.79
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-05 | BOOKING.COM BV NO.SMS8M7LVEG7RNLO | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.10 | GBP 0.00 | GBP 120.10 | GBP 14752.05 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.10
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-05 | BOOKING.COM BV NO.SCQQGDSENFEOVAD | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.01 | GBP 0.00 | GBP 120.01 | GBP 14631.95 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-06 | ELIZABETH VIRGO 300000001663297515 CLEANING 206055 10 06NOV25 14:10 | ELIZABETH VIRGO | Cleaning | 0.0% | GBP 25.00 | GBP 0.00 | GBP 25.00 | GBP 15005.89 | |
|
Client:
ELIZABETH VIRGO
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 25.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-07 | HAMPSHIRE TRUST BA 40094687 | HAMPSHIRE TRUST | New loan | 0.0% | GBP 1020.25 | GBP 0.00 | GBP 1020.25 | GBP 14105.65 | |
|
Client:
HAMPSHIRE TRUST
Category:
New loan
VAT %:
0.0%
Net Amount:
GBP 1020.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-07 | BOOKING.COM BV NO.8PJ30RD031JV8TY | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.01 | GBP 0.00 | GBP 120.01 | GBP 15125.90 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.01
VAT Amount:
GBP 0.00
|
|||||||||