Run an accounts receivable aging report in ERPNext
Key facts
The report date sets the cutoff used for the receivables view. The aging basis controls how open amounts are placed in 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.
Set the reporting cutoff
Open Accounts Receivable for the correct Company. Set the Report Date to the cutoff you need and review the aging basis. Leave Show Future Payments off for a historical cutoff, then refresh the report. Use Due Date when you need to know how far past the agreed payment date an invoice is. Save the report filters with the export.
Trace the balance that needs attention
Open the source Sales Invoice and compare the outstanding amount with payments, credits and allocations recorded for that customer. If the customer has paid but the invoice still appears open, trace the receipt and invoice reference through the Payment Ledger.
Keep two reports for two jobs
In this example, a $1,200 invoice is open at October 31 and paid on November 3. Retain the October 31 result as close evidence. Run the report for today before deciding whether to contact the customer.
For help deciding which invoices to follow up, see Debitura’s accounts receivable guide.


.webp)