Skip to content

Switching / From QuickBooks

Move from QuickBooks with a clear import plan.

Bring supported lists and documents through separate CSV/XLSX imports; use .qbo files for bank activity only. Review each result, keep your source archive, and reconcile balances before switching daily work. Timing depends on the records and cleanup needed.

Before you start

Three decisions before you import

Decide the cut-over date, the records to bring, and how to retain your source data before importing. Leave time to review the results and reconcile balances.

Pick a clean cut-over date

The first of a month is good; the first of your fiscal year is better. Best of all is the day after your last reconciled bank statement — everything before it is settled history, everything after it is new work in Bokeping.

Decide how much history you actually need

You rarely need every year you have ever recorded. Open invoices and bills, plus the current fiscal year, covers most businesses. Anything older is reference — and QuickBooks can keep holding it.

Keep the old system read-only for a quarter

Do not cancel QuickBooks the day you import. Stop entering new work in it, let the subscription run to its renewal, and export PDF copies of the reports you would hate to lose. A fallback you never use is cheap; one you needed and canceled is not.

The sequence

Seven steps, in this order

The order matters more than the speed. Lists before transactions, transactions before balances, balances before you trust a single report.

  1. 1

    Reconcile, then freeze

    Run your last bank reconciliation in QuickBooks through the cut-over date and let it finish clean. The numbers you are about to import are only as trustworthy as the day you copy them from — reconciling first means any discrepancy you find later belongs to the import, not to the history.

  2. 2

    Export your lists

    QuickBooks produces separate exports for your lists — customers, vendors, items and the chart of accounts. Keep them as separate files rather than one merged sheet: each one imports into a different place in Bokeping, and separate files make the import report easy to read.

  3. 3

    Export your transactions — and three proof reports

    Prepare separate CSV/XLSX files for the invoices, bills, and other supported records you plan to import, matching each file to the relevant Bokeping template. For bank activity, download a .qbo (Web Connect) file or another supported transaction file from your bank. A .qbo file contains bank or credit-card transactions, not your customer and vendor lists or sales and purchase documents. Also export the trial balance, A/R aging summary, and A/P aging summary as of the cut-over date so you can compare balances after import.

  4. 4

    Import the lists first, in order

    Chart of accounts, then customers and vendors, then items. Bokeping guesses which of your columns is which, shows you every guess in a preview, and writes nothing until you confirm. Fix the mapping once and it holds for the rest of the file.

    How column mapping works
  5. 5

    Import the transactions

    Import invoices and bills through their respective CSV/XLSX imports, then review the documents and any payment records needed to establish the correct outstanding balances. Import .qbo files through Banking for bank transactions only. Review each import result and match bank activity to existing documents where appropriate; a bank transaction alone does not recreate its invoice or bill.

  6. 6

    Post opening balances and tie out

    Review what the imported transactions already contribute, then enter only the remaining opening balances as of your cut-over date. Do not count an imported invoice or bill again in an opening receivable or payable. Compare every trial balance account, the A/R and A/P details, and bank balances with your QuickBooks reports. Investigate differences before starting daily work.

    Financial statements in Bokeping
  7. 7

    Connect the bank and send one invoice

    Bank feeds are Plaid-powered, read-only, and included from Standard up, including during your account’s one-time Pro trial. The trial starts with your first company; companies created during it share the same end date. Confirm the first batch of categorizations and the suggestions start learning your habits. Then send one real invoice from your imported customer list.

    How bank feeds work

The honest inventory

What comes across, and what doesn’t

What comes across

  • Customers and vendors. Import the supported contact fields, then establish outstanding balances through the relevant documents, payments, or opening balances. Importing a contact list alone does not recreate its full transaction history.

  • Your items list. Products and services with prices and descriptions, ready to drop onto the first invoice.

  • Supported accounts. Review Bokeping’s default chart, then add or import the accounts you need using the supported account fields and types. Check the mapping before importing transactions; the old chart is not a complete company restore.

  • Open invoices and bills. Import supported invoice and bill fields, then check the payment records and allocations needed to establish the outstanding amounts. A source status such as “partly paid” does not by itself recreate the payment history.

  • Bank transaction history. The lines behind the balance, so your first reconciliation in Bokeping has something to reconcile against.

  • Opening balances to reconcile. Prepare balances for the cut-over date, accounting for any history already imported. Compare the resulting accounts and unpaid documents with your source reports and resolve differences.

What doesn’t

  • QuickBooks Payroll history and filed tax forms. Pay runs, payroll liabilities and anything you have already filed stay with Intuit. Export PDFs of your payroll registers and year-end forms before you stop paying for the subscription, and keep a payroll provider — Bokeping does not run payroll and does not file returns.

  • Memorized reports and custom layouts. A saved report is a saved set of options, not data. Rebuild the two or three you actually open; most people find the default statements cover them.

  • Bank rules. Your QuickBooks rules do not travel. Bokeping learns from the categorizations you confirm in the first week instead of asking you to re-type the rules — but that first week is you teaching it.

  • Reconciliation status on past periods. History arrives as history, not as pre-cleared lines. You do not re-reconcile the past: the opening balance as of the cut-over date is the settled figure, and reconciliation starts fresh from there.

  • Attachments beyond what you can export. CSV/XLSX and .qbo imports do not bring attached receipts or PDFs with them. Download and archive those files while you still have access; attach them separately to supported records in Bokeping where needed.

  • Class and location tracking, where we have no equivalent. Check the fields supported by each import before relying on QuickBooks classes or locations. They are not automatically converted into Bokeping dimensions or description text. Keep unsupported detail in your archive or deliberately map it to a supported field.

Bokeping does not sell payroll, file tax returns, or do project and job costing. It also does not consolidate multiple entities — you can run more than one company from a single login, each with its own books and its own separately billed subscription, but there is no combined set of statements across them. If your QuickBooks file leans on any of those, keep the tool that does them — a payroll provider such as Gusto or ADP, your filing agent, your consolidation spreadsheet — and let Bokeping be the ledger underneath.

Suggested sequence

Prepare, import, verify, then begin daily work.

Step 1

Export

Prepare supported list and transaction exports, then save the trial balance and aging reports for comparison.

Step 2

Import and map

Import lists before documents, confirm mappings, and check the result of each file before continuing.

Step 3

Tie out, connect the bank

Compare the trial balance, aging reports, and bank balances with your exports. Resolve differences, then review the bank connection and its starting date.

Step 4

First invoice out

From the imported customer list, on your own template, with the right number in sequence.

Step 5

First reconciliation

Reconcile bank activity against a statement and confirm that imported history and new feed transactions do not overlap.

Then leave QuickBooks read-only until you have closed a full quarter in Bokeping. By the time the renewal comes round, the decision makes itself.

While you are here

The three things people check next

FAQs

Fair questions about leaving QuickBooks

Switching from something else?From Xero ·From spreadsheets ·Switching overview ·Help center

Prepare your QuickBooks exports

File import has no additional fee. Start with supported records, review the preview and results, and keep your original exports.

Start for free

Ready to know your money?

Free plan, no card needed. Bring your QuickBooks or spreadsheet history, invite your accountant, and start reading your own books today.