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-07-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 18459.87 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-07-18 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 18122.99 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | Automated Credit JB ESTATES LTD KENILWORTH FP 01/08/25 0233 L2L6EXZ00000057506 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 19302.99 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-01 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 01/08/25 30 61024430870011000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 18222.99 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-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 18926.99 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 704.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-08 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 379.24 | GBP 0.00 | GBP 379.24 | GBP 18547.75 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 379.24
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-18 | Automated Credit REEDS RAINS CLT 13 ROSEMULLION CLO | Reeds Rain | Rental Income | 0.0% | GBP 660.00 | GBP 0.00 | GBP 660.00 | GBP 19207.75 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-08-20 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 18870.87 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | Automated Credit JB ESTATES LTD KENILWORTH FP 01/09/25 0056 L2L6EXZ00000768396 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 20050.87 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-01 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 01/09/25 30 50014227487588000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 18970.87 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-05 | Automated Credit REEDS RAINS CLT 71 REGENT STREET | Reeds Rain | Rental Income | 0.0% | GBP 594.00 | GBP 0.00 | GBP 594.00 | GBP 19564.87 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 594.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-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 19185.63 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 379.24
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-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 19845.63 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-18 | Direct Debit TMW DDR 19749806/2039194 | TMW 9194 | Loan interest- -ROSEMULLION | 0.0% | GBP 336.88 | GBP 0.00 | GBP 336.88 | GBP 19508.75 | |
|
Client:
TMW 9194
Category:
Loan interest- -ROSEMULLION
VAT %:
0.0%
Net Amount:
GBP 336.88
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-09-30 | OnLine Transaction HMRC SHIPLEY 9815226551A00113A VIA MOBILE - PYMT FP 30/09/25 10 21172824516162000N | HMRC | CT payment | 0.0% | GBP 154.85 | GBP 0.00 | GBP 154.85 | GBP 19353.90 | |
|
Client:
HMRC
Category:
CT payment
VAT %:
0.0%
Net Amount:
GBP 154.85
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-01 | Automated Credit JB ESTATES LTD KENILWORTH FP 01/10/25 0156 L2OGNZJ00000503897 | JB Estate | Intercompany | 0.0% | GBP 1180.00 | GBP 0.00 | GBP 1180.00 | GBP 20533.90 | |
|
Client:
JB Estate
Category:
Intercompany
VAT %:
0.0%
Net Amount:
GBP 1180.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-01 | Standing Order WHITEROCK CAPITAL REEDS RAINS FP 01/10/25 30 52024202896247000N | WHITEROCK CAPITAL | Commissions payable | 0.0% | GBP 1080.00 | GBP 0.00 | GBP 1080.00 | GBP 19453.90 | |
|
Client:
WHITEROCK CAPITAL
Category:
Commissions payable
VAT %:
0.0%
Net Amount:
GBP 1080.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-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 20157.90 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 704.00
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-08 | Direct Debit TMW DDR 18283874/1771321 | TMW 1321 | Loan interest- Regent Street | 0.0% | GBP 379.24 | GBP 0.00 | GBP 379.24 | GBP 19778.66 | |
|
Client:
TMW 1321
Category:
Loan interest- Regent Street
VAT %:
0.0%
Net Amount:
GBP 379.24
VAT Amount:
GBP 0.00
|
|||||||||
| 2025-10-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 20438.66 | |
|
Client:
Reeds Rain
Category:
Rental Income
VAT %:
0.0%
Net Amount:
GBP 660.00
VAT Amount:
GBP 0.00
|
|||||||||