Restricted Fund Reconciliation Template Guide

A restricted fund reconciliation template is a bridge between the donor or grant agreement and the financial statements. It should show why a restricted balance exists, what changed this month, and what amount is still restricted.

Many nonprofits try to use bank balance as the shortcut. That can mislead the team. A restricted balance may include an unpaid receivable. It may also be lower than cash if the nonprofit received an advance and has already met part of the restriction.

The template should explain the balance, not just store it.

Start with one row per fund or grant

Each restricted purpose needs a clear row. Use one row for each grant, donor restriction, or restricted fund that finance tracks separately.

Recommended setup fields:

• Fund or grant name
• Donor or funder
• Restriction type
• Award or gift amount
• Grant or gift period
• Payment terms
• Report due dates
• Owner
• Current status

The restriction type matters. A purpose restriction is met by doing the approved work. A time restriction is met when the date or period arrives. A conditional grant is different. Under FASB ASU 2018-08, conditions affect when contribution revenue is recognized. Do not treat a condition as a normal restriction until the accounting review supports that treatment.

For that question, link to the deferred revenue vs conditional grants guide.

Build the monthly movement section

The core of the template is a simple rollforward:

Beginning restricted balance
+ New restricted revenue
+ Corrections into restricted balance
- Releases from restriction
- Corrections out of restricted balance
= Ending restricted balance

Add columns for cash and receivables beside the rollforward. Do not mix them into the net asset calculation unless the accounting entry calls for it.

Use separate columns for:

• Cash received this month
• Cash received to date
• Receivable recorded
• Receivable collected
• Open receivable
• Qualifying expenses
• Release amount
• Ending restricted balance

This format helps finance explain why cash, revenue, receivables, expenses, and restrictions do not always move together.

Tie the template to the ledger

Every amount in the template should tie to a report or journal entry. Use account numbers, grant codes, fund codes, or class codes that match the chart of accounts.

For each row, include links or references to:

• General ledger detail
• Cash receipt detail
• Accounts receivable detail
• Expense detail
• Payroll allocation support
• Release journal entry
• Correction entry, if any

If the template lives in a spreadsheet, add a source column. If it lives in a system, attach or link the support. GrantPipe can help keep grant documents, ledger-facing categories, and reporting views in one place, but finance still needs to approve the logic.

Add a release check

Restricted funds often go wrong when releases are missed or posted too early. Add a release check column with one of these statuses:

• Not ready
• Ready to release
• Released this month
• Partially released
• Needs review

The reviewer should ask why the status is true. If the restriction was met by expenses, tie the release to qualifying expense detail. If it was met by time, tie it to the date. If both time and purpose apply, both must be satisfied.

The release from restriction journal entry guide gives a plain debit and credit example.

Show exceptions clearly

The template should surface problems, not hide them. Add an exception column for items such as:

• Negative restricted balance
• Cash received with no agreement
• Expenses outside the grant period
• Receivable older than expected
• Release with missing support
• Budget line overspent
• Conditional amount recorded too early
• Grant file missing approval

Each exception needs an owner and due date. Avoid vague notes like “researching.” A stronger note says, “Finance will ask the program director for June payroll support by July 8.”

Connect to board reporting

The board does not need the whole template. It needs a short summary of material restricted balances and risks.

A board-ready summary can show:

• Total net assets with donor restrictions
• Largest restricted balances
• Grants waiting on reimbursement
• Funds that may expire soon
• Restricted cash pressure
• Open errors or missing support

This supports the finance committee without burying them in ledger detail. FASB ASU 2016-14 focuses nonprofit reporting on net assets with and without donor restrictions. A good template helps the board understand those balances before the audit.

Keep the template boring

A useful template is repeatable. Do not make it so complex that only one person can use it.

Use the same columns each month. Lock formulas. Save support in the same folder. Review exceptions before the month is closed. Tie the final ending balance to the statement of financial position and the net asset rollforward.

Then keep improving the process. If the same error appears every month, fix the source. The best reconciliation is not the one with the most tabs. It is the one that helps finance catch errors while there is still time to correct them.

DEFINITION

Restricted fund reconciliation

A schedule that proves restricted fund activity and ending balances agree with donor or grant terms and the general ledger.

DEFINITION

Ending restricted balance

The amount still reported as restricted after new activity, releases, corrections, and spending are reviewed.