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-11-10 | HOSTAWAY SUBSCRIPT CD 8312 | HOSTAWAY SUBSCRIPT | Subscriptions | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 14893.60 | |
|
Client:
HOSTAWAY SUBSCRIPT
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-10 | CJ COTTERELL 600000001662051767 CLEANING 070806 10 10NOV25 18:34 | COTTERELL CLEANING | Cleaning | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 14993.60 | |
|
Client:
COTTERELL CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-10 | PNET5522559-1 PNET5522559-1 | PNET55225591 PNET55225591 | Subscriptions | 0.0% | GBP 27.99 | GBP 0.00 | GBP 27.99 | GBP 15013.60 | |
|
Client:
PNET55225591 PNET55225591
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 27.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-10 | BOOKING.COM BV NO.7UPSLIPDLGXGV0V | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 142.61 | GBP 0.00 | GBP 142.61 | GBP 15041.59 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 142.61
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-10 | CJ COTTERELL 500000001661710159 CLEANING 070806 10 09NOV25 18:42 | COTTERELL CLEANING | Cleaning | 0.0% | GBP 40.00 | GBP 0.00 | GBP 40.00 | GBP 14898.98 | |
|
Client:
COTTERELL CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 40.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-10 | L PRENTICE GUY PRENTICE 400000001666009000 309414 10 08NOV25 14:35 | L PRENTICE GUY | Rent | 0.0% | GBP 833.33 | GBP 0.00 | GBP 833.33 | GBP 14938.98 | |
|
Client:
L PRENTICE GUY
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 833.33
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-11 | ELIZABETH VIRGO 300000001666279446 CLEANING 206055 10 11NOV25 20:27 | ELIZABETH VIRGO | Cleaning | 0.0% | GBP 45.00 | GBP 0.00 | GBP 45.00 | GBP 14968.61 | |
|
Client:
ELIZABETH VIRGO
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 45.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-11 | BOOKING.COM BV NO.IYKFT8YMTPQ9IKX | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.01 | GBP 0.00 | GBP 120.01 | GBP 15013.61 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-12 | ELIZABETH VIRGO 500000001663299432 CLEANING 206055 10 12NOV25 17:40 | ELIZABETH VIRGO | Cleaning | 0.0% | GBP 45.00 | GBP 0.00 | GBP 45.00 | GBP 15467.19 | |
|
Client:
ELIZABETH VIRGO
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 45.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-12 | BOOKING.COM BV NO.FSS3RUUDIIJQMST | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 285.23 | GBP 0.00 | GBP 285.23 | GBP 15512.19 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 285.23
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-12 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 258.35 | GBP 0.00 | GBP 258.35 | GBP 15226.96 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 258.35
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-13 | BOOKING.COM BV NO.N24A6L0ACKJMHVF | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.01 | GBP 0.00 | GBP 120.01 | GBP 15686.09 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-13 | BOOKING.COM BV NO.AF1TP9VSMWKIWMJ | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 98.89 | GBP 0.00 | GBP 98.89 | GBP 15566.08 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 98.89
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-14 | ELIZABETH VIRGO 500000001664666215 CLEANING 206055 10 14NOV25 20:38 | ELIZABETH VIRGO | Cleaning | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 15884.99 | |
|
Client:
ELIZABETH VIRGO
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-14 | BOOKING.COM BV NO.86MYKC4YGKYM81R | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.01 | GBP 0.00 | GBP 120.01 | GBP 15904.99 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-14 | BOOKING.COM BV NO.NO3BFNZARQVMHQR | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 98.89 | GBP 0.00 | GBP 98.89 | GBP 15784.98 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 98.89
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-17 | SMARTESTENERGY BUS 65317-001 | SMARTESTENERGY BUS | Light and heat | 0.0% | GBP 202.72 | GBP 0.00 | GBP 202.72 | GBP 15861.17 | |
|
Client:
SMARTESTENERGY BUS
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 202.72
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-17 | BOOKING.COM BV NO.X6FGHNSGB3U8U9T | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.01 | GBP 0.00 | GBP 120.01 | GBP 16063.89 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-17 | BOOKING.COM BV NO.MMBJVPALMV7CCZY | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 98.89 | GBP 0.00 | GBP 98.89 | GBP 15943.88 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 98.89
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-17 | CJ COTTERELL 600000001664869897 CLEANING 070806 10 15NOV25 18:04 | COTTERELL CLEANING | Cleaning | 0.0% | GBP 40.00 | GBP 0.00 | GBP 40.00 | GBP 15844.99 | |
|
Client:
COTTERELL CLEANING
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 40.00
VAT Amount:
GBP 0.00
|
|||||||||