How Nonprofits Should Track Restricted Funds

Most nonprofits managing more than two active grants encounter the same restricted fund tracking problem: a spreadsheet that works cleanly for one award becomes a liability when a second and third arrive with different expense categories, reporting periods, and indirect cost rates. By month-end close, the finance manager is manually reconciling three budget-to-actual columns while chasing receipts across program staff.

Why Restricted Fund Accounting Breaks Spreadsheets

The Financial Accounting Standards Board's ASC 958 requires nonprofits to classify net assets as either donor-restricted or unrestricted. In practice, that requirement cascades into a separate tracking obligation for every active grant: each award has its own approved budget categories, its own allowable indirect cost rate, and its own drawdown schedule tied to a funder's fiscal calendar.

A spreadsheet handles one grant cleanly. At three, the complexity compounds. Expense allocations must be split across programs, shared staff salaries require percentage-of-time documentation, and any budget modification requires parallel updates across linked cells. A formula error in the allocation column does not announce itself. It waits until an interim report is due.

Consider a 12-person literacy nonprofit managing three simultaneous awards: one federal workforce literacy grant, one state-level contract, and one private foundation grant. Each carries different fringe benefit rates, different indirect cost allowances, and different expense category labels. Managing all three in a single Excel workbook puts the finance director one accidental paste operation away from misreporting to a federal program officer.

The Four Numbers Every Active Grant Needs

Regardless of how many grants a nonprofit manages, each award needs the same four numbers visible at any point in the grant period:

• Grant balance remaining by category: Total award minus cumulative expenditures, broken out by approved line item, not just in aggregate.
• Monthly burn rate vs. budget pace: If a grant runs 18 months and it is month 10, the organization should have spent roughly 55 percent of the total. A burn rate at 35 percent in month 10 often signals funds at risk of being returned or recaptured at close.
• Days to next reporting deadline: Funder reports trigger drawdown requests on cost-reimbursement grants. A missed deadline delays cash flow.
• Category-level variance: Federal grants treat unexpended budget by category as a compliance matter. Spending beyond an approved line item typically requires a prior approval request from the program officer before the expenditure is made.

These four numbers are the minimum viable view for grant management. Without them, a finance director is reacting to problems rather than preventing them.

The Grant Ledger View: A Four-Column Framework

For nonprofits managing up to five active grants, a structured tracking approach called the Grant Ledger View organizes each award into four columns reviewed at least monthly.

Column A: Approved Budget by Category. The exact line-item budget as approved by the funder. This does not change unless the organization files a formal budget modification request.

Column B: Actuals to Date by Category. Cumulative expenditures charged to the grant through the current accounting period. This figure should be pulled from the accounting system, not estimated from receipts.

Column C: Remaining Balance per Category. Column A minus Column B. A negative number in any row is an immediate compliance flag requiring action before the next expenditure is approved in that category.

Column D: Projected Spend Through Period End. A forward-looking estimate based on current burn rate and known upcoming commitments: contracted services, payroll, planned purchases. This column answers the question: will there be unexpended funds at grant close, and if so, in which categories?

The Grant Ledger View is not a cash flow statement and not a general ledger report. It is a grant-specific management tool that sits between the accounting system and the funder report.

When the Ledger Becomes a Dashboard Problem

The Grant Ledger View works in a spreadsheet when one person owns all grant tracking and all grants share a consistent indirect cost structure. It breaks down under three conditions.

First, when multiple staff split time across grants. Percentage-of-time allocations need updating every pay period. A spreadsheet updated quarterly creates retroactive corrections that distort both the burn rate column and the category balances, sometimes for months.

Second, when program directors need real-time visibility without accessing the finance manager's workbook. Staff making hiring, subcontract, or purchasing decisions need to know the grant balance before the commitment is made, not after the month-end close.

Third, when a funder requires monthly interim reporting on a cost-reimbursement basis. That pace requires actuals to be clean, reconciled, and accessible within days of period close, not weeks.

A workforce development organization running three federal grants illustrates the breaking point. The finance manager had built a competent tracking system, but when a second program director began entering purchase commitments independently, the workbook stopped reflecting reality within two weeks of each period close. A category overspend on a Department of Labor Workforce Innovation and Opportunity Act grant was caught only six weeks before the reporting deadline, leaving too little time to file a proper budget modification request.

Connecting Grant Tracking to Board Reporting

Grant balance data belongs in board reporting, and most nonprofit boards see it too rarely and too late. A finance committee reviewing grant status quarterly is working with numbers already 45 to 90 days old. For an organization where restricted grants represent the majority of revenue, that lag is a governance risk.

A useful board-level grant summary requires only three elements: total restricted revenue committed across all active grants, total restricted expenditures to date against that committed amount, and a list of grants within 60 days of a reporting deadline or grant close. That summary does not require a complicated system. It requires that the underlying Grant Ledger View data is current when the board packet is assembled.

The National Council of Nonprofits publishes guidance on sound financial management, including the expectation that board members understand the difference between restricted and unrestricted funds and monitor both. Most boards receive operating results. Restricted fund status arrives as a footnote.

What a Connected Dashboard Adds

A dashboard connected to accounting data adds three things a spreadsheet cannot provide sustainably.

Automated period-over-period comparison surfaces burn rate trends without the finance manager manually calculating last month's figures alongside this month's. Category variance flags appear at a glance rather than requiring a column-by-column audit.

Alert logic allows the system to surface a flag automatically when any grant category balance crosses below a defined threshold. A remaining balance of 15 percent with more than 30 days left in the grant period is a warning that should not require someone to remember to check.

Shared read access lets program directors and the executive director view grant status without touching the source data, removing the finance manager from the role of on-demand report generator.

MyDashBorg builds restricted fund tracking dashboards for nonprofits from templates designed for grant management, without requiring finance staff to configure the tool. Explore available templates or review tier options at our pricing to see what fits.