One screen for sales, stock and dues across every outlet

Who this is for

An owner with four supermarkets across Thanjavur and Kumbakonam has billing software in every outlet, Tally at the head office and a purchase register in Excel. Each system does its job. The trouble is that knowing yesterday's sales, margin and stock position across all four still means waiting for managers to send photographs of printed reports on WhatsApp, then adding them up by hand. By the time the picture is complete, it is a day old. A dashboard replaces none of those systems. It reads from them and shows one honest view, which is exactly what this owner is missing.

What the dashboard includes

• Connections to your existing data: billing software databases, Tally exports, Excel files and Google Sheets, read on a schedule that suits each source, from every few minutes to once a night.
• Views by role: the owner sees every outlet, a branch manager sees one, and the accountant sees collections and supplier dues, a pattern known as role-based access control.
• Exceptions before totals: the first screen lists what needs action, such as an outlet whose sales fell against the same weekday last month, or an item that will run out before the next delivery.
• Drill-down and exports: tap any total to reach the bills behind it, and export any table to Excel or PDF for the accountant or the bank.
• Alerts: a short WhatsApp summary each morning, and an immediate message when a threshold you set is crossed.

Tally, billing software and the owner's phone

It is common for an Indian retailer or distributor to run billing software from one vendor, Tally for the books and Excel for everything else, with none of them talking to the rest. A dashboard is the cheapest way to make them cooperate without touching anything the accountant relies on. Owners here also tend to run the business from a phone, so every chart is designed for a small screen first. Running costs are low: a small cloud server or the hosting you already pay for and, where billing data sits on a local computer, a lightweight sync program that sends it up.

Data first, charts second

The first stage is spent on the data, not the design. We list every source, check how clean it is, and agree the definition of each number with you: does "sales" include returns, is margin worked out on purchase price or landed cost. A dashboard whose figures disagree with the accountant's is ignored within a month, so this step matters more than any chart. Screens are then designed around the five or six decisions you make every week, and weekly demos use your real data. At launch, the dashboard runs beside your existing reports for a fortnight so you can compare the two before trusting it.

What it costs

A reporting dashboard over existing data sits in the same band as a single-module management tool, ₹50,000 to ₹1,50,000, and usually takes 6 to 10 weeks. Cost rises with the number of data sources, how messy they are, how fresh the figures must be and how many role-specific views you need. When the project grows to include new data entry, such as purchase approvals or a stock audit screen, it becomes a management system and is priced like one; our page on custom ERP software covers that route.

When Looker Studio or Power BI will do

If your data already lives in one clean place, such as a single billing system or a well-kept Google Sheet, start with the reports your software already offers, or connect the sheet to a free tool like Google Looker Studio. Microsoft Power BI is another strong choice if someone on your team will maintain it. If stock is your main question, read our comparison of Google Sheets and inventory software first. A custom dashboard from VS Tech Builders is worth it when data is scattered across systems, when different people must see different slices, or when you want alerts rather than another screen to remember. If the billing at each outlet is itself unreliable, fix that first, because no dashboard is better than its source data; that groundwork is part of our software for supermarkets.