Excel workbook
Monthly KPI Dashboard Workbook: Margins, Days Sales Outstanding, Cash Runway and Trends in Excel
Type in each month's revenue, costs, receivables and cash, then pick a month and see the KPIs and charts that matter, with change from last month and the same month last year.
$29 one time · example and blank copies · download link by email
Who it is for
Owners who want a one-page monthly scorecard, and bookkeepers who send clients a monthly report.
Why it is different
- It compares against last month and the same month last year, so a single number is never left without context.
- Each KPI is explained on its own tab, with the formula shown.
- A filled example for an invented service business and a blank copy with working formulas.
What is inside
- Start Here. Purpose, which cells to fill in and how to pick a month.
- Monthly Data. Twelve months of revenue, cost of sales, expenses, receivables, cash and customers, with an optional prior-year block.
- Dashboard. Pick a month to see margins, days sales outstanding, months of cash, revenue per customer, year to date and the change from last month and last year, with charts.
- KPI Guide. What each measure means and how it is worked out.
- Checks. Gaps, incomplete months and negative cash.
A look inside
Example data, real formulas
Get it
Monthly KPI Dashboard Workbook
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting advice. The measures are general and are only as accurate as the figures you enter. Months with no data plot as zero on the charts. Not accounting, tax or financial advice. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Buy it with the others