Skip to content

Changes to Xero reports

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.

Grouping

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.

 

Read more about Accountants

 

24 comments

Nigel
19 May 2014 #

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
19 May 2014 #

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.

Sharon
19 May 2014 #

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

Mark Blundell
19 May 2014 #

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.

Campbell
19 May 2014 #

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

Rod Drury
19 May 2014 #

@Nigel we made a tweak to contacts a few months ago that make it more obvious how to quickly get to all invoices from Customers and Suppliers.

Pic here: http://www.xero.com/blog/wp-content/uploads/2014/05/Invoices.png

As Mark said, new full report coming and looking good.

Jonathan Amos
19 May 2014 #

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
19 May 2014 #

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
19 May 2014 #

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?

Darren
19 May 2014 #

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.

Jason
19 May 2014 #

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
19 May 2014 #

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
19 May 2014 #

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.

Michael
19 May 2014 #

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
19 May 2014 #

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
19 May 2014 #

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
20 May 2014 #

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.

@Heather
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.

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

Melissa Scott
20 May 2014 #

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

Nick
21 May 2014 #

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
21 May 2014 #

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
21 May 2014 #

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
23 May 2014 #

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

George
28 May 2014 #

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

Tonya
24 June 2014 #

Hi
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

Add your comment





We welcome all feedback but prefer a real name and email address.