The Creditor Age Analysis Options allows
you to select the options to analyse your transactions with each of your
creditor accounts according to specified accounting periods. This could be a
useful tool to schedule your payments to your creditors. This Report will
display a break down of your creditor account balances for each of the specified
periods for a selected creditor account or a range of selected creditor
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 (Purchase and Goods Returned documents) the Document number will be displayed in this column. If the Show Transactions field is not selected on the Creditor 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 Creditor 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 Creditor Age Analysis Options screen, the batch type will not be displayed.
Column 4 - Transaction Total - The total outstanding balance for the creditor 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 creditors 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.
If you did not take on the opening balances for each accounting period for each of your creditors, you will not be able to use the ageing facility for the first ageing periods. To take-on Opening balances for Creditor Accounts, to use the ageing feature, click here.
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 (Purchase and Goods Returned documents) the Document number will be displayed in this column. If the Show Transactions field is not selected on the Creditor 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 Creditor 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 Creditor Age Analysis Options screen, the batch type will not be displayed.
Column 4 - Transaction Total - The total outstanding balance for the creditor 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 creditors 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.
![]()
If you did not take on the opening balances for each accounting period for each of your creditors, you will not be able to use the ageing facility for the first ageing periods. To take-on Opening balances for Creditor Accounts, to use the ageing feature, click here.
![]()
taken from the