Accounts Receivable Summary

Accounts Receivable Summary collapses the invoice by invoice list into one row per customer: total invoiced, total paid, credit notes, outstanding, and the outstanding split into the same ageing buckets. It is the view for an owner or manager who wants to know total debtors and the three customers who owe the most, not every invoice number. The grand total of the Outstanding column must equal the Debtors balance in the Trial Balance on the same date; if it does not, an unallocated receipt or a broken Payment Ledger row is the usual cause. Jivan Dahal shows invoiced Rs 36,160, received Rs 36,160 and outstanding Rs 0 in the demo. Use it monthly to decide credit limits.

Per customer: Outstanding = Sum of invoiced - Sum of paid - Sum of credit notes; grand total = Debtors balance

1. 01Go to Financial Reports > Accounts Receivable Summary.
2. 02Set Company, Report Date and Ageing Based On Due Date; optionally Customer Group or Territory.
3. 03Read Total Invoiced, Paid, Credit Note and Outstanding per customer with the ageing columns.
4. 04Compare the Outstanding grand total with Debtors in the Trial Balance for the same date.
5. 05Open the detailed Accounts Receivable report for any customer whose over 90 days column is large.
6. 06Set credit limits on the Customer record for parties that are habitually late.

Open for a management view of debtors without every invoice line.

Jivan Dahal: invoiced Rs 36,160, received Rs 36,160, outstanding Rs 0.