Aged Analysis Reports

Ageing reports sort transactions into ageing bands. You can age the transactions for any type of account, but the most frequently used aged reports age the transactions for debtors/receivables and creditors/payables accounts. You might also use an aged report to analyze cash flow.

Note:  The standard aged analysis reports display values in the base currency only.

Ageing reports can help you to plan your credit control activity and your payments. An aged debtors/receivables report shows your customers' outstanding debts to you. An aged creditors/payables report shows your commitments to suppliers and when you are due to pay them.

On debtor/receivables and creditor/payables accounts, ageing backward tells you how long outstanding transactions have remained unpaid.

On debtor/receivables accounts ageing forward may be used to project receipts. On creditor/payables accounts, it is useful for projecting outgoings.

If you select both debtor and creditor accounts and choose a forward ageing report, the report shows your net cash flow.

The standard ageing reports allow you to age transactions either forward or backward by due date. You can choose to report in the base currency only, or include the transaction currency.

The due date, by which the transactions are aged, is determined on each transaction from the payment terms. You can define up to four ageing periods for the report.

SunSystems includes four predefined aged analysis reports:

Aged Analysis - Back Due Date Detail

The Aged Analysis Back Due Date Detail (AAB1D) report ages the selected transactions backward by due date, and prints the transaction values in the base and transaction currencies.

Aged Analysis - Back Due Date Summary

The Aged Analysis Back Due Date Summary (AAB1S) report ages the selected transactions backward by due date, and prints the transaction values in the base currency only.

Aged Analysis - Forward Due Base Detail

The Aged Analysis Forward Due Base Detail (AAF1D) report ages the selected transactions forward by due date, and prints the transaction values in the base and transaction currencies.

Aged Analysis - Forward Due Base Summary

The Aged Analysis Forward Due Base Summary (AAF1S) report ages the selected transactions forward by due date, and prints the transaction values in the base currency only.

All these reports are produced using the SunSystems Reporting functionality, so you can define your own ageing reports or modify the layout of these reports, if required.