How to switch from Tally and Excel to cloud ERP without losing a number

What does switching from Tally and Excel to cloud ERP involve?

Switching means choosing one date, carrying the balances and open items of that date into the new system, and posting every new document there from that day on. You do not re-enter years of vouchers. The old books stay where they are, closed and readable, and the new system starts from a trial balance that matches them to the rupee.

Most small businesses arrive here with accounts in Tally on one computer, stock in Excel and godown numbers on WhatsApp. Nothing connects them, so every number is typed twice.

1. 1

   Decide you need to move

   Look for the signs: a queue for the PC, stock that never matches, balances that need a phone call.

2. 2

   Pick the cut-over date

   The first day of a month, ideally 1 April or the start of a quarter.

3. 3

   Set up and load masters

   Products, customers, suppliers, warehouses and the team.

4. 4

   Enter opening figures

   The trial balance as of the day before cut-over, a balance per party and stock by product. Lock that day once they match.

5. 5

   Dry run for two weeks

   Post real documents in both systems and compare the totals each week.

6. 6

   Go live

   Stop posting in the old system and keep it read-only.

How do you know your business has outgrown Tally and Excel?

You have outgrown them when the work waits on the software instead of the other way round. The most common signs are a second person waiting for the one PC with the licence, a stock sheet that disagrees with the shelf, and a customer balance that needs a phone call to the accountant.

• Two people need to bill at the same time and one of them waits.
• The physical count never matches the register, and nobody knows which movement is missing.
• Backups live on a pen drive in a drawer.
• The owner cannot see today's sales, cash or receivables from the phone.

There are eight signs in all, each with what it costs a month. Read eight signs your business has outgrown Tally and Excel if you are still deciding. If the stock sheet is the main pain, why your Excel stock register is always wrong explains the five ways it fails.

How is Tally on one PC different from cloud ERP on a normal Tuesday?

The difference is not features on a list. It is who can work, from where, at the same moment. Here is a typical Tuesday at a 10 person business in both setups.

Remote access or hosting can put a desktop licence online, but each session still needs its own seat. A system built for several users at once is a different thing. Multi-user accounting software compares the three set-ups in detail.

What moves to the new system, and what stays in Tally?

Balances and open items move; history stays. You carry over what the business needs to keep working from the cut-over date, and you leave the closed vouchers in Tally as the archive your auditor can still open.

The full list, in order and with who does each item, is in the Tally to cloud ERP migration checklist.

When should you switch: 1 April or the middle of the year?

Switch on 1 April if it is close; otherwise switch on the first day of any month. 1 April gives one system per financial year, so reports, returns and invoice numbering all start clean. A mid-year switch works just as well if you take a trial balance as of the last day of the previous month and keep the registers of both systems for that month.

Never switch mid-month. A month split across two systems means two half-registers for one GST return, and that is where numbers get lost. When to switch accounting software has a decision table by size, audit and payroll.

A worked example: Lakshmi Steel Furnitures moves on 1 October

Lakshmi Steel Furnitures is the fictional Coimbatore maker of steel racks, chairs and cupboards used across this site. It has 10 people, one GSTIN, a main godown and a store at Ukkadam. It ran Tally on the accountant's PC and stock in Excel. The owner chose 1 October 2026 as the cut-over date, six months into the financial year.

The accountant closed September in Tally and printed the trial balance as of 30 September 2026. This is the single document the new system must match.

Receivables of ₹2,31,000 are not one number in the new system. They go in per customer, so each statement of account and the next payment start from the right balance.

Payables of ₹1,84,700 go in the same way, per supplier. Stock goes in by product and warehouse at quantity and average cost, and the values must add to ₹2,19,000. Fixed assets go in at cost of ₹6,00,000 with ₹1,80,000 of depreciation already charged, so future depreciation runs on the right base. The wizard posts the balancing line to Opening Balance Equity. Once capital, stock and every party balance are in, the trial balance in SimpleERP should match the one above line for line.

Opening balances when you switch accounting software walks through each entry with the journal and the balance sheet on the opening date.

How does a two-week dry run catch mistakes before go-live?

A dry run means posting the same real documents in both systems for two weeks and comparing the totals. It is the cheapest insurance in the whole move, because every mistake it finds is found while the old system still has the right answer.

• Every invoice and bill from the first two weeks is posted in both systems
• Sales and purchase register totals match, tax head by tax head
• Each customer's balance matches, starting with the three opening balances
• Bank balance matches the passbook on the same date
• Stock quantity matches a spot count of ten fast-moving products
• Stock value on the stock screen equals the Inventory account, with a difference of zero

At Lakshmi Steel the dry run found one supplier bill for ₹28,320 entered in Tally but not in SimpleERP. Fixing it took five minutes.

What does the first month after go-live look like?

The first month is about habits, not data. Each person posts their own documents from their own login, the accountant checks the registers weekly, and the owner reads the dashboard instead of asking for numbers.

• Week 1: salespeople raise invoices; the store enters supplier bills.
• Week 2: payments are recorded against invoices, not just against the party.
• Week 3: the first stock count in one warehouse, with differences posted as adjustments with a reason.
• Week 4: month close, the GST registers checked, and the lock date moved to 31 October.

The 30-day ERP implementation plan breaks this into daily tasks with a check at the end of each week.

What does your CA need from you when you switch?

Your chartered accountant needs one trial balance as of the cut-over date and the GST registers from both systems for the month of the switch. With those two, the books join without a gap.

• The closing trial balance from Tally as of the day before cut-over, signed off by your accountant
• The opening trial balance from the new system as of the cut-over date, matching it line by line
• Party-wise receivables and payables lists from both systems
• Stock list with quantity and value per warehouse as of the cut-over date
• Sales and purchase registers from Tally up to the cut-over date and from the new system after it
• The HSN summary for the switch month from both systems, if the month is split
• A read-only copy of the Tally data for the year, kept for audit

Invoice numbering also deserves a word with your CA. As of October 2026, a GST invoice number can be up to 16 characters, using letters, numerals, hyphens and slashes, and must be unique within a financial year; a business may run more than one series. A new series that starts on the cut-over date, such as INV-2026-27-0001, keeps both systems' numbers apart.

How do you freeze the old period once you have switched?

Set an accounting lock date on the day before cut-over, so nothing can be posted into the period that Tally already closed. In SimpleERP the database refuses postings dated on or before the lock date, whichever screen they come from.

In Tally, stop posting on the same day and keep the company data read-only. If an old invoice needs a credit note later, issue it in the new system, so the customer's balance stays in one place.

How does SimpleERP handle the move from Tally and Excel?

SimpleERP gives each step of the switch its own tool. Setup seeds the chart of accounts, GST rates, units, roles and numbering. Settings → Import data brings in masters, opening stock, balances and open bills from Tally or spreadsheets, checked first and undoable, and posts the balancing line to Opening Balance Equity.

• Unlimited members, with seven ready-made roles and View, Manage and Approve permission levels.
• Posting an invoice writes the journal, the stock issue, the receivable and GST in one step.
• Stock is valued at weighted average cost, and the stock screen shows its value beside the Inventory account with the difference.
• Posted documents cannot be edited; cancellation reverses them, and the audit history records every change.
• One accounting lock date freezes the old period.

Read moving from Tally or Excel for the product side of the switch, or start a 7-day free trial and post a few test documents before you choose your date. For the cost per user, see pricing.