Migrate from QuickBooks
Export your QuickBooks Online data, map it to Finance Operating System, and verify the migration.
Migrate from QuickBooks
Migrating off QuickBooks Online is a one-time job that takes most small businesses an afternoon. The output is your full historical books in Finance Operating System, with the same trial balance on the same date. This guide walks through the export, the import, and the verification.
What we migrate
We import: chart of accounts, customers and vendors, open invoices, open bills, all journal entries (so historical reports remain accurate), and bank account metadata. We do not import: payroll history (use Check's migration tool if you are bringing payroll over), attached PDFs (you can re-attach manually for the most important documents), or QuickBooks "Classes" (we use Projects instead — we will help you map them during the import).
Step 1: export from QuickBooks
In QuickBooks Online, go to Settings → Export data → Export everything. QuickBooks will email you a ZIP within an hour containing the data as Excel files. You can also export individual reports (chart of accounts, journal entries) as CSV on demand — we accept either format.
If you have access via the QuickBooks API and prefer that, you can use any of the standard tools to dump the data; just make sure your export includes the journal entries report for at least the date range you want to import, not only the summary reports.
Step 2: import wizard
From Settings → Import → QuickBooks, upload the ZIP. We will parse the contents and show you a preview of what we found: account counts, contact counts, transaction counts by type. Confirm the parse, and proceed to mapping.
The mapping screen has three sections:
- Account mapping. Each QuickBooks account is matched against your Finance Operating System chart by name. We pre-suggest a match; you can override or merge. If a QB account has no equivalent, choose Create new to auto-add it to your chart.
- Contact mapping. Same idea, but rare to override — contact names are usually unique.
- Classes → Projects. If you use QB classes, map each one to a Finance Operating System project (or skip).
Click Run import. The import streams in chunks; you can leave the page and we will email you when it is done. For a year of data on a busy business, expect 5–15 minutes.
Step 3: verify
Once the import finishes, open Reports → Trial balance in Finance Operating System and Reports → Trial Balance in QuickBooks for the same date — usually the last day before the migration cutover. Compare line by line. The two should agree to the cent.
If they do not, the most common cause is timing: ensure your QuickBooks export was captured after the same set of transactions as the import. The second most common cause is a category that did not get mapped — re-run the mapping step and re-import. Each import run is fully reversible: from Settings → Import → History, click Undo on the most recent run.
After cutover
Cancel your QuickBooks subscription, download a final ZIP for safekeeping, and disconnect any third-party tools that were pointed at the QB API. Re-point them at the Finance Operating System API — most flows have direct equivalents documented in our API reference.

