Opening Invoice Creation Tool in ERPNext
The Opening Invoice Creation Tool in ERPNext is used to import outstanding Sales Invoices or Purchase Invoices into the system during implementation or data migration.
Unlike the Data Import Tool, this utility focuses only on outstanding balances, where item-level transaction details are not important and only receivables or payables need to be carried forward.
This tool is specifically designed for migrating opening balances of customers and suppliers without requiring full historical invoice data.
Access Path
You can access the Opening Invoice Creation Tool using the following path:
Home > Accounting > Opening and Closing > Opening Invoice Creation Tool
How to Import Opening Invoices
Follow these steps to import opening invoices into ERPNext:
- Select the Company for which you want to import opening balances.
- Select the Invoice Type:
- Sales Invoice – for customer receivables
- Purchase Invoice – for supplier payables
- Enable the “Create Missing Party” option if required.
This will automatically create new Customers or Suppliers if they do not already exist in the system. - Fill in the invoices table with required details.
Invoices Table Fields
The table includes the following important fields:
- Party – Customer or Supplier name. New parties can be auto-created if not existing.
- Posting Date – Date when the invoice will be recorded in ERPNext.
- Due Date – Date after which the invoice becomes overdue.
- Item Name (Optional) – Display item description in the invoice.
- Outstanding Amount – Pending amount to be recorded as receivable or payable.
- Invoice Number – Reference number from the previous system. If left blank, ERPNext will auto-generate it.
Tip for Faster Data Entry
You can download an Excel template using the Download button, fill in the required data offline, and then upload it back using the Upload option. The system will automatically populate the table with your data.
When to Use This Tool
This tool is most useful during:
- ERPNext implementation or migration
- Importing outstanding customer invoices
- Importing supplier payable balances
- Replacing legacy accounting systems
SUMMARY
The Opening Invoice Creation Tool helps organizations efficiently migrate outstanding Sales and Purchase Invoices into ERPNext. It simplifies data migration by focusing only on receivables and payables, reducing manual effort and ensuring accurate opening balance setup.
