GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 15 gaps > 7 days: 01/08/2025 to 01/16/2025 (8 days), 01/20/2025 to 02/03/2025 (14 days), 02/19/2025 to 03/03/2025 (12 days), 03/19/2025 to 04/01/2025 (13 days), 04/22/2025 to 05/01/2025 (9 days), 05/08/2025 to 05/16/2025 (8 days), 05/20/2025 to 06/02/2025 (13 days), 06/18/2025 to 07/01/2025 (13 days), 07/18/2025 to 08/01/2025 (14 days), 08/08/2025 to 08/18/2025 (10 days), 08/20/2025 to 09/01/2025 (12 days), 09/18/2025 to 09/30/2025 (12 days), 10/08/2025 to 10/16/2025 (8 days), 10/20/2025 to 11/03/2025 (14 days), 11/19/2025 to 12/01/2025 (12 days)
| Date | Description | Client | Category | VAT % | Net Amount | VAT Amount | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-10-20 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 20101.78 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | Automated Credit JB ESTATES LTD KENILWORTH FP 03/11/25 0058 L2QAKDS00000599011 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 21281.78 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-03 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 03/11/25 30 07014227438234000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 20201.78 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-05 | Automated Credit REEDS RAINS CLT 71 REGENT STREET | Reeds Rain | Rental Income | 0.0% | GBP 704.00 | GBP 0.00 | GBP 704.00 | GBP 20905.78 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 704.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-10 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 379.24 | GBP 0.00 | GBP 379.24 | GBP 20526.54 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 379.24
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-17 | Automated Credit REEDS RAINS CLT 13 ROSEMULLION CLO | Reeds Rain | Rental Income | 0.0% | GBP 550.00 | GBP 0.00 | GBP 550.00 | GBP 21076.54 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 550.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-11-19 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 20739.66 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-01 | Automated Credit JB ESTATES LTD KENILWORTH FP 01/12/25 0102 L2UZV3Y00000446868 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 21919.66 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-01 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 01/12/25 30 36014418543960000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 20839.66 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-08 | Automated Credit REEDS RAINS CLT 71 REGENT STREET | Reeds Rain | Rental Income | 0.0% | GBP 704.00 | GBP 0.00 | GBP 704.00 | GBP 21543.66 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 704.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-10 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 379.24 | GBP 0.00 | GBP 379.24 | GBP 21164.42 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 379.24
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-16 | Automated Credit REEDS RAINS CLT 13 ROSEMULLION CLO | Reeds Rain | Rental Income | 0.0% | GBP 644.00 | GBP 0.00 | GBP 644.00 | GBP 21808.42 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 644.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-12-18 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 21471.54 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||