Supplier Ledger Summary
The Supplier Ledger Summary is a financial report in ERPNext that gives a full picture of all the transactions with your suppliers (creditors) during the period chosen. It is the main reconciliation tool for accounts payable, monitoring outstanding balances, and keeping track of your books accurately.
1. Main Purpose:
To display a summarized, date-wise history of all purchases, payments, and adjustments for a specific supplier or a group of suppliers, culminating in a running balance.
2. Accessing the Report:
Go to:
Accounting > Reports > Supplier Ledger Summary
3. Features and Filters
The report is very Flexible with the filters at the top. The most important filters are:
- Company: Choose the legal entity whose report you wish.
- From Date & To Date: Specify the date range for which you wish to view the transactions.
- Supplier: Report on a particular supplier or leave blank for all suppliers.
- Supplier Group: Filter the suppliers on a particular group (e.g., Raw Material Suppliers, Local Suppliers).
- Show Reconciliation: An important checkbox. If it is checked, you can show invoices as reconciled versus payments, which is important to ensure proper balancing of accounts.
4. Columns in the report
The report shows the following columns:
- Date: The voucher posting date.
- Voucher Type: The voucher type (e.g., Purchase Invoice, Payment Entry, Journal Entry).
- Voucher No: The transaction document ID. This is a link to view the particular voucher.
- Supplier: The Supplier’s name.
- Debit: Indicates an amount that reduces your accounts payable. This could be payments made through Payment Entry or purchase returns through Credit Notes.
- Credit: Indicates an amount that adds to your accounts payable. This would be normally a new Purchase Invoice or a debit note.
- Balance: Running cumulative balance following every transaction.
- A positive credit (Cr) balance reflects an amount you owe to the supplier.
- A positive debit (Dr) balance reflects an advance paid (the supplier owes you).
- Remarks: Any comments associated with the voucher.
- Ageing Columns (0-30 / 31-60 / …): In the event of “Aged” reporting being switched on, these columns present the breakdown of the outstanding balance by the number of days overdue.
5. Key Features
- Detailed Transaction History: Presents a comprehensive, auditable history of all transactions for a supplier over the selected time period.
- Direct Voucher Access: Any click on a Voucher No. will bring up the original transaction to view or edit.
- Reconciliation Tool: The “Show Reconciliation” filter turns the report into an interactive tool for reconciling payments against invoices, so your books balance with the supplier statements.
