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-05-30 | Direct Credit From Pay Weekly Carpets Ref: Rebt June 25 | Weekly Carpets | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 3089.15 | |
|
Client:
Weekly Carpets
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-02 | On-Line Banking Bill Payment to Marta A Sienkiewic Ref: 97 Brondeg | Marta A | Repairs | 0.0% | GBP 122.50 | GBP 0.00 | GBP 122.50 | GBP 2966.65 | |
|
Client:
Marta A
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 122.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-03 | On-Line Banking Bill Payment to CT Appliances Ref: 36 Yew Street | CT Appliances | Repairs | 0.0% | GBP 80.00 | GBP 0.00 | GBP 80.00 | GBP 2886.65 | |
|
Client:
CT Appliances
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 80.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-04 | On-Line Banking Bill Payment to N A Thomas Ref: 97 Brondeg Paintin | NA Thomas | Repairs | 0.0% | GBP 1560.00 | GBP 0.00 | GBP 1560.00 | GBP 1326.65 | |
|
Client:
NA Thomas
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 1560.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-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 2054.65 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 728.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-04 | Direct Credit From Price J Ref: Directors Loan | Directs Loan | DLA | 0.0% | GBP 3000.00 | GBP 0.00 | GBP 3000.00 | GBP 5054.65 | |
|
Client:
Directs Loan
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 3000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-05 | Commission Charges For The Period 14 Apr /12 May | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 5046.15 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-05 | On-Line Banking Bill Payment to Edf Energy Cume Ref: A-95587CD7 | Edf Energy Cume | Light heat | 0.0% | GBP 167.63 | GBP 0.00 | GBP 167.63 | GBP 4878.52 | |
|
Client:
Edf Energy Cume
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 167.63
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-06 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 4898.52 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-10 | On-Line Banking Bill Payment to Brown + Brown Insu Ref: 544883203 Tkj Prop | Brown Insurance | Insurance | 0.0% | GBP 631.92 | GBP 0.00 | GBP 631.92 | GBP 4266.60 | |
|
Client:
Brown Insurance
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 631.92
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-13 | On-Line Banking Bill Payment to Kieron Atkins Ref: Tkj Properties Ltd | Kieron Atkins | Repairs & Renewals | 0.0% | GBP 499.00 | GBP 0.00 | GBP 499.00 | GBP 3767.60 | |
|
Client:
Kieron Atkins
Category:
Repairs & Renewals
VAT %:
0.0%
Net Amount:
GBP 499.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-13 | Card Payment to Clr*Merthyr.Gov.UK On 12 Jun | Merthyr.Gov.Uk | Rates | 0.0% | GBP 1222.00 | GBP 0.00 | GBP 1222.00 | GBP 2545.60 | |
|
Client:
Merthyr.Gov.Uk
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 1222.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-13 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 2565.60 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-16 | 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 3212.10 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 646.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-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 2660.45 | |
|
Client:
Other expense
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 551.65
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-17 | On-Line Banking Bill Payment to CT Appliances Ref: 36 Yew Street | CT Appliances | Repairs | 0.0% | GBP 240.00 | GBP 0.00 | GBP 240.00 | GBP 2420.45 | |
|
Client:
CT Appliances
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 240.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-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 1734.87 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 685.58
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-23 | On-Line Banking Bill Payment to Cooper Healey Mert Ref: Tkj Properties | Cooper Healey | Accountancy | 0.0% | GBP 102.00 | GBP 0.00 | GBP 102.00 | GBP 1632.87 | |
|
Client:
Cooper Healey
Category:
Accountancy
VAT %:
0.0%
Net Amount:
GBP 102.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-23 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 1652.87 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-24 | Internet Banking Transfer From Account 00640328 at 20-56-56 Transfer | Other expense | Other Expenses | 0.0% | GBP 5000.00 | GBP 0.00 | GBP 5000.00 | GBP 6652.87 | |
|
Client:
Other expense
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 5000.00
VAT Amount:
GBP 0.00
|
|||||||||