Importing Transactions and Opening Balances

The History Question

Ask yourself honestly: do you really need five years of transaction history in ERPNext?

Recommended Approach

Import Opening Balances as of a specific date (typically January 1 or your fiscal year start), then only detailed transactions for the current year. Keep QuickBooks as a read-only archive for historical data.

This gives you clean books going forward without wrestling with years of legacy data migration.

Opening Balances

Go to Accounting → Opening Invoice Creation Tool (for outstanding invoices) or Journal Entry (for General Ledger balances).

Accounts Receivable

Import all unpaid invoices as Opening Sales Invoices. This ensures you can receive payments against them later.

Accounts Payable

Import all unpaid bills as Opening Purchase Invoices. This ensures you can make payments against them later.

Historical Invoices (If You Must)

If compliance or audit requirements force full history migration:

Use the Sales Invoice Data Import template. Set status to “Draft.” Verify it and make them Submitted.

Critical

You must import linked Payment Entries immediately after, or your customer balances will show amounts owed that were already paid. This is exactly the kind of linked-transaction problem where the Data Import Tool gets unreliable. Budget significant time for reconciliation, or consider API migration.