How to import stock item in Tally from Excel

🗓 May 25, 2022 | 📂 Uitlity

How to Import Stock Item in Tally from Excel

Managing stock items in Tally is a core part of inventory and accounting operations. However, manually creating stock item masters one by one in Tally can be time-consuming, especially when dealing with hundreds or thousands of items. That’s where Excel-based import utilities like XLTOOL become extremely helpful. XLTOOL is a smart Excel to Tally migration utility that allows users to import bulk master stock items from Excel directly into Tally with ease and accuracy.

Whether you’re a business owner, accountant, or data entry operator, XLTOOL helps simplify the task by offering a user-friendly, Excel-based interface that requires no programming skills. It supports all major Tally versions including Tally 7.2, ERP 9, Tally Prime, and future releases. With this tool, you can import item names, aliases, stock groups, categories, units of measure, godowns, HSN codes, tax rates, GST details, and more.

Why Import Stock Items from Excel to Tally?

Businesses that deal with inventory need a fast and error-free way to manage stock items in Tally. Manually adding each item can lead to mistakes, take significant time, and reduce productivity. Importing stock item master data from Excel provides several benefits:

Speed: Bulk import saves countless hours of data entry.
Accuracy: Reduces human error by using pre-validated Excel sheets.
Consistency: Ensures all stock item fields follow the same format and structure.
Easy Updates: Easily update or re-import data when needed.

What is XLTOOL?

XLTOOL is an Excel macro-based utility that allows users to send data directly from Excel to Tally. It uses Tally’s ODBC connection (default port 9005) to communicate between Excel and Tally software. Because it’s built within Microsoft Excel, there’s no need to learn any complicated software interface — everything works inside a familiar spreadsheet.

With XLTOOL, you can import master stock items, ledgers, cost centres, and more. It comes with ready-made templates, and users just need to copy their data into the provided columns. Once data is pasted, the tool validates it and sends it to Tally in just a few clicks.

Fields You Can Import

Using the Master Stock Item template, you can import the following fields into Tally:

Stock Item Name
Alias (Alternate Name)
Stock Group
Stock Category (optional)
Unit of Measure
Godown (Storage location)
HSN Code
GST Rate (%)
Taxability (Taxable/Exempt/Nil Rated)
Opening Balance (Qty and Value)

These fields ensure that your stock item records are complete and fully compliant with taxation rules.

Steps to Import Master Stock Items from Excel to Tally

Follow these simple steps to begin importing your stock data from Excel to Tally:

Download XLTOOL from www.xltool.in/download.
Open your Tally company and ensure ODBC is enabled on port 9005. You can do this from the Tally settings menu.
Open the XLTOOL Excel file (macro-enabled Excel file).
Select the “Master Stock” template from the available options.
Copy and paste your stock item data into the provided sheet. Make sure the column headings match the required format.
Press F1 to open the tool menu in XLTOOL.
Click the START button to begin importing data to Tally.
Wait for the import to complete. The tool will show you the number of records successfully transferred.
Open Tally and verify that the stock items have been imported correctly.

Tips for Accurate Import

Ensure that each stock item name is unique. Tally does not allow duplicate names in masters.
Make sure all required fields (like Unit, Group, GST) are filled properly in Excel before import.
Validate the GST rates and HSN codes to ensure tax compliance.
If importing to a company with multiple godowns, be sure to assign the correct godown for each item.
Back up your Tally data before importing, especially if it’s the first time.

Use Cases of XLTOOL for Stock Import

Here are common use cases where XLTOOL is extremely useful:

New Company Setup: When starting a new business or creating a new company in Tally, import all item masters in one go.
Seasonal Product Updates: For businesses dealing with seasonal or changing inventories, use Excel to prepare and update stock items periodically.
Wholesale and Distribution: Large number of SKUs can be managed more effectively by using Excel imports.
Retail and E-commerce: Quickly synchronize stock lists from websites or POS systems by exporting to Excel and then importing into Tally.

Conclusion

Using XLTOOL to import stock items from Excel to Tally is an efficient and error-free way to manage inventory master data. It removes the burden of manual entry and helps maintain a clean and accurate database in Tally. Whether you’re onboarding new products, switching software, or streamlining operations, XLTOOL can save you time and effort.

Download the tool, follow the steps, and take full control of your stock master data in Tally. It’s fast, easy, and requires no technical expertise. Start now to improve your inventory management process.