How to move from Tally or a desktop POS to a cloud system
Most shops stay on an old desktop program because moving the data looks hard. With a clear cut-over date and the right order, it is a few days of work.
By Sirin Kolasseri, Founder of StartERP ยท Updated
1. Pick a cut-over date
Choose the first day of a month or of a VAT period. Everything before that day stays in the old system as history; everything from that day is entered only in the new one. This keeps your VAT returns clean.
2. Move the lists first
- Products: name, code or barcode, unit, cost and selling price, category. Export them from the old program to Excel.
- Customers and suppliers: name, phone, VAT number, address and credit limit.
- Clean the file before importing: remove duplicates and old items you no longer sell.
3. Bring in the opening balances
On the cut-over day, take from the old system: stock on hand for every item, what each customer owes you, what you owe each supplier, and the closing balance of your cash, bank and other ledger accounts.
Enter them as one opening entry dated that day, and check that the totals match the old system's trial balance before you start selling.
4. Let the tools do the copying
StartERP's import screen reads products, customers, vendors and past invoices from Excel or CSV, with a sample file for each. Rows already in StartERP can be skipped or updated.
For bigger moves, the Data migration add-on has a Windows agent that reads an old SQL Server database or Tally (through its XML port) with your consent, maps the tables, and posts the opening balances as one entry you check before committing.
5. Run a short check, then switch
- Sell a few test items in the new system and print a receipt on your printer.
- Count a few shelves and compare with the imported stock.
- Keep the old program read-only for at least a year, for audits and old invoices.
Frequently asked questions
Do I lose my old invoices?
No. They stay in the old system, and you can also import past invoices for reference. Imported invoices keep their old numbers and are never sent to ZATCA again.
How long does a move take?
For a single shop with clean lists, a day or two. Several branches with years of history take longer, mostly for checking balances.
Can I move in the middle of a VAT period?
You can, but you will then add up that period from two systems. Starting on the first day of a period is simpler.