How to Track Reimbursable Grants in QuickBooks

With a reimbursable grant, your nonprofit pays an eligible cost first, submits a claim, and receives cash later. The expense, the claim, the receivable, the revenue, and the deposit may therefore fall in different months, and treating them as one number quickly makes a grant report unreliable.

A good process keeps QuickBooks Online as the accounting record and adds a separate claim schedule. The schedule shows which eligible costs have been reviewed, claimed, and paid, and which are still available to claim.

The process below is operating guidance, not legal or accounting advice. Your award terms decide eligibility and billing rules, and your CPA decides the recognition and journal entry treatment.

Keep six measures separate

Don't call every inflow or balance "reimbursement." Keep a short schedule with a clear definition for each measure.

Measure	What it means	Typical evidence
Award ceiling	The most the funder will pay	Signed award and amendments
Eligible spending	Reviewed costs that the award allows	QuickBooks Online transactions and support
Claimed	Costs included in submitted reimbursement requests	Claim workbook or portal confirmation
Receivable	Amount earned or billed but not yet collected, if applicable	Approved accounting entry and supporting detail
Cash received	Deposits collected from the funder	Bank deposit matched in QuickBooks Online
Recognized revenue	Revenue recorded under the nonprofit's accounting policy	QuickBooks Online income report and journal support

The measures are related, but you can't swap one for another. For example, a $30,000 claim can include $25,000 of current-month spending and $5,000 carried forward from earlier months. Cash can also arrive after year-end. Revenue may be recognized before or after billing, depending on the award conditions and your accounting policy.

A worked reimbursement example

Suppose a $240,000 cost-reimbursement award runs from January through December. By March 31:

Item	Amount
Reviewed eligible costs through March	$58,400
Costs held for missing support	$3,600
Claims submitted	$45,000
Cash received	$30,000
Recognized revenue under the approved policy	$58,400

From these numbers:

• Available to claim is $13,400, which is $58,400 eligible minus $45,000 claimed.
• Submitted but unpaid is $15,000, which is $45,000 claimed minus $30,000 received, before any rejected or offset items.
• Unspent award is $181,600, which is the $240,000 award minus $58,400 of eligible spending. It isn't $210,000, even though only $30,000 of cash has arrived.
• On hold is $3,600, which you can't claim until documentation and funder rules support it.

The table shows revenue separately because the right accounting depends on whether the award conditions have been met and on your policy. Don't calculate recognized revenue directly from cash or claims without CPA review.

Choose a consistent grant dimension in QuickBooks Online

Choose a consistent QuickBooks Online dimension before you pull transactions into a claim workbook. Real company files are often mixed. One grant may be a Customer, another may be a Project under a funder Customer, and a third may span several Classes or sub-classes.

Document each award's mapping.

Grant	QuickBooks Online pattern	Included values	Excluded values
Workforce award	Customer and Project	Funder: Workforce FY26	The parent Customer by itself
Senior services award	Classes	Every sub-class for the grant	Parent Classes used for grouping
Housing contract	Customer	Housing Contract 2026	The inactive prior-year Customer

A grant that spans sub-classes under different parent Classes can be understated if some of the valid sub-classes aren't linked to the grant report, even though every transaction is in QuickBooks Online. Classes aren't always the right answer. What matters is that you write down the full mapping, including every sub-class or child record, and test it against the general ledger.

Use accounts for the type of cost, such as salary, rent, or supplies, and don't use them in place of the grant dimension. Use Classes, Customers, or Projects consistently enough to isolate each award. Then map those account categories to the funder's claim categories.

Build the expense-to-claim schedule

Export or sync the award's QuickBooks Online activity for the exact reporting period. Keep one row for each source transaction or line, with these fields:

• QuickBooks Online transaction ID, date, payee, account, memo, amount, and tag
• Grant and funder budget category
• Eligibility status, such as eligible, held, excluded, or pending review
• Allocation method and the approved grant share
• Claim number and claim period
• Submitted date, accepted amount, payment date, and deposit reference
• Reviewer, review date, and exception note

Never overwrite the QuickBooks Online amount with the claimable amount. If 60% of a $10,000 invoice is allowable under the award, keep the $10,000 source line and record a $6,000 allocation. You can then always trace the claim back to the books.

Review shared costs before you claim them

For payroll, rent, insurance, and other shared costs:

1. Confirm that the cost falls within the award period.
2. Check allowability and any budget or prior-approval limits.
3. Apply the documented allocation basis.
4. Attach or reference the calculation and the support prepared at the time.
5. Have someone other than the preparer review material allocations or allocations that need judgment.
6. Save a fixed copy of the accepted claim, and record later corrections as adjustments instead of editing the claim.

GrantLink syncs QuickBooks Online transactions and supports allocation and review. When a grant spans several Classes or sub-classes, you can link all of them to one grant. QuickBooks Online stays the accounting record, and GrantLink holds the reviewed grant share.

Prepare and reconcile each claim

Many funders require a strict Excel workbook instead of a simple export. Keep the funder's tabs, formulas, category order, reporting period, and certification language. A practical claim package includes:

1. A cover sheet with the award, claim number, period, preparer, reviewer, and submission date
2. A category summary with the current claim, prior claims, cumulative claims, budget, and balance
3. Transaction detail, with each eligible line backed by QuickBooks Online and an allocation
4. Adjustments, such as rejected costs, credits, prior-period corrections, and amounts carried forward
5. A support index for invoices, payroll, procurement, and allocations

Before you submit, prove the following:

Current claim detail
= Current claim category summary

Prior accepted claims + current claim
= Cumulative claimed

Award budget - cumulative claimed
= Remaining claim capacity

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. The finance team should still review the filled workbook against the funder's instructions before submission, because filling a template doesn't decide allowability. GrantLink's Reporting > Claims page lists reimbursement claims built from costs already allocated to grants.

Match cash without hiding timing differences

When cash arrives, match the bank deposit in QuickBooks Online using the process your CPA approves. In the claim schedule, record the receipt separately and apply it to the right claim or claims. Don't mark every eligible transaction as paid just because a round-number deposit arrived.

Check for:

• One payment that covers several claims
• A partial payment or a funder holdback
• A payment reduced by a rejected cost
• A deposit combined with another award
• Payment of an older claim during the current reporting period

GrantLink tracks payments received on the grant's Transactions > Invoices & receipts page, separately from the award and from expenses. Keeping them separate helps explain why "spent," "claimed," and "received" can all be correct and still differ.

Month-end checklist for reimbursement grants

• QuickBooks Online bank and credit card accounts are reconciled.
• The grant's Expenses and Money received links in GrantLink include every intended Customer, Project, Class, or sub-class.
• The export or sync covers the whole grant period and claim period.
• Credits, voids, and reversals are included.
• Shared-cost allocations are documented and reviewed.
• Held and excluded costs aren't in the claim.
• Current detail ties to the funder workbook summary.
• Cumulative claims tie to accepted prior submissions.
• Receipts are matched to claims, including partial payments.
• Revenue and receivable balances tie to the accounting records your CPA approves.
• The remaining award, remaining budget, and remaining claim capacity each have their own label.

When the report and QuickBooks differ

Don't add a plug to the claim workbook. Find each difference by transaction and by step. Common causes include sub-classes that weren't linked, a sync or export date range that leaves out older transactions, reversed allocations, credits entered after submission, and journal entry revenue that an income report built from sales forms leaves out.

None of these differences is a reason to edit the general ledger just to make the totals agree. Each one needs a fix to the mapping, the data coverage, or the process.

To find the cause of a difference transaction by transaction, use Why Your Grant Report Doesn't Match QuickBooks. For a repeatable close and submission process after you know the cause, use How to Reconcile a Grant Report to the QuickBooks General Ledger.

Keep an exception log with the owner, cause, amount, correction, and retest date. If a difference involves revenue recognition, grant conditions, indirect costs, allowability, or financial statement presentation, stop and check the award, the funder, and your CPA.

Final check

A reimbursable grant is in good shape when finance can trace a claim total to the eligible allocations, to the original QuickBooks Online lines, and to their support. Finance should also be able to explain unpaid claims and cash receipts separately.

GrantLink's grant links and automatic allocation work inside GrantLink, and they don't change QuickBooks Online. GrantLink changes QuickBooks Online only when 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.

The claim schedule, support index, independent review, and fixed submission copies described above are recommended practices. The award and the funder's instructions decide allowability and billing.

Sources

• FASB: ASU 2018-08: contributions compared with exchange transactions, and recognition of conditional contributions.
• Intuit: Reconcile an account in QuickBooks Online: bank and credit card reconciliation.