Bank Statement to Tally XML Converter

Bank statement import in Tally, without typing

Entering a month of bank transactions into Tally by hand takes hours and invites typing mistakes. This free bank statement to Tally converter reads the statement for you and writes a Tally XML file, so the whole month imports in one step. It works as a PDF to Tally converter and an Excel to Tally converter, and the output imports into TallyPrime and Tally.ERP 9.

• PDF, Excel and CSV statements. Text-based e-statements, password-protected PDFs, and XLS, XLSX or CSV downloads from net banking.
• Payment, Receipt and Contra vouchers. Withdrawals become Payment vouchers, deposits become Receipt vouchers, and cash movements become Contra vouchers.
• Ledger suggestions. Common narrations are mapped to ledgers automatically, and you can change any of them.
• Balance check on every row. Each entry is checked against the running balance, so a misread amount is flagged before it reaches your books.
• Ledger masters included. A second XML file creates any ledgers your company doesn’t have yet.
• Private by design. The statement is read in your browser and never uploaded, which matters when you handle client data.

What the converter does with each statement line

Every line of the bank statement becomes one Tally voucher. The voucher type comes from the direction of the money, and the ledger comes from the narration. Here is how three typical lines are converted:

Ledgers are suggested for common narrations such as bank charges, interest, ATM and cash deposits, GST and TDS payments, rent, salary, electricity, telephone, insurance and fuel. Everything else goes to the ledger you choose for unmatched entries, usually Suspense A/c, so you can reassign it before or after the import.

What the XML looks like

The vouchers file uses Tally’s standard XML import format. A single Payment voucher looks like this:

<VOUCHER VCHTYPE="Payment" ACTION="Create">
  <DATE>20260415</DATE>
  <VOUCHERTYPENAME>Payment</VOUCHERTYPENAME>
  <NARRATION>SMS ALERT CHARGES QTR</NARRATION>
  <ALLLEDGERENTRIES.LIST>
    <LEDGERNAME>Bank Charges</LEDGERNAME>
    <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
    <AMOUNT>-17.70</AMOUNT>
  </ALLLEDGERENTRIES.LIST>
  <ALLLEDGERENTRIES.LIST>
    <LEDGERNAME>HDFC Bank A/c</LEDGERNAME>
    <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
    <AMOUNT>17.70</AMOUNT>
  </ALLLEDGERENTRIES.LIST>
</VOUCHER>

Dates are written as YYYYMMDD, debits carry a negative amount with ISDEEMEDPOSITIVE set to Yes, and credits carry a positive amount. You don’t need to edit any of this by hand.

Supported banks

The converter reads statements by their columns, not by bank, so it works with any bank whose statement has a date, narration, withdrawal and deposit (or a single amount with Dr/Cr), and balance. Layouts tested so far include statements in the style of HDFC Bank, State Bank of India, ICICI Bank, Axis Bank and Kotak Mahindra Bank, plus Excel and CSV downloads. See the bank guides for HDFC, SBI and ICICI.