“How much is left on this grant?” sounds like one question. In practice, a finance director, program lead, funder, and accountant may each mean something different.

The award ceiling, pledge, cash received, recognized revenue, eligible spend, and budget remaining can all be different on the same date. A useful grant dashboard does not collapse them into one ambiguous progress bar. It defines each measure and shows the formula behind every “remaining” balance.

This guide explains the operating model. It is not legal or accounting advice. Your executed award and funder policy govern conditions and eligible uses; your CPA governs contribution, exchange-transaction, receivable, revenue, and net-asset accounting.

The six measures to keep separate

Measure	Definition	Source of truth
Award	Maximum or approved funding under the executed agreement, including amendments	Award documents
Promise/commitment	Amount promised; determine whether it is unconditional, conditional, or merely prospective before recording a receivable or revenue	Executed terms and approved accounting analysis
Cash received	Money actually deposited and attributable to the award	QuickBooks Online bank/deposit records
Recognized revenue	Amount recorded as revenue under approved accounting policy	QuickBooks Online general ledger
Expenses/spend	Costs incurred, paid, allocated, or deemed eligible—state which	QuickBooks Online plus reviewed grant allocations
Remaining	A calculated balance whose numerator and subtraction must be named	Formula, not a source document

Award is not cash. Cash is not automatically revenue. Revenue is not spend. Spend can exceed cash received on a reimbursable award or lag behind cash on an advance-funded award.

Make the accounting classification before choosing the balance

Under FASB ASU 2018-08, first determine whether the resource provider receives commensurate value. A reciprocal arrangement is an exchange transaction accounted for under the applicable contract guidance; benefit to the general public or furthering the provider's mission is not, by itself, commensurate value to the provider. A nonreciprocal transfer is a contribution.

For a contribution, distinguish these cases under the organization's approved policy:

Case	Typical accounting consequence
Unconditional contribution or unconditional promise to give	Recognize contribution revenue and, when not yet collected, an appropriate receivable, subject to valuation and collectibility policy
Conditional contribution: both a substantive barrier and a right of return or release	Do not recognize the conditional promise before the barrier is substantially overcome; cash received in advance is generally a refundable advance liability
Exchange transaction paid before performance	Record cash and a contract liability/deferred revenue as applicable, then recognize revenue as performance obligations are satisfied
Donor-restricted unconditional contribution	Recognition timing follows contribution guidance; classify in net assets with donor restrictions until the time or purpose restriction is satisfied
Restriction release	Reclassify between net-asset classes under policy; it is not new cash and generally is not new contribution revenue

A restriction limits use; a condition affects entitlement and therefore recognition. An approved budget, reimbursement process, reporting clause, or payment schedule does not answer the classification by itself. Preserve the accountant's conclusion and the agreement evidence.

A worked illustrative multi-period example

Assume a nonprofit signs a two-year, conditional reimbursement award with a $500,000 ceiling. By December 31, its records show:

Measure	Amount
Authorized award ceiling	$500,000
Amount currently pledged in funder schedule	$500,000
Cash received	$160,000
Recognized revenue under CPA-approved policy	$205,000
Reviewed eligible spend	$205,000
Total book expenses tagged to the grant	$214,000

Why is book expense higher than eligible spend? Perhaps $9,000 is pending documentation or excluded by funder policy. Why is revenue higher than cash? In this illustration, the cost-based barriers associated with $205,000 of eligible spend have been overcome, but only $160,000 has been collected. The actual accounting conclusion depends on the agreement and policy; a dashboard must preserve the distinction.

Now calculate several legitimate balances:

Label	Formula	Amount
Management ceiling less eligible spend	Award ceiling − eligible spend	$295,000
Award ceiling less cash received—management measure	Award ceiling − cash received	$340,000
Revenue not yet recognized against ceiling	Award ceiling − recognized revenue	$295,000
Eligible spend ahead of cash	Eligible spend − cash received	$45,000
Book costs pending/excluded from eligible spend	Book expense − eligible spend	$9,000

Calling any one of these simply “remaining” invites mistakes. Label the calculation in reports and tooltips. “Award ceiling minus spend” is a management measure, not proof of currently authorized funding, cash availability, an accounting asset, or permission to incur more cost; amendments, period and category limits, conditions, and funder approval still govern.

Award and pledged amount

Store the executed amount, amendment history, period, restrictions, and status. Keep prospective applications and verbal expectations out of confirmed award totals. If a multi-year commitment depends on future appropriations or milestones, distinguish the overall stated commitment from the currently authorized or unconditional amount.

A clean award rollforward is:

Original executed amount
+ approved increases
- approved reductions or terminations
= current award ceiling

Never alter the original amount without preserving the amendment. Your grant operating record may track the full management ceiling even when the accounting treatment differs; label it as award metadata rather than automatically posting it as revenue.

Cash received

Cash received is usually the easiest measure to understand and still easy to misstate. Record each receipt with:

amount and date;
QuickBooks Online deposit or transaction link;
funder and grant;
payment, draw, or installment reference;
period covered, if provided;
restriction or condition notes;
unapplied or split amount.

One deposit can cover several grants; one grant payment can be part of a combined deposit; one claim can be paid in installments. Match at the line level where possible and retain the remittance advice.

GrantLink's Money received link identifies relevant QuickBooks Online income or revenue records. The label does not guarantee that every linked record is a cash receipt, and GrantLink does not provide authoritative donor identity. Confirm cash against QuickBooks Online bank/deposit records and remittance evidence.

Recognized revenue

Recognized revenue belongs to the accounting layer. Its timing depends on whether the arrangement is a contribution or exchange transaction, whether donor-imposed conditions exist, and whether barriers or performance obligations have been satisfied. Unconditional contribution revenue can precede cash and create a receivable; advance cash for a conditional contribution can create a refundable advance; advance payment in an exchange can create deferred revenue or another contract liability. Ask your CPA to define the policy and entries.

For reporting controls, reconcile recognized revenue to QuickBooks Online income-account detail and inspect journal entries. Revenue booked through JE credits can be invisible to a pipeline limited to common income transaction forms, so the expense side can reconcile while the revenue dashboard remains incomplete.

For each JE, inspect lines rather than treating the whole entry as revenue. Revenue credits, revenue debits, deferred-revenue or refundable-advance liability lines, receivable lines, and expense lines serve different purposes.

Expenses and spend

“Spend” can mean at least four things:

Book expense: cost recorded in QuickBooks Online.
Cash disbursement: cost paid during the period.
Allocated grant expense: share assigned to a grant.
Eligible/reportable expense: allocated share accepted under funder policy.

Choose one primary dashboard measure and expose the others in reconciliation. For grant management, reviewed allocated expense is often more useful than every QuickBooks Online line bearing a broad program Class.

In GrantLink, each grant's Expenses links select relevant QuickBooks Online Customers, sub-customers/jobs, Projects, Locations, or Classes. Those links backfill and auto-allocate eligible matching activity. Ledger, Todos, and manual allocation are exception paths. A synced or allocated line is not automatically funder-eligible, and allocations do not inherently rewrite QuickBooks Online.

Remaining balance is a family of formulas

Use precise labels:

Question	Recommended measure
How much of the management ceiling has not been consumed by eligible spend?	Award ceiling − eligible cumulative spend, subject to current authorization and award terms
How much budget remains by category?	Current category budget − eligible category spend
How much cash has not arrived?	Scheduled/authorized cash − cash received
How much eligible cost awaits reimbursement?	Eligible spend − claimed or paid amount, adjusted for rejects
How much recognized revenue exceeds spend?	Recognized revenue − selected spend measure
How much cash is temporarily funding the grant?	Eligible spend − grant cash received, if positive

Do not call recognized revenue less spend “grant remaining” unless that is explicitly the intended management question. It can be useful, but it is not the same as award capacity.

A monthly rollforward design

Maintain one grant summary with separate columns, then link to detail.

Month	Award ceiling	Cash received MTD	Cash cumulative	Revenue MTD	Revenue cumulative	Eligible spend MTD	Spend cumulative	Ceiling less eligible spend
Oct	$500,000	$80,000	$80,000	$75,000	$75,000	$68,000	$68,000	$432,000
Nov	$500,000	$40,000	$120,000	$70,000	$145,000	$72,000	$140,000	$360,000
Dec	$500,000	$40,000	$160,000	$75,000	$220,000	$65,000	$205,000	$295,000

Below the summary, retain:

award and amendment log;
receipt register linked to QuickBooks Online deposits;
revenue detail tied to QuickBooks Online, including JEs;
expense allocation detail backed by QuickBooks Online;
funder-category budget versus actual;
claims or invoices and outstanding balances;
reconciliation exceptions.

Reporting to different audiences

Program leads

Show award capacity, reviewed spend, category budget remaining, pace, and known commitments. Avoid presenting cash received as permission to spend.

Finance and accountants

Show all six measures, receivables or advances according to approved policy, allocation exceptions, QuickBooks Online source links, and the revenue/expense reconciliation.

Funders

Use the exact requested measure and template. Some require cash receipts, others cumulative eligible expenditure, reimbursement claims, or budget-versus-actual. Strict Excel templates are common and may need to be completed in exact cells and converted to PDF.

GrantLink can store and complete Excel report templates from reviewed data. A human must confirm date range, formulas, categories, and funder definitions before submission.

Reports start in Chats > New Chat and then appear in the grant Reports tab. QuickBooks Online remains the accounting source of truth. Any supported QuickBooks Online write requires explicit permission and workflow; Settings > QuickBooks Mapping is for restriction-release account mappings, not grant matching. GrantLink does not provide acknowledgment-ready donor exports.

Boards

Show a concise portfolio view, but define every balance. “$295,000 of the management ceiling remains after eligible spend, subject to award terms; $45,000 of eligible costs is ahead of cash collections” is more useful than one unexplained green balance.

Month-end control checklist

Common dashboard failures

Avoid these shortcuts:

Award = revenue: an operating award record does not determine recognition.
Deposit = revenue: cash timing and revenue timing can differ.
QuickBooks Online tag = eligible spend: tagging identifies scope, not allowability.
Revenue − expense = remaining award: this answers a different question.
Restriction release = revenue or cash: a release is a net-asset reclassification under policy, not a new receipt.
One QuickBooks Online entity = one grant: real files can use mixed Customers/Projects or many subclasses.
Successful sync = complete history: a limited date window can omit old, unchanged transactions.
One total for all audiences: management, accounting, and funder reports have different definitions.

The goal is not more numbers. It is a controlled vocabulary that lets every number retain its meaning and trace to evidence.

Sources

FASB ASU 2018-08 — commensurate value, conditional contributions, barriers, and rights of return or release
FASB ASU 2016-14 — net assets with and without donor restrictions and release presentation

How to Track Grant Award, Cash, Revenue, Expenses, and Remaining Balance