Debtor Aging Report (New Vers.)

Debtor Aging Report (New Vers.)

The Debtors Aging Report is a financial document that categorizes outstanding customer balances based on the length of time they have been outstanding. It typically breaks down customer balances into different time periods, such as current, 30 days, 60 days, 90 days, and so on, indicating how long each invoice or balance has been outstanding. This report helps businesses track and manage their accounts receivable by providing insights into the age of outstanding balances and identifying potential collection issues. 

The Debtors Aging Report takes into consideration not only outstanding balances owed by customers but also accounts for overpaid amounts and other journal entries associated with specific debtors. This comprehensive approach ensures that the report accurately reflects the financial status of each debtor by considering all relevant transactions and adjustments made to their accounts.

1. Click on Accounting and select 'View Report'

2. Click on Debtor Aging Report

3. Select a date that you wish to view overdue payments from debtors

4. Some tips for reading the report

• Current: payments that are due for less than 1 day from invoice due date

• 1-30: payments that are due for 1 to 30 days from invoice due date

• 31-60: payments that are due for 31 to 60 days from invoice due date

• 61-90: payments that are due for 61 to 90 days from invoice due date

• 91-120: payments that are due for 91 to 120 days from invoice due date

• 121-150: payments that are due for 121 to 150 days from invoice due date

• 151-180: payments that are due for 151 to 180 days from invoice due date

• 180+: payments that are due for more than 180 days from invoice due date

5. Click on a customer name to see the breakdown of invoices

6. Click on the settings menu

7. Filter aging by day or month

8. Days

9. Months

10. Check 'Customize Range' to edit your preferred day range

11. Filter the Customer

12. Filter the branch

13. Click on the three-dot menu

14. Choose to export the Debtor Aging Report as an Excel or CSV file