MyTaxFlow — Convert Bank Statement to Tally XML

How to Import PDF Bank Statement in Tally Prime

Two import routes explained, the exact Alt+O steps, ledger setup, and how to fix or undo an import that went wrong.

Updated November 2026 · 11 min read

Typing every bank transaction into Tally Prime is the slowest part of a monthly close. A current account with 200+ entries can take two hours of keying, and every retyped narration is a chance for an error. Importing the statement instead takes minutes.

But there is a catch that most guides skip: Tally Prime has two different import paths, and only one of them works with a PDF bank statement. Choosing the wrong one is the reason people see “unsupported file” or a zero-voucher import.

Quick answer: Tally Prime cannot read a PDF directly. Convert the PDF to Tally XML using the MyTaxFlow bank statement to Tally XML converter, then open Tally Prime and press Alt+O (Import) → Transactions, select the XML file, and import. For a CSV or Excel statement downloaded from a supported bank, use Alt+O → Bank Statement instead.

The Two Import Routes in Tally Prime

Tally Prime ships with a bank statement import feature, and separately with a voucher/master data import feature. They accept different files and produce different results.

Bank Statement importVoucher XML import
MenuGateway of Tally → Alt+O → Bank StatementGateway of Tally → Alt+O → Transactions (called Vouchers in some releases)
Accepts PDFNoNo — convert to XML first
Accepts CSV / ExcelYes, but only bank-generated files from supported banksNo — XML only
PDF converted to CSV/ExcelNot supported (Tally documentation lists this as invalid)Not applicable — use XML
What it createsImported bank data used for reconciliation; vouchers can be auto-createdPayment, Receipt and Contra vouchers directly in the books
Best forBanks that expose a native CSV/Excel statement exportPDF statements from any bank, including password-protected PDFs

For a PDF statement — which is what most Indian banks issue — the voucher XML route is the reliable one. Everything below follows that route.

Why Tally Prime Cannot Import PDF

A PDF is a page description, not a data table. The numbers on the page have no reliable row or column identity until something reads the layout and rebuilds the transactions. Tally's importer expects structured data where each value is already labelled: this is a date, this is a debit, this is the bank ledger.

Tally's own help documentation is explicit about this: bank statements can be imported in CSV or Excel format downloaded from the bank portal, while PDF files — and CSV or Excel files that were converted from a PDF — are not accepted by the bank statement import screen.

That leaves the XML route. XML carries its own meaning: a voucher is labelled as Payment or Receipt, the bank ledger is named, and every amount is tagged as debit or credit. Tally does not need to guess the layout, so a converted PDF imports cleanly.

Step 1: Convert the PDF to Tally XML

Before touching Tally, turn the statement into voucher XML. The bank statement to Tally XML converter accepts digital PDF statements from 100+ Indian banks, including SBI, HDFC, ICICI, Axis, Kotak, PNB, Canara, Union Bank and South Indian Bank.

1 Open the converter — go to mytaxflow.online/bank-converter.html and sign in.

2 Upload the PDF — drag the bank statement PDF, or browse for it. Digital PDFs up to 50 MB are supported. Scanned or image-only PDFs are not, because there is no text layer to extract.

3 Enter the PDF password if prompted — net banking e-statements are usually protected. The password is normally your customer ID, date of birth or a combination the bank tells you at download time.

4 Select the bank and convert — choose the bank from the list so the correct statement layout is used. The transactions are extracted page by page.

5 Review the preview — check the date range, opening and closing balance, and a few narrations. The numbers should reconcile: opening balance + credits − debits = closing balance.

6 Set the ledger names, then download XML — in the preview, fill Bank Ledger Name and Opposite / Suspense Ledger exactly as they are spelled in your Tally company. Then click Download Tally XML.

Ledger names matter more than anything else. The XML does not create ledgers on its own. If the file says “HDFC Bank” and your company has “HDFC Bank – Current A/c”, Tally will skip those vouchers or report them as exceptions.

Step 2: Prepare Ledgers in Tally Prime

Create or confirm these masters before importing. It takes a minute and prevents most failed imports.

Bank ledger

  1. Press Alt+G (Go To) → Create Master → Ledger, or use Gateway of Tally → Chart of Accounts → Ledgers → Create.
  2. Set Under to Bank Accounts.
  3. Enable Provide bank details and fill the account number, IFSC and bank name. This also makes the ledger usable for bank reconciliation, cheque printing and e-payments.
  4. Save with Ctrl+A.

Opposite / Suspense ledger

The generated XML has two legs: the bank ledger and an opposite ledger. By default the converter names the opposite leg Suspense Account. Either create that ledger under Suspense A/c in Tally, or change the name in the preview to a ledger that already exists.

During import, the counter leg lands in that ledger. After import, reclassify each entry to the correct expense, income, party or loan ledger. This is the accounting judgement Tally cannot make for you — but reclassifying is far faster than typing every voucher.

Faster option: if you already know the counter ledger for a batch — for example a single client, a loan account, or bank charges — type that ledger name in Opposite / Suspense Ledger before downloading. The vouchers then import already classified.

Step 3: Import the XML Vouchers

Tally Prime

  1. Open the company that should receive the vouchers.
  2. Press Alt+O (Import).
  3. Choose Transactions. In some releases this option is labelled Vouchers; the destination screen is the same.
  4. Set the File Path and select the downloaded .xml file. If the file does not appear, confirm that the format selector is XML and that Tally can read the folder.
  5. Choose the behaviour for existing vouchers. Add is the safe default. Overwrite replaces matching vouchers and should be used only when you are certain what it will match.
  6. Optionally take a company backup when Tally offers it. For a first import, always say yes.
  7. Press Enter to import. Tally reports how many vouchers were imported and how many were skipped.

Tally.ERP 9

  1. Open the company.
  2. Go to Gateway of Tally → Import of Data → Vouchers.
  3. Enter the full path of the XML file and press Enter.
  4. Check the Day Book afterwards.

If Tally stops on errors, open Alt+O → Configuration and set Ignore errors during import to Yes. The valid vouchers are imported and the rest are listed as exceptions, which is easier to diagnose than a failed batch.

Step 4: Verify and Reconcile

Check the Day Book

  1. Open Gateway of Tally → Day Book (or Alt+G → Day Book).
  2. Press Alt+F2 (Period) and set the statement date range.
  3. Confirm that the voucher count matches the number of transactions in the PDF.
  4. Open two or three vouchers and compare the date, narration and amount against the statement.

Check the totals

Open the bank ledger report and compare the closing balance with the bank statement. If the imported total differs, the usual cause is a missing row or a skipped voucher, not a Tally bug. Re-check the exceptions and the statement's own balance column.

Run bank reconciliation

  1. Go to Gateway of Tally → Banking → Bank Reconciliation, or open the Bank Reconciliation report from the bank ledger.
  2. Select the bank ledger and set the reconciliation period.
  3. Match book entries with bank entries. Tally Prime can suggest exact matches and potential matches.
  4. Mark matched entries as reconciled and review anything left unmatched.

If you imported the statement through Alt+O → Bank Statement instead, the transactions live in Imported Bank Data and can be used to auto-create vouchers. That data is separate from the vouchers in the Day Book.

How to Enter Bank Statement in Tally Prime Automatically

There are three practical ways to avoid manual keying. They differ in which banks they support and how much of the work happens inside Tally.

MethodHow it worksLimitation
PDF → Tally XMLConvert the statement in a browser, then import vouchers with Alt+O → TransactionsNeeds a converter; ledgers must exist
Bank Statement importAlt+O → Bank Statement, choose the bank ledger and a supported CSV/Excel file, then auto-create vouchersOnly bank-generated CSV/Excel from supported banks; no PDF
Connected BankingAlt+Z (Exchange) → All Banking Options → Get Statement fetches the statement inside Tally PrimeRequires Connected Banking and a bank supported for it; available from TallyPrime Release 6.0

For a CA firm handling many clients across many banks, the PDF → XML route is the most portable: it does not depend on the bank exposing a clean CSV, and it works with statements the client emails or downloads months later.

Delete or Reset an Import

There is no single “undo import” button. What you do depends on which route you used.

If you used the Bank Statement import screen

  1. Press F1 (Help) → Troubleshooting.
  2. Select Reset Bank Statement Data.
  3. Choose the bank and the period to reset.

You cannot delete individual transactions from previously imported bank data — the reset works by bank and period.

If you imported vouchers from XML

  1. Take a backup first: Alt+Y.
  2. To delete one voucher, open it and press Alt+D.
  3. To delete many, open the Day Book, press Alt+F2 to set the statement period, and delete the vouchers belonging to the import.

Deletion is permanent, so filter by date and check the Suspense/counter ledger before confirming. Full walkthrough: how to delete imported bank statement vouchers in Tally Prime.

Prevention: import one week of the statement first. If the ledger mapping or voucher types are wrong, you are deleting ten vouchers instead of four hundred.

The XML Structure Tally Expects

A Tally voucher import file has a fixed envelope and one message per voucher. This is the shape MyTaxFlow generates:

<?xml version="1.0" encoding="UTF-8"?>
<ENVELOPE>
  <HEADER>
    <TALLYREQUEST>Import Data</TALLYREQUEST>
  </HEADER>
  <BODY>
    <IMPORTDATA>
      <REQUESTDESC>
        <REPORTNAME>Vouchers</REPORTNAME>
      </REQUESTDESC>
      <REQUESTDATA>
        <TALLYMESSAGE xmlns:UDF="TallyUDF">
          <VOUCHER VCHTYPE="Payment" ACTION="Create" OBJVIEW="Accounting Voucher View">
            <DATE>20261001</DATE>
            <EFFECTIVEDATE>20261001</EFFECTIVEDATE>
            <VOUCHERTYPENAME>Payment</VOUCHERTYPENAME>
            <NARRATION>UPI/DR/123456/ABC ENTERPRISES</NARRATION>
            <PARTYLEDGERNAME>Suspense Account</PARTYLEDGERNAME>
            <PERSISTEDVIEW>Accounting Voucher View</PERSISTEDVIEW>
            <ALLLEDGERENTRIES.LIST>
              <LEDGERNAME>Suspense Account</LEDGERNAME>
              <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
              <ISPARTYLEDGER>No</ISPARTYLEDGER>
              <AMOUNT>-1250.00</AMOUNT>
            </ALLLEDGERENTRIES.LIST>
            <ALLLEDGERENTRIES.LIST>
              <LEDGERNAME>HDFC Bank - Current A/c</LEDGERNAME>
              <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
              <ISPARTYLEDGER>No</ISPARTYLEDGER>
              <AMOUNT>1250.00</AMOUNT>
            </ALLLEDGERENTRIES.LIST>
          </VOUCHER>
        </TALLYMESSAGE>
      </REQUESTDATA>
    </IMPORTDATA>
  </BODY>
</ENVELOPE>
ElementWhat it does
TALLYREQUESTMust be Import Data for an import file.
REPORTNAMEVouchers for transactions, All Masters for ledgers and other masters.
TALLYMESSAGEOne wrapper per object. A file can contain hundreds.
VOUCHERVCHTYPE sets the voucher type; ACTION="Create" creates a new voucher.
DATEYYYYMMDD without separators. This is the most common import error.
ALLLEDGERENTRIES.LISTTwo blocks per voucher, one per ledger leg, with opposite signs.
ISDEEMEDPOSITIVEYes for the debit leg, No for the credit leg.
AMOUNTNegative for debit, positive for credit. The two legs must net to zero.

Deeper reference: Tally XML format explained and which data can be imported into Tally Prime using XML.

Insert Bank Details in a Tally Prime Invoice

Once the bank ledger exists with a valid account number and IFSC, Tally can print those details on your sales invoices so customers can pay directly. The short version: open the invoice, press Ctrl+P → C (Configure), set Show Bank Details to Yes, select the bank ledger, and press Ctrl+A.

Step-by-step with troubleshooting: how to insert bank details in a Tally Prime invoice.

Common Errors and Fixes

What you seeWhyFix
“Masters missing” or vouchers skippedA ledger name in the XML does not exist in the companyCreate the ledger with the exact spelling, or re-download the XML with corrected names
Zero vouchers importedWrong file, wrong company period, missing voucher type, or invalid datesCheck the file path, extend the company period, confirm Payment/Receipt voucher types are enabled
Date errorDate not in YYYYMMDD format, or outside the company periodUse a clean converted XML; set the company period to cover the statement
Existing vouchers overwrittenDuplicate voucher IDs between the XML and the companyChoose Add, keep backups, and prefer XML without remote voucher IDs
Every entry shows Suspense AccountThe counter ledger was left at its defaultReclassify after import, or set the opposite ledger before downloading
“Unsupported file” on the Bank Statement screenYou selected a PDF, or a CSV/Excel converted from a PDFUse Alt+O → Transactions with a Tally XML file
Conversion fails or finds no transactionsScanned/image PDF, wrong bank selected, or wrong PDF passwordDownload a digital statement from net banking; select the correct bank; re-enter the password
Amounts doubledThe same statement was imported twiceDelete the duplicate batch by date, then import once

Pre-Import Checklist

Frequently Asked Questions

Can we import PDF bank statement in Tally Prime directly?

No. Tally Prime's Import Bank Statement screen accepts supported CSV and Excel files downloaded from the bank, not PDF. A PDF must first be converted to Tally XML, and then imported through Alt+O > Transactions (Vouchers in some releases).

How do I import a bank statement into Tally Prime?

Convert the PDF statement to Tally XML, create the bank ledger and the opposite/Suspense ledger in Tally Prime, then press Alt+O (Import) > Transactions, select the XML file, choose Add as the behaviour, and press Enter. Verify the vouchers in Day Book.

Can I import a PDF converted to Excel into Tally Prime?

Tally documentation states that bank statements in PDF, and CSV or Excel files converted from a PDF, cannot be imported through the bank statement import feature. Use the Tally XML voucher import route for PDF statements instead.

Why are my imported vouchers showing Suspense Account?

The generated XML posts the opposite leg to the ledger named in the Opposite/Suspense Ledger field. If that leg should be an expense or party ledger, reclassify the voucher after import. If the ledger name does not exist in Tally, the voucher is skipped.

How do I delete an imported bank statement in Tally Prime?

Imported bank data can be removed with F1 (Help) > Troubleshooting > Reset Bank Statement Data. Vouchers created by an XML import are ordinary vouchers, so open each one and press Alt+D, or filter the Day Book by date and delete them in bulk. Take a backup with Alt+Y first.

How do I enter bank statement in Tally Prime automatically?

There are three options: import a bank-generated CSV or Excel through Alt+O > Bank Statement (supported banks only), use Connected Banking to fetch the statement inside Tally Prime, or convert a PDF to Tally XML and import the vouchers automatically.

Which data can be imported into Tally Prime using XML format?

Tally XML can import both masters and transactions. Masters include ledgers, groups, stock items, voucher types and cost centres. Transactions include accounting vouchers such as Payment, Receipt, Contra, Sales and Purchase.

Does the Tally XML work with both Tally Prime and Tally.ERP 9?

Yes. The XML envelope and voucher structure are the same. Tally Prime uses Alt+O (Import) > Transactions, while Tally.ERP 9 uses Gateway of Tally > Import of Data > Vouchers.

Why does Tally show zero vouchers imported?

The usual causes are a missing ledger name, a missing voucher type, an invalid date, or a company period that does not include the voucher dates. Check the exceptions or skipped count shown after import and create the missing masters.

Should I import Payment and Receipt vouchers or Contra vouchers for a bank statement?

Use Payment for debits (money leaving the bank), Receipt for credits (money coming in), and Contra only for transfers between cash and bank or between two bank accounts.

Related workflow: Start with the bank statement to Tally XML converter, read the Tally XML format guide if Tally reports a ledger, date or voucher-type error, then import the downloaded XML through Gateway of Tally.

How this guide was checked

The import steps, menu paths and error behaviour were tested in TallyPrime and cross-checked against Tally's official documentation for XML import, bank statement import and Connected Banking. Read the editorial policy for how we handle corrections.

Last reviewed: 4 November 2026

Sources

Convert Your Bank Statement to Tally XML

Import bank statement in Tally Prime in under 60 seconds. Supports SBI, HDFC, ICICI, Axis & 100+ banks, including password-protected PDFs.

Convert Bank Statement to Tally XML Now

Related Guides