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-01-02 | Automated Credit JB ESTATES LTD KENILWORTH FP 02/01/25 0104 L2PBEUS00000508011 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 14236.89 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-02 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 02/01/25 30 55014113975558000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 13156.89 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-06 | Automated Credit REEDS RAINS CLT 71 REGENT STREET | Reeds Rain | Rental Income | 0.0% | GBP 704.00 | GBP 0.00 | GBP 704.00 | GBP 13860.89 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 704.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-08 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 410.88 | GBP 0.00 | GBP 410.88 | GBP 13450.01 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 410.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-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 14110.01 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-01-20 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 13773.13 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-03 | Automated Credit JB ESTATES LTD KENILWORTH FP 03/02/25 0059 L2M6AQ200000527303 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 14953.13 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-03 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 03/02/25 30 03014228928993000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 13873.13 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-05 | Automated Credit REEDS RAINS CLT 71 REGENT STREET | Reeds Rain | Rental Income | 0.0% | GBP 661.50 | GBP 0.00 | GBP 661.50 | GBP 14534.63 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 661.50
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-10 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 410.88 | GBP 0.00 | GBP 410.88 | GBP 14123.75 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 410.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-17 | Automated Credit REEDS RAINS CLT 13 ROSEMULLION CLO | Reeds Rain | Rental Income | 0.0% | GBP 660.00 | GBP 0.00 | GBP 660.00 | GBP 14783.75 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-02-19 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 14446.87 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-03 | Automated Credit JB ESTATES LTD KENILWORTH FP 03/03/25 0058 L2M6AQ200001239896 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 15626.87 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-03 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 03/03/25 30 11014153392627000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 14546.87 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-10 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 410.88 | GBP 0.00 | GBP 410.88 | GBP 14135.99 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 410.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-11 | Automated Credit REEDS RAINS CLT 71 REGENT STREET | Reeds Rain | Rental Income | 0.0% | GBP 704.00 | GBP 0.00 | GBP 704.00 | GBP 14839.99 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 704.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-17 | Automated Credit REEDS RAINS CLT 13 ROSEMULLION CLO | Reeds Rain | Rental Income | 0.0% | GBP 660.00 | GBP 0.00 | GBP 660.00 | GBP 15499.99 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-03-19 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 15163.11 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-01 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 01/04/25 30 38024425387625000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 15263.11 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-04-01 | Automated Credit JB ESTATES LTD KENILWORTH FP 01/04/25 0233 L2M6AQ200001966277 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 16343.11 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||