Skip to content

Move from QuickBooks

This is the step-by-step for a business moving its books from QuickBooks Online. The general picture (what a conversion is, and how old documents land in your books) is in Moving to BaseCloud from another accounting system. Coming from QuickBooks Desktop? Export from it and follow From any other system.

Nothing is changed in QuickBooks, and nothing is sent to your customers. Keep QuickBooks, read-only, until the move is proven.

Before you start

  • Pick your start date with your accountant: the first day of your fiscal year, or at least of a sales tax filing period, so no return is split between QuickBooks and BaseCloud. The day before it is your balances day.
  • Finish that period in QuickBooks: every invoice raised, every payment received and deposited, up to the balances day.
  • List your sales tax rates (in QuickBooks, Taxes): each agency and its rate. QuickBooks keeps them outside its chart, so you'll add them in BaseCloud.
  • Note what isn't coming over: bills (BaseCloud has no bills yet), recurring transactions, estimates, bank transactions and reconciliations. Write down your recurring invoices to set up as recurring invoices.
  • You need Manage Users and the books' Manage Accounts right.

1. Connect QuickBooks

In Settings › App Connections & Keys, connect QuickBooks and sign in to the company you're moving. See Connect QuickBooks.

2. Start your books with QuickBooks' chart

Ask BaseCloud support to start your books with you. In the setup (see Start your books):

  • Where does your chart of accounts come from? Import it from QuickBooks. Your accounts and account numbers come across. Credit card accounts become bank accounts, ready to reconcile. Your financial year end is taken from QuickBooks' fiscal year.
  • Start date: the date you picked. The move must use the same one.
  • Opening balances: leave them blank. The move brings QuickBooks' trial balance in.

3. Add your sales tax rates

In Accounting › Chart of accounts › Tax rates, add a rate for each agency you collect for, with its parts (state, county, city) if you report them separately. See Sales tax and VAT. Customers you don't charge tax (resellers, nonprofits) can be marked Exempt from tax with their certificate, on their Accounting tab.

4. Preview the move

In Settings › Books, under Move from Xero, QuickBooks or Sage:

  1. Move from: your QuickBooks connection.
  2. Start date: the same as your books'.
  3. Click Preview. BaseCloud reads QuickBooks once.

The preview shows how many customers come over (suppliers don't) and how many match clients already in BaseCloud, the items, the open invoices and open credit notes (credit memos) with what's still owed on them, payments since the balances day, unused payments (unapplied payments) kept as credit, the trial balance, and Owed to you on the balances day by age. It lists anything that can't come over and why, and Clients to check after the move. Nothing has come over yet.

Not right? Click Change, fix it in QuickBooks, and preview again.

5. Bring it over

Click Bring it over. Each step shows Done, Working, Needs you or To come. Keep the page open, or close it and click Carry on later: it carries on from where it stopped.

If a record couldn't come over, it's listed with the reason. Fix it (here or in QuickBooks) and click Try these again. If the opening balances wait because an account in QuickBooks' trial balance isn't in your chart, add it in Accounting › Chart of accounts with the same number, then click Carry on.

Each old invoice is dated on its own date and each payment on the day it was paid, never on the day of the move.

6. Bring paid history over (optional)

Under Paid invoices from before your start date, pick the From date and click Bring the history over. Invoices from then up to the balances day, paid in full by that day, come over with the payments that paid them. Your books' balances don't change.

7. Check your move

Click Check your move. Every account in QuickBooks' trial balance is set against BaseCloud's, every customer's balance too, and documents by year. When it says Proven, the move is complete. Compare it with QuickBooks' A/R Aging Summary on the balances day if you like.

8. After the move

  • Lock the move: set a lock date once it's proven.
  • Bank: connect each bank account's feed (Plaid) from the start date. See Bank accounts. Checks and deposits not yet cleared on the balances day are covered in Start your books.
  • Online payments: connect Stripe in BaseCloud, so new invoices can be paid online by card or ACH.
  • Recurring invoices: set up your QuickBooks recurring invoices as recurring invoices in BaseCloud.
  • Payment terms: set your Net terms in Settings so new invoices are due when your customers expect.
  • Merge any clients listed under Clients to check after the move that are the same.
  • Your accountant: give them access.