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-07-21 | On-Line Banking Bill Payment to Claire Tang Ref: House | Claire Tang | Repairs | 0.0% | GBP 1000.00 | GBP 0.00 | GBP 1000.00 | GBP 3539.15 | |
|
Client:
Claire Tang
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 1000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-23 | Card Payment to DWR Cymru Welsh WA On 22 Jul | DWR Cymru Welsh | Rates & water charges | 0.0% | GBP 17.52 | GBP 0.00 | GBP 17.52 | GBP 3521.63 | |
|
Client:
DWR Cymru Welsh
Category:
Rates & water charges
VAT %:
0.0%
Net Amount:
GBP 17.52
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-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 3253.23 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 268.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-25 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 3273.23 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | Direct Credit From Pay Weekly Carpets Ref: Rent August 25 | Weekly Carpets | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 3773.23 | |
|
Client:
Weekly Carpets
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-04 | Card Payment to Clr*Merthyr.Gov.UK On 01 Aug | Merthyr.Gov.Uk | Rates | 0.0% | GBP 611.00 | GBP 0.00 | GBP 611.00 | GBP 3162.23 | |
|
Client:
Merthyr.Gov.Uk
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 611.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-04 | Commission Charges For The Period 13 Jun /13 Jul | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 3153.73 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-04 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 3173.73 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-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 3901.73 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 728.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-07 | On-Line Banking Bill Payment to Edf Energy Cume Ref: A-95587CD7 | Edf Energy Cume | Light heat | 0.0% | GBP 125.37 | GBP 0.00 | GBP 125.37 | GBP 3776.36 | |
|
Client:
Edf Energy Cume
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 125.37
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-08 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 3796.36 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-11 | On-Line Banking Bill Payment to CT Appliances Ref: 97 Brondeg | CT Appliances | Repairs | 0.0% | GBP 380.00 | GBP 0.00 | GBP 380.00 | GBP 3416.36 | |
|
Client:
CT Appliances
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 380.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-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 4189.86 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 773.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-14 | 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 4836.36 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 646.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-15 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 4856.36 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | Direct Debit to Direct Debit Ref: 5001470603/122375 | Other expense | Other Expenses | 0.0% | GBP 551.65 | GBP 0.00 | GBP 551.65 | GBP 4304.71 | |
|
Client:
Other expense
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 551.65
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | Card Payment to HMRC Gov.UK Cotax On 15 Aug | HMRC Gov.UK Cotax | Corporation Tax | 0.0% | GBP 1000.60 | GBP 0.00 | GBP 1000.60 | GBP 3304.11 | |
|
Client:
HMRC Gov.UK Cotax
Category:
Corporation Tax
VAT %:
0.0%
Net Amount:
GBP 1000.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | On-Line Banking Bill Payment to Kieron Atkins Ref: Tkj Properties Ltd | Kieron Atkins | Repairs & Renewals | 0.0% | GBP 200.00 | GBP 0.00 | GBP 200.00 | GBP 3104.11 | |
|
Client:
Kieron Atkins
Category:
Repairs & Renewals
VAT %:
0.0%
Net Amount:
GBP 200.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-20 | Direct Debit to Shawbrook Bank Ltd Ref: 2021110988 | Shawbrook Bank Ltd | Other Loan 1 | 0.0% | GBP 685.58 | GBP 0.00 | GBP 685.58 | GBP 2418.53 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 685.58
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-26 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 2438.53 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||