Monthly performance pack
Northgate Estates
July 2026
Reviewed & signed · 6 August 2026Rent collected
£96,920
▲ 2.1% vs June
Collection rate
97.9%
▼ 0.6 pts vs June
Occupancy
94.9%
— no change vs June
Net to owners
£37,146
▲ 3.4% vs June
Rent demanded less rent collected, July. Collection rate in the appendix.
Alder Place is £770 short on the smallest rent roll in the portfolio — a 94.4% collection rate against 97.9% across the group. At less than a month’s rent on the block it is a part payment rather than a missed one, so it wants a reminder and not a recovery. Foundry Yard and Northgate House collected in full.
Occupied units over lettable units at month end, as a percentage. Darker is fuller.
Weaver's Row has fallen 12 points since February and has not recovered. Two units have been void since May — £2,400 a month at the block's average rent, and £7,200 foregone so far. That is more every month than every arrear arising across the whole portfolio, which is where the attention has been going. Every other block is flat or improving.
Opening arrears, plus rent demanded but not collected, less recoveries and write-offs.
A falling arrears balance with a falling collection rate means older debt is being recovered faster than new debt is arising — worth watching rather than acting on.
Share of £96,920 collected, July.
- Mortgage interest · £38,600
- Management, works & insurance · £21,174
- Net to owners · £37,146
Checks — the numbers reconcile
Rent demanded less rent collected equals the new arrears raised
£98,950 − £96,920 = £2,030
Client account receipts equal rent collected on the rent roll
£96,920 banked across 71 receipts
The works ledger total equals the repairs line in this pack
14 contractor invoices = £9,240
Alder Place service charge for June has not been raised
£1,240 accrued, outside this pack
Sources — 3 files, one join
rent_roll_JUL2026.xlsx
Property manager export — one row per tenancy, arrears on a second sheet
Arrived 3 Aug
client_account_0771_july.csv
Client bank account — rent receipts, mortgage debits and contractor payments
Arrived 3 Aug
works_ledger_2026.xlsx
Maintenance spreadsheet kept by the site manager — invoice, block, category
Arrived 5 Aug
Joined on block reference and month. Computed by recipe v7 — frozen 4 February 2026 — so the occupancy series above is six months of identically calculated numbers. Ground rents and the commercial unit at Foundry Yard are out of scope and excluded throughout.
Appendix — by property
| Property | Units | Let | Demanded | Collected | Rate |
|---|---|---|---|---|---|
| Kingsway Court | 24 | 23 | £28,800 | £28,100 | 97.6% |
| Foundry Yard | 18 | 18 | £24,300 | £24,300 | 100.0% |
| Alder Place | 12 | 11 | £13,750 | £12,980 | 94.4% |
| Weaver's Row | 16 | 14 | £16,800 | £16,240 | 96.7% |
| Northgate House | 9 | 9 | £15,300 | £15,300 | 100.0% |
| Portfolio | 79 | 75 | £98,950 | £96,920 | 97.9% |
Northgate Estates · July 2026 · prepared by Bellhouse Advisory
Built with Databoat
Commentary
Rent collected in July was £96,920 against £98,950 demanded — a collection rate of 97.9%, down from 98.5% in June.1 Foundry Yard and Northgate House collected in full for the fourth month running. Alder Place is the weak point at 94.4%, and a single unit accounts for most of it.
Occupancy held at 94.9% across the portfolio, unchanged since May. Two units at Weaver’s Row have now been void for three months, which is the single largest recoverable item in this pack.2 Arrears closed at £11,310, slightly below the opening balance — £1,860 was recovered against £2,030 of new arrears, and £340 was written off on a departed tenant.3
After mortgage interest of £38,600 and running costs of £21,174, the net distribution to owners is £37,146.4 Receipts on the client account agree with the rent roll to the penny, and the works ledger ties to the repairs line.✓
Drafted by Databoat from the computed figures, then edited and signed by Bellhouse Advisory. Each citation links the sentence to the figure behind it.