How to Migrate from QuickBooks Online to Zera Books
A step by step playbook for moving your books off QuickBooks Online. Export, import, categorize, reconcile, and run your first P&L the same day. Built for business owners and the accountants who serve them.
TL;DR
Migrating from QuickBooks Online to Zera Books takes about 90 minutes. Export your COA, transactions, and trial balance from QBO, drop them into Zera Books, upload 12 months of bank statement PDFs, and let the AI categorize at 99.6% accuracy across 3.2M+ documents processed. You run a P&L the same day. Cost is $79 per month flat, no per user fees, with a 1 week trial and no credit card.
By Damin Mutti, founder of Zera Books. Last reviewed 2026-05-20.
Why switch from QuickBooks Online
Three forces push most QBO customers to evaluate alternatives in 2026: price creep, the desktop sunset, and the AI gap. Intuit raised QuickBooks Online Plus from $25 per month in 2019 to $99 per month in 2026, a 296% increase in seven years. The same period the document workflow has barely changed. QBO still cannot read a bank statement PDF on its own. You either re key transactions or pay $25 to $80 per month for an add on like Hubdoc or Dext.
Annual cost: typical QBO stack
- QBO Plus base
- $1,188
- Hubdoc or Dext
- $600
- QBO Payments processing premium
- $480
- Bookkeeping cleanup hours
- $1,200
- Total
- $3,468 / year
Annual cost: Zera Books
- Flat subscription
- $948
- Document processing
- Included
- Categorization AI
- Included
- Cleanup time
- ~80% lower
- Annual savings
- $2,520+
QBO pricing pulled from Intuit's official pricing page on 2026-05-20.
Pre flight checklist
Gather these before you start. Allow 15 minutes for prep. The migration itself will not move forward if any of these are missing.
- Admin access to your QuickBooks Online file (must be the Master Admin role)
- A current chart of accounts export (Reports → Account List → Export to Excel)
- A trial balance as of your chosen cutover date
- The last reconciled bank and credit card statement for every connected account
- 12 months of bank statement PDFs downloaded from each bank portal
- Login credentials for any third party app you want to reconnect (Stripe, Gusto, Shopify, etc.)
- A list of recurring transactions and their schedules from QBO
- A backup of your QBO file (Settings → Export Data → All Time Data)
Step by step migration
Eight steps. Eighty to ninety minutes. Each step has an estimated time so you can pace the work between meetings.
Export your chart of accounts from QuickBooks Online
5 minIn QBO, open Reports, run the Account List report, and export to CSV. Save it as zera-coa-import.csv. This becomes the seed for your new ledger. If your COA has more than 200 lines, this is the time to trim it. Old inactive accounts will only slow down categorization later.
Export 12 months of transactions plus a trial balance
10 minRun a transaction list by date for the last fiscal year and a trial balance as of your cutover date. Export both as CSV and PDF. The PDF is your audit copy. The CSV is the data Zera will reconcile against.
Sign up for Zera Books and import the COA
2 minCreate a Zera Books account at zerabooks.com/auth. The first onboarding screen asks for your COA file. Drop in the QBO export. Zera maps QBO account types to its 5 type model automatically. You will see the full new COA in under 30 seconds.
Upload bank statement PDFs
15 minSkip re exporting transactions from QBO. Drag the original PDF bank statements (one per account, last 12 months) into Zera. The AI extracts every transaction at 99.6% accuracy. No template setup. No CSV reformatting.
Review and approve AI categorization
20 minZera batch categorizes against your imported COA. Approve the first batch one click at a time. By batch two the AI has learned your vendor patterns and 95% of transactions auto match. This is the only step that scales with transaction volume.
Reconcile and verify trial balance
20 minOpen the reconciliation panel. Each account ties to its bank statement ending balance. Compare the Zera trial balance to your QBO trial balance. They should match to the cent if the prior books were clean. If a number is off, it means QBO had an unreconciled item, and the variance report will name it.
Set opening balances and lock prior periods
5 minApply the QBO trial balance as opening balances at the cutover date. Lock all periods prior to cutover. This freezes the historical numbers so nothing back dates into them by accident.
Keep QBO read only for 30 days, then cancel
5 minDo not cancel QuickBooks Online on day one. Run parallel for 30 days. Reconcile the same month in both systems. Once three statements match, downgrade to the cheapest QBO tier as a read only archive or export everything and cancel. See the official QBO cancellation help for the exact path.
Need the official QBO cancellation steps? See Intuit's cancellation help article and the IRS recordkeeping guidance for your archive retention period.
QuickBooks Online to Zera Books data mapping
Every QBO field has a home in Zera. Some map one to one. A few rebuild during cutover. This table is the reference your accountant will ask for.
| QuickBooks Online | Zera Books equivalent |
|---|---|
| Chart of Accounts (.QBO export) | COA import wizard, 5 type model |
| Account Types (Income, COGS, Expense, etc.) | Asset, Liability, Equity, Income, Expense (mapped automatically) |
| Sub accounts | Parent and child accounts, unlimited depth |
| Vendors | Vendors module with vendor aliases for AI matching |
| Customers | Customers module with AR sub ledger |
| Products and Services | Items table, linked to invoices and bills |
| Invoices | invoices and invoice_lines tables, AR aging native |
| Bills | bills and bill_lines tables, AP aging native |
| Bank Transactions | Uploaded statements, AI extracted, then posted |
| Manual Journal Entries | journal_entries and journal_entry_lines (double entry enforced) |
| Trial Balance | Opening balances on the cutover date |
| Bank Reconciliations | Re reconciled in Zera (about 20 min per account) |
| P&L by Class | Class tagging on every transaction, native P&L by Class report |
| Departments and Locations | Departments table, Location tagging on entries |
| Recurring Transactions | Recurring engine, rebuild from QBO list (about 5 min each) |
| Attachments | Original PDFs stored alongside extracted transactions |
| Audit Log | Full immutable audit log from cutover date forward |
| Payroll Journal Entries | Gusto and ADP push directly to Zera, same as QBO |
| Sales Tax Liability | Sales tax tracking on invoices and bills |
| Bank Feeds | Plaid integration, OAuth in 5 minutes per institution |
| Reports (P&L, BS, Cash Flow) | Built in plus AI insight commentary on every report |
What carries over and what does not
Honest answer first. Most data migrates cleanly. A few items rebuild during cutover. None of it is destructive.
Carries over cleanly
- Chart of accounts (structure, types, sub accounts)
- Trial balance as opening balances
- Vendors and customers
- Products and services (mapped to items)
- Open invoices and bills (re entered at cutover date)
- Class and Location tagging
- Sales tax rates and codes
- Recurring transaction schedules (manually rebuilt from QBO list)
Rebuilds in Zera
- Historical bank reconciliations (about 20 min per account)
- QBO attachments (download separately, retain as archive)
- The QBO audit log (Zera starts a fresh log on day one)
- Third party app connections (OAuth reconnect, 5 min each)
- Bank feeds (Plaid reconnect, 5 min per institution)
- User access roles (re invite team to Zera)
Common pitfalls during QuickBooks Online migration
Six things I see trip people up. None of them are deal breakers, but each one wastes 20 to 60 minutes if you hit it cold.
Stale inactive accounts
A 12 year old QBO file usually has 80 to 200 inactive accounts cluttering the COA. Mark them inactive in QBO before exporting. Zera will only import active accounts unless you tell it otherwise.
Class and Location tagging gaps
QBO lets you create transactions with no class even when class tracking is on. Run a transactions without classes report in QBO and fix gaps before cutover. Otherwise your class P&L in Zera will look off.
Open invoices with future dates
Invoices dated after the cutover need to be re entered in Zera, not imported as historical. The trial balance includes their AR balance, but the document itself lives in the new system.
Bank feed duplication
If you reconnect Plaid to Zera while QBO still has the same feed active, you get double counted transactions during overlap. Disconnect bank feeds in QBO on cutover day. The PDF upload covers prior history.
Sales tax rate changes mid period
If a state changed sales tax rates between your last QBO filing and your cutover, re verify the rate inside Zera before issuing new invoices. The IRS, AICPA, and most state revenue sites publish current rates monthly.
Forgetting to download attachments
QBO attachments do not migrate. Bulk download every attached document from the QBO Attachments page before you cancel. Zera will store new PDFs from day one, but the QBO archive is yours to keep.
Reference: AICPA accounting software evaluation guidance recommends a 30 day parallel run after any GL migration.
What changes day to day after switching
You will notice four big workflow shifts in the first week. None of them require training. Most teams stop opening QBO entirely after week two.
Document upload replaces re keying
Drop the PDF. The AI extracts and categorizes. No more typing transactions from a paper or scanned statement.
Batch categorization replaces one by one review
You approve categorizations in batches of 50 to 200 transactions, not one transaction at a time like the QBO For Review tab.
One platform for accountants and owners
Your accountant sees the same data you see. No more QuickBooks Online Accountant separate from QBO. One login, one ledger.
AI insight commentary on every report
P&L and balance sheet reports include a written AI narrative on what changed month over month. That alone has replaced the 30 minute prep call most firms used to do before sending statements to clients.
“I migrated our retail business off QuickBooks Online on a Saturday afternoon. By Monday morning the books were caught up cleaner than they had been in two years. The AI categorized 14 months of bank statements in under 30 minutes. I never wrote a single rule.”
QuickBooks Online migration FAQ
- How long does it take to migrate from QuickBooks Online to Zera Books?
- A single entity migration takes 60 to 90 minutes of active work. The exports run in 5 minutes, the COA import takes 30 seconds, statement upload and AI categorization runs 20 to 40 minutes, and reconciliation takes about 20 minutes per bank account. A 25 client firm typically migrates in one working day.
- Will I lose any data when I move from QuickBooks Online to Zera Books?
- No transaction data is lost if you follow the export checklist. Chart of accounts, vendors, customers, journal entries, and trial balance all migrate cleanly. What does not import are QBO bank reconciliation flags, attachment files, and the audit log. Reconciliations get rebuilt in Zera in about 20 minutes per account.
- Do I need to cancel QuickBooks Online before starting?
- No. Keep QBO running for 30 days after cutover as a read only reference. Cancel only after three reconciliation cycles match in Zera. Intuit offers a 30 day refund window, so timing the cancellation to your billing date avoids a wasted month.
- Can I migrate mid year or do I need to wait for January?
- Mid year works fine. Pick the first day of any month as cutover. Apply the QBO trial balance as of that date as your opening balances in Zera. Year to date P&L data stays in QBO for the prior period and continues in Zera from the cutover forward. Most teams switch in May or October to avoid year end stress.
- What happens to my QuickBooks Online integrations and apps?
- You will need to reconnect third party apps to Zera Books. Stripe, Shopify, and bank feeds reconnect via OAuth in 5 minutes each. Payroll providers like Gusto and ADP push journal entries to Zera the same way they pushed to QBO. Specialty QBO only apps need a CSV bridge or replacement.
- Is Zera Books cheaper than QuickBooks Online over a year?
- Yes for almost every configuration. Zera Books is $79 per month flat, totaling $948 per year. QuickBooks Online Plus is $99 per month base for 5 users which is $1,188 per year, before payroll, payments, or Hubdoc add ons. A typical small business pays $2,400 to $4,800 per year on the full QBO stack versus $948 on Zera Books.
- How does Zera Books handle my QuickBooks Online historical reports?
- Export historical P&L, balance sheet, and general ledger reports from QBO as PDF and CSV before you cancel. Store them as part of your year end binder. Zera retains all post cutover transactions and runs the same reports natively from day one forward.
- What if I have multiple QuickBooks Online companies?
- Zera Books treats each entity as a client in the multi client dashboard. Repeat the migration process per entity. The COA template carries forward, so the second and third entities take 30 minutes each instead of 90.
- Can my accountant still work with me if I leave QuickBooks Online?
- Yes. Zera Books exports clean QBO and IIF formats. If your accountant insists on QuickBooks, they can import your Zera journal entries into a QBO file at year end. Most accountants prefer Zera once they see the AI pre categorization because it cuts cleanup time in half.
- Does the IRS care if I switch accounting software mid year?
- No. The IRS requires books that accurately reflect income and expenses under IRC Section 446. Switching platforms is allowed as long as the new system maintains continuity and you retain the prior platform records for the standard 3 to 7 year retention period.
- What support do I get during the QuickBooks migration?
- Founder support. Damin Mutti personally helps with migrations during the 1 week trial. Average reply time is 1 hour. Schedule a 30 minute migration walkthrough through the in app chat after you upload your first COA.
- Will my year over year comparisons still work after migrating?
- Yes, with one extra step. Import the prior year P&L as a comparison budget into Zera. Once both years live in Zera, year over year comparisons run natively. Most teams backfill 13 months of prior data to get a clean rolling comparison from month one.
Related migration and comparison guides
If QuickBooks Online is not the only platform you are evaluating, these guides cover the rest of the field. Start with the QuickBooks alternative pillar guide for the full landscape.
Start your migration today
Sign up, upload your QuickBooks Online COA, and watch the new ledger build itself. One week trial, no credit card. Migration done before your next coffee.