Understanding the Standard Layout Parameter in the Xero Reports API

July 23, 2024

Historically, the ‘Standard Layout’ parameter within the Xero API was designed to control the format of profit and loss reports.

Standard Layout = TRUE: This setting generated a standard profit and loss report as it would appear in the Xero user interface without any customisations.
Standard Layout = FALSE: This option originally displayed account codes and numbers based on the default custom report settings in the Xero user interface. However, it’s important to note that this setting no longer functions as intended for the newer custom report styles introduced in 2023.

It's important to note that the ‘Standard Layout = FALSE’ option is no longer relevant to the new Xero custom reports. This is an old parameter that relates to Xero’s Custom Reports, so any values or integers applied to account codes via the old Xero Custom Reports will continue to be applied when the Standard Layout = FALSE on the Xero API for the Profit and Loss report.

"Have questions or need further assistance? Reach out to us!"

learn 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

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

How to connect your Xero account(s) to AccountingBi

This guide will walk you through two methods for connecting your Xero accounting software to AccountingBi
READ MORE

How to call your profit and loss account reports from Xero to AccountingBi

We have outlined a step-by-step process of calling your profit and loss report data from your Xero account to AccountingBi - article and video.
READ MORE

How to call the balance sheet reports from Xero to AccountingBi

We have outlined the steps of calling balance sheet reports from Xero to AccountingBi in a video (watch below) and an article.
READ MORE

How to connect Microsoft excel to Xero through AccountingBi

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.
READ MORE
1 2 3 7
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