How to Reconcile a Grant Report to the QuickBooks General Ledger

A grant report is reconciled when every reported amount can be traced through a defined mapping and allocation to posted QuickBooks Online detail—and every in-scope QBO line is either reported or has a documented reason for exclusion.

That is stronger than making two grand totals equal. Equal totals can hide offsetting errors, wrong categories, omitted credits, or expenses from the wrong grant.

Use this procedure at month-end, before submitting a reimbursement claim, and at grant closeout. Award terms and funder instructions govern report eligibility and format. Your CPA governs accounting basis, revenue recognition, and financial-statement treatment.

This guide is for the repeatable close and reporting procedure: assembling a reconciliation packet, tying categories in a workbook, maintaining an exception log, and obtaining signoff. If totals differ and the cause is not yet known, first use Why Your Grant Report Doesn't Match QuickBooks to work the difference tree and isolate the root cause.

Assemble the reconciliation packet

Collect immutable copies of:

1. the funder's blank and completed Excel templates;
2. QBO general-ledger or transaction detail for the exact period;
3. grant allocation detail, including pending, rejected, and reversed items;
4. the approved grant budget and amendments;
5. prior accepted reports and cumulative claimed amounts;
6. award receipts or deposit detail;
7. the QBO-to-grant and account-to-funder-category mapping;
8. support for material shared-cost allocations.

Strict funder workbooks are common. They may require exact tabs, cells, formulas, signatures, and a final PDF. Treat the workbook as an output specification, not the accounting subledger. Preserve an untouched template and a dated submitted copy.

Step 1: write the reconciliation specification

Do not begin with exports. Complete this control header first:

Control	Selected definition
Grant period	July 1, 2025–June 30, 2026
Report period	April 1–June 30, 2026
Accounting basis	Accrual, subject to funder adjustments
QBO dimension	Documented tracking values linked to one grant
Expense accounts	Defined natural expense accounts
Report population	Reviewed eligible allocation lines
Revenue measure	Recognized revenue, separately reconciled
Cash measure	Deposits received, separately reconciled

This makes disagreements visible. If the funder wants cash-basis expenditure detail while management reviews accrual-basis expense, create a documented bridge rather than quietly switching filters.

Step 2: establish the QBO control total

Run transaction-level detail for the full grant period and for the current report period. Include stable IDs, transaction type, date, account, amount, and full tracking-dimension path.

Validate the source before using it:

• QBO bank and credit-card reconciliations are complete.
• The report is from the intended QBO company.
• Beginning and ending dates are explicit.
• The accounting basis is visible.
• Journal entries, credits, voids, and negative lines are included as intended.
• Account and tracking-dimension filters are saved or documented.

If data comes through a sync, verify that its historical window reaches the grant start. An incremental refresh does not necessarily retrieve an old transaction that has not been modified recently.

Step 3: prove the grant scope

Create a scope inventory rather than relying on entity names.

QBO value	Full path	Linked?	Include?	Reason
900101	Admin : Award 3	Yes	Yes	Grant-specific subclass
900102	Transportation : Award 3	Yes	Yes	Grant-specific subclass
900199	Admin	No	No	Parent/container only

One grant may cross several functional areas or tracking values. An organization may also use a mixed Customer/Project setup, where a Customer represents one grant in some cases and a child Project represents the grant in others. The reconciliation scope must follow the actual file, not a universal setup rule.

GrantLink can link multiple QBO classes or subclasses to one grant and sync QBO transactions. Confirm the links before trusting the grant total.

Step 4: reconcile source lines to allocations

Use stable source IDs to compare the QBO population with grant allocations. Do not join solely on date, vendor, and amount; recurring payroll and rent can create false matches.

Build a bridge:

QBO in-scope expense lines
- valid non-grant or ineligible costs
- amount assigned to other grants
- held/pending support
+ approved shared-cost allocations from other source scopes, if policy permits
= reviewed grant actual

For each difference, capture a reason code:

• missing entity link;
• outside grant/report period;
• outside sync history;
• pending allocation review;
• rejected or reversed allocation;
• partial/shared allocation;
• non-expense account or balancing line;
• credit, void, or source revision;
• funder-policy exclusion;
• duplicate or manual report line.

Step 5: map grant actuals to funder categories

The QBO chart of accounts and the funder's budget rarely have a one-to-one relationship. Maintain a mapping table with effective dates.

QBO account	Funder category	Allocation needed?	Review note
Salaries	Personnel	Yes	Grant share supported by approved method
Payroll taxes	Fringe	Yes	Same base or funder-approved treatment
Office rent	Occupancy	Yes	Document square footage or other basis
Program supplies	Supplies	Sometimes	Review grant tag and allowability

Then prove all three levels:

QBO source lines -> reviewed allocations -> funder category rows

GrantLink supports allocation and review, and can store and complete Excel report templates. It does not replace the funder's policy or your judgment about allowability. Review formula ranges and category mappings after workbook population.

Step 6: tie current and cumulative columns

For every funder category, recalculate:

Category	Approved budget	Prior accepted	Current report	Cumulative	Budget remaining
Personnel	$120,000	$48,000	$24,000	$72,000	$48,000
Occupancy	$36,000	$15,000	$9,000	$24,000	$12,000
Supplies	$24,000	$6,500	$4,500	$11,000	$13,000
Total	$180,000	$69,500	$37,500	$107,000	$73,000

Check that current detail equals the current column; prior accepted reports equal the prior column; cumulative equals prior plus current; and budget less cumulative equals the stated balance. If amendments exist, document which budget version governs each report.

Step 7: reconcile revenue and cash separately

Expense reconciliation does not prove revenue or receipt balances. Maintain distinct measures for award, pledged amount, cash received, recognized revenue, spend, and remaining.

Journal entries are a frequent trap. Revenue may be booked through a JE credit while the same JE contains expense or balance-sheet lines. A transaction feed designed around sales forms may not include that revenue. Inspect revenue-account lines and posting sides rather than assuming all JEs are excluded or included wholesale.

GrantLink tracks fund receipts separately from expense activity. Match each receipt to QBO deposit evidence, but let the CPA-approved books determine revenue and receivable treatment.

Step 8: review exceptions and certify

The preparer should deliver an exception log, not just a workbook.

Exception	Amount	Owner	Resolution	Retested
Missing subclass link	$12,400	Finance admin	Added link; refreshed period	Yes
Payroll support pending	$2,100	Program lead	Held from current report	Yes
Prior claim credit	($600)	Controller	Shown as current adjustment	Yes

The reviewer should independently check material source lines, all manual adjustments, new mappings, allocation methods, workbook formulas, and cumulative totals. Keep evidence of reviewer signoff.

Submission checklist

• Scope, dates, basis, and definitions are documented.
• QBO source accounts are reconciled and the export is retained.
• Every intended Customer, Project, Class, or subclass is listed.
• Historical sync/export coverage reaches the period start.
• QBO lines tie to active, reviewed allocations by stable ID.
• Pending, rejected, and reversed allocations are explained.
• Funder category mapping is complete and current.
• Current detail ties to current summary.
• Prior accepted reports tie to the cumulative rollforward.
• Revenue and receipts are reconciled independently of spend.
• The original template's formulas and formatting are preserved.
• Exceptions and reviewer approval are archived with the report.

When totals legitimately remain different

Some differences should remain: accrual versus cash basis, report-period cutoff, unallowable book expenses, pending support, funder caps, or a later credit. Label these as reconciling items with expected reversal or resolution dates. A transparent bridge is more authoritative than a forced zero.

Escalate questions about award conditions, indirect-cost treatment, recognition, net-asset presentation, or disputed eligibility to the funder and CPA. Reconciliation identifies the difference; it does not make the policy decision.