Advance Accounts Payable During ERP Migration
When migrating from another accounting system to ERPNext, suppliers may already have advance payments that have not yet been adjusted against Purchase Invoices. ERPNext allows you to record these opening advances and later reconcile them automatically with supplier invoices using the Payment Reconciliation tool.
Recording supplier advances correctly during migration ensures that Accounts Payable reflects the actual outstanding balance and prevents duplicate liabilities.
1. Booking Opening Advance Payments
To record advance payments made to suppliers before your ERPNext go-live date:
- Create a Journal Entry.
- Select Entry Type = Opening Entry.
- Debit the Creditor (Payable) Account and select the respective Supplier.
- Credit the Temporary Opening Account.
- Expand the supplier row.
- Enable Is Advance.
- Save and Submit the Journal Entry.
Marking the entry as Is Advance tells ERPNext that this amount should be treated as an advance payment instead of an outstanding payable.
2. Effect on Accounts Payable
Once submitted:
- The advance appears as a negative balance in the Accounts Payable Summary.
- No Purchase Invoice is required at this stage.
- The supplier’s advance remains available for future reconciliation.
This accurately represents that money has already been paid to the supplier before receiving the invoice.
3. Creating the Purchase Invoice
When the supplier invoice is received later:
- Create the Purchase Invoice normally.
- Submit the invoice.
At this point, the Accounts Payable report will display:
- The Purchase Invoice as an outstanding payable.
- The Opening Journal Entry as an advance.
Since they are independent transactions, they will initially appear as separate entries.
4. Reconciling the Advance
Use the Payment Reconciliation tool to allocate the advance against the Purchase Invoice.
Go to:
Accounts > Payment Reconciliation
Then:
- Select Supplier as the Party Type.
- Select the Supplier.
- Fetch Unreconciled Entries.
- Select both the Purchase Invoice and the Opening Advance Journal Entry.
- Click Reconcile.
ERPNext will automatically allocate the advance against the Purchase Invoice.
Payment Reconciliation links the advance to the invoice without creating additional accounting entries, ensuring accurate outstanding balances.
5. Result After Reconciliation
After reconciliation:
- The Opening Advance Journal Entry is no longer shown as an outstanding advance.
- The Purchase Invoice reflects only the remaining unpaid amount (if any).
- If the advance fully covers the invoice, the outstanding balance becomes zero.
- Accounts Payable reports display the correct supplier balance.
6. Benefits
- Supports smooth migration from legacy accounting systems.
- Accurately records supplier advances before ERPNext go-live.
- Prevents duplicate liabilities.
- Maintains clean Accounts Payable reports.
- Allows future invoices to consume previously recorded advances.
- Works seamlessly with ERPNext’s Payment Reconciliation tool.
