Customer Aging Report
The Customer Aging report provides an overview of unpaid customer debts. For each customer who owes you money, the report shows:
- The value of the customer debt
- The age of the debt (the length of time the debt has remained unpaid)
- Liability accounts in which the debt is recorded
- Subtotal balances for each unpaid invoice
Customer debts are grouped by age, and the analysis of each customer debt is provided.
The report fetches data from the Customer Aging journal.
The basic Customer Aging report provides a list of customers with their outstanding balances, the total amounts being displayed in your company’s (system) currency and in the customer’s currency and being broken into date ranges of 30 days.
For example, the customer total debt is 10 000 EUR (and your customer’s currency is GBP) but it is made up of payments that are behind schedule for different periods of time. For example, a payment worth 6 000 EUR is 15 days past due, so the amount is displayed in the column containing invoices that are 30 days old or less (the Value:30 column) and is presented in both EUR (in the Amount column) and in GBP (in the Currency amount column). Another payment worth 4 000 EUR is 36 days past due, and its amount is recorded in the column containing invoices that are 31-60 days old (the Value:60 column) and it is also displayed in both currencies.
The total amounts are also summarized and displayed in the Total column.
For each customer, the report also contains information about liability accounts in which the customer debt is recorded. If slices of the debt are recorded in different accounts, the total amount is broken into corresponding subtotals that are allocated to different liability accounts presented in the report. For each liability account, you can find a currency or currencies in which the debt or its slice is to be paid. For each currency provided, you can see the list of unpaid invoices that have to be paid in this currency.
To go to the Customer Aging report
1. On the Codejig ERP Main menu, click the Reports tab.
2. Under the Reports tab, click the Sales folder, and then select Customer Aging report.
Customer Aging Report: Header Area
Customer Aging Report: Default Grouping
Customer Aging Report: Default Summarizing