Finance operations
Finance Dashboard for SME Owners: 8 Metrics and Who Owns Them
Build a one-page finance dashboard for your SME with eight metrics, the record each comes from, who updates it and how often the owner should review it.
9 min read
Short answer
A useful finance dashboard for an SME owner tracks eight metrics: cash position, receivables ageing, payables due, gross margin, expense against budget, tax set aside, stock value and bank reconciliation status. Each figure should come from a named source record, be updated by a named person and be reviewed on a fixed rhythm, weekly or monthly. Read the metrics together, because a single figure seldom tells the whole story. Last reviewed: November 2026.
Already seeing this in your business? Describe what is happening instead of reading to the end.
Why do eight metrics work better than a full set of accounts?
Most owners do not have time to read a trial balance every week, and they do not need to. What they need is a short view that answers three questions: do we have enough cash, is money coming in and going out as planned, and can we trust the numbers.
The eight metrics below cover those questions. Cash, receivables and payables show liquidity. Gross margin and expense against budget show whether trading is paying for itself. Tax set aside and stock value show money that looks available but is already committed or tied up. Bank reconciliation status tells you whether to trust the rest.
Keep the dashboard to one page. If a metric does not lead to a decision or a question, leave it out until it does.
What are the eight metrics, and who should own each one?
The table gives a definition, the record each figure is taken from, the person who usually updates it in a small business, and a sensible review rhythm. Adjust the owners to suit your team, but give every metric exactly one named person.
| Metric | What it means | Source record | Who updates it | Review rhythm |
|---|---|---|---|---|
| Cash position | Usable balance across business bank accounts and cash in hand, less cheques issued but not yet cleared | Bank statements, cash book and the weekly cash worksheet | Accountant or bookkeeper | Weekly |
| Receivables ageing | Amounts customers owe, grouped by how long each invoice has been outstanding | Sales ledger and party-wise outstanding report | Accounts or collections person | Weekly |
| Payables due | Supplier bills falling due in the coming period, including those already overdue | Purchase ledger and supplier-wise ageing report | Accounts payable person | Weekly |
| Gross margin | Sales less the direct cost of what was sold, shown as an amount and against sales | Sales and purchase ledgers, adjusted for opening and closing stock | Accountant | Monthly |
| Expense against budget | Actual operating spend for each expense head compared with the amount budgeted | Expense ledgers and the approved monthly budget | Accountant, with comments from each budget holder | Monthly |
| Tax set aside | Money reserved for GST, TDS and other tax payments that will fall due, kept apart from operating cash | Tax ledgers, return working papers and the reserve account balance | Accountant, confirmed with your CA | Weekly balance, monthly true-up |
| Stock value | Value of goods held in the shop, godown or in transit, on the basis your accountant uses | Stock register or inventory report, checked against physical counts | Stores or godown in-charge, valued by the accountant | Monthly, with periodic counts |
| Bank reconciliation status | Whether each bank account has been reconciled to the books, and the value of unexplained items | Bank reconciliation statements | Accountant or bookkeeper | Weekly status, full monthly reconciliation |
How should each metric be prepared so the dashboard can be trusted?
- Prepare cash position from the weekly cash position worksheet, not from memory or a banking app balance alone.
- Run receivables ageing after all receipts for the week are posted, so paid invoices do not show as overdue.
- Include supplier bills that are approved but not yet entered, and mark them, so payables due is not understated.
- Calculate gross margin only after the month's purchases and stock movements are posted.
- Take expense against budget from the monthly budget versus actual expense review, with a one-line reason for each large variance.
- Confirm the method for tax set aside with your CA, and check current rates and due dates on the official GST and Income Tax portals rather than estimating them.
- Show the date of the last physical stock count beside the stock value.
- Show the date each bank account was last reconciled and the total of unexplained items.
How do you read one week's dashboard?
Below is one week's dashboard for an imaginary trading business with a shop and a godown. All figures are illustrative and do not describe any real business.
| Metric | This week | Note from the preparer |
|---|---|---|
| Cash position | Rs 6,40,000 | Two bank accounts plus cash in hand; one supplier cheque of Rs 40,000 not yet cleared and already deducted |
| Receivables ageing | Rs 9,80,000 total; Rs 3,10,000 in the oldest bucket | Two parties account for most of the oldest amount |
| Payables due | Rs 5,20,000 due in the next two weeks | Includes Rs 1,20,000 for the main supplier |
| Gross margin | Last month: Rs 4,50,000 on sales of Rs 18,00,000 | Lower than the month before; purchase prices rose on one product line |
| Expense against budget | Last month: Rs 2,90,000 against Rs 2,60,000 budget | Over on transport and repairs |
| Tax set aside | Rs 1,60,000 in reserve account | CA's working for the next payment is Rs 1,75,000 |
| Stock value | Rs 12,00,000 | Last full count was at the previous month-end |
| Bank reconciliation status | Account A reconciled; Account B pending | Rs 22,000 of unexplained receipts on Account B |
Start with cash. Rs 6,40,000 looks comfortable against Rs 5,20,000 of payables due. But Rs 15,000 more is needed to complete the tax reserve, which leaves less room than the headline suggests.
Next, receivables. Rs 3,10,000 sits in the oldest bucket with two parties. Collecting even part of that would ease the next fortnight. The decision here is to call both parties this week and to hold further credit to them until a payment date is agreed.
Then margin and spending. Margin fell because purchase prices rose on one line, and expenses ran over budget. Together these explain why cash feels tighter than sales suggest. The owner asks whether selling prices on that line need revisiting and asks who approved the repair spend.
Finally, trust. Account B is not reconciled and has Rs 22,000 of unexplained receipts. Those may be customer payments not yet allocated, which would also overstate receivables. The owner asks for Account B to be reconciled before the next supplier payment run.
That gives four actions from one page: top up the tax reserve, chase two overdue parties, review pricing and repair approvals, and finish the pending reconciliation.
What common mistakes should you avoid?
- Treating the bank balance as free cash while tax money and uncleared cheques sit inside it.
- Reading receivables as a total only, without looking at how old the amounts are.
- Reporting gross margin without updating stock, which makes margin swing for no real reason.
- Letting the person who makes payments also be the only person who reconciles the bank.
- Adding metrics every month until nobody reads the dashboard.
- Changing how a metric is calculated without noting it, so weeks can no longer be compared.
When does this dashboard not fit your business?
A pure service business with no goods may drop stock value and track unbilled work instead. A business that sells mostly for cash may find receivables ageing less useful than daily collections. Businesses with loans, overdrafts or foreign-currency dealings will need extra lines for borrowing and exposure.
This dashboard is also not a substitute for monthly accounts or statutory returns. It summarises figures your books already hold. If the books are behind, fix that first with a month-end close routine and a regular bank reconciliation, then build the dashboard on top.
Sources and review
Published by ThynkBored. Published 15 November 2026. Content review completed 15 November 2026. The byline identifies accountability for the page; it does not represent an individual author, credential, professional certification, or evidence of CA, CS, accounting, or legal review.
This guide describes a practical management dashboard, not an accounting standard or tax advice. All worked-example amounts are illustrative. It does not set target values or benchmarks for any metric and states no tax rate, threshold or due date; confirm tax reserves and current figures with your CA or the official GST and Income Tax portals.
Set up a finance dashboard you can read in minutes
Tell us which of the eight metrics you track today, who prepares them and how far behind your books run. ThynkBored can help define sources, owners and a review rhythm that fits your team.
Use categories and ranges only. Do not send bank statements, ledgers, account numbers, passwords, OTPs or files through the form. Agree a secure handoff first if records need review.
Diagnose this issueA person reads every enquiry. We reply as soon as we can.
Questions owners ask
How often should an SME owner review the finance dashboard?
Review cash position, receivables, payables, tax set aside and reconciliation status weekly, because they change quickly and drive payment decisions. Review gross margin, expense against budget and stock value monthly, after the books are closed, so that the figures are complete and comparable from one month to the next.
Can I build this dashboard in a spreadsheet?
Yes. A single sheet with one row per metric, the figure, the preparer, the date updated and a short note is enough. What matters is that each figure is taken from the accounting records, not retyped from memory, and that the same method is used every week.
How much tax should I set aside each week?
This depends on your registrations, sales mix, input tax credit position and other obligations, so there is no single figure. Ask your CA to give you a method for estimating the reserve, and check current rates and due dates on the official GST and Income Tax portals.
What should I do if the bank reconciliation is not up to date?
Treat the other figures with caution, especially cash and receivables, because unposted or misallocated entries affect both. Ask for the reconciliation to be completed before major payment decisions, and record the date of the last reconciliation on the dashboard so the gap stays visible every week.
Useful context for this decision
Follow the records, definitions, comparisons, and next actions connected to this page.