Creditor Aging Report (New Vers.)

Creditor Aging Report (New Vers.)

The Creditor Aging Report helps you track how much you owe and how long you have been owing it.

It allows you to monitor overdue payments or payments that are yet to be made to your creditors, making it especially useful when you need to check from a previous date.

1. Click on Accounting and select 'View Report'

2. Click on Creditor Aging Report

3. Select a date that you wish to use to view overdue payments to creditors

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 supplier 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 supplier

12. Filter the branch

13. Click on the three-dot menu

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

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

1. You have overpaid your creditor. You paid more than the amount you owe to your creditors. For example, you owe Creditor A an amount of RM1,000, and you paid him/her RM1,500. The RM500 will be shown as a negative amount in the aging report.

2. You return goods to creditors after you make payment to them. For example, you have paid Creditor B RM1,500 for the goods, however, you find out there are some damaged goods and return them to Creditor B. You will have to record a credit note given by Creditor B into the system. 

3. Opening balance error. You should have a key in the appropriate creditor 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 amount debit but no amount credit so no tally is overpaid.