A business dashboard shows the few numbers you check every week, like sales, overdue invoices, open orders and cash. It reads them from the sheets and accounts you already use and refreshes them on its own. Start with five numbers and one question for each.
What is a business dashboard for?
A business dashboard is one screen that answers the few questions you ask about your business every week, with numbers that update themselves.
Say you run a small bakery that also supplies cafes. Sales are in the accounting system. Orders for tomorrow are in a sheet. Who owes you money is in a report. To answer "how much are we owed today?" you open three things and add it up by hand. A dashboard puts that answer in one place.
That is also the test of a good one. If you still have to open the accounts to know what to do, the dashboard is decoration. If it shows which invoice to chase and whether cash covers next week's bills, it is doing its job.
Below we cover how to pick the numbers, where each one comes from, how to keep them fresh without copying by hand, and when a short report works better than a screen.
Which five numbers should you start with?
Start with five numbers. Each one should answer a question you really ask and help you make a decision.
Most dashboards fail by showing too much. Twenty tiles look thorough and get ignored. Five that you check every Monday get used. Write each as a question first, then pick the figure, then note where it lives today.
Two numbers need a clear definition. Overdue means past the due date and unpaid, not just unpaid. Cash should say whether it is the balance in your accounts or a live figure from the bank. Without a definition, everyone reads the number differently.
| Number | The question it answers | Where it usually lives |
|---|---|---|
| Sales this month against last month | Are we selling more or less? | Accounting system |
| Overdue invoices | Who owes us, and how late? | Accounting system |
| Bills due in two weeks | What must we pay soon? | Accounting system |
| Open orders | What have we promised and not delivered? | An order sheet |
| Cash in the bank | Can we cover what is due? | Your accounts |
| Open enquiries | Who is waiting for an answer? | Your mailbox or a register |
Where does the data come from?
Every number should come from a system you already keep up to date, never from a copy someone must maintain.
A dashboard fed by a sheet that someone updates on Fridays is wrong from Monday to Thursday. Look for the source that is kept as part of the work. The accounts, because invoices go in anyway. The order sheet, because the team fills it in to do the job. The mailbox, because enquiries land there first.
Typical sources for a small business:
- The accounting system: sales, overdue invoices, bills due, recorded bank balances.
- Order or stock sheets: open orders, deliveries due, what's on the shelf.
- Registers kept up to date for you, like a price history built from your invoices.
- The mailbox: new and unanswered emails, open enquiries.
- If something is only kept by hand and nobody needs it for the work, fix that before it goes on a screen.
Is your dashboard ready to build?
Think of the dashboard you want. Tick each line that is true today.
How does it refresh by itself?
At set times, a small program reads each number from its source and redraws the screen, with no copying by hand.
The program only reads. It never changes your accounts. If a source can't be read, the tile says so instead of showing an old figure as if it were fresh. How often depends on the number. Cash and overdue invoices may be worth a look every morning. Margins once a week is plenty.
A typical refresh runs like this:
- At the set time, the refresh starts.
- It reads each source: the accounts, the order sheet, the registers.
- It works out each number the way you defined it.
- It writes the figures, with the time they were read, to a sheet in your own account.
- The dashboard redraws from that sheet. A source that failed shows as not updated.
- Every refresh goes in a log, so a strange figure can be traced back.
Dashboard or weekly report?
A dashboard is for looking at the current picture whenever you like. A report is for being told, on a set day, what changed.
Some people never open a dashboard but always read an email. For them, automated reporting works better: a Monday message with sales, overdue invoices and bills due. Other people check often and want to dig into a figure. Many owners want a short report that points to the screen for detail.
One example of the report side runs today for a client. Each morning it lists yesterday's new and unanswered emails across several mailboxes, sorted by business, with a short summary of each. Our client app also shows a page per client with what is waiting for whom. Neither is a money dashboard, but both answer a daily question without anyone putting the answer together by hand.
Can I build one on my own tools?
Yes, and it's the cheapest kind to keep running. Use the accounts, sheets and mailboxes you already have, not a new system your team must feed.
Custom dashboard development is built to order. It isn't running for a client yet. It follows the same approach as the AI employees that are running today: the work runs on our servers against your own accounts, today Google Workspace mail, Google Drive, Google Sheets and Xero. The figures go into sheets you own. It's rented by the month, with one price per workflow in the quote. If the rental stops, the refresh stops, and every sheet stays yours.
Know the limits. A dashboard shows what your systems record. If invoices are entered late, the dashboard is late. It won't decide what to do about a client who pays slowly. It doesn't replace your accountant, and figures for tax or lending should be checked with your adviser.
A good first dashboard is small: five tiles, with the question, the source and the definition written under each. Use it for a month. Take off the tiles nobody opens. Add the question you kept asking that it couldn't answer. That is how a dashboard stays useful instead of turning into a wall of figures.
The checklist below helps you pick your five numbers and name their sources before anything is built.
Questions
What is a business dashboard?
One screen with the few numbers you check every week, like sales, overdue invoices, bills due, open orders and cash. It reads them from the systems you already use.
What numbers should be on a dashboard?
Only the ones tied to a question you ask and a decision you make. Five is a good start. More tend to be ignored.
Can I build a dashboard in a spreadsheet?
Yes, if the figures are read from their sources on their own. A sheet updated by hand is wrong between updates.
What is the difference between a dashboard and a report?
A dashboard shows the current picture whenever you look. A report tells you, on a set day, what changed. Many businesses use both.
Do I need new software for a dashboard?
Not necessarily. It can sit on your own accounts, sheets and mailbox, with the figures written to sheets you own.
Tell us your workflow. We will build it around you.
Write to hello@thenewaiemployee.com with the five numbers you want to see and how many hours you spend putting them together each month. We'll tell you plainly if this fits.
Talk to us Related service: CRM and dashboards


