Export Bank Statement — bank statement PDF to Excel
Free converter

Convert a bank statement to Tally XML .xml

Bring bank transactions into Tally Prime without retyping. This converts your statement PDF into Tally's "Import Data → Vouchers" XML — each transaction becomes a balanced Receipt or Payment voucher — with every figure checked against the statement's running balance first.

Upload the statement PDF at exportbankstatement.com/convert and choose Tally XML. You get a voucher XML file for Tally Prime or Tally ERP 9 — import it at Gateway of Tally, Alt+O, Vouchers. Each transaction becomes a Receipt or Payment voucher dated YYYYMMDD, carrying the statement's own description as the narration, with the counter ledger set to Suspense so you allocate it properly in Tally rather than having a category guessed for you. This is the route to use for a converted PDF: Tally's Bank Statement import does not accept Excel or CSV converted from a PDF.

  • Every transaction checked to balance
  • Scanned PDFs too (OCR)
  • Files deleted after processing

What the Tally XML contains

A standard Tally import ENVELOPE of vouchers: money in becomes a Receipt, money out a Payment, each as a balanced two-ledger entry.

Dates are in Tally's YYYYMMDD form and narrations carry the transaction description; amounts are currency-neutral numbers.

Why Tally XML

It loads a whole statement of bank entries into Tally in one import, instead of keying each voucher by hand.

It's the practical route for Indian businesses and accountants moving statement data into Tally Prime.

How to import it into Tally

After converting (included with paid plans):

  1. Drop your statement PDF into the converter above, then sign in on a paid plan.
  2. Download the Tally XML.
  3. In Tally Prime: Gateway of Tally → Import Data → Vouchers, and select the file.
  4. Map the bank and counter ledgers when prompted (see the note below).

Tally honesty: you map the ledgers

The file uses placeholder ledger names — "Bank Account" for your bank and "Suspense" as the counter ledger. Those ledgers must exist in your Tally company (or be mapped on import) for it to post cleanly; the file does not guarantee a clean import without that mapping. The vouchers are valid, balanced double entries — the bank and counter ledger choices are yours.

Checked before you download

Every conversion runs a reconciliation check — it ties the extracted transactions back to the statement's running balance, so credits and debits add up to the closing figure the bank printed. A statement that doesn't reconcile is flagged, not quietly exported — so your Tally XML file is correct before it reaches your books.

Frequently asked questions

Which Tally version does this target?

Tally Prime's "Import Data → Vouchers" XML. Each bank transaction becomes a balanced Receipt or Payment voucher.

What ledgers do I need?

A bank ledger and a counter ledger (the file defaults to "Bank Account" and "Suspense") that exist in your Tally company, or are mapped at import.

Is it free?

Converting, and Excel, CSV or JSON downloads, are free. Tally XML export is included with every paid plan, starting with Starter.

Other formats

Convert to another format

Checked to balance

Convert your bank statement — every transaction verified

Upload any PDF, get clean Excel or CSV ready for Xero & QuickBooks. Scanned statements too.

Convert a statement free