From the dashboard, head to Organisations tab. If you have already connected your Xero account to AccountingBi, you will find it listed on this dashboard.
Navigate to the ‘Reports” tab and click on “Chart of Accounts”. Select the Xero organisation you want data for and click on submit.
After clicking “Submit,” a popup notification appears showing the progress. Wait for it to finish and then close it.
Navigate to the Profit & Loss reports under the Reports tab
Choose the desired date range, timeframe (month) and layout.
In the “To date” field, select the ending date of the month (always select a month with 31 days),
Periods: set the number of previous periods you want
Timeframe: select as month
Standard layout as ‘Yes’ (For US organisation, select ‘No’)
Click ‘submit’, wait for the notification, and ensure it’s completed.
Once complete, head to the "Connectors" tab on the top right corner. There, you'll find a Bearer Token – copy it, as this will be used to fetch reports in Excel.
How to know you have successfully extracted your profit and loss account from Xero
To find out if your call has been successful:
Navigate back to the homepage.
Check the status of your call under Your API Call Report
As an accountant, you may find yourself referring to multiple sources to track the performance of your client’s cash flow, profitability, business trends and even bookkeeping cycle. What if you could access those results and comparisons automatically refreshed, on-demand, from your tablet, smartphone, PC, or even wearable device? Business intelligence and data visualisation systems can provide accountants with – the critical data and organisation summary in a custom format in one (or more) visuals or a dashboard. One of these powerful business intelligence tools is PowerBI.
DAX (Data Analysis Expressions) is a formula expression language developed by Microsoft to interact with data in different analysis services and visualisation tools platforms like Power BI, PowerPivot and SSAS tabular models. DAX can seem familiar to competent excel users as the language uses similar formulas and expressions.
This video and article provide steps for connecting Xero to PowerBi through AccountingBi. It assumes that you've already pulled the Xero API from accounting BI for your various reports.
