Payment Ledger in ERPNext
The Payment Ledger is a separate ledger in ERPNext that records transactions only for Receivable and Payable accounts.
Whenever a transaction impacts an account whose Account Type is set as Receivable or Payable, the corresponding entries are automatically recorded in the Payment Ledger.
The Payment Ledger acts as the primary source for tracking outstanding receivables and payables, making customer and supplier balance calculations faster and more accurate.
1. How Payment Ledger Works
Payment Ledger captures transactions related to:
- Customer Receivables
- Supplier Payables
- Sales Invoices
- Purchase Invoices
- Payment Entries
- Credit Notes and Debit Notes
Only accounts configured with the Account Type as Receivable or Payable are included in the Payment Ledger.
If an account is not marked as Receivable or Payable, its transactions will not be recorded in the Payment Ledger.
2. Example
Suppose a Sales Invoice is created for ₹1,000 and later a Payment Entry is made against that invoice.
The Sales Invoice creates an outstanding receivable, and the Payment Entry reduces that outstanding amount.
Both transactions are reflected in the Payment Ledger, allowing ERPNext to accurately calculate the invoice balance and payment status.
The Payment Ledger continuously tracks invoice balances by recording both invoice creation and payment allocation entries.
3. Usage in Reports
Several important accounting reports use the Payment Ledger as their primary data source.
These include:
- Accounts Receivable Report
- Accounts Receivable Summary
- Accounts Payable Report
- Accounts Payable Summary
Because these reports rely on the Payment Ledger, outstanding balances are calculated more efficiently and accurately.
Receivable and Payable reports no longer depend solely on General Ledger entries; instead, they use the Payment Ledger to calculate outstanding amounts.
4. Usage in Reconciliation Tools
The Payment Ledger is also used by reconciliation utilities in ERPNext.
Supported tools include:
- Payment Reconciliation
- Semi-Auto Payment Reconciliation
These tools use Payment Ledger data to:
- Identify outstanding invoices
- Match payments with invoices
- Allocate unassigned payments
- Update receivable and payable balances
The reconciliation process updates only the Payment Ledger, ensuring invoice outstanding amounts remain accurate without altering the original accounting entries.
5. Benefits of Payment Ledger
- Improves receivable and payable tracking
- Provides faster outstanding balance calculations
- Enhances payment reconciliation accuracy
- Reduces dependency on General Ledger queries
- Supports efficient financial reporting
- Maintains clear separation of payment-related transactions
By maintaining a dedicated ledger for receivables and payables, ERPNext delivers more efficient reporting, reconciliation, and outstanding balance management.
