ARTICLES

General advice and guides from our accounting experts.

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

Handling Group Companies with US and Non-US Xero Organisations: Sorting out the Negatives

This article addresses a challenge encountered when consolidating reports across multiple Xero organisations in different regions. Here, we'll explore the issue with "Display Values" in Xero's Profit & Loss and Balance Sheet reports and how to rectify it.
READ MORE

Understanding the Standard Layout Parameter in the Xero Reports API

Are you confused about the "Standard Layout" setting in the Xero Reports API? This feature used to control how profit and loss reports looked, but it's changed. Let's explore what it does now.
READ MORE

How to Install PowerBi Custom Connector

This guide will walk you through installing a custom connector for Power BI, specifically the Accounting BI connector which allows you to connect your Xero data to Power BI for analysis.
READ MORE

Understanding AccountingBi Report Statuses

This article explains the different statuses you might encounter when running reports in Accounting.BI. Understanding these statuses can help you know what's happening with your report and when to expect the results.
READ MORE

HOW TO CALL YOUR CHART OF ACCOUNTS REPORTS FROM XERO TO ACCOUNTINGBI

We have outlined a step-by-step process of calling your chart of accounts report data from your Xero account to AccountingBi.
READ MORE

AccountingBi software has Cyber Essential Plus Certification

At AccountingBi, we understand that our clients trust us with their sensitive data. That is why we are constantly improving our data security to create a secure space that protects our(including clients’) data from cyber threats. 
READ MORE

Data Analysis Expression (DAX) for accountants

Download your free PDF of DAX functions designed specifically for accountants and finance professionals.
READ MORE

Power BI: What is DAX?

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.
READ MORE

Why is PowerBI important for Accountants?

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.
READ MORE
Accounting.bi - Business Intelligence Software
HOW IT WORKS...
Copyright © 2024 Accounting.bi is a brand owned and operated by Accounting SQL Limited, incorporated in the United Kingdom. ​
Terms & Conditions - GDPR