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-03-18 | SERVICE CHARGES REF : 450323223 | service charges ref : 429929618 | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 6535.57 | |
|
Client:
service charges ref : 429929618
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-20 | EDF UK CARD PAYMEN CD 8312 | EDF UK PAYMEN | Light and heat | 0.0% | GBP 241.90 | GBP 0.00 | GBP 241.90 | GBP 6293.67 | |
|
Client:
EDF UK PAYMEN
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 241.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-24 | PNET5182871-1 PNET5182871-1 | pnet5182871-1 pnet5182871-1 | Subscriptions | 0.0% | GBP 24.99 | GBP 0.00 | GBP 24.99 | GBP 6944.86 | |
|
Client:
pnet5182871-1 pnet5182871-1
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 24.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-24 | BOOKING.COM BV NO.DREVMYRHTDYTUF6 | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 556.84 | GBP 0.00 | GBP 556.84 | GBP 6969.85 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 556.84
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-24 | BOOKING.COM BV NO.QIS4NENC4NQSCNO | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 119.34 | GBP 0.00 | GBP 119.34 | GBP 6413.01 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 119.34
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-26 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 100.26 | GBP 0.00 | GBP 100.26 | GBP 7045.12 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 100.26
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-27 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 250.64 | GBP 0.00 | GBP 250.64 | GBP 7295.76 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 250.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-31 | NEWTOWN ROAD (HERE | newtown road (here | Property management and service charges | 0.0% | GBP 68.00 | GBP 0.00 | GBP 68.00 | GBP 8119.62 | |
|
Client:
newtown road (here
Category:
Property management and service charges
VAT %:
0.0%
Net Amount:
GBP 68.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-31 | BOOKING.COM BV NO.3ELX8C8BGLAZHKH | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 459.51 | GBP 0.00 | GBP 459.51 | GBP 8187.62 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 459.51
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-31 | BOOKING.COM BV NO.T7VZGRZU3NGYHRX | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 432.35 | GBP 0.00 | GBP 432.35 | GBP 7728.11 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 432.35
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-01 | ZEPHRY HOMELOANS ZBR00001/860075608 | zephry homeloans zbr00001/860075608 | Home Loan | 0.0% | GBP 227.00 | GBP 0.00 | GBP 227.00 | GBP 7732.06 | |
|
Client:
zephry homeloans zbr00001/860075608
Category:
Home Loan
VAT %:
0.0%
Net Amount:
GBP 227.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-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 7959.06 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-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 8019.06 | |
|
Client:
edf energy a-b4f04f07-001
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 54.16
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-01 | TV LICENCE MBP 4254618094 | TV LICENCE | Subscriptions | 0.0% | GBP 33.90 | GBP 0.00 | GBP 33.90 | GBP 8073.22 | |
|
Client:
TV LICENCE
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 33.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-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 8107.12 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 12.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-07 | SWIFT MOTORS HEREF 200000001533540691 T50XXY 308055 10 05APR25 14:04 | swift motors cd 8312 18may24 | Vehicle Running costs | 0.0% | GBP 1063.49 | GBP 0.00 | GBP 1063.49 | GBP 6698.57 | |
|
Client:
swift motors cd 8312 18may24
Category:
Vehicle Running costs
VAT %:
0.0%
Net Amount:
GBP 1063.49
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-07 | S PUGH SASHA 600000001537157894 308082 10 05APR25 09:42 | S PUGH SASHA | Rent | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 7762.06 | |
|
Client:
S PUGH SASHA
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-07 | BOOKING.COM BV NO.HCWV9VCZBOPPP4C | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 432.35 | GBP 0.00 | GBP 432.35 | GBP 7454.46 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 432.35
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-07 | BOOKING.COM BV NO.WOBSPXPE9D9JVND | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 323.54 | GBP 0.00 | GBP 323.54 | GBP 7022.11 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 323.54
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-07 | HAMPSHIRE TRUST BA 40094687 | HAMPSHIRE TRUST | New loan | 0.0% | GBP 1134.64 | GBP 0.00 | GBP 1134.64 | GBP 6319.82 | |
|
Client:
HAMPSHIRE TRUST
Category:
New loan
VAT %:
0.0%
Net Amount:
GBP 1134.64
VAT Amount:
GBP 0.00
|
|||||||||