Development Accounting for Housing Associations: Schemes, Shared Ownership and Sales on Oracle
A development scheme starts as a land purchase and ends as homes in the asset register, some of them partly sold. This is how we design Oracle Fusion so each stage is accounted for against the scheme, and finance can see where every scheme stands.
Development is where housing finance meets the longest timelines and the largest sums.
A scheme can run for several years, in phases, with a mix of tenures: homes for rent, shared ownership homes where residents buy a share, and sometimes homes for outright sale. Costs build up as work in progress (WIP), grant is drawn against them, and at completion the homes move into the fixed asset register, except for the shares that are sold.
The development team, finance and the asset team each need a different view of the same scheme. The design gives them one record to work from.
Steps, in order:
- Scheme set-up: Phases, tenure mix, budget
- Commitments: Orders and variations
- Work in progress: Costs against budget
- Completion: Capitalise into components
- Sales: First tranche, staircasing, disposals
Schemes, phases and budgets
Each scheme is set up as a project in Oracle Fusion, with phases for staged developments and tasks for the cost categories the development team manages. Land and property acquisitions, including buy-backs, are recorded against the scheme from the start.
Budgets are held at scheme and phase level. Finance and development can compare the original budget, the approved budget, the current forecast and actual costs side by side, with variance and forecast outturn (the expected final cost) for each scheme.
Commitments and work in progress
Contractor orders, variations, invoices and accruals are coded to the scheme and phase, so commitments and costs are tracked against the approved budget and funding limits. Our procure-to-pay guide covers how orders, receipts and invoices are controlled.
Work in progress builds up from those costs. The design includes a reconciliation between WIP, open commitments, invoices and the general ledger, so the development balance in the accounts can be explained scheme by scheme at month-end.
Capitalisation on completion
At practical completion (when the homes are finished and ready to hand over), the scheme's costs move from WIP into the fixed asset register. Under Housing SORP, housing properties are recorded by component, so costs are split into components such as structure, roof, kitchen and bathroom, each with its own useful life.
Partial capitalisation is supported for phased schemes, so completed phases move into the register while later phases stay in WIP. Grant follows the costs it funded. Our article on grant funding in housing finance covers that side.
Shared ownership, staircasing and other sales
Shared ownership needs two treatments in one scheme. The share sold to the resident at completion, the first tranche, is a sale. The share the housing association keeps stays in the asset register as a fixed asset.
First tranche sales
Recorded as sales income, with the matching cost of sale, at completion.
Staircasing
When a resident buys further shares, part of the retained asset is disposed of, with any gain or loss and grant recycling.
Right to Buy and Right to Acquire
Disposals of whole homes, with proceeds, net book value and any grant treatment recorded together.
Each of these runs through the same property record, so the asset register, sales income and grant balances stay consistent. The detailed accounting follows the organisation's own policies under Housing SORP, which are confirmed in design workshops.
Reporting the development programme
Scheme dashboards show status, budget, forecast, commitments and WIP, with drill-down to the transactions. Capital programme, grant and scheme profitability reports come from the same data, and can be cut by tenure mix, so sales income, grant income and costs can be seen together for each scheme.
Finance: for a large UK housing group, PCL One's Oracle programme cut month-end close from 18 days to under 5, with return on investment in under seven months.
Controls auditors can follow
- Approval workflows for scheme budgets, variations and capitalisation.
- Document attachments and change history on each scheme, kept with the record they support.
- Integration with the general ledger, payables, budgets, fixed assets and grants, so each figure has one source.
From land purchase to completed homes
PCL One implements Oracle Fusion Cloud ERP, Projects and Fixed Assets for housing providers, from the first design workshop to the last day of hypercare (the intensive support period after go-live), with the same team throughout.
A development programme is easier to steer when the forecast, the commitments and the ledger come from one place.