Customer Statements - Ageing (30, 60, 90days)
It would be great if we could add ageing on client/customer statements. (Current, 30, 60, 90 days) Many clients have requested that the ageing be displayed on their statements. Current, overdue and total isn't detailed enough..
Hi everybody, coming across from the previous forums we know this idea has a lot of interest.
There is a way of using Xero's reports to accomplish what you're asking here and save the format so you can easily access and send this report to your customers outside of Xero.
Running the Aged Receivables detail report you can choose how many ageing periods you'd like to show and set the period to '30 days'. Simply Filter the report by Contact and Update to run.
- Once you've got it set up, save as Custom so you can easily access this format anytime
- If you deal with groups of contacts this also means you could Filter for multiple contacts to combine the view into one report rather than multiple customer statements 🙂
- Export the report to PDF, where you can send to customers from your email system outside of Xero
We appreciate the one element missing is the ability to send from in Xero, but to be open and upfront we don't have direct plans for making this change within customer statements in the foreseeable future. Thanks
-
Nikki Moran commented
This one lacking "feature" (AKA basic function) is what is stopping me from migrating 6 clients currently on Sage who would miss this ability too much to change their system. I know there must be many others who feel the same, not only is this a problem for current users, it is holding others off migrating to Xero.
-
Bokkie Fourie commented
We recently migrated from Sage Accounting to Xero in following a third party app that we want to use (including onselling of Xero integration functionality).
I cannot believe that such a basic reporting feature as account ageing is not a standard inclusion in Xero statements.
If you (Xero) don't wat to develop this feature, then give your paying subscribers the ability to build it into our custom branding documents with field codes!!!
-
Hannah Doherty commented
In the process of migrating to xero and just discovered that thus is, inexplicably, not a feature.
How can Xero disregard the many, many, requests for this basic feature?
Very surprising, I'm adding my vote in the hope that Xero will reconsider -
John Lynch commented
The aged listing only works with the functional currency used in Xero, but statements report is in the billing currency.
Using the aged listing which is translated into whatever the functional currency is set in Xero, these numbers would be utterly meaningless to our customers.
-
Riaan Badenhorst commented
Dear Gary.
Please understand that at the premium Xero charges for its subscription, we expect the feature to be a basic function. We are already paying a premium and therefore the need to pay for an additional subscription for a basic function unnecessary. We all are familiar with Statey and is not a new add on. We just refuse to pay and pay and pay. From the latest update by @Kelly Munro from Xero, I realized that the feature will not be added and just ignoring the 360+ votes. Xero is more concerned to add basically useless functions that only have 10 votes (have seen this)
Thus to save myself from a headache, I am bust migrating clients to a platform that is accountant centric. OH, that was 40+ clients. Only left about 11 to migrate. But I am sure in will not affect Xero's bottom line.
This was not the only feature that made me consider to move, but the pure ignorance from Xero is beyond believe.
-
Gary Greyling commented
Hey all. There is a new plugin on the Xero app store called "Statey" that makes this automatic and easy.
I know the spirit of this thread is that it should be part of Xero. But at least there is now a 3rd-party plugin that makes this easy, even if it does cost a couple of bucks.
It also enables the much requested 'automatic statement send outs' feature.
A solid interim solution for those in desperate need of this.
-
Tracey Kidd commented
I guess this along with putting the search back on every page and all the other things will be put on the back burner now.
https://i.stuff.co.nz/business/300826021/xero-plans-to-cut-up-to-800-jobs -
Barbara Mundell commented
Xero, most of our clients need this standard on their statements. I have clients who's default payment terms is 30 days from statement, so their clients require the age analysis on their statements. This is the only reason they will not move to Xero, please relook at your decision.
-
Bruce Hooper commented
I find it unacceptable that Xero is not looking at this basic functionality. I think Xero needs to rethink this, failing that many accountants will be rethinking their Xero as a suitable offering.
-
Jenny Johns commented
I cannot believe you have sent this update. I'm embarrssed to tell my clients who have asked for this feature.
One of the clients I told yesterday said they need the trail in Xero which show when statements and invoice chasing has occurred in case of having to take legal action against debtors.
I deal with supplier statements on behalf of my clients every day and I'd say 90% of them have the aging, with Xero ones being in the 10% not showing30, 60, 90 days and statements which must be produced from a few other a few other types of software.
Xero is world class accounting software. This is a fundamental task.
-
Adele Dixon commented
Please add the ageing, it should be a standard feature & I don't understand why it is not possible.
-
Lucy Moore commented
Great work Xero, completely missing the reason why this is important. i do not have time to manually run and check this report for 200 customers every month. If you think this is a solution then i think we have issues. Its not even like you can export this report in bulk with a customer per page and automatically save each page individually, it requires a lot of manual intervention and i expect more form a digital platform.
-
Timea Hoskins commented
I think you're missing the point here Xero...for most businesses it is standard practice for you to send your customers a statement - and a lot of customers will only pay on receipt of a statement. To have the outstanding items shown per your standard terms (be that 30days, 60days or even calendar months) is a basic accounting requirement.
Please look at this decision again. Thanks.
-
Nikki Moran commented
Disgraceful - this is a basic expectation from any accounting program
-
Tracy Thompson commented
Extremely disappointing, maybe its time to look at an alternative software for our clients that does offer this function!
-
Johan Potgieter commented
This is just extremely dissapointing.
Especially after you state the obvious - "we know this idea has a lot of interest"
Unfortunately, most customers pay 30 days on statement. So unless the Statement gives the 30 days portion CLEARLY, whilst showing the movement and ensuring they have all the latest invoices of the past month ready for payment in the next... This creates a lot of headache and I have a lot of clients thats is constantly asking.
Then Xero is constantly talking of making things beautiful... Have you had a look at the Statements section?? It is still the OLD Xero look - So the hope and the expectation has been that when Xero started moving to the NEW INVOICING the Statements on which that invoicing is based will also receive some love.
So unfortunately, the very poor workaround given above, adds to the frustration and does not take away from it.
I realise that Xero will probably never read what I have just written - considering the amount of feedback we get on these requests - even though this particular request has been coming on for YEARS! I am talking before 2017 period.
So unless there is doubt - This function is an Accounting System BASIC - not a gimick or nice-to-have. And the expectation from every business owner is that this is included - it is not specifically asked, becuase it is like asking if water is wet - it is a universally accpeted fact... but here we are... the Xero community stading corrected in the desert where water is dry.
-
Cass Moore commented
Oh, I thought this was a request to add 30,60,90 days to the statements that are emailed to each customer.... not to the report about customers as the reply from xero seems to refer to - we already do that.
But it would be great to email a customer a statement that shows the portion owing for that month, and each previous month, ie: 30,60,90 days - as in Sandra Tuckers attachment
-
Anne Norman commented
Just another reason to look at other programs. This is ridiculous.
-
Megan Shell commented
How do you know when it's time to give up on your accounting platform? When they refuse to implement easy fixes that are standard in almost every other accounting platform.
-
Catherine Lynch commented
I'd say you're right. I like Xero, but I miss some of the features that Quickbooks had. Ireland is not a big enough market for them to invest in these things for us, but while ageing 30,60,90 days isn't a huge thing to me, I would have thought it an indispensable feature for any accounting package. Personally I miss being able to create partial invoices from a quote and being able to go back into the quote to see what was invoiced and what is left. I don't see why that's such a difficult thing to have either. Is it a feature available in other jurisdictions? If not that would be pretty poor from Xero. If it is, I can't see why it's not available to us.