Restricted gifts come with deadlines. A time-restricted grant requires funds to be spent by a specific date. A multi-year pledge releases in installments tied to the calendar. A capital campaign gift may specify that funds must be used for construction within three years of receipt. Missing those deadlines is not an administrative oversight — it is a compliance failure with financial and legal consequences.
A restricted fund aging report tracks every donor-restricted balance by age, deadline, and remaining balance, ensuring your organization meets spending requirements on time and avoids the compliance violations that come from missing donor-imposed deadlines. For organizations managing multiple restricted funds simultaneously, this report is as important to review as the monthly bank reconciliation.
Why Deadlines Get Missed
The mechanisms by which restricted fund deadlines get missed are predictable.
The restriction lives in a document, not the accounting system. The grant award letter or gift agreement specifying the deadline is in a file folder or email archive. No one entered the deadline into the accounting system. No one is monitoring it. The Controller discovers the deadline has passed while assembling the audit package.
Staff turnover breaks the institutional knowledge chain. The Controller who accepted the original grant knew the deadline. Their replacement did not know to look for it. The restriction expires unnoticed.
Portfolio growth outpaces manual tracking capacity. When an organization manages three restricted funds, a spreadsheet tracking deadlines is manageable. When it manages 25, that same spreadsheet is a compliance liability — too complex to maintain accurately, too important to let slide.
Cash management decisions obscure fund balances. When restricted cash is commingled with operating cash and balances are tracked only in a spreadsheet, the effective balance of any individual restricted fund is unclear. The deadline arrives, and the organization discovers it has spent the restricted cash on operating needs without realizing it.
The Anatomy of a Restricted Fund Aging Report
A useful restricted fund aging report includes these elements for every active restricted fund:
- Fund name and donor / funder
- Original restricted amount
- Date received
- Restriction type (purpose, time, or both)
- Restriction description (what the funds must be used for)
- Spending deadline (the date by which funds must be expended or returned)
- Cumulative expenditures to date
- Remaining balance
- Days remaining to deadline
- Alert status (green: more than 180 days; yellow: 90 to 180 days; red: fewer than 90 days)
The aging element is the days-remaining column. Just as accounts receivable aging shows how long invoices have been outstanding, restricted fund aging shows how much time remains to spend each restricted balance. Funds in the red column require immediate action plans, not a note to review next quarter.
What Happens When a Deadline Is Missed
Missing a restricted fund deadline triggers consequences that vary by restriction type and donor relationship, but none of them are good.
Return of funds. Many grant agreements explicitly require unspent funds to be returned at the end of the grant period. If the cash has already been spent on other purposes, you face either a breach of the grant agreement or a cash flow emergency to make the return.
Audit findings. Single Auditors and financial auditors look for restricted fund management compliance. An expired restriction with a remaining balance is a potential finding. Depending on the amount and circumstances, it may be characterized as a significant deficiency or material weakness in internal controls.
Donor relationship damage. Private foundations and individual major donors who impose time restrictions do so for reasons. Discovering that their restriction was missed — and that the organization either spent the funds on unapproved purposes or failed to spend them at all — is among the most serious trust failures in the donor relationship.
Legal exposure. In extreme cases, misuse of restricted funds can trigger regulatory action from state charity oversight agencies. Board members who failed to exercise adequate oversight can face personal liability.
The 90-Day Action Protocol
When a restricted fund enters the 90-day window, a specific set of actions should begin.
Review the remaining balance and spending pace. Is it realistic that the remaining balance can be spent on approved purposes before the deadline? If not, how large is the gap?
Consult the grant agreement or gift documentation. What does the agreement say about unspent funds? Are there provisions for extensions, budget modifications, or return requirements?
Contact the funder or donor proactively. Most funders prefer a proactive conversation about spending challenges over discovering missed deadlines after the fact. A no-cost extension request submitted 60 days before the deadline is a very different conversation from one submitted after the deadline has passed.
Develop an accelerated spending plan. If extension is not possible, identify what program activities can be accelerated to expend remaining funds on approved purposes before the deadline.
Document everything. Any communication with the donor or funder, any decisions made about the fund, and the resolution should be in writing and retained with the fund file.
Building the Aging Report Manually vs. With Software
The manual approach to restricted fund aging is a spreadsheet with a row per fund, a date formula calculating days remaining, and conditional formatting highlighting the warning zones. It works when built carefully and maintained consistently.
The failure modes are predictable: the spreadsheet gets out of sync with the accounting system when expenditures are recorded in the GL but not updated in the tracking sheet; new funds get added inconsistently; the person who maintains it takes vacation during audit season.
The deeper problem is structural. The manual approach creates a parallel tracking system disconnected from the authoritative source of financial truth. The accounting system has the actual expenditure data. The spreadsheet has the deadline data. Connecting them requires manual reconciliation — at exactly the moment when the Finance team is already under maximum pressure.
The Restricted Fund Aging report in sherbertOSOS generates directly from the general ledger. Restriction deadlines are stored as fund attributes at the point of fund setup. Every expense tagged to a restricted fund updates the balance automatically. The report always shows the current balance, the deadline, and the days remaining — without reconciliation between a spreadsheet and the accounting system.
For the broader context of restricted fund compliance, see Donor-Restricted Compliance: Avoiding the Most Common Mistakes. For the grant management lifecycle that intersects with fund aging, see Grant Management for Nonprofits: Tracking, Reporting, and Compliance.
Frequently Asked Questions
What happens if we miss a restricted fund deadline?
Consequences depend on the grant agreement or gift documentation. Common outcomes include required return of unspent funds, audit findings if auditors identify the missed deadline, damage to the donor or funder relationship, and potential regulatory attention for significant violations.
How often should the aging report be reviewed?
Monthly by the Controller or Finance Director. Quarterly by the Finance Committee. Funds entering the 90-day window should trigger immediate action plans, not wait for the next scheduled review.
Can time restrictions be extended?
Often yes, if requested proactively before the deadline. Most funders and donors are willing to grant extensions when the organization communicates early and honestly about spending challenges. After the deadline, the options narrow significantly.
What is the difference between a time restriction and a purpose restriction?
A time restriction limits when funds can be spent. A purpose restriction limits what funds can be spent on. Many grants carry both. A fund with only a time restriction releases to unrestricted net assets when the time period arrives. A fund with a purpose restriction releases only when expenses meeting the purpose restriction have been incurred.
How should we handle a restricted fund whose purpose has become impractical?
This requires donor consent in most cases, through a process called variance power. Some gift agreements include provisions allowing the organization to redirect funds to a similar purpose if the original becomes impossible or impractical. Without those provisions, a formal conversation with the donor is required before redirecting the funds.
The Bottom Line
Restricted fund management is time-critical in a way that most general accounting activities are not. Accounts payable does not expire. Payroll does not have a compliance deadline tied to donor intent. Restricted funds do, and the consequences of missing those deadlines compound with time.
The organizations that manage restricted fund aging well are not the ones with the best spreadsheets. They are the ones whose accounting systems treat restriction deadlines as live data, surface alerts when deadlines approach, and eliminate the gap between the tracking system and the accounting system.
→ Start a free trial of sherbertOSOS and see how Restricted Fund Aging reporting keeps your compliance deadlines visible and actionable.
Frequently Asked Questions
What happens if we miss a restricted fund deadline?
You may need to return the funds to the donor or negotiate a deadline extension. In severe cases, it can trigger audit findings and damage donor relationships.
How often should the aging report be reviewed?
Monthly by the Controller, quarterly by the Finance Committee. Restrictions expiring within 90 days should trigger immediate action plans.
Can time restrictions be extended?
Sometimes. If you communicate proactively with the donor before the deadline, many will grant extensions. After the deadline, your options are limited.
Related Articles
Try sherbertOS free
See how sherbertOS simplifies your nonprofit operations.