Convert Excel to Tally XML Vouchers
Turn your Excel transaction data into Tally XML vouchers — import directly into TallyPrime or Tally ERP 9 without manual voucher entry.
For TallyPrime and Tally ERP 9. Free online — no signup.
How It Works
Upload Your Excel File
XLSX or XLS with transaction data. Date, amount, and description columns auto-detected.
Mapped to Tally XML
Rows converted to XML voucher entries with ledger names, amounts, and dates in YYYYMMDD format.
Download XML
Import via Gateway of Tally > Import Data > Vouchers in TallyPrime or Tally ERP 9.
Tally Voucher Types We Generate
Payment Voucher
Cash or bank payments — expenses, vendor payments, utility bills
Receipt Voucher
Cash or bank receipts — income, customer payments, refunds
Contra Voucher
Fund transfers — bank to bank, cash deposit, ATM withdrawal
Journal Voucher
Adjustment entries — depreciation, provisions, corrections
How to Import XML into Tally
TallyPrime
- Gateway of Tally > Import Data
- Select Vouchers
- Enter XML file path
- Click Import — verify in Day Book
Tally ERP 9
- Gateway of Tally > Import Data
- Select Vouchers
- Browse to XML file location
- Import — check Day Book for entries
What the XML Looks Like
<ENVELOPE>
<HEADER>
<TALLYREQUEST>Import Data</TALLYREQUEST>
</HEADER>
<BODY>
<IMPORTDATA>
<REQUESTDESC>
<REPORTNAME>Vouchers</REPORTNAME>
</REQUESTDESC>
<REQUESTDATA>
<TALLYMESSAGE>
<VOUCHER VCHTYPE="Payment" ACTION="Create">
<DATE>20260315</DATE>
<NARRATION>Office Supplies</NARRATION>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>Office Expenses</LEDGERNAME>
<AMOUNT>-4500.00</AMOUNT>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>HDFC Bank</LEDGERNAME>
<AMOUNT>4500.00</AMOUNT>
</ALLLEDGERENTRIES.LIST>
</VOUCHER>
</TALLYMESSAGE>
</REQUESTDATA>
</IMPORTDATA>
</BODY>
</ENVELOPE>Dates in YYYYMMDD format. Debit and credit must balance to zero.
What is Excel?
Microsoft Excel Spreadsheet (XLSX/XLS)
Rows and columns of transaction data. Tally can't import Excel directly — it needs XML voucher format.
What is Tally XML?
Tally XML Voucher Format
ENVELOPE > TALLYMESSAGE > VOUCHER structure with ledger entries, YYYYMMDD dates, and debit/credit amounts. Imports via Gateway of Tally.
Why This Tool
Auto Column Detection
Date, amount, and description columns detected automatically — no manual mapping.
Voucher Type Mapping
Payment, Receipt, Contra, and Journal vouchers created based on debit/credit patterns.
YYYYMMDD Dates
Excel dates converted to Tally's required YYYYMMDD format automatically.
Ledger Entries
Debit and credit ledger entries structured correctly in XML for balanced vouchers.
TallyPrime + ERP 9
Same XML format works with both TallyPrime and Tally ERP 9.
XLS + XLSX
Both modern (.xlsx) and legacy (.xls) Excel formats supported.
When to Use This
Bulk Voucher Entry
Skip manual data entry. Convert hundreds of Excel transactions to Tally vouchers in one import.
Bank Statement Import
Downloaded your bank statement as Excel? Convert to Tally XML and import as payment/receipt vouchers.
CA / Accountant Workflow
Clients send data in Excel. Convert to Tally XML and import instead of re-entering every transaction.
Excel-to-Tally Issues & Fixes
"Ledger not found" error on import
Ledger names are case-sensitive in Tally. "HDFC Bank" and "hdfc bank" are different. Verify exact names in your Chart of Accounts before importing.
Vouchers not appearing in Day Book after import
Check the Tally.imp log file for errors. Common cause: date outside the current accounting period. Ensure your voucher dates fall within the open period.
Amounts don't balance — import rejected
Every voucher must have equal debit and credit totals. If your Excel has a single amount column, the converter creates the balancing entry automatically.
Wrong voucher type assigned
Voucher type is determined by the debit/credit pattern. If the auto-detection doesn't match your intent, verify your amount signs (positive = credit, negative = debit).
Frequently Asked Questions
Which Tally versions are supported?
Both TallyPrime and Tally ERP 9. The XML voucher format is compatible with both.
What voucher types does it create?
Payment, Receipt, Contra, and Journal vouchers based on your transaction data. The voucher type is determined by the debit/credit pattern.
Do ledger names need to match exactly?
Yes. Tally matches ledger names case-sensitively. If the ledger in your XML doesn't exist in Tally, you'll get an import error. Create ledgers in Tally first, or include them in the XML.
What date format does Tally XML use?
YYYYMMDD (e.g., 20260315 for March 15, 2026). Our converter handles this automatically from your Excel dates.
Do I need specific column names?
No. Date, amount, and description columns are auto-detected regardless of header naming.
XLTOOL and Quick2Tally charge for this. Is it free?
Yes. No desktop install, no Tally connection required, no per-voucher charges. Fully free in your browser.
Can I import sales and purchase vouchers?
The converter creates standard accounting vouchers (Payment, Receipt, Contra, Journal). For sales/purchase with GST and inventory, use Tally's built-in import or a dedicated tool like XLTOOL.
Is my data secure?
Encrypted via TLS, processed in memory, never stored. Your file is deleted immediately after conversion.
Related Tools
CSV to Tally XML
Convert CSV financial files to Tally-compatible XML for Tally ERP 9 and TallyPrime. Maps rows to voucher entries. Free, instant, no signup required.
Convert now →PDF to Tally XML
Convert bank statement PDFs to Tally XML vouchers for Tally ERP 9 and TallyPrime. AI maps transactions from any bank. Free online, no signup.
Convert now →Excel to QBO
Convert Excel (XLSX/XLS) files to QBO for QuickBooks Desktop and Online. Auto-detects columns and maps your data. Free, instant, no signup required.
Convert now →Excel to CSV
Convert Excel spreadsheets (XLSX/XLS) to clean CSV format. Compatible with any tool that accepts CSV input. Free, instant, no signup required.
Convert now →