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.
- Opening balances
- Chart of accounts
- Contacts
- Inventory and costs
- 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.
- Finish the bank reconciliation as of the cutover date
- Export the trial balance as of that same date
- Pull the list of open customer invoices and supplier bills
- Count your inventory, with costs
- Note the GST and QST to remit for the last period
- 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
Choose the cutover date
Ideally the first day of a fiscal year, or at least the start of a quarter.
-
2
Export your reports
Trial balance, customer and supplier lists, open invoices and inventory, in Excel or CSV.
-
3
Import and preview
Every import is validated and previewed before it is posted.
-
4
Check the balances
The control reconciliation compares imported balances with your original trial balance.
-
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.
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