Balance Sheet Power BI Reports for Xero

Home / Report Templates / Balance Sheet Power BI Reports for Xero

The Balance Sheet Reports for Xero is a simple dashboard that provides a series of reports to analyse your Balance Sheet statements in Power BI. For an Excel version of these reports, see the Balance Sheet Excel Reports for Xero.

The dashboard includes:

  • Monthly Balance Sheet Report
  • Balance Sheet Variance By Month Report
  • Monthly Balance Sheet Chart

Not only this, but it can also consolidate data from multiple Xero Organisations (data files) when using the Consolidation OData Feed.

While this is a fully working and standalone dashboard, it can also be used as a starting point that can be further customised or modified as required to fit whatever business rules you need. It is not locked in any way. Because of this, it can also be used to learn how to create power queries, how to create DAX formulas, etc.

Reports Included

Monthly Balance Sheet Report

The Monthly Balance Sheet Report is a simple report that displays Accounts down the page and Months across the page.

Balance Sheet Variance By Month Report

The Balance Sheet Variance By Month Report compares This Month vs Previous Month and includes Variance and Variance %.

Monthly Balance Sheet Chart

The Monthly Balance Sheet Chart uses the same data as the Monthly Balance Sheet Report but display it as a chart instead.

Requirements

To use the report, you will need to:

  1. Have an OdataLink Subscription or Trial Account.
  2. Connect OdataLink to your Xero Organisation.
  3. Configure a Model that includes the following endpoints:

Download and Setup

You can download the Power BI templates from the following links:

There is also a Company Financial Reports template that combines Profit and Loss, Balance Sheet and Cash Flow all in one.

Once downloaded, you can connect it to your own data using this article.

How to Refresh in Power BI Desktop

To refresh it in Power BI Desktop, follow these steps.

  1. Under the Home tab, go to Transform Data and click on Edit Parameters
  2. Enter the Date Start and Date End for the months you wish to report on.
    This can be any date range but the larger it is, the longer the refresh will take to run.
  3. Click the Refresh button and wait for the data to download.

Find an issue with the template?

Let us know of any issues you find with the template. We built it to use the least amount of data possible but this might not suit everyone.