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-07-21 | BOOKING.COM BV NO.JGWQU1REHJBWPLV | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 949.79 | GBP 0.00 | GBP 949.79 | GBP 5546.87 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 949.79
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-21 | BOOKING.COM BV NO.TTOPKIIYF4KXFKA | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 216.18 | GBP 0.00 | GBP 216.18 | GBP 4597.08 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 216.18
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-21 | S JONES BOOKING FOR 26TH 100000001588091735 308034 10 19JUL25 16:32 | S JONES BOOKING | Rent | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 4380.90 | |
|
Client:
S JONES BOOKING
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-21 | L PRENTICE GUY PRENTICE 500000001597075530 309414 10 19JUL25 09:42 | L PRENTICE GUY | Rent | 0.0% | GBP 67.00 | GBP 0.00 | GBP 67.00 | GBP 4280.90 | |
|
Client:
L PRENTICE GUY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 67.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-22 | HOME BARGAINS CD 8312 | HOME BARGAINS | Travel expenses | 0.0% | GBP 70.98 | GBP 0.00 | GBP 70.98 | GBP 5461.48 | |
|
Client:
HOME BARGAINS
Category:
Travel expenses
VAT %:
0.0%
Net Amount:
GBP 70.98
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-22 | B&M 469 - HS HEREF CD 8312 | unknown | Cleaning | 0.0% | GBP 18.23 | GBP 0.00 | GBP 18.23 | GBP 5532.46 | |
|
Client:
unknown
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 18.23
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-22 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 5550.69 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-23 | Dunelm SoftFurnish CD 2813 | DUNELM SOFTFURNISH | Rent | 0.0% | GBP 81.00 | GBP 0.00 | GBP 81.00 | GBP 5851.44 | |
|
Client:
DUNELM SOFTFURNISH
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 81.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-23 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 254.50 | GBP 0.00 | GBP 254.50 | GBP 5770.44 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 254.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-23 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 54.46 | GBP 0.00 | GBP 54.46 | GBP 5515.94 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 54.46
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-24 | AMAZON* RS3A98MN4 CD 8312 | amazon* 187589cp5 cd 8312 | Repairs and maintenance | 0.0% | GBP 86.47 | GBP 0.00 | GBP 86.47 | GBP 5738.23 | |
|
Client:
amazon* 187589cp5 cd 8312
Category:
Repairs and maintenance
VAT %:
0.0%
Net Amount:
GBP 86.47
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-24 | PNET5182871-1 PNET5182871-1 | pnet5182871-1 pnet5182871-1 | Subscriptions | 0.0% | GBP 26.74 | GBP 0.00 | GBP 26.74 | GBP 5824.70 | |
|
Client:
pnet5182871-1 pnet5182871-1
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 26.74
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-28 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 667.09 | GBP 0.00 | GBP 667.09 | GBP 7244.75 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 667.09
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-28 | BOOKING.COM BV NO.OZ9W1WQAOGJVQ6Q | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 603.25 | GBP 0.00 | GBP 603.25 | GBP 6577.66 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 603.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-28 | BOOKING.COM BV NO.UJL5YW6BFIXNMFP | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 216.18 | GBP 0.00 | GBP 216.18 | GBP 5974.41 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 216.18
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-28 | JONATHAN EDWARD D LATE CHECK OUT FEE RD182Y3YYL460N4Y60 608371 10 26JUL25 11:51 | JONATHAN EDWARD | Rent | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 5758.23 | |
|
Client:
JONATHAN EDWARD
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-29 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 7370.07 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-31 | NEWTOWN ROAD (HERE | newtown road (here | Property management and service charges | 0.0% | GBP 75.00 | GBP 0.00 | GBP 75.00 | GBP 7295.07 | |
|
Client:
newtown road (here
Category:
Property management and service charges
VAT %:
0.0%
Net Amount:
GBP 75.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | ZEPHRY HOMELOANS ZBR00001/860075608 | zephry homeloans zbr00001/860075608 | Home Loan | 0.0% | GBP 227.00 | GBP 0.00 | GBP 227.00 | GBP 6840.84 | |
|
Client:
zephry homeloans zbr00001/860075608
Category:
Home Loan
VAT %:
0.0%
Net Amount:
GBP 227.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | EDF ENERGY A-B4F04F07-001 | edf energy a-b4f04f07-001 | Light and heat | 0.0% | GBP 140.55 | GBP 0.00 | GBP 140.55 | GBP 7067.84 | |
|
Client:
edf energy a-b4f04f07-001
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 140.55
VAT Amount:
GBP 0.00
|
|||||||||