Excel to Tally Import Item Master

Whats is Item Master

Stock Item refers to goods that you manufacture or trade. It is the primary inventory entity and is the lowest level of information on your inventory. You have to create a Stock Item in Tally.ERP 9 for each inventory item that you want to account for. (ref Tally Solutions)

Whats to do with Stock Items

  1. We can Create New Stock Items In Tally 
  2. We can Alter Stock Items in Tally 
  3. We can Delete Stock Items in Tally 

How to import Item master data using
Excel-Tally Software in just a click 

Step 1- Put Data In Template Using Smart Mapping

Excel-Tally software provides you smart data mapping functionality, that helps you to copy all your data from your file to a template without any mistakes. 

or simply copy-paste your data column-wise from your sheet to the software template file.

Step 2- Now Select Item Master Template In Software & Click Import

Open Excel-Tally Software, it will shows you Dashboard here you can select company in which you want to import data.

Now All set just select template file in software using  ITEMS MASTER Button & Click on Import Button,

check the software dashboard it will show you Count of Items Records created.

check in tally all your records are imported successfully

follow Same 2 step to Alter Item master using Excel-Tally Software

You can Import Item Master with Following details

GST details

You can import Item master with HSN Code with HSN description 

Item Details

You can import Item Name with different types of Alias code , Part No

MRP & Standard Price

Your can import Stock item with MRP & Standard Price with Applicable date

Batch & MFG date

You can import item master with Batch, Godown & MFG dates 

GST rate details

You can import Item with Tax Rate, CGST, SGST, IGST & Applicable date 

Opening Quantity & Rate

Your can import import team master with Opening Quantity & Rate