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-08-19 | SERVICE CHARGES REF : 462317080 | service charges ref : 429929618 | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 10080.75 | |
|
Client:
service charges ref : 429929618
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-19 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 126.28 | GBP 0.00 | GBP 126.28 | GBP 10089.25 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 126.28
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-20 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 10206.07 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | Dunelm F0775 CD 8312 | DUNELM SOFTFURNISH | Rent | 0.0% | GBP 101.50 | GBP 0.00 | GBP 101.50 | GBP 11150.62 | |
|
Client:
DUNELM SOFTFURNISH
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 101.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | ALLAN CL LATE CHECK OUT RP4679961542501700 206815 10 26AUG25 10:26 | ALLAN | Rent | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 11252.12 | |
|
Client:
ALLAN
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | PNET5182871-1 PNET5182871-1 | pnet5182871-1 pnet5182871-1 | Subscriptions | 0.0% | GBP 26.74 | GBP 0.00 | GBP 26.74 | GBP 11222.12 | |
|
Client:
pnet5182871-1 pnet5182871-1
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 26.74
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | BOOKING.COM BV NO.9R62MFOMKW4ASNB | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 922.69 | GBP 0.00 | GBP 922.69 | GBP 11248.86 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 922.69
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | BOOKING.COM BV NO.1X3BPNIXJSHMQUM | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.10 | GBP 0.00 | GBP 120.10 | GBP 10326.17 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.10
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-28 | GORE KF 100000001610335008 CLEANING 535041 10 28AUG25 16:45 | GORE KF CLEANING | Cleaning | 0.0% | GBP 22.00 | GBP 0.00 | GBP 22.00 | GBP 11268.40 | |
|
Client:
GORE KF CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 22.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-28 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 139.78 | GBP 0.00 | GBP 139.78 | GBP 11290.40 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 139.78
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | GORE KF 200000001616327134 CLEANING 535041 10 29AUG25 15:22 | GORE KF CLEANING | Cleaning | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 11363.72 | |
|
Client:
GORE KF CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-29 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 11393.72 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | WICKES HEREFORD CD 8312 | WICKES HEREFORD | Travel expenses | 0.0% | GBP 97.64 | GBP 0.00 | GBP 97.64 | GBP 12109.70 | |
|
Client:
WICKES HEREFORD
Category:
Travel expenses
VAT %:
0.0%
Net Amount:
GBP 97.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | B&M 469 - HS HEREF CD 8312 | unknown | Cleaning | 0.0% | GBP 56.76 | GBP 0.00 | GBP 56.76 | GBP 12207.34 | |
|
Client:
unknown
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 56.76
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | GORE KF 100000001613030880 CLEANING 535041 10 01SEP25 15:36 | GORE KF CLEANING | Cleaning | 0.0% | GBP 23.44 | GBP 0.00 | GBP 23.44 | GBP 12264.10 | |
|
Client:
GORE KF CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 23.44
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | ZEPHRY HOMELOANS ZBR00001/860075608 | zephry homeloans zbr00001/860075608 | Home Loan | 0.0% | GBP 227.00 | GBP 0.00 | GBP 227.00 | GBP 12287.54 | |
|
Client:
zephry homeloans zbr00001/860075608
Category:
Home Loan
VAT %:
0.0%
Net Amount:
GBP 227.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-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 12514.54 | |
|
Client:
edf energy a-b4f04f07-001
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 140.55
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-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 12655.09 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | TV LICENCE MBP 4254618094 | TV LICENCE | Subscriptions | 0.0% | GBP 14.12 | GBP 0.00 | GBP 14.12 | GBP 12715.09 | |
|
Client:
TV LICENCE
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 14.12
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-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 12729.21 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 12.50
VAT Amount:
GBP 0.00
|
|||||||||