All guides
Guide · Getting started

Switching from QuickBooks

Bringing your accounts, opening balances, open invoices and bills, and stock over from QuickBooks Online, checked to the cent before anything posts.

3 min read

Start a company from QuickBooks

The setup wizard for a business moving from QuickBooks Online: a real company chosen and its details, QuickBooks Online chosen as where you’re coming from, the company created with only the essential accounts, the switch it lands on, and the setup checklist pointing the chart and opening balances at the switch. (3:22)

Switch from QuickBooks, step by step

Every tab of the switch: the switch date and the warehouse, the eight QuickBooks Online reports uploaded, the accounts mapped, the customers, suppliers and items added, the open items and stock reviewed, the check at zero, the import, and the Trial Balance as at the opening date. (4:20)

Moving from QuickBooks Online doesn't mean retyping your books. You export eight standard reports from QuickBooks, upload them to BeanDish, and BeanDish builds your opening position from them, checking every account against your trial balance before it posts anything.

Starting a new company from QuickBooks

Every new company starts with the setup wizard: it opens the first time you sign in, and after that from Add company in the company menu at the top of the sidebar. Fill in your company's details, and when the wizard asks where you're coming from, choose QuickBooks Online. The company starts with only the essential accounts, because the rest come over from QuickBooks, and when you click Create company you land on the switch.

Before you start

The switch lives at Admin › Switch from QuickBooks. Only an Admin can use it, because it posts your opening balances.

On Main, choose the switch date — the first day you will work in BeanDish — and the warehouse your opening stock goes into.

The reports

On Reports, each row names one QuickBooks Online report. In QuickBooks, run each one as of the day before your switch date, export it to Excel, and upload it on its row. A dated report for any other day is refused, with both dates named, so the opening figures can't come from different days.

Accounts

On Accounts, each QuickBooks account goes onto a BeanDish account, or is added as a new one. Receivables and payables go onto BeanDish's own control accounts, so your aging and your ledger agree from day one. Change any row and click Save mapping.

Customers, suppliers and items

Customers & items shows what the lists will add. A record BeanDish already has is matched rather than added twice. Click Add accounts, customers, suppliers and items.

Open items and stock

Open items & stock lists the open invoices and credits, the unpaid bills and the stock on hand, with their totals, so you can see what will come across.

The check

Check compares every account with what BeanDish will hold after the import. Opening Balance Clearing, the account that takes the other side of every opening figure, should end at zero. When it does, click Import and confirm: everything posts in one go, dated the day before the switch date.

Open the Trial Balance as at that date afterwards: it matches QuickBooks to the cent.

Changing your mind

Undo the switch takes the import back, as long as nothing has been built on it yet — for example a payment against an opening invoice or bill, or opening stock that has since moved — and the opening date can still take a posting; if it can't, it says why. The accounts, customers, suppliers and items it added stay.

See every step

The two tutorials at the top of this page show it done: the first starts a company from QuickBooks in the setup wizard, the second goes through every tab of the switch. Both are in BeanDish too, under Learn › Tutorials.