Skip to content
← For small businesses

Enter your idea

For small businesses: Accounting features

Categories

(thinking…)

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,

35 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Paul Murray shared this idea  ·   ·  Report…  ·  Admin →
delivered  ·  AdminKelly Munro (Community Manager, Xero) responded  · 

Hi everyone, thanks for showing your interest here. With the newer Aged Detail reports, you can achieve this by;

  1. Setting the date of the report to the date you want to include payments up to
  2. Click Filter
  3. Set an Invoice Date filter as 'any' - 'invoices raised up to date'

If this is something you'll commonly run you may want to save the report as custom so you can easily open the report anytime. You'll just want to remember to adjust the filter for the Invoice Date. 🙂

Show previous admin responses (1)
Comments are closed An error occurred while saving the comment
  • Kevin Dodd commented  ·   ·  Report

    Is this still not possible in Xero? Any updates at all available?

  • Bev (Accounts) commented  ·   ·  Report

    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  ·   ·  Report

    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

  • AdminKelly Munro (Community Manager, Xero) commented  ·   ·  Report

    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  ·   ·  Report

    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?

  • Stuart Schembri commented  ·   ·  Report

    To be able to run a report at a specific time and exclude the items which have been laterally paid.