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-04-07 | Automated Credit REEDS RAINS CLT 71 REGENT STREET | Reeds Rain | Rental Income | 0.0% | GBP 704.00 | GBP 0.00 | GBP 704.00 | GBP 15967.11 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 704.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-09 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 410.88 | GBP 0.00 | GBP 410.88 | GBP 15556.23 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 410.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-16 | Automated Credit REEDS RAINS CLT 13 ROSEMULLION CLO | Reeds Rain | Rental Income | 0.0% | GBP 660.00 | GBP 0.00 | GBP 660.00 | GBP 16216.23 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-22 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 15879.35 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | Automated Credit JB ESTATES LTD KENILWORTH FP 01/05/25 0256 L27QFQZ00000363742 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 17059.35 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-01 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 01/05/25 30 11024101472021000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 15979.35 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-07 | Automated Credit REEDS RAINS CLT 71 REGENT STREET | Reeds Rain | Rental Income | 0.0% | GBP 704.00 | GBP 0.00 | GBP 704.00 | GBP 16683.35 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 704.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-08 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 569.18 | GBP 0.00 | GBP 569.18 | GBP 16114.17 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 569.18
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-16 | Automated Credit REEDS RAINS CLT 13 ROSEMULLION CLO | Reeds Rain | Rental Income | 0.0% | GBP 660.00 | GBP 0.00 | GBP 660.00 | GBP 16774.17 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-05-20 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 16437.29 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-02 | Automated Credit JB ESTATES LTD KENILWORTH FP 02/06/25 0050 L2WNBI500000361107 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 17617.29 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-02 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 02/06/25 30 15014221241240000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 16537.29 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-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 17241.29 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 704.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-10 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 189.30 | GBP 0.00 | GBP 189.30 | GBP 17051.99 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 189.30
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-16 | Automated Credit REEDS RAINS CLT 13 ROSEMULLION CLO | Reeds Rain | Rental Income | 0.0% | GBP 660.00 | GBP 0.00 | GBP 660.00 | GBP 17711.99 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-06-18 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 17375.11 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-01 | Automated Credit JB ESTATES LTD KENILWORTH FP 01/07/25 0208 L23LYKE00000372439 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 18555.11 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-01 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 01/07/25 30 48024218703166000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 17475.11 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-07 | Automated Credit REEDS RAINS CLT 71 REGENT STREET | Reeds Rain | Rental Income | 0.0% | GBP 704.00 | GBP 0.00 | GBP 704.00 | GBP 18179.11 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 704.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-09 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 379.24 | GBP 0.00 | GBP 379.24 | GBP 17799.87 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 379.24
VAT Amount:
GBP 0.00
|
|||||||||