A simple financial dashboard for a small business is one page that shows seven numbers: income, expenses, profit, tax set-aside, cash and savings, debt, and net worth. Build it as one tab in a spreadsheet. Glance at income, expenses and cash weekly, review the whole page monthly, and update net worth once a quarter.
Many service business owners don't say "I don't make enough money." They say "I don't know where my money is going." They're earning, they're spending, they're busy, and they're making decisions in the dark because the numbers live in five different places: the booking system, the bank app, a credit card statement, a shoebox of receipts, and memory.
A financial dashboard won't make you a numbers person overnight. What it gives you is clarity at a glance, and for a salon, studio or service business, that's usually what's missing. This guide covers which numbers belong on the page, how often to update each one, and a sample layout you can build in a free spreadsheet this week.
What is a financial dashboard, and why does a small business need one?
Think of the dashboard in your car. You don't need to understand the engine to know that when the fuel gauge hits empty, you need gas. When a warning light turns red, something needs attention. When the speedometer reads 90 in a 45 zone, you slow down.
A financial dashboard works the same way. It takes the most important numbers in your business, and the personal ones that affect it, and puts them in one easy-to-read view. Instead of digging through bank statements, spreadsheets and receipts every time you want to know whether you can afford something, you open one page and see the answer.
Watching only your bank balance is like watching only the check engine light. It tells you you're not in immediate danger, but it says nothing about how fast you're going or how much fuel is left. A healthy-looking balance can hide a tax payment due next month, a supply bill that's crept up, or a slow season about to start.
You don't need expensive software, a CFO or a head for math to build one. If you can read a number on a screen, you can use a dashboard. The setup takes an hour or so; after that, it's minutes a week.
The 7 numbers on a simple small business financial dashboard
Seven numbers is enough to run a service business and few enough to actually keep up. Five are the core: income, expenses, savings, debt and net worth. Profit and your tax set-aside complete the picture for anyone who's self-employed.
1. Income: what came in
Your total income this month, broken down by source. For a salon or beauty business that usually means service income and retail sales on separate lines, plus any booth rent you collect from other stylists. For another service business it might be client sessions, packages and memberships.
Show it next to last month so you can see the direction. If your income swings with the seasons, also show it next to your planning floor: your lowest recent month. Our guide on how to budget with irregular income explains why that floor matters. Above it, you have surplus to put to work. At or below it, you protect the essentials.
2. Expenses: what went out
Total expenses this month, in a handful of categories, not fifty. A salon might use: rent, product and supplies, payroll or commission, software and subscriptions, and everything else. Keep the categories the same every month so the comparison means something.
The month-over-month comparison is what catches creep before it becomes a problem: a subscription that went up, a supply order that doubled, a charge that appeared twice. Our post on spending leaks that quietly drain your business covers the usual suspects.
3. Profit: what you kept
Income minus expenses. This is the number that tells you whether the business is working, and it's the one many owners never look at directly. Show it as a dollar amount and as a percentage of income, so a busy month with thin margins doesn't fool you.
If you take an owner's draw, add a line underneath for what you paid yourself, so you can see it against profit. Our guide to paying yourself as a salon owner walks through how to set that amount. And when you want to go deeper than one profit line, here's how to read a salon P&L line by line.
4. Tax set-aside: what you owe but haven't paid yet
If you're self-employed, part of every deposit already belongs to the IRS. Show the balance of your tax savings account and how much you added this month. When a quarterly payment comes due, the money should already be sitting there.
This is general education, not tax advice. A tax professional can confirm your rate and your dates.
5. Cash and savings: how long you could keep going
Two figures here. First, the balance in your business checking account, set against the bills due in the next 30 days. That one comparison answers "can I afford this?" better than the balance alone. Second, your cash cushion or emergency fund, and how many months of expenses it would cover.
Seeing "my cushion covers 1.3 months" every week keeps the goal alive in a way that a savings account you never open can't. If you're saving toward something specific, like a new styling chair or a course, add it here too.
6. Debt: what you owe
Each debt you carry: the balance, the interest rate and the minimum payment. Credit cards, equipment financing, a business loan, a line of credit.
The interest rate is the important column. When a card charging 24% sits on the page next to a 7% equipment loan, the order to pay them off becomes obvious. And when debt sits on the same page as savings, you can weigh the trade-off honestly instead of guessing.
7. Net worth: the long-term scoreboard
Everything you own minus everything you owe. Assets include your bank and savings accounts, investments, retirement accounts, equipment, retail inventory, and money clients owe you. Liabilities are the debts from line 6, plus any bills you owe vendors.
Net worth is the one number that tells the whole story. Income can look great while net worth shrinks, because you're spending faster than you earn. Income can look modest while net worth climbs, because you're keeping more. Some quarters it goes down. That's fine. The point isn't to always see growth; it's to always see the truth.
A sample financial dashboard layout for a salon
Here's what the page can look like, using example figures for a small salon in October. Your own numbers will be different. The layout is what matters: each line, this month, last month, and one note about what to check.
| | | |
|---|
| | | Services $8,300, retail $1,100 |
| | | Product and supplies up $250 |
| | | 37% of income, up from 36% |
| | | |
| Checking $6,800, cushion $7,500 | Checking $5,900, cushion $7,000 | Bills due in the next 30 days: $4,100 |
| | | Card first, then the equipment loan |
| | | |
Reading it takes less than a minute. Income and profit are up. Expenses rose too, mostly supplies, so that's the one line worth a closer look. Checking covers the next month of bills with room to spare, the cushion is growing, and debt went down by $400.
How to build a free financial dashboard in Google Sheets
You can build this for free in Google Sheets or Excel. If you already have a budgeting spreadsheet from our Google Sheets budgeting guide, you're most of the way there.
Add a new tab to your spreadsheet and name it Dashboard.
Create four columns: Line, This month, Last month, and What to check. Add one row for each of the seven numbers.
Pull totals from your income and expense tabs with the SUM or SUMIF function, so the dashboard updates when the detail does. For the balances in lines 4 to 6, simply type in the figure from your bank or loan statement.
Add a fifth column that shows the change between this month and last month, as a dollar amount or a percentage.
Use conditional formatting so a cell turns green when a number moves the way you want and red when it needs attention. In Google Sheets it's under the Format menu and takes a couple of minutes to set up.
For net worth, list assets in one small block and liabilities in another, subtract the totals, and make the result bold.
The manual version works, and typing the numbers in yourself makes you notice them. The downside is that it depends on you remembering to update it, which is why the schedule below matters as much as the layout.
How often to update each number
A dashboard you don't open is just a pretty spreadsheet. Put these on your calendar like client appointments.
| | |
|---|
| | Income, expenses, checking balance, bills due next |
| | |
| | The first six lines, compared with last month |
| | Net worth, debt plan, and whether the categories still fit |
Your weekly dashboard check-in
Pick the same time each week, such as a slow Monday morning before your first client. Look at the week's income and expenses. Any charges you don't recognize? Any payments you expected that haven't arrived? Is checking on track for the bills due next? Make a note and move on. You're scanning, not analyzing. Our weekly cash flow routine gives you a short script for it.
Your monthly financial dashboard review
Fill in the first six lines and compare them with last month. Is income growing or shrinking? Are expenses creeping up? Did profit keep pace? Did the tax set-aside get its share? This is also when you check the dashboard against your bank statements, so the big picture and the details agree. Our monthly financial review checklist walks through it step by step.
Your quarterly look back
Every three months, zoom out. Update net worth. Look at the quarter as a whole and ask whether your categories, your owner pay and your savings targets still match reality. It isn't about perfection; it's about small corrections that add up over a year.
Common financial dashboard mistakes
Tracking too much on day one. Start with the seven lines. You can add a salon-specific number later, like retail sales per client, once the habit sticks.
Building it and never opening it. Block the time on your calendar, weekly and monthly.
Looking without acting. If expenses jumped, find out why. If you don't recognize a subscription, cancel it. The dashboard shows you; you decide.
Changing categories every month. If the categories move, the month-over-month comparison stops meaning anything.
Mixing business and personal without labels. If both appear on the page, keep them in clearly separate sections.
Your action step this week
Before next Sunday, build the first three lines: income, expenses and profit, for this month and last month. Just those three. Get the numbers in, look at them side by side, and find one thing that surprises you: a charge you forgot, a category that grew, a month that was better than it felt.
If that happens, the dashboard is already working, and the rest of the lines will be easier to add.
If you'd like your business and personal numbers in one place, the Money Mastery System brings together five connected workbooks, Clarity AI, and the Money Mastery Collective, a community of people doing the same work beside you. Start free with La Soglia.
Full disclosure: the Money Mastery System is Donna Roggio's own product.
Your money is already telling a story. A dashboard just makes sure you're finally listening.
Frequently asked questions about a small business financial dashboard
Do I need accounting software to create a financial dashboard?
No. A simple dashboard in Google Sheets or Excel, with a few SUM formulas and some conditional formatting, does the job. Software can save you the data entry, but a manual dashboard you actually use beats a polished tool you ignore.
How often should I update my small business financial dashboard?
Glance at income, expenses and your checking balance weekly; it takes five to ten minutes. Fill in the full page once a month, and update net worth once a quarter. The habit of looking matters more than the exact schedule.
What if my business is brand new and I don't have much data yet?
Start anyway. One month of numbers gives you a baseline, two give you a comparison, and three give you a trend. The worst time to build a dashboard is in the middle of a cash crunch, when you're trying to work out what went wrong.
What's the difference between a financial dashboard and a financial report?
A financial report, like a monthly profit and loss statement, covers a set period and stays fixed once it's done. A dashboard is a living one-page summary of where you stand now, pulled from those reports and your bank balances. Reports tell you what happened; a dashboard helps you decide what to do next.
Should I include personal finances on my business dashboard?
If you're a sole proprietor whose business and personal money overlap, yes, in clearly separate sections. Your personal savings and debt affect your business decisions whether you track them or not. If the line between the two has blurred, start with how to separate business and personal finances.
Which numbers should I put on my dashboard first?
Income, expenses and profit, followed closely by your checking balance against upcoming bills. Those four tell you whether the business is working and whether you can pay what's due. Add the tax set-aside, savings, debt and net worth once the first four are a habit.