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 December 17, 2024
A recent survey showed that 93% of respondents believed changes made by the Government had increased their cost of doing business . And rising costs can have a significant impact on your cashflow and bottom line. So, what can you do to minimise the impact of sky-rocketing costs in your business? Seven ways to cutting your expenses and boosting your revenue When costs are rising and profit margins are falling, that’s bad news for the financial health of your business. But there are ways to combat this scenario. In short, you have two main tactics to kick into gear. You can either look at cost-cutting across all your operating expenses, or you can find ways to sympathetically boost your revenue . Strategies for cost reduction: Streamline your operations - Look for any inefficiencies and find ways to streamline your processes and reduce the underlying costs. You can also use technology to automate key functions to add efficiency and reduce your underlying costs. Negotiate with suppliers - Revisit your existing contracts with suppliers and negotiate better terms, while also being mindful of the suppliers own cashflow pressures. Looking for alternative suppliers or finding cost efficiencies by purchasing in bulk. Reduce your energy consumption - Putting energy-saving measures in place, like LED lighting and energy-efficient equipment, is a move towards good sustainability, but can also help you save money. Considering renewable energy options can also help. Manage inventory effectively - Keeping your inventory lean is a good way to optimise inventory levels and minimise your holding costs. Implementing a just-in-time inventory management cuts costs while keeping you ready to service customer needs. Strategies for increasing revenue: Expand your customer base - A broader customer base helps to bring in more sales and revenue. Explore the potential for entering new markets or customer segments, and boost ecommerce and digital marketing to sell more online. Raise your prices strategically - Think about the demand for your products/services in the market and revise your pricing to keep it competitive. Be sure to communicate any price increases sympathetically to customers, so you don’t damage customer loyalty. Introduce new products or services - If your current products/services are not selling, it could be time to diversify your offering to meet changing customer needs. Make the most of your existing resources and expertise to bring new products to market. There’s no magic wand that can make the current economic pressures disappear. But by being proactive about your cost-reduction and revenue-generation, you can do your best to protect your business from the worst elements of increasing costs and an uncertain market. We can help you review your current financial and business strategies to look for the best possible opportunities, whether it’s better cashflow management, cost-cutting or revenue generation. Together, we’ll identify actionable solutions to drive sustainable growth and maximise your profitability. Give us a call today on 04 970 1182.
By Ben Duflou December 17, 2024
Have you tried out Xero's new AI-generated answers in the help menu? Now, when you're working in Xero and ask for help, you'll receive an AI-generated answer along with a list of other relevant content articles. This provides a fast, straightforward response with links to the source material and additional details if necessary. The answer takes into account what page you’re viewing, and the version of Xero you use, to make sure that the information provided is relevant to you. This means you spend less time searching and more time focusing on what matters most – managing your finances seamlessly. To access the help menu, simply click on the question mark icon located on the far right of your toolbar.
By Ben Duflou December 17, 2024
View our November / Early December 2024 General Ledger: - Key Ways to Overcome Rising Costs and Expenses - Important Notices - Financial Preparations for the Holidays - Xero Tip of the Month: Unlock Faster Support With AI-Generated Answers in the Help Menu - Changes to the Retirement Date of Xero Classic Invoicing - Welcome to the Team: Harpreet & Gurpreet - Tax Question of the Month: What is the cost base for depreciable assets when a look-through company reverts to being an ordinary company? - IRD Upcoming Tax Payment Dates https://public2.bomamarketing.com/email/0dJN
By Ben Duflou November 24, 2024
As noted in our August General Ledger, classic invoicing in Xero was initially set to retire this month. However, recognising the busy period ahead, Xero has decided to extend the availability of classic invoicing until 27 February 2025, ensuring a smoother transition for everyone. With the introduction of the new invoicing system, there will be updated workflows to learn. To help you get up to speed, Xero’s new invoicing education hub is the ideal resource to guide you through the process. To access this resource, visit the link below: https://learning.central.xero.com/student/activity/3482 ?
By Ben Duflou November 21, 2024
Seeking an easy-to-use cloud-based payroll solution? PaySauce is the innovative answer to all your payroll needs. Designed for New Zealand businesses, it seamlessly integrates with all major NZ banks and the Inland Revenue department, so all PAYE obligations i.e. salary/wage and tax payments, as well as tax return filings, are all part of the package – providing you with a complete end-to-end solution. As a special promotion for new customer sign-ups, PaySauce is reducing the prices of their Standard and Premium plans for new accounts by 25% until the 31 January 2025, with the 25% discount applied through to 30th September 2025 for our clients! PaySauce operates on a flexible subscription model with monthly payments, allowing you to cancel at any time without long-term commitments. What's more, transitioning from another payroll provider to PaySauce is a breeze and won't cost you a thing. Interested in learning more about PaySauce? Check them out here: https://www.paysauce.com/
By Ben Duflou November 12, 2024
When guests come to your hotel or motel, they want to feel that you genuinely care about their stay. The best way to show this is by tailoring the guest experience to their individual needs. People from all walks of life may pass through your doors, and each one will want to feel like the most important guest. There are many ways to personalise guest experiences, but the only caveat is that it can get costly. Whatever you do to personalise the experience, you can’t afford to do it at the expense of profitability. That’s where the team at All Accounted For comes in. After reviewing your finances, we’ll help you find cost-effective ways to personalise the guest experience. With our help, any new services you introduce will only strengthen your bottom line. Interested in learning more? Contact us at 04 970 1182, and let’s explore how we can drive your business toward greater success.
By Ben Duflou November 11, 2024
Small and medium-sized enterprises (SMEs) make up 97% of all businesses in New Zealand. As the owner of an SME, you’re doing your bit to provide employment, aid the economy and put Aotearoa on the map in an increasingly globalised world. But running your own business can be incredibly stressful! New research from RFI Global research, commissioned by Prospa, shows that seven in ten New Zealand SMEs are feeling stressed and burnt out. On the whole, this stress comes down to economic pressures, cashflow worries and the time commitments of being an owner. So, what can you do to remove some of the pressure and avoid business burnout? Practical Ways to Ease Your Business Stress: Let’s look at some simple ways to bring those anxiety and stress levels down: Ease those financial worries: You can’t change external factors like the economy, but you can get deeper into cashflow forecasting, spend management and cost-cutting exercises to put your cashflow and revenue in a more positive position. Look for a business mentor: Partnering with an experienced business mentor can work wonders for both your business knowledge and your mental health. Mentors can share their experiences of the lean times, and what they did to overcome the challenges. Take time away from the business: You can’t have your business brain turned on 24/7. Schedule time away from the business to improve your work/life balance. Time away can be hugely beneficial, allowing you to come back refreshed and motivated. Focus on your own health and wellbeing: The long hours of running a business are not always conducive to healthy living, both for your physical and mental health. Try to eat and drink healthily, and also make time for exercise, social activities and a greater focus on relaxation, mindfulness and your personal wellbeing. Work closely with your accountant: You don’t have to shoulder those cashflow worries alone! We can work closely with you to keep your cashflow in a more positive position, while also providing wider financial, advisory and business support. Talk to us about about dialling down those stress levels: To run a healthy business, you need to be fit, healthy and in a good place personally. Constantly pushing yourself can quickly lead to burnout – and that’s a recipe for disaster! We understand the pressure you can feel as a business owner. So, we’re here to help take on some of the load, whether it’s strategic business advice, cashflow forecasting or introducing you to the right mentor from our business networks.
By Ben Duflou November 4, 2024
One of the most significant upgrades you can make for work efficiency is your screen setup. Xero bookkeeping and accounting are doable on a single screen, but tasks become much easier when you try out the dual-screen setup. Using two monitors instead of one while using Xero can increase your productivity exponentially. You can have your accounting documents up on one monitor, and have Xero running on another. By working on both monitors at the same time, you will no longer have to tab in and out of applications to check reports and budgets, as you can now simply glance over to the other monitor to check instead. Dual screen setups are becoming increasingly common in many workplaces as it gives the user a greater amount of screen space to work with, which can lead to an increase in productivity and prevent their desktop from becoming cluttered with windows and instances of other software. 
By Ben Duflou October 31, 2024
View our October 2024 General Ledger: - 5 Ways to Reduce Your Stress as a Business Owner - Important Notices - Following up on Invoice Payment in a Down Economy - Xero Tip of the Month: Making the Most of Dual Screens - Audit Shield Insurance - Protect Yourself from a Tax Audit - Tax Question of the Month: Offset of Bright-Line Profit Against Bright-Line Loss - Welcome to the Team: Chanelle Doole - Farewell to Sarah Toner - IRD Upcoming Tax Payment Dates https://public2.bomamarketing.com/email/LJB0
Show More
Share by: