Moving to New Accounting Software: The Cut-Over Checklist
- Phase 1: decide before you touch data
- Phase 2: set up the masters
- Phase 3: bring across opening balances, in detail
- Phase 4: prove it
- Phase 5: go live carefully
- Phase 6: after the first quarter
- The short version
- Where this fits
Moving to new accounting software is mostly about one date and one proof. The date is the cut-over: the point after which every transaction goes into the new system and none into the old. The proof is that the new system’s opening trial balance, customer balances, supplier balances, stock and fixed assets agree exactly with the old system’s closing figures on that date. Everything else in a migration supports those two things.
Most migrations that go wrong fail at the second step: balances are brought across in totals, and the detail behind them is reconstructed from memory months later.
Phase 1: decide before you touch data
- Choose the cut-over date. The start of a financial year is cleanest, because no year is split between two systems. The start of a quarter is the next best, and it aligns with return periods. Avoid the middle of a month.
- Decide how much history to bring. Opening balances only, or a year of transactions? Opening balances are faster and less error-prone. Keep the old system or a full export available read-only for history.
- Design the chart of accounts in the new system first. Do not simply copy the old one if it has problems. See setting up a chart of accounts.
- Map old accounts to new. A two-column table: every old ledger, and the new account its balance goes to. Several old accounts can map to one new one; one old account should not be split without a documented basis.
- Name an owner. One person is accountable for the migration and signs off the proof.
Phase 2: set up the masters
- Company details, financial year, GST registrations and tax settings.
- Customer and supplier masters with GSTINs, addresses, payment terms and state codes.
- Item masters with units, tax rates, HSN or SAC codes, and valuation method.
- Bank accounts, with the closing balance per bank statement on the cut-over date.
- Users and permissions, set to roles rather than giving everyone administrator access.
- Number series for invoices and other documents, continuing or starting fresh as your accountant advises for the period.
Clean the masters as you go. Migration is the cheapest time to remove duplicate customers and dormant items.
Phase 3: bring across opening balances, in detail
| Balance | Bring across as | Why |
|---|---|---|
| Trade receivables | Each unpaid invoice individually, with date and due date | So receipts can be matched and ageing is correct from day one |
| Trade payables | Each unpaid bill individually | So payments match bills and supplier statements reconcile |
| Stock | Quantity and value by item, and by location if relevant | So cost of goods sold is right from the first sale |
| Fixed assets | Each asset with cost, accumulated depreciation and date | So depreciation continues correctly |
| Bank | Book balance, plus unreconciled items listed individually | So the first reconciliation works |
| Tax ledgers | Balance of each GST and TDS ledger | So the first returns in the new system are right |
| Everything else | Ledger balance | Loans, capital, provisions, deposits |
Receivables and payables brought across as a single total are the most expensive shortcut in any migration. The first customer who pays two old invoices at once cannot be matched, and the ageing report is wrong until someone rebuilds it.
Phase 4: prove it
On the cut-over date, produce the following from both systems and check they agree to the rupee:
- Trial balance, account by account through the mapping table.
- Customer-wise receivables and supplier-wise payables.
- Stock by item: quantity and value.
- Fixed asset register totals.
- Bank balances, and the bank reconciliation.
- GST and TDS ledger balances.
Any difference must be explained and corrected before live entries start. Keep the signed-off comparison as a record; your auditor will ask for it.
Phase 5: go live carefully
- Run one month in parallel if the business can manage it: record the month in both systems and compare the profit and loss, GST registers and bank reconciliation. Differences reveal set-up errors while they are still small.
- Lock the old system for the period after cut-over so nobody posts there by habit.
- Train by role, on the tasks each person actually does, using real transactions.
- Check the first return prepared from the new system line by line against source documents before filing.
Phase 6: after the first quarter
- Review suspense and unallocated accounts for items that crept in during the switch.
- Confirm that reports your lenders, accountant and management need can be produced.
- Archive the old system’s data in a format you can still open in years to come, for the period records must be retained.
The short version
One cut-over date. Open items brought across individually. Opening balances proved to the rupee. One month in parallel. Old system locked.
Where this fits
- Choosing what to move to: choosing accounting software
- The structure to set up first: chart of accounts
- The reconciliation that proves the bank side: bank reconciliation step by step
- Why spreadsheets eventually fail: when Excel stops being enough