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

“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
Pledged/committed	Amount promised, which may or may not equal the current authorized ceiling	Commitment records and award terms
Cash received	Money actually deposited and attributable to the award	QBO bank/deposit records
Recognized revenue	Amount recorded as revenue under approved accounting policy	QBO general ledger
Expenses/spend	Costs incurred, paid, allocated, or deemed eligible—state which	QBO 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.

A worked 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	$220,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? The organization may have met conditions for amounts not yet collected. The accounting conclusion depends on facts and policy, but the dashboard must preserve the distinction.

Now calculate several legitimate balances:

Label	Formula	Amount
Award capacity remaining	Award − eligible spend	$295,000
Cash funding remaining	Award − cash received	$340,000
Revenue not yet recognized against ceiling	Award − recognized revenue	$280,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 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;
• QBO 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 tracks fund receipts separately and can link appropriate QBO deposit activity to a grant. That means the receipt total does not have to masquerade as either revenue or award amount.

Recognized revenue

Recognized revenue belongs to the accounting layer. Its timing may depend on whether the arrangement is a contribution or exchange transaction, whether donor-imposed conditions exist, and whether qualifying barriers or performance obligations have been met. Ask your CPA to define the policy and entries.

For reporting controls, reconcile recognized revenue to QBO 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:

1. Book expense: cost recorded in QBO.
2. Cash disbursement: cost paid during the period.
3. Allocated grant expense: share assigned to a grant.
4. 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 QBO line bearing a broad program Class.

GrantLink syncs QBO transactions and supports allocation and review. It also permits multiple Classes or subclasses to link to one grant. This matters when one award funds several functions: missing valid tracking links can understate spend even though the general ledger is complete.

Remaining balance is a family of formulas

Use precise labels:

Question	Recommended measure
How much award authority is not yet used?	Award ceiling − eligible cumulative spend
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	Award capacity remaining
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 QBO deposits;
• revenue detail tied to QBO, including JEs;
• QBO-backed expense allocation detail;
• 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, QBO 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.

Boards

Show a concise portfolio view, but define every balance. “$295,000 award capacity remaining; $45,000 of eligible costs ahead of cash collections” is more useful than one unexplained green balance.

Month-end control checklist

• Award amount agrees to executed documents and approved amendments.
• Prospective and conditional amounts are labeled separately.
• Fund receipts tie to QBO deposits and remittance evidence.
• Split and unapplied receipts are resolved or listed.
• Recognized revenue ties to QBO income detail and reviewed JEs.
• Expense population covers the full period and all linked dimensions.
• Allocation statuses and shared-cost methods are reviewed.
• Eligible spend is distinguished from total book expense.
• Claims submitted and cash paid are tracked separately.
• Every remaining balance displays its formula.
• Funder workbook current and cumulative columns recalculate.
• CPA and funder questions are documented rather than guessed.

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.
• QBO tag = eligible spend: tagging identifies scope, not allowability.
• Revenue − expense = remaining award: this answers a different question.
• One QBO 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.