Why does early detection matter?
Donors expect you to use grant funds in the period and on the agreed lines. An underspend can mean unfinished work and unspent funds that may need to be returned, depending on the agreement. An overspend means costs the grant cannot cover. Both are far cheaper to fix in month four than in month eleven.
What should you track?
Three numbers, for each grant and for each budget line:
- Budget. The approved amount for the period.
- Spent and committed. Posted actual costs plus open orders and agreements. Our budget vs actual review article explains this pair.
- Time elapsed. The share of the grant period that has passed.
The test compares percent used with percent of time elapsed.
How do you run the simple test?
Do this each month:
- Calculate percent of time elapsed: months passed ÷ months in the grant.
- Calculate percent used: (spent + committed) ÷ budget.
- Take the gap: percent used minus percent of time.
- Compare the gap with your tolerance, such as 10 percentage points.
Example, for illustration only:
| Line | Budget | Spent + committed | % used | % time | Gap | Signal |
|---|---|---|---|---|---|---|
| Personnel | 60,000 | 18,000 | 30% | 50% | -20 | Under |
| Travel | 8,000 | 6,000 | 75% | 50% | +25 | Over |
| Training | 12,000 | 6,200 | 52% | 50% | +2 | On track |
Some costs are not even across the year. A training line may be heavy in months 8 to 10. Use your work plan to adjust the expected pattern, rather than a straight line.
What are the common causes of underspend?
- Late start. Staff hired late, or procurement that has not begun.
- Slow purchasing. Requests wait in approval queues. See procurement approval limits.
- Unspent partner funds. Sub-grantee reports arrive late.
- Cost not yet posted. Invoices received but not entered.
- Activities delayed by access, weather or security.
Check the last two first, because they are bookkeeping, not delivery.
What are the common causes of overspend?
- Price changes or exchange-rate movements.
- Scope growth without a budget change.
- Wrong coding. A cost charged to the wrong grant or line.
- Ordering in bulk early, with no remaining budget for later months.
- Unrecorded commitments, so the budget looks healthier than it is.
What should you do when a line drifts?
Set the response before it happens. A short decision list:
- Check the data. Are all costs posted and coded correctly?
- Ask program staff. Is delivery on plan, or is work delayed?
- Choose an action: speed up spending that is truly needed, slow down or stop, move money between lines within the agreement’s limit, or ask the donor for a change.
- Record the decision, its owner and a date to check again.
Moving money between lines often has a limit set in the agreement. Read it first. Donor approval, if needed, takes time, so ask early.
Who should see the numbers?
Send the table to the project manager and finance lead every month. The project manager knows whether delivery is on track, and finance knows whether the data is complete. A short meeting of both, with the table, is more useful than a long report.
How do you build the habit?
An early warning only works if someone looks at it. Put the check on the same date each month, right after the books close. Keep the table to one page, sorted so the largest gaps appear first.
Record the decision for each flagged line, even if the decision is “wait”. At the next meeting, start with last month’s flags and ask what happened. Over a year, this record also shows which lines are hard to forecast, and you can use that when you plan the next budget.
Two small habits help. Ask program staff to share their work plan dates, so you can adjust the expected spending pattern. And ask logistics to share open orders each month, so commitments are never a surprise.
Where EMPOBase fits
EMPOBase’s Finance module shows Budget vs Actual per grant, and Budget Health, with Restricted Funds tracked through commitments, so you can see spent, committed and still available per award. Figures update as procurements land and journals post, so they are only as current as the records behind them. EMPOBase shows the gap; your team decides the response, and donor approvals are still yours to request. See the documentation or ask for a walk-through.