Customer Ledger Summary

Customer Ledger Summary is the statement of account you send a customer: for each customer in the period, the opening balance, invoiced amount, payments received, credit notes (returns) and the closing balance, all from GL Entry on the Debtors account. Where Accounts Receivable looks only at unpaid invoices, this report shows the whole flow of the period, including invoices that were paid, which is what a customer wants to see when disputing a balance. Jivan Dahal reads opening Rs 0, invoiced Rs 36,160, paid Rs 36,160, closing Rs 0 in the demo. The sum of all closing balances equals Debtors. Nepali businesses often print this at Dashain and at year end for every credit customer.

Closing balance = Opening balance + Invoiced amount - Paid amount - Credit notes, per customer for the period

1. 01Go to Financial Reports > Customer Ledger Summary.
2. 02Set Company, From Date and To Date; optionally one Customer, Customer Group or Sales Person.
3. 03Read Opening Balance, Invoiced Amount, Paid Amount, Return Amount and Closing Balance per customer.
4. 04Click a customer name to open the General Ledger filtered by that party for the voucher detail.
5. 05Export with Menu > Export and send it as the statement of account.
6. 06If the customer disputes a line, check the invoice and the Payment Entry it names before adjusting anything.

Open to send a customer a statement of account or to settle a dispute.

Jivan Dahal: opening Rs 0, invoiced Rs 36,160, paid Rs 36,160, closing Rs 0.