All Collections
Reports
Accounts Receivable System
Accounts Receivable Aging Report Options
Accounts Receivable Aging Report Options
Jeremy Johnson avatar
Written by Jeremy Johnson
Updated over a week ago

When making collection calls, it is most efficient to have a concise list of those companies that are past due. There are a number of options available when printing the Accounts Receivable Aging in The Business Edge.

If you were to print an Accounts Receivable Aging Report, and use all of the defaults that the system suggests, your printed report would be what most companies consider a typical Aging report.

There are a number of options available in The Business Edge when printing the Accounts Receivable Aging. You will find these options helpful, particularly when you are making collection calls. This document will go through all of the options individually.

You can print an aging for any range of customers, if you press enter at Begin With Customer and End With Customer the system will include all Customers. If you would like a single Customer you can simply type in the Customer Name you would like.

Customer Sequence By, your options are Customer Name or Customer Code. The system default is Customer Name, this makes if very easy to locate specific customers on the Aging.

AS OF Date, You can print the Accounts Receivable Aging “As Of” any date. If you were to print the aging as of 06-30-01 all invoices and payments since that date would not be included. Your report would reflect what your aging was As Of 06-30-01.

Days per Period is defaulted to 30. This means your columns will be in 30 day increments.

Number of Periods is defaulted to 5. This means you will have 5 columns. If you selected 30 days per period and 5 periods you will have a column for 0-30 days, 31-60 days, 61-90 days, 91-120 days and 120 and over.

Use Whole Month Periods, which is defaulted to No, will use full months instead of days. If you were running your Aging in September and included 5 periods, your Columns would be September, August, July, June and May.

Date to Age by can be Invoice Date or Due Date. The system default is Invoice Date. If you are printing the Aging as a tool for collection calls you may want to run it by Due Date. This way the invoices that show up in the 0-30 column for instance would be 0-30 days past due, the invoices in the 31-60 day column would be 31-60 days past due etc. The only time the Current Column is used is when you are running the aging by Due Date. The Current column would then represent the Invoices that are not due yet.

Show all invoices for Customer, this option is only considered if you are selecting specific periods with the F3 Key.

The F3 Key allows you to select specific periods you would like included on the aging. For instance, if you were short on time and wanted to make collection calls you might press F3 and answer No to 0-30 and 31-60 days, this way only invoices that were 61 and over would be included. But if your customer also had some more current invoices you might want to see those also. So if you answer Yes to Show all invoices for Customer, the system will show all invoices if they have any invoices that are 61 days or older.

Suggestion: Print this for invoices over 60 or over 90 days only. Then call up each customer in Customer Inquiry as you are making your collection calls. You can then enter their response in the Customer Notes. If you have the Fax option you can also fax Invoice copies or a statement from the Customer inquiry screen.

Summarize Customers is defaulted to No. This option will present a Subtotal for each Customer under the appropriate column. This is a much shorter report than the typical aging that lists all invoices.

F4 = Additional Information function key will enable you to select or deselect information to be included on the aging. The system automatically prints the Customer Code and Name as well as defaults the telephone number to Yes. If you would like additional fields you can select them on a one time basis, or you can change your defaults in User Flags, Accounts Receivable, F4 Aging Flags.

Did this answer your question?