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-01 | ZEPHRY HOMELOANS ZBR00001/860075608 | zephry homeloans zbr00001/860075608 | Home Loan | 0.0% | GBP 227.00 | GBP 0.00 | GBP 227.00 | GBP 2344.68 | |
|
Client:
zephry homeloans zbr00001/860075608
Category:
Home Loan
VAT %:
0.0%
Net Amount:
GBP 227.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-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 2571.68 | |
|
Client:
edf energy a-b4f04f07-001
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 140.55
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-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 2712.23 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-01 | TV LICENCE MBP 4254618094 | TV LICENCE | Subscriptions | 0.0% | GBP 33.90 | GBP 0.00 | GBP 33.90 | GBP 2772.23 | |
|
Client:
TV LICENCE
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 33.90
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-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 2806.13 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 12.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-01 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 2818.63 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-02 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 134.96 | GBP 0.00 | GBP 134.96 | GBP 2479.64 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 134.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | L PRENTICE GUY PRENTICE 200000001586773537 309414 10 07JUL25 21:11 | L PRENTICE GUY | Rent | 0.0% | GBP 833.33 | GBP 0.00 | GBP 833.33 | GBP 2868.12 | |
|
Client:
L PRENTICE GUY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 833.33
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | L PRENTICE GUY PRENTICE 100000001581488576 309414 10 07JUL25 16:38 | L PRENTICE GUY | Rent | 0.0% | GBP 78.00 | GBP 0.00 | GBP 78.00 | GBP 2034.79 | |
|
Client:
L PRENTICE GUY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 78.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | HAMPSHIRE TRUST BA 40094687 | HAMPSHIRE TRUST | New loan | 0.0% | GBP 1020.25 | GBP 0.00 | GBP 1020.25 | GBP 1956.79 | |
|
Client:
HAMPSHIRE TRUST
Category:
New loan
VAT %:
0.0%
Net Amount:
GBP 1020.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | BOOKING.COM BV NO.PAWYADWQWIVQWBN | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 253.54 | GBP 0.00 | GBP 253.54 | GBP 2977.04 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 253.54
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | BOOKING.COM BV NO.9E1AWOGPFJRCGIA | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 243.86 | GBP 0.00 | GBP 243.86 | GBP 2723.50 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 243.86
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-08 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 2993.44 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-09 | WITCHELL G WITCHELL RP4679964066012700 200384 10 09JUL25 11:48 | WITCHELL G WITCHELL | Rent | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 3023.44 | |
|
Client:
WITCHELL G WITCHELL
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-10 | PNET5522559-1 PNET5522559-1 | PNET55225591 PNET55225591 | Subscriptions | 0.0% | GBP 27.99 | GBP 0.00 | GBP 27.99 | GBP 2995.45 | |
|
Client:
PNET55225591 PNET55225591
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 27.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-14 | BOOKING.COM BV NO.NYZL5BK34IH2ZLX | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 456.38 | GBP 0.00 | GBP 456.38 | GBP 3451.83 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 456.38
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-14 | BOOKING.COM BV NO.AHQHV4DFHJVTDKL | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 636.75 | GBP 0.00 | GBP 636.75 | GBP 4088.58 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 636.75
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-18 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 4213.90 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
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 | Dunelm SoftFurnish CD 2813 | DUNELM SOFTFURNISH | Rent | 0.0% | GBP 113.00 | GBP 0.00 | GBP 113.00 | GBP 5425.37 | |
|
Client:
DUNELM SOFTFURNISH
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 113.00
VAT Amount:
GBP 0.00
|
|||||||||