Xero Tip of the Month: Bring Old Report Layouts Over To New Custom Reports

February 28, 2023

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:

  • The Balance Sheet initially compares the current and previous two years. 
  • The Profit and Loss report compares the current and previous three months. 
  • The Budget Variance report compares actual amounts vs the overall budget for the current month and year to date.


To do this:


  1. In the Accounting menu, select Reports.
  2. Use the search field in the top right corner to find and open the old version of the Balance Sheet, Budget Variance or Profit and Loss report.
  3. In the banner message at the top of the report, click Bring standard and saved layouts. You might need to click Learn about changing to open the banner message first. 
  4. Select an available layout, then click Next. You can select an old report layout you’ve saved or the standard version of the old report if you prefer that layout.
  5. Give the layout a new name or keep the same name, then click Save.

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:

  1. In the Accounting menu, select Reports.
  2. Find and open the new version of the Balance Sheet, Budget Variance or Profit and Loss report. You can use the search field in the top right corner.
  3. In the Tips and tricks panel on the right of the screen, click Select layout. You might need to click Tips and tricks in the top right corner to open the panel first.
  4. Select an available layout, then click Next. You can select an old report layout you’ve saved or the standard version of the old report if you prefer that layout.
  5. Give the layout a new name or keep the same name, then click Save.


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:

  1. Click More, then select Account codes.
  2. Click Update.
  3. You can also drag and drop accounts into a different order:
  4. On the new report, click Edit layout.
  5. Select an account or account group, then drag and drop it into the correct order.
  6. Click Update layout to apply your changes. 


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.

By Ben Duflou • October 28, 2026
Your profit and loss statement (P&L) helps you understand your business performance and profitability over time. It’s sometimes called an Income statement and its main purpose is to list income and expenditure. Whereas a balance sheet is a snapshot in time, the P&L shows transactions over a specific period of time. This can be a month, quarter, financial year or any other period, and it can be a stand-alone report or a comparative period report. Together with the balance sheet, these two reports provide a comprehensive understanding of the financial position and performance of a business. The profit and loss statement has two main sections: income and expenses These may be further subdivided depending on the complexity of the business and reporting requirements. Income or Revenue Income primarily includes main business activities such as sale of goods or services. Other income such as interest received, capital gains or income from secondary business activities is also reported. Expenses Expenses are usually divided into two sections: direct costs, or cost of goods sold, and expenses. Cost of goods are those that are directly linked to the provision of services or sale of goods. For example, if you buy widgets from a wholesaler and sell them at a marked-up value, the cost of the widgets is a direct cost, not an overhead expense. Other types of direct costs might be importing and freight costs, contractor costs or certain equipment. Some direct costs are fixed, that is, they are the same from month to month, or they could be a fixed percentage of sales; others vary in value but are still related to the income producing activities. Overhead expenses are all the other expenses required to run the business, regardless of the level of income: for example, rent, utilities, bank fees, bookkeeping fees, professional development costs, vehicle costs and staff costs. Many of these costs form the basis of working out your break-even point, or how much it costs just to open the doors for business. There are some expenses which may be reported as a direct cost in one business but an indirect cost in another type of business, for example, merchant fees or contractor costs. The Bottom Line Total income minus total expenses results in the net profit (or loss), is often called ‘the bottom line’. Often business owners are just interested in looking at the bottom line, but a true financial picture requires an understanding of several reports and an ability to see the big picture that the reports are illustrating. The P&L is a vital tool to analyse for trends over time What does your P&L tell you about relationships and ratios between sales and expenses, seasonal changes and annual trends? Have all your direct costs been allocated correctly? Have you recouped all billable expenses from customers? Financial statements help you understand the big picture for your business. With deeper understanding of your business operations and performance you can make informed decisions about your business finances. Book a session today to examine your financial reports with our experienced business advisors.
By Ben Duflou • October 23, 2026
A simple but highly effective habit in Xero is consistently using the Reference field when entering invoices, bills or bank transactions. While it's often overlooked, it can make a big difference when it comes to finding and identifying transactions later on. For businesses managing multiple customers, suppliers, projects or recurring expenses, using consistent references makes transactions much easier to track and search. How to use the Reference field in Xero: 1. When creating an invoice or bill, locate the Reference field 2. Enter a clear and consistent description, such as: “Website Hosting - August 2026” “Office Supplies - July 2026” “Project - Smith Renovation” “Vehicle Registration - ABC123” 3. Save or approve the transaction as normal 4. Use the search bar later in Xero to find transactions by reference Using consistent references makes it much easier to locate specific transactions quickly, especially when reviewing reports, answering customer or supplier queries, or checking previous purchases. It also helps keep your records organised and can save valuable time as your business grows.
By Ben Duflou • October 23, 2026
View our October 2026 General Ledger: - What’s Taking More Time Than It Should in Your Business? - Important Notices - Buying a Business Asset? Here’s What We Need - Xero Tip of the Month: Use Reference Fields Consistently for Easier Searching - Tax Question of the Month: When Should the Insurance Payout be Recognised as Taxable - IRD Upcoming Tax Payment Dates https://public2.bomamarketing.com/email/aqXb
By Ben Duflou • October 7, 2026
Did you know every invoice, bill, and transaction in Xero includes a built-in audit trail? It's a feature some users might overlook, but the History & Notes feature lets you easily see who made changes, what was updated, and when - helping you and your finance team stay connected and organised. To view the history for any transaction: Open the transaction (invoice, bill, or payment) you want to check. Scroll down to the History & Notes section at the bottom of the page. Click History & Notes to view a detailed timeline of changes. This feature ensures everyone is on the same page and provides invaluable context for financial reviews – especially crucial during audits or when delegating tasks.
By Ben Duflou • September 15, 2026
View our August & September 2026 General Ledger: - Five Areas to Review Before the End of the Year - Important Notices - Charities & Not-For-Profits: Tax Changes Are Coming - Xero Pricing Increase - 1 October 2026 - Xero Tip of the Month: Accessing the History and Notes Feature - Tax Question of the Month: Deductibility of Dual-Use Home Office and Vehicle Expenses - IRD Upcoming Tax Payment Dates https://public2.bomamarketing.com/email/dbXj
By Ben Duflou • July 3, 2026
With many businesses expecting a lower profit this financial year, the more prepared you can be for the unexpected, the better. Managing expenses is a good idea at any stage in your business, and reviewing your pricing can also help improve your margins and support long-term sustainability. The challenge is knowing where to start. Before making significant changes, it pays to take a closer look at how your business is operating, where money is being spent, and whether your pricing still reflects the value you provide. Small adjustments can often make a meaningful difference to your bottom line. Smart ways to get your costs under control Cashflow has been a big issue for thousands of businesses this year, and when the money's not rolling in, it can help to rethink your costs. To do it effectively involves more than just keeping an eye on outgoings. It's about looking at all the moving parts of your business to see if your systems (or lack of them) are costing you unnecessarily. Here's how: Muck in - Do a cost control audit to work out where your biggest cost centres are and review the systems you have in place to manage them. Be aware - Don't just slash expenses without considering the impact. Track costs carefully and look for opportunities to streamline spending or achieve the same result in a more cost-effective way. Unite your team - Bring everyone together to monitor and analyse inputs and expenses. If you're reviewing or developing systems, seek feedback from the people using them every day. Look to your peers - How do your costs compare to others? If a business of a similar size is performing well while spending less, explore what they're doing differently. Seek advice - Whether you've identified some problem areas or you're unsure where to begin, talking with your advisors (that's us!) can help you determine the best next steps. How can I put my prices up without losing customers? If you need to change your pricing to make ends meet, be honest and up-front with your customers at all communication points. Make it clear on your website and social media that prices have changed and explain why. Send an email to let your customers and suppliers know about any changes in advance. If you're meeting customers face-to-face, ensure they're aware of any price increases before they're invoiced. No one likes an unexpected surprise. Support your team with clear information so they can confidently explain any changes and continue delivering a great customer experience. If you're concerned about customer reaction, consider introducing increases gradually across products or services over time. Get in touch if you'd like us to help analyse your margins, review your expenses, and identify opportunities to strengthen your business performance.
By Ben Duflou • July 3, 2026
Keeping on top of your finances while you’re out and about just got easier! Xero has refreshed the Accounting App experience to make it simpler for you to access key features and complete everyday tasks from your mobile device. The updated layout improves how you move between core areas, helping you find what you need faster and stay on top of activity wherever you are. What’s Changed - The key improvements include: A simplified bottom navigation to help you move between key areas more easily Home as the main dashboard view for a clearer overview experience Key functions such as invoices, bills, bank accounts, and contacts accessed through a streamlined Menu for easier navigation This makes it easier for you to quickly locate what you need, whether you’re processing invoices, reviewing transactions, or checking account activity. How to Use the Refreshed App Navigation: Open the Xero Accounting App on your mobile device Use the simplified bottom navigation to move between key areas Tap Home to view your account overview Access core functions such as invoices, bills, bank accounts, and contacts via the Menu Navigate directly through the Menu rather than switching between multiple screens or tabs Next time you’re using the Xero mobile app, take a moment to explore the updated layout, it’s designed to help you move through tasks more efficiently, wherever you’re working from.
By Ben Duflou • July 3, 2026
View our June & July 2026 General Ledger: - 2026 Budget Announcement - Cutting costs or increasing your prices? We can help - Xero Tip of the Month: The Refreshed Xero Accounting App Navigation - Welcome to the Team: Lavina - Tax Question of the Month: Case Study - The Incorrect Tax Code - IRD Upcoming Tax Payment Dates https://public2.bomamarketing.com/email/pdLw
By Ben Duflou • June 19, 2026
Ever feel like your business expenses are adding up, but it’s hard to see exactly where your money is going? When you have a clear picture of your spending, it becomes much easier to manage cashflow and make confident business decisions. Small improvements in how you track and review expenses can lead to better visibility, fewer surprises, and stronger financial control over time. If you’re finding it difficult to stay on top of your business expenses or want more clarity in your reporting, we can help. We can support you with: Streamlining expense tracking Improving cashflow visibility Turning your numbers into clearer business decisions If you’d like to chat about improving your financial processes, feel free to get in touch with our team on 04 970 1182.
Show More