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-04-08 | L PRENTICE GUY PRENTICE 100000001529709659 309414 10 08APR25 03:45 | L PRENTICE GUY | Rent | 0.0% | GBP 933.33 | GBP 0.00 | GBP 933.33 | GBP 7253.15 | |
|
Client:
L PRENTICE GUY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 933.33
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-10 | PNET5522559-1 PNET5522559-1 | PNET55225591 PNET55225591 | Subscriptions | 0.0% | GBP 27.99 | GBP 0.00 | GBP 27.99 | GBP 7225.16 | |
|
Client:
PNET55225591 PNET55225591
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 27.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-14 | BOOKING.COM BV NO.Y53YLUUJ87WEFJN | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 352.97 | GBP 0.00 | GBP 352.97 | GBP 7806.32 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 352.97
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-14 | BOOKING.COM BV NO.6HAUDHGGK6ISNBS | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 228.19 | GBP 0.00 | GBP 228.19 | GBP 7453.35 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 228.19
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-16 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 7931.64 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-17 | L PRENTICE GUY PRENTICE 600000001543909364 309414 10 17APR25 15:10 | L PRENTICE GUY | Rent | 0.0% | GBP 104.50 | GBP 0.00 | GBP 104.50 | GBP 8036.14 | |
|
Client:
L PRENTICE GUY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 104.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-22 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 375.96 | GBP 0.00 | GBP 375.96 | GBP 8412.10 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 375.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-22 | SERVICE CHARGES REF : 452758550 | service charges ref : 429929618 | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 8403.60 | |
|
Client:
service charges ref : 429929618
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-22 | B&M 469 - HS HEREF CD 8312 | unknown | Cleaning | 0.0% | GBP 56.45 | GBP 0.00 | GBP 56.45 | GBP 8341.01 | |
|
Client:
unknown
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 56.45
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-22 | HOME BARGAINS CD 8312 | HOME BARGAINS | Travel expenses | 0.0% | GBP 6.14 | GBP 0.00 | GBP 6.14 | GBP 8397.46 | |
|
Client:
HOME BARGAINS
Category:
Travel expenses
VAT %:
0.0%
Net Amount:
GBP 6.14
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-23 | B&M 469 - HS HEREF CD 8312 | unknown | Cleaning | 0.0% | GBP 36.04 | GBP 0.00 | GBP 36.04 | GBP 8803.29 | |
|
Client:
unknown
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 36.04
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-23 | BOOKING.COM BV NO.PPKGHSMJIBZ6TUS | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 258.12 | GBP 0.00 | GBP 258.12 | GBP 8839.33 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 258.12
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-23 | BOOKING.COM BV NO.BLAKTAKPPMBYLLM | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 240.20 | GBP 0.00 | GBP 240.20 | GBP 8581.21 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 240.20
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-24 | THE HEREFORDSHIRE 300000001551024562 1 BALLARD 162120 10 24APR25 15:41 | the herefordshire 600000001344421669 1 ballard 162120 10 08may24 16:46 | Rates | 0.0% | GBP 425.35 | GBP 0.00 | GBP 425.35 | GBP 8377.94 | |
|
Client:
the herefordshire 600000001344421669 1 ballard 162120 10 08may24 16:46
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 425.35
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-28 | BOOKING.COM BV NO.BB8AS2IU6FLFNEK | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 133.44 | GBP 0.00 | GBP 133.44 | GBP 7974.43 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 133.44
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-28 | HEREFORDSHIRE COUN CD 8312 26APR25 | Council | Rates | 0.0% | GBP 536.95 | GBP 0.00 | GBP 536.95 | GBP 7840.99 | |
|
Client:
Council
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 536.95
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-28 | BOOKING.COM BV NO.GVUMLJXHDNPJ7DK | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 853.51 | GBP 0.00 | GBP 853.51 | GBP 8827.94 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 853.51
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-29 | PNET5182871-1 PNET5182871-1 | pnet5182871-1 pnet5182871-1 | Subscriptions | 0.0% | GBP 26.74 | GBP 0.00 | GBP 26.74 | GBP 8801.20 | |
|
Client:
pnet5182871-1 pnet5182871-1
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 26.74
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-30 | NEWTOWN ROAD (HERE | newtown road (here | Property management and service charges | 0.0% | GBP 68.00 | GBP 0.00 | GBP 68.00 | GBP 8733.20 | |
|
Client:
newtown road (here
Category:
Property management and service charges
VAT %:
0.0%
Net Amount:
GBP 68.00
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
|
|||||||||