Why Your Grant Report Doesn't Match QuickBooks

When a grant report differs from QuickBooks Online, neither the general ledger nor the grant report is automatically wrong. The two reports may answer different questions from different sets of transactions.

The fastest way to an answer is to define each total, compare the transactions behind each one, and classify every difference. Don't post a journal entry or add a spreadsheet plug only to make the reports agree.

First, confirm that the totals should match

Write a one-sentence definition of each number.

Report total	Possible definition
QuickBooks Online grant total	Posted expense account lines tagged with selected Customers, Projects, or Classes for a date range
Grant actual	Reviewed allocations from synced QuickBooks Online transactions within the grant period
Funder expense total	Eligible costs mapped to funder categories, possibly without unallowable or unsupported costs
Cash-basis expense	Expense under QuickBooks Online's cash-basis report rules for the period
Recognized revenue	Revenue recorded under the organization's accounting policy

An accrual-basis QuickBooks Online report won't always equal a cash-basis funder report. Cash-basis expense isn't the same as payments. For example, payments posted to balance sheet accounts, such as loan principal or prepaid assets, aren't automatically expense. A grant actual built from approved allocations won't equal every expense tagged to a broad parent Class. A reimbursement claim may also leave out costs that are valid book expenses but aren't allowable under the award.

Before you troubleshoot, record the basis, period, transaction types, accounts, tags, allocation status, and treatment of credits for both sides.

Work through the differences in order

Work in the following order, because each step can explain a large group of transactions at once.

1. Scope and tracking dimension

Confirm which QuickBooks Online records define the grant. Organizations commonly use:

• One Customer for one grant
• A funder Customer with a Project or sub-customer for each grant
• One Class for one grant
• Classes for programs and Customers or Projects for grants
• Several sub-classes for one grant, under different parent Classes

Many organizations mix setups. For example, a nonprofit may use a Customer for each grant on older awards and a Project for each grant on newer awards. Don't assume the current organization-wide setup describes every older transaction.

For a grant that uses several Classes, list every full Class path. Parent Classes may only group other Classes, so don't include a parent just because its sub-classes are included. If a grant spans several sub-classes, leaving out even one valid sub-class can make the report materially incomplete.

2. Report dates and grant dates

Use explicit start and end dates on both reports. Check:

• Transaction date compared with posting date or last modified date
• Fiscal period compared with grant period
• Quarter end compared with "through today"
• Prior-period adjustments posted later
• Transactions dated exactly on the start or end date

Also check how far back the data goes. A sync can succeed and still leave out older transactions if its history window is shorter than the grant period. A new routine sync may not fix the gap when those transactions haven't changed recently in QuickBooks Online. You need to widen the history window and refresh it. In GrantLink, you can do so in Settings > QuickBooks > Sync.

3. Transaction types and accounts

Compare the transaction types on each side, such as bills, expenses, checks, credit card charges, bill payments, deposits, invoices, sales receipts, credits, and journal entries. Then compare the account filters.

Journal entries need special attention, because one entry can contain both expense and revenue lines. A grant report that reads expense allocations may include an eligible journal entry debit. At the same time, a revenue report built only from sales forms may leave out the journal entry credit. On the other hand, a journal entry total that is too broad can count balancing lines twice.

Don't classify a line from its memo or account name alone. For example, "Property/Liability" can be the name of an insurance expense account, even though the word "liability" appears in it. Use the QuickBooks Online account type, the debit or credit side, and the line detail.

4. Links and allocation status

A transaction can be in QuickBooks Online and synced to GrantLink, but still be missing from the grant total, for these reasons:

• Its Class, Customer, or Project isn't linked to the grant.
• It falls outside the grant period.
• The grant's share hasn't been allocated.
• The allocation is pending review, rejected, or reversed.
• The line is allocated to another grant.
• Only part of a shared cost is eligible.

GrantLink syncs QuickBooks Online transactions, lets you link several Classes or sub-classes to one grant, and supports allocation and review. A report based on reviewed allocations won't equal a broad QuickBooks Online tag total until you resolve the exceptions.

5. Changes after the report was prepared

Look for voids, deleted transactions, credits, reclassifications, and changed allocation percentages after the report date. Keep copies of submitted reports, and explain later corrections separately. Editing a spreadsheet without a record removes the audit trail.

Example diagnosis

Suppose a report is lower than the matching QuickBooks Online total. A comparison by transaction could sort the difference into causes like these.

Cause	Test that finds it
A valid tag wasn't linked	Group QuickBooks Online lines by full tag path
Older activity was outside the sync history	Compare QuickBooks Online export IDs with synced IDs
An eligible allocation was no longer active	Compare eligible QuickBooks Online lines with active allocations

If grant revenue booked through journal entry credits is also missing from a revenue view, treat it as a separate revenue problem. Don't mix it into the expense analysis.

The example shows four general points:

1. A connection marked as synced doesn't prove that all past transactions are included.
2. One grant can link to several QuickBooks Online records, so count and check every link.
3. Reversed allocations should stay visible in exception reports.
4. Expense and revenue reconciliations need separate rules.

Use the steps above to find why totals differ. Once you know the causes, use How to Reconcile a Grant Report to the QuickBooks General Ledger for the repeatable close procedure, reconciliation packet, category tie-out, exception log, and reviewer signoff.

Compare the reports line by line

Export the QuickBooks Online detail and the grant detail to separate tabs. Put these fields in the same format on both:

• Transaction ID, and line ID where available
• Date
• Transaction type
• Payee or name
• Account and account type
• Amount, with the same sign convention on both sides
• Full Customer, Project, or Class path
• Grant allocation amount and status

Then classify each row.

Classification	Meaning	Typical action
Both, same amount	The line and the amount agree	No action
QuickBooks Online only	Missing from the grant data	Check links, dates, sync, eligibility, and allocation
Grant only	The source changed, or a duplicate or manual item exists	Trace the source and the report copy
Both, different amount	Partial allocation or a changed source	Recalculate and document
Timing difference	Valid, but in different periods	Carry it forward in the reconciliation
Definition difference	The reports answer different questions	Relabel, and don't force agreement

Group exceptions by cause and amount. If 200 missing lines share one sub-class, fix the missing link instead of investigating 200 separate rows.

Reconcile revenue separately

Keep these measures in separate columns.

Measure	Example
Award	$300,000
Pledged or committed	$300,000
Cash received	$180,000
Recognized revenue	$210,000
Eligible or allocated spending	$165,000

A "remaining" amount needs a formula. Award minus spending is $135,000, award minus cash is $120,000, and recognized revenue minus spending is $45,000. All three can be correct, because each answers a different question.

Check income booked by journal entry, including recognition accruals and corrections. Review releases from restriction separately, because a release changes how restricted amounts are presented and isn't new revenue. Have your CPA confirm the recognition and release treatment. Ask the funder whether its report should show cash received, earned reimbursement, or another measure.

Reconciliation checklist

• Define both report totals in writing.
• Match the accounting basis and the exact start and end dates.
• Confirm the QuickBooks Online company and the last successful sync.
• Before relying on cash or deposit totals, confirm that bank and credit card accounts are reconciled.
• Check that the sync history reaches the grant start date.
• List every linked Customer, Project, Location, Class, and sub-class.
• Leave out parent Classes or Customers unless you mean to include them.
• Compare transaction types and account filters.
• Check journal entries line by line for both expenses and revenue.
• Include credits, voids, reversals, and rejected allocations.
• Compare transaction IDs, not only vendor, date, and amount.
• Tie funder categories back to QuickBooks Online accounts and allocation rules.
• Record each exception, owner, correction, and retest result.
• Save the submitted funder workbook and its supporting detail.

What not to do

Don't change QuickBooks Online only to match an outside workbook, and don't widen a report until the number looks right. Don't classify transactions from the vendor name alone, and don't combine the award, revenue, receipts, and spending into one balance. Don't let an AI tool guess a grant's scope from names when the grant has explicit links.

You can add the funder's Excel workbook on the grant's Reporting > Templates page, and the Assistant fills a new copy from reviewed grant data. Filling the funder's format doesn't replace a reconciliation. Your finance reviewer is responsible for which transactions the report includes, and your CPA or funder decides accounting and award policy questions.

Fix the books in QuickBooks Online only when the books are wrong. When the grant data in GrantLink is wrong, fix the grant's links or allocations in GrantLink. GrantLink doesn't change QuickBooks Online unless your organization allows that change in Settings > QuickBooks > Permissions. To create a report, select Draft report with Assistant on the grant's Reporting > Reports page, or open Chats > New chat.

Sources

• Intuit: Run reports in QuickBooks Online: report periods, accounting basis, customization, and detail.
• Intuit: Reconcile an account: reconciliation status and reports.
• FASB: ASU 2018-08: the recognition rules behind differences among the award, cash, and revenue.