How to do a grant budget-to-actual reconciliation for a nonprofit

A grant budget-to-actual reconciliation compares the funder's approved budget against what you actually spent, one line at a time, and explains every material difference. Start from the latest approved budget, pull the general ledger filtered to the grant's code, map ledger categories to the funder's line items, compute each variance as budget minus actual, and write a short root-cause explanation next to it. Then check the re-budgeting rule, apply indirect costs at the approved rate, post any reclassifying entries, and do it every month. The variance number tells you where to look. The explanation column is the part that actually protects the grant.

What the reconciliation actually answers

A budget-to-actual reconciliation is both a management tool and a compliance control. For the executive director and board, it answers whether the program is on pace and on budget. For the funder, it proves that the money was spent on approved, allowable purposes and that any drift was caught and explained. A reconciliation that lists variances without explaining them fails at both jobs, because a 20,000 dollar underspend caused by a four-month staff vacancy and a 20,000 dollar underspend caused by genuine savings lead to completely different decisions.

Start with the right three documents

Before touching a spreadsheet, gather the three inputs that define the exercise.

1. The latest approved grant budget. Use the current approved version, including any funder-approved amendments, not the original proposal budget. Reconciling to a superseded budget is the most common way a reconciliation goes wrong from the first cell.

2. The award agreement. This is where the rules live: the grant period, the allowable cost categories, the indirect cost rate, the line-item flexibility limits, and the re-budgeting threshold that decides when a shift between categories needs prior written approval.

3. The general ledger, filtered to the grant. Pull the ledger detail for the grant's specific fund, class, or project code across the reporting period. This is only clean if the grant was coded correctly during the month; a reconciliation cannot fix a ledger that never separated the grant in the first place.

The seven steps

1. Map the ledger to the funder's line items. Line the general ledger categories up against the approved budget categories such as personnel, fringe, travel, supplies, contractual, and indirect. If your internal account names do not match the funder's, keep a mapping schedule so the crosswalk is documented and repeatable.

2. Pull actual expenses for the period. Take the actual amounts posted to the grant, and account for accruals: expenses that belong to the period but have not posted yet, and any reimbursements received but not yet recorded. Otherwise you end up explaining a variance that is really just timing.

3. Verify payroll allocations. Personnel is usually the largest line and the one auditors probe hardest. For each person charged to the grant, confirm that salary times the percentage of time charged matches the ledger, backed by timesheets or an activity report. If a person budgeted at 50 percent shows a full salary hitting the grant, that gap is a reconciling item, not a rounding difference.

4. Calculate the variance per line. Compute variance as budgeted amount minus actual expense for every line and for the total. Positive is favorable and under budget; negative is unfavorable and over budget.

5. Explain every material variance. This is the step the AI answers and the free templates skip. For each significant difference, name the root cause and say what, if anything, the funder needs. Common causes are timing, a hiring delay, price inflation, a coding error, a scope change, or a budget amendment that was approved but never reflected in the accounting.

6. Check the re-budgeting rule before you move anything. If a category is heading over, read the award's re-budgeting threshold before shifting funds. For federal awards this is the Uniform Guidance rule described below, and private funders set their own limits.

7. Post reclassifying entries and document. If costs were coded to the wrong grant or category, post the correcting journal entries before you close the period, and keep the budget-to-actual report, the ledger detail, and the variance explanations together as the month's record.

A worked example, with the explanation column

Here is a single grant nine months into a twelve-month period. The approved budget is 250,000 dollars. The point of the table is not the variance numbers, which any spreadsheet produces. It is the last column, which is what turns a list of differences into a reconciliation a funder and an auditor will accept. All figures are in US dollars.

Budget line	Approved budget	Actual to date	Variance	Explanation and funder action
Personnel	120,000	88,000	32,000 favorable	A program manager seat sat vacant for four months. This is a timing variance, not a saving. The role is now filled, so spending will rise over the remaining quarter. No funder action needed; note the delayed hire in the narrative.
Fringe benefits	30,000	22,000	8,000 favorable	Moves with personnel. The gap closes as the new hire's benefits begin posting. No action.
Travel	15,000	4,000	11,000 favorable	Two site visits were deferred to the final quarter. Timing variance. The forecast still expects close to the full budget by closeout.
Supplies	20,000	27,500	7,500 unfavorable	Price inflation on program materials pushed this line over. Genuine overspend, not timing. Checked against the re-budgeting threshold: the cumulative transfer is still within 10 percent of the total budget, so no prior approval is required yet, but the overage is documented and flagged to watch.
Contractual	40,000	41,000	1,000 unfavorable	A subrecipient invoice came in slightly high. Within tolerance. Reviewed for allowability and left as is.
Indirect	25,000	20,350	4,650 favorable	Indirect is applied at the approved rate against allowable direct costs, so it tracks direct spending and will rise as personnel and travel catch up. No action.
Total	250,000	202,850	47,150 favorable	On the surface, 81 percent spent at 75 percent of the timeline. Underneath, most of the favorable variance is timing that will reverse, while supplies is a real overrun. The total hides both.

Read the total row on its own and the grant looks comfortably under budget. Read the explanation column and the real picture appears: the personnel, fringe, and travel underspends are timing that will unwind as the vacancy fills and the deferred visits happen, so the remaining 47,150 dollars will largely be spent, while supplies has genuinely overrun on price. The decision that follows is not visible in any number: keep watching supplies, and if the trend continues, open the re-budgeting conversation with the funder before, not after, the threshold is crossed.

Look at timing, then forecast to completion

A variance against the annual budget is only half the read. The more useful comparison is spending against where you should be at this point in the grant. Nine months into a twelve-month grant, roughly 75 percent of the budget would be spent on an even pace. This grant is at 81 percent, slightly ahead, driven almost entirely by the supplies overrun rather than by broad overspending.

From there, forecast to completion: take actual to date and add expected remaining spend. If the filled position, the deferred travel, and normal supply purchasing all run their course, this grant lands close to its full 250,000 dollars with a small overrun risk concentrated in supplies. Naming that now, while there is a quarter left, is the entire value of reconciling monthly instead of at closeout.

Two accuracy details the shortcuts get wrong

Most generic answers to this question get two technical points slightly wrong. On grant reporting, slightly wrong is what a monitor or an auditor circles.

The re-budgeting rule is a total-budget test, not a per-line cap. The common shorthand is that you can move up to 10 percent of any line before you need permission. The actual federal rule, at 2 CFR 200.308 of the Uniform Guidance, is that prior written approval is generally required when cumulative transfers among direct cost categories exceed 10 percent of the total approved budget, and only for awards above the Simplified Acquisition Threshold. It is a 10 percent test measured against the whole budget, and it does not apply at all below that award size. Private funders set their own thresholds in the agreement, so the rule is always read from the specific award, not from a blog.

The net-asset labels are the current ones. When the reconciliation feeds the financial statements, restricted balances are described in current terms: net assets with donor restrictions and net assets without donor restrictions, under FASB ASC 958. The retired three-bucket labels, unrestricted, temporarily restricted, and permanently restricted, signal books that are behind the standard. If the grant carries a specific indirect arrangement, the de minimis indirect cost rate under the Uniform Guidance is now up to 15 percent of modified total direct costs, raised from the older 10 percent, another figure the shortcuts often quote out of date.

Do it on your platform, not in a side spreadsheet

A reconciliation that lives in a spreadsheet copied out of the accounting system drifts from the ledger the moment a journal entry changes. The durable version runs on the grant dimension inside the platform you already use, so the budget-to-actual report is the ledger, not a snapshot of it.

In QuickBooks Online that means classes and projects carrying the grant, with the budget loaded against them. In Sage Intacct it is the grant and funding dimensions with budget versions attached. In Blackbaud Financial Edge NXT it is fund and project segments. In Aplos it is funds and tags. In each case the grant is a coded dimension the reports run on, which is what lets one general ledger produce a clean budget-to-actual for every grant on demand, rather than a stack of disconnected spreadsheets that only agree until someone posts a correction.

The monthly reconciliation package

Whether you keep this in-house or outsource it, the output of each month should be one package that a funder or auditor could pick up without a walkthrough: the approved budget and any amendments, the budget-to-actual report, the general ledger detail behind it, the payroll allocation support, the written variance explanations, and a short allowability note on anything over budget. Produced monthly, that package is also most of what audit preparation and funder reporting already ask for, so the work is done once and reused.

Where Numetix fits

Grant budget-to-actual reconciliation is exactly the work a general bookkeeper who treats a nonprofit like any other business tends to skip, and where a funder finding usually begins. Numetix sets up the grant as a coded dimension in the platform an organization already uses, QuickBooks Online, Sage Intacct, Blackbaud Financial Edge NXT, or Aplos, maps the ledger to each funder's budget lines, verifies payroll allocations, runs the variance calculation with a written explanation on every material line, applies the correct re-budgeting rule from the specific award, and delivers the monthly reconciliation package in current ASC 958 terms.

Across more than 40 nonprofits and over 25 million dollars in grants managed, Numetix holds 99 percent fund-tracking accuracy and 95 percent accuracy on restricted-fund tracking, files Form 990 on time 100 percent of the time, has zero missed funder deadlines, and has cut monthly close from about 10 days to 3. When a program officer asks where a grant stands against its budget, the answer, with the reasons, is already written down.

The short version

Reconcile from the latest approved budget, pull the ledger filtered to the grant's code, map it to the funder's line items, and compute variance as budget minus actual for each line. Then write the explanation next to every material variance, because the root cause, not the number, drives the decision. Check the re-budgeting rule against the whole budget under 2 CFR 200.308, apply indirect at the approved rate, use current ASC 958 net-asset terms, run it on your platform's grant dimension, and do it monthly as a package. The spreadsheet gives you the variance. The explanation column and the monthly discipline are what keep the grant clean.

This page describes nonprofit grant reconciliation practice, including the federal Uniform Guidance (2 CFR 200) and FASB ASC 958, and is general information, not legal, tax, audit, or grant-compliance advice. Award terms vary, and specific thresholds and rates should be confirmed against the particular grant agreement and current regulations. Example figures are illustrative. Numetix figures reflect its nonprofit client base as of the date above and may change.