GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 1 gap > 7 days: 12/05/2024 to 12/13/2024 (8 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-08-28 | Direct Debit to Tmw R Ref: 18365165/1785929 | TMW | Other loan 2 | 0.0% | GBP 268.40 | GBP 0.00 | GBP 268.40 | GBP 2170.13 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 268.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 2190.13 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | Direct Credit From Pay Weekly Carpets Ref: Rent September | Weekly Carpets | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 2690.13 | |
|
Client:
Weekly Carpets
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-02 | Card Payment to Clr*Www.Merthyr.GO On 01 Sep | Merthyr.Gov.Uk | Rates | 0.0% | GBP 611.00 | GBP 0.00 | GBP 611.00 | GBP 2079.13 | |
|
Client:
Merthyr.Gov.Uk
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 611.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-04 | Direct Credit From Payprop Client Acc Ref: Yew St Rent | Paypro | Rental Income | 0.0% | GBP 728.00 | GBP 0.00 | GBP 728.00 | GBP 2807.13 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 728.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-05 | Commission Charges For The Period 14 Jul /12 Aug | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 2798.63 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-05 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 2818.63 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-08 | Card Payment to SQ *Planet Ice Bri On 06 Sep | Other | DLA | 0.0% | GBP 9.59 | GBP 0.00 | GBP 9.59 | GBP 2809.04 | |
|
Client:
Other
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 9.59
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-09 | On-Line Banking Bill Payment to Edf Energy Cume Ref: A-95587CD7 | Edf Energy Cume | Light heat | 0.0% | GBP 179.04 | GBP 0.00 | GBP 179.04 | GBP 2630.00 | |
|
Client:
Edf Energy Cume
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 179.04
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-11 | Direct Credit From Payprop Client Acc Ref: 97 Brondeg Rent | Paypro | Rental Income | 0.0% | GBP 773.50 | GBP 0.00 | GBP 773.50 | GBP 3403.50 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 773.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-12 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 3423.50 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-15 | Direct Credit From Payprop Client Acc Ref: 27 Brynglas Rent | Paypro | Rental Income | 0.0% | GBP 646.50 | GBP 0.00 | GBP 646.50 | GBP 4070.00 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 646.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-16 | Card Payment to HMRC Gov.UK Cotax On 15 Sep | HMRC Gov.UK Cotax | Corporation Tax | 0.0% | GBP 1000.60 | GBP 0.00 | GBP 1000.60 | GBP 3069.40 | |
|
Client:
HMRC Gov.UK Cotax
Category:
Corporation Tax
VAT %:
0.0%
Net Amount:
GBP 1000.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-17 | Direct Debit to Direct Debit Ref: 5001470603/122375 | Other expense | Other Expenses | 0.0% | GBP 551.65 | GBP 0.00 | GBP 551.65 | GBP 2517.75 | |
|
Client:
Other expense
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 551.65
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-19 | On-Line Banking Bill Payment to Kieron Atkins Ref: Tkj Properties Ltd | Kieron Atkins | Repairs & Renewals | 0.0% | GBP 40.00 | GBP 0.00 | GBP 40.00 | GBP 2477.75 | |
|
Client:
Kieron Atkins
Category:
Repairs & Renewals
VAT %:
0.0%
Net Amount:
GBP 40.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-19 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 2497.75 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-22 | Direct Debit to Shawbrook Bank Ltd Ref: 2021110988 | Shawbrook Bank Ltd | Other Loan 1 | 0.0% | GBP 668.32 | GBP 0.00 | GBP 668.32 | GBP 1829.43 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 668.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-25 | Direct Debit to Tmw R Ref: 18365165/1785929 | TMW | Other loan 2 | 0.0% | GBP 268.40 | GBP 0.00 | GBP 268.40 | GBP 1561.03 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 268.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-26 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 1581.03 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||