A financial dashboard is a one-page (or two-page) summary of your organization's financial health. It shows the metrics that matter most, updated monthly, so your board can stay informed without drowning in spreadsheets.
The goal: help your board spot problems early and make strategic decisions based on financial reality, not emotion or assumption.
Core Metrics Every Board Should Track
1. Cash Balance — How much money is in your bank account right now? This is the single most important metric. Many nonprofits look profitable on paper but are out of cash in reality.
Track: Opening balance, deposits in, spending, closing balance. Also track: days of operating expenses in reserve (divide cash by monthly expenses). Aim for 3-6 months.
2. Revenue vs. Budget — How much have you raised versus what you predicted? Track by month and year-to-date. If you're at 75% of the year but only 50% of budgeted revenue, you have a problem.
3. Expenses vs. Budget — Are you spending what you budgeted? Under-spending might mean you're not delivering programs. Over-spending might mean you're running out of money.
4. Restricted vs. Unrestricted — How much of your cash is restricted (must be spent on a specific program/grant) versus unrestricted (can use for anything)? You might have $100K in the bank but only $10K unrestricted. That matters.
5. Program vs. Administrative Costs — What percentage of revenue goes to programs versus overhead? Funders and donors care about this. Track: if 70%+ of spending is program, that's strong.
6. Cash Flow Projection — Where will you be in 3 months if nothing changes? Do you have a big grant coming in? Big expense? This helps you anticipate problems.
A Simple Dashboard Template
Here's a monthly dashboard any treasurer can create in a spreadsheet:
Cash Position (as of [date])
| Opening cash balance | $XX,XXX |
| Deposits this month | $X,XXX |
| Spending this month | $(X,XXX) |
| Closing balance | $XX,XXX |
| Months of runway | X.X months |
Year-to-Date Revenue
| Budgeted revenue | $XXX,XXX | 100% |
| Actual revenue | $XX,XXX | XX% |
| Variance | $(X,XXX) | -X% |
Top Revenue Sources (YTD)
| Individuals (donations) | $XX,XXX | XX% |
| Grants | $XX,XXX | XX% |
| Program revenue | $X,XXX | X% |
Year-to-Date Spending
| Budgeted spending | $XXX,XXX | 100% |
| Actual spending | $XX,XXX | XX% |
| Variance | $(X,XXX) | -X% |
Spending by Category (YTD)
| Program | $XX,XXX | XX% |
| Administrative | $X,XXX | X% |
| Fundraising | $X,XXX | X% |
Key Notes: [2-3 bullets about what's notable this month]
Red Flags That Require Board Action
Cash below 1 month of expenses. If you're down to less than 30 days of operations, you need an emergency board meeting. This is crisis territory.
Revenue more than 25% behind budget. If it's August and you've only raised 50% of annual revenue, you need a conversation about whether you can hit your budget or need to cut spending.
Spending more than 10% over budget. If you're tracking to spend more than projected, you'll run out of money. Cut spending or find more revenue.
Restricted funds growing without being spent. If you have $50K in restricted grants that you haven't spent, either you're behind on program delivery or the restriction is unclear. Either way, investigate.
One funder representing more than 30% of revenue. Over-dependence on one funder is risky. If they cut you, you're in trouble. Diversify or build unrestricted reserves.
How to Present Your Dashboard to the Board
1. Send it before the meeting. Board members need time to digest numbers. Send the dashboard 3-5 days before the meeting with a brief explanation.
2. Highlight the story, not every number. Don't read the dashboard line by line. Hit the highlights: "Cash is strong at 4 months runway," "Revenue is tracking slightly ahead of budget," "We had an unexpected $5K emergency repair that we're adjusting for next month."
3. Use visuals. A chart is better than numbers for quickly understanding trends. Show a 12-month cash projection graph. Show revenue by source as a pie chart.
4. Flag issues clearly. If something needs board discussion or decision, call it out explicitly: "Cash flow projection shows we'll dip below 2 months in June. We need to either accelerate grant revenue or reduce July expenses."
5. Connect to mission. Numbers matter only if they connect to mission delivery. "Strong cash position means we can hire the summer program coordinator ahead of schedule." "Revenue shortfall means we need to reduce the fall program scope."
Building Your Dashboard
Start simple. Most nonprofit treasurers spend 2-3 hours monthly building a dashboard. If you have accounting software, much of this can be automated (QB and Aplos both support dashboard reports).
For related guidance, see Lecture 1.4.1 and Lecture 1.4.2. And see Lecture 1.4.4 for other financial protections.