←
AI for Nonprofits
Aware · M23 · lesson 23 of 23 · queued
Preview — browse every lesson free. Enroll to mark lessons complete, open partner links and save your progress. Login & enroll →
📖
in this lesson

The Nonprofit Financial Dashboard: Key Metrics Every Board Should See

10 min

A financial dashboard is a one-page, or at most 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 is not to turn trustees into accountants. It is to help your board spot problems early and make strategic decisions based on financial reality rather than emotion or assumption. Done well, a dashboard turns the treasurer's report from a recitation of line items into a short, honest conversation about what the numbers mean and what, if anything, the board needs to decide.

Why a Dashboard Beats a Financial Statement

Most boards already receive financial information. The problem is the format. A full statement of activities and a balance sheet answer an accountant's questions, in an accountant's order, at a level of detail no volunteer trustee can absorb between the agenda packet and the meeting. Board members either skim them and stay silent, or ask questions about whichever line happens to catch their eye. A dashboard inverts that. It selects a small number of measures, presents each one against a reference point, and leaves the underlying statements available for anyone who wants to go deeper. The statements remain the record; the dashboard is the interface.

That distinction matters for governance, not just for readability. A board's financial duty is to notice trouble in time to act on it, and to allocate resources toward the mission. Neither of those depends on knowing every account balance. They depend on knowing whether cash is holding, whether income is arriving as planned, whether spending is tracking, and whether anything has changed since last month. If your reporting format makes those four questions hard to answer at a glance, it is failing at the one job the board actually needs it to do, no matter how technically correct the statements underneath it are.

Core Metrics Every Board Should Track

The source curriculum identifies six measures that belong on essentially every nonprofit dashboard. They are chosen because each one catches a different kind of failure: running out of money, raising less than planned, spending more than planned, mistaking restricted money for spendable money, drifting away from program delivery, and being surprised by something that was visible months in advance. Together they cover the ordinary ways a small organization gets into financial trouble.

1. Cash Balance

How much money is in your bank account right now? This is the single most important metric on the dashboard. Many nonprofits look profitable on paper but are out of cash in reality, because a pledge recorded as revenue and a grant awarded but not yet paid both improve the surplus without putting anything in the bank. Track the opening balance, deposits in, spending, and closing balance. Then track days of operating expenses in reserve, which you calculate by dividing cash by monthly expenses. Aim for three to six months. That single derived figure tells the board more about survival than any other number you could print.

2. Revenue vs. Budget

How much have you raised versus what you predicted? Track it both by month and year-to-date, because a single weak month can be noise while a year-to-date gap is a trend. The comparison that matters is against elapsed time. If you are at seventy-five percent of the year but only fifty percent of budgeted revenue, you have a problem, and you have it now rather than at year end when nothing can be done about it. Include the variance explicitly on the dashboard so nobody has to do the subtraction in their head during the meeting.

3. Expenses vs. Budget

Are you spending what you budgeted? Boards tend to treat this as a one-sided test, watching only for overspending, but the gap runs both ways. Under-spending might mean you are not delivering programs, which is a mission failure that shows up in the accounts as good news. Over-spending might mean you are running out of money. Either direction deserves a sentence of explanation from whoever owns the budget line. The dashboard's job is to make the variance visible; the discussion's job is to decide whether it reflects timing, a delivery problem, or a genuine change in cost.

4. Restricted vs. Unrestricted

How much of your cash is restricted, meaning it must be spent on a specific program or grant, versus unrestricted, meaning you can use it for anything? This is where a healthy-looking bank balance misleads people. You might be holding a substantial sum of which only a small share is genuinely available to cover payroll, rent, and the ordinary costs of staying open. That matters, and it needs to be on the face of the dashboard rather than buried in a note. A board that reads only the total balance will approve commitments the organization cannot legally fund.

5. Program vs. Administrative Costs

What percentage of revenue goes to programs versus overhead? Funders and donors care about this, and many will ask for it directly, so it is better for the board to see the number monthly than to meet it for the first time inside a grant application. The rough benchmark in the curriculum is that if seventy percent or more of spending is program, that is strong. Treat it as a signal rather than a target to be engineered; the ratio is easy to flatter by reclassifying costs, and a board that pushes it up artificially is trading real infrastructure for a number on a report.

6. Cash Flow Projection

Where will you be in three months if nothing changes? This is the only forward-looking measure on the list, and it is the one that converts the dashboard from a record into a decision tool. Do you have a big grant coming in? A big expense? Layer the known inflows and outflows onto today's cash balance and you can see the dip before you reach it. Most cash crises in small nonprofits were visible a quarter in advance and simply were not looked for, because every other number on the report describes the past.

A Simple Dashboard Template

Here is a monthly dashboard any treasurer can build in a spreadsheet. The layout below uses placeholder values rather than real figures, because the point is the structure: each block pairs an amount with a reference point, so the reader is never left holding a number without a comparison. Keep the same blocks in the same order every month. Consistency is what lets a board member who reads it in four minutes notice that one section looks different from last time.

Cash Position (as of the reporting date)

LineAmount
Opening cash balance$XX,XXX
Deposits this month$X,XXX
Spending this month$(X,XXX)
Closing balance$XX,XXX
Months of runwayX.X months

Year-to-Date Revenue

LineAmountPercent of budget
Budgeted revenue$XXX,XXX100%
Actual revenue$XX,XXXXX%
Variance$(X,XXX)-X%

Top Revenue Sources (Year-to-Date)

SourceAmountShare of revenue
Individuals (donations)$XX,XXXXX%
Grants$XX,XXXXX%
Program revenue$X,XXXX%

Year-to-Date Spending

LineAmountPercent of budget
Budgeted spending$XXX,XXX100%
Actual spending$XX,XXXXX%
Variance$(X,XXX)-X%

Spending by Category (Year-to-Date)

CategoryAmountShare of spending
Program$XX,XXXXX%
Administrative$X,XXXX%
Fundraising$X,XXXX%

Close the dashboard with a short block of key notes, two or three bullets about what is notable this month. This is the part board members read first and remember longest, so write it in plain language: what changed, why it changed, and whether it needs a decision. The tables give the evidence; the notes give the interpretation. A dashboard with tables and no notes forces every reader to construct their own story from the same figures, which is how two trustees leave the same meeting with opposite impressions of how the organization is doing.

Red Flags That Require Board Action

Some readings are not information; they are triggers. Agreeing in advance on what counts as a trigger is what stops a board from debating whether a situation is serious while it gets worse. Write these thresholds into your dashboard so they fire automatically rather than depending on whether anyone happens to notice.

  • Cash below one month of expenses. If you are down to less than thirty days of operations, you need an emergency board meeting. This is crisis territory, and it is not something to hold until the next scheduled quarterly meeting.
  • Revenue more than twenty-five percent behind budget. If it is August and you have only raised half of annual revenue, you need a conversation about whether you can still hit your budget or need to cut spending. The earlier that conversation happens, the more options remain on the table.
  • Spending more than ten percent over budget. If you are tracking to spend more than projected, you will run out of money. There are only two levers: cut spending or find more revenue. Deciding which one, deliberately, is board work.
  • Restricted funds growing without being spent. If restricted grant money is accumulating unspent, either you are behind on program delivery or the restriction is unclear. Either way, investigate, because both explanations carry consequences with the funder.
  • One funder representing more than thirty percent of revenue. Over-dependence on one funder is risky. If they cut you, you are in trouble. Diversify the revenue base or build unrestricted reserves deep enough to absorb the loss while you replace it.

None of these thresholds says the organization has failed. Each says that a decision which is still cheap today becomes expensive if it is deferred. That is the whole argument for monthly reporting rather than annual review: a board that sees a threshold crossed early in the year still has choices about revenue and about spending, while a board that meets the same figure near year end is usually left with only the painful half of those options.

How to Present Your Dashboard to the Board

The dashboard is only half the work. How it reaches the board determines whether it produces a decision or a polite nod. Five practices make the difference, and none of them require more data than you already have.

Send it before the meeting. Board members need time to digest numbers, and nobody absorbs a table for the first time while someone reads it aloud. Send the dashboard three to five days before the meeting with a brief explanation. That window is long enough for people to read it and short enough that they still remember it.

Highlight the story, not every number. Do not read the dashboard line by line. Hit the highlights: cash is strong at four months of runway, revenue is tracking slightly ahead of budget, an unexpected emergency repair landed this month and you are adjusting for it next month. A short narrative does more than a full recitation, because it tells the board where to look.

Use visuals. A chart is better than a column of figures for understanding a trend quickly. Show a twelve-month cash projection as a graph so the dip is visible as a shape rather than a comparison the reader has to perform. Show revenue by source as a pie chart when the point is concentration rather than amount.

Flag issues clearly. If something needs board discussion or a decision, say so explicitly rather than hoping someone notices. For example: the cash flow projection shows a dip below two months in June, so the board needs to either accelerate grant revenue or reduce July expenses. Naming the choice is what converts a report into an agenda item.

Connect to mission. Numbers matter only if they connect to mission delivery. A strong cash position means you can hire the summer program coordinator ahead of schedule. A revenue shortfall means reducing the fall program scope. Trustees who joined for the mission engage with financial questions when the financial question is visibly a mission question, and disengage when it is presented as bookkeeping.

Building Your Dashboard

Start simple. A dashboard that exists and is imperfect beats an elegant one you never finish. Most nonprofit treasurers spend two to three hours monthly building one, and much of that time goes into pulling and formatting rather than analysis. If you have accounting software, a good deal of it can be automated: QuickBooks and Aplos both support dashboard reports, so the recurring work becomes reviewing and annotating rather than assembling from scratch.

Build it in the order the board reads it. Cash first, because that is the survival question. Revenue and spending against budget next, because those explain how cash got where it is. Composition, meaning restricted versus unrestricted and program versus administrative, after that. The projection last, because it is the part the board acts on. Then add your notes. Once the layout is stable, resist redesigning it; the value compounds when the same eyes see the same shape month after month and notice the deviation without being told.

Anti-Patterns

  • Reporting cash without runway. A bank balance on its own has no meaning. The same balance is comfortable for one organization and an emergency for another. Always divide by monthly expenses and publish the months figure next to it.
  • Presenting the total balance as if it were spendable. Leaving restricted and unrestricted funds merged in a single line invites the board to approve commitments against money that is legally committed elsewhere. Split the line.
  • Only looking for overspending. Treating under-spend as good news hides stalled program delivery. Both directions of variance need an explanation.
  • Reading the dashboard aloud in the meeting. If the first time trustees see the numbers is during the meeting, the meeting becomes a briefing rather than a decision. Send it in advance and use the meeting for the questions.
  • Backward-looking reporting only. A dashboard made entirely of what already happened cannot prevent anything. The projection is the section that earns the board's time.
  • Engineering the program ratio. Reclassifying overhead to improve the program percentage produces a better-looking report and a weaker organization. The ratio is a signal, not a scoreboard.
  • Redesigning the layout every month. Novelty destroys comparability. Pick a structure, keep it, and let familiarity do the work of spotting changes.

Practice Prompts

  • Take your most recent bank balance and your average monthly expenses and calculate months of runway. Write one sentence stating where that sits against the three to six month range and what you would do first if it fell below one month.
  • Rebuild last month's treasurer's report as the five-block template in this lesson. Time yourself. If it takes far longer than a couple of hours, identify which block is the bottleneck and what would have to change in your bookkeeping to fix it.
  • Split your current cash into restricted and unrestricted. Write down what the unrestricted portion covers in months of operating expenses, then compare that with the figure you would have quoted from the total balance alone.
  • List your revenue sources in descending order and calculate what share the largest one represents. If it exceeds the concentration threshold in this lesson, draft the two sentences you would use to raise it with the board.
  • Draft the key notes block for your current month in three bullets. Show it to someone who does not work in finance and ask them to tell you what the organization should do next. If they cannot, rewrite the notes rather than the tables.
  • Sketch a three-month cash flow projection using only inflows and outflows you already know about. Mark the lowest point. Decide now what action you would take if that point arrived.

Reflection

Think about the last time your board discussed finances. How much of the meeting was spent establishing what the numbers were, and how much was spent deciding what to do about them? The ratio between those two is a fair measure of whether your reporting format is working. If most of the time went into explanation, the problem is upstream of the discussion. Consider also which of the six core metrics your board currently could not answer without looking something up, and what would have to change, in the bookkeeping or in the reporting habit, for that answer to be available every month without a scramble.

Glossary

  • Financial dashboard. A one-page or two-page monthly summary of the metrics that most affect financial health, designed for board reading rather than accounting completeness.
  • Runway. The number of months of operating expenses your current cash would cover, calculated by dividing cash by monthly expenses.
  • Operating reserve. Unrestricted funds held deliberately to absorb shortfalls, usually expressed in months of expenses rather than as an amount.
  • Restricted funds. Money that must be spent on a specific program or grant purpose and is therefore not available for general operating costs.
  • Unrestricted funds. Money the organization may use for any legitimate purpose, including payroll, rent, and other core costs.
  • Variance. The difference between a budgeted figure and the actual result, shown for both revenue and spending and readable in either direction.
  • Year-to-date. The cumulative total from the start of the fiscal year to the reporting date, used to compare progress against elapsed time.
  • Cash flow projection. A forward view of expected inflows and outflows applied to today's cash balance, used to find future shortfalls while they are still avoidable.
  • Program ratio. The share of spending devoted to programs rather than administration or fundraising, watched closely by funders and donors.
  • Funder concentration. The share of total revenue coming from a single funder, used as a measure of exposure if that funder withdraws.

The dashboard sits on top of your bookkeeping, so the quality of the underlying records determines how quickly you can produce it. For the account structure and fund treatment that make these metrics straightforward to pull, see Nonprofit Accounting 101: Fund Accounting, Chart of Accounts, GAAP. For the software decision that determines how much of the dashboard can be automated rather than assembled by hand, see Choosing Accounting Software: QuickBooks vs Aplos vs Wave vs Sage. And for the other side of financial protection, the risks that a healthy balance sheet alone will not cover, see Nonprofit Insurance 101: D&O, Liability, Cyber, Event Coverage.

Closing

A dashboard is a governance tool disguised as a spreadsheet. Its purpose is to give a group of volunteers who meet occasionally enough financial understanding to notice trouble early and to allocate resources with confidence. That takes six metrics, a stable layout, a handful of agreed thresholds, and a few honest sentences of interpretation. It does not take more detail. If your board currently receives more financial information than it can use and less financial understanding than it needs, the fix is not another report; it is one page, sent early, that says what the numbers mean.

Key Takeaways

  • A dashboard is a one-page or two-page monthly summary built for board comprehension, not an accounting statement in smaller type.
  • Cash balance is the single most important metric, and it only becomes meaningful when converted into months of runway against a three to six month target.
  • Compare revenue and spending against budget and against elapsed time, and treat under-spending as seriously as over-spending.
  • Separate restricted from unrestricted cash on the face of the dashboard so nobody commits money that is already committed.
  • Agree the red flag thresholds in advance so they trigger action automatically rather than depending on who notices.
  • Include a forward-looking cash flow projection; it is the only section that lets the board prevent something rather than record it.
  • Send the dashboard three to five days ahead, lead with the story, flag decisions explicitly, and tie every number back to mission delivery.

Frequently Asked Questions

Should the dashboard include program metrics or just financial? Ideally both. A complete dashboard includes financial metrics plus program metrics such as how many people were served, program cost per person, and retention rates. But the financial dashboard focuses on money. You might keep a separate program dashboard, or combine them if the board wants a complete picture in one place.

How often should we update the dashboard? Monthly is standard. Some organizations do it quarterly. The faster you track, the faster you can respond to problems. Monthly gives you a good cadence without becoming overwhelming for whoever prepares it.

What if we have seasonal revenue fluctuations? Show both year-to-date figures and a comparison with the same period last year. If you always raise less in summer and more in autumn, your dashboard should reflect that pattern rather than treating it as a variance. Compare May with the previous May, not May with August.

Should we share the financial dashboard with all staff or just the board? Transparency is good. Many organizations share a simplified version with all staff covering total revenue, spending by program, and cash position. This helps staff understand financial reality and make decisions aligned with sustainability. You might keep a more detailed version for the board only.

Who should build the dashboard? Any treasurer can build it in a spreadsheet, and most spend a couple of hours a month doing so. If your accounting software generates dashboard reports, the treasurer's job shifts from assembling figures to reviewing them and writing the notes, which is the part that actually requires judgement.