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)
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.
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
You can import Item master with HSN Code with HSN description
You can import Item Name with different types of Alias code , Part No
Your can import Stock item with MRP & Standard Price with Applicable date
You can import item master with Batch, Godown & MFG dates
You can import Item with Tax Rate, CGST, SGST, IGST & Applicable date
Your can import import team master with Opening Quantity & Rate