A SaaS CFO dashboard is one page, refreshed after each monthly close, that shows cash and runway first, then the ARR bridge, then the efficiency ratios (magic number, SaaS quick ratio and burn multiple) that tell the board whether growth spend is working. Every figure on it needs a written definition, one owner and a source system that ties back to the ledger.
This guide covers how to lay out a SaaS CFO dashboard, how to calculate and read the magic number, quick ratio and cash runway, and how often each view should go to the board. It closes with a worked quarter for an example company, with the arithmetic checked in Python. It reflects rules and figures in force as of October 2026.
MRR on its own can rise while the business weakens. Expansion can hide churn, discounting can lift bookings while margin falls, and a large prepaid contract can fill the bank account long before the revenue is earned. A dashboard fixes that by putting the numbers that move in different directions side by side.
The formulas for ARR, net revenue retention (NRR), gross revenue retention (GRR), CAC payback, burn multiple and the Rule of 40 are covered in depth, with their ties to GAAP revenue, in our guide to SaaS financial metrics for finance teams. This page uses those definitions and focuses on how the pieces fit on one screen and which three numbers usually get the least explanation: magic number, quick ratio and runway.
A practical page has four bands, read from top to bottom:
| Band | Metrics | Question it answers |
|---|---|---|
| Cash | Cash balance, monthly net burn, runway in months, cash by bank | How long can the company operate on current plans |
| Growth | ARR bridge (starting, new, expansion, contraction, churn, ending), NRR, GRR | Where recurring revenue came from and where it leaked |
| Efficiency | Magic number, SaaS quick ratio, burn multiple, CAC payback | Whether each dollar of spend is buying durable ARR |
| Margin | Subscription gross margin, operating expense by function | Whether the cost to deliver is scaling with revenue |
Put cash at the top. A board member who reads only the first row should still learn how long the current plan can be funded.
Keep the data model small. Billing data supplies the ARR bridge and churn detail. The CRM supplies new bookings and pipeline. The general ledger supplies cash, gross margin and operating expense by function. Use shared codes for customer, plan, region and product so a churned account in billing matches the same account in the CRM.
Refresh after the books close each month, never mid-month from live billing data. A five-day monthly close checklist gives a realistic timetable for having reconciled numbers by the second week. Revenue figures should match what was recognized under ASC 606, and cash collected ahead of service should sit in deferred revenue so the margin band is not inflated by annual prepayments. For the recognition rules behind subscriptions, setup fees and usage pricing, see SaaS revenue recognition under ASC 606.
Write a definitions page and keep it with the dashboard. The SEC's 2020 guidance on key performance indicators applies only to public company filings, but its checklist is a sound standard for any board pack. The Commission said it would generally expect "a clear definition of the metric and how it is calculated" and added that if a company "changes the method by which it calculates or presents the metric from one period to another," it should consider disclosing the differences. For a private company, that means noting on the dashboard any quarter in which a definition changed, such as moving usage revenue into ARR.
Give each metric one owner and one backup. The owner answers questions about the number before the board meeting, so the meeting itself can stay on decisions.
The magic number estimates how much new recurring revenue each dollar of the prior quarter's sales and marketing spend produced. It uses a one-quarter lag because deals closed this quarter were mostly generated by last quarter's spend.
There are two common versions, and they should give similar answers:
The ARR version needs no multiplication by four, because ARR is already an annual figure. Multiplying a change in ARR by four double counts the annualization and overstates efficiency fourfold. Pick one basis, state it on the definitions page and use it every quarter.
Read the trend before the level. A magic number that falls for three quarters in a row while spend rises usually points to a saturated channel, longer sales cycles or a pricing change that has not landed. As a rule of thumb among operators and investors, a figure near or above 0.75 is read as a signal that more spend is likely to pay off, and a figure well below 0.5 as a reason to examine the funnel before adding budget. No accounting body or regulator sets these thresholds, so treat them as rough guidance and compare your company's figure with its own history first.
Net new ARR in the numerator is already reduced by churn. A company with strong new bookings and heavy churn will show a weak magic number, which is the right result. To separate the two, read it beside gross new ARR and the quick ratio.
The SaaS quick ratio compares recurring revenue added with recurring revenue lost in the same period.
Formula: SaaS quick ratio = (New ARR + Expansion ARR) / (Churned ARR + Contraction ARR)
A ratio of 4 means the company added four dollars of recurring revenue for every dollar it lost. A ratio near 1 means new sales are mostly refilling a leaking base. A common rule of thumb treats 4 as a strong figure for an early-stage company, with the bar easing as the base gets larger and growth slows. It is an operator convention with no official standard behind it, so the company's own trend matters more than the single threshold.
The quick ratio shares inputs with NRR and GRR, so it adds the most value where those retention figures cannot help: it includes new-logo ARR. A company can post a healthy NRR because existing customers expand, while new-logo sales slow. The quick ratio will fall in that case even though NRR looks fine. Use the same period and the same ARR definitions for all four inputs, and show the ratio as a trailing four-quarter line beside the current quarter, since one large churned contract can swing a single quarter.
Formula: Runway (months) = Cash and liquid investments / Average monthly net cash burn
Use net burn from the cash flow statement, averaged over the last three months, so one large annual invoice or a payroll timing difference does not distort the figure. Show a second runway figure using the forward plan, because burn rarely stays flat. Our guide to cash flow scenario planning sets out how to build base and downside cases from the same model, and a rolling forecast keeps that plan current between budget cycles.
Runway also connects to the audit. Under ASC 205-40, in connection with preparing financial statements for each annual and interim period, management should evaluate "whether there are conditions or events, considered in the aggregate, that raise substantial doubt about the entity's ability to continue as a going concern within one year after the date that the financial statements are issued (or within one year after the date that the financial statements are available to be issued when applicable)." The clock starts at the date the statements are issued or available to be issued, which for many venture-backed companies falls months after year end. A company that shows 16 months of runway in September can show fewer than 12 by the time its audited statements are issued the following spring. Add a line to the dashboard that projects runway at the expected issue date.
Cash concentration belongs in the cash band as well. The FDIC states that "FDIC deposit insurance covers $250,000 per depositor, per FDIC-insured bank, for each account ownership category." A SaaS company holding several million dollars in one operating account is almost entirely uninsured, so show cash by bank and by instrument next to the runway figure.
Tax payments feed into burn. For tax years beginning after December 31, 2024, the One Big Beautiful Bill Act lets companies deduct domestic research or experimental expenditures currently under new Section 174A. The same IRS page notes that companies may instead elect to capitalize those costs and amortize them over at least 60 months. For a profitable or near-profitable software company with large engineering payroll, that can lower cash taxes in 2025 and 2026, and the runway model should reflect it. Our explainer on how the One Big Beautiful Bill Act changed Section 174 covers the transition rules.
Example Co is an illustrative B2B software company. All figures below are assumptions for the example. The arithmetic was checked in Python.
| Input, Q3 2026 | Amount |
|---|---|
| ARR at June 30, 2026 | $8,000,000 |
| New ARR | $900,000 |
| Expansion ARR | $400,000 |
| Contraction ARR | $100,000 |
| Churned ARR | $250,000 |
| Sales and marketing expense, Q2 2026 | $1,300,000 |
| Subscription revenue, Q2 2026 | $1,940,000 |
| Subscription revenue, Q3 2026 | $2,180,000 |
| Net cash burn, Q3 2026 | $1,800,000 |
| Cash at September 30, 2026 | $9,600,000 |
| Dashboard line | Calculation | Result |
|---|---|---|
| Net new ARR | 900,000 + 400,000 minus 100,000 minus 250,000 | $950,000 |
| Ending ARR | 8,000,000 + 950,000 | $8,950,000 |
| Magic number, ARR basis | 950,000 / 1,300,000 | 0.73 |
| Magic number, revenue basis | (2,180,000 minus 1,940,000) x 4 / 1,300,000 | 0.74 |
| SaaS quick ratio | (900,000 + 400,000) / (250,000 + 100,000) | 3.71 |
| Burn multiple | 1,800,000 / 950,000 | 1.89 |
| Average monthly net burn | 1,800,000 / 3 | $600,000 |
| Runway | 9,600,000 / 600,000 | 16.0 months |
| Runway if burn rises to $700,000 | 9,600,000 / 700,000 | 13.7 months |
| Cash at expected audit issue date, March 31, 2027 | 9,600,000 minus (6 x 600,000) | $6,000,000 |
| Runway at that issue date | 6,000,000 / 600,000 | 10.0 months |
The two magic number methods agree closely, which is a useful check that the ARR bridge and recognized revenue are consistent. Had the change in ARR been multiplied by four, the result would have been 2.92, a figure that would have suggested sales spend was far more efficient than it is.
A quick ratio of 3.71 says growth quality is reasonable, and a burn multiple of 1.89 means the company burned about $1.89 for each dollar of net new ARR. The line a board would focus on is the last one. Sixteen months of runway today becomes ten months at the date the 2026 audited statements are expected to be issued, inside the one-year window that management should evaluate. That gives the CFO a clear agenda item: start the financing or cost plan now, and document it, so the going-concern evaluation in the spring rests on a funded plan.
The cash band would also show that if the $9.6 million sat at two banks under one ownership category, at most $500,000 would be insured, leaving about 94.8% of cash uninsured.
Matching the cadence to the audience keeps the dashboard useful without turning it into a monthly slide production exercise. A pattern many venture-backed SaaS companies follow:
Investors preparing for a financing round will ask for the same series, so a dashboard kept on consistent definitions shortens investor due diligence. Companies without a full-time finance lead often have a SaaS fractional CFO own the quarterly pack, with the monthly close and ARR bridge handled through outsourced accounting for SaaS.
Close each review by assigning actions to metric owners and logging them next to the dashboard. Over a few quarters, the log shows which actions moved which numbers, and planning gets sharper as a result.
What should a SaaS CFO dashboard include? Four bands work for most companies: cash and runway, the ARR bridge with NRR and GRR, efficiency ratios (magic number, SaaS quick ratio, burn multiple, CAC payback) and gross margin. Each metric needs a written definition and one owner.
How is the SaaS magic number calculated? On an ARR basis, divide this quarter's net new ARR by last quarter's sales and marketing expense. On a revenue basis, multiply the quarter-over-quarter change in subscription revenue by four before dividing. Do not multiply a change in ARR by four, since ARR is already annual.
What is a good SaaS quick ratio? There is no official benchmark. A common rule of thumb treats 4 or above as strong for an early-stage company, meaning four dollars of ARR added for each dollar lost. Larger companies with slower growth commonly run lower. Track the trailing four-quarter trend, since one large churned account can move a single quarter.
How should SaaS companies calculate cash runway? Divide cash and liquid investments by average monthly net cash burn over the last three months, then show a second figure from the forward plan. Also project runway at the expected date your financial statements will be issued or available to be issued, because the going-concern evaluation looks one year forward from that date.
How often should the board see the dashboard? A one-page monthly flash after close and a full dashboard at each quarterly board meeting is a common pattern, with targets reset in the annual plan.
Madras Accountancy supports SaaS companies and the CPA firms that serve them with monthly close, ARR and deferred revenue schedules, and board-ready reporting packs. To talk through what your dashboard needs, contact our team.
The section 4960 excise tax is 21% of nonprofit pay over $1M. From 2026 it covers all employees. See the medical carve-outs, Form 4720 and a worked example.
The paid family and medical leave tax credit is permanent from 2026. See the 12.5% to 25% rates, the premium option, the 6-month rule and how Form 8994 works.
Opportunity zones become permanent in 2027 under the One Big Beautiful Bill. See the new deferral, rural bonus, and the 2026 handoff.
