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-09-29 | BOOKING.COM BV NO.AENGLDA4SIN7JWE | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 227.38 | GBP 0.00 | GBP 227.38 | GBP 12279.82 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 227.38
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-29 | BOOKING.COM BV NO.QSZ7BNYSZBMQPCU | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 197.80 | GBP 0.00 | GBP 197.80 | GBP 12052.44 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 197.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-30 | NEWTOWN ROAD (HERE | newtown road (here | Property management and service charges | 0.0% | GBP 75.00 | GBP 0.00 | GBP 75.00 | GBP 12273.72 | |
|
Client:
newtown road (here
Category:
Property management and service charges
VAT %:
0.0%
Net Amount:
GBP 75.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-30 | BOOKING.COM BV NO.XINTKP9LCGGASMI | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.01 | GBP 0.00 | GBP 120.01 | GBP 12348.72 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-30 | BOOKING.COM BV NO.00T4DO1CLNKHBLR | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 98.89 | GBP 0.00 | GBP 98.89 | GBP 12228.71 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 98.89
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-01 | ZEPHRY HOMELOANS ZBR00001/860075608 | zephry homeloans zbr00001/860075608 | Home Loan | 0.0% | GBP 227.00 | GBP 0.00 | GBP 227.00 | GBP 12449.48 | |
|
Client:
zephry homeloans zbr00001/860075608
Category:
Home Loan
VAT %:
0.0%
Net Amount:
GBP 227.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-01 | 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 12676.48 | |
|
Client:
edf energy a-b4f04f07-001
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 129.52
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-01 | DWR CYMRU WELSH WA 5513220001 | dwr cymru welsh wa 5416805701 | Water Rates | 0.0% | GBP 60.00 | GBP 0.00 | GBP 60.00 | GBP 12806.00 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-01 | TV LICENCE MBP 4254618094 | TV LICENCE | Subscriptions | 0.0% | GBP 14.12 | GBP 0.00 | GBP 14.12 | GBP 12866.00 | |
|
Client:
TV LICENCE
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 14.12
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-01 | DWR CYMRU WELSH WA 5416805701 | dwr cymru welsh wa 5416805701 | Water Rates | 0.0% | GBP 12.50 | GBP 0.00 | GBP 12.50 | GBP 12880.12 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 12.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-01 | BOOKING.COM BV NO.QPCLUH58GPNKM3Z | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 262.62 | GBP 0.00 | GBP 262.62 | GBP 12892.62 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 262.62
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-01 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 257.39 | GBP 0.00 | GBP 257.39 | GBP 12630.00 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 257.39
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-01 | BOOKING.COM BV NO.MF53ZG3I0ACDKZS | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 98.89 | GBP 0.00 | GBP 98.89 | GBP 12372.61 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 98.89
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-02 | AMAZON UK* WK8OP30 CD 8312 | amazon* 187589cp5 cd 8312 | Repairs and maintenance | 0.0% | GBP 300.00 | GBP 0.00 | GBP 300.00 | GBP 11849.48 | |
|
Client:
amazon* 187589cp5 cd 8312
Category:
Repairs and maintenance
VAT %:
0.0%
Net Amount:
GBP 300.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-02 | AMAZON UK* VN0IK1A CD 8312 | amazon* 187589cp5 cd 8312 | Repairs and maintenance | 0.0% | GBP 300.00 | GBP 0.00 | GBP 300.00 | GBP 12149.48 | |
|
Client:
amazon* 187589cp5 cd 8312
Category:
Repairs and maintenance
VAT %:
0.0%
Net Amount:
GBP 300.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-03 | BRISTOL CITY COUNC CD 8312 | Council | Rates | 0.0% | GBP 69.00 | GBP 0.00 | GBP 69.00 | GBP 11748.48 | |
|
Client:
Council
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 69.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-03 | ELIZABETH VIRGO 300000001643969357 CLEANING 206055 10 03OCT25 12:32 | ELIZABETH VIRGO | Cleaning | 0.0% | GBP 32.00 | GBP 0.00 | GBP 32.00 | GBP 11817.48 | |
|
Client:
ELIZABETH VIRGO
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 32.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-06 | SMARTESTENERGY BUS 400000001646642954 ERTTFBXKQ 402069 10 05OCT25 19:28 | SMARTESTENERGY BUS ERTTFBXKQ | Light and heat | 0.0% | GBP 1145.88 | GBP 0.00 | GBP 1145.88 | GBP 10602.60 | |
|
Client:
SMARTESTENERGY BUS ERTTFBXKQ
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 1145.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-07 | STRIPE PAYMENTS UK STRIPE XP8014311365388849 185008 10 07OCT25 08:23 | Other | Other Expenses | 0.0% | GBP 311.60 | GBP 0.00 | GBP 311.60 | GBP 10091.75 | |
|
Client:
Other
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 311.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-07 | HAMPSHIRE TRUST BA 40094687 | HAMPSHIRE TRUST | New loan | 0.0% | GBP 1020.25 | GBP 0.00 | GBP 1020.25 | GBP 9780.15 | |
|
Client:
HAMPSHIRE TRUST
Category:
New loan
VAT %:
0.0%
Net Amount:
GBP 1020.25
VAT Amount:
GBP 0.00
|
|||||||||