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-06-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 6384.47 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 268.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-27 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 6404.47 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-30 | Card Payment to DWR Cymru Welsh WA On 27 Jun | DWR Cymru Welsh | Rates & water charges | 0.0% | GBP 151.27 | GBP 0.00 | GBP 151.27 | GBP 6253.20 | |
|
Client:
DWR Cymru Welsh
Category:
Rates & water charges
VAT %:
0.0%
Net Amount:
GBP 151.27
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-01 | Direct Credit From Pay Weekly Carpets Ref: Rent July 25 | Weekly Carpets | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 6753.20 | |
|
Client:
Weekly Carpets
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-03 | Card Payment to Clr*Merthyr.Gov.UK On 02 Jul | Merthyr.Gov.Uk | Rates | 0.0% | GBP 611.00 | GBP 0.00 | GBP 611.00 | GBP 6142.20 | |
|
Client:
Merthyr.Gov.Uk
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 611.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-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 6870.20 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 728.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | Commission Charges For The Period 13 May /12 Jun | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 6861.70 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 6881.70 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-08 | Card Payment to Restaurante Miso Spain EUR 83.25 On 07 Jul at VISA Exchange Rate 1.16 The Final GBP Amount Includes A Non-Sterling Transaction Fee of 1.98 | Restaurante Miso | Travel | 0.0% | GBP 73.96 | GBP 0.00 | GBP 73.96 | GBP 6807.74 | |
|
Client:
Restaurante Miso
Category:
Travel
VAT %:
0.0%
Net Amount:
GBP 73.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-11 | Card Payment to Octopus Energy Ltd On 10 Jul | Opus Energy Ltd | Light & heat | 0.0% | GBP 52.63 | GBP 0.00 | GBP 52.63 | GBP 6755.11 | |
|
Client:
Opus Energy Ltd
Category:
Light & heat
VAT %:
0.0%
Net Amount:
GBP 52.63
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-11 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 6775.11 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-11 | Direct Credit From Payprop Client Acc Ref: 97 Brondeg Rent | Paypro | Rental Income | 0.0% | GBP 437.50 | GBP 0.00 | GBP 437.50 | GBP 7212.61 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 437.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-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 7859.11 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 646.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-15 | On-Line Banking Bill Payment to Edf Energy Cume Ref: A-95587CD7 | Edf Energy Cume | Light heat | 0.0% | GBP 153.70 | GBP 0.00 | GBP 153.70 | GBP 7705.41 | |
|
Client:
Edf Energy Cume
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 153.70
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-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 7153.76 | |
|
Client:
Other expense
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 551.65
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-17 | On-Line Banking Bill Payment to Cooper Healey Mert Ref: Tkj Properties | Cooper Healey | Accountancy | 0.0% | GBP 942.00 | GBP 0.00 | GBP 942.00 | GBP 6211.76 | |
|
Client:
Cooper Healey
Category:
Accountancy
VAT %:
0.0%
Net Amount:
GBP 942.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-18 | Card Payment to HMRC Gov.UK Cotax On 17 Jul | HMRC Gov.UK Cotax | Corporation Tax | 0.0% | GBP 1000.60 | GBP 0.00 | GBP 1000.60 | GBP 5211.16 | |
|
Client:
HMRC Gov.UK Cotax
Category:
Corporation Tax
VAT %:
0.0%
Net Amount:
GBP 1000.60
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-18 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 5231.16 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-21 | 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 4545.58 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 685.58
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-21 | Card Payment to Octopus Energy Ltd On 18 Jul | Opus Energy Ltd | Light & heat | 0.0% | GBP 6.43 | GBP 0.00 | GBP 6.43 | GBP 4539.15 | |
|
Client:
Opus Energy Ltd
Category:
Light & heat
VAT %:
0.0%
Net Amount:
GBP 6.43
VAT Amount:
GBP 0.00
|
|||||||||