Skip to main content

A/R Aging Report

A/R Aging Report​

From the menu select Accounts Receivable > Invoice/Statement > A/R Aging Report

Purpose The Aging Report prints a one-line summary or detailed aging of invoices for customer accounts. The report shows the total amount of each invoice due, the total of any open credits, and the total net amounts due.

 The total invoice amounts are aged as current, 1 - 30 days past due, and three user-defined date ranges.

 The report may also be used to reconcile the total of the Accounts Receivable detail to the Accounts Receivable G/L balance. Refer to the A/R Schedule Report in the Journals Menu for a report listing A/R schedule account totals.

The aging report may be run for one specific Accounts Receivable G/L Schedule account or for all Accounts Receivable G/L Schedule accounts.

Before printing the aging report, it is important to understand the two dates associated with each customer invoice.

  • Invoice Date - The invoice date is assigned at the time the invoice is entered and posted.

  • Due Date - DockMaster automatically calculated based on the payment terms in the customer master file. If no payment terms are defined the due date is the same as invoice date.

  • Closing Date - Enter the Closing Date (last date of invoices) to include on the Aging Report. This is the invoice date or the due date depending on the next prompt.

  • Due Date or Invoice Date - Click the drop-down box to select to print an aging based on the invoice’s Due Date or Invoice Date.

Note: Use the Invoice Date option when reconciling the A/R Aging to the General Ledger A/R Schedule accounts. Use the same A/R Closing Date as the date you are balancing to in the General Ledger.

  • Number of Days in - The Aging Report allows the user to define three date ranges to age invoices. The program automatically lists the first column as CURRENT invoices with a day range from 1 to [COLUMN 1 - 1].

The beginning and ending day of each aging period can be figured out by using the following formula:

CURRENT = [1] to [DAYS COLUMN 1 - 1]

COLUMN 1 = [DAYS COLUMN 1] to [DAYS COLUMN 2 - 1]

COLUMN 2 = [DAYS COLUMN 2] to [DAYS COLUMN 3 - 1]

COLUMN 3 = [DAYS COLUMN 3] to [INFINITY]

Note: The Age period length in each column must be in ascending order (i.e. column 2 must be larger than column 1 and column 3 larger than column 2).

  • Column 1 - Enter the Number of Days in your first aging period or press Enter to default to 30 days. The default will create a range from 30 - 59 days.

  • Column 2 - Enter the Number of Days in your second aging period or press Enter to default to 60 days. The default will create a range from 60 - 89 days.

  • Column 3 - Enter the Number of Days in your third aging period or press Enter to default to 90 days. The default will create a range from 90 - infinity days.

  • Detail, Summary, or Total - Click the drop-down box to select the output option for this report. Select Summary to print the report in SUMMARY, listing only a total for each aging period for each customer. Select Detail to print the report in DETAIL, listing each customer’s individual invoices by age. Select Total to print the report in TOTAL, listing only a total for each aging period. No customer breakdown will be given.

  • Sort By Name, Boat or Location - Click the drop-down box to select a sort option for this report.

  • G/L Schedule Account - Enter a G/L Schedule Account or leave the prompt blank to print a report for ALL schedule accounts. Each invoice in DockMaster is assigned a schedule account at the time it’s posted to a customer’s account. This option allows you to generate a report for A/R transactions posted to a particular A/R Schedule account.

  • Category Code - Enter a Category Code or leave the prompt blank to print a report for ALL categories. This option allows you to generate an aging for customers with a specific customer category code.

Note: Multiple category codes can be assigned to a customer in the Customer File; this option will select the customer if the code exists in the list.

  • Display Customer Comments - Click this option to display the Comment field from the Customer File on this report. The Comment field can be found on the Billing tab in the Customer File.

  • Click the Print button to print this report.