Converting Between QuickBooks and NetSuite: What to Check First
Last reviewed 2026-11-21
A move between QuickBooks and NetSuite carries more than lists. It carries the condition of the books: any damage in the file, every unreconciled account, every open item from years past. Whatever the direction, the source data sets the ceiling on how clean the destination can be. This page walks through the checks that matter before either move, and the decisions that have to be settled before a single record is extracted.
Why check the file before anything moves?
Conversion tooling reads whatever is in the source file. Damage does not stay behind during a conversion; it surfaces as missing names, truncated transactions, or balances that no longer foot. A file can limp along in daily use while quietly carrying problems that only appear under extraction.
Run the built-in verification on the QuickBooks file first, and let the rebuild utility attempt whatever repairs it reports. A file that still fails verification is a risk to convert.
Reconciliation status is the other quick health signal. Bank, credit card, loan, A/R, A/P, and sales tax accounts that reconcile cleanly through a recent date give the conversion a verified set of balances to start from. Unreconciled accounts are not neutral: the destination system will treat their balances as fact.
What has to move?
Four groups of data make up nearly every conversion of this kind:
- Lists: the chart of accounts, customers, vendors, other names, and items.
- Open items: unpaid invoices, bills, credit memos, and purchase orders still live at the cut-over date.
- Balances: every account total as of that date, plus the open balance of each customer and vendor.
- History, if wanted: transaction detail going back a chosen number of years.
History depth is the choice with real trade-offs. Full history keeps reporting continuity in the new system, but it carries every old mistake and dormant record along with it. A balances-forward start keeps the destination lean, with the source file kept as a read-only archive for anything older.
Decisions that belong to you and your accountant
The cut-over date. A fiscal year end is the cleanest point; a quarter or month end is common. Everything before it becomes history or opening balances. Everything after it gets entered in the new system only.
The chart of accounts. Redesigning it in the middle of the move invites mismapping. Rename and consolidate before or after the conversion, not during.
Subsidiary structure. One QuickBooks file maps naturally to one company. Multiple files can stay separate or combine under a parent, and that choice shapes the chart, currency handling, and reporting from day one.
History depth and currency belong on the same list. If the QuickBooks file uses multicurrency, that fact needs to be on the table early, because it changes the whole mapping.
Gather these before the first export
Assemble the paper trail in the source system first:
- A trial balance and general ledger detail through the intended cut-over date.
- A/R and A/P aging detail at that same date.
- Reconciliation reports for every bank, credit card, and loan account.
- An inventory valuation summary, if the file tracks inventory.
- Sales tax payable detail by agency.
- A verified backup of the company file, kept read-only.
Then do the housekeeping. Apply or write off stale credits and ancient open items with the accountant's sign-off. Clear anything stranded in undeposited funds. Fix negative quantity-on-hand figures before the valuation snapshot is taken.
The traps that surface most often
Opening balances that do not tie. Every account total in the destination must foot to the source trial balance at the cut-over date. Customer and vendor open balances must foot to the A/R and A/P control accounts. When they do not, the two systems disagree from the first report and users stop trusting both.
Open items settled twice. A payment recorded in the old system after cut-over, then again in the new one, doubles the cash applied and resurrects an invoice that was already paid. Agree a hard date after which nothing gets entered in the source.
Sales tax built differently. QuickBooks attaches taxable status to items and customers and reports by agency. NetSuite works from tax codes tied to where you sell. The mapping between the two is where wrong rates and wrong payables are born, so it deserves explicit attention rather than a default.
Inventory valuation. Average cost, assembly items, and any negative on-hand quantity that has corrupted an average cost will not translate mechanically. The item-by-item valuation in the new system has to be compared against the source summary before anyone ships a product.
How do you check the converted books?
Three comparisons catch most of it, all made at the cut-over date:
- Trial balance, line by line, source against destination.
- A/R and A/P aging in detail, invoice by invoice, not just the totals.
- Inventory valuation summary, item by item.
Then reconcile one bank account in the new system against the same statement used in the old one. If those four checks pass, the data landed. It is worth closing one full month in the new system before retiring the old one, so the first real close is not also the first test.
Does the direction of the move change the checks?
The checks do not change; the constraints do. Moving to NetSuite, the destination supports structures QuickBooks does not have, and the chart has to be designed up to them. Moving to QuickBooks, the reverse applies: some NetSuite structures have no Desktop equivalent, and the chart usually has to be simplified rather than expanded. In both directions, the source decides the ceiling, which is why the health checks come first.
The practical starting point is small. Agree the cut-over date with your accountant, verify and back up the source file, and reconcile every balance sheet account through that date. Those three steps settle most of what a conversion needs before any data moves.
Planning a NetSuite and QuickBooks conversion?
We convert accounting data in both directions -- NetSuite to QuickBooks Desktop or Online, and QuickBooks to NetSuite, and check the converted books against the source before handover. Tell us which system you are on, how many years of history you need, and any deadline. Contact us for a free evaluation, or read about our NetSuite to QuickBooks and QuickBooks to NetSuite conversion services.
NetSuite and Oracle are registered trademarks of Oracle and/or its affiliates. QuickBooks is a registered trademark of Intuit Inc. This page is not affiliated with, sponsored by, or approved by Oracle or Intuit.