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-04-01 | Direct Credit From Pay Weekly Carpets Ref: Rent April 25 | Weekly Carpets | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 1316.54 | |
|
Client:
Weekly Carpets
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-03 | On-Line Banking Bill Payment to Hughes Forest Ltd Ref: Tkj Properties | Hughes Forest Ltd | Repairs | 0.0% | GBP 76.80 | GBP 0.00 | GBP 76.80 | GBP 1239.74 | |
|
Client:
Hughes Forest Ltd
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 76.80
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-04 | Commission Charges For The Period 13 Feb /12 Mar | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 1231.24 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-04 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 1251.24 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-04 | Direct Credit From Payprop Client Acc Ref: Yew St Rent | Paypro | Rental Income | 0.0% | GBP 638.00 | GBP 0.00 | GBP 638.00 | GBP 1889.24 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 638.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-07 | Card Payment to E.On Next On 04 Apr | E.on next | Light heat | 0.0% | GBP 5.92 | GBP 0.00 | GBP 5.92 | GBP 1883.32 | |
|
Client:
E.on next
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 5.92
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-08 | On-Line Banking Bill Payment to Edf Energy Cume Ref: A-95587CD7 | Edf Energy Cume | Light heat | 0.0% | GBP 165.01 | GBP 0.00 | GBP 165.01 | GBP 1718.31 | |
|
Client:
Edf Energy Cume
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 165.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-09 | On-Line Banking Bill Payment to Harding Evans Ref: Tkj/1 | Harding Evans | Legal and professional fees | 0.0% | GBP 87294.36 | GBP 0.00 | GBP 87294.36 | GBP -85576.05 | |
|
Client:
Harding Evans
Category:
Legal and professional fees
VAT %:
0.0%
Net Amount:
GBP 87294.36
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-09 | Internet Banking Transfer From Account 00280356 at 20-56-56 | Other expense | Other Expenses | 0.0% | GBP 41000.00 | GBP 0.00 | GBP 41000.00 | GBP -44576.05 | |
|
Client:
Other expense
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 41000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-09 | Internet Banking Transfer From Account 00640328 at 20-56-56 | Other expense | Other Expenses | 0.0% | GBP 50000.00 | GBP 0.00 | GBP 50000.00 | GBP 5423.95 | |
|
Client:
Other expense
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 50000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-11 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 5443.95 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-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 6090.45 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 646.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-17 | Internet Banking Transfer From Account 00280356 at 20-56-56 Solicitor | Other expense | Other Expenses | 0.0% | GBP 16184.12 | GBP 0.00 | GBP 16184.12 | GBP 22274.57 | |
|
Client:
Other expense
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 16184.12
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-22 | Direct Debit to Shawbrook Bank Ltd Ref: 2021110988 | Shawbrook Bank Ltd | Other Loan 1 | 0.0% | GBP 781.66 | GBP 0.00 | GBP 781.66 | GBP 21492.91 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 781.66
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-22 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 21512.91 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-23 | Card Payment to Clr*Merthyr.Gov.UK On 22 Apr | Merthyr.Gov.Uk | Rates | 0.0% | GBP 607.00 | GBP 0.00 | GBP 607.00 | GBP 20905.91 | |
|
Client:
Merthyr.Gov.Uk
Category:
Rates
VAT %:
0.0%
Net Amount:
GBP 607.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-23 | Card Payment to Tmw Servicing On 22 Apr | TMW | Other loan 2 | 0.0% | GBP 4224.50 | GBP 0.00 | GBP 4224.50 | GBP 16681.41 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 4224.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-23 | Card Payment to Shawbrook Bank Ltd On 22 Apr | Shawbrook Bank Ltd | Other Loan 1 | 0.0% | GBP 9250.64 | GBP 0.00 | GBP 9250.64 | GBP 7430.77 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 9250.64
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-25 | Direct Debit to Tmw R Ref: 18365165/1785929 | TMW | Other loan 2 | 0.0% | GBP 307.01 | GBP 0.00 | GBP 307.01 | GBP 7123.76 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 307.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-25 | On-Line Banking Bill Payment to Mortgage Taylors L Ref: 97 Brondeg | Mortgage Taylors L | Legal and professional fees | 0.0% | GBP 695.00 | GBP 0.00 | GBP 695.00 | GBP 6428.76 | |
|
Client:
Mortgage Taylors L
Category:
Legal and professional fees
VAT %:
0.0%
Net Amount:
GBP 695.00
VAT Amount:
GBP 0.00
|
|||||||||