Almost every Hong Kong SME starts on Excel. For a one-person shop with twenty invoices a month and no employees, a single spreadsheet can carry the business comfortably for years. The trouble starts somewhere around the point you cross 50 invoices a month, hire your first staff member, take on multi-currency clients, or face your first audit — and the spreadsheet that used to feel agile suddenly feels brittle.
This guide walks through how to migrate from Excel to proper accounting software without losing data, double-counting transactions, or arriving at year-end with a set of books your auditor cannot reconcile. It is written for the HK SME owner or bookkeeper doing the migration themselves, with reference to where outside help usually pays for itself.
The signs that Excel has run out of road
You do not have to wait for a crisis. The common indicators that a HK business has outgrown spreadsheet-based bookkeeping:
- Two people need to update the file at the same time — a versioning nightmare that gets worse the more you patch it.
- You hire a part-time bookkeeper — handing over a personal spreadsheet creates a single point of failure.
- You start invoicing in USD, RMB or other currencies — Excel can do FX, but month-end revaluation by hand is fragile.
- You take on more than 50 invoices a month — the manual entry cost crosses the line where software pays for itself.
- Your first audit is approaching — auditors prefer reading from a system that produces a proper trial balance and audit trail.
- You want to see live cash flow or AR/AP positions — these are painful to maintain in Excel and trivial in a real system.
If two or more of these apply, the migration conversation is overdue.
Step 1: Choose a clean cutoff date
The most important decision in the entire migration is when you stop posting to Excel and start posting to the new system. The cleanest options, in order:
- Start of a new financial year. Best by a wide margin. Opening balances are the closing balances from a complete set of books, no part-year reconstruction required, and the new year’s audit reads cleanly from the new system.
- Start of a quarter. Acceptable if waiting for the financial year is impractical. You will carry mid-year opening balances that need a careful trial balance, but the bookkeeping rhythm picks up cleanly.
- Mid-month. Avoid if at all possible. Reconciling a partial month across two systems is where most migrations get into trouble.
If the financial year ends 31 March, the cleanest migration cutoff is 1 April with all the prior year’s books closed and signed off in Excel before the cut.
Step 2: Decide your chart of accounts
Most Excel-era books accumulate categories organically — “Office stuff”, “Things for clients”, “Bank fees & misc” — that no auditor will accept. Migration is the moment to design a proper chart of accounts:
- Aim for 30–50 GL accounts for a typical HK SME. Resist the urge to start with 200; you can always split later, but merging is much harder once data is posted.
- Group accounts by financial-statement section — assets, liabilities, equity, revenue, COGS, operating expenses, other income, other expenses.
- Map your existing Excel categories to the new GL accounts on paper before importing. Half the post-migration cleanup we see comes from skipping this step.
- Confirm depreciation account treatment for fixed assets — this is the single most common audit query post-migration.
- Set up dimensional tags (project, location, department) only if you know you will use them. Empty dimensions create reporting noise.
If you are unsure where to start, our companion guide on setting up a company in HK: accounting checklist walks through a realistic chart of accounts for a typical SME.
Step 3: Compile the opening balances
Opening balances are where migrations stand or fall. You need a trial balance at your cutoff date, listing every account with a debit or credit balance, that totals to zero. The components:
- Bank balances per the bank reconciliation at cutoff.
- Accounts receivable as a list of open customer invoices with original date, currency, amount, and outstanding balance.
- Accounts payable as a similar list of open supplier invoices.
- Fixed assets with cost, accumulated depreciation, and net book value at cutoff.
- Inventory if you carry it — at cost, with proper valuation.
- Loans, accruals, prepayments with supporting schedules.
- Share capital and retained earnings — the balancing items that complete the trial balance.
If your prior year was audited, the audited balance sheet is the authoritative starting point. If it was not, you may need to spend a few days reconstructing balances from bank statements and source documents — which is where engaging a bookkeeper for a one-off “migration cleanup” usually pays off.
Step 4: Import master data
Before importing transactions, set up the master records that future entries will reference:
- Customers — name, billing address, currency, payment terms, BR number where relevant.
- Suppliers — name, address, currency, payment terms, bank details for FPS or autopay.
- Items — if you sell standardised products or services, set them up with codes, default GL accounts, and prices.
- Tax codes — minimal in Hong Kong (no VAT), but set up codes for any cross-border tax handling.
- Users — invite the bookkeeper, the accountant, and any reviewer with the appropriate role-based permissions.
Most cloud systems support CSV import for masters. The work is in cleaning the Excel data first — duplicate customers, inconsistent name spellings, and missing currency codes are the usual landmines.
Step 5: Run the first month in parallel
For the first month after cutoff, post every transaction in both Excel and the new system. The point is not to keep Excel alive forever — it is to catch the configuration mistakes (wrong GL account, wrong tax code, wrong currency setup) while the volume is small enough to fix easily. At the end of the first month, the new system’s trial balance and the Excel control totals should agree to the cent. If they do not, find the difference now, before three months of data sits on top of it.
Common pitfalls
Importing historical transactions. Tempting, but rarely worth it. Opening balances at cutoff plus forward-only posting is far cleaner than trying to back-load five years of Excel into the new system.
Skipping the customer/supplier cleanup. Duplicate masters create reconciliation chaos. Spend the time to consolidate before importing.
Choosing software before designing the chart of accounts. The COA should drive the software choice, not the other way around. Our QuickBooks vs Xero vs local software comparison covers what each platform is and is not strong at.
Underestimating bank reconciliation setup. Bank feed configuration takes a couple of weeks for HK banks — start the process before cutoff, not after.
Trying to migrate during your busiest quarter. Pick a quiet month. The migration itself is not glamorous work and concentration matters.
When to bring in help
A solo founder migrating a simple set of books can usually handle this themselves in 20–40 hours of focused work. A growing business with multi-currency, fixed assets, payroll, and an active audit relationship usually benefits from engaging a professional — either to do the migration end-to-end, or to review the trial balance and chart of accounts before go-live. The cost is modest compared with the cost of having to re-migrate eighteen months later when the original setup turns out to be unworkable.
Make the move with confidence
Giga Accounting by 凌峰會計 includes a guided onboarding flow specifically designed for businesses migrating off Excel — chart of accounts templates for common HK industries, opening balance import, customer and supplier master upload, and a parallel-run period to confirm everything reconciles.
For pricing, see our HK accounting software pricing guide. To compare against other systems, our QuickBooks vs Xero vs local software piece is the best starting point. If you would prefer to outsource the migration entirely, our bookkeeping and accounting service handles it as a one-off project — usually delivered in two to four weeks for a typical SME.
