Run an Acumatica AR aging report by customer
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.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
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.


.webp)