Blog
Zoho CRM and Twilio Integration: Automated SMS Campaigns and Call Logging
Set up Zoho CRM and Twilio integration with Deluge custom functions for triggered SMS, call…
15 min read
Read article →
Migrating from Tally or a legacy ERP to NetSuite ERP for Indian mid-market is the most complex part of a NetSuite implementation for Indian businesses. It involves moving chart of accounts, open balances, transaction history, master data, and custom configurations while keeping the business running.
What Gets Migrated
A typical Tally-to-NetSuite migration includes:
- Chart of Accounts, map Tally ledger groups to NetSuite account types (Asset, Liability, Equity, Income, Expense)
- Customer and Vendor Masters, names, addresses, GSTINs, credit terms, contact details
- Item Masters, products, services, HSN/SAC codes, unit of measure, tax rates
- Opening Balances, trial balance as of the migration date
- Open Transactions, unpaid invoices, outstanding purchase orders, pending receipts
- Historical Data, optional; 1 to 3 years of transaction history for audit and comparison
Pre-Migration Data Cleanup
Before migrating, clean up your Tally data. Common issues:
- Duplicate ledger entries for the same customer with slightly different names
- Items with missing HSN codes that need to be added for GST compliance
- Unreconciled bank balances that need to be sorted before moving to NetSuite
- Old outstanding invoices from 2+ years ago that should be written off
Every data quality problem in Tally becomes a bigger problem in NetSuite. Fix it before migration, not after.
Migration Approach
Use a phased approach:
- Phase 1: Masters, migrate chart of accounts, customers, vendors, and items. Validate in NetSuite Sandbox.
- Phase 2: Opening balances, enter the trial balance as of the cutover date using journal entries.
- Phase 3: Open transactions, import unpaid invoices, open POs, and pending deliveries.
- Phase 4: Historical data, import 1 to 3 years of transactions if needed for audit trail.
Cutover Strategy
Choose a cutover date that aligns with a month-end or quarter-end. Run Tally and NetSuite in parallel for 2 to 4 weeks. During parallel run, enter transactions in both systems and reconcile at month-end. Once the reconciliation matches, switch to NetSuite only.
Common Migration Pitfalls
- Underestimating data cleanup time (budget 30% to 40% of migration effort for cleanup)
- Not validating imported data in Sandbox before production cutover
- Forgetting to migrate pending GST credits and TDS balances
- Not training users before go-live, leading to data entry errors in the first week
Frequently Asked Questions
How long does a Tally to NetSuite migration take?
4 to 8 weeks for data migration alone. This includes data extraction from Tally, cleanup, mapping, import into NetSuite Sandbox, validation, and production cutover. The total implementation including configuration and training is 3 to 6 months.
Can I import Tally data directly into NetSuite?
Not directly. Export Tally data as XML or CSV using Tally’s export tools, transform the data to match NetSuite’s import format (CSV templates or SuiteScript), and import via NetSuite’s CSV Import tool or a migration script. A partner like Aaxonix handles the transformation logic.
Do I need to migrate all historical transactions?
No. Most companies migrate opening balances and open transactions only. Historical transactions (closed invoices, past journal entries) are kept in Tally for reference. Migrate 1 to 3 years of history only if you need it for audit or trend analysis in NetSuite.
What about GST credit balances during migration?
Carry forward your CGST, SGST, and IGST credit balances as opening balances in NetSuite. These must match your GST portal balances exactly. Verify the numbers with your CA before entering them in NetSuite to avoid compliance issues.
