Accounts Receivable Aging Report

Go To User Guide - Accounts Receivable

Accounting>File>Accounts Receivable>Aging Report

This selection prints a report through the user-specified date on all delivered invoices with the option to define up to four aging periods.

Although this looks similar to the Month-End Accounts Receivable aging report, it is not a true month-end report as it reflects transactions up to the minute. Aging by delivery date will provide a true accounts receivable figure. 

Field Explanations

Field	Explanation
Aging Date	Defaults to current system date. Use the F8 button to access the calendar.
Starting/Ending Name	If the name is left blank, ALL customer mains and their branches are printed. Customers that do not belong to a main/branch relationship will not print. If a name is entered, the report will include all orders that are a part of the main/branch relationship, including other branches. If Property report type is selected, the Name selection will change to Property title.
Aging Periods	The report will list all invoices that are current (up to 30 days), 30-60 days, 60-90 days, and over 90 days. While the system defaults to this aging schedule, contiguous aging periods are definable.
Report Type	General: This report is sorted in a general format that lists all Accounts Receivables in alphabetical order and their past due status. This report displays all delivered invoices through specified dates. The report is sorted by account name and shows the telephone number, invoice number, date, receivable amounts in each of the four aging periods, and the A/R total.  By Salesperson: This report is sorted by Sales Rep that lists all Accounts Receivables for each salesperson and their past due status. Orders which are split between 2 sales reps will only be listed for Sales Rep 1. Property: This report is sorted by Property name and lists alphabetically and by date the customer name and orders linked to that property. If this report type is selected, the Name selection will change to Property title. Billing Group: This report is sorted by Billing Group and lists alphabetically and by date the customer name and orders linked to that group.
Age By	Delivery: Next to the Invoice column will be a Delivery Date column. The delivery date of an order will be listed next to each one. Invoice: Next to the Invoice column will be an Invoice Date column. The invoice date of an order will be listed next to each one. Due: Next to the Invoice column will be a Due Date column. The due date of an order will be listed next to each one. Order: Next to the Invoice column will be an Order Date column. The order date of an order will be listed next to each one.
Description to Use	The description is the first column of the report. Select a different option to change what information appears in this column. Options include: Ship To Name, Sold To Name, Job Num/TB, Po Number, Ship To Addr1
Customer Types	Select one, multiple, or all customer types to include in the report.
Salespersons	Select one, multiple, or all salesperson to include in the report.
Stores and Combine Stores	Select one, multiple or all stores to include in the report. Different stores will be separated by a page break. Check Combine to merge all stores into a single report.
Remark Types to Print	Select one, multiple, or all remark types to include in the report.
Print Preview	View the report in a print preview before printing.
Summary	Print a summary report that lists only the customer open receivables sub-totals.
Exclude Out of Period Balances	Balances that are outside of the set aging periods will not be included with the report.
Include Invoices on Hold	Invoices that have an on-hold status will be included with open invoices.
Generate Page Break for Sort	Depending on the report type selected, a page break will be inserted after each account name (general report), salesperson, property title, or billing group.
Include Not Job Costed	This checkbox becomes available if the Age By option is set to Order. Check this box to included invoices that have not been job costed.
Exclude Credit Balances	If the account holder is on a payment plan this option will exclude the remaining balance and show if they are up to date on payments.
Print Customer Notes	Customer Notes from the customer file can be printed on the report. They are not included in the CSV because the data could be incompatible with the .csv file format.
Show Retainage	Retainage has its own column on the report. Retainage shows in the retainage column until the number of days has passed from the Final Billing Date.  Once retainage is due, it ages separately from the non-retainage amount. If retainage has not been billed yet, but payment has been made above the non-retainage amount then a negative non-retainage will be aged.
Output CSV	Choose to create a CSV file in addition to a printed report.

Report Example

List of CSV Output

Store

Salesman

Customer

Telephone

Date Entered

Description

Inv Number

Date

0 - 30 Days

31 - 60 Days

61 - 90 Days

91 - 999 Days

Balance

Retainage

PO_Num