INTERNAL DASHBOARDS

Nepal business owners reviewing last month's performance in a spreadsheet on the 15th of the following month are making decisions about a situation that changed two weeks ago — a live dashboard connects the data that already exists in your systems

Connect your accounting software, Google Sheets, and operations data into a single live view. Stop compiling reports. Start reading them.

Request a Dashboard Diagnostic → View the evidence →
This is for you if

Hotel groups and independent properties tracking occupancy rate, average daily rate, RevPAR, and booking channel source across multiple properties or room types need a single operations view that updates daily. Right now most Nepal hospitality businesses pull these figures from their property management system into a spreadsheet, compare them manually against the same period last year, and circulate a PDF to the management team once a week. A Looker Studio dashboard connected directly to the source data gives the general manager and ownership group the same view every morning, segmented by property, room category, and booking channel, without the weekly compilation.

Importers and trading businesses tracking inventory levels, purchase order status, outstanding receivables, and foreign currency exposure are managing at least four data streams that rarely appear in the same view at the same time. Inventory sits in one system, receivables sit in the accounting software, foreign exchange exposure sits in a separate spreadsheet maintained by the finance officer. When the owner asks for a combined picture of the business, someone spends half a day pulling those figures together. A connected operations dashboard gives that combined view permanently, updated whenever any of the source systems changes.

IT firms managing multiple client projects need a dashboard that shows project billing utilisation, staff allocation, revenue per client, and outstanding invoices across the whole portfolio in one view. Project managers currently track their own projects in separate spreadsheets. The finance manager tracks invoices separately. The business owner has no live view of which projects are profitable, which clients have outstanding balances, and which staff members are over- or under-allocated. A dashboard that connects the project tracking data, timesheet system, and accounting software closes that gap.

Construction companies and developers tracking active projects need a live view of cost versus budget, milestone completion percentage, and subcontractor payment schedules. Project cost variance is currently identified at the monthly finance review, by which point overruns have been accumulating for three to four weeks. A live project dashboard connected to the cost tracking system and project schedule flags cost variance the week it appears, not the month after.

What's broken

Business performance data spread across six separate Google Sheets

Most Nepal SMEs track different parts of the business in separate Google Sheets maintained by different people. Revenue is in one sheet maintained by the finance officer. Inventory is in another sheet maintained by the operations manager. Marketing spend is in a third sheet maintained by whoever manages the ad accounts. There is no single view that shows revenue, costs, and margins together, which means the owner can see any one piece of the picture clearly but never the whole picture at once. When the sheets are built by different people at different times, the column structures do not match, the date ranges are inconsistent, and combining them requires manual work every single time.

Monthly reports compiled manually by finance staff

The standard Nepal business reporting process involves the finance officer spending two to three days at the end of every month pulling figures from Swastik or FACTS, cross-referencing them against the bank statement, reconciling them with the operational data held in separate spreadsheets, and then formatting the result into a report that the owner reviews on the 10th or 15th of the following month. This process is not producing better information than a live dashboard would produce. It is producing the same information, two weeks late, at a cost of two to three working days per month. A configured Looker Studio or Power BI dashboard connected to the source systems produces that same view every day without the compilation work.

No operational alert for threshold breaches

Nepal businesses currently identify that stock has dropped below the reorder level, that a receivable has passed 60 days overdue, or that a project has exceeded its budget only when someone compiles the monthly report and notices the figure. There is no alert that fires when the threshold is crossed. A live dashboard with configured alert thresholds sends a notification when stock drops below the reorder point, when a receivable ages past the agreed credit terms, or when a project's cost-to-date crosses 80 percent of the approved budget. Identifying these situations in real time rather than at the month-end review changes the response time from weeks to days.

Marketing spend and revenue not visible in the same view

Nepal businesses running Facebook and Google advertising have their ad spend data in the ad platforms and their revenue data in the accounting software. No one has connected these two data sources into a single view, which means blended return on ad spend is calculated manually, infrequently, and often incorrectly. The marketing team reports on ad platform metrics. The finance team reports on revenue. The owner is not certain which ad spend is producing which revenue. A Looker Studio dashboard that pulls spend data from Facebook Ads and Google Ads and revenue data from the accounting system or sales records into a single view makes blended ROAS visible every day without the manual calculation.

What we engineer

Map the data sources the business already has in operation

We start by mapping the data sources the business already has in operation. For most Nepal businesses this means accounting software (Swastik, FACTS, or Tally), one or more Google Sheets tracking operational data, an ad platform account (Google Ads or Facebook Ads), and possibly a property management system, project tracking tool, or inventory management system. We document what data lives where, what format it is in, and what connection method is available for each source.

Identify the reporting views the business actually needs

We then identify the reporting views the business actually needs. Leadership views are different from operations views. The owner needs to see revenue, margin, and cash position at a glance. The operations manager needs to see stock levels, project status, and open purchase orders. The finance officer needs to see receivables ageing and expense categories. We design each view for the person who will use it, not as a single dashboard that shows everything to everyone.

Select the dashboard tool that fits the business

For Nepal SMEs, Looker Studio is the most practical starting point. It is free, it connects directly to Google Sheets and Google Ads without additional connectors, and it produces clean, readable dashboards accessible on any device. For Nepal businesses that already use Power BI or want enterprise-grade data modelling, we build in Power BI using connectors appropriate to the source systems in use. We configure the tool to match the business, not the other way around.

Connect the data sources

We connect the data sources. For Google Sheets this is a direct Looker Studio connector. For accounting software like Swastik or FACTS, we work with the export formats available and build a structured data pipeline that keeps the dashboard updated. For ad platforms, we use native API connectors where available or scheduled exports where not. We document every connection so the business understands how the data flows and can maintain it independently.

Build the dashboard views and configure alerts

We build the dashboard views, configure the KPI scorecards, trend charts, and period-comparison tables, and set up any operational alert thresholds the business needs. For hotel dashboards this means occupancy, ADR, and RevPAR by property and room type. For trading companies this means receivables ageing, inventory levels, and outstanding purchase order value. For construction companies this means cost versus budget by project and milestone completion percentage. We configure the specific metrics the business actually tracks, not a generic template.

Hand over with documentation and support

We hand over the dashboard with documentation and a walkthrough session so the team knows how to read it, how to filter it, and how to identify when something in the data feed needs attention. We include a 30-day support period for questions and adjustments as the team begins using the live view in daily operations.

Request a Dashboard Diagnostic →
What changes

Before
After
Before Most Nepal SMEs track different parts of the business in separate Google Sheets maintained by different people. Revenue is in one sheet maintained by the finance officer. Inventory is in another sheet maintained by the operations manager. Marketing spend is in a third sheet maintained by whoever manages the ad accounts. There is no single view that shows revenue, costs, and margins together, which means the owner can see any one piece of the picture clearly but never the whole picture at once. When the sheets are built by different people at different times, the column structures do not match, the date ranges are inconsistent, and combining them requires manual work every single time.
After Business owners stop waiting for the monthly report and start reading live performance data every morning before the day's decisions are made. The two-to-three-day monthly compilation process is replaced by a dashboard that updates automatically, which means the finance officer's time is redirected to analysis and planning rather than data assembly.
Before The standard Nepal business reporting process involves the finance officer spending two to three days at the end of every month pulling figures from Swastik or FACTS, cross-referencing them against the bank statement, reconciling them with the operational data held in separate spreadsheets, and then formatting the result into a report that the owner reviews on the 10th or 15th of the following month. This process is not producing better information than a live dashboard would produce. It is producing the same information, two weeks late, at a cost of two to three working days per month. A configured Looker Studio or Power BI dashboard connected to the source systems produces that same view every day without the compilation work.
After Threshold breaches are identified when they happen, not at the month-end review. Stock that drops below the reorder level triggers an alert the same day. Receivables that age past 60 days appear in the overdue view immediately. Project cost overruns appear the week they begin, not four weeks later when the monthly report is compiled.
Before Nepal businesses currently identify that stock has dropped below the reorder level, that a receivable has passed 60 days overdue, or that a project has exceeded its budget only when someone compiles the monthly report and notices the figure. There is no alert that fires when the threshold is crossed. A live dashboard with configured alert thresholds sends a notification when stock drops below the reorder point, when a receivable ages past the agreed credit terms, or when a project's cost-to-date crosses 80 percent of the approved budget. Identifying these situations in real time rather than at the month-end review changes the response time from weeks to days.
After Marketing spend and revenue become visible in the same view. Blended ROAS is calculated automatically from live ad platform data and revenue data. The owner can see which channels are producing revenue and which are not without asking the marketing team to manually compile the comparison.
Before Nepal businesses running Facebook and Google advertising have their ad spend data in the ad platforms and their revenue data in the accounting software. No one has connected these two data sources into a single view, which means blended return on ad spend is calculated manually, infrequently, and often incorrectly. The marketing team reports on ad platform metrics. The finance team reports on revenue. The owner is not certain which ad spend is producing which revenue. A Looker Studio dashboard that pulls spend data from Facebook Ads and Google Ads and revenue data from the accounting system or sales records into a single view makes blended ROAS visible every day without the manual calculation.
After Leadership, management, and operations teams each have a view designed for their function. The owner sees the top-level scorecard. The project manager sees cost versus budget and milestone status. The finance officer sees receivables ageing and expense categories. Each person has the information relevant to their decisions without navigating data designed for someone else.
How it works

  1. 01

    Data source audit.

    We document every system the business uses to store operational and financial data — accounting software, Google Sheets, ad platforms, property management systems, project tracking tools. We identify what data is in each system, what format it is in, and what connection method is available.

  2. 02

    Reporting requirements interview.

    We work with the business owner and department heads to define what questions the dashboard needs to answer, who will use each view, and what decisions each user is making that the dashboard should support. We map the required metrics and KPIs for each audience level.

  3. 03

    Tool selection and data pipeline design.

    We select the dashboard tool appropriate to the business (Looker Studio for most Nepal SMEs, Power BI for businesses requiring more complex data modelling) and design the data pipeline that connects each source system to the dashboard. We document the pipeline before building it so the business can review and approve the approach.

  4. 04

    Connection and data model build.

    We connect each data source, build the underlying data model, configure calculated fields (blended ROAS, cost variance percentage, receivables ageing buckets, occupancy rate), and validate that the figures in the dashboard match the figures in the source systems.

  5. 05

    Dashboard design and alert configuration.

    We build the dashboard views for each audience level, configure KPI scorecards and trend charts, and set up any operational alert thresholds. We review the design with the business owner and make adjustments before handover.

  6. 06

    Handover, documentation, and support.

    We deliver the live dashboard with written documentation covering how the data flows, how to read each view, and how to identify and resolve common data feed issues. We conduct a walkthrough session with the team and provide 30 days of support for questions and adjustments.

Request a Dashboard Diagnostic →
Common questions

Frequently asked questions about Internal Dashboards

How do I build a free live business dashboard for a Nepal SME using Looker Studio?

Looker Studio is a free Google product that connects directly to Google Sheets, Google Ads, and YouTube Analytics without any additional paid connectors. To build a live dashboard for a Nepal SME, you connect your Google Sheets data sources as Looker Studio data sources, create calculated fields for the KPIs your business tracks, and design report pages for each audience level. For data that does not sit in Google products (accounting software, Facebook Ads), you set up a structured export to Google Sheets that Looker Studio can read, or use a third-party connector. The result is a dashboard that updates every time the underlying data changes, at no software cost.

How do I connect my Nepal accounting software (Swastik or FACTS) to a dashboard tool?

Swastik and FACTS both support data export in CSV or Excel format. The standard approach for connecting these to a dashboard tool is to configure a structured export from the accounting software into a Google Sheet or a shared folder, and then connect the dashboard tool (Looker Studio or Power BI) to that export as a data source. The export can be scheduled daily or updated manually depending on how frequently the dashboard needs to refresh. For businesses that require a fully automated pipeline with no manual export step, a custom integration is built using the accounting software's available export API or file output path.

How do I build a hotel performance dashboard (occupancy, ADR, RevPAR) for a Nepal hospitality business?

A Nepal hotel performance dashboard requires occupancy rate (rooms sold divided by rooms available), average daily rate (total room revenue divided by rooms sold), and RevPAR (total room revenue divided by rooms available) calculated from the property management system's booking data. If the property management system can export booking data to Google Sheets or CSV, these metrics can be calculated as formulas in the data source and displayed in Looker Studio. The dashboard is typically structured to show current month versus prior year same period, a trend line over the last 12 months, and a breakdown by room type and booking channel. Properties with multiple locations add a location filter that lets the owner toggle between the combined view and any individual property.

How do I track project cost versus budget in a live dashboard for a Nepal construction or IT company?

Project cost versus budget tracking requires two data inputs: the approved budget per project (which is typically static and can be held in a Google Sheet) and the actual cost-to-date per project (which updates as costs are entered into the accounting software or project tracking tool). The dashboard connects both data sources, calculates the variance as a percentage of budget, and displays each active project with its current cost, approved budget, variance amount, and a percentage bar showing how much of the budget has been consumed. Alert thresholds are typically set at 80 percent budget consumed (early warning) and 100 percent (overrun). For Nepal construction companies tracking subcontractor payments, a separate view shows payment schedule milestones, amounts due, and payment status for each active project.

How do I create an outstanding receivables alert dashboard for a Nepal trading or import-export business?

An outstanding receivables alert dashboard pulls invoice data from the accounting software (Swastik, FACTS, or Tally), calculates the age of each outstanding invoice in days, and groups receivables into ageing buckets (0-30 days, 31-60 days, 61-90 days, over 90 days). The dashboard shows the total receivables balance, the value in each ageing bucket, and a list of the oldest and largest outstanding invoices. Alert thresholds are configured so that invoices crossing the 60-day or 90-day mark are highlighted in the dashboard view. For import businesses managing foreign currency receivables, the dashboard adds a foreign currency column showing the outstanding amount in both NPR and the foreign currency, so exchange rate exposure is visible alongside the ageing data.

Start here

Your accounting software, Google Sheets, and ad platform accounts already contain the performance data you need to run your business. The gap is not the data — it is the connection between the data and a view that is available every morning without anyone compiling it. We build that connection, configure it for the specific metrics your business tracks, and hand it over with documentation so your team can use it and maintain it independently. If you want to understand what a dashboard would look like for your business before committing to a build, start with a diagnostic conversation.

Request a Dashboard Diagnostic →