Xero Tip Of The Month January 2017 - Customisable New Reports In Xero

Xero is making it’s reporting even more customisable so businesses and their advisers can easily display the results that matter the most to them.

Mountain View

Xero have released a new layout editor which allows you to customise nearly any aspect of a financial report, as well as a new report centre experience. This brings unparalleled reporting power to Xero with the flexibility to suit any user.

Layout editor

A little over a year ago Xero released a layout editor to allow you to modify the key financial reports — the Balance Sheet, Profit & Loss, Movements in Equity and — for our partners using Report Templates, some very powerful schedule creation abilities. It was a huge step forward with powerful row level customisation — grouping accounts together, creating formulas and ordering items exactly how you want them to show. Today we add the logical next step, column customisation. Plus we’re making it available to all users of Xero reports — businesses and practices alike.

All the columns you could want

Prior to this release, columns were ordered in reverse chronological order, they were all the same time span, and they were all continuous. You couldn’t add budgets to anything, and you couldn’t define your own variance calculations. Now you can do all of those things!

You can define all characteristics of the date columns, what time frame they cover, what they are titled and in which order they will show.

Mountain View

You can add budgets to the Profit & Loss and also to reports that contain schedules like the Notes to the Financial Statements. You can customize where they show, the time frame, and the titles.

Mountain View

Compare anything

Formulas let you calculate variances between any columns on your report. Whether actuals vs budget, actuals vs other actuals, you can now compare anything.

Mountain View

As well as the new columns behaviour, the user interface for accounts, groups and formula rows has been improved. As before, there is still an easy and intuitive drag and drop interface to move items around. You can now hide total rows to create cleaner layouts, or you can rename them. Lastly, the means by which you show the detail of all the accounts, or summarise them together to create a single line is now a simple toggle, which also keeps your layout page cleaner.

Report Centre

The report center has been completely rebuilt. It brings all of Xero’s reports, both old and new, into one place. We’ve added some great new functionality that we think you’ll love – especially the ways you can very easily tailor a report to suit your specific needs.

Reports are now grouped into new categories that make it easier to find what you’re looking for. Just click the three dots to expand a group and see more reports.

You can still use the star icon to favorite any report (new or old) so those reports always display at the top of that group and in the Reports menu.

Better yet, we’ve introduced a new search function so that you can quickly find the report you need. This screenshot shows the results when you search for “Rec”.

Mountain View

Xero’s default report layouts are great — but sometimes you need to tailor them to your specific needs. Now after editing the layout and settings of any new report, you can save the layout to use again with one click. Simply click Save as Custom.

You can save more than one custom layout per report, so now you can create as many reports as you need to manage your business.

What’s next for reporting?

There are two pieces of work which are underway now, to be released in the coming months. Tracking Columns will allow you to set one or more tracking values to show in a column on a report. This will allow consolidation of multiple values into one column as well as showing more than one tracking value on any given report.

The To Date convenience picker option. (Year to Date, Quarter to Date, Month to Date.) Will allow even easier reporting up to the current day, taking advantage of the always online nature of Xero.

We’d love to hear what you think about the improvements to reporting in Xero and if you’d like to learn more head to the help center for a comprehensive guide of the new functionality.

See all the Xero features that can help you run your business beautifully at

Previous Tips

December 2016 – Email Templates In Xero

November 2016 – Bank Rules In Xero

October 2016 – Smart Lists In Xero

September 2016 – Files in Xero

August 2016 – Direct Bank Feeds In Xero

July 2016 – Managing Bills and Purchases in Xero

June 2016 – Shortcuts In Xero

May 2016 – Email Integration

April 2016 – Recurring Sales Invoices

March 2016 – Two Step Authentication

February 2016 – Xero Search

January 2016 – File Storage in Xero

December 2015 – Invoice Reminders

November 2015 – Xero on the go, with Xero Touch

October 2015 – Invoice Payment Terms

September 2015 – Sales Invoice Customisation

August 2015 – Business Performance Review

July 2015 – Cash Coding In Xero

June 2015 – Xero to Xero Billing

May 2015 – Find and Recode

April 2015 – Online Invoicing