How do I import a bank statement into Tally Prime?

First convert the bank statement PDF to Tally XML using a converter like MyTaxFlow, then open Tally Prime, go to Gateway of Tally > Import > Vouchers, select the XML file, and confirm import.

Can Tally Prime import PDF bank statements directly?

No, Tally Prime cannot read PDF files directly. You must first convert the PDF to Tally XML format using a converter tool, then import the XML file into Tally Prime.

What format does Tally Prime support for bank statement import?

Tally Prime imports vouchers natively through XML format. The XML must follow the ENVELOPE > TALLYMESSAGE > VOUCHER structure with Payment and Receipt voucher types.

How to Import Bank Statement in Tally Prime

← Back to Home

Typing bank statement entries manually into Tally Prime is one of the most time-consuming tasks for accountants and CA firms in India. Every transaction — date, narration, debit, credit — must be entered as a separate voucher. For a busy current account with 200+ transactions a month, that is hours of repetitive data entry.

The solution is to import bank statement in Tally Prime using the built-in XML import feature. This guide walks you through the entire process: from converting your PDF bank statement to Tally XML, to importing the vouchers into Tally Prime or Tally.ERP 9.

Quick answer: Convert your PDF bank statement to Tally XML using MyTaxFlow's free converter, then open Tally Prime → Gateway of Tally → Import → Vouchers → select the XML file. Your entire statement imports as payment and receipt vouchers automatically.

Why Import Bank Statement in Tally Prime Instead of Manual Entry?

Metric	Manual Entry	XML Import
Time for 100 transactions	1.5–2 hours	Under 2 minutes
Data entry errors	Frequent	Near zero
Narration accuracy	Depends on operator	Exact copy from statement
Multi-page statements	Painful	Single upload
Cost	Accountant hours	Free to start

What You Need

Your bank statement in PDF format (from SBI, HDFC, ICICI, Axis, or any Indian bank)
Access to Tally Prime or Tally.ERP 9
A bank statement to Tally XML converter like MyTaxFlow
The bank ledger already created in your Tally company (e.g., "HDFC Bank - Current A/c")

Step 1: Convert PDF Bank Statement to Tally XML

Tally Prime does not read PDF files directly. You must first convert the bank statement PDF into Tally XML format — the native import format Tally understands.

1 Go to the MyTaxFlow Bank Statement Converter

2 Upload your bank statement PDF (or CSV/Excel if downloaded from net banking)

3 Select your bank from the list (SBI, HDFC, ICICI, Axis, Kotak, or 100+ others)

4 Click "Convert" — the system extracts every transaction using AI and OCR

5 Preview the extracted data and click "Download Tally XML"

Pro tip: The XML file contains ENVELOPE > TALLYMESSAGE > VOUCHER structure with Payment vouchers for debits and Receipt vouchers for credits. Debits become outgoing payments, credits become incoming receipts — exactly how Tally expects them.

Step 2: Import Bank Statement in Tally Prime

For Tally Prime (Latest Version)

Open your company in Tally Prime
Press Alt+O (Import) or go to Gateway of Tally → Import → Vouchers
Browse and select the Tally XML file you downloaded
Tally Prime will show a summary of vouchers to be imported
Confirm the import — the bank ledger must match exactly with your chart of accounts
Verify the entries in Day Book (Gateway of Tally → Display → Day Book)

For Tally.ERP 9

Open your company in Tally.ERP 9
Go to Gateway of Tally → Import of Data → Vouchers
Enter the XML file name or browse to its location
Tally processes the vouchers automatically
Check Day Book to confirm all entries are correct

Step 3: Run Bank Reconciliation

After importing the bank statement into Tally Prime, run the bank reconciliation to match your imported vouchers with the bank's records:

Go to Gateway of Tally → Banking → Bank Reconciliation
Select the bank ledger
Tally Prime's Auto-BRS (Release 6.0+) can auto-match imported vouchers against book entries
Review and confirm the reconciliation statement

Understanding the Tally XML Structure

When you convert bank statement to Tally XML, the output follows this structure:

ENVELOPE — the root element that wraps all data
HEADER — contains the request type (Import Data)
TALLYMESSAGE — one per transaction, contains a VOUCHER element
VOUCHER — typed as "Payment" for debits or "Receipt" for credits
Each voucher has DATE (YYYYMMDD format), NARRATION, and two balanced ALLLEDGERENTRIES.LIST blocks

This format is the standard Tally XML schema and works with both Tally Prime and Tally.ERP 9 without any additional TDL or add-on.

Frequently Asked Questions

Can I import PDF bank statement directly into Tally Prime?

No — Tally Prime cannot read PDF files. You must convert the PDF to Tally XML first using a bank statement to Tally XML converter, then import the XML file.

Which banks are supported for import into Tally Prime?

All major Indian banks: SBI, HDFC, ICICI, Axis, Kotak, PNB, Bank of Baroda, Canara, Union Bank, IDFC First, Yes Bank, Federal Bank, and 100+ others. Even scanned PDFs and password-protected files are supported.

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

Yes. The XML schema is identical for both versions. Tally Prime uses Gateway of Tally → Import → Vouchers, while Tally.ERP 9 uses Gateway of Tally → Import of Data → Vouchers.

How are debits and credits mapped to voucher types?

Debits (money going out) become Payment vouchers. Credits (money coming in) become Receipt vouchers. Bank-to-bank transfers can be mapped as Contra vouchers.

Convert Your Bank Statement to Tally XML Free

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

Convert Bank Statement to Tally XML Now