Section 8: Reports > Accounting Reports

Aged Receivables

This report is a summary of receivables by customer account number aged as 0-30 days, 31-60 days, 61 to 90 days, and >90 days (see Invoicing).

Report totals include the total receivable for each aged period. The report may be sorted by customer account number, customer name, or any of the aged periods. And it may be filtered by business location. A cut-off date may also optionally be specified, after which any receivables are excluded from the report.

Report Option Fields

Field

Description

Bus. Location

Enter or select the business location for which to generate the report or leave blank for all business locations. This report option is not available in the Repair Lite and Repair Micro editions.

Cut-off Date

Enter or select the cut-off date or leave blank to use the current date as the cut-off date. The cut-off date is based on the invoice or credit note date. For approved repair orders the invoice date is the same as the repair completed date, while for refused repair orders the invoice date is the same as the estimate refused date.

Sort by

Select the desired sort order, either by customer account number, by customer name (the system default), by total receivable, by receivables aged 0-30 days, by receivables aged 31-60 days, by receivables aged 61-90 days, or by receivables aged >90 days.

 

Sales invoices are included on the report when the amount paid is different from the grand total. Repair invoices are included on the report when they are set to a repair invoice status (see Repair Invoice     Statuses) and the amount paid is different from the grand total. And credit notes are included on the report when the amount applied is different from the grand total. Overpayments on some invoices may balance out receivable amounts on other invoices. Only customers with a non-zero balance in one or more periods are included in the report.

The aging periods are determined by calculating the difference between today’s date and the invoice or credit note date, and they do not take into account the payment terms. For approved repair orders the invoice date is the same as the repair completed date, while for refused repair orders the invoice date is the same as the estimate refused date.

More:

Audit Invoice Ledger for Balances