Blog

From Excel to a Financial Dashboard for Small Business: KPIs, Free Template and When to Switch

TMG Books · 9 min read

Financial dashboard with revenue KPIs and a monthly bar chart on a laptop, next to a printed Excel sheet, on the desk of a small business office in Italy
A financial dashboard is not software: it is the moment, every month, when your numbers tell you what to do next.

Your annual accounts tell you how last year went. By the time you read them, it is too late to change anything. A monthly financial dashboard shows you whether you are making money, where margin is leaking and how much cash you will have in three months, while you can still act.

For a small business you do not need expensive software to start. You need bookkeeping that is closed every month, six KPIs read the same way every time and a well-built file. Below you will find the method, a worked example with real numbers, a free Excel template ready to use and the signals that tell you when to move from Excel to a connected dashboard.

Short answer

A small business financial dashboard is a monthly routine: a budget, actuals from your bookkeeping, six KPIs (revenue vs budget, contribution margin, break-even point, EBITDA, forecast cash, days sales outstanding) and one action for every significant variance. Excel is enough to start; move to a dashboard tool when updating the file costs you more than half a day a month or the numbers arrive after the 20th. Download the free template or let us set it up with you, free.

In this guide

  1. What is a financial dashboard and why does a small business need one?
  2. Which KPIs should a small business track every month?
  3. How do you build a financial dashboard in Excel?
  4. How do you read one month of numbers? A worked example
  5. Where can you get a free financial dashboard template?
  6. When is Excel no longer enough?
  7. How do you move from Excel to a dashboard without losing control?
  8. Which mistakes make a financial dashboard useless?
  9. Who can run monthly financial control for your business in Italy?
  10. Frequently Asked Questions (FAQ)

What is a financial dashboard and why does a small business need one?

It is the system you use every month to compare your real numbers with your targets and decide what to correct. In Italy it goes by the name controllo di gestione. Bookkeeping records the past for the tax office; the dashboard uses the same data to steer next month.

  • Budget. Your targets for the year split by month: revenue, variable costs, fixed costs, cash in and cash out. Without it, every month looks normal.
  • Actuals. The real figures for the month just closed, taken from your bookkeeping within the first 10 to 15 days of the following month. If your books are only updated quarterly, your dashboard cannot be monthly.
  • KPIs and variances. A few indicators, always calculated the same way, and the gap between budget and actuals. The variance tells you where to look, not what to do.
  • Decisions. One hour a month to read the numbers and choose an action for every significant variance. A report without actions is just one more file.

Want a monthly dashboard without building it yourself?

In a free 30-minute call we look at how your books are kept today and what it takes to get a reliable monthly report, in English.

Book a free call

Which KPIs should a small business track every month?

Six numbers answer the three questions that matter: am I selling enough, am I making money on what I sell, will I have the cash to pay. Add one or two that are specific to your business, no more.

The 6 KPIs of a monthly small business dashboard
KPIHow to calculate itWhat it tells you
Revenue vs budgetRevenue for the month divided by budgeted revenue, minus 1Whether you are selling as planned, and since when you are not
Contribution margin %(Revenue minus variable costs) divided by revenueHow much of every euro sold is left to cover fixed costs
Break-even pointFixed costs divided by contribution margin %The minimum revenue for the month to avoid a loss
EBITDA (MOL in Italian)Contribution margin minus fixed costsWhether day-to-day operations create value, before depreciation, interest and tax
Forecast cash balanceToday's balance plus expected receipts minus expected paymentsWhether in one, two or three months you will have the cash for salaries, F24 payments and suppliers
Days sales outstanding (DSO)Customer receivables divided by revenue (VAT included), times 30How long your clients keep your money

If you have employees, add staff costs as a share of revenue: it is the fixed cost that grows fastest and the one a new hire moves most. If you hold stock, add inventory turnover. Everything else you look at when you need it, not every month.

How do you build a financial dashboard in Excel?

Excel is the right tool to start with: you know it, it is flexible and it forces you to understand every formula. The secret is not the file, it is the sequence, the same every month.

  1. Split your costs. Separate variable costs (they grow with sales: goods, materials, commissions, shipping) from fixed costs (staff, rent, utilities, professional fees, software). Without this split you cannot calculate margin or break-even.
  2. Write the budget. Start from last year's revenue month by month and adjust for what you know: seasonality, new clients, price increases, a new hire. A simple, realistic budget beats a perfect one that is never updated.
  3. Load the actuals. By the 10th or 15th of the following month, take revenue and costs for the closed month from your bookkeeping, plus cash in and out of the bank, customer receivables and supplier payables.
  4. Read the variances and decide. Compare actuals with budget, check the six KPIs and for every significant variance write down a cause and an action, with a name and a date. Next month, check whether the action worked.
Stacks of printed Excel spreadsheets with columns of figures, sticky notes, a pen and a calculator on a small business desk in Italy, the typical starting point of a financial dashboard
Most small business dashboards start like this: printed spreadsheets, scattered numbers and good intentions. The method turns them into decisions.

How do you read one month of numbers? A worked example

These are the example figures from the free template: a small trading business with €38,000 of revenue in January, variable costs at 45% of revenue and €15,500 of fixed costs a month. Amounts net of VAT, rounded.

January: from actuals to KPIs
ItemAmount for the month
Revenue€38,000
Budgeted revenue€39,900 (variance about minus 4.8%)
Variable costs (goods, commissions, shipping)€17,100
Contribution margin€20,900 (55%)
Fixed costs (staff, rent, utilities, professional fees, marketing, other)€15,500
Break-even point (15,500 divided by 55%)about €28,200 of revenue
EBITDA€5,400 (about 14% of revenue)

January is below budget but almost €10,000 above break-even: not urgent, and the question is why €1,900 of sales are missing. Now look at August: with €30,000 of revenue the margin falls to €16,500 and, even with less marketing, fixed costs stay at €14,800. EBITDA drops to €1,700. And in December the 13th-month salary (tredicesima) takes staff costs from €9,500 to €17,500 in a single month. All of this is predictable: the dashboard is there so you see it in January, not discover it in September.

Want us to read your numbers with you?

Bring your last three months of figures to a free 30-minute call. We show you your break-even, your margin and the months when cash gets tight.

Book a free call

Where can you get a free financial dashboard template?

Right here: a ready-made Excel file with formulas and charts already set up and example data you simply overwrite. It also works in Google Sheets and LibreOffice.

Free download

Small business financial dashboard template (Excel, free)

  • Budget: your targets month by month, with revenue, variable and fixed costs, cash in and cash out.
  • Actuals: the real figures for each month, with contribution margin, EBITDA and bank balance calculated automatically.
  • Dashboard: the monthly KPIs (revenue variance, margin, break-even, EBITDA, cash, days sales outstanding) and three actual vs budget charts.
  • Instructions: the 4 steps to use it every month, on one page.

Download the free Excel template

Cells in grey italic are example data: replace them with yours. Cells with a light background contain formulas. If you would like us to fill it in and review it with you every month, book a free call.

When is Excel no longer enough?

Excel does not stop working: it stops being sustainable. The signal is not the size of your business, it is how much it costs you to keep the numbers current and reliable.

  • The file eats half a day a month. If copying, pasting and checking data takes more than four hours every month, you are paying in time for what a connected dashboard would do on its own.
  • The numbers arrive after the 20th. Actuals that land at the end of the following month are good for commenting, not for deciding. If the delay comes from the file, it is time to automate.
  • Several versions of the same file are in circulation. When you, your partner and your sales manager have different numbers, the meeting is spent arguing about which is right instead of what to do.
  • More locations, companies or business lines. Every extra dimension multiplies sheets and formulas. A dashboard shows you the total and the detail from the same data.
Excel or a connected dashboard: the comparison
ExcelConnected dashboard
Tool costPractically zeroSoftware licences and initial setup
Data updatesManual, at every month endAutomatic from bookkeeping and bank
Risk of errorsHigh: broken formulas, copy and pasteLow, if the rules are well defined
SpeedDepends on whoever updates the fileNumbers available as soon as the books are closed
Best forSmall businesses, one activity, one person in chargeSeveral locations or companies, several people reading the numbers, cash to follow weekly

Not sure whether it is time to switch?

In a free 30-minute call we look at your current file and tell you honestly whether Excel is still enough or a dashboard would pay for itself.

Book a free call

How do you move from Excel to a dashboard without losing control?

The switch almost always fails for the same reason: the tool is bought before anyone decides what it should measure. The right order is the other way round.

  1. Stabilise the model in Excel. Use the file for at least three or four months, until KPIs, cost split and definitions stop changing. The dashboard will copy those rules, right or wrong.
  2. Get the bookkeeping in order. Timely monthly entries, a consistent chart of accounts, cost centres if you need them (by location, line or client). A dashboard does not clean dirty data: it only makes it faster.
  3. Connect the data sources. Bookkeeping, bank and, if you have them, your invoicing or management software: the goal is that nobody copies numbers by hand any more.
  4. Choose the simplest tool that does the job. Often the dashboard in your accounting software, or a tool such as Power BI or Looker Studio, is enough. The tool matters less than the method.
  5. Keep the monthly review. A dashboard does not replace reading the numbers. One hour a month, always the same week, with actions written down and checked the following month.
Monthly financial report with revenue, margin and cash charts on a tablet and on paper, discussed during a meeting in an office in Italy
A dashboard gets you the numbers faster; decisions still happen in a monthly review, with the report on the table.

Which mistakes make a financial dashboard useless?

The problem is almost never the tool. It is the method, or the lack of timely data.

  • Late bookkeeping. If entries are made quarterly, monthly actuals are an estimate. A dashboard starts from books closed every month.
  • Watching only turnover. More revenue does not mean more profit. Without contribution margin you cannot tell whether growth makes you money or just more work.
  • No budget. Without a written target every month looks normal. Even an imperfect budget gives you something to measure against.
  • Too many KPIs. Nobody reads thirty indicators. Six numbers read every month beat a full dashboard opened once a year.
  • Reports without actions. If nothing changes after reading the numbers, the dashboard has become a chore. Every significant variance deserves an action.
  • Forgetting cash. A profitable business can run out of cash. The 13th-month salary, tax advance payments and late-paying clients need to be seen months ahead.

Who can run monthly financial control for your business in Italy?

Whoever already keeps your books has the data: the extra step is using it every month to help you decide. That is how we work at TMG Books: an organized team that handles the full range of commercialista services and, on top of that, your monthly financial control. Everything in English.

  • Books closed every month. Timely monthly bookkeeping: the foundation without which no report can be trusted.
  • Monthly financial control. Budget, actuals, KPIs and cash prepared and reviewed with you every month through our financial control service, linked to your bookkeeping.
  • Tax compliance handled by a team. Tax returns, deadlines and tax planning handled by a team, not one person always in a rush. You always know who is on your file and when you will get an answer.
  • A plan that fits. Several locations, several companies or a dashboard to connect? We build it into a custom plan around your business.

Frequently Asked Questions (FAQ)

What is a financial dashboard for a small business?

It is one page, updated every month, that compares your real numbers with your targets so you can see where you make money, where you lose it and what to fix while there is still time.

Behind it sit four things: an annual budget split by month, monthly actuals taken from your bookkeeping, a handful of KPIs always calculated the same way, and a monthly review where you decide actions. In Italy this is called controllo di gestione. You do not need a finance department or expensive software to start: you need up-to-date books and a method. To set it up for your business, book a free call.

What is the difference between bookkeeping and a financial dashboard?

Bookkeeping records what happened, mainly for tax and the annual accounts; a financial dashboard uses those same numbers to decide what to do next month.

Your books tell you what you invoiced and what tax you owe, often months later. A dashboard tells you which product, client or location really makes money, whether you are above or below budget and how much cash you will have in three months. It only works if the bookkeeping is closed on time, which is why it pays to have the same team handle both. To see how they connect, book a free call with our team.

Which KPIs should a small business track every month?

Few, and always the same: revenue against budget, contribution margin, break-even point, EBITDA, forecast cash balance and days sales outstanding.

Those six numbers answer the three questions that matter: am I selling enough, am I making money on what I sell, will I have the cash to pay. If you have employees, add staff costs as a share of revenue; if you hold stock, add inventory turnover. Track more than ten KPIs and nobody reads them. To choose the right ones for your business, book a free call.

Can I build a financial dashboard in Excel?

Yes, and for most small businesses it is the right place to start: a well-built file with budget, actuals and a dashboard sheet is enough while the data is small and one person updates it.

Excel's limit is not power, it is maintenance: data copied by hand, formulas that break, several versions of the same file. Our free template already has the sheets, formulas and charts in place, so you start from the method rather than the formatting. When updating it takes too long or the numbers arrive too late, it is time to move to a connected dashboard. To check where you stand, book a free consultation.

When should a small business move from Excel to a dashboard tool?

When updating the file takes you more than half a day a month, when the numbers arrive after the 20th of the following month, or when several versions of the same file are in circulation.

Other signals: you run more than one location, company or business line, you want to see cash week by week, or someone besides you needs to read the numbers. At that point a dashboard connected to your bookkeeping and bank saves time and errors. Stabilise the model in Excel first, though: a dashboard built on muddled KPIs stays muddled. To weigh up the switch, book a free call.

How much does it cost to set up a financial dashboard for a small business?

To start, almost nothing in tools: with an Excel template you only need the time to build a budget and up-to-date monthly bookkeeping.

The real cost is time: collecting the data, checking it, reading it and deciding. That is why many owners hand it to whoever already keeps their books, so the report arrives on time without extra work on their side. A dedicated dashboard tool adds software licences and an initial setup to connect the data, which only pays off when your volumes justify it. For an estimate on your case, book a free call.

How often should I review my financial dashboard?

Every month, with the figures for the month just closed ready within the first 10 to 15 days of the following month.

Quarterly is too late: a margin or collections problem found after three months has already become a cash problem. Cash itself deserves a closer look, ideally a weekly forecast over the next 12 weeks. A monthly rhythm only works if your bookkeeping is monthly too: many small businesses in Italy have their books updated only quarterly, and that is where you start. To set a realistic calendar, book a free call.

What is contribution margin and why does it matter so much?

It is what is left of revenue after variable costs, in other words the money each sale brings in to cover fixed costs and generate profit.

In our example, with €38,000 of revenue and €17,100 of variable costs, the contribution margin is €20,900, or 55%. It is the number that tells you whether more revenue makes you more money or just more work, and which product or client to push. Many small businesses only watch turnover and find out too late. To calculate it by product or client, talk to our team.

How do I calculate my break-even point?

Divide your fixed costs by your contribution margin percentage: the result is the minimum revenue you need to avoid a loss.

With €15,500 of fixed costs a month and a 55% contribution margin, break-even is about €28,200 of monthly revenue. Below it you lose money, above it you make money. Recalculate it every time fixed costs change, for example with a new hire or a new lease, because it is the first number to move. To work it out on your own figures, book a free call.

What is the difference between budget and actuals?

The budget is what you plan to do, the actuals are what you really did: financial control lives on the gap between the two.

The variance tells you where to look. If January's budget said €39,900 of revenue and the actuals say €38,000, you are about 4.8% below: the question is not the number, it is why and what you do in February. Without a budget you have no reference and every month looks normal. To build your first budget, book a free call.

Why can a profitable small business run out of cash?

Because profit is measured on invoices issued and costs incurred, while cash moves only when you actually collect and pay, and the two can be months apart.

Clients paying at 60 or 90 days, growing stock, the 13th-month salary in December, loan instalments and Italian tax advance payments all absorb cash even when the profit and loss is positive. That is why cash has a permanent place on the dashboard, with a forecast for the coming months and days sales outstanding. To build your cash plan, book a free call.

Which software do small businesses use for financial dashboards?

For a small business the most common business intelligence tools, such as Power BI or Looker Studio, or the dashboards built into your accounting software, are usually enough.

The tool matters less than it seems. Three things matter more: data flowing automatically from your bookkeeping and bank, KPI definitions identical to the ones in your Excel file, and someone checking the numbers before you read them. A beautiful dashboard with wrong data does more damage than a simple spreadsheet. To choose the right tool, book a free call.

Can my accountant in Italy run my financial dashboard?

Yes, and it makes sense: whoever keeps your books already has the data, and if they work proactively they can turn it into a monthly report that helps you decide.

The limit of the traditional model is that the commercialista calls you about deadlines, not margins. We work as an organized team: we handle the full range of commercialista services, from bookkeeping to tax returns, and on top of that we deliver your monthly financial control with budget, actuals, KPIs and cash, reviewed with you, in English. To see how it would work for your business, book a free 30-minute call.

How do I start building a financial dashboard tomorrow?

Download the free template, enter the last three months of figures from your bookkeeping and write a simple budget for the next twelve.

Then block one hour a month in your calendar to read the dashboard and decide at least one action for every significant variance. If your bookkeeping is not ready in time, that is the first thing to fix: no model works without timely numbers. If you would rather have a team set it up and keep it updated for you, book a free call.

Want to know every month how your business is really doing?
Let us set up your dashboard together.

In 30 minutes we look at your numbers, choose the KPIs that matter for you and tell you whether Excel is enough or it is time for a dashboard. No commitment, no surprises.

Book your free call

Enjoy This Article? You May Also Like:

Reviewed by the TMG Books team (November 2026). Figures are illustrative, based on the template's example data; they are not advice for your specific case.