TLDR
An Executive Director does not need a balance sheet to manage restricted funds. They need to know: how much restricted money do we have, which grants are at risk, when are reports due, and are any restrictions about to expire unused. A well-designed restricted funds dashboard answers those four questions in a single view. The challenge is designing it to be useful at a board meeting and actionable at a staff meeting.
Executive Directors do not fail at restricted fund management because they do not care about compliance. They fail because nobody designed an information system that makes the right things visible without requiring a finance degree to read.
A finance director who works with restricted funds daily knows what the balance is on every active grant. An ED who gets that information twice a year at audit time, and once a month in a financial report that requires context to interpret, is flying on partial information.
The restricted funds dashboard is the bridge. It translates the finance department’s working knowledge into a management-ready view that supports the decisions an ED actually makes.
The Four Questions That Drive the Design
Before building anything, clarify what decisions the dashboard will support. Most EDs need answers to four questions:
How much restricted money do we have, by fund? This is the basic inventory - what obligations exist and what balances are available to fulfill them.
Are any grants in trouble? Not “is anything wrong in the general ledger?” but specifically: is there a grant where spending is not on pace, a budget line that has been over-spent, or a reporting deadline about to be missed?
What is due soon? Funder reports, drawdown requests, program officer meetings - the obligations that have to happen on specific dates whether the organization is ready or not.
Are any funds about to expire with money left? This is the most actionable question on the dashboard because there is still time to do something about it - if the ED sees it soon enough.
Build the dashboard to answer those four questions. Everything else is detail that finance needs but the ED does not.
What Finance Tracks vs. What the ED Needs
Finance tracks the underlying data: individual journal entries, allocation percentages, indirect cost rate calculations, chart of accounts coding, period-end reconciliation. This is correct and necessary. It is not what belongs on the ED dashboard.
The dashboard summarizes the finance team’s work into a management view. A restricted fund balance on the dashboard is not the same as the fund balance in the general ledger - it is a calculated summary that the finance team has verified and certified as accurate. The ED trusts the number because the finance team stands behind it, not because she can audit it herself.
This distinction matters for dashboard design. Finance staff want dashboards that show them where to look for problems. EDs want dashboards that show them what requires a decision. Design for the decision-maker’s needs, not the analyst’s needs.
The Board Meeting Version
Once the ED is using the restricted funds dashboard, the next request is usually a board-ready version. Boards have fiduciary responsibility for restricted fund management but do not need operational detail.
The board version shows: total restricted fund balance (with fund-level detail available on request), compliance status narrative (“all funds within approved budget parameters” or “one fund with low burn rate under review”), reporting deadlines for the quarter, and any material risks that require board awareness.
At a board meeting, this information takes three to five minutes to present - not the twenty minutes that a detailed financial report requires. Board members can ask follow-up questions if they want detail; the dashboard gives them enough to fulfill their oversight responsibility without putting them in the position of managing compliance directly.
The Weekly Maintenance Habit
The dashboard is only useful if it is current. An ED who opens the restricted funds dashboard on Monday and finds data from the previous Thursday is making decisions based on stale information.
The weekly update is a fifteen-minute process for a finance staff member who is already maintaining the fund records in the accounting system. Post any new transactions, update reporting deadline statuses, check whether any risk flags are newly triggered, and mark the dashboard as reviewed with the current date.
This is not a time-consuming process. It requires discipline - the same discipline as any other weekly reporting practice. When it is built into the close-of-week routine, it becomes automatic. When it is not built in, the dashboard becomes unreliable and eventually stops being used.
The cost of the dashboard being accurate is fifteen minutes per week. The cost of it being inaccurate - an expiring grant discovered too late, a compliance problem not caught until audit - is significantly higher.
Free resource
Get the Restricted Funds Release Calculator
A worksheet for calculating when and how restrictions are released: fund name, restriction type, release conditions, eligible expenses to date, amount releasable, documentation required, and journal entry reference - with ASC 958 release-from-restriction guidance. Delivered by email.
- Temporarily restricted net assets
- Funds restricted by a donor or funder to a specific purpose or time period. They become available for unrestricted use when the restriction is satisfied. For grant-funded nonprofits, most active grants fall into this category.
DEFINITION
- Board-designated funds
- Funds set aside by board action for a specific purpose. These are not donor-restricted - the board can rescind the designation. They appear in the unrestricted net asset class, not the restricted class. A common dashboard error is showing board designations as restricted funds.
DEFINITION
- Award end date vs. budget period end date
- The award end date is when the grant agreement expires. The budget period end date may be the same or, for multi-year grants, the end of the current budget period within a longer award. For spend-down monitoring, the relevant date is the budget period end date - that is when unspent funds in the current budget period must be spent or requested for carry-forward.
DEFINITION
Q&A
What is the most important thing an ED should see on a restricted funds dashboard?
The most important indicator is expiring funds with unspent balances. An ED who can see that Grant X has $35,000 remaining with 60 days left in the award period can act: authorize additional program spending on approved activities, initiate a no-cost extension request, or begin a conversation with the program officer. An ED who discovers this on day 75 of a 90-day award end period has almost no options.
Q&A
Should the restricted funds dashboard be shared with the board?
A simplified version should be shared at board meetings as part of the financial report. Boards have a fiduciary responsibility to ensure that restricted funds are managed properly - they cannot fulfill that responsibility without seeing the restricted fund summary. The board version should not include the line-item compliance detail that finance staff need; it should show totals, risk flags, and the compliance status narrative.
Frequently asked