Follow the below steps to import Bill of Material (BOM) Data from Excel to Tally.ERP9.

  1. Login to your existing account or Signup a Free Account on
  2. Add a Company in which you want to import data, Company name should be the same as per the company name in Tally
  3. Download our Sample Bill of Material Template and fill your data in the respective columns
  4. Once your data is ready as per our template, upload and process the same
  5. Once data process is completed, you will get Tally XML for download
  6. Now, Go to Tally > Open Tally Company > Import Data > Masters > Give the complete XML file path and press enter to import all your data to Tally

By following these steps you can easily import product Bill of Material data in Tally without impacting your other data.

In case if your data is not imported as expected then please check the message displayed in the calculator panel or in Tally.IMP file, if you are unable to resolve the error, you may get in touch with our professional support executive on +91 7710010372 / 73 / 74 or drop an email on

Good Luck!

Download Bill of Material Template


Send download link to:

You might be interested in our other Products / Services