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-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
|
|||||||||
| 2024-11-25 | Card Payment to Kimpton Flooring L On 22 Nov | Kimpton Flooring L | Repairs | 0.0% | GBP 646.39 | GBP 0.00 | GBP 646.39 | GBP 16332.89 | |
|
Client:
Kimpton Flooring L
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 646.39
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-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 16025.88 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 307.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-27 | On-Line Banking Bill Payment to Andrew Jones Ref: Tkj Properties | Andrew Jones | Repairs | 0.0% | GBP 200.00 | GBP 0.00 | GBP 200.00 | GBP 15825.88 | |
|
Client:
Andrew Jones
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 200.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-27 | Direct Credit From Ram Ltd Clnt Acc Ref: Deposit 36 Yew St | Other | Rental Income | 0.0% | GBP 575.00 | GBP 0.00 | GBP 575.00 | GBP 16400.88 | |
|
Client:
Other
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 575.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-29 | Card Payment to Www.E.Org On 28 Nov | WWW.E.Org | Light heat | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP 16390.88 | |
|
Client:
WWW.E.Org
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-11-29 | Card Payment to Www.E.Org On 28 Nov | WWW.E.Org | Light heat | 0.0% | GBP 15.00 | GBP 0.00 | GBP 15.00 | GBP 16375.88 | |
|
Client:
WWW.E.Org
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 15.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | Card Payment to Www.E.Org On 30 Nov | WWW.E.Org | Light heat | 0.0% | GBP 10.00 | GBP 0.00 | GBP 10.00 | GBP 16365.88 | |
|
Client:
WWW.E.Org
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 10.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | Direct Credit From Pay Weekly Carpets Ref: Rent December 24 | Weekly Carpets | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 17065.88 | |
|
Client:
Weekly Carpets
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-02 | Direct Credit From M Sullivan Ref: Carl | M Sullivan | Rental Income | 0.0% | GBP 200.00 | GBP 0.00 | GBP 200.00 | GBP 16565.88 | |
|
Client:
M Sullivan
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 200.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-04 | On-Line Banking Bill Payment to N A Thomas Ref: Yew St Paint | NA Thomas | Repairs | 0.0% | GBP 800.00 | GBP 0.00 | GBP 800.00 | GBP 16265.88 | |
|
Client:
NA Thomas
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 800.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-05 | Commission Charges For The Period 14 Oct /12 Nov | Commission Charges | Bank Charges | 0.0% | GBP 8.50 | GBP 0.00 | GBP 8.50 | GBP 16257.38 | |
|
Client:
Commission Charges
Category:
Bank Charges
VAT %:
0.0%
Net Amount:
GBP 8.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-13 | On-Line Banking Bill Payment to N A Thomas Ref: Brynglas Paint | NA Thomas | Repairs | 0.0% | GBP 450.00 | GBP 0.00 | GBP 450.00 | GBP 15807.38 | |
|
Client:
NA Thomas
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 450.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-13 | Card Payment to E.On Next On 16 Dec | E.on next | Light heat | 0.0% | GBP 157.28 | GBP 0.00 | GBP 157.28 | GBP 15650.10 | |
|
Client:
E.on next
Category:
Light heat
VAT %:
0.0%
Net Amount:
GBP 157.28
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-19 | On-Line Banking Bill Payment to Andrew Jones Ref: Tkj Properties | Andrew Jones | Repairs | 0.0% | GBP 280.00 | GBP 0.00 | GBP 280.00 | GBP 15370.10 | |
|
Client:
Andrew Jones
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 280.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-19 | On-Line Banking Bill Payment to Claire Tang Ref: House | Claire Tang | Repairs | 0.0% | GBP 2000.00 | GBP 0.00 | GBP 2000.00 | GBP 13370.10 | |
|
Client:
Claire Tang
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 2000.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-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 12569.26 | |
|
Client:
Shawbrook Bank Ltd
Category:
Other Loan 1
VAT %:
0.0%
Net Amount:
GBP 800.84
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-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 12262.25 | |
|
Client:
TMW
Category:
Other loan 2
VAT %:
0.0%
Net Amount:
GBP 307.01
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-30 | Direct Credit From Pay Weekly Carpets Ref: Rent January 25 | Weekly Carpets | Rental Income | 0.0% | GBP 500.00 | GBP 0.00 | GBP 500.00 | GBP 9666.15 | |
|
Client:
Weekly Carpets
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 500.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2024-12-30 | Card Payment to Magnet Limited On 27 Dec | Magnet Limited | Repairs | 0.0% | GBP 3096.10 | GBP 0.00 | GBP 3096.10 | GBP 9166.15 | |
|
Client:
Magnet Limited
Category:
Repairs
VAT %:
0.0%
Net Amount:
GBP 3096.10
VAT Amount:
GBP 0.00
|
|||||||||