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
- We can Create New Stock Items In Tally
- We can Alter Stock Items in Tally
- 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
You can import Item master with HSN Code with HSN description
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