Allocate a recorded customer payment in ERPNext

Match an existing customer receipt to the right submitted invoice and verify the balance left open.
Upload a case

Key facts

Payment Reconciliation allocates a receipt that is already recorded. The allocation leaves the original bank posting in place.

Find the two entries

Open Payment Reconciliation. Select the Company, set Party Type to Customer, then choose the customer and receivable account. Select Get Unreconciled Entries, then compare the invoice and payment document numbers, dates and amounts.

See ERPNext Payment Reconciliation guide.

Control the allocation

Select the exact invoice and receipt and select Allocate. In Allocated Entries, check the proposed amount, adjust it if needed, and select Reconcile when the references match. Selecting the rows prevents the tool from allocating solely by date order.

Verify the remaining open amount

For a $1,200 invoice and a $450 receipt, applying all $450 leaves $750 open. Check that amount on the invoice or in Accounts Receivable, then retain the remittance and the reconciliation reference.

For help deciding which invoices to follow up, see Debitura’s accounts receivable guide.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.