Migration · QuickBooks Online

Leaving QuickBooks Online without losing the numbers

QuickBooks Online has a real API, which makes the extraction straightforward and the mapping the hard part. Most of the work in this conversion is deciding what your chart of accounts should have been — and proving, period by period, that what we loaded agrees with what you filed.

Get a fixed migration quote

Company size, entity count, and what is in the file. We come back with a scope, a price, and a timeline.

1 / 3
Typically 3–4 weeksRead-only until cutoverPer-period variance report

The mapping

AI proposes it. A person approves every row.

The agent reads your posted history to infer what each account is actually used for, then proposes a target structure. Anything it cannot justify is held rather than guessed.

source chart of accountsproposed target · you approve every row6100 · Advertising6100 · Advertisingexact6110 · Ads - Google6100 · Advertisingmerged6115 · Ads – FB6100 · Advertisingmerged6200 · Contract labor6200 · SubcontractorsrenamedMisc expenseheld for reviewreviewAsk My Accountantheld for reviewreviewAI proposes the mapping · a human approves it · nothing loads unapproved

QuickBooks quirks

Six things we find in almost every file.

None of these are QuickBooks failing. They are what happens when a system is used for eight years by a growing business — and they are the things a generic conversion carries across unexamined.

Ask My Accountant

Almost every file has one, and it is usually holding transactions nobody resolved. We surface the balance and its contents rather than carrying it across as a mystery account.

Duplicated name lists

QuickBooks lets a company exist as a customer and a vendor with different spellings. We match on tax ID, remit-to, and history, and hand you the ambiguous ones.

Classes doing three jobs

Classes often encode department, location, and entity at once because there was nowhere else to put them. Splitting that into real dimensions is the highest-value part of the conversion.

Undeposited funds

A frequent source of cash variance. We reconcile the balance and its constituent receipts before anything loads rather than after.

Fixed assets in a spreadsheet

QuickBooks has no real fixed-asset subledger, so the schedule usually lives outside it. We bring the schedule in with cost, accumulated depreciation, method, and remaining life.

Closed periods with a password

A closing date password is not the same as a locked period. We check whether prior periods actually changed after closing, which is a conversation worth having before conversion.

Extractread source, no writesMapaccounts, customers, vendorsLoadinto a staged tenantReconciletrial balance, per periodgate · must tieReviewyour controller signsCut oversource goes read-onlygate · must tievariance → back to mapping, never waivednothing advances past a gate until the trial balance agrees to the penny

Timeline and price

A single-entity QuickBooks Online conversion with two years of history runs three to four weeks from kickoff to cutover and is priced at $18,000. Multi-entity conversions with intercompany history start at $45,000 and take six to ten weeks depending on how the entities have been kept.

The distribution of effort surprises people. Extraction is a few days — the API is good. Mapping and review take about half the elapsed time, because they require decisions from your controller rather than work from us. Reconciliation takes the rest, and it is the part we will not compress.

Week by week

  • Week 1. Connect read-only, extract, and produce the proposed mapping with everything ambiguous flagged. You get a first variance report on day four, which is usually the moment people realise how much is in Ask My Accountant.
  • Week 2. Mapping review with your controller. This is a working session, not a document review — the class-to-dimension decisions made here determine what your reporting can do for the next five years.
  • Week 3. Load into a staged tenant, reconcile every period, resolve variances, reload. Usually two or three cycles.
  • Week 4. Sign-off against the variance report, cutover at period end, first close in the new system with the old one still available read-only.
The API takes days. The decisions take weeks. Any quote that inverts that has not accounted for your controller’s calendar.

What makes it faster or slower

Faster: one entity, a chart of accounts under 200 lines, classes used consistently, and a controller who can commit half a day a week. Slower: multiple company files that need consolidating, heavy use of sub-customers as a project workaround, inventory tracked in QuickBooks, and payroll history that needs to reconcile to filed returns.

The single biggest variable is not data volume. It is whether the chart of accounts has been maintained or accumulated. A 900-line chart where half the accounts have not been posted to since 2021 is more work than ten times the transaction volume on a clean one.

If you are on Connect already

The shadow ledger has been reconciling against this QuickBooks file daily for months, so most of this work is already done and evidenced. Cutover in that case is a $6,000 engagement and about a week, because the reconciliation gate has been passing continuously rather than needing to be established.

Questions

What QuickBooks customers ask.

Will our QuickBooks data be modified?
No. The connection is read-only for the entire conversion. We never write to your QuickBooks file, and you can revoke access at any point without affecting your books.
How much history comes across?
Opening balances plus one to two years of transactional detail as standard. Keep QuickBooks read-only for prior years — it costs almost nothing and it is what your auditor will want.
What about payroll?
Payroll history comes across as summarised journal entries reconciled to your filed returns, and ongoing payroll continues in Gusto, Rippling, ADP, or whoever you use today, mapped into the ledger. We do not migrate a payroll engine.
Can you consolidate several QuickBooks files?
Yes, and it is one of the most common reasons companies leave. Each file becomes an entity, intercompany balances are identified and eliminated, and you get consolidated statements that do not live in a spreadsheet.
What if we find a problem after cutover?
The old file is still there read-only, the variance report shows exactly what was loaded, and corrections are made as dated adjusting entries in the new system rather than by reloading data. That is the same process your accountant would follow for any post-close correction.

See the mapping before you commit.

A read-only connection produces a proposed chart of accounts and a first variance report inside a week.