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-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 7208.39 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | TV LICENCE MBP 4254618094 | TV LICENCE | Subscriptions | 0.0% | GBP 14.18 | GBP 0.00 | GBP 14.18 | GBP 7268.39 | |
|
Client:
TV LICENCE
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 14.18
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-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 7282.57 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 12.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-04 | A FRANKS A FRANKS 11/12 AUG 600000001606413319 309218 10 04AUG25 19:30 | A FRANKS | Rent | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 7654.80 | |
|
Client:
A FRANKS
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-04 | BOOKING.COM BV NO.STT4ZCLQEZGHPZC | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 773.96 | GBP 0.00 | GBP 773.96 | GBP 7554.80 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 773.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-04 | GORE KF 600000001605706954 CLEANING 535041 10 03AUG25 15:10 | GORE KF CLEANING | Cleaning | 0.0% | GBP 60.00 | GBP 0.00 | GBP 60.00 | GBP 6780.84 | |
|
Client:
GORE KF CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-06 | GORE KF 600000001607477583 CLEANING 535041 10 06AUG25 18:39 | GORE KF CLEANING | Cleaning | 0.0% | GBP 27.00 | GBP 0.00 | GBP 27.00 | GBP 7627.80 | |
|
Client:
GORE KF CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 27.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-07 | HAMPSHIRE TRUST BA 40094687 | HAMPSHIRE TRUST | New loan | 0.0% | GBP 1020.25 | GBP 0.00 | GBP 1020.25 | GBP 6732.87 | |
|
Client:
HAMPSHIRE TRUST
Category:
New loan
VAT %:
0.0%
Net Amount:
GBP 1020.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-07 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 7753.12 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-08 | L PRENTICE GUY PRENTICE 400000001613260116 309414 10 08AUG25 04:23 | L PRENTICE GUY | Rent | 0.0% | GBP 833.33 | GBP 0.00 | GBP 833.33 | GBP 7566.20 | |
|
Client:
L PRENTICE GUY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 833.33
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | PNET5522559-1 PNET5522559-1 | PNET55225591 PNET55225591 | Subscriptions | 0.0% | GBP 27.99 | GBP 0.00 | GBP 27.99 | GBP 8532.92 | |
|
Client:
PNET55225591 PNET55225591
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 27.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | BOOKING.COM BV NO.4UFLYXQI8LVTMOP | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 921.27 | GBP 0.00 | GBP 921.27 | GBP 8560.91 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 921.27
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | BOOKING.COM BV NO.EGQ0TIOIDXQBLZJ | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 133.44 | GBP 0.00 | GBP 133.44 | GBP 7639.64 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 133.44
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | TAIA ARTHUR 600000001609433333 CLEANING 608371 10 10AUG25 12:34 | Other | Other Expenses | 0.0% | GBP 60.00 | GBP 0.00 | GBP 60.00 | GBP 7506.20 | |
|
Client:
Other
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-14 | CHILD I 6/9/25 35093121517057000N 515014 10 14AUG25 09:31 | CHILD I | Other Income | 0.0% | GBP 30.00 | GBP 0.00 | GBP 30.00 | GBP 8562.92 | |
|
Client:
CHILD I
Category:
Other Income
VAT %:
0.0%
Net Amount:
GBP 30.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-15 | GORE KF 200000001608477181 CLEANING 535041 10 15AUG25 14:41 | GORE KF CLEANING | Cleaning | 0.0% | GBP 60.00 | GBP 0.00 | GBP 60.00 | GBP 8599.32 | |
|
Client:
GORE KF CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 60.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-15 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 96.40 | GBP 0.00 | GBP 96.40 | GBP 8659.32 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 96.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | BOOKING.COM BV NO.ELJX441UF5EWKMI | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 988.29 | GBP 0.00 | GBP 988.29 | GBP 9962.97 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 988.29
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | BOOKING.COM BV NO.6VV4G4PBO34DIQO | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 456.36 | GBP 0.00 | GBP 456.36 | GBP 8974.68 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 456.36
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | GORE KF 600000001613211118 CLEANING 535041 10 17AUG25 15:26 | GORE KF CLEANING | Cleaning | 0.0% | GBP 81.00 | GBP 0.00 | GBP 81.00 | GBP 8518.32 | |
|
Client:
GORE KF CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 81.00
VAT Amount:
GBP 0.00
|
|||||||||