Skip to content

Switch to BooksMatic from Sage 50, QuickBooks or Excel

Import your balances from Sage 50, QuickBooks or Excel, check them, then start working. Without re-entering everything.

Sage 50 · QuickBooks · Excel

You don't have to re-enter everything

Import your trial balance, customers, suppliers and inventory from Sage 50, QuickBooks or an Excel file. Every import is validated, previewed, then posted with a trail.

  1. Opening balances
  2. Chart of accounts
  3. Contacts
  4. Inventory and costs
  5. Control reconciliation after import

SWITCH SAFELY

Why switch accounting software?

Many businesses keep their old software because they fear the migration. Yet its limits are often what cost the most, day after day.

  • Software installed on a single computer, hard to share with your team or your accountant

  • Licences and yearly updates to pay for and install

  • Backups to do yourself, and the fear of losing your file

  • Uncontrolled Excel spreadsheets, where a broken formula goes unnoticed

What you import into BooksMatic

  • Chart of accounts and opening balances (trial balance)
  • Customers and suppliers, with their contact details
  • Customer invoices and supplier bills still open
  • Inventory: items, quantities and costs

What stays in your former software

  • The detailed history of past transactions
  • Old reports and returns already filed
  • Export them to PDF or Excel for your records: nothing to re-enter.

Before the cutover: your preparation checklist

A good migration is prepared in the old software. These six points are enough for the import to balance the first time.

  1. Finish the bank reconciliation as of the cutover date
  2. Export the trial balance as of that same date
  3. Pull the list of open customer invoices and supplier bills
  4. Count your inventory, with costs
  5. Note the GST and QST to remit for the last period
  6. For payroll, prefer a January 1 cutover: you will have no year-to-date totals to carry over

The method, in five steps

A successful migration does not transfer everything. It transfers the right balances, at the right date, then proves they are accurate.

  1. 1

    Choose the cutover date

    Ideally the first day of a fiscal year, or at least the start of a quarter.

  2. 2

    Export your reports

    Trial balance, customer and supplier lists, open invoices and inventory, in Excel or CSV.

  3. 3

    Import and preview

    Every import is validated and previewed before it is posted.

  4. 4

    Check the balances

    The control reconciliation compares imported balances with your original trial balance.

  5. 5

    Start working

    Enter in BooksMatic from the cutover date. Your history remains available in your former software.

Checks after the import

Any difference, even a few dollars, is resolved before you start entering. Afterwards, it gets mixed up with new transactions.

  • Trial balance: each account equals its original balance at the cutover date.
  • Receivables: the total of open invoices equals the Accounts Receivable balance.
  • Payables: the total of open bills equals the Accounts Payable balance.
  • Inventory: the value of imported stock equals the Inventory account balance.

FAQ

Your questions about migrating

Which software can I migrate from?

From Sage 50, QuickBooks or any software that can export a trial balance and lists to Excel or CSV. If you keep your books in a spreadsheet, you can import that too.

Do I have to import all my history?

No. You import the balances at the cutover date, open invoices and inventory. The detailed history stays in your former software or your exports, for reference.

Which cutover date should I choose?

Ideally the first day of a fiscal year, otherwise the start of a quarter. Your GST and QST returns then stay whole in a single system. For payroll, January 1 is the simplest date.

What happens if a balance does not match after the import?

The post-import check compares each balance with your original trial balance and flags the difference. Fix it before you start entering: afterwards, it would get mixed up with new transactions.

Are my open invoices and inventory carried over?

Yes. Customer invoices and supplier bills still open are imported, as are your inventory items with their quantities and costs.

Can my accountant do the migration for me?

Yes. Give them access to your file: they can prepare the files, run the import and check the balances. With the free Firm plan, they can handle several clients' migrations from a single account.

All questions

Try it with your real books

Create your account, import your trial balance and watch your financial statements take shape.

30-day free trial · Cancel anytime