Moving clients from Sage Business Cloud Accounting to QuickBooks Online
A practical walkthrough for accountants migrating clients from Sage Business Cloud Accounting to QuickBooks Online, covering exports, lists, history, and cutover.
Switching a client’s books from Sage Business Cloud Accounting to QuickBooks Online is a project, not a button click. Done in the right order, though, it can be a clean handover. Here is how we approach it, and where the common snags appear.
What transfers and what does not
QuickBooks Online can import the core lists you will export from Sage: customers, suppliers, products and services, and the chart of accounts. Historical transactions do not carry over as live, editable records. Most firms handle this by entering opening balances as of a cutover date, then running the old system in parallel for reference only.
Pick the cutover at a clean point. The start of a fiscal year, a VAT quarter, or a month end keeps reconciliation work to a minimum.
Preparing the export
Before exporting anything, tidy the source data. Merge duplicate customers and suppliers, deactivate anything unused, and confirm the chart of accounts still reflects how the client actually trades. Cleaning up before the move is far easier than cleaning up after it.
Export each list from Sage as a CSV or Excel file. You will then reshape those files into the column layout QuickBooks Online expects for its import tools. Account names, types, and email fields need to match the template exactly, or rows will be rejected.
Importing into QuickBooks Online
Use the import options under the Settings menu to bring in your chart of accounts first, then products and services, then customers and suppliers. Importing in that order means transaction forms can resolve their linked records as you enter them.
Work through the import error reports as they appear. Most rejections come down to a mismatched account type, a stray character in a name, or a missing required column. Fix the file, re-upload, and repeat until the lists are clean.
Setting opening balances
Once the lists are in, enter opening balances as at your cutover date. For a going concern, the cleanest route is usually a journal dated the day before cutover, posting each balance sheet account, with the difference landing in opening balance equity. Bank feeds then connect from the cutover date forward.
Reconcile the first bank statement period in QuickBooks Online against the closing balance from Sage. If it ties, the migration is sound. If it does not, the discrepancy is almost always a missed receivable, payable, or inventory adjustment.
A sensible cutover checklist
- Choose the cutover date and freeze new entries in Sage from that point.
- Export and clean lists, then import them in order.
- Post opening balances and connect bank feeds.
- Reconcile the first period and confirm VAT setup.
- Keep the Sage subscription read-only for a final quarter of reference, then cancel.
Before you cancel the old subscription, download every report and document you might need later: final trial balance, filed VAT returns, and any attachments. Once access ends, retrieval becomes far harder.
If you are weighing up repair work on a damaged file instead of a migration, see our QuickBooks error code repair service for when that is the better path.