How to Import stock journal from excel to tally

🗓 May 25, 2022 | 📂 Uitlity

How to Import Stock Journal from Excel to Tally

Importing stock journal entries into Tally from Excel can save a significant amount of time for businesses that deal with large volumes of inventory movements. Stock journals are commonly used in Tally for transferring stock between godowns, recording production, or adjusting inventory quantities. However, entering these transactions manually one by one in Tally can be both time-consuming and error-prone.

To address this, XLTOOL – an Excel to Tally utility – offers a seamless way to import stock journal vouchers directly from Excel to Tally. Whether you use Tally 7.2, Tally ERP 9, or Tally Prime, XLTOOL supports all versions and simplifies your data migration process.

What is XLTOOL?

XLTOOL is an Excel-based utility designed to help users transfer data from Excel spreadsheets into Tally without manual re-entry. It is especially helpful for accountants, inventory managers, and business owners who frequently work with stock journal vouchers. Built entirely on Microsoft Excel, this tool eliminates the need for complex software or coding knowledge.

With a clean, familiar spreadsheet layout, XLTOOL allows you to enter or copy-paste your voucher data into specific templates. Once the data is ready, the tool connects with your open Tally company and imports everything in just a few clicks using Tally’s ODBC (Open Database Connectivity) protocol.

Benefits of Importing Stock Journal via Excel

There are several benefits to using XLTOOL for stock journal import:

Time-Saving: Bulk import avoids manual entry of each voucher.
Error Reduction: Excel-based data entry allows easy review before import.
Flexibility: Supports different types of stock journal entries like production, consumption, transfers, etc.
Customization: You can tailor the Excel template based on your business needs.
Compatibility: Works with all major Tally versions.

What Are Stock Journal Vouchers?

In Tally, a stock journal is used for:

Transferring stock between different godowns or warehouses.
Recording production and consumption of raw materials and finished goods.
Making stock adjustments for excess or shortage.
Handling inter-location movement of goods.

Using XLTOOL, you can create these vouchers in Excel and send them directly to Tally without manually entering each one.

Fields You Can Import with Stock Journal

The stock journal template in XLTOOL allows you to import the following fields:

Voucher Number
Date
Particulars (Narration)
Godown (Source and Destination)
Stock Item Name
Quantity
Rate
Value
Units of Measure
Ledger Name (if cost impact is to be recorded)

All these fields are presented in an easy-to-understand Excel format.

Steps to Import Stock Journal from Excel to Tally

Follow these steps to successfully import stock journal vouchers:

Download XLTOOL Excel to Tally utility from www.xltool.in/download.
Open your Tally company and set the ODBC port to 9005.
Launch the XLTOOL Excel file (make sure macros are enabled).
Select the “Stock Journal” sheet from the available templates.
Paste your stock journal data into the provided format.
Review your data for completeness and accuracy.
Press F1 to open the tool menu in Excel.
Click the START button to begin the import process.
Wait for the tool to show confirmation of successful import.
Open Tally and verify your vouchers under “Display > Daybook” or “Display > Inventory Books”.

Common Use Cases

Businesses across different sectors use stock journal vouchers for different reasons:

Manufacturers: To record raw material consumption and finished goods production.
Retail Chains: For transferring stock between branches or warehouses.
Wholesale Traders: To manage stock adjustments for bulk goods.
Warehousing Companies: For internal transfers and godown movement.

All these tasks become easier and faster when automated using Excel imports.

Tips for a Smooth Import

To ensure your import process goes smoothly, follow these tips:

Always back up your Tally company data before importing.
Double-check Excel data for errors or blanks.
Ensure all required masters (like stock items, units, and godowns) are already created in Tally.
If masters don’t exist, you can import them first using the XLTOOL master templates.
Use the same spelling and case in Excel as used in Tally to avoid mismatch errors.

Conclusion

Importing stock journal entries from Excel to Tally using XLTOOL is a reliable, accurate, and time-saving method for managing your inventory transactions. It helps eliminate manual data entry, reduces errors, and allows businesses to focus on productivity rather than repetitive tasks. Whether you are handling transfers, production, or stock adjustments, XLTOOL is a valuable companion for your accounting and inventory needs.

By adopting this tool, you can optimize your workflow, enhance reporting accuracy, and maintain a cleaner data structure in Tally. Start today by downloading XLTOOL and transforming how you manage stock journals in your business.