This article explains how to generate a creditor age analysis report in d6+. The report shows outstanding creditor amounts grouped by the age of the debt.

Reports > Finances > Creditors: Age Analysis

How to generate an age analysis report

1. Select the date for which you want to generate the report.

2. Select whether to generate the age analysis by Creditor or by General ledger control account.

3. Select whether the report should be generated per Standard analysis (showing outstanding days) or per Payment terms.

4. Select which balances to show on the report: All balances, Debit balances, Credit balances or Zero balances.

5. Select whether to sort the report by Code or Supplier.

6. Click Preview to generate the report.

Frequently asked questions

What is the difference between Standard analysis and Payment terms?

Standard analysis shows outstanding amounts grouped by the number of days outstanding. Payment terms groups the outstanding amounts according to the payment terms linked to the creditor.

Can I generate the report for a specific creditor?

The report can be generated per creditor or per general ledger control account. Select the appropriate option in step 2 to refine the report.

Why do I see zero balances on my report?

If you selected All balances, creditors with a zero balance will also appear. Select Debit balances or Credit balances to show only accounts with an outstanding balance.