How to Switch from QuickBooks to simpleWhirks Books in Under an Hour

If you’ve decided to leave QuickBooks Online for simpleWhirks Books, the actual migration takes less time than most operators expect. The fear of losing data, breaking your CPA workflow, or ending up with two half-functioning bookkeeping systems is what stops most owner-operators from switching, not the technical difficulty.

This is the complete playbook. We co-wrote it because the migration touches two distinct concerns: the technical side (exports, imports, file formats, bank feeds, data integrity) and the accounting side (opening balances, trial balance, chart of accounts mapping, CPA continuity). Travis owns the first; Garrett owns the second. If you follow all 10 steps in order, you’ll be running on simpleWhirks Books, reconciled and ready for your next month-end, in about an hour.

The patterns we describe below are the ones our team encounters consistently when small-business owners migrate. The mistakes are predictable. The fix for almost every problem is doing the steps in the order we recommend, not reordering them.

A note on pricing and product details. This post cites QuickBooks Online plan prices and Intuit product policies at the time of writing. Intuit raises prices most years and adjusts product details periodically; verify on Intuit’s pricing page before relying on these numbers for a budget or migration plan.

Before you start: is this the right time to switch?#

The cleanest moments to switch bookkeeping software are the first day of a fiscal year, the first day of a new quarter, or immediately after an estimated tax filing. Mid-period switches are doable but harder because every report you run will span two systems.

Three situations should pause you:

You run payroll inside QuickBooks. Switch only at year-end. QuickBooks Payroll handles tax filings, W-2s, 1099s, and quarterly 941 forms; splitting those across two systems mid-year creates filing complications and possibly amended returns. Wait for December 31 and migrate payroll with everything else.

You’re more than two months behind on bookkeeping. Clean up first. Migrating messy books just moves the mess. Reconcile through the last completed month before you even start the export. This is the single biggest mistake we see.

You have an active audit or recent IRS notice. Don’t switch in the middle of an audit. The auditor wants to see records in the system they were created in. Resolve the audit, then migrate at the next quarter-end.

If none of those apply, the migration is a half-day project at most. Most home-based operators finish in under an hour.

What you need before starting#

Five things. Have them ready before you open QuickBooks:

1. Administrative access to your QuickBooks Online account (Master Admin or Company Admin role)
2. Bank statement covering your chosen transition date (the most recent statement that includes month-end is ideal)
3. Your most recent prior-year tax return (for verifying balance sheet equity)
4. A blank simpleWhirks Books account, created but not yet populated with data
5. About 60 to 90 uninterrupted minutes

Don’t try to do the migration in 15-minute chunks across a week. You’ll lose context between sessions. Block the time.

Phase 1: Prepare QuickBooks for migration#

Step 1: Reconcile QuickBooks through the last completed month#

Open QuickBooks Online. Navigate to Banking. For every bank account and credit card, confirm the reconciliation is complete through the end of the prior month. The reconciliation indicator (a small green check or “R” flag on transactions) should cover everything before your transition date.

If any account is unreconciled, reconcile it now. This is non-negotiable. Migrating with an unreconciled account guarantees opening balances won’t match in Books, and you’ll spend longer fixing that than reconciling cleanly in the first place.

Step 2: Pick your transition date#

Choose the last day of a completed month or quarter. April 30 (M4 close), June 30 (Q2 close), September 30 (Q3 close), and December 31 (year-end) are the cleanest. The transition date defines two things: the date your QuickBooks data ends, and the date your simpleWhirks Books opening balances begin (technically the day after).

The transition date should be at least a week in the past. Don’t pick today’s date. You want your bank statement for that period to be available and your books to be reconciled through it.

Step 3: Clean up uncategorized transactions#

Run a profit and loss report in QuickBooks for the year to date. Scroll to the bottom. If you see “Uncategorized Income” or “Uncategorized Expense” categories with any non-zero amount, click in and recategorize every transaction. Same for any “Ask My Accountant” or unspecified-category lines.

These categories don’t have a clean Books equivalent. If you import transactions sitting in “Uncategorized,” they’ll either fail the import or land in a placeholder category in Books that you’ll have to clean up by hand. Five minutes here saves an hour later.

Phase 2: Export data from QuickBooks#

Step 4: Export the chart of accounts to CSV#

In QuickBooks Online: Settings (gear icon) → Chart of Accounts → click the export icon (the small arrow above the list) → save as CSV.

Open the CSV in a spreadsheet and review it. Most home-based businesses have between 60 and 100 accounts in QuickBooks but only actually use 15 to 30. Note which accounts have activity (you can see this from the trial balance in the next step); the unused ones don’t need to migrate.

Step 5: Export customer and vendor lists#

Sales → Customers → click “Customer types” filter → All → Export to CSV.

Expenses → Vendors → Export to CSV.

Both files import cleanly into Books. Save them in a “QB Export” folder alongside the chart of accounts.

Step 6: Export the trial balance as of the transition date#

Reports → Trial Balance. Set the date to your transition date. Export to CSV.

This is the most important file in your migration. The trial balance shows every account in your chart of accounts with its current debit or credit balance as of that date. Those numbers become your opening balances in Books.

Open the trial balance and verify two things: (a) the total debits equal the total credits at the bottom (if they don’t, QuickBooks is broken and a CPA needs to look before you migrate), and (b) the bank account balances match what your bank statement says for that date. Discrepancies here are the second-most-common source of migration problems.

Step 7: Export the last 24 months of transactions#

Reports → Transaction Detail by Account. Set the date range to the prior 24 months. Export to CSV.

For most home-based businesses, this file is 200 to 1,200 rows. It contains the historical detail that gives Books reports comparison data after the migration. If you want only the current year (because prior years are tied up in already-filed tax returns), 12 months is acceptable. Two years is the sweet spot for most operators.

Phase 3: Import into simpleWhirks Books#

Step 8: Create your simpleWhirks Books workspace#

Sign up at books.simplewhirks.com. Complete the business profile setup: business name, EIN or SSN, fiscal year start, and a single primary bank account placeholder. Skip the “load sample data” prompt; you want a clean workspace before importing real data.

The workspace is ready for import as soon as the business profile saves.

Step 9: Run the data import wizard#

Settings → Data Import → Start QuickBooks Migration. Upload the five files from QuickBooks in order:

1. Chart of accounts CSV
2. Customer list CSV
3. Vendor list CSV
4. Trial balance CSV (this defines opening balances)
5. Transaction history CSV (24 months)

For the chart of accounts, the wizard will suggest a Books category for each QuickBooks category. Accept the suggestions that are obvious (QB “Office Supplies” maps to Books “Office Supplies”). For ambiguous ones (a custom QB category like “Marketing Software Subscription”), pick the closest Books category or create a new one. The wizard previews the mapping before committing.

The trial balance import is where the magic happens. Books creates opening balance journal entries based on the trial balance amounts, dated the day after your transition date. The total debits and credits in the resulting opening journal entry must equal each other and must equal what the QuickBooks trial balance showed. The wizard confirms this before saving.

The transaction history populates the prior 24 months of P&L comparison data. These transactions are imported as historical reference (locked, non-editable) so your year-over-year reports work from day one.

Step 10: Reconcile both systems against the same bank statement#

Pull the bank statement that covers your transition date. In QuickBooks, run a reconciliation against that statement (if you haven’t already). In Books, run a reconciliation against the same statement.

Both systems should show the same ending balance. If they don’t, something didn’t import correctly. The most common culprit is a single transaction in QuickBooks that crossed midnight on the transition date and is now in both periods. Find it, decide which side it belongs on, and remove it from the other.

Once the balances match, connect the simpleWhirks Books bank feed to your bank account. Turn off the QuickBooks bank feed for the same account. Both systems can’t pull from the same feed simultaneously; the duplicate transactions will cause problems.

After the migration: the 30-day sanity check#

For the first 30 days after the switch, keep QuickBooks active and parallel-run.

Every Friday afternoon, run a profit and loss report in both QuickBooks and Books for the period since the transition date. The two reports should show identical revenue, identical expenses, and identical net profit. They will. If they don’t, find the discrepancy that week, not in a month.

After 30 days of matching reports, you can confidently downgrade QuickBooks to Simple Start (Intuit’s cheapest paid tier) for one more month of read-only access, then cancel entirely. Before canceling, export PDF backups of: prior-year P&L, prior-year balance sheet, general ledger for the prior year, and the most recent three years of tax-return supporting documentation. Save them locally and in cloud storage.

Intuit retains your QuickBooks file for one year after cancellation, after which it’s deleted. Your locally saved PDFs are your only record of the QuickBooks history after that one-year window.

What doesn’t transfer (and how to recreate it)#

Five categories of data don’t migrate automatically through the CSV exports:

1. Recurring transaction templates. Books has its own recurring transaction setup. Recreate the 3 to 8 templates you actually use; the rest weren’t worth keeping.

2. Custom report layouts. Books reports have their own layouts. Standard reports (P&L, balance sheet, transaction detail, GL) are one-click in Books. If you had heavily customized reports in QuickBooks, this is the moment to ask whether you actually used them.

3. Attached receipts and PDFs. These are stored in QuickBooks but not exported by the CSV. If you need digital copies, download them individually before canceling QuickBooks. For most home-based operators, the bank statement plus the categorized transaction record is sufficient documentation; the receipts are belt-and-suspenders.

4. Third-party app integrations. Bill.com, payroll providers, time-tracking apps, e-commerce integrations all need to be reconfigured to point at Books instead of QuickBooks. Most major integrations support both.

5. Budget data. Recreate budgets fresh in Books if you actively use them. Many home-based operators don’t.

Recreating all five typically takes 20 to 30 minutes if you’re light, 1 to 2 hours if you had heavily customized QuickBooks. Plan accordingly.

How does a CPA fit into this?#

If your CPA actively uses your QuickBooks file (logging in regularly, not just at year-end), have one conversation with them before you switch.

The conversation has two parts:

Part 1, the practical question. Ask: “If I send you a clean P&L, balance sheet, and transaction list as CSVs every quarter, can you do my Schedule C from that without extra hours?” Most CPAs will say yes. A few are deeply embedded in QuickBooks workflows and will say no. For the no-CPAs, the cost of switching is the hourly difference in their bill. Do the math; it’s often still favorable.

Part 2, the structural question. Ask: “Is there anything specific to my QuickBooks setup (opening equity, retained earnings, specific account classifications) that I should preserve when I migrate?” Most home-based operators have nothing here. A few do. Catching it before the migration is much cheaper than fixing it after.

If your CPA has never seen your QuickBooks file outside of tax season, this conversation is optional. The exported reports tell them everything they need.

Common migration mistakes (don’t repeat these)#

Eight failure modes account for almost every migration that goes wrong:

1. Migrating without reconciling QuickBooks first. Books shows balances that don’t match the bank statement, and you spend three hours figuring out why. Reconcile first. Always.

2. Picking today as the transition date. The bank statement covering today doesn’t exist yet, and reconciliation requires it. Pick a date at least one week in the past, ideally a completed month-end.

3. Leaving uncategorized transactions in QuickBooks. They import as a placeholder category in Books and have to be re-categorized by hand. Clean up before exporting.

4. Skipping the parallel sanity check. Cancel QuickBooks immediately, then discover three weeks later that an account didn’t import correctly. Keep QuickBooks active for at least 30 days.

5. Forgetting to disconnect the QuickBooks bank feed. Both systems pull from the same feed and create duplicates in both. Disconnect QuickBooks the moment Books is connected.

6. Migrating mid-payroll-period. Quarterly 941 filings and year-end W-2s get split across two systems. If you run payroll inside QuickBooks, switch at year-end and only at year-end.

7. Not exporting PDF backups before canceling QuickBooks. Intuit holds your data for one year after cancellation, then deletes. Locally saved PDFs are your permanent record.

8. Trying to migrate five years of history. The exports work, but the value is low. Two years of history is plenty for comparison reports; prior years are in your filed tax returns and don’t need to live inside your bookkeeping software.

Frequently asked questions about switching from QuickBooks#

Will I lose any data switching from QuickBooks to simpleWhirks Books?#

Your core data (chart of accounts, customer list, vendor list, historical transactions, balances) transfers cleanly via standard CSV exports from QuickBooks Online. The pieces that don’t transfer automatically are: recurring transaction templates, custom report layouts, attached receipts and PDFs, third-party app integrations (Bill.com, payroll providers, time-tracking apps), and budget data. Recreating those takes about 20 minutes for a typical home-based business. Your historical QuickBooks file remains accessible through Intuit for at least one year after canceling, so you have a fallback if you need to look up an old invoice.

Do I have to clean up my QuickBooks file before switching?#

Yes, always. The single biggest migration mistake is exporting messy data into a new tool, which gives you messy data in a new tool plus the time you just spent migrating. Before you start the switch, reconcile QuickBooks through the last completed month, fix any uncategorized transactions, clear out any “Ask My Accountant” items, and confirm the opening balance equity matches what you expect. The cleanup typically takes 1 to 4 hours depending on how behind you are. Skipping it is what turns a one-hour migration into a five-hour ordeal.

When is the best time of year to switch bookkeeping software?#

The best moments are: (1) the start of a new fiscal year (January 1 for most small businesses), which lets you start with clean opening balances and a fresh chart of accounts; (2) the first day of a new quarter, which gives you clean quarter-end reports; or (3) immediately after an estimated tax filing (April 15, June 15, September 15, and January 15 of the following year, with weekend or holiday shifts as the IRS publishes), so the prior quarter’s numbers are already locked in. Avoid switching in the middle of a tax filing period or while you’re owed a refund. If you run payroll inside QuickBooks, only switch at year-end so payroll tax filings and W-2s aren’t fragmented across two systems.

What happens to my QuickBooks subscription when I switch?#

Keep your QuickBooks subscription active for at least one full month after the switch, ideally three. The first month is a sanity check: run reports in both systems and confirm the numbers match. After that, you can downgrade to QuickBooks’ lowest tier (Simple Start, currently Intuit’s cheapest paid plan) for read-only access to historical data, or cancel entirely. Once you cancel, Intuit retains your file for one year, after which it’s deleted. Export a final backup before canceling so you have a permanent local copy of your QuickBooks data.

Will my CPA still be able to use my books after I switch?#

Yes, as long as you can produce three standard reports as CSVs or PDFs: a profit and loss statement, a balance sheet, and a transaction detail by category report. Every modern bookkeeping tool, including simpleWhirks Books, generates those in one click. Most CPAs prefer QuickBooks because their staff is trained in it, but virtually all CPAs work from exported reports. Before switching, ask your CPA directly: “If I send you a clean P&L, balance sheet, and transaction list in CSV format, can you do my year-end without extra hours?” Most will say yes. If yours says no, that’s important data for your decision.

How do I handle opening balances correctly?#

Opening balances are the most error-prone part of any migration. The rule is: pick a transition date that’s the end of a completed accounting period (the last day of a month or quarter), pull a trial balance from QuickBooks as of that date, and enter those balances in simpleWhirks Books as your opening balances on the day after. Every account balance, bank, credit card, equity, retained earnings, must match. If the opening trial balance doesn’t balance (debits don’t equal credits), something is wrong in QuickBooks and you need to fix it before migrating, not after. This is where a CPA is worth the call.

Can I keep my historical QuickBooks reports after canceling?#

Yes, but you have to export them first. Before you cancel your QuickBooks subscription, export PDFs of your annual P&L, balance sheet, general ledger, and the prior three years of tax-filing supporting documentation. Save them locally and in cloud storage. The IRS expects you to retain business records for three years minimum, seven for safety. Once you cancel QuickBooks, Intuit holds your data for one year and then deletes it. After that point, your locally saved PDFs are your only record of the QuickBooks history, so do this step before you cancel, not after.

Next step: Book a free Books setup call#

If you’ve read this far, you’re seriously considering the switch. The fastest way to derisk it is a 30-minute call where we walk through your specific QuickBooks setup, identify any edge cases (payroll, inventory, multi-entity), and either confirm the standard playbook will work or flag what needs custom handling.

The call is free, there’s no obligation, and most operators leave knowing exactly which Saturday afternoon they’re going to do the switch.

Book a Free Books Setup Call with Travis

Calls are scheduled with Travis Sutphin (CTO and product lead). For migrations with accounting complexity (multi-entity, inventory, opening balance equity issues), Garrett joins the call directly.

About the authors.

Travis Sutphin is the CTO and co-founder of simpleWhirks. He leads engineering on the Books product and oversees the QuickBooks import pipeline. He writes about the technical side of bookkeeping software: bank feeds, import pipelines, schema decisions, and the tradeoffs of picking a tool sized to the way owner-operators run their books. Read more · LinkedIn

Garrett Truman is a licensed Florida CPA (License #AC45159) and co-founder of simpleWhirks. He has spent over twenty years working with small businesses in finance and accounting roles, including as virtual CFO and the author of The Little Simple Startup Book. He works primarily with home-based businesses, trades, and owner-operators in northeast Florida. Read more · LinkedIn

Pricing, IRS guidance, and Intuit product details change. This post is reviewed periodically against the cited primary sources; use the links below to verify the current values before relying on them for a migration plan.

Sources cited: Intuit QuickBooks Online export documentation · QuickBooks Online pricing · IRS Small Business Recordkeeping · AICPA small business resources · SBA Manage Your Finances