Receiving Bulk Payments in ERPNext

Use bulk payment workflows when you receive one receipt that settles several invoices, when you need to reconcile existing advances, or when many receipts are coming from a bank statement or an external system. The right method depends on where the payment information starts.

Choose the right method

Method 1: Receive one payment against multiple invoices

Use a Payment Entry when the customer has made one payment and you want to allocate that amount across more than one Sales Invoice.

1. Go to Accounting > Payment Entry and create a new Payment Entry.
2. Set Payment Type to Receive.
3. Select the Party Type as Customer, then select the customer.
4. Enter the amount received, bank or cash account, reference number, and reference date.
5. In the Payment References table, add the Sales Invoices or use Get Outstanding Invoices.
6. Enter the Allocated amount for each invoice. The same payment can fully or partially settle multiple invoices.
7. Review Total Allocated Amount, Unallocated Amount, and Difference Amount, then save and submit the Payment Entry.

The screenshot below shows one receipt allocated to multiple Sales Invoices in the Payment References table.

Payment Entry with multiple invoice references.

Method 2: Reconcile an existing payment or advance

Use Payment Reconciliation when the receipt is already recorded but is not linked to the correct invoices. This is common when a customer pays in advance, when a payment was entered before the invoice was submitted, or when an imported payment remains unallocated.

1. Go to Accounting > Payment Reconciliation.
2. Select the company, party type, party, receivable account, and date range.
3. Click Get Unreconciled Entries to fetch existing payments, advances, journal entries, and outstanding invoices.
4. Allocate the available payment amount against the correct invoices.
5. Click Reconcile after checking the allocations.

Use this method when you do not need to create a new receipt, only connect existing accounting entries to invoices.

Payment Reconciliation is used after the payment or advance already exists.

Method 3: Receive and reconcile payments from a bank statement

Use the Bank Reconciliation Tool when the bank statement is the starting point. This is useful when there are many incoming deposits and you want to match them with invoices or Payment Entries.

1. Go to Accounting > Bank Reconciliation Tool.
2. Select the company and bank account.
3. Upload the bank statement or fetch bank transactions if bank integration is configured.
4. Use Get Unreconciled Entries or Auto Reconcile to match deposits with existing Payment Entries and invoices.
5. Create or adjust Payment Entries for unmatched receipts, then reconcile them with the bank transaction.

This method is best when the receipt data comes from the bank and not from a manually prepared list.

Bank Reconciliation Tool for uploaded or synced bank transactions.

Method 4: Import many separate Payment Entries

Use Data Import when you need to create many separate receipts in ERPNext from a spreadsheet. This is different from one customer payment split across several invoices; here each row represents a Payment Entry or a child row required for the Payment Entry import template.

1. Go to Data Import and create a new Data Import record.
2. Set Document Type to Payment Entry.
3. Select Insert New Records when you are creating new receipts.
4. Download the template and fill the required parent fields such as payment type, posting date, company, party type, party, accounts, paid amount, reference number, and reference date.
5. If the receipt must be allocated to invoices, include the Payment References child table rows in the template.
6. Upload the completed file, start the import, and fix validation errors before importing into production.

Use this method only after testing the template with a few records, especially if you plan to submit the Payment Entries after import.

Data Import can create Payment Entry records in bulk from a template.

After posting bulk receipts

• Check the Customer Ledger and Accounts Receivable report for the affected customers.
• Review the General Ledger for the bank, cash, receivable, write-off, and deduction accounts.
• Use Bank Reconciliation to confirm that the Payment Entries are cleared against the bank statement.
• Investigate any unallocated amount, difference amount, exchange gain or loss, or write-off before closing the period.

Common mistakes

• Creating one Payment Entry per invoice when one bank receipt actually covered multiple invoices.
• Using Payment Reconciliation before recording the payment or advance.
• Importing Payment Entries without the Payment References child rows, leaving invoices outstanding.
• Ignoring deductions, write-offs, bank charges, or exchange differences.
• Submitting imported records without testing the template in a staging or test site first.