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 |
|---|---|---|---|---|---|---|---|---|---|
| 2024-10-01 | Direct Credit From Pay Weekly Carpets Ref: Rent October 24 | Shawbrook Bank Ltd | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 7987.18 | |
|
Client:
Shawbrook Bank Ltd
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-03 | Direct Credit From Jason Price Ref: Loan | Jason Price | DLA | 0.0% | GBP 10000.00 | GBP 0.00 | GBP 10000.00 | GBP 17987.18 | |
|
Client:
Jason Price
Category:
DLA
VAT %:
0.0%
Net Amount:
GBP 10000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-04 | On-Line Banking Bill Payment to N A Thomas Ref: Brynglas Paint | NA Thomas | Repairs | 0.0% | GBP 390.00 | GBP 0.00 | GBP 390.00 | GBP 17597.18 | |
|
Client:
NA Thomas
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 390.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-07 | Commission Charges For The Period 13 Aug /12 Sep | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 17588.68 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-14 | Direct Credit From Carl Flye Ref: Outstanding Arrear | Other | Rental Income | 0.0% | GBP 200.00 | GBP 0.00 | GBP 200.00 | GBP 17788.68 | |
|
Client:
Other
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 200.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-16 | Card Payment to E.On Next On 15 Oct | E.on next | Light heat | 0.0% | GBP 35.71 | GBP 0.00 | GBP 35.71 | GBP 17752.97 | |
|
Client:
E.on next
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 35.71
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-21 | Direct Debit to Shawbrook Bank Ltd Ref: 2021110988 | Shawbrook Bank Ltd | Other Loan 1 | 0.0% | GBP 820.01 | GBP 0.00 | GBP 820.01 | GBP 16932.96 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 820.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-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 16625.95 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 307.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-10-30 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 200.00 | GBP 0.00 | GBP 200.00 | GBP 16825.95 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 200.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-01 | Direct Credit From Pay Weekly Carpets Ref: Rebt November 24 | Weekly Carpets | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 17325.95 | |
|
Client:
Weekly Carpets
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-04 | Commission Charges For The Period 13 Sep /13 Oct | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 17317.45 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-04 | Direct Credit From Payprop Client Acc Ref: 36 Yew Street | Paypro | Rental Income | 0.0% | GBP 526.70 | GBP 0.00 | GBP 526.70 | GBP 17844.15 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 526.70
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-07 | On-Line Banking Bill Payment to Cooper Healey Mert Ref: Tkj Properties | Cooper Healey | Accountancy | 0.0% | GBP 66.00 | GBP 0.00 | GBP 66.00 | GBP 17778.15 | |
|
Client:
Cooper Healey
Category:
Accountancy
VAT %:
0.0%
Net Amount:
GBP 66.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-12 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 200.00 | GBP 0.00 | GBP 200.00 | GBP 17978.15 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 200.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-13 | Card Payment to E.On Next On 12 Nov | E.on next | Light heat | 0.0% | GBP 29.82 | GBP 0.00 | GBP 29.82 | GBP 17948.33 | |
|
Client:
E.on next
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 29.82
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-13 | Card Payment to DWR Cymru Welsh WA On 12 Nov | DWR Cymru Welsh | Rates & water charges | 0.0% | GBP 197.16 | GBP 0.00 | GBP 197.16 | GBP 17751.17 | |
|
Client:
DWR Cymru Welsh
Category:
Rates & water charges
VAT %:
0.0%
Net Amount:
GBP 197.16
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-15 | Direct Credit From Payprop Client Acc Ref: 36 Yew Street | Paypro | Rental Income | 0.0% | GBP 173.12 | GBP 0.00 | GBP 173.12 | GBP 17924.29 | |
|
Client:
Paypro
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 173.12
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-20 | Direct Debit to Shawbrook Bank Ltd Ref: 2021110988 | Shawbrook Bank Ltd | Other Loan 1 | 0.0% | GBP 820.01 | GBP 0.00 | GBP 820.01 | GBP 17104.28 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 820.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-22 | On-Line Banking Bill Payment to Marta A Sienkiewic Ref: Clean Yew Street | Marta A | Cleaning | 0.0% | GBP 105.00 | GBP 0.00 | GBP 105.00 | GBP 16999.28 | |
|
Client:
Marta A
Category:
Cleaning
VAT %:
0.0%
Net Amount:
GBP 105.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-25 | Card Payment to Www.E.Org On 22 Nov | WWW.E.Org | Light heat | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP 16979.28 | |
|
Client:
WWW.E.Org
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||