Linking Grant Output Units to Individual Register Records
Reconcile grant delivery outputs with asset records through a unit-to-asset crosswalk that explains shared components, multiple records and unresolved gaps.
How can a grant output schedule be reconciled with the asset register?
Build a crosswalk from each reported delivery unit to the assets or components that support it, retaining project, location and evidence references. Explain one-to-many and many-to-one relationships rather than forcing equal counts. Grant output reporting and asset accounting describe different things, so finance and programme owners should review the connection and any differences.
A programme report may say five facilities were completed, while the asset register contains thirty additions for buildings, equipment and supporting infrastructure. Neither count is necessarily wrong. The problem is whether a reviewer can follow each reported facility to the physical scope and financial records that support it, without double counting shared assets or claiming unsupported completion.
Define the output unit before matching records
Ask the programme owner for the definition used in the applicable grant agreement or reporting instructions. Record whether the unit is a facility, household connection, road section or another deliverable. Preserve the reporting period and version. Do not infer the definition from a short label in a presentation, because similarly named outputs may use different completion criteria.
Assign a stable output reference and link its location, project scope and completion evidence. Record the person responsible for confirming delivery. This creates the programme side of the crosswalk. It should remain distinct from the asset identifier so changes in register componentisation do not silently alter the reported delivery population.
Explain the relationships to assets
List the register records associated with each output and describe their role. One facility may contain several separately recorded assets; one shared asset may support several outputs. Mark these relationships explicitly and identify any allocation or attribution basis used. Avoid duplicating the full value of a shared component under every output and then adding the rows together.
Check for assets with no output link and outputs with no supporting asset records. Some differences may be legitimate, such as a deliverable that does not create a separately recognised asset. Others may indicate incomplete handover. Route each exception to the relevant programme, technical or finance owner rather than forcing a match for presentation purposes.
Reconcile evidence as well as totals
Select outputs and trace them to completion evidence, physical references and register entries. Then select new register records and trace back to the project and relevant output where applicable. This reverse check can reveal additions omitted from the programme schedule or grant-funded scope mixed with unrelated work.
Keep funding evidence separate from the accounting decision. A grant reference does not itself determine recognition, measurement or the reporting framework. Finance should apply the entity's applicable requirements, with ASB Directive 5 providing period-specific framework references for GRAP reporters. Retain the approved crosswalk and unresolved differences with the reporting pack so the relationship remains reviewable.
Practical Example
Illustrative example: a grant programme reports two community facilities. Each has a building and several equipment records, while one shared generator supports both. The crosswalk links the generator once and describes its shared role. Programme completion evidence and register values remain separately controlled, avoiding the false conclusion that two reported outputs should equal two asset rows.
Action Checklist
- 1.Obtain the output-unit definition from the applicable programme documentation.
- 2.Assign stable output references with location and completion evidence.
- 3.Map individual and shared assets without duplicating shared values in totals.
- 4.Investigate unmatched outputs and unmatched asset additions as separate populations.
- 5.Test the crosswalk in both directions and retain reviewed explanations of differences.
Connect delivery evidence to asset records in an audit-ready handover pack through Audit-Ready Asset Management.