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 |
|---|---|---|---|---|---|---|---|---|---|
| 2024-12-02 | DWR CYMRU WELSH WA 5416805701 | dwr cymru welsh wa 5416805701 | Water Rates | 0.0% | GBP 70.50 | GBP 0.00 | GBP 70.50 | GBP 74494.64 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 70.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | ZEPHRY HOMELOANS ZBR00001/860075608 | zephry homeloans zbr00001/860075608 | Home Loan | 0.0% | GBP 227.00 | GBP 0.00 | GBP 227.00 | GBP 74267.64 | |
|
Client:
zephry homeloans zbr00001/860075608
Category:
Home Loan
VAT %:
0.0%
Net Amount:
GBP 227.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | BOOKING.COM BV NO.UJB8MSQQXIIPN3U | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 121.93 | GBP 0.00 | GBP 121.93 | GBP 74695.14 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 121.93
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | EDF ENERGY A-B4F04F07-001 | edf energy a-b4f04f07-001 | Light and heat | 0.0% | GBP 62.00 | GBP 0.00 | GBP 62.00 | GBP 74565.14 | |
|
Client:
edf energy a-b4f04f07-001
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 62.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | NEWTOWN ROAD (HERE | newtown road (here | Property management and service charges | 0.0% | GBP 68.00 | GBP 0.00 | GBP 68.00 | GBP 74627.14 | |
|
Client:
newtown road (here
Category:
Property management and service charges
VAT %:
0.0%
Net Amount:
GBP 68.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-09 | BOOKING.COM BV NO.RVUXF5770UCWVBR | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 630.33 | GBP 0.00 | GBP 630.33 | GBP 74897.97 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 630.33
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-16 | BOOKING.COM BV NO.T9TU4NEL9HH0UU2 | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 630.33 | GBP 0.00 | GBP 630.33 | GBP 75528.30 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 630.33
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-17 | SERVICE CHARGES REF : 442012229 | service charges ref : 429929618 | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 75519.80 | |
|
Client:
service charges ref : 429929618
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-23 | BOOKING.COM BV NO.KZ34WHFYQXXJDMG | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 365.79 | GBP 0.00 | GBP 365.79 | GBP 75885.59 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 365.79
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-24 | PNET5182871-1 PNET5182871-1 | pnet5182871-1 pnet5182871-1 | Subscriptions | 0.0% | GBP 20.79 | GBP 0.00 | GBP 20.79 | GBP 75864.80 | |
|
Client:
pnet5182871-1 pnet5182871-1
Category:
Subscriptions
VAT %:
0.0%
Net Amount:
GBP 20.79
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-31 | NEWTOWN ROAD (HERE | newtown road (here | Property management and service charges | 0.0% | GBP 68.00 | GBP 0.00 | GBP 68.00 | GBP 76162.59 | |
|
Client:
newtown road (here
Category:
Property management and service charges
VAT %:
0.0%
Net Amount:
GBP 68.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-31 | BOOKING.COM BV NO.XM0ALEB5CIFCBR7 | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 365.79 | GBP 0.00 | GBP 365.79 | GBP 76230.59 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 365.79
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-02 | ZEPHRY HOMELOANS ZBR00001/860075608 | zephry homeloans zbr00001/860075608 | Home Loan | 0.0% | GBP 227.00 | GBP 0.00 | GBP 227.00 | GBP 75803.09 | |
|
Client:
zephry homeloans zbr00001/860075608
Category:
Home Loan
VAT %:
0.0%
Net Amount:
GBP 227.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-02 | DWR CYMRU WELSH WA 5416805701 | dwr cymru welsh wa 5416805701 | Water Rates | 0.0% | GBP 70.50 | GBP 0.00 | GBP 70.50 | GBP 76030.09 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 70.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-02 | EDF ENERGY A-B4F04F07-001 | edf energy a-b4f04f07-001 | Light and heat | 0.0% | GBP 62.00 | GBP 0.00 | GBP 62.00 | GBP 76100.59 | |
|
Client:
edf energy a-b4f04f07-001
Category:
Light and heat
VAT %:
0.0%
Net Amount:
GBP 62.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-06 | BOOKING.COM BV NO.YIDJWO9HVNZB2II | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 250.28 | GBP 0.00 | GBP 250.28 | GBP 76053.37 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 250.28
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-06 | DWR CYMRU WELSH WA DCWW 0104804906 K | dwr cymru welsh wa 5416805701 | Water Rates | 0.0% | GBP 354.66 | GBP 0.00 | GBP 354.66 | GBP 76408.03 | |
|
Client:
dwr cymru welsh wa 5416805701
Category:
Water Rates
VAT %:
0.0%
Net Amount:
GBP 354.66
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-16 | JACKLYN DAWSON 200000001488318029 MP/REU/CMCY3896 309600 10 16JAN25 16:17 | jacklyn dawson 100000001440071391 mp/reu/cmcy3896 309600 10 31oct24 16:37 | Legal & Professional fees | 0.0% | GBP 62500.00 | GBP 0.00 | GBP 62500.00 | GBP 13908.03 | |
|
Client:
jacklyn dawson 100000001440071391 mp/reu/cmcy3896 309600 10 31oct24 16:37
Category:
Legal & Professional fees
VAT %:
0.0%
Net Amount:
GBP 62500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | BOOKING.COM BV NO.B2CEURBD0FIMEZR | booking.com bv no.qzmrfhmfebsyfcb | Rent | 0.0% | GBP 673.83 | GBP 0.00 | GBP 673.83 | GBP 14581.86 | |
|
Client:
booking.com bv no.qzmrfhmfebsyfcb
Category:
Rent
VAT %:
0.0%
Net Amount:
GBP 673.83
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | SERVICE CHARGES REF : 445393530 | service charges ref : 429929618 | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 14573.36 | |
|
Client:
service charges ref : 429929618
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||