What a business dashboard really costs a Nepali SME

A one-page dashboard for a Nepali SME usually costs more in setup hours than in software. Tool licences run from zero to about US$90 a month for a five-person team. The real cost is two to six weeks of connecting, cleaning and agreeing on numbers. It pays back when someone is spending hours every week building reports by hand, and not otherwise.

Where does a Nepali SME's data already live?

Almost every business we talk to already has more data than it uses. It just sits in five places that don't talk to each other.

• Billing or POS software, which records every sale. Since April 2026, businesses above Rs 200 million in turnover must bill through IRD-certified software linked to the government's CBMS system, so that data is already structured.
• Accounting books in Tally or a similar package, holding receivables, payables and expenses.
• Bank statements, including QR settlements. Merchant QR codes in Nepal went from 282,000 in mid-2021 to 2.34 million by January 2024, so a lot of sales now land in the bank as digital records.
• Google Sheets and Excel files for stock counts, targets and anything the software doesn't cover.
• The owner's head, which is the most up-to-date and least shareable source of all.

None of this needs new software to collect. It needs a way to put it side by side.

Why can't owners see it, then?

Because turning it into a picture is manual, slow and usually one person's job. The accountant exports sales, copies bank lines into a sheet, fixes the names that don't match, and emails a summary. That happens at month-end. So by the time you see that a product stopped selling or a customer stopped paying, it has been happening for three weeks.

This isn't only a Nepal problem. McKinsey's research on knowledge workers found they spend about 19% of the working week searching for and gathering information. Anaconda's 2020 survey of data professionals put loading and cleaning data at about 45% of their time. If trained analysts lose that much to preparation, a busy accountant doing it on the side is unlikely to do better.

There is also a quality problem. Raymond Panko's review of fifteen years of spreadsheet research concluded that spreadsheet errors are common and non-trivial. A monthly report rebuilt by hand gets fresh chances to be wrong every month. And when the one person who understands the file goes on leave, the report simply doesn't happen.

What does a dashboard project actually involve?

Five steps, and only the fourth is about charts. First you connect: get a copy of each source out on a schedule. Then you clean: make names, dates and codes consistent. Then you model: write down, once, what each number means. Then you visualise: put six to ten of those numbers on one page. Finally you set a refresh schedule so it updates without anyone touching it.

The step people underestimate is modelling. It sounds technical, but it's really a conversation. Does a sale count when the bill is raised or when the money arrives? Are returns taken off on the day they happen or against the original sale? Two partners with different answers will get different numbers from the same data. Settling that is most of the value.

How does the pipeline fit together?

Here is the shape we'd use for a typical trading or retail business with a billing system, Tally, a bank account taking QR payments and a few working sheets.

A small business doesn't need a data warehouse for this. A scheduled import, a set of cleaning rules and a small database are enough. The same pattern scales up, as in our executive KPI dashboard blueprint, but most SMEs never need the bigger version.

What does it cost in hours and licences?

Build effort is where the money goes. For three or four sources and one page of numbers, our planning range is roughly 54 to 174 hours. The wide range is almost entirely down to how messy the data is and whether the sources can be exported automatically.

Licences are the smaller line. As of August 2026, Power BI Pro is US$14 per user per month, up from $10 before April 2025. Google's free report builder, renamed from Looker Studio back to Data Studio in April 2026, costs nothing, and its Pro tier is $9 per user per project. Metabase is free to self-host, with a hosted Starter plan from about $90 a month for five users on yearly billing.

Those are dollar list prices. A Nepali business also pays VAT, a card or bank fee and the exchange margin, and needs a dollar-capable card with enough limit for a recurring charge. That's one reason free and self-hosted options are popular here. Choosing between the tools deserves its own comparison, so we'll leave it there.

Where does the payback come from?

Three places, in order of how easy they are to count.

• Hours of manual reporting you stop spending. This is the one you can measure before you start.
• Faster decisions. A slow-moving product or a branch having a bad week shows up in days, not at month-end.
• Problems caught earlier. Unpaid credit sales, stock that isn't moving and a tightening cash position all become visible sooner, when they're cheaper to fix.

Do the first one as arithmetic. Say your accountant spends six hours a week putting together sales and cash reports. That's roughly 300 hours a year. If a dashboard build takes 100 hours and cuts the manual work to one hour a week, the build hours come back in about five months, before counting anything the faster numbers help you catch. Plug in your own hours. If the answer comes out in years rather than months, that's telling you something. Our post on how automation ROI actually works walks through the same method in more detail.

When is a dashboard not worth it?

More often than vendors admit. Skip it, or wait, if any of these are true:

• Nobody spends more than an hour or two a week on reports now. There's nothing to save.
• Your sales and stock aren't recorded in software yet. Fix the recording first; a dashboard over guesses is just a prettier guess.
• You can't name the decisions it would change. If the numbers won't change what you do on Monday, they're decoration.
• The business is changing shape fast, with a new product line or a merger. Definitions will move, so wait until they settle.

In all of these cases a cheaper first step is a fixed-layout spreadsheet that one person updates weekly. It shows you which numbers people actually look at, which is exactly the brief a proper dashboard needs later.

What should you do this week?

List every report someone in the business builds by hand, how often, and how long it takes. Write down the three decisions you most wish you could make sooner. Check whether your billing software and bank can export a file on a schedule. With those three answers you can tell in an afternoon whether a dashboard would pay for itself, and roughly how big the job is.

If you'd like a second opinion on those answers, talk to us. Our data visualisation service starts with exactly that scoping, and we'll tell you honestly if a spreadsheet will do.