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-01-03 | On-Line Banking Bill Payment to Kieron Atkins Ref: Brynglass | Kieron Atkins | Repairs & Renewals | 0.0% | GBP 1190.00 | GBP 0.00 | GBP 1190.00 | GBP 8476.15 | |
|
Client:
Kieron Atkins
Category:
Repairs & Renewals
VAT %:
0.0%
Net Amount:
GBP 1190.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-06 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 100.00 | GBP 0.00 | GBP 100.00 | GBP 8576.15 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 100.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-06 | Direct Credit From Payprop Client Acc Ref: Yew St Rent | Paypro | Rental Income | 0.0% | GBP 368.00 | GBP 0.00 | GBP 368.00 | GBP 8944.15 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 368.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-07 | Card Payment to Panel People/Ancho On 06 Jan | Panel People | Repairs | 0.0% | GBP 180.00 | GBP 0.00 | GBP 180.00 | GBP 8764.15 | |
|
Client:
Panel People
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-08 | Card Payment to Plumbase On 07 Jan | Plumbase | Repairs | 0.0% | GBP 856.50 | GBP 0.00 | GBP 856.50 | GBP 7907.65 | |
|
Client:
Plumbase
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 856.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-09 | Commission Charges For The Period 13 Nov /12 Dec | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 7899.15 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-10 | On-Line Banking Bill Payment to Andrew Jones Ref: Brynglais | Andrew Jones | Repairs | 0.0% | GBP 300.00 | GBP 0.00 | GBP 300.00 | GBP 7599.15 | |
|
Client:
Andrew Jones
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 300.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-14 | Card Payment to E.On Next On 13 Jan | E.on next | Light heat | 0.0% | GBP 191.32 | GBP 0.00 | GBP 191.32 | GBP 7407.83 | |
|
Client:
E.on next
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 191.32
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-14 | On-Line Banking Bill Payment to N A Thomas Ref: Brynglas Paint | NA Thomas | Repairs | 0.0% | GBP 800.00 | GBP 0.00 | GBP 800.00 | GBP 6607.83 | |
|
Client:
NA Thomas
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 800.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | On-Line Banking Bill Payment to Andrew Jones Ref: Brynglais | Andrew Jones | Repairs | 0.0% | GBP 600.00 | GBP 0.00 | GBP 600.00 | GBP 5206.99 | |
|
Client:
Andrew Jones
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 600.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | Direct Debit to Shawbrook Bank Ltd Ref: 2021110988 | Shawbrook Bank Ltd | Other Loan 1 | 0.0% | GBP 800.84 | GBP 0.00 | GBP 800.84 | GBP 5806.99 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 800.84
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-24 | Card Payment to Edf UK Card Paymen On 23 Jan | Edf Energy Cume | Light heat | 0.0% | GBP 161.81 | GBP 0.00 | GBP 161.81 | GBP 5045.18 | |
|
Client:
Edf Energy Cume
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 161.81
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-27 | Direct Debit to Tmw R Ref: 18365165/1785929 | TMW | Other loan 2 | 0.0% | GBP 307.01 | GBP 0.00 | GBP 307.01 | GBP 4738.17 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 307.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-28 | On-Line Banking Bill Payment to Marta A Sienkiewic Ref: Clean Brynglais | Marta A | Cleaning | 0.0% | GBP 131.25 | GBP 0.00 | GBP 131.25 | GBP 4606.92 | |
|
Client:
Marta A
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 131.25
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-31 | Direct Credit From Pay Weekly Carpets Ref: Rent Febuary 25 | Weekly Carpets | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 5106.92 | |
|
Client:
Weekly Carpets
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-03 | Commission Charges For The Period 13 Dec 2024/12 Jan 2025 | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 5098.42 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-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 3460.55 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 728.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-04 | On-Line Banking Bill Payment to Edf Energy Cume Ref: A-95587CD7 | Edf Energy Cume | Light heat | 0.0% | GBP 73.87 | GBP 0.00 | GBP 73.87 | GBP 5024.55 | |
|
Client:
Edf Energy Cume
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 73.87
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-04 | On-Line Banking Bill Payment to Ecp Construction Ref: Bryglas Work | Ecp | Repairs | 0.0% | GBP 2292.00 | GBP 0.00 | GBP 2292.00 | GBP 2732.55 | |
|
Client:
Ecp
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 2292.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-11 | On-Line Banking Bill Payment to Mortgage Taylors L Ref: Tkj Properties Ltd | Mortgage Taylors L | Legal and professional fees | 0.0% | GBP 150.00 | GBP 0.00 | GBP 150.00 | GBP 3310.55 | |
|
Client:
Mortgage Taylors L
Category:
Legal and professional fees
VAT %:
0.0%
Net Amount:
GBP 150.00
VAT Amount:
GBP 0.00
|
|||||||||