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-28 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 6448.76 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-29 | On-Line Banking Bill Payment to Brown + Brown Insu Ref: 543657375 Tkj Prop | Brown Insurance | Insurance | 0.0% | GBP 298.15 | GBP 0.00 | GBP 298.15 | GBP 6150.61 | |
|
Client:
Brown Insurance
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 298.15
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | Direct Credit From Pay Weekly Carpets Ref: Rent May 25 | Weekly Carpets | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 6650.61 | |
|
Client:
Weekly Carpets
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-02 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 6670.61 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-06 | On-Line Banking Bill Payment to Edf Energy Cume Ref: A-95587CD7 | Edf Energy Cume | Light heat | 0.0% | GBP 181.37 | GBP 0.00 | GBP 181.37 | GBP 6489.24 | |
|
Client:
Edf Energy Cume
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 181.37
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-06 | 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 7217.24 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 728.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-08 | Commission Charges For The Period 13 Mar /13 Apr | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 7208.74 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-08 | On-Line Banking Bill Payment to Brown + Brown Insu Ref: 544157510 | Brown Insurance | Insurance | 0.0% | GBP 839.94 | GBP 0.00 | GBP 839.94 | GBP 6368.80 | |
|
Client:
Brown Insurance
Category:
Insurance
VAT %:
0.0%
Net Amount:
GBP 839.94
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-09 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 6388.80 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-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 7035.30 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 646.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-16 | Card Payment to DWR Cymru Welsh WA On 15 May | DWR Cymru Welsh | Rates & water charges | 0.0% | GBP 189.56 | GBP 0.00 | GBP 189.56 | GBP 6845.74 | |
|
Client:
DWR Cymru Welsh
Category:
Rates & water charges
VAT %:
0.0%
Net Amount:
GBP 189.56
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-16 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 6865.74 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-19 | Direct Debit to Direct Debit Ref: 5001470603/122375 This Is A New Direct Debit Payment | Other expense | Other Expenses | 0.0% | GBP 806.77 | GBP 0.00 | GBP 806.77 | GBP 6058.97 | |
|
Client:
Other expense
Category:
Other Expenses
VAT %:
0.0%
Net Amount:
GBP 806.77
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-20 | Direct Debit to Shawbrook Bank Ltd Ref: 2021110988 | Shawbrook Bank Ltd | Other Loan 1 | 0.0% | GBP 708.96 | GBP 0.00 | GBP 708.96 | GBP 5350.01 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 708.96
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-23 | Card Payment to Octopus Energy Ltd On 22 May | Opus Energy Ltd | Light & heat | 0.0% | GBP 32.46 | GBP 0.00 | GBP 32.46 | GBP 5317.55 | |
|
Client:
Opus Energy Ltd
Category:
Light & heat
VAT %:
0.0%
Net Amount:
GBP 32.46
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-23 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 5337.55 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-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 5069.15 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 268.40
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-29 | On-Line Banking Bill Payment to Kieron Atkins Ref: Tkj Properties Ltd | Kieron Atkins | Repairs & Renewals | 0.0% | GBP 2050.00 | GBP 0.00 | GBP 2050.00 | GBP 3019.15 | |
|
Client:
Kieron Atkins
Category:
Repairs & Renewals
VAT %:
0.0%
Net Amount:
GBP 2050.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-30 | On-Line Banking Bill Payment to Andrew Jones Ref: Tkj Properties | Andrew Jones | Repairs | 0.0% | GBP 450.00 | GBP 0.00 | GBP 450.00 | GBP 2569.15 | |
|
Client:
Andrew Jones
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 450.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-30 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 20.00 | GBP 0.00 | GBP 20.00 | GBP 2589.15 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 20.00
VAT Amount:
GBP 0.00
|
|||||||||