Run an accounts receivable aging report in ERPNext

Keep a month-end snapshot and a current collections list with a clear report date.
Upload a case

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.

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.

See ERPNext Accounts Receivable report.

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.

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.