Accounting basicsPublished 8 min read

How to Switch From QuickBooks Online: A Step-by-Step Guide

Switching accounting software is a bookkeeping project with a clear shape: pick a cutover date, move the history, prove the numbers match, and keep the old system readable until they do. Here is the sequence, and what each step looks like when you move from QuickBooks Online to Numbrr.

The short answer

  • Switch at a clean point: the start of a fiscal year or right after a completed month-end close. A mid-year switch works too, as long as you tie out at the cutover.
  • Connect QuickBooks Online to Numbrr. It copies your history, you map the accounts and set a cutover date for each bank, and one import loads everything.
  • Prove it before you rely on it. Numbrr compares its ledger with your QuickBooks trial balances account by account. Every difference is listed with a likely cause, and an import can be undone.
  • Keep QuickBooks readable until your first month in Numbrr closes and ties. Export a backup before you cancel anything.

Is it time to switch?

People usually move for one of three reasons: they spend hours each month categorizing transactions and want software to do it, they need accrual books for investors or a lender, or they pay a bookkeeper mostly to keep QuickBooks tidy. A fourth, practical reason is the calendar. A new fiscal year or a freshly closed quarter makes the cutover easy to explain to an accountant.

Before you start

  1. 1Close the period you are leaving. Reconcile every bank and card account in QuickBooks through your cutover date, and post the month-end entries.
  2. 2Clear the uncategorized account. Money sitting in Uncategorized Income or Uncategorized Expense comes across as it is. Recode it first if you can.
  3. 3Note what is open. Unpaid customer invoices and unpaid vendor bills should be correct in QuickBooks, because they move with their balances.
  4. 4Choose the cutover date for each bank. QuickBooks supplies the history up to that date, and the bank feed in Numbrr takes over after it. The first day of a month is easiest.
  5. 5Give yourself admin access. You need to sign in to QuickBooks Online as an admin to authorize the connection.
  6. 6Export a backup. Download your reports and a company backup from QuickBooks, and keep the subscription active for now.

What moves and what stays behind

Comes acrossStays behind or works differently
Every transaction in your ledger, with split transactions keptPayroll paychecks and inventory cost of goods, which QuickBooks does not share through its connection
Invoices and bills as documents, with their payments and credit memosEdits made in QuickBooks after the import: undo and import again to bring them in
Open receivables and payables, with their balancesClasses and locations: kept as references on each record, and not used in Numbrr yet
Your chart of accounts, including parent accounts and sub-accountsAn ongoing sync: QuickBooks is a source for the move, and your books run in Numbrr afterward
Customers, vendors and items, with 1099 vendors marked
Budgets by month, and your QuickBooks fiscal year

Imported history arrives already categorized the way you coded it. No AI touches it, so nothing you booked in the past is reinterpreted.

The steps

  1. 1

    Create your Numbrr account and connect QuickBooks Online

    Connecting QuickBooks is one step of onboarding. You can also do it later from Settings. Numbrr copies what QuickBooks makes available into a holding area and writes nothing to your books yet.

  2. 2

    Read the summary

    You see what was copied: the count of each record type, the date span, your QuickBooks company, its accounting method and its fiscal year. Check the span against what you expect.

  3. 3

    Map your accounts

    Each QuickBooks account with activity is matched to your Numbrr chart by role, number and name, busiest first. Accounts without a match are marked new, and QuickBooks parent accounts and sub-accounts keep their structure. Nothing is created until you press Import.

  4. 4

    Set the bank and card cutover dates

    Match each QuickBooks bank and card account to a linked account in Numbrr and choose the date the feed takes over. Overlaps are shown, and a transaction the feed already has is skipped and reported. A bank you cannot connect yet can be added with its history, and the feed attached later.

  5. 5

    Review customers, vendors, items and budgets

    They are matched by name or email, or added. Vendors flagged for 1099 reporting arrive marked.

  6. 6

    Check the preview and import

    The preview lists what will be written and anything that blocks the import, which stays disabled until each is resolved. Import runs as one batch. Large companies load in ordered parts under one run, and each part is safe to resend.

  7. 7

    Read the tie-out

    Numbrr compares its ledger with every QuickBooks trial balance it retrieved, account by account, to zero. Each difference is listed with its likely cause: a cutover, a transfer in transit, an unmapped account or a payroll or inventory amount. If it is wrong, Undo removes that import and nothing else.

  8. 8

    Close the old periods and set up the new routine

    You can lock the books through the date QuickBooks closed them. Then connect the remaining bank feeds, invite your accountant and set up revenue recognition, fixed assets and prepaids if you use them.

Verify it ties

An import you have not reconciled is a guess. After the import, compare three reports with the ones from QuickBooks as of the same date: the balance sheet, the profit and loss for a period both cover, and the trial balance. Bank and card balances should match exactly. Expect zero difference, since a few dollars off usually means an account mapped to the wrong place or an overlap with the bank feed.

  • Balance sheet: every bank, card, receivable and payable balance as of the cutover.
  • Profit and loss: line by line for a full period.
  • Trial balance: account by account, which the tie-out does for you.
  • Open invoices and bills: a count and total that match the QuickBooks aging reports.

What to keep until it ties

  • Keep QuickBooks active, even read-only, until your first full month in Numbrr is closed and reconciled.
  • Keep the backup and the reports you exported. You will want them if a number is questioned.
  • Keep your accountant in the loop from the start. Numbrr gives accountants their own seat, and the books export in standard reports.
  • Cancel QuickBooks only after the first close ties. Cancelling earlier can end access to the history you may need to check.

Common mistakes

  • Importing before the old period is reconciled, which carries the old errors across.
  • Choosing a bank cutover date that overlaps the feed. The import skips duplicates, but the overlap is easier to avoid than to explain.
  • Cancelling QuickBooks the day the import finishes.
  • Leaving a large Uncategorized balance and expecting the new system to recode it.
  • Making edits in QuickBooks after the import and expecting them to appear in Numbrr.
  • Skipping the tie-out because the numbers look right.

What changes after you switch

Day to day, the work moves from you to Numbrr. Transactions are categorized as they arrive and the bank is reconciled automatically. Numbrr asks a question only when it is unsure, and it keeps an audit log of every change and every AI decision. Every plan keeps accrual-basis books, and Numbrr One adds invoicing, bills, revenue recognition and the rest of the accrual suite. If you have been on cash, cash vs accrual accounting for startups explains what changes. Catch-up bookkeeping for earlier months is included on every plan.

Can I move my QuickBooks Online history into Numbrr?

Yes. Connect QuickBooks Online during onboarding and Numbrr copies your history: transactions, invoices and bills with their payments, customers, vendors, items and budgets. You map accounts, set a cutover date for each bank, import, and check a tie-out against your QuickBooks trial balance.

When is the best time to switch from QuickBooks Online?

The start of a fiscal year or right after a completed month-end close, because the cutover point is clear. A mid-year switch works as well when you tie out to the trial balance at the cutover date.

Will I lose my transaction history?

No. The history is imported already categorized, and every imported record keeps its QuickBooks reference. Export a backup and keep QuickBooks active until your first month in Numbrr ties out.

Does Numbrr change my QuickBooks data?

No. Numbrr only reads from QuickBooks, and it closes its access once the copy is done. QuickBooks is a source for the move and is not synced afterward, so edits made there after the import do not appear in Numbrr.

How do I know the import is correct?

Numbrr compares its ledger with each QuickBooks trial balance account by account, and lists every difference with a likely cause. An import can be undone, which removes that batch and nothing else.

Does the import use AI?

No. Imported history loads categorized the way you coded it, and no AI is called on it.

What does not move from QuickBooks Online?

Payroll paychecks and inventory cost of goods are not available through the QuickBooks connection, and classes and locations are kept as references and not used yet. Numbrr does not run payroll and has no inventory module, so a company that needs either should plan for another tool.

Can I migrate from Xero, Wave or a spreadsheet?

Transaction history from other systems can be loaded by CSV. Contact us with what you are coming from and we will say how clean the move will be.

The Numbrr newsletter

Accounting that makes sense, once a month

One email a month: a new guide, the deadlines coming up, and one thing about your books worth fixing. Unsubscribe whenever.