Run an Acumatica AR aging report by customer

For an Acumatica customer balance at month-end, run AR Aged Period-Sensitive (AR630500). Record the financial period, the Aged On date shown on the report, and the customer’s statement cycle.
Upload a case

Key facts

The Aged On date is the last day of the selected financial period. Record the customer’s statement cycle to explain the aging buckets.

Choose the month-end report

On Report Parameters, choose the financial period and select Detailed to see open documents. Narrow by company, branch or customer class if needed. Locate the customer in the report, where results are grouped by statement cycle and customer. See the Acumatica report reference for the available parameters.

Record how the buckets were calculated

Record whether the customer’s statement cycle ages by document date or due date. That basis can change the bucket an invoice lands in. If you use the report as a follow-up list, compare it with the current customer record for payments or credits posted after the cutoff.

Test the extract on one customer

Take a December 31 extract for a customer who paid on January 4. Keep an invoice outstanding at the December cutoff in the month-end file. Remove it from the current follow-up list once you have matched the January receipt. Use this receivables reconciliation template to keep the two views and their dates clear.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.