How to import sales vouchers from Excel to Tally

🗓 May 25, 2022 | 📂 Uitlity

How to Import Sales Vouchers from Excel to Tally

Importing sales vouchers manually into Tally can be a tedious and time-consuming task, especially for businesses that deal with high volumes of daily sales. However, with the help of an efficient Excel-to-Tally integration tool like XLTOOL, you can eliminate repetitive manual entries and reduce human errors. This utility offers a fast and accurate method of importing bulk sales data directly from Excel into Tally, thereby simplifying your accounting process.

XLTOOL is compatible with all major Tally versions including Tally 7.2, Tally ERP 9, and Tally Prime. It provides a seamless way to handle accounting data such as ledgers, vouchers, stock items, and especially sales invoices. Whether your sales invoice includes stock items or is a service invoice without inventory, XLTOOL can handle it with ease.

The tool is built entirely on the Microsoft Excel platform, allowing users to work in a familiar interface. This greatly improves productivity, as most users are already comfortable using Excel. The data is filled in a predefined Excel template, and with a simple click, the entire batch of sales vouchers can be sent to Tally using its ODBC connection.

Why Import Sales Vouchers from Excel?

Businesses frequently record sales transactions that include customer names, stock items, quantities, rates, taxes, and ledger postings. Manually entering each invoice into Tally is not only slow but also susceptible to typographical errors.

By using Excel to prepare your sales data, you get a clear overview of all your entries, can apply Excel formulas, verify totals, and prepare hundreds of invoices in one go. Once ready, XLTOOL helps push the entire set into Tally without having to enter them individually.

This automation not only saves time but also improves the accuracy and consistency of your accounting records.

Key Features of XLTOOL

Supports Tally 7.2, ERP 9, and Tally Prime.
Imports bulk sales vouchers from Excel into Tally.
Supports both inventory and non-inventory invoices.
Imports master data like ledgers, stock items, and units if needed.
Simple and user-friendly Excel-based interface.
Data validation to avoid common import errors.

Fields You Can Import in Sales Vouchers

The sales voucher template supports several important fields to ensure a complete import:

Invoice Number
Date of Sale
Customer Ledger
Stock Item Name
Quantity
Rate
Amount
Tax Ledgers (CGST, SGST, IGST)
Narration
Place of Supply
Voucher Type

You can enter these details in Excel as per the sample format provided with XLTOOL.

Steps to Import Sales Invoice Excel to Tally

Follow these steps to easily import your sales invoices from Excel:

Download XLTOOL Excel to Tally Prime utility from www.xltool.in/download.
Open your Tally company and confirm that the ODBC port is set to 9005.
Launch the XLTOOL file (ensure macros are enabled in Excel).
Select the “Sales Voucher” template sheet.
Paste your sales data in the appropriate format in the template.
Verify all details and correct any missing values.
Press the F1 key to access the main menu of XLTOOL.
Click the START button to begin the import process.
Wait for the success message. Your sales vouchers are now visible in Tally.

Best Practices

To ensure a smooth import process, keep the following tips in mind:

Make sure all customer and item masters are already created in Tally. If not, XLTOOL can import them beforehand.
Check for spelling consistency between Excel and Tally for ledger and item names.
Use proper date formats (DD-MM-YYYY) to avoid import errors.
Backup your Tally data before starting the import.
Double-check amounts and tax entries for accuracy.

Who Can Use This?

The Excel to Tally import process is helpful for:

Retail businesses with daily sales bills.
Wholesalers and distributors processing bulk invoices.
Online sellers exporting data from platforms like Amazon or Flipkart.
Service providers raising periodic invoices.
Accounting professionals handling client records in Tally.

Conclusion

Manually creating every sales voucher in Tally can take hours or even days for businesses with high transaction volumes. XLTOOL simplifies this by providing a direct Excel-to-Tally import path that is fast, efficient, and error-free. It empowers accountants and business owners to manage sales data with greater accuracy and speed.

Whether you run a large enterprise or a small business, integrating your Excel sales records into Tally through XLTOOL can transform your accounting process. With just a few simple steps, you can shift from tedious manual entry to smart automation — saving time and reducing mistakes.

Download XLTOOL today and start importing your sales vouchers the smart way!