New Aged debtors report - Full monthly aging periods
The 'old version' Aged Debtors report 'aged' the figures into months (as it should).
The new 'Aged Debtors' report does not.
If you run it at month end 'such as June' then the 'current' period' picks up 30th June, then the next period picks up 1st to 29th June.
It was reported to Xero support and their suggestion was......
"As you’ve found, right now it's not possible to show the full month for the first month on the New Style report for Aged Receivables Summary. This is working as expected. Please continue to use the Old Style report as that is working for you.
It doesn’t look like this functionality has been raised as a product idea yet. Xero Product Ideas is where our customers can share and support ideas for change"

Thanks for all your feedback on this one, community 🙂
Good news! Recently, we rolled out an update to all our ‘as-at’ type reports.
Now, you’ll notice that the report runs as at the end of the current month by default, and all of the invoices for the month will appear in the column you expect them to. The Current column will still contain any future dated invoices when ageing by Due Date, but will always be empty now when ageing by Invoice Date - See our before and afters
-
Julie Crundwell commented
How inferior does the "new" report look. Huge jump back in time. once you go through all the settings and get it semi usable you have to save your settings, then save that report, then find that report when you need it. Why not fix important issues in xero, than downgrade reports that are working! How about looking at reconciling or paying bulk payments. what a time consuming, back and forth job that is.
-
Kay Daniels commented
This report set up is unhelpful and unusable this way
-
Cassandra Scott commented
Hey everyone - I am not a Xero employee, however do sit on XPAC (the Xero Partner Advisory Council). I too share your concerns with this report, and along with other XPAC members have raised and are pushing hard to have this report reviewed.
No answers at this stage, but it is with the Reporting Team, and they are understanding the issue.
-
Naomi Gibbins commented
Seriously Xero, this needs fixing. The current report is absurd - I've never in 30 years working heard of anyone who wants to know what is "< 1 month" and what's the point? Can we simply have a report that shows month names with meaningful data. I completely agree with Debbie & Jeremy below.
-
Debbie Hornsey commented
I too am very concerned about the withdrawal of the old version of the aged receivables and aged payables reports. The new reports aren't user friendly at all. I see they've added the function to have the columns show month names but these reports can't even be added into a pack because they need to be dated differently to the rest of the pack to get them to work. Please keep the old reports whose dating function worked correctly and dump the new ones.
-
Karen Robertson commented
We totally agree with all comments made as at today on this report. Then to be informed that the 'old' version is being made unavailable really concerns us, the report as it currently is, is not useful to us at all without having to spend extra time make it "real".
-
VIKKI RALPH commented
I approached Xero about this style of reporting some time back as was left to fell that I was the one who wasn't reading (or filtering) the report correctly! I'm glad to see that by these comments it's a problem to many and that in fact it is an issue with the Xero program. I have never seen an Aged report report like this.
Please listen to how your subscribers want these the appear and be presented and make some positive, useful upgrades - as all the ones I've seen of late in Xero seem to be anything but positive.
Subscriptions are getting higher but the user-friendliness of the program is definitely on the decline. -
Claire Barning commented
I have found the same issue with Aged Creditors and reported it to Xero who have sent me to this product ideas page. The new report shows incorrect data when you have already set up payments for future dates.
"This new report defaults to todays date, how can I create a new report template that defaults to the end of the current month, so the invoices showing are the actual invoices owing, as if I use today's date it shows invoices owing that I have already sent to my bank for payment at the end of the month. The old report simply defaulted to the month, but it would be great if this was an option for the new report." -
Debbie Meiklejohn commented
It is ridiculous to call current invoices "< 1 month". Not sure who thought this was a good idea or even what purpose it would serve.
I am mystified as to the point of breakdown invoice into current and < 1 month - exactly what is the difference. If you run a report for the end of the month - the invoices are current surely the report run for the end of June in the month of July does not show July invoices.
I think it would be good to get an explanation as to what Xero is calling current and what they are calling , 1 month and the purpose of this.
The old report was simple easy to understand and now my clients will struggle to understand the report
AND again the only way to provide our clients with meaningful reports is to export this report to excel and format it back to the same as the old report.
Typical Xero making changes where they are not necessary
Also why can we not have month names instead of 1 month 2 months 3 months.
This is meaningless for my clients.
These reports are not an improvement - just more work for me to provide meaningful information for my clients
Not impressed - the Xero fees go up but we are given a more complicated product to work with. A product that causes us more work.
We can't keep working with the old reports as they are going to be retired
-
Carol Dufour commented
To add insult to injury my initial request (to have an Aged Debt report that was fit for purpose - as the 'old' version was) now links into something totally different
-
Jeremy Hall commented
I think this is pretty disingenuous of Xero to call it a Product Idea. In my book it is a product defect which should be rectified.
I vote that they fix defects. -
Cassandra Scott commented
This is not a logical way to be running an AR report (in either summary or detail). Never have I seen the 30th of June, separated from 1-29th June.