Migrating from Excel or Tally ERP 9 to Tally Prime Without …

Many Bangladeshi Businesses have years of accounts sitting in Excel sheets or an old Tally ERP 9 installation. The thought of moving all of that into Tally Prime feels risky. One wrong step and you imagine losing sales records, party ledgers, or stock data you cannot rebuild. The good news is that migration to Tally Prime is one of the safest parts of switching Software, as long as you follow a clear process. This guide walks through both paths: moving from Tally ERP 9 and moving from Excel.

Why Migrate in the First Place

Tally ERP 9 stopped receiving major updates, and Tally Prime is now the active product with regular releases like 5.0. If you stay on ERP 9, you miss out on a faster interface, better banking features, improved reports, and easier multi-tasking. For a full comparison of what the newer version offers, see our guide on TallyPrime 5.0 new features.

There is also a cost angle. Support for old versions gets harder to find, and training new staff on outdated software wastes time. If you are budgeting for the switch, our Tally Prime price in Bangladesh guide breaks down Silver and Gold license costs.

What You Need Before You Start

Preparation is 80 percent of a safe migration. Keep these ready:

Item	Why It Matters
Full backup of ERP 9 data	Your safety net if anything goes wrong
Tally Prime installed and activated	The destination must be working first
Company name and financial year details	Migration asks for these
Admin username and password	Old data may be secured
Free disk space of at least 2 GB	Data files expand during conversion

Also write down your custom settings, such as voucher numbering styles or F11 configuration. Some settings carry over automatically, but noting them down means you can verify after migration.

Migrating from Tally ERP 9 to Tally Prime

Tally Solutions includes a built-in migration tool, so this path is mostly automatic.

Step 1: Take a backup. In ERP 9, go to Company > Backup and save the data folder to a pen drive or another drive. Never skip this, even if you are confident.

Step 2: Open Tally Prime and use the migrate option. Press Alt + Y > Migrate, then choose “From Tally ERP 9”. Select the company data folder you want to convert.

Step 3: Confirm the company selection. The tool lists companies found in that folder. Pick yours and press Enter to start.

Step 4: Wait for the conversion report. After migration, Tally Prime shows a summary of what converted successfully and what needs attention. Most companies convert fully. Occasionally a voucher type or old feature needs manual review.

Step 5: Verify your numbers. Open the migrated company and compare key reports against your ERP 9 records:

Trial balance totals
Balance sheet closing figures
Outstanding receivables and payables
Stock summary quantities and values

If these four match, your migration is essentially complete.

Common ERP 9 Migration Problems and Fixes

Most issues come from a small set of causes:

Problem	Usual Fix
Migration stops midway	Check disk space, close other programs, retry
Vouchers show errors after migration	Open the day book around those dates and correct manually
Stock values differ	Re-run stock valuation method settings from ERP 9 notes
Password protected data fails	Unlock or note credentials before migrating
Very old data versions	Update ERP 9 to its latest release first, then migrate

The last point matters more than people expect. If your ERP 9 release is many versions behind, update it to the final ERP 9 build before converting. This resolves most data format gaps.

Moving from Excel to Tally Prime

Excel is harder because Excel has no standard accounting structure. Two people’s sheets rarely look alike. There is no single-click import, so plan it in stages rather than trying to bring everything at once.

Stage 1: Bring opening balances only. Create masters in Tally Prime for ledgers, parties, and stock items, then enter opening balances as of a chosen date. Many businesses pick the start of a financial year. This alone gives you a running system.

Stage 2: Import masters using Excel to Tally. Tally Prime supports importing masters through XML, and third-party tools convert your Excel columns into import-ready files. Keep column names simple: name, group, opening balance, GST or BIN number if relevant.

Stage 3: Import historical transactions selectively. Ask yourself whether you truly need five years of transactions inside Tally. Usually you do not. Keeping old years in Excel as read-only archives while Tally holds the current year keeps things clean and fast.

Stage 4: Reconcile. Match bank balances, party outstanding, and stock quantities between Excel and Tally before you declare the switch done. Our bank reconciliation guide covers how to do this systematically.

A Safe Timeline for Small Businesses

Rushing migration during month-end or year-end creates stress. A simple schedule works better:

Week	Task
Week 1	Install Tally Prime, take backups, list masters
Week 2	Import or create masters, set opening balances
Week 3	Enter current month transactions, run parallel with old system
Week 4	Compare reports, fix gaps, cut over fully

Running both systems in parallel for two to four weeks is the single best protection against silent data loss.

When to Get Professional Help

DIY migration works well for straightforward books. Consider expert help if any of these apply: multiple years of company data, payroll history, complex stock with godowns and batch numbers, or customized ERP 9 setups with TDL modifications. An experienced team converts this in days instead of weeks and verifies every report line. Proper Way Solution handles ERP 9 to Tally Prime and Excel migrations for Bangladeshi businesses regularly, so we know exactly where data usually breaks.

FAQ

Will my old vouchers change dates or amounts after migration?

No. Migration preserves dates, amounts, and ledger references. Only formatting-related items like some voucher type settings may need a quick review afterward.

Can I keep using Tally ERP 9 alongside Tally Prime during transition?

Yes, and we recommend it. Run parallel for a few weeks, compare trial balances weekly, and stop using ERP 9 only when the numbers match.

How long does ERP 9 migration take?

A typical company data folder converts within minutes to an hour. Verification and correction add a few days for most businesses.

Is there a cost to migrate?

The built-in ERP 9 migration tool is free with your Tally Prime license. Excel imports may need a conversion tool or professional service depending on how messy your sheets are.

What if migration fails halfway?

Your original ERP 9 data stays untouched, which is why the backup-first rule exists. You can retry safely, and worst case restore from backup.

Moving your accounts should feel like upgrading a vehicle, not abandoning your luggage on the roadside. With a backup, a staged plan, and verification at every step, nothing gets left behind.

Ready to get started? Ready to move your books without losing a single entry? Contact Proper Way Solution for a guided Tally Prime migration today.