INTERNAL DASHBOARDS

UK businesses compiling monthly board packs from Sage, Xero, and a CRM export every month-end are spending half a finance working week on a task that a connected Power BI dashboard would reduce to a single refresh

Live financial and operational dashboards built for UK businesses — connected to Sage, Xero, HubSpot, Salesforce, and your operational systems, with your actual financial year configured from day one.

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

UK professional services firms — management consultancies, law firms, accountancies, and recruitment businesses — tracking staff utilisation, billable realisation rates, project profitability, and debtor days need a leadership dashboard that connects directly to their practice management system and accounting platform. A dashboard built on Xero or Sage data, combined with CRM pipeline figures, gives partners and directors a single view of financial performance without relying on a monthly Excel build from the finance team. Debtor day trends and WIP ageing are visible in real time, not at month-end.

UK retail and hospitality businesses tracking daily sales by location and channel, basket size, stock turn, and margin by category across multiple sites or brands need performance dashboards that connect EPOS and POS systems — including Lightspeed, Square, and other UK retail platforms — to a centralised reporting view. A location-level dashboard shows which sites are performing above target and which are underperforming before the weekly management meeting, not after a manual data pull. Category margin and promotional performance are visible without a separate spreadsheet model.

UK manufacturing and distribution businesses tracking production output, OEE (Overall Equipment Effectiveness), order fulfilment rates, and inventory movement across warehouse and factory sites need operational dashboards that connect ERP, WMS, and production data into a single view. Management decisions about shift planning, supplier performance, and stock replenishment currently depend on data extracted from separate systems and reconciled manually. A connected operational dashboard puts live output, reject rates, and delivery performance in front of the operations team throughout the day.

UK FCA-regulated businesses tracking compliance metric KPIs alongside operational performance need a combined dashboard aligned to their GABRIEL reporting calendar and FCA obligations. Compliance and operations data are typically stored in separate systems and reported separately, creating a fragmented picture for senior management. A dashboard that surfaces both operational KPIs and compliance indicators in one view — with period markers aligned to the FCA reporting schedule — gives regulated firms the visibility they need without maintaining two separate reporting tracks.

What's broken

UK Company Financial Year Not Configured in the Dashboard

UK businesses with a January or March financial year start date run dashboards that default to the calendar year, meaning year-to-date revenue comparisons are misaligned with the company's actual financial year as registered at Companies House. A business with a 31 March financial year end will see Power BI reporting nine months of the current calendar year as "YTD" when the financial year is already complete. FY start date configuration affects every trend chart, period comparison, and budget versus actuals calculation in the dashboard. This single misconfiguration makes every directional comparison in the board pack unreliable.

Sage and Xero Revenue Data Not Connected to CRM Pipeline in One View

UK businesses operating Sage or Xero for financial reporting alongside HubSpot or Salesforce for sales pipeline management are maintaining two separate pictures of commercial performance. Finance sees closed revenue; sales sees weighted pipeline. No connected dashboard shows pipeline coverage ratio against revenue target, or how the current quarter's pipeline compares to the same period last year. The blended view is built manually in Excel each month by a finance analyst who exports from both systems, reconciles entity names, and creates a single table. That process takes hours and produces a result that is out of date the moment it is finished.

VAT Return Periods Not Tracked in the Finance Dashboard

UK VAT-registered businesses on quarterly VAT return cycles are not flagging return deadlines anywhere in their operational dashboards. Finance teams are discovering a VAT return is due in ten days via a calendar reminder or an email from their accountant rather than a dashboard alert surfaced alongside cash flow and working capital metrics. Adding VAT period tracking to the finance dashboard — with period-end dates, submission deadlines, and estimated VAT liability calculated from live transactional data — adds compliance visibility to the same view that already shows revenue and cost performance. It is a configuration and data model addition, not a separate report.

No Location-Level Performance Split for Multi-Site UK Businesses

UK retail, hospitality, and service businesses operating multiple locations are aggregating all site sales into a single revenue line in their dashboards, making high-performing and underperforming locations invisible without a manual data pull. Management decisions about staffing, pricing, investment, and promotional activity are being made using blended averages that obscure the performance differences between sites. A dashboard with a location dimension — filterable by site, region, and channel — surfaces which locations are driving margin and which are eroding it. Building this requires a location attribute in the data model from the point of connection, not a retrofit after the dashboard is already built.

What we engineer

Connect to the systems already in use

Ignited Nepal builds internal dashboards for UK businesses that connect directly to the accounting, CRM, EPOS, and operational systems already in use — without asking the business to change platforms or introduce a new data warehouse before the first report is live. The process starts with understanding which decisions are being made slowly because the data is not visible in real time, and working backwards to the minimum data model that changes that.

Configure the correct UK financial year from the start

For UK businesses using Sage 50, Sage 200, Xero, or QuickBooks, the data connection is handled via certified connectors or direct API integration, depending on the platform version and hosting arrangement. Financial data is pulled into a Power BI data model with the correct UK financial year configured from the start — whether that is a 31 March, 31 December, or 30 June financial year end. Every period comparison, year-to-date calculation, and budget versus actuals measure is built against the actual company financial year, not the calendar year default.

Connect CRM pipeline to financial performance

CRM integration connects HubSpot or Salesforce pipeline data to financial performance in the same model, so leadership can see revenue recognised alongside pipeline coverage and conversion rate without switching between systems. For businesses using Salesforce, the integration includes opportunity stage, expected close date, and weighted value. For HubSpot, deal stage progression and pipeline velocity are surfaced alongside closed-won revenue from the accounting system.

Configure role-appropriate views from the start of the build

Role-appropriate views are configured from the start of the build. A board-level view shows revenue, EBITDA, cash position, and key operational indicators without row-level transaction data. A finance manager view adds cost line detail, debtor ageing, and VAT period status. An operations view shows fulfilment, utilisation, or production metrics depending on the business type. Each view is built in the same Power BI report using row-level security and page-level visibility rules, so a single dashboard serves all three audiences without maintaining three separate files.

Configure scheduled and automated reporting

Scheduled and automated reporting is configured so that the board pack, the weekly management summary, and the daily operational snapshot are distributed automatically to the right recipients on the right schedule — without a manual export or email from the finance team. Power BI subscription emails, automated PDF exports, and push alerts for threshold breaches are all part of the standard delivery.

Build a location dimension for multi-site businesses

For multi-site UK businesses, a location dimension is built into the data model from the point of connection, so every metric — revenue, margin, transactions, utilisation — can be filtered and compared by site, region, and channel. This is not a filter applied to an aggregate; it is a dimensional model that allows any combination of site-level analysis without rebuilding the report.

Request a Dashboard Diagnostic →
What changes

Before
After
Before UK businesses with a January or March financial year start date run dashboards that default to the calendar year, meaning year-to-date revenue comparisons are misaligned with the company's actual financial year as registered at Companies House. A business with a 31 March financial year end will see Power BI reporting nine months of the current calendar year as "YTD" when the financial year is already complete. FY start date configuration affects every trend chart, period comparison, and budget versus actuals calculation in the dashboard. This single misconfiguration makes every directional comparison in the board pack unreliable.
After Board packs go from a three-day finance task to a scheduled report that arrives in inboxes automatically. The monthly board pack is a Power BI subscription export — finance reviews it for narrative, not for compilation.
Before UK businesses operating Sage or Xero for financial reporting alongside HubSpot or Salesforce for sales pipeline management are maintaining two separate pictures of commercial performance. Finance sees closed revenue; sales sees weighted pipeline. No connected dashboard shows pipeline coverage ratio against revenue target, or how the current quarter's pipeline compares to the same period last year. The blended view is built manually in Excel each month by a finance analyst who exports from both systems, reconciles entity names, and creates a single table. That process takes hours and produces a result that is out of date the moment it is finished.
After Leadership sees revenue, pipeline, and cash in a single connected view for the first time. The gap between what the CRM shows and what the accounts show disappears; pipeline coverage ratio and debtor days are visible in the same dashboard.
Before UK VAT-registered businesses on quarterly VAT return cycles are not flagging return deadlines anywhere in their operational dashboards. Finance teams are discovering a VAT return is due in ten days via a calendar reminder or an email from their accountant rather than a dashboard alert surfaced alongside cash flow and working capital metrics. Adding VAT period tracking to the finance dashboard — with period-end dates, submission deadlines, and estimated VAT liability calculated from live transactional data — adds compliance visibility to the same view that already shows revenue and cost performance. It is a configuration and data model addition, not a separate report.
After The correct UK financial year is the basis for every comparison. YTD, prior year, and budget versus actuals calculations all align to the company's actual FY start date, eliminating the recalculation that currently happens manually every time a chart is shared with the board.
Before UK retail, hospitality, and service businesses operating multiple locations are aggregating all site sales into a single revenue line in their dashboards, making high-performing and underperforming locations invisible without a manual data pull. Management decisions about staffing, pricing, investment, and promotional activity are being made using blended averages that obscure the performance differences between sites. A dashboard with a location dimension — filterable by site, region, and channel — surfaces which locations are driving margin and which are eroding it. Building this requires a location attribute in the data model from the point of connection, not a retrofit after the dashboard is already built.
After VAT return deadlines are visible alongside cash flow in the finance dashboard. Finance teams stop discovering return deadlines via calendar reminders and start seeing them as a dashboard metric alongside estimated liability.
How it works

  1. 01

    Discovery and data audit.

    We map every data source — accounting platform, CRM, EPOS, ERP — and document what is in each system, how it is structured, and what the key business questions are that the dashboard needs to answer. We confirm the company financial year start date, VAT return period, and any FCA or regulatory reporting requirements at this stage.

  2. 02

    Data model design.

    We design the Power BI data model: source tables, relationships, calculated measures, and the dimensional structure — including location, period, and FY configuration. The model design is reviewed and approved before any build begins.

  3. 03

    Data connections and transformation.

    We connect to each source system using the appropriate method — certified connector, direct query, API integration, or scheduled import — and build the data transformation layer in Power Query. Financial year period tables and VAT return period flags are added to the date table at this stage.

  4. 04

    Dashboard build and role configuration.

    We build the report pages for each audience — board, finance manager, operations — and configure row-level security and page visibility. KPI scorecards, trend charts, and period comparison tables are built against the confirmed measures and reviewed against the original business questions.

  5. 05

    Automated reporting setup.

    Power BI subscriptions, scheduled email exports, and threshold alert rules are configured. The board pack, weekly summary, and operational snapshot schedules are set and tested before handover.

  6. 06

    Handover, documentation, and training.

    We deliver a data model documentation pack, a user guide for each audience group, and a training session for the Power BI report owners. A 30-day hypercare period covers any data connection issues or measure adjustments identified during the first month of live use.

Request a Dashboard Diagnostic →
Common questions

Frequently asked questions about Internal Dashboards

How do I connect Sage or Xero to a Power BI dashboard for a UK business?

Sage 50 and Sage 200 connect to Power BI via ODBC connector or the Sage Intelligence connector, depending on version and hosting; Xero connects via the certified Xero Power BI connector or through an intermediary API layer for more complex data models. The connection method depends on whether Sage is hosted locally, on a server, or in Sage Cloud — local Sage installations require a Power BI on-premises data gateway configured on the Sage server. Xero's API provides access to invoices, bank transactions, contacts, and financial reports in near real time. Both connections require a scheduled refresh cadence configured in Power BI Service to keep the dashboard data current.

How do I configure the correct UK financial year start date in Power BI or Looker Studio?

In Power BI, the financial year start date is set by creating a custom date table in DAX or Power Query that defines financial year, financial quarter, and financial period based on the company's actual FY start date rather than the calendar year default. A UK business with a 1 April financial year start requires a date table where FY 2025 runs from 1 April 2025 to 31 March 2026, and every YTD and prior year comparison measure references this FY definition. In Looker Studio, fiscal year configuration is set at the data source level for Google-native connectors, but for Xero or Sage connections via a custom connector, the fiscal period logic must be built into the data source query. Getting this right at the data model stage prevents every chart and comparison in the report from being misconfigured.

How do I add VAT return period tracking and deadline alerts to a UK finance dashboard?

VAT return period tracking is added to the Power BI data model by extending the date table with a VAT period dimension — quarterly or monthly VAT periods with start dates, end dates, and HMRC submission deadlines calculated for the business's specific VAT stagger group. A card visual showing days remaining to the next VAT return submission deadline can be placed on the finance manager dashboard page alongside estimated VAT liability calculated from live invoice data. Power BI alerts can be configured on a KPI card so that a threshold alert is triggered when the submission deadline is within a defined number of days. This is a data model and report configuration task, not a separate compliance system.

How do I build a multi-location sales performance dashboard for a UK retail or hospitality business?

A multi-location sales dashboard requires a location dimension in the data model from the point of connection — either mapped from a location field in the EPOS or POS system, or added as a lookup table that maps transaction IDs to location, region, and channel. Once the location dimension is in the model, every measure — revenue, transactions, average basket size, margin — becomes filterable and comparable by location without rebuilding the report. For UK businesses using Lightspeed or Square, the location data is available via the platform API and can be pulled directly into the Power BI model. Slicer panels and a location comparison matrix page allow management to rank sites by any metric and drill into individual site performance without leaving the dashboard.

What is the best dashboard tool for a UK mid-market business — Power BI, Looker Studio, or Tableau?

Power BI is the dominant choice for UK mid-market businesses, primarily because most UK businesses are already on Microsoft 365 and Power BI Pro licences are included in or add-on to existing Microsoft enterprise agreements at a lower per-seat cost than Tableau. Power BI also has the most mature certified connector ecosystem for UK accounting platforms — Sage, Xero, and QuickBooks all have supported Power BI connectors. Looker Studio is appropriate for UK businesses whose primary data sources are Google-native — Google Analytics, Google Ads, and Google Sheets — and where lightweight marketing and web performance reporting is the primary use case rather than financial or operational reporting. Tableau offers the strongest visualisation flexibility and is used by larger UK enterprises with complex analytical requirements and dedicated data analyst teams; for most UK SME and mid-market use cases, the Power BI cost and integration advantage outweighs Tableau's visualisation edge.

Our team

The people behind the work

Not a black box. Real specialists you can call, with their names on the work.

Niraj Raut

Niraj Raut

Founder — Ecommerce SEO
Keshab Joshi

Keshab Joshi

PPC Expert
Hawrry Bhattarai

Hawrry Bhattarai

Google Ads Expert
Arogya Rijal

Arogya Rijal

SaaS SEO Expert
About Us →
Start here

UK businesses spending finance team time compiling dashboards from Sage, Xero, and CRM exports are not facing a reporting problem — they are facing a missing data infrastructure problem. A connected Power BI dashboard with the correct financial year, the right data sources joined, and automated distribution does not require a major technology project. It requires a structured build with the right data model from the start. Ignited Nepal delivers that build for UK businesses, from discovery through to automated reporting and handover. The first step is a Dashboard Diagnostic, where we map your current data sources, identify the three to five decisions that would change with live data, and design the data model that makes the dashboard reliable from day one.

Request a Dashboard Diagnostic →