Switching from QNE, AutoCount or SQL Account: the order that works

Updated 10 October 2026 · 6 min read

Move your lists and balances in an afternoon, in the order that avoids rework — and the one check that proves the move.

Most of the pain in switching accounting systems comes from doing things in the wrong order: importing invoices before the customers exist, or opening balances before the chart of accounts is right. Do it in this order and each step builds on the last.

Before you start: pick a go-live date

Choose the first day of a month — say 1 November. Your old system keeps everything up to 31 October; TechnoCount starts from 1 November. Your opening balances are the figures as at 31 October.

The order

1. Chart of accounts. Export your account list (or simply your Trial Balance, which lists every account). TechnoCount starts with a Malaysian chart already set up; import yours to add your own accounts and codes.
2. Branches, departments and projects — only if you use them.
3. Customers and suppliers. Export the debtor and creditor listings.
4. Items and products. Export the stock item listing.
5. Fixed assets, if your old system keeps the asset register.
6. Opening balances, in three parts: the Trial Balance at 31 October; your unpaid invoices and bills (the aged debtors and creditors in detail, one line per invoice); and your stock on hand with its cost.

Everything above is under Import & Export in TechnoCount. You can upload the Excel or CSV files exactly as your old system exports them: columns such as AccNo, CompanyName, Debtor Code or Doc No are recognised automatically, and you can adjust the matching before anything is saved.

The check that proves it

Open the Trial Balance as at 31 October in TechnoCount and put it beside the one from your old system. They should agree to the sen. Then do the same with the Customer Aging and the Stock Balance. If all three agree, your move is complete.

What about this year's past transactions?

You don't need them to start — the opening balances carry everything forward. If you want the history for reports, you can import this year's sales and purchase documents or its journals. Choose one, not both, or the same sale would be counted twice.