All migration guides

Migration guide

Migrate from QuickBooks Online.

Export your chart of accounts, trial balance, vendors, customers, and bank data from QuickBooks Online. Most migrations complete in under 2 hours.

Enterprise migration support

Enterprise customers get free migration support. We'll do the heavy lifting for you — chart of accounts mapping, opening balance import, and 30-day parallel-run support.

Contact us

Before you start.

  • Close all accounting periods through your planned cutover date (ideally a month-end).
  • Reconcile all bank and credit card accounts through the cutover date.
  • Ensure you have Administrator access in QuickBooks Online.
  • Note your fiscal year start month (Settings > Company > Fiscal year).
  • Decide on a cutover date. We recommend the last day of a month (e.g., March 31).

Step 1

Export your data from QuickBooks Online.

a.

Chart of Accounts

Navigate to:
Reports > search "Account List" (or Bookkeeping > Chart of Accounts > Run Report)
Export:
Click the Export button (top-right) > Export to Excel
Format:
XLSX (Excel). Re-save as CSV if needed.

The Account List report includes account type, detail type, and balance columns. This is more complete than the Chart of Accounts page export.

b.

Trial Balance (Opening Balances)

Navigate to:
Reports > search "Trial Balance"
Export:
Set the "As of" date to your cutover date, then click Export > Export to Excel
Format:
XLSX

This is your opening balance sheet for Quoining. Make sure the As-of date is set correctly before exporting.

c.

Vendor List

Navigate to:
Reports > search "Vendor Contact List"
Export:
Click Export > Export to Excel
Format:
XLSX
d.

Open Bills (AP Aging)

Navigate to:
Reports > search "Accounts Payable Aging Detail"
Export:
Set the "As of" date to your cutover date, then Export to Excel
Format:
XLSX

This shows all unpaid vendor bills as of the cutover date. You'll re-enter these in Quoining to establish your starting AP balance.

e.

Customer List

Navigate to:
Reports > search "Customer Contact List"
Export:
Click Export > Export to Excel
Format:
XLSX
f.

Open Invoices (AR Aging)

Navigate to:
Reports > search "Accounts Receivable Aging Detail"
Export:
Set the "As of" date to your cutover date, then Export to Excel
Format:
XLSX

This shows all unpaid customer invoices as of the cutover date. Re-enter these in Quoining to establish your starting AR balance.

g.

Bank Transactions (optional)

Navigate to:
Reports > search "Transaction Detail by Account" > filter to your bank account
Export:
Set the date range for the current fiscal year, then Export to Excel
Format:
XLSX

For historical transaction data. Alternatively, download bank statements directly from your bank in CSV or OFX format and import them into Quoining.

h.

General Ledger Detail (optional)

Navigate to:
Reports > search "General Ledger"
Export:
Set the date range, then Export to Excel
Format:
XLSX

For full GL history. Large reports may time out in QBO. If this happens, export in smaller date ranges (quarterly) and combine the files.

Watch out for

Common gotchas.

  • QuickBooks Online exports XLSX (Excel) only — not CSV directly. You may need to re-save as CSV for Quoining's import tool.
  • Large General Ledger reports can time out in the browser. Export in quarterly chunks if needed.
  • QBO Online does NOT support IIF file export. That format is only available in QuickBooks Desktop.
  • The default "As of" date on reports is usually today. Always verify you've set it to your cutover date before exporting.
  • If you use classes or locations in QBO, export the Profit & Loss by Class report separately to map them to Quoining's departments or custom fields.

Step 2

Import into Quoining.

01

Sign up and complete onboarding

Enter your company name, create your entities, and set your fiscal year start month. Choose your chart of accounts or upload the one you exported.

02

Enter opening balances

Use the Opening Balance Wizard to enter your trial balance as of the cutover date. Each GL account gets a debit or credit entry that matches your source system's balance sheet.

03

Import vendors and customers

Use Settings > Data Import to upload your vendor and customer lists as CSV files. Quoining maps the columns automatically.

04

Re-enter open AP and AR

Enter any open (unpaid) bills and invoices as of the cutover date. This establishes your starting AP and AR aging. You can also use the AI Accountant to create these from your exported aging reports.

05

Connect your bank accounts

Connect via Plaid for automatic transaction sync, or import bank statements as CSV/OFX files. SmartGL will categorize transactions using Claude and present them for your review.

06

Run your first reconciliation

Reconcile each bank and credit card account through the cutover date. The GL-based reconciliation matches your bank statement against posted journal entries.

07

Compare financial statements

Run a Balance Sheet and Income Statement in Quoining as of the cutover date and compare them to your source system. They should match. If they don't, check the Opening Balance Wizard for discrepancies.

08

Go live

Once your trial balance matches, you're live. Start categorizing new transactions, entering bills and invoices, and running your monthly close in Quoining.

Frequently asked.

Ready to migrate?

Start free. No credit card required. Enterprise customers get free migration support.