First page of the Restricted Funds TrackerExcel workbook preview

Nonprofit finance (Form 990)

Restricted Funds Tracker

Restricted funds tracker in Excel: donor restrictions by fund, releases log, balances, spend-by dates and a tie-out to Form 990 Part X line 28.

Excel workbook · 17 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

A restricted funds tracker lists every gift or grant that a donor limited to a purpose, a time period or permanent holding, and shows how much of each has been spent and what remains. Auditors test it against the net assets with donor restrictions in the financial statements, grantors ask for it in reports, and the board needs it to know which cash is free to use. Form 990, Part X, line 28 reports the same total, so the tracker is also a working paper for the return.

The workbook has three working sheets. The register holds one row per restricted gift with its restriction type, key date and acknowledgment status. The Releases log records each release with the expense it funded, so balances update by formula. The Summary sheet totals balances by restriction type and status and reconciles them to the general ledger. It rests on the free IRS Form 990 instructions for Part X and IRS Publication 1771 on donor acknowledgments.

Who it is for

The nonprofit finance manager or bookkeeper asked by the auditor or the board for a list of donor-restricted gifts, what has been spent and what is left.

What is inside

  • Restricted Funds register with 11 worked funds and 20 blank formatted rows
  • Released to date pulled from a Releases log by formula, with balance and days to the key date calculated on every row
  • Status by formula: open, fully released, spend-by within 90 days, past spend-by date, not yet available, time passed or held in perpetuity
  • Releases sheet with 11 sample releases, 24 blank rows, a fund ID dropdown and a Form 990 Part IX line column
  • Acknowledgment column that highlights gifts of USD 250 or more with no written acknowledgment sent (IRS Publication 1771)
  • Summary sheet by restriction type and status, releases in a chosen year and a reconciliation to the general ledger and Form 990 Part X, line 28
  • Dropdowns, conditional formatting, freeze panes, filters and print fit on every working sheet

How to use it

Enter every open donor-restricted gift on the Restricted Funds sheet, then log each release on the Releases sheet as the money is spent.

Files

  • XLSXrestricted-funds-tracker.xlsx17 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

What is the difference between a purpose restriction and a time restriction?

The Form 990 instructions describe donor restrictions that require resources to be used after a specified date, which are time restrictions, or used for a specified purpose, which are purpose restrictions, or both. Donors can also require that assets be preserved and invested to provide a permanent source of income. The tracker records each type and calculates a status that fits it.

When should a restricted gift be released?

A purpose restriction is released when the organization spends money on the purpose the donor specified, and a time restriction when the stated time has passed. This tracker records each release with its date, the expense funded and the approver, so the auditor can trace the release to evidence. Agree the timing rules with your auditor.

Does a restricted grant need a donor acknowledgment letter?

IRS Publication 1771 says a donor cannot claim a deduction for any single contribution of USD 250 or more without a contemporaneous written acknowledgment from the charity. Many government grants and contracts do not involve a deductible gift, so the tracker lets you mark them as not needed, and it highlights any gift of USD 250 or more marked as not sent.