" No Monthly Cost Pay Once Use Lifetime 100% Accuracy and Guaranteed Support " Tally Connect Software imports various types of vouchers like Sales Vouchers, Purchases Vouchers, Bank statements, Receipt Vouchers, Payment Vouchers, Journal Vouchers, E-Commerce, and Payroll Vouchers, and masters like Ledgers, Items, and Stock Journal into Tally Prime or Tally ERP9. How to import data from Excel to Tally Software? 1- Prepare your data in a template by copying & pasting or by smart mapping 2-Validate Ledger, Items, Vouchers & Auto Create using TallyConnect software 3- Select template & start importing. After successful import, check data in Tally
Read More No Monthly Cost Pay Once Use Lifetime
100% Accuracy and Guaranteed Support
Tally Connect Software imports various types of vouchers like Sales Vouchers, Purchases Vouchers, Bank statements, Receipt Vouchers, Payment Vouchers, Journal Vouchers, E-Commerce, and Payroll Vouchers, and masters like Ledgers, Items, and Stock Journal into Tally Prime or Tally ERP9.
How to import data from Excel to Tally Software?
1- Prepare your data in a template by copying & pasting or by smart mapping
2-Validate Ledger, Items, Vouchers & Auto Create using TallyConnect software
3- Select template & start importing. After successful import, check data in Tally
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)
How to import Item master
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