GPT Analysis: Excel data processed directly from structured columns; Date Gap Analysis: Found 1 gap > 7 days: 04/17/2026 to 04/25/2026 (8 days)
| Date | Description | Client | Category | Debit | Credit | Balance |
|---|---|---|---|---|---|---|
| 2026-05-15 | Internet charges (BTB001) | Internet | Uncategorized | EUR 25.00 | ||
|
Client:
Internet
Category:
Uncategorized
|
||||||
| 2026-05-17 | Rent 17 May–16 Jun 2026 (KEL001) | Rent | Uncategorized | EUR 1100.00 | ||
|
Client:
Rent
Category:
Uncategorized
|
||||||
| 2026-05-19 | Keys & locks (CAP001) | Keys | Uncategorized | EUR 1100.00 | ||
|
Client:
Keys
Category:
Uncategorized
|
||||||
| 2026-05-22 | Service charge 01 Apr 2026–31 Mar 2027 (SOU002) [see accrual note] | Service charge | Uncategorized | EUR 1100.00 | ||
|
Client:
Service charge
Category:
Uncategorized
|
||||||
| 2026-05-22 | Ground rent 01 Apr 2026–31 Mar 2027 (SOU002) [see accrual note] | Ground rent 01 Apr 2026–31 Mar | Uncategorized | EUR 1100.00 | ||
|
Client:
Ground rent 01 Apr 2026–31 Mar
Category:
Uncategorized
|
||||||
| 2026-05-25 | Rent 24 Jun–28 Sep 2026 (SHA001) [see accrual note] | Rent | Uncategorized | EUR 7375.00 | ||
|
Client:
Rent
Category:
Uncategorized
|
||||||
| 2026-05-25 | Rent 25 May–24 Jun 2026 (ELI001) | Rent | Uncategorized | EUR 1250.00 | ||
|
Client:
Rent
Category:
Uncategorized
|
||||||
| 2026-05-26 | Rent 24 Jun–28 Sep 2026 (THE001) [see accrual note] | Rent | Uncategorized | EUR 7125.00 | ||
|
Client:
Rent
Category:
Uncategorized
|
||||||
| 2026-05-29 | Rent 29 May–28 Jun 2026 (DAN001) | Rent | Uncategorized | EUR 1100.00 | ||
|
Client:
Rent
Category:
Uncategorized
|
||||||
| 2026-06-01 | Rent Jun 2026 (JAY001) | Rent | Uncategorized | EUR 2550.00 | ||
|
Client:
Rent
Category:
Uncategorized
|
||||||
| 2026-06-01 | Internet recharged (JAY001) | Internet | Uncategorized | EUR 25.00 | ||
|
Client:
Internet
Category:
Uncategorized
|
||||||
| 2026-06-01 | Cleaning (SPA001) | Cleaning | Uncategorized | EUR 0.00 | ||
|
Client:
Cleaning
Category:
Uncategorized
|
||||||
| 2026-06-01 | Electricity (EON005) | Electricity EON005 | Uncategorized | EUR 0.00 | ||
|
Client:
Electricity EON005
Category:
Uncategorized
|
||||||
| 2026-06-01 | Rent Jun 2026 (DAB001) | Rent | Uncategorized | EUR 2620.00 | ||
|
Client:
Rent
Category:
Uncategorized
|
||||||
| 2026-06-01 | Internal cleaning (SPA002) | Internal cleaning | Uncategorized | EUR 0.00 | ||
|
Client:
Internal cleaning
Category:
Uncategorized
|
||||||
| 2026-06-01 | Rent 01–30 Jun 2026 (SEA001) | Rent | Uncategorized | EUR 1250.00 | ||
|
Client:
Rent
Category:
Uncategorized
|
||||||
| 2026-06-02 | M&E repairs (CAP001) | Sales invoice INV-1021 ACME LTD | Rental Income | EUR 1250.00 | ||
|
Client:
Sales invoice INV-1021 ACME LTD
Category:
Rental Income
|
||||||
| 2026-06-03 | Business rates x2 (BAR001) | Business rates | Uncategorized | EUR 1250.00 | ||
|
Client:
Business rates
Category:
Uncategorized
|
||||||
| 2026-06-05 | Keys & locks (CAP001) | Keys | Uncategorized | EUR 0.00 | ||
|
Client:
Keys
Category:
Uncategorized
|
||||||
| 2026-06-05 | Rent 05 Jun–04 Jul 2026 (WER001) [see accrual note] | Rent | Uncategorized | EUR 1060.00 | ||
|
Client:
Rent
Category:
Uncategorized
|
||||||