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-05-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 8720.70 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 12.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | TV LICENCE MBP 4254618094 | TV LICENCE | Subscriptions | 0.0% | GBP 33.90 | GBP 0.00 | GBP 33.90 | GBP 8686.80 | |
|
Client:
TV LICENCE
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 33.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | ZEPHRY HOMELOANS ZBR00001/860075608 | zephry homeloans zbr00001/860075608 | Home Loan | 0.0% | GBP 227.00 | GBP 0.00 | GBP 227.00 | GBP 8345.64 | |
|
Client:
zephry homeloans zbr00001/860075608
Category:
Home Loan
VAT %:
0.0%
Net Amount:
GBP 227.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | 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 8632.64 | |
|
Client:
edf energy a-b4f04f07-001
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 54.16
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-06 | BOOKING.COM BV NO.ZMFI45OA2SZBC8T | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 365.79 | GBP 0.00 | GBP 365.79 | GBP 8831.53 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 365.79
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-06 | S JONES S JONES 100000001545726296 309906 10 06MAY25 09:04 | Other | Other Expenses | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 8861.53 | |
|
Client:
Other
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-06 | BOOKING.COM BV NO.LWBKWRL8TRFMZVN | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.10 | GBP 0.00 | GBP 120.10 | GBP 8465.74 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.10
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-07 | L PRENTICE GUY PRENTICE 500000001555714092 309414 10 07MAY25 16:39 | L PRENTICE GUY | Rent | 0.0% | GBP 833.33 | GBP 0.00 | GBP 833.33 | GBP 8560.22 | |
|
Client:
L PRENTICE GUY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 833.33
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-07 | HAMPSHIRE TRUST BA 40094687 | HAMPSHIRE TRUST | New loan | 0.0% | GBP 1134.64 | GBP 0.00 | GBP 1134.64 | GBP 7726.89 | |
|
Client:
HAMPSHIRE TRUST
Category:
New loan
VAT %:
0.0%
Net Amount:
GBP 1134.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-08 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 8685.54 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-09 | L PRENTICE GUY PRENTICE 300000001559995180 309414 10 09MAY25 07:42 | L PRENTICE GUY | Rent | 0.0% | GBP 380.00 | GBP 0.00 | GBP 380.00 | GBP 9065.54 | |
|
Client:
L PRENTICE GUY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 380.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-12 | BOOKING.COM BV NO.PWF34GTM3HXCIT7 | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 379.34 | GBP 0.00 | GBP 379.34 | GBP 9661.05 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 379.34
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-12 | BOOKING.COM BV NO.GQGQETEYIJJKHNC | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 216.17 | GBP 0.00 | GBP 216.17 | GBP 9281.71 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 216.17
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-13 | Dunelm SoftFurnish CD 2813 | DUNELM SOFTFURNISH | Rent | 0.0% | GBP 200.00 | GBP 0.00 | GBP 200.00 | GBP 9433.06 | |
|
Client:
DUNELM SOFTFURNISH
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 200.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-13 | PNET5522559-1 PNET5522559-1 | PNET55225591 PNET55225591 | Subscriptions | 0.0% | GBP 27.99 | GBP 0.00 | GBP 27.99 | GBP 9633.06 | |
|
Client:
PNET55225591 PNET55225591
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 27.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-19 | BOOKING.COM BV NO.CADI11FOH944TP3 | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 360.29 | GBP 0.00 | GBP 360.29 | GBP 9793.35 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 360.29
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-19 | SERVICE CHARGES REF : 455388933 | service charges ref : 429929618 | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 10732.10 | |
|
Client:
service charges ref : 429929618
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-19 | BOOKING.COM BV NO.EPDNQEE11HR9ICX | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 947.25 | GBP 0.00 | GBP 947.25 | GBP 10740.60 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 947.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-21 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 133.42 | GBP 0.00 | GBP 133.42 | GBP 10990.84 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 133.42
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-21 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 10857.42 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||