Restricted Fund Tracking for Nonprofits

Restricted fund tracking in GrantPipe attaches a ledger to each grant and donor restriction, so the balance you owe the funder is the same number you report to the board. Every disbursement posts against the correct restriction, net asset releases follow FASB ASC 958 categories, and the spend-down report is a query on live data, not a monthly spreadsheet reconciliation.

TL;DR

• Each grant and donor restriction has its own ledger, not a spreadsheet tab
• Net asset releases post automatically when qualifying expenses are allocated, per FASB ASC 958-205
• Over-obligation guardrails block accidental overspend before a period closes
• Spend-down reports run on live data and are exportable as audit evidence
• Pairs with QuickBooks or Sage Intacct; replaces the reconciliation spreadsheet above them

What this feature does

Restricted fund tracking is the system of record for every dollar your organization has accepted with strings attached. A federal grant, a donor-advised fund gift restricted to scholarships, a board-designated reserve: each gets its own fund record, its own start and end dates, its own allowable-expense rules, and its own running balance. When money comes in, it is posted to the restriction. When money goes out, it is allocated against the restriction and the released amount is moved from with-restriction to without-restriction net assets.

The goal is one number. The balance your program director sees, the balance your finance lead reports to the board, and the balance on your next funder drawdown request should all be the same, and should all reflect activity through today, not through last month’s close.

How it works

1. Create the fund record with funder, amount, start date, end date, and restriction type
2. Define allowable expense categories and allocation rules (percentage, dollar cap, or specific GL accounts)
3. As expenses post, allocate them to one or more funds; splits are supported per line
4. The system posts a net asset release journal entry equal to the allocated amount
5. The fund ledger and the restriction report update in real time
6. At funder reporting time, pull the spend-down with underlying transaction detail attached

Who it’s for

Finance leads at $500K to $10M nonprofits who currently maintain parallel spreadsheets for every restricted grant. Executive directors who have been surprised at the audit when a restriction showed a different balance than the board report. Grants managers who have been asked by a program officer for a spend-down and spent two days rebuilding it.

Why GrantPipe built it this way

The team that built GrantPipe came to this problem as builders rather than nonprofit operators, and the pattern was consistent across every finance lead interviewed: the GL tracked debits and credits, the donor CRM tracked the donor, and the restrictions lived in Excel. That seam is where audit findings originate. The architectural choice was to model restrictions as a first-class entity with its own ledger, allocations as a many-to-many between expenses and restrictions, and releases as a derived consequence of allocation. The GL stays the GL. The CRM stays the CRM. The restriction layer sits between them and owns the compliance detail.

What it replaces

• The per-grant spreadsheet tab with a pivot that never matches the GL
• The monthly journal entry to move funds out of restriction
• The two-day scramble to rebuild a funder spend-down
• The audit finding on missing or misclassified net asset releases
• The board report that is two weeks stale by the time it is printed

Start a free trial

Start a trial.