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.
On this page
- The two import routes in Tally Prime
- Why Tally Prime cannot import PDF
- Step 1: Convert PDF to Tally XML
- Step 2: Prepare ledgers in Tally
- Step 3: Import the XML vouchers
- Step 4: Verify and reconcile
- How to enter bank statement automatically
- Delete or reset an import
- The XML structure Tally expects
- Common errors and fixes
- FAQ
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 import | Voucher XML import | |
|---|---|---|
| Menu | Gateway of Tally → Alt+O → Bank Statement | Gateway of Tally → Alt+O → Transactions (called Vouchers in some releases) |
| Accepts PDF | No | No — convert to XML first |
| Accepts CSV / Excel | Yes, but only bank-generated files from supported banks | No — XML only |
| PDF converted to CSV/Excel | Not supported (Tally documentation lists this as invalid) | Not applicable — use XML |
| What it creates | Imported bank data used for reconciliation; vouchers can be auto-created | Payment, Receipt and Contra vouchers directly in the books |
| Best for | Banks that expose a native CSV/Excel statement export | PDF 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.
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
- Press Alt+G (Go To) → Create Master → Ledger, or use Gateway of Tally → Chart of Accounts → Ledgers → Create.
- Set Under to Bank Accounts.
- 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.
- 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.
Step 3: Import the XML Vouchers
Tally Prime
- Open the company that should receive the vouchers.
- Press Alt+O (Import).
- Choose Transactions. In some releases this option is labelled Vouchers; the destination screen is the same.
- Set the File Path and select the downloaded
.xmlfile. If the file does not appear, confirm that the format selector is XML and that Tally can read the folder. - 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.
- Optionally take a company backup when Tally offers it. For a first import, always say yes.
- Press Enter to import. Tally reports how many vouchers were imported and how many were skipped.
Tally.ERP 9
- Open the company.
- Go to Gateway of Tally → Import of Data → Vouchers.
- Enter the full path of the XML file and press Enter.
- 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
- Open Gateway of Tally → Day Book (or Alt+G → Day Book).
- Press Alt+F2 (Period) and set the statement date range.
- Confirm that the voucher count matches the number of transactions in the PDF.
- 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
- Go to Gateway of Tally → Banking → Bank Reconciliation, or open the Bank Reconciliation report from the bank ledger.
- Select the bank ledger and set the reconciliation period.
- Match book entries with bank entries. Tally Prime can suggest exact matches and potential matches.
- 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.
| Method | How it works | Limitation |
|---|---|---|
| PDF → Tally XML | Convert the statement in a browser, then import vouchers with Alt+O → Transactions | Needs a converter; ledgers must exist |
| Bank Statement import | Alt+O → Bank Statement, choose the bank ledger and a supported CSV/Excel file, then auto-create vouchers | Only bank-generated CSV/Excel from supported banks; no PDF |
| Connected Banking | Alt+Z (Exchange) → All Banking Options → Get Statement fetches the statement inside Tally Prime | Requires 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
- Press F1 (Help) → Troubleshooting.
- Select Reset Bank Statement Data.
- 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
- Take a backup first: Alt+Y.
- To delete one voucher, open it and press Alt+D.
- 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.
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>
| Element | What it does |
|---|---|
TALLYREQUEST | Must be Import Data for an import file. |
REPORTNAME | Vouchers for transactions, All Masters for ledgers and other masters. |
TALLYMESSAGE | One wrapper per object. A file can contain hundreds. |
VOUCHER | VCHTYPE sets the voucher type; ACTION="Create" creates a new voucher. |
DATE | YYYYMMDD without separators. This is the most common import error. |
ALLLEDGERENTRIES.LIST | Two blocks per voucher, one per ledger leg, with opposite signs. |
ISDEEMEDPOSITIVE | Yes for the debit leg, No for the credit leg. |
AMOUNT | Negative 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 see | Why | Fix |
|---|---|---|
| “Masters missing” or vouchers skipped | A ledger name in the XML does not exist in the company | Create the ledger with the exact spelling, or re-download the XML with corrected names |
| Zero vouchers imported | Wrong file, wrong company period, missing voucher type, or invalid dates | Check the file path, extend the company period, confirm Payment/Receipt voucher types are enabled |
| Date error | Date not in YYYYMMDD format, or outside the company period | Use a clean converted XML; set the company period to cover the statement |
| Existing vouchers overwritten | Duplicate voucher IDs between the XML and the company | Choose Add, keep backups, and prefer XML without remote voucher IDs |
| Every entry shows Suspense Account | The counter ledger was left at its default | Reclassify after import, or set the opposite ledger before downloading |
| “Unsupported file” on the Bank Statement screen | You selected a PDF, or a CSV/Excel converted from a PDF | Use Alt+O → Transactions with a Tally XML file |
| Conversion fails or finds no transactions | Scanned/image PDF, wrong bank selected, or wrong PDF password | Download a digital statement from net banking; select the correct bank; re-enter the password |
| Amounts doubled | The same statement was imported twice | Delete the duplicate batch by date, then import once |
Pre-Import Checklist
- Bank ledger exists under Bank Accounts, with account number and IFSC.
- Opposite/Suspense ledger exists, or a real counter ledger is chosen.
- Payment and Receipt voucher types are enabled in the company.
- Company period covers the statement dates.
- Preview totals reconcile with the statement's opening and closing balance.
- A company backup exists before the first import.
- Only one copy of the XML is imported.
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.
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 2026Sources
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 NowRelated Guides
- Which data can be imported into Tally Prime using XML format?
- Tally bank statement import Excel format and a free template
- How to delete imported bank statement vouchers in Tally Prime
- How to insert bank details in a Tally Prime invoice
- Tally XML format, import and TallyXML guide
- Best bank statement converter for CAs in India (2026)
- How to download a South Indian Bank (SIB) statement
- SBI bank statement to Tally XML converter
- South Indian Bank statement to Tally XML converter