The Debtor Age Analysis Options allows you
to select the options to analyse your transactions with each of your debtors
according to specified accounting periods. This could be a useful tool to manage
your outstanding debts and to see which debtors are not performing according to
your credit agreements. You may also use this facility to calculate provision
for bad debts. This Report will display a break down of your debtor account
balances for each of the specified periods for a selected debtor account or a
range of selected debtor accounts.
This report consists of the following 8 columns:
Column 1 - Reference No. - This is the reference number of the transaction as entered into the reference field of the Batch Entry screen. If you generate documents (Invoices and Credit Notes) the Document number will be displayed in this column. If the Show Transactions field is not selected on the Debtor Age Analysis Options screen, the reference number will not be displayed.
Column 2 - Date - This is the date of the transaction. If the Show Transactions field is not selected on the Debtor Age Analysis Options screen, the date will not be displayed.
Column 3 - Batch Type - The name of the selected batch type in which the transaction was entered and posted or updated to the Ledger. If the Show Transactions field is not selected on the Debtor Age Analysis Options screen, the batch type will not be displayed.
Column 4 - Transaction Total - The total outstanding balance for the debtor account as at the selected date of ageing.
Column 5 - Current to - The outstanding balances as at the end of the specified accounting period (e.g. the selected current accounting period).
Column 6 - 30 Days to - The outstanding balances as at the end of the specified accounting period (e.g. 1 accounting period or month back).
Column 7 - 60 Days to - The outstanding balances as at the end of the specified accounting period (e.g. 2 accounting period or months back).
Column 8 - 90 Days to - The outstanding balances as at the end of the specified accounting period (e.g. 3 accounting period or months back).
At the end of each of the selected debtor accounts, a total will be displayed and at the end of the report, a total for all of the selected reports will be displayed for each of the selected ageing periods.
This report consists of the following 8 columns:
Column 1 - Reference No. - This is the reference number of the transaction as entered into the reference field of the Batch Entry screen. If you generate documents (Invoices and Credit Notes) the Document number will be displayed in this column. If the Show Transactions field is not selected on the Debtor Age Analysis Options screen, the reference number will not be displayed.
Column 2 - Date - This is the date of the transaction. If the Show Transactions field is not selected on the Debtor Age Analysis Options screen, the date will not be displayed.
Column 3 - Batch Type - The name of the selected batch type in which the transaction was entered and posted or updated to the Ledger. If the Show Transactions field is not selected on the Debtor Age Analysis Options screen, the batch type will not be displayed.
Column 4 - Transaction Total - The total outstanding balance for the debtor account as at the selected date of ageing.
Column 5 - Current to - The outstanding balances as at the end of the specified accounting period (e.g. the selected current accounting period).
Column 6 - 30 Days to - The outstanding balances as at the end of the specified accounting period (e.g. 1 accounting period or month back).
Column 7 - 60 Days to - The outstanding balances as at the end of the specified accounting period (e.g. 2 accounting period or months back).
Column 8 - 90 Days to - The outstanding balances as at the end of the specified accounting period (e.g. 3 accounting period or months back).
At the end of each of the selected debtor accounts, a total will be displayed and at the end of the report, a total for all of the selected reports will be displayed for each of the selected ageing periods.
![]()
![]()
![]()
taken from the