Add budget versus actual without confusion
A practical guide to presenting budget, actual spending and variances clearly in a small NGO donor financial report.
A budget-versus-actual table can make a donor report useful, but only if the reader can tell which budget, which period and which currency it covers. A table labelled simply “Budget, Actual, Balance” may create more questions than it answers.
The safest approach is to use the approved donor budget headings, compare like with like, and explain only the variances that matter. You do not need complicated accounting language. You need clear labels, consistent dates and a short explanation of what changed.
Decide exactly what you are comparing
Before making the table, write down the reporting period. For example: “Quarter ended 30 June 2025” or “From 1 January to 31 March 2025”. The budget and actual columns must relate to the same dates unless you clearly label them otherwise.
There are two common ways to present budget versus actual. A period comparison shows the budget for this month or quarter beside spending for the same period. A cumulative comparison shows the budget from the start of the grant to the report date beside all spending from the start of the grant to that date.
Cumulative reporting is often easier for a donor to interpret because timing differences from one month may settle in the next. However, use the format required by the grant agreement or donor template. If the template asks for both period and cumulative figures, show them in separate groups of columns.
Do not compare one quarter’s spending with the whole annual budget and then call the difference a variance. The arithmetic may be correct, but the comparison is not meaningful. If you only have an annual budget, prepare a simple phased budget showing when activities and costs were expected. Keep this working sheet with the report records.
Also decide what “actual” means. It normally means costs already incurred and recorded by the report date. An order placed with a supplier is not automatically actual spending. A planned workshop is not actual spending. If committed costs must be reported, place them in a separate column and define the term.
Write the basis above or below the table. A useful note is: “Actual expenditure includes transactions recorded from 1 January to 30 June 2025. Commitments are excluded.”
- Use the exact start and end dates.
- Choose period, cumulative or both.
- Compare spending with the budget for the same dates.
- Keep commitments separate from actual expenditure.
- State the currency and accounting basis.
Use columns that answer simple questions
A reader should be able to scan the table and answer four questions: What was planned? What was spent? What remains? Why is there a significant difference?
For a straightforward cumulative report, use these columns: budget line, approved budget, cumulative budget to date, cumulative actual to date, variance to date and brief explanation. The approved budget gives context, while the budget-to-date column provides the fair comparison.
If the donor does not require the full approved budget in every report, you can use a shorter table with budget for the reporting period, actual for the reporting period and variance. Do not add columns merely because a spreadsheet can hold them.
Choose one sign convention for variance and state it. A clear option is “Variance equals budget minus actual”. Under this method, a positive number is unspent budget and a negative number is overspending. Another method may be acceptable, but unexplained negative figures are easy to misunderstand.
Use the budget headings from the approved grant budget. Do not replace “Community training” with internal labels such as “Events” or “Field costs” unless the donor approved that structure. You may maintain more detailed internal categories, but combine them under the correct donor line for reporting.
Add a total row and make it visually distinct. Check that the detailed lines add to the total budget, total actual and total variance. Avoid excessive colours, abbreviations and notes inside the figures. Put explanations in a final column or directly below the table.
- Label every column with its period.
- Show the reporting currency beside the table title.
- Define how variance is calculated.
- Keep donor budget headings in the approved order.
- Use brackets or a minus sign consistently for overspending.
Build the table from a simple worked example
Suppose a six-month community health project has an approved budget of USD 24,000. By the end of the first quarter, the phased budget says the project expected to use USD 11,000. Recorded expenditure for the same three months is USD 9,800.
The table could show these rows: training materials, venue and refreshments, local travel, field staff, communications and administration. Each row needs a budget-to-date figure based on the activity plan, not an equal share of the full budget unless costs were genuinely expected to occur evenly.
For example, the training materials budget to date is USD 2,500 and actual spending is USD 1,700. Using budget minus actual, the variance is USD 800. Venue and refreshments have a budget to date of USD 1,500 and actual spending of USD 2,000, giving a variance of negative USD 500.
The first line is underspent because some materials will be bought before the next workshop. The second line is overspent because two planned sessions were combined and held earlier than expected. These explanations tell the reader whether the difference is mainly timing or a change in cost.
Now consider the total. The budget to date is USD 11,000, actual spending is USD 9,800 and the variance is USD 1,200 unspent. Do not write that the project “saved USD 1,200” unless activities were completed for less than budgeted and the money is no longer needed. At the end of the quarter, it may simply be money expected to be spent later.
The full approved budget of USD 24,000 can appear in a separate column. This shows the overall ceiling without confusing it with the budget expected to have been used by the quarter end. The reader can see both the total grant position and the fair comparison for the reporting date.
- Training materials: budget to date USD 2,500; actual USD 1,700; variance USD 800.
- Venue and refreshments: budget to date USD 1,500; actual USD 2,000; variance negative USD 500.
- All lines combined: budget to date USD 11,000; actual USD 9,800; variance USD 1,200.
Explain variances without writing an essay
A variance note should explain the reason, the effect and the next step where relevant. One or two sentences are usually enough. Avoid repeating the numbers without explaining them. “Travel is over budget by USD 600” adds little because the table already shows that fact.
A more useful note would be: “Local travel exceeded the budget to date because visits to three villages were brought forward from the next quarter. No increase to the full travel budget is currently expected.” This explains timing and indicates whether the approved total is likely to be affected.
For a cost increase, you might write: “Venue hire cost more than planned because the original low-cost venue was unavailable. The project will use the community hall for the remaining sessions. A budget transfer may be needed if the line remains above the approved amount.”
For delayed spending, write what was delayed and when it is now expected. For example: “The second training was moved to July after the facilitator became unavailable. The related materials and refreshment costs remain unspent and are expected next quarter.”
Do not describe every small difference. Follow any variance threshold in the donor agreement. If no threshold is given, focus on differences that affect activities, approved budget limits, future cash needs or the ability to complete the project.
Be careful with the words “underspent”, “saving” and “available”. An underspend at the report date may be a timing difference. It does not automatically mean the funds can be moved to another budget line. Check the grant rules before describing money as available for reallocation.
- Reason: what caused the difference?
- Effect: does it change an activity or the full budget?
- Timing: will the cost appear in a later period?
- Action: is approval, reallocation or another response needed?
Check the final report from the reader’s view
First, confirm that the actual expenditure total agrees with the expenditure schedule used for the donor report. If the report is prepared from a bank statement and paper receipts, check that cash transactions, bank charges, refunds and advances have been treated consistently. The budget-versus-actual table should not introduce a second, different actual total.
Second, check the currency. If the approved budget is in USD but spending records are in local currency, state how figures were converted. Follow the exchange-rate method in the agreement. Do not silently compare a USD budget with unconverted local-currency expenditure.
Third, check for approved revisions. If the donor approved a budget change, use the revised budget and keep the approval with the grant records. Label the column “Revised approved budget” and note the approval date. Do not overwrite the original budget without retaining a copy.
Fourth, inspect the table as if you had not prepared it. Can you identify the reporting dates, currency, variance formula and budget version without opening another file? Can you distinguish an overspend from an underspend? Do the explanations match the correct lines?
Finally, keep the main report readable. Detailed calculations, exchange-rate workings and transaction lists can sit in supporting schedules. The main table should present the approved headings, reliable totals and explanations needed to understand the current position.
- Actual expenditure agrees with the report schedule.
- Budget and actual figures cover the same dates.
- The currency and exchange-rate basis are stated.
- Approved revisions are clearly identified.
- Variance notes explain causes rather than repeat figures.
- Totals and formulas have been checked.
Questions
Should I show the full grant budget or only the budget for the period?
Show what the donor template requires. If there is no fixed format, include the full approved budget for context and a budget-to-date column for comparison with cumulative actual spending. Label both clearly.
What if we did not prepare a monthly or quarterly budget?
Create a reasonable phased budget from the approved activity plan, expected payment dates and known recurring costs. Document how you divided the budget. Do not change the approved total or present the phasing as donor-approved unless it was approved.
Should unpaid invoices be included as actual expenditure?
Follow the accounting basis required by the donor. If actual expenditure is reported when costs are incurred, an eligible unpaid invoice may belong in actuals. If reporting is cash-based, it may be excluded until payment. State the basis and show commitments separately if requested.
Can an underspend on one line cancel an overspend on another?
It may make the overall total look within budget, but it does not remove a budget-line breach. Check whether the agreement permits transfers between lines and whether prior donor approval is required.
How much detail should a variance explanation contain?
Usually one or two sentences covering the cause, effect and planned action. Give more detail when the variance may affect activities, timing, eligibility or compliance with an approved line.
A clear budget-versus-actual report compares the same period, uses approved headings, defines the variance and explains important differences in plain language. Honest Record can help match recorded expenditure to budget lines and run consistency checks, but the preparer still needs to confirm the reporting basis, approved revisions and explanation for each material variance.
Honest Record reads the statement and receipts, matches them, applies your fund's rules and verifies every row before the Excel exists. Free 14-day trial, no card.
Upload your first month free See a sample report