How to Track Reimbursable Grants in QuickBooks

A reimbursable grant creates a timing problem: your nonprofit pays an eligible cost first, submits a claim, and receives cash later. The expense, reimbursement request, receivable, revenue, and deposit may therefore occur in different months. Treating all five as one number is the fastest way to lose confidence in a grant report.

The right workflow keeps QuickBooks Online as the accounting record while maintaining a separate claim schedule that answers: Which eligible costs have been reviewed, claimed, paid, and still remain available to claim?

This guide is an operational framework, not legal or accounting advice. Your award terms determine eligibility and billing rules; your CPA determines the appropriate recognition and journal-entry treatment.

Start with six separate measures

Do not label every inflow or balance “reimbursement.” Use a small rollforward with explicit definitions.

Measure	What it means	Typical evidence
Award ceiling	Maximum authorized funding	Executed award and amendments
Eligible spend	Reviewed costs allowed under the award	QBO transactions plus 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 subledger
Cash received	Deposits actually collected from the funder	Bank deposit matched in QBO
Recognized revenue	Revenue recorded under the nonprofit's accounting policy	QBO income report and journal support

These values are related, but they are not interchangeable. A $30,000 claim can include $25,000 of current-month spend and $5,000 carried forward. Cash can arrive after year-end. Revenue may be recognized before or after billing depending on award conditions and accounting policy.

A worked reimbursement example

Assume a $240,000 cost-reimbursement award runs 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 per approved policy	$58,400

The operational conclusions are:

• Available to claim: $13,400 ($58,400 eligible minus $45,000 claimed).
• Submitted but unpaid: $15,000 ($45,000 claimed minus $30,000 received), before adjusting for rejected or offset items.
• Unspent award capacity: $181,600 ($240,000 award minus $58,400 eligible spend), not $210,000 merely because only $30,000 cash has arrived.
• On hold: $3,600 is not claimable until documentation and funder rules support it.

The revenue amount is shown separately because the correct accounting depends on whether conditions have been substantially met and on the organization's policy. Do not derive recognized revenue mechanically from cash or claims without CPA review.

Configure QuickBooks around a stable grant dimension

Choose a consistent QBO tracking dimension before importing transactions into a claim workbook. Real nonprofit files are not always uniform: one grant may be a Customer, another a Project under a funder Customer, and another may span multiple Classes or subclasses.

Document each award's mapping:

Grant	QBO tracking pattern	Included values	Explicit exclusions
Workforce award	Customer/Project	Funder: Workforce FY26	Parent customer only
Senior services award	Classes	All grant-specific subclasses	Parent/container classes
Housing contract	Customer	Housing Contract 2026	Prior-year inactive customer

A grant that spans subclasses under different parent classes can be understated when some valid child values are not linked to the grant report, even though every transaction exists in QBO. The lesson is not “always use Classes.” It is: write down the full mapping, including every child value, and test it against the general ledger.

Use accounts for the natural character of a cost—salary, rent, supplies—not as a substitute for the grant dimension. Use Classes, Customers, or Projects consistently enough to isolate the award, then map those accounting categories to the funder's claim categories.

Build the expense-to-claim control table

Export or sync the award's QBO activity for the exact reporting period. Maintain one row per source transaction or transaction line with these fields:

• QBO transaction ID, date, payee, account, memo, amount, and tracking dimension;
• grant and funder budget category;
• eligibility status: eligible, held, excluded, or pending review;
• allocation method and 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 QBO amount with the claimable amount. If a $10,000 invoice is 60% allowable to the award, preserve the $10,000 source line and record a $6,000 allocation. That keeps the route back to the books visible.

Review shared costs before claiming

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

1. Confirm the cost occurred within the award period.
2. Check allowability and any budget or prior-approval restrictions.
3. Apply the documented allocation basis.
4. Attach or reference the calculation and contemporaneous support.
5. Have someone other than the preparer review material or judgmental allocations.
6. Lock the accepted claim snapshot; process later corrections as adjustments, not silent edits.

GrantLink syncs QBO transactions and supports allocation and review workflows. Where a grant spans several QBO classes or subclasses, those links can point to one grant. The accounting source remains QBO; the grant layer provides the reviewed grant share.

Prepare and reconcile each claim

Many funders require a strict Excel workbook rather than a convenient export. Preserve the funder's tabs, formulas, category order, reporting period, and certification language. A practical claim package includes:

1. Cover control: award, claim number, period, preparer, reviewer, and submission date.
2. Category summary: current claim, prior claimed, cumulative claimed, budget, and balance.
3. Transaction detail: each QBO-backed eligible line and allocation.
4. Adjustments: rejected costs, credits, prior-period corrections, and carryforwards.
5. Support index: invoice, payroll, procurement, and allocation references.

Before submission, prove:

Current claim detail
= Current claim category summary

Prior accepted claims + current claim
= Cumulative claimed

Award budget - cumulative claimed
= Remaining claim capacity

GrantLink can store and complete Excel report templates. The finance team should still review the populated workbook against the funder's instructions before submission; template completion does not decide allowability.

Match cash without erasing timing differences

When cash arrives, match the bank deposit in QBO according to the accounting workflow approved by your CPA. In the grant schedule, record the receipt separately and apply it to the correct claim or claims. Do not mark every eligible transaction “paid” simply because a round-dollar deposit arrived.

Check for:

• one payment covering multiple claims;
• a partial payment or funder holdback;
• a payment net of a rejected cost;
• a deposit combined with another award;
• payment of an older claim during the current reporting period.

GrantLink tracks fund receipts separately from award and expense activity. That separation helps explain why “spent,” “claimed,” and “received” legitimately differ.

Month-end reimbursement checklist

• QBO bank and credit-card accounts are reconciled.
• The grant mapping includes every intended Customer, Project, Class, or subclass.
• The export/sync covers the entire grant and claim period.
• Credits, voids, and reversals are included.
• Shared-cost allocations are documented and reviewed.
• Held and excluded costs are not 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 CPA-approved accounting records.
• Remaining award, remaining budget, and remaining claim capacity are not mislabeled as the same balance.

When the report and QuickBooks differ

Do not plug the claim workbook. Isolate differences by transaction and by layer. Common causes include omitted subclasses, a sync or export date window that excludes older transactions, reversed allocations, credits entered after submission, and journal-entry revenue that is absent from an income-only transaction feed.

None of those differences justifies editing the general ledger merely to force agreement. They require mapping, data-coverage, or workflow corrections.

For a root-cause difference tree and transaction-level troubleshooting, use Why Your Grant Report Doesn't Match QuickBooks. For a repeatable close and submission process after the cause is understood, use How to Reconcile a Grant Report to the QuickBooks General Ledger.

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

Final control

A reimbursable grant is healthy when finance can move from a claim total to the eligible allocation, to the original QBO line, and to its support—and can separately explain outstanding claims and cash receipts.