Xcelerate
Menu
Get in touch
All articles on council finance and operations

Council finance and operations

Community grants software for reporting back to council

Design a council grants register from award to accountability report. Test evidence requests, amended budgets and unspent amounts from a volunteer’s perspective.

Community gardeners review project expenses and progress photographs on a laptop.
AI-generated editorial image.

A community garden wins a grant for materials and a public workshop. Rain moves the event, a supplier donates the timber and the volunteer treasurer changes halfway through. The grant officer will eventually need to reconcile spending with the agreement. The new treasurer needs to know what the group promised and what evidence will close the grant. Design council grants software from that handover backwards.

What did the council actually approve?

Retain the approved purpose, amount, eligible costs and reporting date with the original funding decision. Keep a copy of the terms for that funding round. If a council changes next year's template, an earlier recipient should still see the conditions they accepted. Give staff a place to record an approved change and who had authority to grant it.

For the garden, distinguish cash paid to the group, its own contribution and the value of donated materials. Donated timber may help explain the outcome. Entering its value as a payment from the grant would misstate spending. Ask the supplier to show how the original and revised budgets stay visible side by side.

How much evidence is enough?

Start from the fund's own rules. Central Otago District Council's guide for its first 2025 round describes different reporting requests at different grant amounts. It illustrates why buyers should be able to configure evidence by funding round and award conditions. Avoid hard-coding another council's thresholds into a shared application form.

Make each requested item concrete. A volunteer might supply a receipt for materials, a brief account of the workshop and the amount remaining. Explain how to send evidence through an assisted channel and who can help if the original invoice is missing. Let officers ask a specific follow-up question against the relevant line while preserving the first submission.

Can a new treasurer finish the report?

A shared community group survives changes in office holders. Give the organisation a continuing record and individual people separate access. Rehearse a transfer of responsibility in which the former treasurer loses access and the incoming officer sees only the grants they are authorised to manage. Keep the transfer approval in the staff history.

Save a report in progress. The treasurer should be able to return after a committee meeting, review the amounts with another authorised member and submit once. Send a dated receipt showing the grant reference and what the council will do next. That receipt is useful when a volunteer hands over their files.

Show how a grant closes

Use an example with grant money left over after the donation of timber. Ask the grants officer to reconcile the payment, eligible expenditure and balance, then record the agreed treatment of that balance. Show an officer requesting clarification, the group supplying it and a reviewer accepting the report. A programme summary should distinguish reports received, reports accepted and amounts still under review so elected members can read the results accurately.

Sources and further reading