Edit

Share via

Customer aging report

The Customer aging report shows the balances that are due from customers, sorted by date interval or aging period.

When you generate this report, it displays the following default parameters. Use these parameters to filter the data that appears on the report. For more information, see Set up collections.

Field

Description

Billing classification

Select one or more billing classifications to include on the report.

Note: This control is available only if the Public Sector configuration key is selected.

Include transactions without a billing classification

If you select this checkbox, the report shows all transactions that don't have a billing classification assigned to them.

Note: This control is available only if the Public sector configuration key is selected.

Aging as of

Enter the date used on the current aging bucket.

Balance as of

Enter the date to view the customer balances for. This is also known as a cutoff date for transactions.

Start date

Enter a date that is in the first period interval or aging period to include on the report.

Criteria

Select the type of date to base the report on.

  • Transaction date – The posting date of the transactions. For example, this might be an invoice date that is the basis for the calculation of the due date.

  • Due date – The due date of the transactions, based on the terms of payment.

  • Document date – A user-defined document date that is the basis for the calculation of the due date.

Aging period definition

Select an aging period definition. The Interval field isn't used if you select an aging period definition.

Aging period definitions that have more than six aging periods can't be used on the printed report.

Note: Set up aging periods on the Aging period definitions page.

Print aging period description

Select Yes to include aging period descriptions at the top of each aging period column on the report. Select No to print the report without column headers.

Interval

Define the period to use by entering the number of the day or month units in each period. For example, to view aging information by week, enter 7 in this field and select Day in the Day/Mth field.

Note: The information that you enter in this field is used only if you didn't select an aging period definition. Otherwise, the printing direction is defined on the aging period definition.

Day/Mth

Select the unit, either Day or Month, that's used to define the period in the Interval field.

Printing direction

Select whether to calculate balances and print the aging report for past or future periods. The dates are evaluated relative to the date that is selected in the Balance as on field. Select Backward to show information for past periods. Select Forward to show information for future periods.

Note: The information that you enter in this field is used only if you didn't select an aging period definition.

Details

Select to list the transactions that are included in the balances that are shown on the report.

Include amounts in transaction currency

Select to include amounts in the transaction currency in addition to amounts in the accounting currency. If you don't select this checkbox, the amounts on the report are displayed only in the accounting currency.

Negative balance

Select to include customer accounts that have negative balances.

Exclude zero balance accounts

Select to exclude customer accounts that have a zero balance.

Payment positioning

Select to display payments that aren't settled. These payments are displayed in the first column of the report.
  • Last updated on