Your Xero reports in Power BI 

Coming soon – automated Xero reporting with Power BI

“Insights for Xero is a reporting solution that enables you to produce engaging Xero reports for multiple companies in Microsoft Power BI.  This Xero add-on solution comprises software connector and a suite of Power BI templates, enabling: 
  1. Automation

    Fully automated business intelligence reporting from Xero, using Microsoft Power BI. Multi-company reporting available. 

  2. Insights

    Deep drill-down from Xero dashboard to transaction line item.

  3. Access

    Access to the complete set of your Xero data going back over the last 25 months, so that you can create detailed Profit & Loss, Balance Sheet, Cash Flow, Accounts Receivable and other reports.

  4. A Fast Start

    A fast start to your reporting project with pre-built Power BI Desktop templates for Xero Accounts, on several topics.

Register your interest
Your Xero reports in Power BI 1
Your consent is required to display this content from youtube - Privacy Settings
Watch video
Your Xero reports in Power BI 2

Make your Xero reporting better.

Example Profit & Loss Report page

Your Xero reports in Power BI 3

Example Receivables Report page

Power BI Accounts Receivable Report

The Accounting Insights Xero connector

The Accounting Insights connector maintains a separate reporting database of your Xero data that you can add as a data source to your Power BI reports.  The connector enables: 

  • Automation of your Power BI reports from Xero. In the background, the connector extracts your data from Xero into an external database that Power BI can interrogate.  It allows you to schedule up to eight daily, automated report refreshes by the Power BI service, without you having to connect to Xero and extract your data.
  • 25 months of your Xero data on tap.  Insights for Xero maintains a database of your last 25 months of Xero data that is always ready for your Power BI reports.  You won’t experience long waits and timeouts when you refresh your Xero reports in Power BI.  In this way, you will always be able to track your performance this YTD against last YTD.
  • Multi-company reporting. So you want to build a dashboard for multiple Xero organisations?  No problem.  You can connect to all of your Xero organisations and pull their data into a single reporting model.

Power BI templates for Xero

Downloading your Xero data into a reporting tool like Power BI is just the first step on a journey to great Xero reports.  The next steps are to transform your raw Xero data into a useful Power BI dataset and then turn this dataset into meaningful and accurate reports for your business.

  • They transform your Xero data into a reporting-ready dataset with the following tables:
    • Dimension tables
      • Organisation – your Xero organisation defaults, such as year-end month etc.
      • Currencies
      • Customers
      • Dates – a ready-to-go dates table set to your financial year
      • Accounts – your GL accounts and their reporting hierarchy 
      • Items – your stock information
      • Suppliers
      • Tracking Categories
    • Transaction (“Fact”) tables
      • SalesInvoices – a table of your sales invoices and their line items
      • PurchaseOrders – a table of your purchase orders and their line items
      • Receivables & Payables 
      • Transactions – a table of all of your posted financial transactions and their line items
  • A collection of measures tables with pre-built measures for your reports
  • You receive a free basic template when you register for a free trial of Accounting Insights for Xero. This includes the above tables and sample report pages covering:
    • Sales
    • Receivables
    • Item Sales
    • Purchase Orders
    • Profit & Loss
  • Additional premium templates are available for:
    • Advanced Profit & Loss
    • Balance Sheet
    • Receivables & Collections

Your own custom Xero reports

Using the Xero connector and our Power BI Desktop templates you can create your own custom reports very easily (or we can do this for you very efficiently).

Subscribe for updates, news & offers.

Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Consent to display content from Youtube
Consent to display content from Vimeo
Google Maps
Consent to display content from Google
Consent to display content from Spotify
Sound Cloud
Consent to display content from Sound
Cart Overview