Migrating from QuickBooks to ERPNext means exporting your lists and balances from QuickBooks, importing them into ERPNext, and starting new transactions from a clean cut-over date. Most of the work is data preparation. In India there is a twist: QuickBooks closed there in 2023, so your source may be the exports you took then, or your accountant's records.
Intuit withdrew QuickBooks from India: subscriber access ended on 30 April 2023, and from 1 July 2023 there has been no access to QuickBooks products in India. Outside India, QuickBooks Desktop is being wound down version by version. Either way, many businesses need a new home for their books. ERPNext is open source, handles Indian GST through the India Compliance app, and puts accounts, stock and operations in one system with no licence fee.
The migration is a careful data exercise: export cleanly, map your ledgers, import opening balances, check on a test site, then cut over. I lead ERPNext and Frappe implementations at MithTech, a team of Frappe specialists in Bengaluru, and this is the order we follow on a QuickBooks to ERPNext migration. The longer a QuickBooks chart of accounts has drifted with ad hoc adjustments, the more the preparation pays off: trimming it before you start saves cleanup later.
How do I migrate from QuickBooks to ERPNext?
Five steps: export your QuickBooks data, prepare and map it, import masters and opening balances, check on a test site, and go live from a cut-over date. Each step can be repeated until the final cut-over, so your accountant can check the numbers before you commit.
- Export from QuickBooks. In QuickBooks Online, run the Account List, Customer Contact List, Vendor Contact List and Product/Service List reports, plus the Trial Balance and A/R and A/P ageing detail as on the cut-over date, and export each to Excel. In QuickBooks Desktop, export lists and the same reports to Excel.
- Prepare and map the data. Clean the exports, map QuickBooks accounts to the ERPNext chart of accounts, and remove duplicate ledgers.
- Import into ERPNext. Use Data Import (it reads Excel or CSV) to load accounts, customers, suppliers and items, then post opening balances with a Journal Entry and open invoices with the Opening Invoice Creation Tool.
- Check on a staging site. Reconcile the trial balance and party balances against QuickBooks. Fix mismatches before production.
- Go live from a cut-over date. Freeze new entries in QuickBooks and start all transactions in ERPNext from that date.
Skimmable summary: export, map, import masters and opening balances, check on staging, then go live from a cut-over date.
What data can I move from QuickBooks to ERPNext?
Master data and opening balances, not the entire transaction history. Masters are your chart of accounts, customers, suppliers and items. Opening balances are the closing figures from QuickBooks on your cut-over date. Past transactions stay in your QuickBooks exports as a read-only archive.
| Chart of accounts | Account List report | Yes | Data Import, mapped to ERPNext accounts |
| Customers & suppliers | Customer and Vendor Contact Lists | Yes | Data Import (Customer, Supplier) |
| Items / products | Product/Service List | Yes | Data Import (Item) |
| Opening balances | Trial Balance | Yes | Journal Entry |
| Outstanding invoices & bills | A/R and A/P ageing detail | Yes | Opening Invoice Creation Tool |
| Full transaction history | Reports | No (archive it) | Keep the QuickBooks exports |
Replaying years of transactions into a new system is slow and error-prone. Opening balances plus new transactions give accurate books from day one.
Skimmable summary: move masters and opening balances; keep the transaction history as an archived export.
What to export from QuickBooks before you map and import. If QuickBooks India closed before you exported, your accountant's records are the source.
See what QuickBooks's own export leaves behind.
What if QuickBooks India closed before I exported?
Then the source is what you and your accountant still hold: any exports or PDFs taken before 30 April 2023, the accountant's working files, bank statements, and the GST returns already filed on the GST portal. From those you rebuild the party lists and the balances as on a chosen date, then load them as opening balances in ERPNext. Your CA should sign off the opening trial balance before you go live.
Skimmable summary: without exports, rebuild opening balances from your accountant's records, bank statements and filed returns, and have your CA sign them off.
How long does a QuickBooks to ERPNext migration take?
It follows the data, not the software. Clean QuickBooks books with a tidy chart of accounts import quickly; a chart with duplicate or unused ledgers, missing exports or several companies takes longer. Most of the time is preparation: cleaning exports, mapping ledgers and checking the test import. The switch itself is short once that is done. To see what moves the cost, estimate your price. The same discipline for Tally users is in the Tally to ERPNext migration guide.
Skimmable summary: data quality, not the software, sets the timeline.
Will I lose my QuickBooks history after migrating?
No, as long as you keep the exports. Migrating moves masters and opening balances into ERPNext; your past reports stay in the files you exported.
Past audits and GST returns stay where they are: with your QuickBooks records and on the GST portal. ERPNext prepares return data from the first transaction after cut-over, so you carry nothing stale into the new system.
Skimmable summary: keep the QuickBooks exports as the archive; past filings stay on the GST portal.
How do I set up GST in ERPNext after moving from QuickBooks?
Install the open-source India Compliance app, enter your GSTIN, add HSN/SAC codes to items and set up tax templates during go-live. ERPNext then calculates CGST, SGST and IGST and, through the app, generates e-invoices with IRN and e-way bills through the government systems. The app is free; on a self-hosted site the e-invoice and e-way bill API calls use paid credits.
Do the GST setup as part of the migration: company GSTIN and state, HSN codes on the imported items, and tax templates before the first live invoice. For the recent GST changes, see my ERPNext GST 2026 readiness checklist.
Skimmable summary: set up GST through the India Compliance app (GSTIN, HSN codes, tax templates) before the first live invoice.
Frequently asked questions
+Can I import my QuickBooks data into ERPNext?
Yes. Export your chart of accounts, customers, suppliers, items and outstanding balances from QuickBooks to Excel, then import them with ERPNext's Data Import tool and the Opening Invoice Creation Tool. You import masters and opening balances, not every past transaction, and keep the QuickBooks exports as your archive.
+How long does it take to move from QuickBooks to ERPNext?
It depends on how clean the data is, how many companies you run and whether you still have full exports. Most of the time goes into preparation: cleaning exports, mapping ledgers and checking a test import on staging.
+Is ERPNext a good replacement for QuickBooks in India?
For most businesses, yes. ERPNext has full double-entry accounting and financial reports, Indian GST and e-invoicing through the India Compliance app, and stock and operations that QuickBooks did not cover. It is open source with no per-user fee, and because the code is open, it cannot be withdrawn from your market.
+What happens to my QuickBooks data now that it shut down in India?
Subscriber access ended on 30 April 2023, and there has been no access in India since 1 July 2023. If you exported before then, you hold your reports and history in those files. If you did not, rebuild opening balances from your accountant's records, bank statements and filed GST returns, and have your CA sign them off.
+Do I need outside help to migrate from QuickBooks to ERPNext?
Not always. A capable team can move a simple set of books with ERPNext's import tools. Many businesses bring in someone who has done it before, for ledger mapping, opening balances and GST setup. It depends on your internal capacity and how complete your QuickBooks data is.
Comments & ratings
No comments yet. Start a new discussion.
Manoj · Published on 8 July 2026
Worked with us? Leave a Google review