--- title: "Monthly KPI Dashboard Workbook (Excel) | MCC Solutions" description: "Excel workbook that turns twelve months of numbers into a one-page dashboard: margins, days sales outstanding, months of cash, revenue per customer." url: "https://mcc-solutionsnj.com/toolkits/monthly-kpi-dashboard-workbook" --- 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 · 14-day full refund · example and blank copies · download link by email Buy now, $29 🌙 The desk is asleep. The store never is. Every kit and ebook downloads the moment you pay, day or night. Questions get answered after we open in the morning. [Browse the store](/toolkits) Who it is for Owners who want a one-page monthly scorecard, and bookkeepers who send clients a monthly report. Not the right fit if You want a dashboard that pulls data automatically: you type each month's figures in by hand. 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 [![Dashboard tab of the Monthly KPI Dashboard Workbook, with example data](/img/toolkits/monthly-kpi-dashboard-workbook/a.png)](/img/toolkits/monthly-kpi-dashboard-workbook/a.png) Dashboard tab with example data. Made-up numbers. [![Monthly Data tab of the Monthly KPI Dashboard Workbook, with example data](/img/toolkits/monthly-kpi-dashboard-workbook/b.png)](/img/toolkits/monthly-kpi-dashboard-workbook/b.png) Monthly Data tab with example data. Made-up numbers. Get it ## Monthly KPI Dashboard Workbook Or pay with PayPal Uses the email and terms box above. You get the same download link by email. ZIP code (for sales tax) Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly. Get every update for a year, $29: the [Yearly Updates Pass](/updates-pass?kit=monthly-kpi-dashboard-workbook) gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal. Delivered as a zip with a filled example and a blank copy. Built for Excel, tested in LibreOffice; it should open in Google Sheets but not every feature is tested there. For one business, your own use. General information, not accounting, tax or legal 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. Ways to get it ## Just this kit, or more This kit **$29 one time** Monthly KPI Dashboard Workbook. Buy this kit The set **$79 one time** 4 kits including this one, $27 less than buying them separately. [See the set](/toolkits/business-planning-bundle) Membership **$29 a month** Every kit and document pack in the store, including new ones. Cancel any time. [See the membership](/membership) Questions ## Common questions **What do I get and how is it delivered?** The Monthly KPI Dashboard Workbook as two Excel files in one zip: a filled-in EXAMPLE so you can see every tab working, and a BLANK copy for your own numbers, plus a README. The download link arrives by email after payment. **Will it open on a Mac, Google Sheets or my phone?** Built for Excel and tested in LibreOffice, which runs on Mac and Windows; it should open in Google Sheets, but not every feature is tested there. Phone spreadsheet apps are not tested. If a file will not open or something looks wrong, reply to your order email and we will make it right. If it is not right for you, email us within 14 days of buying for a full refund. **Is this legal or tax advice?** No, it is not accounting, tax or financial advice. **Is it the right fit for me?** It is made for owners who want a one-page monthly scorecard, and bookkeepers who send clients a monthly report. Skip it if you want a dashboard that pulls data automatically: you type each month's figures in by hand. 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](/bookkeeping/#interest) [Free books health check](/bookkeeping/health-check) Prefer to keep it yourself but want a hand getting started? [Book a 45 minute setup session](/workbook-setup-session) ($65). Buy it with the others [Bundle ### Business Planning Bundle This product plus 3 more, in one download. $79 instead of $106 separately](/toolkits/business-planning-bundle)[### Month-End Close Workbook A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock. $19](/toolkits/month-end-close-workbook) ## More bookkeeping and business toolkits - [Multi-Property Short-Term Rental Host Tracker](/toolkits/short-term-rental-host-tracker) $29 - [Multi-State 1099 and W-2 Filing Checklist](/toolkits/multi-state-1099-w2-filing-checklist) $17 - [Multi-State LLC Compliance Calendar](/toolkits/multi-state-llc-compliance-calendar) $19 - [Multi-State Sales Tax Tracker for Online Sellers](/toolkits/multi-state-sales-tax-tracker) $24 - [Multi-State Worker Tax Organizer](/toolkits/multi-state-worker-tax-organizer) $15 - [Nebraska Employer Compliance Kit 2027](/toolkits/nebraska-employer-compliance-kit-2027) $19 [See every toolkit and document pack](/toolkits/all) ## Rather have someone do the books? [Get a Bookkeeping Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)