Why did Tally reject some vouchers?

Almost always a ledger name that does not exist in Tally exactly as typed. The tool lists every ledger used so you can compare, and can create the missing ones under a group you choose.

Which voucher types are supported?

Payment, Receipt, Journal, Contra, Sales, Purchase, Debit Note and Credit Note, in accounting-voucher mode without inventory.

toolsexcel-tallyfree · runs in your browser

Excel to Tally XML converter

Paste rows, get postable Tally vouchers.

YOU BRING: Rows of date, voucher type, debit ledger, credit ledger and amount in Excel
YOU GET: An XML file that TallyPrime and Tally.ERP 9 import as vouchers
YOUR DATA: Read in your browser. The file is never uploaded.

Add your file(you are here)
Check the result(next)
Download(next)

One row per entry: date, voucher type, debit ledger, credit ledger, amount. Rows with the same date, type and voucher number are merged into one multi-line voucher. . Ledger names must match Tally exactly, or Tally will reject those vouchers.

Your entries

Excel or CSV. Dates are read day-first (DD/MM/YYYY).

Drop Excel or CSV here, or click

Did this help?

IN SHORT

What the Excel → Tally XML does

Filingo's Excel to Tally converter turns rows of date, voucher type, debit ledger, credit ledger and amount into XML that TallyPrime and Tally.ERP 9 import directly. It merges rows into multi-line vouchers, lists rows it could not use, and can create missing ledgers. It is free to try without signing up and runs in the browser; the first download is free and more need a free login.

Share on WhatsApp Track every client's filings on Firm Desk →

Updated 8 Oct 2026

Excel to Tally XML: a worked example

5 rows in the sheet become 3 vouchers. Rows that share a date, voucher type and voucher number are merged into one voucher with several lines, and identical ledgers on the same side are added together.

Rows in the sheet: 5
Columns: Date, Debit ledger, Credit ledger, Amount (needed)

The two Journal rows numbered J1 on 30/04/2026 become one voucher: Salary Dr ₹1,00,000, Example Bank Cr ₹90,000, TDS Payable Cr ₹10,000.
The row for Payment 2 debits and credits the same ledger, so it is left out. The tool lists it with the reason: row 5, debit and credit ledger are the same.
The other vouchers are written to XML for Tally to import. In Tally, use Import, then Transactions.

3 vouchers ready for import, 1 row left out with a reason.

Vouchers built from the example rows
DATE	TYPE	NO	LINES	ROWS USED
01/04/2026	Payment	1	Office Rent Dr ₹25,000; Example Bank Cr ₹25,000	1
05/04/2026	Receipt	1	Example Bank Dr ₹1,18,000; Sharma Traders Cr ₹1,18,000	2
30/04/2026	Journal	J1	Salary Dr ₹1,00,000; Example Bank Cr ₹90,000; TDS Payable Cr ₹10,000	3, 4

The XML for the journal voucher:

<ENVELOPE>
 <HEADER><TALLYREQUEST>Import Data</TALLYREQUEST></HEADER>
 <BODY>
  <IMPORTDATA>
   <REQUESTDESC><REPORTNAME>Vouchers</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY>Example Traders</SVCURRENTCOMPANY></STATICVARIABLES></REQUESTDESC>
   <REQUESTDATA>
    <TALLYMESSAGE xmlns:UDF="TallyUDF">
     <VOUCHER VCHTYPE="Journal" ACTION="Create" OBJVIEW="Accounting Voucher View">
      <DATE>20260430</DATE>
      <EFFECTIVEDATE>20260430</EFFECTIVEDATE>
      <VOUCHERTYPENAME>Journal</VOUCHERTYPENAME>
      <VOUCHERNUMBER>J1</VOUCHERNUMBER>
      <PARTYLEDGERNAME>Example Bank</PARTYLEDGERNAME>
      <NARRATION>April salary</NARRATION>
      <ALLLEDGERENTRIES.LIST>
       <LEDGERNAME>Salary</LEDGERNAME>
       <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
       <AMOUNT>-100000.00</AMOUNT>
      </ALLLEDGERENTRIES.LIST>
      <ALLLEDGERENTRIES.LIST>
       <LEDGERNAME>Example Bank</LEDGERNAME>
       <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
       <AMOUNT>90000.00</AMOUNT>
      </ALLLEDGERENTRIES.LIST>
      <ALLLEDGERENTRIES.LIST>
       <LEDGERNAME>TDS Payable</LEDGERNAME>
       <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
       <AMOUNT>10000.00</AMOUNT>
      </ALLLEDGERENTRIES.LIST>
     </VOUCHER>
    </TALLYMESSAGE>
   </REQUESTDATA>
  </IMPORTDATA>
 </BODY>
</ENVELOPE>

Excel to Tally import template: the columns it reads

One row per entry. Dates are read day-first. Ledger names must match Tally exactly, or Tally will reject those vouchers. A template is on the tool.

Columns read from the Excel sheet
COLUMN	NEEDED	ALSO READ AS
Date	Yes	date, voucher date, vch date, txn date
Voucher type	No	voucher type, vch type, type
Voucher no	No	voucher no, voucher number, vch no, ref no, number
Debit ledger	Yes	debit ledger, dr ledger, debit, dr, to ledger
Credit ledger	Yes	credit ledger, cr ledger, credit, cr, by ledger
Amount	Yes	amount, amt, value
Narration	No	narration, particulars, description, remarks

Voucher types the converter supports

Vouchers are written in accounting-voucher mode, without inventory. A voucher type that is not in this list is left out of the XML and reported. A blank voucher type is read as Journal.

Voucher types
VOUCHER TYPE
Payment
Receipt
Journal
Contra
Sales
Purchase
Debit Note
Credit Note

STEP BY STEP

How it works

Download the template: date, voucher type, voucher number, debit ledger, credit ledger, amount, narration.
Fill it in or paste from your working. Rows that share a date, type and voucher number become one multi-line voucher.
Download the XML and import it in Tally: Import → Transactions.

GOOD TO KNOW

Common questions

Why did Tally reject some vouchers?: Almost always a ledger name that does not exist in Tally exactly as typed. The tool lists every ledger used so you can compare, and can create the missing ones under a group you choose.
Which voucher types are supported?: Payment, Receipt, Journal, Contra, Sales, Purchase, Debit Note and Credit Note, in accounting-voucher mode without inventory.