Saturday, October 21, 2017

Map excel and import in Tally ERP 9

How to map your excel file and import it into Tally ERP 9?

Here's a video on how to map excel file and import it in Tally ERP 9

For reference, the steps are given underneath :

Steps to Map your Excel file
  1. Start udi-Magic converter
  2. Select the option Excel to Tally > Create a Custom template
  3. Select the files :
    • udi-Magic Standard Excel template
    • Your Excel file
  4. Map the columns
  5. Save the Mapping file

Steps to Import data into Tally
  1. Start Tally ERP 9 and Open a Company.
  2. Start udi-Magic software.
  3. Select the option Excel to Tally > Import data into Tally.
  4. Select the files
    • Your Excel file
    • Xml file (Mapping file generated in the mapping process)
  5. Click the Start button.

No comments: