How to Reconcile a Grant Report to the QuickBooks General Ledger

A grant report is reconciled when you can trace every reported amount through a defined mapping and allocation to posted QuickBooks Online detail. In addition, every QuickBooks Online line in scope is either in the report or has a documented reason for being left out.

Matching two grand totals isn't enough. Equal totals can hide errors that cancel out, wrong categories, missing credits, or expenses from the wrong grant.

Use this procedure at month-end, before you submit a reimbursement claim, and at grant closeout. The award terms and the funder's instructions decide what is eligible and how the report looks. Your CPA decides the accounting basis, revenue recognition, and financial statement treatment.

The guide below covers the repeatable close and reporting procedure: building a reconciliation packet, tying categories in a workbook, keeping an exception log, and getting a reviewer's signoff. If totals differ and you don't know why yet, start with Why Your Grant Report Doesn't Match QuickBooks to find the cause.

Build the reconciliation packet

Collect copies that won't change later of:

1. The funder's blank and completed Excel templates
2. QuickBooks Online 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 any amendments
5. Prior accepted reports and the cumulative amounts claimed
6. Award payments received, or deposit detail
7. The mapping from QuickBooks Online records to grants, and from accounts to funder categories
8. Support for material shared-cost allocations

Funders often require strict workbooks with exact tabs, cells, formulas, signatures, and a final PDF. Treat the workbook as the required output format, not as your accounting record. Keep an untouched copy of the template and a dated copy of what you submitted.

Step 1: Write the reconciliation definition

Don't start with exports. Fill in a header like this one first.

Item	Definition you choose
Grant period	July 1, 2025 to June 30, 2026
Report period	April 1 to June 30, 2026
Accounting basis	Accrual, with any funder adjustments
QuickBooks Online dimension	The documented tags linked to one grant
Expense accounts	The defined natural expense accounts
Report population	Reviewed eligible allocation lines
Revenue measure	Recognized revenue, reconciled separately
Cash measure	Deposits received, reconciled separately

The header makes disagreements visible. If the funder wants cash-basis spending while management reviews accrual-basis expense, build a documented bridge between the two instead of changing filters without a record.

Step 2: Set the QuickBooks Online control total

Run transaction-level detail for the full grant period and for the current report period. Include transaction IDs, transaction type, date, account, amount, and the full path of each tag.

Check the source before you use it:

• QuickBooks Online bank and credit card reconciliations are complete.
• The report comes from the right QuickBooks Online company.
• The start and end dates are explicit.
• The accounting basis is shown.
• Journal entries, credits, voids, and negative lines are included as intended.
• Account and tag filters are saved or documented.

If the data comes through a sync, check that the sync history reaches the grant start date. A routine sync doesn't always pick up an old transaction that hasn't changed recently. In GrantLink, you can check and extend the history window in Settings > QuickBooks > Sync.

Step 3: Prove the grant scope

List every tag in scope instead of relying on record names.

QuickBooks Online value	Full path	Linked?	Include?	Reason
900101	Admin : Award 3	Yes	Yes	Sub-class for this grant
900102	Transportation : Award 3	Yes	Yes	Sub-class for this grant
900199	Admin	No	No	Parent Class used only for grouping

One grant may cross several functions or tags. An organization may also mix setups, where a Customer represents one grant and a Project under a funder Customer represents another. The scope must follow the actual company file, not a general rule.

GrantLink can link several QuickBooks Online Classes or sub-classes to one grant. Confirm the links before you trust the grant total.

Step 4: Reconcile source lines to allocations

Use transaction IDs to compare the QuickBooks Online lines with the grant's allocations. Don't match only on date, vendor, and amount, because recurring payroll and rent can create false matches.

Build a bridge like this one.

QuickBooks Online expense lines in scope
- valid costs that aren't grant costs or aren't eligible
- amounts assigned to other grants
- costs held for missing support
+ approved shared-cost allocations from outside the scope, if policy permits
= reviewed grant actual

Give each difference a reason code, for example:

• Missing link to a QuickBooks record
• Outside the grant or report period
• Outside the sync history
• Allocation pending review
• Allocation rejected or reversed
• Partial or shared allocation
• Line on a non-expense account, or a balancing line
• Credit, void, or change to the source transaction
• Excluded by funder policy
• Duplicate or manual report line

Step 5: Map grant actuals to funder categories

Your chart of accounts and the funder's budget rarely line up one to one. Keep a mapping table with effective dates.

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

Then prove that each level ties to the next:

QuickBooks Online source lines -> reviewed allocations -> funder category rows

GrantLink supports allocation and review. You can add the funder's Excel workbook on the grant's Reporting > Templates page, and the Assistant fills a new copy from the grant's data without changing your uploaded file. GrantLink doesn't replace the funder's policy or your judgment about allowability. After the workbook is filled, review the formula ranges and the category mapping.

Step 6: Tie the current and cumulative columns

Recalculate every funder category.

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 each of the following:

• The current detail equals the current column.
• Prior accepted reports equal the prior column.
• Cumulative equals prior plus current.
• Budget minus cumulative equals the stated remaining balance.

If the budget was amended, document which version applies to each report.

Step 7: Reconcile revenue and cash separately

An expense reconciliation doesn't prove revenue or receipt balances. Keep separate measures for the award, the pledged amount, cash received, recognized revenue, spending, and the remaining balance.

Journal entries often cause errors. A journal entry may credit a revenue account and also include expense or balance sheet lines. A report built only from sales forms may leave out that revenue. Inspect revenue account lines and their debit or credit side, instead of including or excluding all journal entries.

GrantLink tracks payments received on the grant's Transactions > Invoices & receipts page, separately from expenses. Match each receipt to the QuickBooks Online deposit, and let the books your CPA approves decide the revenue and receivable treatment.

Step 8: Review exceptions and sign off

The preparer should deliver an exception log along with the workbook.

Exception	Amount	Owner	Resolution	Retested
Missing sub-class link	$12,400	Finance admin	Added the link and refreshed the period	Yes
Payroll support pending	$2,100	Program lead	Held out of the current report	Yes
Credit on a prior claim	($600)	Controller	Shown as a current adjustment	Yes

The reviewer should check material source lines, all manual adjustments, new mappings, allocation methods, workbook formulas, and cumulative totals. Keep a record of the reviewer's signoff.

Submission checklist

• The scope, dates, basis, and definitions are documented.
• QuickBooks Online source accounts are reconciled, and the export is saved.
• Every intended Customer, Project, Class, or sub-class is listed.
• Sync or export history reaches the period start.
• QuickBooks Online lines tie to active, reviewed allocations by transaction ID.
• Pending, rejected, and reversed allocations are explained.
• The funder category mapping is complete and current.
• Current detail ties to the current summary.
• Prior accepted reports tie to the cumulative totals.
• Revenue and receipts are reconciled separately from spending.
• The original template's formulas and formatting are preserved.
• Exceptions and the reviewer's approval are saved with the report.

When totals should stay different

Some differences are valid. Examples include accrual compared with cash basis, report period cutoffs, book expenses that aren't allowable, costs waiting for support, funder caps, and a later credit. Label each as a reconciling item with the date you expect it to reverse or be resolved. A clear bridge is more reliable than forcing the difference to zero.

Send questions about award conditions, indirect costs, revenue recognition, net asset presentation, or disputed eligibility to the funder and your CPA. A reconciliation finds the difference, but it doesn't make the policy decision.

GrantLink recommends that you save the source export, the mapping version, the exception log, and the reviewer's signoff together as one dated packet. GrantLink doesn't change QuickBooks Online unless your organization allows that change in Settings > QuickBooks > Permissions.

Sources

• Intuit: Reconcile an account in QuickBooks Online: the reconciliation steps and reconciliation reports.
• FASB: ASU 2018-08: why the award, cash received, conditions met, and recognized revenue are separate measures.