Convert a bank statement PDF to Tally XML
TallyPrime can't read a PDF. Upload the statement your client downloaded from net banking, check the rows, and download Tally XML you can import as vouchers. Works with SBI, HDFC, ICICI, Axis, Kotak, Bank of Baroda, PNB, Canara, Union Bank, IDFC FIRST, YES Bank and IndusInd statements.
Four steps from PDF to Tally
- Upload the PDF: Upload the PDF (up to 50MB per file; more than one file per session). Enter the PDF password if the bank protected it — it's used in memory to unlock and never stored.
- Preview and compare rows with the PDF: Preview and compare rows with the PDF: date, description, debit, credit, balance, plus account number, period, opening and closing balance when the header has them.
- Download Tally XML: Download Tally XML. You can also download Excel (XLSX) or CSV for your working papers.
- Import in TallyPrime: Import in TallyPrime: Alt+O → Import → Transactions → XML. (ERP 9: Gateway of Tally → Import Data → Vouchers.)
Before you import (checklist)
- Take a backup (Tally has no undo for an import); try the first import in a test company.
- Create the bank ledger under Bank Accounts with the exact name used in the file.
- Make sure the statement dates fall inside the company's financial period.
- After import, compare the bank ledger closing balance with the statement and spot-check entries in the Day Book.
Common import errors
"Ledger does not exist"
Tally rejects vouchers if a referenced ledger is missing. Create or rename the bank ledger under Bank Accounts with the exact name used in the export (default is "Bank") and ensure a "Suspense" ledger exists under Suspense Accounts.
Vouchers skipped
Vouchers are skipped if transaction dates fall outside the company's active financial period or books beginning date in Tally, or if a ledger name does not match.
Duplicate vouchers
Tally imports vouchers with ACTION="Create" without checking for existing entries. Duplicates occur if the same statement file or overlapping date ranges are imported twice.
For CAs and bookkeepers handling many clients
Work through several clients' PDFs in one sitting and download Tally XML per file. Manage statement conversions across multiple client entities from the Bank Statement Converter for CAs, or check our pricing plans for volume processing.
Why Tally XML, not only Excel
Many converters stop at a spreadsheet. A spreadsheet is useful for review, but posting into Tally still means re-keying or a second conversion unless you have a file in Tally's import structure. Toolzy writes that Tally XML from the same PDF, so a practice can keep Excel or CSV for checking and import the same transactions into Tally Prime.
What is in the file
The export carries date, narration, debit, credit, and running balance when the statement has them, plus account holder, account number, bank name, period, and opening and closing balances when the header has them. After you download the XML, import it in Tally Prime and compare the vouchers with the PDF before you post. Menu labels vary by Tally version; a common path is Gateway of Tally, then Import Data, then Vouchers. Toolzy does not publish an accuracy rate for the extraction.
Banks this is written for
Pages on this site already cover State Bank of India, HDFC Bank, ICICI Bank, Axis Bank, Kotak Mahindra Bank, Bank of Baroda, Punjab National Bank, Canara Bank, Union Bank of India, IDFC FIRST Bank, YES Bank, and IndusInd Bank. Each of those pages explains that bank's usual columns, the net-banking download, and the PDF password when the bank has published one. You can also add more than one PDF in the same session; each file can be up to 50 MB.
What this page does not do
- It does not file GST or ITR.
- It does not invent a statement password the bank has not published.
- It does not claim that every voucher will post without review. You remain responsible for checking the import against the original PDF.
Frequently asked questions
Can TallyPrime import a bank statement PDF directly?
No. TallyPrime cannot read or parse PDF statements directly. It imports data in XML format. You must convert the PDF to Tally XML first, then import the XML file into Tally.
Does it work with Tally ERP 9?
The XML is structured using standard Tally XML envelope and voucher tags (<VOUCHER> with <ALLLEDGERENTRIES.LIST>), built and verified for TallyPrime (Alt+O → Import → Transactions → XML). In Tally ERP 9, vouchers can be imported via Gateway of Tally → Import Data → Vouchers once the corresponding bank and suspense ledgers are created.
Which voucher types are created?
The export creates Payment vouchers for debit entries (withdrawals) and Receipt vouchers for credit entries (deposits), with the opposing entry mapped to Suspense. It does not automatically create Contra vouchers; inter-bank transfers or cash deposits/withdrawals should be adjusted in Tally after import.
How much does it cost?
10 free pages on signup, then 1 credit per page (or covered under your subscription plan).
What happens to the file?
Uploaded statement PDFs and generated XML files are permanently deleted within 24 hours (with 1-hour and 6-hour options available in settings).
Do I still get Excel or CSV?
Yes. The same conversion allows you to download Tally XML, Excel (XLSX), or CSV. Many practices review in Excel, then import the XML.
Which banks are supported?
Upload the account-statement PDF. Dedicated pages cover SBI, HDFC, ICICI, Axis, Kotak, Bank of Baroda, PNB, Canara, Union Bank, IDFC FIRST, YES Bank, and IndusInd. Password-protected PDFs are supported.
What if the PDF is password-protected?
Enter the statement password when prompted. It is used in server memory to unlock the file and is never stored or logged.
Will this create the right ledgers automatically?
No. Tally rejects vouchers if a referenced ledger does not already exist. You should create the bank ledger and a Suspense ledger before importing. Toolzy does not publish an accuracy rate.
Does this file GST or ITR?
No. The converter prepares files for the books and for working papers. Filing stays with you. The ITR agent is a separate tool for AY 2026-27 preparation.
Convert this statement to Tally XML
Convert this statement to Tally XML. Preview the first page without signing in. New accounts get 10 free pages. Files are deleted within 24 hours. For a stack of client files, start from the page for CAs and bookkeepers. If you need Excel only, the same upload can download XLSX or CSV.