How to Import stock journal from excel to tally
May 25, 2022, 7:57 amHow to Import Stock Journal from Excel to Tally
XLTOOL offers seamless integration between Excel and Tally, allowing users to import unlimited data effortlessly. Compatible with Tally 7.2, Tally ERP 9, Tally Prime, and the latest versions, this versatile software imports all types of masters and voucher entries with ease. Notably, XLTOOL excels in importing stock journal voucher entries, streamlining your accounting processes effectively.
Introducing XLTOOL – Excel to Tally Prime utility, designed specifically to simplify the import of stock journal vouchers’ accounting entries into Tally Prime. Within minutes, XLTOOL efficiently imports bulk Excel-format voucher data into Tally, automating the import of voucher entry and master data, including ledgers and stock items. Its intuitive interface and user-friendly features make it accessible to users of all levels, ensuring a seamless transition from Excel to Tally. Built on the Microsoft Excel platform, XLTOOL provides a comfortable working environment, enhancing user experience and efficiency.
Steps to import Stock Journal Excel to Tally:
- Download XLTOOL Excel to Tally from www.xltool.in/download.
- Open your Tally application company and set Tally application ODBC Port to 9005.
- Launch XLTOOL Utility.
- Select the Stock Journal sheet template.
- Paste your data into the Voucher sheet.
- Press the F1 key for MENU.
- Click the START button.
- Witness as all Vouchers and Masters are imported into Tally.
- Process completed.
XLTOOL provides a convenient environment for entering data in Excel format and auto-exporting it to Tally, saving valuable time and ensuring accurate accounting. With XLTOOL, streamline your accounting processes effortlessly and maximize efficiency.