Skip to main content

Data Migration Guide

Overview​

Our platform enables seamless data migration from your existing systems (Tally, Zoho, Excel spreadsheets, or other accounting software) to get you operational within 2-4 weeks. This guide covers the step-by-step process for migrating your master data and transaction records.

What Can Be Migrated​

Master Data (CSV format)

  • Item Master (products/services)
  • Customer Master
  • Supplier Master

Transaction Data (Excel format)

  • Sales Invoices
  • Purchase Bills

Migration Timeline​

  • Master Data Setup: 1-3 days
  • Transaction Data Upload: 3-7 days
  • Validation & Testing: 3-5 days
  • Go-Live: 2-4 weeks (including configuration)

Before You Start​

Prerequisites​

  1. Data Backup: Export and backup all data from your current system
  2. Data Cleanup: Review and clean duplicate/incorrect records
  3. System Access: Ensure admin access to the platform
  4. Template Download: Download CSV/Excel templates from the migration section

Important Guidelines​

  • Master data must be uploaded before transaction data
  • Upload sequence: Items → Customers/Suppliers → Invoices/Bills
  • Keep original export files as backup
  • Test with small data samples first (10-20 records)

Data Preparation Checklist​

  • Remove duplicate entries
  • Standardize naming conventions
  • Verify contact information (emails, phone numbers)
  • Check for special characters in names/descriptions
  • Ensure all mandatory fields have values
  • Validate GST/Tax registration numbers
  • Review and update pricing information

Master Data Migration​

Item Master Migration​

The Item Master contains all your products, services, and inventory items.

CSV File Structure

Required fields:

  • item_code - Unique identifier for the item
  • item_name - Display name
  • item_type - Product/Service/Asset
  • unit - Unit of measurement (pcs, kg, ltr, etc.)

Optional fields:

  • hsn_code - HSN/SAC code for tax classification
  • category - Item category/group
  • description - Detailed description
  • purchase_rate - Default purchase price
  • sales_rate - Default selling price
  • opening_stock - Initial stock quantity
  • reorder_level - Minimum stock level
  • gst_rate - Applicable GST percentage (0, 5, 12, 18, 28)
  • status - Active/Inactive

Best Practices

  • Use consistent item codes (avoid spaces, use alphanumeric)
  • Include HSN codes for GST compliance
  • Specify correct item type for accurate reporting
  • Set reorder levels for inventory items

Customer Master Migration​

Customer records with contact and billing information.

CSV File Structure

Required fields:

  • customer_code - Unique customer identifier
  • customer_name - Business/individual name
  • customer_type - Business/Individual
  • email - Primary email address
  • phone - Contact number

Optional fields:

  • gstin - GST registration number (for B2B customers)
  • billing_address - Complete billing address
  • shipping_address - Delivery address (if different)
  • city - City name
  • state - State name (for GST)
  • pincode - Postal code
  • credit_limit - Maximum credit allowed
  • credit_days - Payment terms in days
  • opening_balance - Outstanding balance to carry forward
  • pan_number - PAN for TDS purposes
  • contact_person - Primary contact name
  • status - Active/Inactive

Best Practices

  • Validate GSTIN format (15 characters)
  • Include state codes for accurate GST calculation
  • Set credit limits to manage receivables
  • Ensure email validity for automated communications

Supplier Master Migration​

Vendor and supplier information for purchase management.

CSV File Structure

Required fields:

  • supplier_code - Unique supplier identifier
  • supplier_name - Business name
  • email - Primary email address
  • phone - Contact number

Optional fields:

  • gstin - GST registration number
  • address - Complete address
  • city - City name
  • state - State name (for GST)
  • pincode - Postal code
  • payment_terms - Default payment terms
  • credit_days - Standard payment days
  • opening_balance - Outstanding payable to carry forward
  • pan_number - PAN for TDS
  • contact_person - Primary contact name
  • bank_name - For payment processing
  • bank_account - Account number
  • ifsc_code - Bank IFSC code
  • status - Active/Inactive

Best Practices

  • Maintain accurate banking details for payments
  • Include PAN for TDS compliance
  • Set standard payment terms per supplier
  • Verify GSTIN with actual supplier records

Transaction Data Migration​

Sales Invoice Migration​

Historical sales invoices for accurate reporting and customer statements.

Excel File Structure

Required fields:

  • invoice_number - Unique invoice number
  • invoice_date - Date of invoice (DD-MM-YYYY)
  • customer_code - Must exist in Customer Master
  • item_code - Must exist in Item Master
  • quantity - Quantity sold
  • rate - Selling price per unit
  • amount - Line item total (quantity × rate)

Optional fields:

  • discount_percentage - Discount %
  • discount_amount - Discount value
  • cgst_rate - Central GST %
  • cgst_amount - Central GST value
  • sgst_rate - State GST %
  • sgst_amount - State GST value
  • igst_rate - Integrated GST %
  • igst_amount - Integrated GST value
  • cess_rate - Cess %
  • cess_amount - Cess value
  • taxable_amount - Amount before tax
  • total_amount - Final invoice total
  • payment_status - Paid/Unpaid/Partial
  • due_date - Payment due date
  • place_of_supply - State code for GST
  • remarks - Additional notes

Important Notes

  • One row per invoice line item (multi-line invoices need multiple rows)
  • All customer_code and item_code must pre-exist in masters
  • Tax calculations should be pre-computed
  • Maintain original invoice numbering for audit trail

Purchase Bill Migration​

Historical purchase bills and vendor invoices.

Excel File Structure

Required fields:

  • bill_number - Supplier's bill/invoice number
  • bill_date - Date of bill (DD-MM-YYYY)
  • supplier_code - Must exist in Supplier Master
  • item_code - Must exist in Item Master
  • quantity - Quantity purchased
  • rate - Purchase price per unit
  • amount - Line item total (quantity × rate)

Optional fields:

  • our_reference - Internal reference number
  • discount_percentage - Discount %
  • discount_amount - Discount value
  • cgst_rate - Central GST %
  • cgst_amount - Central GST value
  • sgst_rate - State GST %
  • sgst_amount - State GST value
  • igst_rate - Integrated GST %
  • igst_amount - Integrated GST value
  • cess_rate - Cess %
  • cess_amount - Cess value
  • taxable_amount - Amount before tax
  • total_amount - Final bill total
  • payment_status - Paid/Unpaid/Partial
  • due_date - Payment due date
  • tds_rate - TDS deduction %
  • tds_amount - TDS deducted
  • remarks - Additional notes

Important Notes

  • One row per bill line item
  • Supplier_code and item_code must exist in masters
  • Include TDS information for compliance
  • Maintain supplier's original bill numbering

Migration Process​

Step 1: Download Templates​

  1. Login to your account
  2. Navigate to Utilities → Bulk Import
  3. Download CSV templates for master data
  4. Download Excel templates for transaction data
  5. Save templates in a dedicated migration folder

Step 2: Prepare Master Data​

  1. Export data from your current system

    • From Tally: Gateway of Tally → Display → Statements of Accounts → Export to Excel
    • From Zoho: Reports → Export → Select CSV/Excel
    • From Excel: Organize into template format

  2. Map data to templates

    • Open downloaded CSV template
    • Copy-paste data from your export
    • Match column headers exactly as in template
    • Fill mandatory fields for all records

  3. Validate data

    • Check for duplicate codes
    • Verify email formats
    • Remove special characters from codes
    • Ensure numeric fields contain numbers only

Step 3: Upload Master Data​

Upload Sequence (Important)

  1. Upload Item Master first

    • Go to Inventory → Items → Import
    • Click "Choose File" and select Item Master CSV
    • Click "Validate Data"
    • Review validation report
    • Fix any errors in CSV and re-upload
    • Click "Import" once validation passes

  2. Upload Customer Master

    • Go to Sales → Customers → Import
    • Follow same process as Item Master
    • Verify all records imported successfully

  3. Upload Supplier Master

    • Go to Purchases → Suppliers → Import
    • Follow same process
    • Confirm all suppliers are active

Step 4: Prepare Transaction Data​

  1. Start with recent financial year

    • Recommended: Current year + previous year
    • Older data can be maintained in archives

  2. Organize transaction files

    • Separate files for invoices and bills
    • One Excel file per document type (recommended)
    • Ensure all customer/supplier/item codes exist in masters

  3. Validate references

    • Cross-check customer codes in invoice file exist in Customer Master
    • Cross-check supplier codes in bill file exist in Supplier Master
    • Cross-check item codes exist in Item Master

Step 5: Upload Transaction Data​

Upload Invoices

  1. Go to Sales → Invoices → Import
  2. Upload Sales Invoice Excel file
  3. System validates:
    • Customer codes exist
    • Item codes exist
    • Date formats are correct
    • Mandatory fields are filled
    • Tax calculations are accurate
  4. Review validation report
  5. Fix errors and re-upload if needed
  6. Click "Import" to finalize

Upload Bills

  1. Go to Purchases → Bills → Import
  2. Upload Purchase Bills Excel file
  3. System validates similar to invoices
  4. Review and confirm import

Step 6: Post-Migration Verification​

After successful upload, verify:

Master Data Checks

  • Total item count matches source system
  • All customers are searchable
  • All suppliers are visible
  • Opening balances are correct
  • Contact information is accurate

Transaction Data Checks

  • Invoice count matches source
  • Bill count matches source
  • Total sales amount matches
  • Total purchase amount matches
  • Outstanding receivables match
  • Outstanding payables match
  • Tax summaries are accurate

Financial Verification

  • Opening balances reconciled
  • Customer outstanding statements verified
  • Supplier outstanding statements verified
  • Inventory valuation matches (if applicable)

Validation & Troubleshooting​

Common Validation Errors​

Error: Duplicate Code Found

  • Cause: Same item_code/customer_code/supplier_code exists multiple times
  • Solution: Make codes unique; use suffixes like -01, -02 if needed

Error: Invalid Email Format

  • Cause: Email doesn't contain @ or has invalid characters
  • Solution: Correct email format or leave blank if not available

Error: Customer/Supplier/Item Not Found

  • Cause: Referenced code doesn't exist in master data
  • Solution: Upload master data first, or correct the code in transaction file

Error: Invalid Date Format

  • Cause: Date not in DD-MM-YYYY format
  • Solution: Format all date columns as DD-MM-YYYY in Excel before saving

Error: Invalid GST Number

  • Cause: GSTIN not in 15-character format
  • Solution: Verify GSTIN format: 2-digit state + 10-digit PAN + entity code + checksum

Error: Mandatory Field Missing

  • Cause: Required field is empty
  • Solution: Fill all mandatory fields marked with * in template

Error: Invalid Numeric Value

  • Cause: Text in numeric fields (quantity, rate, amount)
  • Solution: Ensure numeric fields contain only numbers

Tips for Smooth Migration​

  1. Start Small: Test with 10-20 records first
  2. One Type at a Time: Don't mix multiple master types in one file
  3. Clean Before Upload: Fix data quality issues in source before migration
  4. Keep Backups: Save original files before making changes
  5. Document Custom Fields: Note any custom mappings for future reference
  6. Verify Incrementally: Check each master upload before moving to next

Getting Help​

If you encounter issues during migration:

  1. Check Validation Report: Detailed error messages with row numbers
  2. Export Error Log: Download error file showing specific issues
  3. Contact Support: Email support with:
    • Screenshot of error
    • Sample data file (first 10 rows)
    • Description of what you're trying to migrate

Post-Migration Checklist​

Immediate Actions​

  • Run system health check from dashboard
  • Generate trial balance and verify opening balances
  • Print sample customer statement and verify
  • Print sample supplier statement and verify
  • Check inventory stock report (if applicable)
  • Verify GST summary reports
  • Test creating a new invoice/bill to ensure system is working

Configuration Tasks​

  • Set up tax rates (if not migrated)
  • Configure invoice/bill numbering for new transactions
  • Set up payment terms templates
  • Configure email templates for customer communications
  • Set up user roles and permissions
  • Configure report preferences

Training & Rollout​

  • Train staff on new system
  • Create internal documentation for your specific workflows
  • Set up backup schedules
  • Schedule go-live date
  • Inform customers/suppliers about system change (if needed)

Data Migration Best Practices​

Before Migration​

  1. Clean Your Data: Remove duplicates, fix errors, standardize formats
  2. Decide Migration Scope: Choose which historical data to migrate
  3. Plan Migration Window: Schedule during low-business activity period
  4. Assign Responsibilities: Designate who handles each data type

During Migration​

  1. Follow Sequence: Always masters before transactions
  2. Validate Continuously: Check each upload before proceeding
  3. Document Issues: Keep log of errors and resolutions
  4. Take Breaks: Don't rush; accuracy is more important than speed

After Migration​

  1. Parallel Run: Run both old and new systems for 1-2 weeks
  2. Daily Reconciliation: Compare reports between systems
  3. User Feedback: Collect issues from team members
  4. Incremental Fixes: Address data issues as discovered

Data Retention​

  • Master Data: Migrate all active records + recently inactive
  • Transaction Data: Minimum 2 financial years recommended
  • Archives: Keep older data in source system for reference

Need Help?​

Our migration support team is available to assist you:

  • Email Support: support@yourplatform.com
  • Migration Assistance: For complex migrations, we offer guided migration service
  • Documentation: Check our knowledge base for detailed field descriptions
  • Video Tutorials: Watch step-by-step migration videos in the Help Center

Estimated Timeline: Most SMEs complete full migration within 2-4 weeks, including testing and validation.

Last Updated: [Date]
Version: 1.0