Home > Reports > Report Financing Aged Trial Balance
Report Financing Aged Trial Balance
(FR Aged Trial Balance)
Access
This report shows the status of finance receivable balances for
-
all or selected finance providers,
-
all or a selected payment type,
-
for a selected date or dates, or
-
as-of a selected date.
Each line item includes a customer name. The report shows a breakdown by age (current and past) of Finance Receivables balances. The range of days in each aging column (for example, 1-7, 8-14, over 14, or 1-30, 31-60, over 60) is determined by the setting in the Number of Aging Days field in the Financing Control Settings (Finance Receivables ACF) file. Three report types are available:
This report does not include finance transactions from finance providers for the which the Auto-Pay Post Bank option is enabled in the Finance Provider Settings.
Report Type
Finance ProviderSpecify the finance providers to include in this report. If you click on the Search button, a list of valid finance provider codes appears from which you can choose. If you click the Action button, the Multiple Finance Provider Selection window appears from which you can select one or more providers. To report on all providers, leave this field blank.
Payment TypeSpecify the payment types to include in this report. If you click on the Search button, a list of valid payment type codes appears from which you can choose. To report on all payment types, leave this field blank.
Date CodeClick on the Arrow button to view a list of date codes, then select the code that best indicates the time period on which to base your report.
As Of DateIf you select CUS (custom) at Date Code field, you activate this field. Use this field to specify the as-of date for which to run this report. If you click on the Calendar Icon, you can select a date from the calendar that appears.
If you select another date code instead of CUS, this field fills in based on that selection and you cannot edit this field.
Send Output toThe output destination of the report displays. To change the output destination, click on the Actions button and select Output Settings.
Export PathIf you select either the Personal Report Viewer (PRV), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.


Once the run-time options have been selected, choose Run to produce the report.