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-06-10 | PNET5522559-1 PNET5522559-1 | PNET55225591 PNET55225591 | Subscriptions | 0.0% | GBP 27.99 | GBP 0.00 | GBP 27.99 | GBP 13388.88 | |
|
Client:
PNET55225591 PNET55225591
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 27.99
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-11 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 250.64 | GBP 0.00 | GBP 250.64 | GBP 13764.84 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 250.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-11 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 13514.20 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-16 | BOOKING.COM BV NO.I2IHY9RFA4KANIB | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 1110.24 | GBP 0.00 | GBP 1110.24 | GBP 15223.37 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 1110.24
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-16 | BOOKING.COM BV NO.KALTMHI6RZQV04M | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 348.29 | GBP 0.00 | GBP 348.29 | GBP 14113.13 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 348.29
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-17 | SERVICE CHARGES REF : 457586042 | service charges ref : 429929618 | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 15590.83 | |
|
Client:
service charges ref : 429929618
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-17 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 375.96 | GBP 0.00 | GBP 375.96 | GBP 15599.33 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 375.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-18 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 333.54 | GBP 0.00 | GBP 333.54 | GBP 16175.01 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 333.54
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-18 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 250.64 | GBP 0.00 | GBP 250.64 | GBP 15841.47 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 250.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-23 | BOOKING.COM BV NO.VJBEFUQSKAXEQHV | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 120.10 | GBP 0.00 | GBP 120.10 | GBP 16295.11 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 120.10
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-23 | BOOKING.COM BV NO.YB35JQ8RGFRNMWG | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 508.40 | GBP 0.00 | GBP 508.40 | GBP 16803.51 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 508.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-24 | HAMPSHIRE TRUST BA 500000001582748714 40094687/OP 203105 10 24JUN25 23:13 | HAMPSHIRE TRUST | New loan | 0.0% | GBP 15300.00 | GBP 0.00 | GBP 15300.00 | GBP 1727.41 | |
|
Client:
HAMPSHIRE TRUST
Category:
New loan
VAT %:
0.0%
Net Amount:
GBP 15300.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-24 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 250.64 | GBP 0.00 | GBP 250.64 | GBP 17054.15 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 250.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-24 | PNET5182871-1 PNET5182871-1 | pnet5182871-1 pnet5182871-1 | Subscriptions | 0.0% | GBP 26.74 | GBP 0.00 | GBP 26.74 | GBP 17027.41 | |
|
Client:
pnet5182871-1 pnet5182871-1
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 26.74
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-25 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 166.77 | GBP 0.00 | GBP 166.77 | GBP 2144.82 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 166.77
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-25 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 1978.05 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-25 | CITIBANK IRE FIN S AIRBNB PAYMENTS UK | CITIBANK IRE | Rent | 0.0% | GBP 125.32 | GBP 0.00 | GBP 125.32 | GBP 1852.73 | |
|
Client:
CITIBANK IRE
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 125.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-30 | BOOKING.COM BV NO.L4CQADBRPZ3EZAS | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 508.40 | GBP 0.00 | GBP 508.40 | GBP 2761.31 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 508.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-30 | BOOKING.COM BV NO.WJ9S9ICWZ50FHAW | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 108.09 | GBP 0.00 | GBP 108.09 | GBP 2252.91 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 108.09
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-30 | NEWTOWN ROAD (HERE | newtown road (here | Property management and service charges | 0.0% | GBP 68.00 | GBP 0.00 | GBP 68.00 | GBP 2693.31 | |
|
Client:
newtown road (here
Category:
Property management and service charges
VAT %:
0.0%
Net Amount:
GBP 68.00
VAT Amount:
GBP 0.00
|
|||||||||