Skip to content
stmtai

Convert a bank statement PDF to Tally XML.
Receipt and Payment vouchers for TallyPrime.

Convert a PDF bank statement into TallyPrime Receipt and Payment vouchers. Every transaction is balanced between the bank ledger and one clearing ledger, with stable voucher IDs and a reconciliation check against the printed statement before you import.

Drop your bank statement for TallyPrime

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. The Tally XML download appears on the results page.

Last updated

Import with Alt+O, step by step

  1. Drop the statement on the home page and make sure the balance check is green.
  2. Click Tally XML. Money in becomes a Receipt voucher and money out becomes a Payment voucher. Each voucher has two ledger entries whose amounts add to zero.
  3. The XML names the bank ledger after the bank and the last four account digits (HDFC Bank 4821, for example). Its other side is a ledger named Statement Import Clearing. Both must exist in the company before you import: create them, or rename your existing ledgers to match.
  4. Set the company period to cover the statement dates (Alt+F2), then press Alt+O, choose Import, then Transactions, and select the downloaded file.
  5. Review the import summary and any exceptions. Open Statement Import Clearing afterwards and reclassify each transaction to the correct expense, income, customer or supplier ledger while reconciling the bank account.

Verified against a live TallyPrime import in September 2026: a converted statement went in through Alt+O, Import, Transactions and the vouchers posted.

The longer walkthrough covers the ledgers, the import summary and what to do with exceptions.

Indian statements: passwords, lakhs, UPI narrations

Dates are day first, DD/MM/YY or DD/MM/YYYY, and most statements print both a transaction date and a value date; the transaction date is the one used. Amounts follow the Indian grouping, 1,23,456.78, with a point for decimals, in Withdrawal and Deposit (or Debit and Credit) columns and a Closing Balance on every row. Narrations are long, often the full UPI string with the payer's VPA and a reference number, and they are kept whole so the UPI ID remains searchable. Statements are frequently emailed as PDFs locked with a published password scheme such as the customer ID or part of the PAN and date of birth.

INR amounts are read from the statement and checked to the paisa; there is no country setting.

Download Tally XML. It creates balanced Receipt and Payment vouchers between the inferred bank ledger and Statement Import Clearing. Create those two ledgers in TallyPrime (or rename yours to match), import the file under Alt+O, Import, Transactions, then reclassify the clearing entries while reconciling. Zoho Books imports the plain CSV through its bank statement import with column mapping.

The Income Tax Department expects bank statements to support an ITR under scrutiny and the Annual Information Statement is reconciled against them; GST filers match deposits to invoices.

Bank pages for Tally users

Where each bank keeps the PDF, what its password rule is, and where its own export falls short.

What it costs

5 pages free; a $19 pack buys 100 pages that never expire; no statement is charged more than 15 pages.

Prices are in US dollars before tax; GST is added at checkout and Dodo Payments can bill in your local currency. Full pricing

What usually goes wrong, and how this avoids it

  • Tally matches ledgers by exact name. A voucher whose ledger does not exist is listed as an exception instead of being posted, so check the two names before importing. Through the API you can pass your own ledger names.
  • Voucher dates must fall inside the company period, and amounts are imported as plain numbers in the company's base currency. Widen the period first, and treat a foreign-currency statement as a job for a multi-currency ledger.
  • Turning guessed categories directly into accounting ledgers can post transactions to the wrong chart-of-accounts group. The export uses one clearing ledger instead, leaving classification under your control.
  • Importing the same statement twice can duplicate vouchers if duplicate handling is disabled. The XML gives every row a stable remote ID and voucher number so Tally can identify the repeat during review.

Tools that export TallyPrime XML

A TallyPrime XML export writes the vouchers Tally imports under Alt+O. The list below is read from each tool's own homepage and pricing page, checked October 2026.

  • stmtai (this site): Receipt and Payment vouchers for Alt+O import, on every plan including the free one.
  • Lido: Excel, CSV, QBO, Xero CSV, QIF, Tally XML, JSON, REST API source, October 2026
  • MintConvert: CSV, Excel, QBO, Xero CSV, OFX, JSON, Google Sheets, Tally XML, Zoho Books, FreshBooks source, October 2026

Of the 24 converters compared in October 2026, 2 name a Tally XML export on their own pages: Lido and MintConvert. The other 22 (ParseBank, BankQBO, BankXLSX, ParseStatement, DocuClipper, LedgerBox, MoneyThumb, Suparse, ConvertStatement, Rocket Statements, Parseur, Nanonets, Docsumo, FlowParse, CapyParse, CreditCardToExcel, StatementToBudget, Documentric, StatementVision, CleanStmt, StatementTable, StatementBridge) do not.

TallyPrime questions

Does the Tally XML create my ledgers?

No. It refers to a bank ledger named after the bank and account, and to Statement Import Clearing. Create both before importing; vouchers that name a ledger Tally cannot find are held as exceptions. Not creating ledgers for you avoids a chart of accounts you did not choose.

How are debits and credits posted?

Money received is a Receipt voucher: the bank ledger is debited and the clearing ledger is credited. Money paid is a Payment voucher: the clearing ledger is debited and the bank ledger is credited. The two amounts in every voucher add to zero.

Can I convert several statements for Tally at once?

Yes. Upload up to 12 files and choose All Tally XML files from the batch page. The ZIP contains one XML file per statement or account, each with stable voucher IDs.

Sources

Other destinations

Popular banks