📥 Tally ERP 9 · Tally Prime · HDFC · SBI · ICICI · Axis · Free Guide

How to Import Bank Statement PDF into Tally

Tally cannot read PDF files directly. This guide covers the correct two-step method: convert your PDF to Tally XML first, then import the XML via Gateway → Import → Vouchers. Free, no signup.

📥 Convert PDF for Tally →
📄→🏦

Convert Bank Statement PDF to Tally XML

Free · No signup · Tally ERP 9 & Prime compatible

Choose PDF File

Step-by-Step: PDF Bank Statement to Tally

Tally cannot open PDF files. The correct workflow converts the PDF to Tally's XML format first, then imports the XML.

1

Download your bank statement PDF

Log into your bank's internet banking or mobile app and download a PDF statement for the date range you need. HDFC: NetBanking → Accounts → Download Statement. SBI: YONO → My Accounts → Statement → Download. ICICI: iMobile Pay → Account Statement → PDF.

2

Upload the PDF to our converter (handle passwords here)

Upload the PDF on this page. If your bank encrypts the PDF with a password, enter it when prompted. Your password is used only to unlock the PDF in memory — it is never stored or logged.

Common Indian bank PDF passwords: HDFC — Customer ID or DDMMYYYY · ICICI — first 4 letters of name + DOB · Axis Bank — PAN in lowercase · Kotak — date of birth DDMMYYYY · SBI — usually not password-protected

3

Download the Tally XML file

The converter extracts every transaction from the PDF, maps debit transactions to Bank Payment vouchers and credit transactions to Bank Receipt vouchers, and packages them in Tally's TALLYMESSAGE XML format. Download the .xml file to your computer.

4

Create the bank ledger in Tally (if not already present)

Before importing, ensure your bank ledger exists in Tally. In ERP 9: Gateway → Accounts Info → Ledgers → Create. Set the group to Bank Accounts. Name it exactly as your bank account (e.g. HDFC Bank Current A/C). The XML references this ledger name — if the name does not match exactly, the import will produce errors.

5

Import the XML into Tally ERP 9 or Tally Prime

See the bank-specific import instructions below for ERP 9 and Prime. After successful import, Tally shows the number of vouchers imported — verify it matches your bank statement row count.

6

Update counterpart ledgers in each voucher

Imported vouchers use a default suspense ledger as the counterpart entry. Open each voucher (Day Book → select voucher → Alt+Enter to edit) and change the counterpart from suspense to the correct ledger: rent expense, salary payable, vendor name, etc.

Tally ERP 9 vs Tally Prime: Import Steps

Tally ERP 9

  1. Open your Tally company
  2. Go to Gateway of Tally
  3. Press Import of Data
  4. Press Vouchers
  5. Type or paste the full path to your .xml file
  6. Press Enter to begin import
  7. Tally displays: "X vouchers imported successfully"

Tally Prime

  1. Open your Tally company
  2. Go to Gateway of Tally
  3. Press Alt+O (Import)
  4. Select Vouchers
  5. Navigate to your .xml file and select it
  6. Review the import preview
  7. Press Import to confirm

Indian Bank PDF Passwords Reference

Most Indian bank statement PDFs are password-protected. Enter the password when prompted during upload.

BankPDF Password FormatExample
HDFC BankCustomer ID (11 digits) OR Date of Birth in DDMMYYYY12345678901 or 15081990
ICICI BankFirst 4 letters of account holder name (lowercase) + date of birth DDMMYYYYaman15081990
Axis BankPAN number in lowercaseabcde1234f
Kotak Mahindra BankDate of birth in DDMMYYYY format15081990
Yes BankCustomer ID or date of birth DDMMYYYY15081990
IDFC First BankDate of birth in DDMMYYYY format15081990
IndusInd BankDate of birth in DDMMYYYY format15081990
SBIUsually not password-protected
Canara BankUsually not password-protected
Bank of BarodaUsually not password-protected

Frequently Asked Questions

No — Tally cannot directly import PDF files. You first need to convert the PDF to Tally XML format using our free converter, then import the XML via Gateway → Import → Vouchers. The two-step process takes under 2 minutes total.
Tally accepts XML files in the TALLYMESSAGE/ENVELOPE format for voucher import. Our converter produces this format automatically from your bank statement PDF — you do not need to format anything manually.
In Tally Prime: (1) Convert your bank PDF to XML using our free tool. (2) Open your Tally company. (3) Press Alt+O (Import) → Vouchers. (4) Navigate to the XML file and select it. (5) Confirm import. Verify the imported count matches your statement row count.
In Tally ERP 9: (1) Convert your bank PDF to XML using our free tool. (2) Open your Tally company. (3) Gateway of Tally → Import of Data → Vouchers. (4) Enter the path to the XML file. (5) Press Enter to import.
The most common reason is a ledger name mismatch — the bank ledger name in the XML must match exactly the ledger name in your Tally company (including capitalization and spaces). Other causes: Tally version too old (before 5.x), XML file path contains special characters, or the Tally company is in a different financial year than the statement dates.
Yes — completely free. No signup, no credit card, no daily limits. The converter and the resulting XML import into Tally are both free with no restrictions.

Related Tools