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

"How much is left on this grant?" sounds like one question, but a finance director, a program lead, a funder, and an accountant may each mean something different by it.

On the same date, the award ceiling, the amount promised, cash received, recognized revenue, eligible spending, and the remaining budget can all be different. A useful grant dashboard shows each measure separately, defines it, and shows the formula behind every remaining balance.

The sections below explain how to track each measure, but they are not legal or accounting advice. Your signed award and the funder's policy govern conditions and allowed uses, and your CPA decides how to account for contributions, exchange transactions, receivables, revenue, and net assets.

Measures to keep separate

Measure	Definition	Source of truth
Award	The maximum or approved funding under the signed agreement, including amendments	Award documents
Promise or commitment	The amount promised. Decide whether it is unconditional, conditional, or only expected before you record a receivable or revenue.	Signed terms and your accountant's analysis
Cash received	Money actually deposited for the award	QuickBooks Online bank and deposit records
Recognized revenue	The amount recorded as revenue under your accounting policy	QuickBooks Online general ledger
Expenses or spending	Costs incurred, paid, allocated, or found eligible. Always state which one you mean.	QuickBooks Online and reviewed grant allocations
Remaining	A calculated balance. Name the starting amount and what you subtract.	A formula, not a source document

The award is not cash, cash is not automatically revenue, and revenue is not spending. Spending can exceed cash received on a reimbursement award, and it can trail cash received on an award paid in advance.

Decide the accounting treatment before you choose a balance

Under FASB ASU 2018-08, first decide whether the funder receives commensurate value. If it does, the arrangement is an exchange transaction, which you account for under the revenue guidance for contracts. A benefit to the general public, or progress on the funder's mission, is not by itself commensurate value to the funder. If the funder does not receive commensurate value, the transfer is a contribution.

For a contribution, the accounting depends on its type. Apply your organization's approved policy.

Case	Typical accounting result
Unconditional contribution or unconditional promise to give	Recognize contribution revenue. If you have not collected it, record a receivable, subject to your valuation and collectibility policy.
Conditional contribution, which has both a barrier and a right of return or release	Do not recognize it until you meet the barrier. Cash received in advance is generally a refundable advance, which is a liability.
Exchange transaction paid before you perform	Record the cash and a contract liability or deferred revenue, and then recognize revenue as you meet your performance obligations.
Unconditional contribution with a donor restriction	Recognize it under the contribution guidance, and classify it in net assets with donor restrictions until you meet the time or purpose restriction.
Release of a restriction	Reclassify the amount between net asset classes under your policy. A release is not new cash, and it is generally not new contribution revenue.

A restriction limits how you use the money, but a condition affects whether you are entitled to it, so a condition affects when you recognize revenue. An approved budget, a reimbursement process, a reporting clause, or a payment schedule does not by itself decide the treatment. Keep your accountant's conclusion with the agreement.

Example over several periods

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

Measure	Amount
Award ceiling	$500,000
Amount promised in the funder's schedule	$500,000
Cash received	$160,000
Revenue recognized under the CPA's policy	$205,000
Reviewed eligible spending	$205,000
Total expenses recorded for the grant	$214,000

Recorded expenses are $9,000 higher than eligible spending, for example because $9,000 is waiting for documentation or the funder's policy excludes it. Revenue is higher than cash because, in this example, the nonprofit met the cost-based barriers for $205,000 of eligible spending but has collected only $160,000. The actual accounting depends on the agreement and your policy, and your dashboard must keep the measures separate.

You can calculate several valid balances from these amounts.

Label	Formula	Amount
Ceiling less eligible spending	Award ceiling - eligible spending	$295,000
Ceiling less cash received	Award ceiling - cash received	$340,000
Revenue not yet recognized against the ceiling	Award ceiling - recognized revenue	$295,000
Eligible spending ahead of cash	Eligible spending - cash received	$45,000
Recorded costs pending or excluded	Recorded expenses - eligible spending	$9,000

If you call any one of these balances "remaining," people will misread it, so label the formula in reports. "Ceiling less eligible spending" is a management measure. It does not prove that funding is currently authorized, that cash is available, or that you may incur more cost, because amendments, period and category limits, conditions, and funder approval still apply.

Award and promised amount

Record the signed amount, the amendment history, the period, the restrictions, and the status. Keep applications you have not won and verbal expectations out of confirmed award totals. If a multi-year commitment depends on future appropriations or milestones, separate the total stated commitment from the amount that is currently authorized or unconditional.

An award rollforward looks like this:

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

Do not change the original amount without keeping a record of the amendment. Your grant records can track the full award ceiling even when the accounting treatment differs. Label it as award information, and do not post it as revenue automatically.

Cash received

Cash received is the easiest measure to understand, but it is still easy to record wrong. Record these details for each receipt:

• The amount and date
• The QuickBooks Online deposit or transaction
• The funder and grant
• The payment, draw, or installment reference
• The period covered, if the funder provides it
• Notes about restrictions or conditions
• Any amount that is unapplied or split across grants

One deposit can cover several grants, one grant payment can be part of a combined deposit, and one claim can be paid in installments. Match receipts line by line when you can, and keep the funder's remittance advice.

In GrantLink, a grant's Money received links point to QuickBooks Online income or revenue records. A linked record is not always a cash receipt, and GrantLink does not keep donor records. Confirm cash against QuickBooks Online bank and deposit records and the remittance advice.

Recognized revenue

Recognized revenue is an accounting measure. When you recognize it depends on whether the arrangement is a contribution or an exchange transaction, whether the donor set conditions, and whether you met the barriers or performance obligations.

An unconditional contribution can be recognized before you receive cash, which creates a receivable. Cash received in advance for a conditional contribution can create a refundable advance. An advance payment on an exchange transaction can create deferred revenue or another contract liability. Ask your CPA to define the policy and the entries.

Reconcile recognized revenue to the detail of your QuickBooks Online income accounts, and inspect journal entries. Some reports and tools read only common income forms, e.g., invoices, sales receipts, and deposits. If you record revenue through journal entries, those reports can miss it, so the expense side may reconcile while the revenue side is incomplete.

Inspect each journal entry line by line instead of treating the whole entry as revenue. Revenue credits, revenue debits, deferred revenue or refundable advance lines, receivable lines, and expense lines each mean something different.

Expenses and spending

"Spending" can mean at least four different measures:

1. Recorded expense is the cost recorded in QuickBooks Online.
2. Cash disbursement is the cost paid during the period.
3. Allocated grant expense is the share of a cost assigned to the grant.
4. Eligible or reportable expense is the allocated share the funder accepts under its policy.

Choose one main measure for your dashboard, and show the others in your reconciliation. For grant management, reviewed allocated expense is often more useful than every QuickBooks Online line that has a broad program Class.

In GrantLink, each grant's Expenses links point to QuickBooks Online Customers, Projects, Locations, or Classes. GrantLink includes costs assigned to those records in the grant, and you can allocate other transactions from the Ledger or manually. A synced or allocated line is not automatically eligible under the funder's rules. Allocating a transaction in GrantLink does not change QuickBooks Online.

Remaining balance depends on the formula

Use precise labels.

Question	Measure to use
How much of the award ceiling is left after eligible spending?	Award ceiling - cumulative eligible spending, subject to current authorization and the award terms
How much budget is left in each category?	Current category budget - eligible category spending
How much cash has not arrived yet?	Scheduled or authorized cash - cash received
How much eligible cost is waiting for reimbursement?	Eligible spending - amount claimed or paid, adjusted for rejected amounts
How much does recognized revenue exceed spending?	Recognized revenue - the spending measure you chose
How much of your own cash is funding the grant for now?	Eligible spending - grant cash received, if the result is positive

Do not call recognized revenue minus spending "grant remaining" unless that is the question you mean to answer. The measure can be useful, but it does not show how much of the award is left.

Monthly rollforward

Keep one grant summary with separate columns, and link it to the detail.

Month	Award ceiling	Cash received this month	Cash to date	Revenue this month	Revenue to date	Eligible spending this month	Spending to date	Ceiling less eligible spending
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	$60,000	$205,000	$65,000	$205,000	$295,000

Below the summary, keep these records:

• A log of the award and its amendments
• A receipt register linked to QuickBooks Online deposits
• Revenue detail tied to QuickBooks Online, including journal entries
• Expense allocation detail based on QuickBooks Online transactions
• Budget to actual by funder category
• Claims or invoices and their unpaid balances
• Reconciliation exceptions

Reporting to different audiences

Program leads

Show award capacity, reviewed spending, remaining budget by category, the pace of spending, and known commitments. Do not present cash received as permission to spend.

Finance staff and accountants

Show all of the measures above, receivables or advances under your approved policy, allocation exceptions, links to QuickBooks Online records, and the reconciliation of revenue and expenses.

Funders

Use the exact measure and template the funder asks for. Some funders ask for cash receipts, and others ask for cumulative eligible expenditures, reimbursement claims, or budget to actual. Many funders use strict Excel templates that you must complete in specific cells and sometimes convert to PDF.

In GrantLink, you can upload a funder's Excel workbook or fillable PDF form on the grant's Reporting > Templates page, and the assistant can fill it from your grant data. Before you submit, a person must confirm the date range, formulas, categories, and the funder's definitions.

To create a report, open Chats > New chat. Reports for a grant are listed on the grant's Reporting > Reports page. QuickBooks Online stays your accounting record. GrantLink writes to QuickBooks Online only when an admin allows that type of change in Settings > QuickBooks > Permissions and a user reviews and applies the change. Settings > QuickBooks > Mapping holds shared QuickBooks Online settings, and you set grant links on each grant. GrantLink does not produce donor acknowledgment exports.

Boards

Show a short portfolio view, and define every balance. For example, "$295,000 of the award ceiling is left after eligible spending, subject to the award terms, and $45,000 of eligible costs is ahead of cash collections" tells the board more than one unexplained balance.

Month-end checklist

• The award amount agrees to the signed documents and approved amendments.
• Expected and conditional amounts are labeled separately.
• Fund receipts tie to QuickBooks Online deposits and remittance advice.
• Split and unapplied receipts are resolved or listed.
• Recognized revenue ties to QuickBooks Online income detail and reviewed journal entries.
• The expense population covers the full period and all linked QuickBooks Online records.
• Allocation statuses and methods for shared costs are reviewed.
• Eligible spending is shown separately from total recorded expense.
• Claims submitted and cash paid are tracked separately.
• Every remaining balance shows its formula.
• Current and cumulative columns in the funder workbook recalculate correctly.
• Questions for the CPA and the funder are documented instead of guessed.

Common dashboard mistakes

• Treating the award as revenue. The award record does not decide when you recognize revenue.
• Treating a deposit as revenue. Cash timing and revenue timing can differ.
• Treating a QuickBooks Online tag as eligible spending. A tag shows scope, but it does not show that a cost is allowable.
• Treating revenue minus expense as the remaining award. The result answers a different question.
• Treating a restriction release as revenue or cash. A release reclassifies net assets under your policy, and it brings in no new money.
• Assuming one QuickBooks Online record equals one grant. Real QuickBooks Online files can mix Customers and Projects or use many sub-classes.
• Assuming a successful sync means complete history. A limited date range can leave out older transactions that have not changed.
• Showing one total to every audience. Management, accounting, and funder reports use different definitions.

Use a consistent set of terms so that every number keeps its meaning and traces to evidence.

Sources

• FASB ASU 2018-08 covers commensurate value, conditional contributions, barriers, and rights of return or release.
• FASB ASU 2016-14 covers net assets with and without donor restrictions and how releases are presented.