Month End A/R Report

  Back to Month-End Accounting Guide

Use the Month-End A/R Report during month-end close to review Accounts Receivable and Customer Deposits for a selected month.

This report can recreate Accounts Receivable for prior accounting periods. Use it to compare A/R and Customer Deposit totals to the General Ledger or journal balance.

The Month-End Undelivered report shows undelivered portions of partially billed customer orders.

Accounting>File>Month End>A/R Report

Report Options

Select the report options you need before print or previewing the report.

Option	Description
Print A/R Report	Prints open balances due as of the selected month-end date.
Print Aging	Ages the balances due. Aging periods can be changed when both A/R Report and Aging Report are selected.
Print Open Orders Report	Prints undelivered orders as of the selected month-end date.
Print Customer Deposits Report	Prints payments on undelivered orders as of the selected month-end date.
Print Customer Discounts Reports	Prints customer discounts.
Summary	Prints customer totals instead of listing each customer order.
Print Preview	Shows the report on screen before printing.
Claims Only	Run the report for Claims orders only
Output CSV to	Select this option to export this report to a .csv file for viewing in Excel.

Aging Periods

To change the default aging periods, select both:

• A/R Report
• Aging Report

The aging period fields appear after both options are selected. Enter the number of periods and the day ranges you want to use.

In a Non-ERRM database, aging is based on the delivery date.

In an ERRM database, aging is based on the bill date. If an order is billed but not booked, it ages by bill date, but the bill date column may remain blank.

Stores

Select one store, multiple stores, or all stores.

Use Combine to merge selected stores into one report.

Use the same store and Combine selection when comparing this report to the General Ledger or journal balance.

Example Reports