Most nonprofit boards make financial decisions based on fragmented information. The treasurer reports quarterly. The director mentions in an aside that cash is tight. Someone asks if we're on budget but no one has updated the budget in eighteen months. By the time the board realizes there's a problem, the organization is in crisis mode.
A financial dashboard prevents this. It's a one or two-page monthly snapshot that shows the few metrics that actually matter: cash, revenue versus budget, spending by category, and cash flow outlook. The board reviews it, asks questions, and has real-time visibility into financial health. Early warning signs become apparent months before they become crises.
This article explains which metrics matter most, how to build a dashboard that takes less than two hours monthly to maintain, and how to present financial information in a way that drives board discussion instead of creating confusion.
The Eight Metrics That Actually Matter
1. Cash balance and runway. This is the metric that determines organizational survival. You can be profitable on paper and insolvent in practice if donors haven't paid pledges or if restricted grants sit unspent. Track your current cash, the opening cash, deposits, and spending for the month. More importantly, calculate "runway"—how many months of operations your cash supports.
To calculate runway, divide your current cash balance by your average monthly spending. If you have $50,000 in the bank and spend $10,000 monthly, you have 5 months of runway. If you have $30,000 and spend $15,000 monthly, you have 2 months. Boards should aim for 3-6 months of runway; 1-2 months is precarious; below one month is a crisis trigger.
2. Year-to-date revenue versus budget. This simple metric shows whether you're fundraising on pace to hit your annual goal. If you're in August (two-thirds through the year) but only halfway to your revenue goal, something is wrong. You need either more revenue (unlikely at this point) or expense cuts (painful but necessary).
The variance matters—both the dollar amount and the percentage. "We're $30,000 behind" is harder to interpret than "$30,000 behind and running at 70% of plan." The percentage version makes it obvious whether you're in minor trouble (5-10% behind is normal variance) or serious trouble (25%+ behind needs intervention).
3. Year-to-date spending versus budget. Overspending is the second most common path to a cash crisis. You planned to spend $300,000 for the year but you're already at $200,000 with four months remaining. Either you're over-delivering on programs (good) or you're hemorrhaging money on inefficiencies (bad). Your dashboard should make the difference obvious.
4. Unrestricted cash available. This is where most nonprofits hide problems. You might have $200,000 in the bank but only $20,000 unrestricted; the rest is restricted to programs you haven't delivered yet or endowment you can't touch. Your board needs to see this breakdown monthly. "We have strong cash but most of it is restricted" is important context that changes decision-making.
5. Restricted revenue released versus restricted revenue received. When you receive a restricted grant, you record it as restricted. As you spend on its intended purpose, you release the restriction. This metric shows whether you're actually delivering on restricted funds or hoarding them. If a funder gives you $50,000 for a program and you've only released $10,000, you're either behind on delivery or the program is in trouble.
6. Revenue by source: individual, grants, program, other. This shows whether your revenue portfolio is diversified or concentrated. If 60% of your revenue comes from one funder, that's a vulnerability. If 80% comes from individual donations, you're dependent on annual fund success. The mix matters for strategic planning.
7. Spending by category: program, administrative, fundraising. Funders and donors obsess over the program-to-overhead ratio. "We spend 80% on programs" sounds better than "We spend 70%." But the metric that actually matters is program quality and impact, not the ratio. Still, you need this data because funders require it and donors use it to make giving decisions.
One note: the program-to-overhead split is less important than people think. An organization that spends 85% on programs but wastes money on ineffective activities is less impactful than one that spends 65% on programs but delivers them brilliantly. But the metric exists because it's easy to measure, so track it.
8. Cash flow forecast for the next 3-6 months. This is the forward-looking metric. Given what you know about upcoming revenue (grants you've applied for, fundraising events you've scheduled, seasonal giving patterns) and planned expenses (payroll, programs, rent), where will your cash be in three months? Will you dip below your safety threshold? Will you be flush?
This forecast doesn't need to be precise—it's probabilistic. "Most likely we'll have $40K in June, but if the foundation grant doesn't come through, it could be $20K." This helps the board anticipate needs for credit lines or fundraising pushes.
Building a Dashboard That Works
A good dashboard fits on one or two pages and takes 2-3 hours monthly to maintain. Most of it can be automated through your accounting software (QuickBooks Online and Aplos both support dashboard generation). If you're building it manually, use a spreadsheet template and update it monthly from your accounting records.
Structure your dashboard by section: cash and runway, revenue performance, spending performance, restricted vs. unrestricted breakdown, and forward-looking metrics. Use tables, not paragraphs, for data. Use charts (not tables) for trends—a line graph showing 12 months of cash balance is clearer than a column of numbers.
Include a brief narrative section at the bottom: "Key items this month" with 3-4 bullet points highlighting what board members should know. "Cash is down due to a planned large program expense, but revenue is tracking above budget and we're comfortable with runway." "We received the Q3 grant ($75K) which strengthened our position significantly." "One major donor hasn't given yet this year; we're following up in April."
Color-code your metrics. Green for healthy (cash above 3 months runway, revenue on budget, spending on budget). Yellow for caution (cash below 3 months, revenue 10-20% behind, spending 5-10% over). Red for alarm (cash below 1 month, revenue 25%+ behind, spending 15%+ over). This lets a board member scan the page and immediately see where problems are.
Metrics That Should Trigger Board Conversation
Cash below 2 months of runway. This isn't a crisis yet, but it's a warning. You should be in active discussion about either accelerating revenue (another grant appeal, special event) or cutting non-essential spending. Below 1 month is true crisis—you need an emergency meeting.
Revenue more than 15% behind annual plan. If it's June and you should be at 50% of annual revenue but you're at 40%, you need a conversation. Either your revenue assumptions were wrong (recalibrate for the year) or something is broken (update strategy).
Spending more than 10% over budget. If you budgeted $300K for the year and you're already at $180K (should be at $150K at this point), you're tracking to overspend by $30K. Stopping this requires either cuts or new revenue. Have the conversation now before it gets worse.
Restricted revenue more than 30% of total revenue received but less than 20% spent. This suggests either you're behind on program delivery (concerning) or your restrictions are unclear (also concerning). If someone gave you $100K for a program and you've only spent $30K two years later, you need to understand why.
One funder representing more than 40% of annual revenue. Over-dependence on a single funder is risk. If they cut you or their priorities change, you're in trouble. This isn't an emergency—it's a strategic concern. Use it to drive diversification conversations.
Presenting the Dashboard to Your Board
How you present matters. Send the dashboard to board members 3-5 days before the board meeting with a one-paragraph explanation. Don't make them guess what they're looking at. "Our cash position remains healthy at 4.2 months of runway. Revenue is on pace. Our main focus this month is program delivery of the Q2 grant activities."
In the meeting, don't read the dashboard. Board members can read. Instead, tell the story: "Cash is strong, which is good news because we're accelerating our summer program. Revenue is tracking slightly behind due to delayed grant payments, but we expect to be back on pace by June when the foundation grants arrive. The one concern is that we're spending about 7% more than budgeted on facilities because of the roof repair we weren't expecting. We're absorbing that this year, but next year's budget needs to account for more maintenance."
Use charts instead of tables when possible. A line graph showing 12 months of cash balance trends tells a story faster than numbers in a row. A pie chart showing revenue by source is more intuitive than a table. Visuals help board members (who might not be detail-oriented) grasp the big picture quickly.
If something needs a decision, call it out explicitly. "Cash flow projection shows we'll dip below 3 months in September unless we accelerate grant revenue or defer some expenses. What should we prioritize?" This moves from reporting to strategy—the board's actual job.
From Simple to Sophisticated
Start with a very simple dashboard in a spreadsheet: cash position, revenue vs. budget, spending vs. budget, and key notes. You can build this in 30 minutes monthly. As the organization grows, add sophistication: restricted revenue tracking, cash flow forecasts, program metrics alongside financial metrics.
If you move to accounting software with dashboard features, use them. QuickBooks Online's dashboard and Aplos's reporting both save time by pulling data automatically. You focus on analysis, not data entry. This moves your treasurer from clerical work to strategy work.
The real value of a dashboard isn't the data—it's the conversation it generates. A number by itself means nothing. But a number in context ("We're at 65% of annual revenue with 8 months left") and trend ("This is up from 62% last year") becomes a strategic data point that informs decisions.