Report Accounts Receivables Aged Trial Balance

This report shows the AR balance for each account, broken down by current and aged receivables. The report sorts by store location, with an optional secondary sort by customer class. The following report types are available:

When you run this report on demand, the report displays long term revolving amounts only if you select today's date as the As Of Date. When the EOD process generates the report during (Generate Daily Reports), the report includes long term revolving amounts.

Totals and grand totals shown at the end of the report are broken out by Open Item and Long Term Revolving (if applicable).

The output of this report may be affected by Regional Processing restrictions. That is, you can inquire only about customers and locations to which you have access.

This report runs as part of the End-of-Month process.

Check this box if you want to group data based on the store in which the transaction activity takes place. Note that if you select this option, you cannot use the resulting report to audit your general ledger.

Leave this box blank if you want to group data based on the store associated with the customer via the Store Assignment field in the Advanced Customer Settings.

When this report runs as part of the End-of-Month process, it groups data by store assignment.

Enter one or more customers to whom you want to restrict this report. If you click on the Search button, the Search for a Customer window appears which you can use to select a customer. If you click on the Action button, the Multiple Customer Selection window appears from which you can choose. If you leave the field blank, you select All customers.

If you enter a response at the Customer Class field, you inactivate this field.

Enter one or more customer classes to which you want to restrict this report. If you click on the Action button, the Multiple Entry Window appears in which you can enter one or more customer classes. If you leave this field blank, you select All customers.

When you run this report, the system searches the Customer Class field in the Customer Settings and includes all customers whose class matches any of the classes you enter here.

If you enter a response at the Customer Account field, you inactivate this field.

If revolving receivables is active and you have customers with payment agreements set up on the system, you can run this report for a specific payment agreement source. Click the Search button to select a source code from the Read-Only Lookup Window. If you select a payment agreement source, the District, Store, Customer Account, Customer Class, Secondary Sort by Class, and Group Data By fields become inactive.

Select the type of report you want to produce. You have the following options:

Detail - breaks down each account balance by transaction type ( The customer's code or name displays on the detail report, depending on the Report Sort By setting in your Accounts Receivable Control Settings.)
Summary - displays only the total receivables for each account ( The summary version displays only the customer code and not the name.)
Audit - displays additional detail including component amounts of each transaction (for example, deposit applied, payment received, etc.)
Total - displays the grand totals only
Store Totals - produces a summary version with store totals only; also checks the box at Exclude Comments and inactivates that field.

Select the aging method you want to produce. You have the following options:

Periodic - with this aging method, portions of the customer's balance may appear as a current, past due and future due receivables.
Bank - with this aging method, the customer's total accounts receivable balance is reported based upon its oldest A/R item.
Recency - with this aging method, the customer's total accounts receivable balance is reported based upon the customer's last payment date. If last payment date is less than or equal to 30 days the total AR balance is reported as 'Current'. If last payment date is greater than 30 days the total AR balance is reported in the aging column based on the customer's last payment date. Thus, when using the recency method of aging, the customer balance never appears in the 1-30 column. If the customer has not made any payments the bank aging method is used, which reports the total AR balance in the oldest aging column.

When this report runs based upon Store of Activity or if it is run as a Detail or Audit report, the aging method is set to Periodic and cannot be changed.

For the Periodic and Bank aging methods, the customer’s open items are aged based upon their due date and the date of the report. Credits are then applied based upon the Credit Aging Method in the Accounts Receivable Control Settings. For example, the customer has a $100 balance that is 31-60 days old, a $150 current balance, and a $600 Long Term Balance.

--Using the example above and the Periodic Aging Method, $150 is reported as current, $100 is reported as 31-60 days past due and $600 is reported as future due reported in the A/R Balance Column.

--Using the example above and the Bank Aging Method, the customer’s total balance of $850 is reported as 31-60 days past due.

Use this field to include or exclude the following options:
- Customers with NO activity - Check this box to exclude customer that have no activity. Otherwise, leave the field blank.
- Customers with ZERO balance - Check this box to exclude customers that have a zero balance. Otherwise, leave the field blank.
- Credit Transactions - Check this box to exclude credits from the aging calculation as well as Long Term Revolving credit balances (checking this field does not prevent credit balances from showing on the report). Otherwise, leave the field blank.
- Comments - To include customer credit comments in the report, check the box. Otherwise, leave the field blank. If you check the box, the report includes comments entered in the Account Comments field on the Point of Sale tab in the Advanced Customer Settings for selected customers. This field is active only if you select Detail or Audit at the Report field.

If you choose to export this report to excel, there are five additional columns that display: Open Item Balance, Long Term Installment, Long Term Revolving, Disputed Amount, and Last Pay Date.