Migrate from QuickBooks® Online

A direct QuickBooks Online connection is not available in shipped builds. Solid Accounting has a sign-in importer for QuickBooks® Online under File → Import → Online Accounting Sync…, but builds don't include the Intuit connection keys it needs. The dialog says so ("This build does not ship OAuth keys") and asks for a developer Client ID and Secret, which normal customers don't have. Until that changes, use the file-based route on this page.

Moving from QuickBooks Desktop instead? That route is fully supported — see Migrate from QuickBooks Desktop.

What works today

QuickBooks Online doesn't give you a company file to take away, so the move is a cutover: start clean in Solid Accounting on a date you choose, carry your balances across, and bring in activity from that date on.

1. Pick a cutover date. The end of a month, quarter, or year is easiest — ideally the end of your last filed tax year.
2. Save reports from QuickBooks Online as of that date: Trial Balance, Balance Sheet, Profit & Loss, A/R Aging Detail, and A/P Aging Detail. Also export your customer, vendor, and product/service lists. Keep these as your record of the old books.
3. Create your company in Solid Accounting (File → New Company…) and set up your chart of accounts to match the one in QuickBooks Online.
4. Enter opening balances with Company → Opening Balances…, using your QuickBooks Online Trial Balance for the cutover date. Opening balances go on balance sheet accounts; income and expense accounts don't take them, and the year's profit so far lands in Opening Balance Equity. That's why a year-end cutover date is easiest.
5. Add your customers, vendors, and items in Contacts and Items & Services. Re-enter open invoices and unpaid bills from the aging reports so you can receive and pay them in Solid Accounting.
6. Import bank and credit-card activity after the cutover with File → Import → Import Transactions…. It reads CSV, OFX, QFX, and IIF files and PDF statements. Download these from your bank, or export a register from QuickBooks Online to CSV.
7. Check your work. Run Reports → Trial Balance in Solid Accounting for the cutover date and compare it with the QuickBooks Online Trial Balance. Every balance sheet account should match.

Nothing on this route touches your QuickBooks Online account. Keep your Intuit subscription until you've downloaded everything you want to keep — once it lapses, Intuit limits access to your data.

What doesn't come across

• Transaction history before the cutover. Your opening balances carry the totals; the saved QuickBooks reports are your record of the detail.
• Payroll, time tracking, bank rules, recurring schedules, custom report layouts, and attachments. These belong to QuickBooks Online. Recreate recurring schedules as recurring transactions and bank rules in Banking → Categorization Rules.

Related

• Import Transactions and the CSV format
• OFX / QFX format
• Import & Export overview

Need help planning a cutover? Email support@solidaccounting.com.