OFFICIAL BLOG

How to import sales vouchers from Excel to Tally

May 25, 2022, 7:53 am

How to import sales vouchers from Excel to Tally

 

Experience seamless integration of Excel data with Tally through XLTOOL, the ultimate software solution facilitating unlimited data import. Compatible with Tally 7.2, ERP 9, Tally Prime, and the latest versions, XLTOOL effortlessly imports all types of masters and voucher entries. Notably, it excels in importing sales voucher entries, whether with or without stock, streamlining your accounting processes effectively.

Introducing XLTOOL – Excel to Tally Prime utility, specifically designed to simplify the import of sales invoices with inventory invoice vouchers’ accounting entries into Tally. Within minutes, XLTOOL efficiently imports bulk Excel-format sales and voucher data into Tally, automating the import of voucher entry and master data, including ledgers and stock items. Its user-friendly features ensure smooth operation, making it accessible to users of all levels. Built on the Microsoft Excel platform, XLTOOL provides a comfortable working environment, enhancing user experience and efficiency.

 

Steps to import Sales Invoice Excel to Tally:

  1. Download the XLTOOL Excel to Tally Prime Utility from www.xltool.in/download.
  2. Open your Tally application company and set Tally application ODBC Port to 9005.
  3. Launch XLTOOL Utility.
  4. Select the Sales Voucher sheet template.
  5. Paste your data into the Voucher sheet.
  6. Press the F1 key for MENU.
  7. Click the START button.
  8. All Vouchers and Masters are imported into Tally.
  9. Process completed.

 

XLTOOL offers a convenient environment for entering data in Excel format and auto-exporting it to Tally, saving valuable time and ensuring accurate accounting. Simplify your accounting processes and maximize efficiency with XLTOOL.

Leave a Reply

Your email address will not be published. Required fields are marked *