As you may be aware, Xero has had two versions of reports for some time — the older version and Xero's ‘new’ reports. Xero's new reports are built on the latest technology and have some great features that will help you get quick access to answers and streamline your financial analysis.
Because Xero is retiring the older versions of their reports, you will no longer be able to use them as of 31 July 2023. However, you can use Xero's layout importer tool to bring across the layout of an old Balance Sheet, Budget Variance, or Profit and Loss report to Xero's new custom reports.
To access the layout importer tool from an old report:
From an old report, use the tool to move the row structure into a new report. The tool applies a preset date and comparison periods:
To do this:
Once you’ve imported the old layout, you can edit it in the new report. Use the settings at the top of the report to change the dates and comparison periods.
To access the layout importer tool from a new report:
From a new report, use the tool to bring across the old report’s row structure. The imported rows won’t overwrite the settings or columns you’ve already set up in the new report. To do this:
To Update layout differences on the new report: You can make further edits if there are differences between the layout of the new report and old report. Once you’re happy with the new report, save it as a custom report to keep the layout.
Report settings: The layout importer tool can't import specific settings such as report date, comparison periods, accrual or cash basis options, and alternative budget. However, you can update your settings on the new Balance Sheet, Budget Variance or Profit and Loss report.
Reorder accounts: In old reports, some accounts are ordered in a specific way, rather than alphabetically or by account code. In new reports, accounts are ordered alphabetically by default. To reorder them by account code:
Check formulas:
In old reports, Xero automatically hides a formula if there are no accounts in the section between the previous and next formula, i.e. it hides the formula if it has no impact on the report result. In new reports, formulas show regardless of the data in a section. This means the new Balance Sheet, Budget Variance or Profit and Loss reports might contain extra rows when compared to the old layout. To remove the extra rows on the new reports, edit the formulas. You need to delete the extra formula, then adjust the formulas below so they don’t reference the deleted formula.
Need help?
Our team is available to support you through this transition. We can create custom reports for your business and teach you how to do this yourself. Contact us today on 04-970-1182.