Debtor Aging Report

What is the function of the Debtor Aging Report?

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.Go to Accounting > Debtor Aging Report from the main menu.

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

3.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

4.Click on the name to see the breakdown of invoices.

The reasons If there is negative amount shown in the table:

1. You have over collected debt from your debtor. You collected more than the amount your debtor owes to you. For example, you issue an invoice to Debtor A for an amount of RM1,000, and you receive RM1,500 from her/him. The RM500 will be shown as a negative amount in the aging report.

2. Your debtor returns goods to you after you collected payment from them. For example, you have collected RM1,500 from Debtor A for the goods, however, they return goods after that. You will have to create a credit note to debtor A in the system. 

3. Opening balance error. You should have a key in the appropriate debtor opening amount once you start using Biztory. For example, if the invoice is created before the opening balance date but the payment created after the opening balance date. System will detect as there is an cash inflow but no sales created, there is no tally between the cash inflow and the debtor amount, meaning to say this is over collected.