How to import Vouchers in Tally from Excel
How to Import Vouchers in Tally from Excel
Are you seeking a seamless method to import vouchers into Tally from Excel? Look no further! Our solution simplifies this process by generating Tally XML files directly from Excel data. Our online portal utility automates the creation of Tally XML files, making it effortless to import various types of vouchers into Tally — including sales, purchases, contra, receipts, payments, journals, and even bank statements.
With the increasing demand for efficient financial management, businesses often struggle to manually enter hundreds of voucher entries in Tally. This manual process is not only time-consuming but also prone to errors. Our tool eliminates this hassle by offering a user-friendly online platform to convert Excel data into Tally-ready XML files.

Import Excel to Tally vouchers
What Types of Vouchers Can Be Imported?
Using our Excel to Tally XML utility, you can import the following types of vouchers:
- Sales Vouchers: Item-wise, GST-inclusive or exclusive, with multiple line items
- Purchase Vouchers: Track supplier invoices, tax components, and inventory details
- Payment Vouchers: Record expense and payment entries made via cash or bank
- Receipt Vouchers: Enter received payments from customers or other parties
- Journal Entries: Adjustments, provisions, depreciation, and transfers
- Contra Entries: Cash withdrawals, deposits, and inter-bank transfers
- Bank Statements: Upload entire bank ledgers with narration and reconciliation-ready format
This all-in-one converter makes it easy for accountants, businesses, and firms to manage bulk voucher imports — saving time and improving accuracy.
Step-by-Step Guide to Importing Vouchers into Tally from Excel
- Visit Our Website: Begin by accessing our utility tool at
www.nikash.in. The tool is free, browser-based, and secure. - Download the Voucher Template: Download the Excel template from our site. It is designed to accommodate multiple voucher types with standard columns such as Date, Ledger Name, Voucher Type, Amount, Narration, GST, and more.
- Fill in the Data: Enter the voucher data into the Excel sheet. Ensure consistency in ledger names and voucher types to match those configured in your Tally company.
- Upload to Our Portal: After completing the sheet, upload your Excel file to our portal. The tool will validate the data structure and prepare it for conversion.
- Generate XML File: Click the “Generate XML” button to initiate the conversion process. The tool will automatically create an XML file formatted specifically for Tally’s import system.
- Download XML File: Once the conversion is done, download the XML file to your system. This file is now ready for import into Tally.
- Import into Tally: Open your Tally software and navigate to:
Gateway of Tally → Import Data → Vouchers. Select the downloaded XML file to begin the import. - Completion: That’s it! Your vouchers, including all types mentioned above, are now successfully imported into Tally. You can now verify them under their respective ledger and voucher type reports.
Why Choose Our Excel to Tally XML Converter?
- 100% Free: No hidden charges, no software installation required
- All Voucher Types Supported: Sales, purchases, contra, journal, receipts, and payments
- Auto Voucher Numbering: Continue sequence from Tally or use your Excel reference
- GST Compliant: Supports IGST, CGST, SGST, and HSN codes
- Secure: Your data is processed securely through encrypted channels
This tool is perfect for accountants, bookkeepers, data entry operators, and ERP integrators who handle regular or large-scale voucher imports into Tally.
Tips for Successful Import
- Ensure voucher types (like “Sales”, “Receipt”, etc.) exactly match those used in Tally
- Use consistent naming for ledger accounts (e.g., “Cash” not “cash”)
- Keep Excel date format as DD-MM-YYYY
- Avoid leaving mandatory columns blank (like Ledger Name, Amount, Date)
- Preview imported vouchers in Tally before finalizing them in books
Conclusion
Manually entering vouchers into Tally is a task of the past. With our intelligent Excel to Tally XML converter, you can import all types of vouchers with a few simple clicks — error-free, compliant, and fast.
Whether you’re digitizing your financials, migrating from another system, or just want to save time on repetitive entries, our tool is your go-to solution.
🚀 Try it now at www.nikash.in and revolutionize your Tally workflow!