Accounting Ideas

Aged debtor report by due date

It's very difficult to monitor the sales ledger when the aged debtor report is only aged by invoice date. Different customers have different payment terms, so the report should be aged on due date to highlight invoices that are overdue for payment and those that are coming due in the next week. Every other accounting software I have used does this!

  • Guest
  • Mar 8 2021
  • We're Taking A Look At This
  • Attach files
  • Guest commented
    November 13, 2023 14:42

    We need to be able to run a debtors report by Due Date (not invoice date). We need reports aged on due dates to keep track of cashflow and payments due.This is a basic report which most other systems have. We need reports aged on due dates to keep track of cashflow and payments due.

  • Guest commented
    August 22, 2023 08:14

    Both Aged debtor and creditor reports, either need an option to select by due date or create another set of reports that have the date by due date. Extra credit terms are also needed to arrive at an accurate due date. e.g. End of the month + x Days. EOM + 30 or EOM +60.

  • Guest commented
    January 25, 2023 10:38

    This really needs to be addressed. At the moment I am having to download into an excel spreadsheet as a detailed report, then move them over into net monthly months. Same with both ledgers and it is time consuming and inefficient. In my opinion this is a basic thing that should be part of any accounting package to chose a report based on customer or supplier terms and not just in days overdue. Please look into this urgently!

  • Guest commented
    November 14, 2022 11:11

    This is such an obvious and basic request. Customers and suppliers have different payment terms. We need reports aged on due dates to keep track of cashflow and payments due. I love Sage, but this is such a problem.


  • Guest commented
    August 09, 2022 13:56

    Agree - we can set the due date for individual records but the due date doesnt show on the supplier or customer activity screen or on the reports. Not helpful or user friendly

  • Guest commented
    July 06, 2022 08:19

    Totally agree - it would increase visibility of debt and help with credit control. Currently it causes confusion to the senior management as they get a false sense of what's owed and days overdue.

  • Guest commented
    August 06, 2021 08:15

    In Sage 50 we had a report called 'Outstanding Customer Invoices' by due date, but there is nothing similar now. Please can this be added?


  • Guest commented
    June 16, 2021 16:11

    Hi there,

    I run a debtors report every month and it puts the totals into the periods from the date of the invoice not the date due for payment. It would be very helpful to have a debtors report that showed you what was really over as per the customers credit terms and the invoice due date instead of the invoice date.

  • Guest commented
    March 10, 2021 18:08

    The same applies to the Aged Creditors report - it would be much more useful to have invoices aged on their due date rather than the invoice date.