Financial Performance Dashboard
The board pack goes out on the ninth business day. Revenue landed within 2% of forecast again, and nobody asks about it. Every question is about gross margin, which has slid four points since January, and nobody in the room can explain it from the pack.
Revenue is a harder number to read than it used to be. In its third estimate for the second quarter of 2026, published September 30, the Bureau of Economic Analysis had the PCE price index rising at a 5.0% annual rate. With prices moving that fast, revenue can reach plan on price alone, and margin and cash have to carry more of the story.
Cash takes its time arriving, too. In the Atradius Payment Practices Barometer for the US, published in September 2026, companies said late payments affect an average of 22% of their B2B receivables, and that they often lose 1% to 2% of B2B invoices to bad debt. The finance team's own speed has a yardstick as well: APQC's open benchmark puts the median time to complete the monthly consolidated financial statements at 6.0 days, across 11,223 organizations.
The company on the board doesn't exist. It's a Texas IT services firm with three divisions that forecast in very different ways, and its figures are modeled, not taken from a real business. It's the story of a forecast measure that beat a published median for nine straight months and was wrong the whole time. Three of the targets below have a published benchmark behind them; the table says which.
What is a Financial KPI Dashboard?
Overview
A financial KPI dashboard shows whether the business is earning money, turning it into cash, collecting what it's owed and closing the books fast enough for any of that to matter, with each number set against a target the finance team has agreed.
The month starts with a forecast. Revenue forecast accuracy scores it once the month is over, and it's only useful if it's scored at the level where the forecast is actually built.
Then revenue is recognized. Consolidated gross margin shows what it cost to deliver, and adjusted EBITDA margin shows what was left after overhead. For a company that resells hardware, revenue and gross margin can move in opposite directions in a strong month.
Invoices go out, and the receivables numbers follow them. Days sales outstanding shows how long the average sale takes to turn into cash. Past-due receivables shows how much is late. Operating cash conversion asks the blunt question: of the EBITDA we reported, how much turned up in the bank?
Last comes the close. Month-end close days measure how long it takes to issue the statements, and post-close journal adjustments measure how many times someone had to go back and fix them.
Who benefits from this dashboard?
- CFO: Gross margin, EBITDA margin and cash conversion on one screen are what the lender's covenant review and the board both start from, and the forecast accuracy line shows how much weight the next quarter's guidance can take.
- Controller: Close days and post-close adjustments are the controller's scorecard. Reading them together stops a faster close from being celebrated while the corrections pile up behind it.
- FP&A manager: Forecast accuracy by division shows which part of the business the forecast doesn't understand, and that's where next month's forecasting effort should go.
- Credit and collections manager: Past-due receivables and days sales outstanding show whether the chasing is working, weeks before it shows in cash conversion.
- Division general managers: They sign the forecast for their division. Seeing their own error every month, instead of a company total that absorbs it, changes how carefully they sign.
Score the forecast that was locked on the first business day of the month, and keep that version. If the forecast gets refreshed on the 20th, accuracy mostly measures how close to month end the last refresh happened.
Dashboard Example Overview
The company sells IT services to mid-sized businesses from offices in Dallas, Houston and San Antonio, with about 420 staff and $129.6 million of revenue in the twelve months to September 2025. Managed services contracts bring in about 45% of it, project work such as cloud migrations and network builds about 30%, and hardware and software resale the rest. The finance team reports nine KPIs each month:
- Consolidated Revenue: Recognized revenue across all three divisions for the month, after intercompany eliminations. Resale is booked gross, so a big hardware month lifts it sharply.
- Consolidated Gross Margin: Revenue less cost of revenue (delivery labor, subcontractors, hardware and license cost), divided by revenue. It falls when engineers sit idle or when resale makes up more of the mix.
- Adjusted EBITDA Margin: Earnings before interest, taxes, depreciation and amortization, with one-off items such as acquisition costs added back, divided by revenue. The add-backs are written down in advance, so the list can't grow to fit the result.
- Operating Cash Conversion: Operating cash flow divided by adjusted EBITDA, over the trailing three months. A single month swings too much on when customers happen to pay.
- Days Sales Outstanding (DSO): Receivables at month end, leaving out work not yet invoiced, divided by average daily revenue over the last three months. Every customer buys on credit, so revenue and credit sales are the same figure here.
- Past-Due Receivables: Receivables past their due date as a share of total receivables at month end. Customers here are on 30-day terms.
- Revenue Forecast Accuracy: One minus the sum of each division's absolute forecast error, divided by actual revenue, using the forecast locked on the first business day. Until June 2025 it was scored on the company total only, which is the point of this story.
- Month-End Close: Business days from month end to issuing the consolidated financial statements.
- Post-Close Journal Adjustments: Journal entries posted to a month after its statements were issued. The quality check on the close.
For nine months, forecast accuracy is the best-looking number on the board. Scored on the company total, it runs between 98.2% and 99.9% from October 2024 to June 2025. That's above APQC's cross-industry median of 97.0% for overall financial forecast accuracy, and the CFO says so in the board pack.
Margin is where it shows. Consolidated gross margin falls from 33.5% in January 2025 to 29.5% in June, and adjusted EBITDA margin from 10.1% to 9.0%. Early in 2025 the Projects division hired eight engineers because the forecast said the work was coming. A lot of it didn't come when the forecast said it would, and idle engineers are cost of revenue.
The second-quarter review in July is where the measure comes apart. For April to June, the company forecast $32.90 million and booked $33.06 million, 0.5% out. Underneath, Projects forecast $11.40 million and delivered $9.41 million, while hardware resale forecast $6.61 million and booked $8.58 million. A $1.99 million miss and a $1.97 million surprise had cancelled almost exactly. They'd been cancelling all along: project start dates slipped every month, and large hardware orders arrived that nobody had put in the forecast.
So from July 2025 the definition changes to the sum of division-level errors. The chart steps down from 98.3% in June to 86.3% in July. Nothing got worse that month. Re-scored on the new basis, October 2024 to June 2025 would have read between 83.6% and 88.7%. The forecast had been that far off for the whole period, and the board had been told 99%.
Three changes follow. Project revenue is forecast from the project managers' milestone dates, signed off each week, instead of the start dates entered in the sales system. Hardware is forecast from signed quotes and distributor ship dates. And Projects stops hiring ahead of the forecast, using subcontractors for peaks until the work is signed.
The slipping projects had been hurting cash, too. Milestone invoices went out on the planned date whether or not the milestone was done, and customers disputed them. Past-due receivables climb to 29.1% in July 2025. Days sales outstanding stays above 50 from May to September and reaches 52.6 days in June, the same month trailing three-month cash conversion falls to 31%. Once milestone invoices wait for customer sign-off, past-due falls steadily, to 15.4% by September 2026, and DSO comes down to 44.0 days.
December 2025 is the setback. Customers spend year-end budgets on hardware, and the forecast misses it again: $2.69 million forecast, $3.83 million booked. Accuracy dips to 86.4%. The hardware invoices push DSO up to 50.2 days, and it drops to 44.5 in January once they're paid. Forecast accuracy clears the 92% target for the first time on the new basis in February 2026, at 92.9%, and reaches 94.9% in September 2026.
The close gets faster over the same stretch: 9 business days in October 2024, 7 by October 2025, 6 in January 2026. That speed costs something at first. Post-close adjustments, usually 11 to 16 a month, jump to 21 in January 2026 and 24 in February, as accruals booked on rough estimates have to be corrected. A materiality threshold and a second reviewer on every manual accrual bring them down to 8 by August, and the close reaches 5 days from May 2026.
By September 2026, monthly revenue is $12.72 million, and $145.5 million for the twelve months. Gross margin is 32.5% and adjusted EBITDA margin 12.7%. Past-due receivables, at 15.4%, still sit just above the 15% target, and DSO, at 44.0 days, is inside its 45-day target but six days slower than APQC's median of 38.0 days. And scored the old way, September's forecast accuracy would have read 99.9%, a shade above the 99.1% it read in October 2024. The old measure couldn't tell the broken forecast from the fixed one.
Creating a Financial Dashboard in SimpleKPI
-
Step 1 Choose the forecast version and the level you score it at
Decide which forecast gets scored (the one locked before the month starts) and at what level. The company total is the easiest figure to hit, because divisions offset each other. Score by division, or by revenue stream if each division is one stream. While you're writing definitions, settle whether resale revenue is booked gross or net, because it changes both revenue and gross margin.
The guide to choosing KPIs covers how to pick and define the rest.
-
Step 2 Name an owner for the ledger, the receivables and the forecast
Revenue, margins and EBITDA come out of the general ledger after the close, so the controller owns them. Receivables live in the AR subledger, which credit control can read on any day. Forecast accuracy needs two inputs, the locked forecast from FP&A and the actual from the ledger, and one named person has to own the comparison or it quietly stops being done. If those numbers currently travel by spreadsheet, this piece on KPI spreadsheets explains where that tends to break.
-
Step 3 Run a weekly receivables flash and a monthly post-close review
Past-due receivables and DSO change daily and suit a short Monday look with credit control. Margins, EBITDA, cash conversion and forecast accuracy have to wait for the close, so they belong in the monthly review. The board and the lender usually get a quarterly view; build it from the same monthly figures so nobody argues about which version is right.
-
Step 4 Read close speed beside its corrections, and revenue beside margin
Close days only mean something next to post-close adjustments. Revenue only means something next to gross margin, because a resale-heavy month adds revenue at a fraction of the margin of a services month. Cash conversion belongs next to past-due receivables, since a jump in late invoices shows up there first.
List of Financial KPIs
Month-end close, revenue forecast accuracy and days sales outstanding are the three with a published APQC median. Everything marked starting point is this company's own target: set yours from a year of your own history.
| KPI Name | Typical Target | Description / Calculation |
|---|---|---|
| Consolidated Revenue | $11.5 million a month (starting point) | Recognized revenue across all divisions for the month, after intercompany eliminations. |
| Consolidated Gross Margin | ≥ 32% (starting point) | Revenue less cost of revenue (delivery labor, subcontractors, hardware and license cost), divided by revenue. |
| Adjusted EBITDA Margin | ≥ 11% (starting point) | EBITDA with a pre-agreed list of one-off items added back, divided by revenue. |
| Operating Cash Conversion | ≥ 85% (starting point) | Operating cash flow divided by adjusted EBITDA, over the trailing three months. |
| Days Sales Outstanding (DSO) | ≤ 45 days (APQC median 38.0 days) | Receivables at month end divided by average daily credit sales over the trailing three months. Lower is better. APQC divides average receivables by annual sales over 365. |
| Past-Due Receivables | ≤ 15% (starting point) | Receivables past their due date divided by total receivables at month end. Lower is better. For context, Atradius found late payments affect an average of 22% of US B2B receivables (2026). |
| Revenue Forecast Accuracy | ≥ 92% by division (APQC median 97.0%, level not stated) | One minus the sum of absolute division-level forecast errors, divided by actual revenue. Forecast locked on the first business day of the month. |
| Month-End Close | ≤ 6 business days (APQC median 6.0 days) | Business days from month end to issuing the consolidated financial statements. Lower is better. |
| Post-Close Journal Adjustments | ≤ 8 a month (starting point) | Journal entries posted to a month after its statements were issued. Lower is better. |
Why Financial Dashboards Matter
Finance numbers are built to reconcile, which makes it easy to forget they can also mislead. A total that ties out to the ledger can still be the sum of two large errors pointing in opposite directions, and a monthly pack that shows only the total will never reveal it.
Several of these nine pull against each other. Resale revenue grows the top line and drags gross margin down with it. A shorter close produces statements sooner and, for a few months at least, more corrections after them. Pressing hard on past-due invoices brings DSO down, but pressing on a disputed milestone invoice can cost a managed services renewal worth far more. Even forecast accuracy can be gamed, by forecasting low or refreshing late, which is why the version and the level have to be fixed in writing.
For a finance manager, the practical answer is to never report one of these alone. Revenue goes out with margin, close days with adjustments, collections with past-due. If you also track working capital through inventory and payables, the supply chain dashboard example covers that side, and the sales dashboard example covers the pipeline a revenue forecast is built from.
One thing to do before the next board pack goes out: re-score last quarter's revenue forecast by division. If the total came in within 1% and the divisions didn't, you've found the number to fix first.
Building it in SimpleKPI
Build this dashboard yourself with SimpleKPI's KPI dashboards, or start from the Financial KPIs template. The mechanics are the same whatever you track:
- KPIs: each one gets a target, an entry frequency and tags, so you can report by team, site, product or whatever you split the numbers by.
- Data: type numbers in, import a spreadsheet, or use an integration or the API. The dashboard updates as each number lands, so daily and monthly KPIs sit side by side.
- Reports: scheduled KPI reports email the numbers to people who never log in.
- AI: Kip, the built-in AI, suggests targets and flags indicative benchmarks (AI estimates, not peer data) once some history builds up.
- Price: $79 a month for unlimited users and KPIs, as one flat price, with a 14-day free trial and no card needed.