Reporting - Aged Receivables Reports - run as at one date, and view the amount still outstanding at another date
Within the debtors and creditors reports (either detailed or summary) the ability to show balances as of todays date when working on client's system up to 9 months later, would be handy to see which debtors and creditors are still outstanding.
I.e. client has £100k debtors as at their year end 31/3/22, but when we run report on say 31/7/22, how many of that £100k is still outstanding? To have a toggle to the balance at the report date (31/3/22) or the current date would help,
Hi Paul, it sounds like the Aged reports could be useful here. With either the Detail or Summary report you'll be able to set the Ageing periods before running the report - Or is there something else I'm missing here?
See an example I created in the demo co. below 📷
-
Bev (Accounts) commented
I echo that Xero really needs the functionality to be able to run 'Aged' reports, indicating the 'as of' date. ie: I need to run a report listing the current creditors/debtors that are STILL outstanding to the 31 March 2023 as of today's date (15th Nov' '23) but this does not seem possible in Xero?
-
Mazaheer Rajwani commented
I would like to run the report for Apr 2023 which shows me outstanding balance as at today (Nov 2023)
So if there was an invoice raised on 30 April 2023 and paid on 31 July 2023.
I want the report (Apr 23) to show me Sales Invoice £200.00 - Outstanding (as at 13/11/2023) NIL
-
Aah I see now - Thanks for adding that extra detail, Paul. 🙂
Understand how you'd find this useful but yes not quite the same as I suggested.
We don't have this change planned atm, but we'll track interest here. I've also slightly adjusted the title to hopefully capture others that are after the same. -
Paul Murray commented
Thanks for this Kelly but not quite there. Say year end of client is July-22 like your example, yes Xero pulls the correct debtors/creditors figure at that date which matches the trial balance. But what i am after (which was a feature of both Sage & QB) is when we actually do the accounts say 6 months later, i want to know the debtors/creditors that still remain outstanding at July-22. If £10k was o/s at July-22, but £9k was paid a month or 2 later, is there any balance that i need to chase the client with. On sage, there is a box to tick to include future payments, on QB the option was to show balance at report date (July-22) or current date (open balances still at July-22). Does this make more sense now?