Brought to you by

Changes to Xero reports

Posted 7 years ago in Advisors by Xero
Posted by Xero

Today marks the first in a series of updates we have planned to introduce a brand new way of running reports in Xero. We’ve designed these new reports from the ground up, taking into account the feedback we’ve received from you and they’re looking great.

To get the ball rolling we’ve launched a new set of Aged Reports and are currently working on a Depreciation Schedule, Disposals Schedule, Account Transactions, and Profit and Loss reports.

Where are the new Xero reports?

As we deliver the new reports over the course of this year, they will become available from a brand new report centre, accessed from the existing report centre.

We will make it easier to navigate between the existing and new reports soon, but for now, we wanted to give you access to the new reports as soon as possible.

What’s new with the Aged Reports?

These reports have been rebuilt from the ground up so that we can offer you a lot more features. There are five reports, a summary and detailed report for each ledger – receivables and payables. We’ve also created a separate Expense Claim Detail report.

But the real magic is in what you can do with these reports. Check out all the options you have when you open up the report settings section.

Xero report: Aged Payables Detail


Let’s have a closer look. Remember, while the first reports you see will be the aged reports, all of our new reports will have these sorts of  features available on them.

More data, and more ways to control it

One of the first things you’ll notice is the ability to control how how many ageing periods to include and whether to age monthly, weekly or daily. This is particular useful for industries where short payment terms are common, so if four ageing periods of a week is a better way to manage your suppliers – well your Xero reports just got a lot better!

Convenience dates

Most reports require you to select a date or date range. New reports will have a preconfigured set of convenience date settings for you to select from. They are clever too – if you save a template (see below) where the date is set to ‘End of Last Month’, the date automatically changes each month you run the report.

Convenience dates


Columns – selecting, sorting and reordering

All new reports will have a selection of predefined columns for you to select from. Check the ones you want to appear on the report, press update and voilà!

Not only that but all columns are sortable (just click the header) and if you don’t like the order which they show in, you can drag the column header to where you want it to appear.

If you want to keep the selected columns and sort order next time you run the report, make sure to save a template.


You can group data on these reports in many different ways, so for example if you want to group a collection of receivable invoices by their reference, you now can!

Group data

Saving drafts, publishing and templates

As with existing reports, all new reports can be saved as a draft and accessed at a later date from report centre. You can publish reports for a permanent record of a report and there is a new publishing screen which allows easy renaming of reports as well as controlling the appearance in pdf form.

Saving drafts, publishing and templates

A new option is to save a report as a template. Once you have a report which suits you, which could be the dates it runs for, the columns it shows or any of the other configurable elements, simply save as a template and next time you run the report it will use these settings. Unlike, drafts, saved templates change based on dynamic parameters like convenience dates.

What’s not available yet, but coming?

We’re still working on a few things that will be added to the Aged and future reports over the next few months. These include,

  • Filtering options – to restrict the information displayed in a report, we will allow you to create filters. For example, you will be able to filter records by tracking or by invoice amount so you only see invoices of a certain value.
    Filtering options
  • Saving templates by name – in today’s release, you can save one template and it will be the default each time that type of report is run. In the future, you will be able to save multiple templates, giving each a name, and these will appear in the report centre under the associated report. For example, you could create a template called “Aged Payables – weekly with contact details” or “Aged Payables – grouped by region”.
    Save Payables by name
  • Favourites – you will be able to favourite both existing and new reports shortly
  • Footnotes – a new clearer way of footnoting information in a report is coming
  • Text sections – you will be able to add blocks of text to any report, similar to the summary blocks available currently, however you will be able to move these and have more control over the presentation of them on new reports.

 What reports are next in line?

We’re currently working on a new Account Transaction report with the ability to report on multiple accounts at once. We are working on a pair of new depreciation reports and a completely redesigned Profit & Loss with an improved layout editor. The P&L has lots of great new features that will apply to all other account based reports (Balance Sheet, Movements in Equity and Trial Balance). I’ll save this for a future post, but to whet your appetite a little, it will include things like:

  • Formulas – ability to create your own formula rows – for example EBITDA or Gross Profit %
  • Header groups – you can create top level groups to get detailed breakdowns of accounts
  • Improved layout editing – much simpler to use and with lots more options
  • User set timeframes – be able to run the report for nonstandard periods such as after a change of settlement date

This release is a foundation release for us, it establishes the platform which will support all new reports. Moving forward we can start to release reports much quicker than we have in the past so you can expect to see more and more reports showing up in the report centre this year. The end goal for this work is to release a new version of report packs which allows you to capitalise on all these new features in your templates. Each report we release will bring us closer!.

So, plenty going on, and we’re glad to be able to start shipping some of the goodness. Lots more to come, exciting times.


May 19, 2014 at 10.14 am

Thank you – this looks just great!

Will customer and supplier accounts be part of this new reporting framework? I’d love to be able to see every transaction with a third party, and then narrow down from there.

Martin Caruana
May 19, 2014 at 10.53 am

I agree with Nigel’s comment. I would like to see every transaction ie the receipts in full, rather than dedudcted from the invoice it is allocated too. Dare I say. I like the sage customer and supplier activity reports for that reason. I think it is important to be able to extract the history as well as the position at a given date.

May 19, 2014 at 11.03 am

Love the new Detail reports! Thanks for your hard word.

Mark Blundell
May 19, 2014 at 11.09 am

Hi Nigel
That exact report is definitely in our future. A full listing of all cash, receivables and payables transactions for one (or many) contacts has already been designed and we aim to release it once the new P&L and account transactions are out.

May 19, 2014 at 11.25 am

This new format is really great.
Pity there is a bug that prevents one of my Tracking Categories from working with the Grouping function.

Jonathan Amos
May 19, 2014 at 2.05 pm

Huge improvement, well done. I hope you will include a Balance column in your new Account Transactions report to save me the tedium of exporting to Excel and making my own balance column each time.

Karmel Everett
May 19, 2014 at 3.22 pm

Hi guys, love the new Aged Receivables Detail report, only when I click ‘print to pdf’ what prints is not the same as what is on the screen – the contacts appear to be randomly arranged not in alphabetical order??

Heather Smith
May 19, 2014 at 3.53 pm

Encouraging my clients to utilise reports is really important to me so all improvements in reports are welcome!
I’ve just had a play around with them and with respect to the new reports;
They use more real estate on my monitor – which is a good thing.
The extra data options is excellent
I’m surprised there is not sorting functionality for all headings – especially above the ‘Current’ heading – but I can see if I add the heading ‘Total’ I get that option.
The bar at the bottom ‘Save As’ and ‘Export’ seems fixed and takes up space, can the bar be hidden?
We’ve lost the graph? Will we be getting graphs or pie chart options?
Also in the All Reports area can the ‘favourite star’ on the left be added to the Payroll Reports and Tax Reports – for quick access please? I know you are adding it to the new reports – can your snipers fix it up for the old section in the mean time?

May 19, 2014 at 4.02 pm

Great to have the new filtering options but the reports are very slow to load. Over 3 times longer than the old reports to load.

May 19, 2014 at 6.23 pm

Where are reports for payables and recievables that allow to show
total amount inc GST tax amount ex gst amount
have to manually do these things every single day

Albert Antonio
May 19, 2014 at 7.33 pm

why can’t you make the AP where the supplier’s account statement can be generated same like customer’s account where invoices and payments are arranged chronologically by date???

Colin Timmis
May 19, 2014 at 7.35 pm

Looks great guys! Definitely need some reports that Help business owners plan and predict cash flow better…..the expected payment date on receivables will help with that. Lets try add a full summary showing how the bank balance affected.

May 19, 2014 at 8.21 pm

Is there an expected delivery time on the updated Report Packs in australia? Hoping to move a lot of ledger client across to Xero but need to be sure there is greater flexibility and less formatting required.

Joe Serrone
May 19, 2014 at 11.06 pm

This is a great start! my only suggestion would be to add the functionality that would allow us to select the invoice status similar to the existing Customer Invoice Report. For my clients it becomes important to understand the age report for Invoices that are still pending “Awaiting payment” vs. Invoices that have already been paid.

Tim Robinson
May 19, 2014 at 11.12 pm

Thanks for the update – perfect timing as I am working on a client with a year end of 1st February and couldn’t previously run an aged payables report to that date.

Mark Blundell
May 20, 2014 at 11.21 am

Hi everyone great to hear the feedback and please, keep the suggestions coming!
A lot of the features people are asking for aren’t things I plan to add to the aged reports specifically, but will to other dedicated reports.
Aged reports are for aging, reports are more usable if their purpose is clear and defined and so the aged reports we have built focus on supplier or customer debt management.
Analysing invoices by status will be the task for the Invoice Summary and Invoice Details reports which we will be working on shortly.
Generating a full supplier or customer transaction listing will come via a new and vastly improved Contact Transactions report which is also yet to come.

We have not implemented graphs on the new reports yet, it’s not high on the priority list either if I’m honest. Things like filters will give us so much more bang for our dev buck (aged reports filtered by tracking category!) and there is also all the work going into the new P&L, Balance Sheet, Movements in Equity, Trial Balance and Statement of Cash Flows. So we will get there with some great graphs, but not soon.

We are on it, will get a fix for that in as soon as possible, thanks for letting us know.

Melissa Scott
May 20, 2014 at 7.57 pm

This looks great! Any chance we will be able to filter to show the customer invoices in different currencies rather than convert them

May 21, 2014 at 10.21 am

The report no longer shows the exchange rate at which foreign currency amounts are converted like the old report did. This is pretty important. It would also be very beneficial to be able to run a payables and receivables report with all amounts showing in the currency that the invoice was invoiced in and not the base currency as it would help to manage cashflow of foreign currency accounts.

Di Crawford-Errington
May 21, 2014 at 4.04 pm

Love it, cant wait for the rest of them. I know we are all impatient to have these things, and I know good things take time, so…Thanks Xero, keep up the good work.

Michelle Banks
May 21, 2014 at 11.56 pm

Hi there, thanks for the new reports Xero very impressive. Can I also ask if it is possible for the ability to manually change the column widths (similar to Excel) I am aware there is a wide view option however this only provides the bottom slider. I export to Excel to view the whole report.

Mark Blundell
May 23, 2014 at 6.36 pm

Hi Nick
The currency notes will come in a future release. The conversion mathematics are still being done the same as it is on the old reports, using the rate of the day, whatever that is in your org. We will start work soon on a standard feature of all reports so that you can show in:
1) Your base currency
2) The source currency of the invoices
3) Convert all invoices into their equivalent amounts in one of the other currencies you use in your organisation

May 28, 2014 at 8.03 pm

We can’t see the new reports. is this one online?

June 24, 2014 at 1.52 pm

I love the new reports – thanks for the update. However, I am working with the payables and wish to ‘group by currency account’, how does this work please? The report I get only splits out some suppliers by currency, not all, yet under their contact details I can see that they are set-up with a currency account… Not sure what i am doing wrong. Thank you

Mike Block CPA
August 9, 2014 at 12.48 am

When might this let us estimate corporate income tax, use gross profit inventory (cost of sales equals a % of sales) or otherwise include calculated results in reports?

December 9, 2014 at 6.03 am

Hi Mark
Is there any update on when we will be able to produce an aged receivables and aged payables report showing invoices in their original currency rather than having to drill down on each customer or supplier? You mentioned on 23 May it would be in a future release. Until then it is not possible to provide a report for anyone to chase their customers without doing each customer separately, amongst other things! it would be ideal to be able to have a report for all clients and also to be able to highlight a selection of customers and print them in their original currency as many other programs allow!

January 13, 2015 at 7.36 am

Mark – on May 20th you made mention of Statement of Cash Flow report that is being worked on. When do you expect this new report to be available?

April 27, 2015 at 9.50 am

Is there any update on the Save As function within the templates? Currently it is restrictive to have just one template for say the Profit and Loss report.

May 15, 2015 at 2.08 am

The new P&L allows me to group some cost centres – great
The old P&L showed a variance to overall budget – great

But I’d really like to be able to publish each of my tracking categories ( x 36) compared to their budgets? And perhaps even group them into my 8 cost centres. And ideally, by just running a ‘set’ of reports.

Come on Xero, surely it’s just like Excel – which I’m desperately trying to avoid using!

April 23, 2017 at 12.46 pm

I’ve tried to work with, however it isn’t going to works in any way.

Leave a reply

Your email address will not be published. Required fields are marked *