ARTICLES & USER MANUALS

General advice and guides from our accounting experts.

Filter our guides by using particular keywords e.g. DAX, Power BI, Integration

Free Accounting.BI PowerBI Dashboards for Multiple Xero Organisations

This article presents a simple yet effective dashboard that serves as a starting point for developing comprehensive reports and impactful solutions for your organization or accounting firm. Explore the features and functionalities available to unleash the full capabilities of Power BI and take your data analysis to new heights. Get a head start on your Power BI journey by leveraging this informative resource.
READ MORE

How to dynamically sync my Xero Sales and Purchase Invoices and Credit Notes to Excel and PowerBi

In this article and video, we explore how to dynamically connect Xero sales and purchase invoices and credit notes to Excel and PowerBi.
READ MORE

How to monitor the status of large API queries with the Accounting.BI real-time Log

Learn how to monitor the status of large API queries with the Accounting.BI real-time API log in our helpful video and article. First, let me get us to understand the purpose of the API Log: The API Log serves as a valuable tool for tracking the activity and status of our API queries in real-time. It helps us monitor the progress of our queries and identify any potential issues or errors that may arise during the process.
READ MORE

HOW TO DYNAMICALLY HANDLE XERO TRACKING CATEGORIES AND TRACKING OPTIONS FROM MICROSOFT EXCEL

Basic overview of Xero Tracking Codes Xero Accounting Software allows users to allocate any number of Tracking Codes to transactions within your accounting records. This allows for additional reporting capabilities without the need to endlessly expand the number of account codes within your Chart of Accounts. This could be used for reporting on different business units, regions, customer demographics and more. The concept works where a user can create a Tracking Category (such as Region), and within this category they will then create Tracking Options (such as North, South, East, West). After setting it up the bookkeeper can assign these Tracking Options to transactions as they post them to Xero within their usual bookkeeping cycle.
READ MORE

Annual Accounting Scheme-my interim payments are too high! How do I reduce them?

If you feel your interim payments to HMRC under the Annual Accounting Scheme are incorrect, you are request these to be re-assessed by HMRC by writing to the address below: BT VAT HM Revenue and Customs BX9 1WR
READ MORE

How to connect Microsoft Excel 2016 to Xero through AccountingBi 

This article explains how to get Xero data into Excel using AccountingBi API.
READ MORE

What to do when I get an error 'Exception of Type 'microsoft.mashup.engine.interface.resourceAccessForbiddenException' was thrown.' when using PowerQuery to access an API?

When using the Accounting.BI system to Excel or PowerBI the error usually means your Bearer Token (aka the password for our API) has changed/needs updating in PowerQuery.
READ MORE

Benefits of accessing Xero data via PowerQuery from Excel

PowerQuery is a business intelligence tool built into Microsoft (or downloaded as an add-on) that allows you to import data from many different sources (including Xero, via Accounting.BI). PowerQuery may change, adjust or shape data from your Xero account to suit your data analysis needs - before loading it into your Excel workbooks. 
READ MORE

How to consolidate data from multiple excel sheets using Power Query

Power Query is a powerful data transformation tool that allows you to combine data from multiple excel sheets into one table. It is a stock feature in Office 365 and Microsoft Excel 2016 and onward versions. You can also download Power Query as an add-in if you have Excel 2010 and 2013.
READ MORE
Accounting.bi - Business Intelligence Software
Copyright © 2023 Accounting.bi is a brand owned and operated by Accounting SQL Limited, incorporated in the United Kingdom. ​
Terms & Conditions - GDPR
How, can we help?