Hundred MSHome / Blog / QuickBooks to NetSuite migration
QuickBooks to NetSuite migration: a practical guide
Stuck on this in your own NetSuite?Bring it to a free 30-minute call with Narek. No pitch.
Book a callA QuickBooks to NetSuite migration has six steps: clean the QuickBooks data, design the NetSuite setup (chart of accounts, entities, segments), map every account and list and test a trial load, cut over at a month end with master records, opening balances and open transactions, reconcile every balance between the two systems, then run the first close in NetSuite. The reconciliation is the part that protects you, and it is the part most often skipped.
- Clean QuickBooks before you move anything.
- Redesign the chart of accounts. Do not copy it.
- Go live at a month end and reconcile every balance between the two systems.
When the move is worth it
QuickBooks is good software, and many companies leave it too early. The move makes sense when the work around QuickBooks has become bigger than the work in it:
- Several entities or currencies, consolidated by hand in spreadsheets.
- Revenue that has to be recognized over time, tracked outside the ledger.
- Inventory or order flows that live in a separate tool that never quite agrees.
- Approvals and controls your auditor or investors now expect.
- A close that gets slower every quarter because of manual steps between systems.
If none of these is true, a cleanup and a better process in QuickBooks may be the cheaper answer. We say so when we see it.
What moves, and what does not
| Data | Usual approach |
|---|---|
| Chart of accounts | Redesigned, not copied. This is the chance to fix years of clutter. |
| Customers, vendors, items | Cleaned, de-duplicated, then imported. |
| Opening balances | Loaded as of the cut-over date and tied to the QuickBooks trial balance. |
| Open invoices and bills | Loaded one by one so they can be paid and matched in NetSuite. |
| Transaction history | A choice: monthly balances for past years, or full detail for a year or two. Full history for everything is rarely worth the cost. |
| Attachments, memos, custom reports | Mostly do not move. QuickBooks is kept as a read-only archive. |
If you had to move tomorrow, which balances in QuickBooks would you not want to carry over as they are? That list is the first phase of the project.
The steps, in order
- Clean QuickBooks first. Reconcile bank accounts, clear suspense, fix old open items. Moving a mess gives you an expensive mess.
- Design the NetSuite setup. Entities, chart of accounts, departments, classes and locations, based on the reports you want to get out, with the accountants who will close in it in the room.
- Map and test. Every QuickBooks account and list mapped to its new home, then a trial load into a sandbox or test account.
- Cut over. Freeze QuickBooks at a month end. Load master data, opening balances and open transactions.
- Reconcile both systems. Trial balance, receivables and payables aging, bank balances and inventory: the same to the cent in both.
- Run the first close in NetSuite with the people who will own it, while QuickBooks is still there to look things up.
Before you sign with anyone, ask what they will hand you at go-live to prove the data arrived intact. The answer should be a reconciliation of every balance between the old system and the new one, account by account.
How long does it take?
It depends on the number of entities, how clean the QuickBooks data is, how much history you keep and how many integrations are involved. Be careful with anyone who quotes a timeline before seeing your data. Our own rule is a written scope and quote within two days of the first call, after we have looked at the file.
For a sense of what disciplined migration work looks like, we wrote up a multi-entity migration reconciled in 26 days. That project went in a different direction, from an enterprise ERP to QuickBooks Online. The method is the same: every balance tied between the two systems before anyone relies on the new one.
Where this goes wrong
| The problem | What it costs you | The fix |
|---|---|---|
| The old chart of accounts is copied as it is | Years of clutter arrive in the new system | Design the chart from the reports you want to get out |
| Go-live lands in the middle of a month | Cut-off errors that take weeks to untangle | Freeze QuickBooks at a month end |
| No reconciliation at go-live | Nobody trusts the opening numbers | Tie the trial balance, aging reports, bank and inventory to the cent |
We migrate clients onto NetSuite and close their books in it afterwards, so we live with the result.
Sources we opened and checked for this guide:
First published 2024. Rewritten and checked in September 2026. If something here is out of date, tell us and we will fix it.
