Certification gets the attention in affordable housing software, and it is not the only thing a compliance failure comes from. Three registers sit alongside it and each has its own failure mode: the waiting list, the unit mix against the set-aside commitment, and the utility allowance applied to each rent. A system that certifies beautifully and mismanages any of the three will still fail a file review.
The waiting list is an auditable record
Applications have to be taken, ordered, and offered in a defensible sequence, with preferences applied consistently and every skip explained. A list held in a spreadsheet with rows moved by hand cannot show why the household in position twelve was offered before the one in position nine. The system should hold the list as an append-only record of events: applied, contacted, declined, withdrawn, housed, each dated.
The unit mix has to hold against the commitment
A property with a set-aside commitment must keep a specified proportion of units occupied by qualifying households at specified income levels. That is a live figure, not an annual one, and it moves every time a unit turns. The system should show the current mix against the commitment and warn before a letting would breach it, because after the letting the remedy is much worse.
Utility allowances change the rent
Where a tenant pays some utilities directly, an allowance is deducted in arriving at the rent they may be charged, and the allowance schedule is updated periodically. An out-of-date allowance means every affected rent is wrong, quietly, across the whole property. The system should hold the schedule with its effective date and reprice affected tenancies when it changes rather than leaving that as a manual sweep.
Everything has to survive a file review
The measure of these systems is not the screen; it is the file a reviewer asks for. Application, certification with its supporting documents, the rent calculation showing the allowance, the lease and its addenda, and the recertification history. If assembling that takes a person a morning per household, the system is a filing cabinet with a login.
Questions people ask about affordable housing property management software
What is usually missed outside certification?
The utility allowance update, because it silently changes every affected rent, and the live unit mix, because it only matters at the moment of a letting.
Can a general product be made to work?
Only with substantial configuration and a person who knows the programme rules. The forms and the file review are the hard part, not the tenancy record.
How should a waiting list be kept?
As a dated, append-only record of events per applicant, so that the order and every departure from it can be explained.