Convert Bank Statement PDF to Tally XML Vouchers
Your bank gave you a PDF statement, but Tally needs XML vouchers. AI reads the PDF layout, extracts every transaction, and builds import-ready XML — no manual data entry, no Excel middleman.
For TallyPrime, Tally ERP 9, and TallyPrime 7.0. Works with every Indian and international bank. Free online.
How It Works
Upload Bank Statement PDF
HDFC, SBI, ICICI, Axis, Kotak, or any bank worldwide. Digital and scanned PDFs both supported — built-in OCR handles even low-quality scans.
AI Extracts & Maps Transactions
Date, narration, debit/credit amounts, and running balance parsed from the PDF layout. Voucher types (Payment, Receipt, Contra) assigned automatically.
Download Tally XML
Properly structured ENVELOPE > TALLYMESSAGE > VOUCHER XML. Import via Gateway of Tally > Alt+O (Import) > Vouchers in TallyPrime or ERP 9.
PDF or CSV — Which Path to Tally?
Your bank may offer both PDF statements and CSV downloads. Each takes a different conversion path to Tally.
PDF to Tally (This Tool)
- AI reads the visual layout of the PDF
- Works with scanned & photographed statements
- Handles any bank without templates
- Best when bank only provides PDF
- OCR extracts text from images
CSV to Tally
- Reads structured columns directly
- Faster — no OCR step needed
- 100% accuracy on clean CSVs
- Best when bank offers CSV download
- Use CSV to Tally instead
Two Ways to Get Bank Data Into Tally
TallyPrime offers built-in bank statement import for reconciliation — but it has limitations. XML voucher import gives you full control.
TallyPrime Built-in Import
- Supports 145+ pre-configured banks
- CSV, Excel, PDF formats accepted
- For reconciliation only — matches existing vouchers
- Won't work if your bank isn't in the list
- Doesn't create new voucher entries
XML Voucher Import (This Tool)
- Creates new vouchers from bank data
- Works with any bank — no pre-configured list
- You control ledger assignments
- Supports Payment, Receipt, Contra types
- Use for entry + reconciliation
Works With Every Bank Statement PDF
Indian banks format PDF statements differently — some use landscape, some portrait, some have separate debit/credit columns, others use a single amount column with Cr/Dr suffixes. Our AI reads the visual layout, not a fixed template.
What is PDF?
Portable Document Format
Bank statements arrive as PDFs — visually formatted for printing, not for software import. Every bank uses a different layout, table structure, and column order. Tally cannot read PDFs at all — the transactions must be extracted and restructured into XML.
What is Tally XML?
Tally XML Voucher Format
Tally's native import format using ENVELOPE > TALLYMESSAGE > VOUCHER tags. Each transaction becomes a balanced voucher entry with ledger names, amounts, narrations, and YYYYMMDD dates. Imports via Gateway of Tally > Import in both TallyPrime and ERP 9.
Why This Tool
AI Reads Any Bank PDF
HDFC, SBI, ICICI, Axis, Kotak, PNB, Canara, Federal, Yes Bank, IDFC FIRST — or any international bank. No templates or per-bank configuration needed.
Scanned PDF & OCR
Built-in OCR handles scanned statements, passbook photocopies, and faxed bank letters. No separate Tesseract or Adobe OCR step required.
Auto Voucher Classification
Debits become Payment vouchers, credits become Receipt vouchers, and bank-to-bank transfers map to Contra. No manual voucher type selection.
UPI/NEFT/RTGS Preserved
Indian bank PDFs include payment mode codes (UPI/CR, NEFT/CR, RTGS, IMPS) in descriptions. These are preserved in XML narration fields for transaction identification in Tally.
Multi-Page Extraction
A 50-page annual statement becomes one XML file. Transactions spanning page breaks are stitched correctly — no gaps, no duplicates from running balance rows.
YYYYMMDD Dates Handled
Your PDF shows dates as DD/MM/YYYY, DD-Mon-YY, or other formats. The XML output uses YYYYMMDD — Tally's required format. No "Invalid Date" errors on import.
When to Use This
Monthly Voucher Entry
CA firms and bookkeepers receiving client bank statements as PDFs via email or WhatsApp. Convert to XML and import — skip hours of manual voucher typing in Tally.
Bank Reconciliation (BRS)
Import PDF statement as vouchers, then use TallyPrime's Auto-BRS to match against book entries. Faster than manual reconciliation for statements with 200+ transactions.
Year-End Catch-Up
Importing 6-12 months of old bank statements for year-end closing, tax filing, or audit preparation. Bulk convert PDFs to XML instead of typing each voucher.
How to Import XML Vouchers Into Tally
TallyPrime (Recommended)
- Open your company in TallyPrime
- Press Alt+O (Import) from Gateway
- Select Vouchers as import type
- Browse to your downloaded .xml file
- Review the import summary and confirm
- Check Tally.Imp log for any errors
Tally ERP 9
- Open your company in Tally ERP 9
- Go to Gateway > Import Data
- Select the .xml file to import
- Tally processes vouchers automatically
- Verify entries in the Day Book
- Run Bank Reconciliation to match
PDF-to-Tally Import Issues & Fixes
"Ledger does not exist" error during XML import
Every ledger name in the XML — bank account and offset ledgers — must exist in your Tally company. Names must match exactly including spaces and capitalization. In TallyPrime, enable "Create new ledger while importing" to auto-create missing ones.
Duplicate vouchers after re-importing the same XML
Tally checks voucher numbers for duplicates. If your numbering method is "Automatic", Tally may assign new numbers and import duplicates. Set voucher numbering to "Manual" with "Prevent Duplicate" enabled before re-importing.
Scanned PDF produces garbled or missing transactions
Low-resolution scans (under 200 DPI), faded ink, or handwritten annotations reduce OCR accuracy. Re-scan at 300 DPI minimum. Password-protected PDFs are unlocked automatically during processing.
Import errors logged in Tally.Imp but no detail shown on screen
Tally writes all import errors to the Tally.Imp file in your TallyPrime installation folder. Open this file in Notepad to see which specific vouchers or ledgers caused the failure.
Amounts appear in wrong columns (debit shown as credit or vice versa)
Some Indian bank PDFs use Cr/Dr suffixes, others use separate columns, and some use positive/negative amounts. If amounts look inverted in Tally, check the original PDF to verify how your bank represents debits and credits.
What the Tally XML Looks Like
Each transaction from your PDF becomes a structured XML voucher that Tally reads natively.
<ENVELOPE>
<HEADER>
<TALLYREQUEST>Import Data</TALLYREQUEST>
</HEADER>
<BODY>
<IMPORTDATA>
<REQUESTDESC>
<REPORTNAME>Vouchers</REPORTNAME>
</REQUESTDESC>
<REQUESTDATA>
<TALLYMESSAGE>
<VOUCHER VCHTYPE="Payment" ACTION="Create">
<DATE>20260315</DATE>
<NARRATION>NEFT/CR/HDFC0001234/Vendor Payment</NARRATION>
<PARTYLEDGERNAME>HDFC Bank - Current A/c</PARTYLEDGERNAME>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>Office Expenses</LEDGERNAME>
<AMOUNT>15000.00</AMOUNT>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>HDFC Bank - Current A/c</LEDGERNAME>
<AMOUNT>-15000.00</AMOUNT>
</ALLLEDGERENTRIES.LIST>
</VOUCHER>
</TALLYMESSAGE>
</REQUESTDATA>
</IMPORTDATA>
</BODY>
</ENVELOPE>Dates always in YYYYMMDD format. Amounts are balanced — debit is positive, credit is negative. Ledger names must match your Tally Chart of Accounts.
Frequently Asked Questions
Why not just import the PDF directly into TallyPrime?
TallyPrime's built-in bank statement import supports CSV, Excel, and PDF for reconciliation — but only for 145+ pre-configured bank formats. If your bank isn't in that list, or you need voucher creation (not just reconciliation), you need XML. Our tool generates import-ready XML from any bank's PDF.
How is this different from your CSV-to-Tally tool?
CSV-to-Tally works when your bank gives you a downloadable CSV. PDF-to-Tally handles cases where you only have a PDF statement — the AI reads the visual layout and extracts transactions that a CSV parser can't. Use whichever matches what your bank provides.
Can it handle scanned or photographed bank statements?
Yes. Built-in OCR processes scanned PDFs, faxed copies, and photos of printed statements. For best results, scan at 300 DPI or higher. Low-resolution scans (under 150 DPI) or heavily faded text may reduce accuracy.
What voucher types does the XML contain?
Payment vouchers for debits (expenses, vendor payments, EMIs), Receipt vouchers for credits (income, refunds, interest), and Contra vouchers for bank-to-bank or bank-to-cash transfers. Auto-detected from the transaction amounts.
My import fails with "Ledger does not exist" — what do I do?
Every ledger name in the XML must exist in your Tally company data — the bank ledger and all offset ledgers. Names must match exactly including spaces and capitalization. Create missing ledgers first, or enable "Create new ledger while importing" in TallyPrime.
Does it handle UPI, NEFT, RTGS, and IMPS transactions?
Yes. Indian bank PDFs often include payment mode in the narration (UPI/CR, NEFT/CR, RTGS, IMPS). These are preserved in the XML narration field so you can identify transaction types in Tally.
Can I use this for bank reconciliation (BRS) in TallyPrime?
Yes. Import the XML vouchers first, then run Bank Reconciliation from Gateway > Banking. TallyPrime's Auto-BRS (Release 6.0+) can match imported vouchers against your book entries automatically.
EazyAUTO4 charges $81/month and XLTOOL requires a desktop add-on. Is this free?
Yes. Free conversions with no signup and no desktop software to install. Works entirely in your browser. Paid plans from $15/month for high-volume users.
Is my data secure?
Encrypted in transit via TLS, processed in memory, never stored. Your bank statement PDF is deleted immediately after conversion.
Related Tools
CSV to Tally XML
Convert CSV financial files to Tally-compatible XML for Tally ERP 9 and TallyPrime. Maps rows to voucher entries. Free, instant, no signup required.
Convert now →PDF to CSV
Extract transactions from bank statement PDFs to CSV. AI-powered, works with any bank in any language. Accurate date and amount extraction. Free, no signup.
Convert now →PDF to Excel
Turn bank statement PDFs into formatted Excel spreadsheets. Keeps all columns, headers, and transaction details. Any bank, any language. Free, no signup.
Convert now →Excel to Tally XML
Convert Excel (XLSX/XLS) files to Tally-compatible XML for Tally ERP 9 and TallyPrime. Maps rows to voucher entries. Free, instant, no signup required.
Convert now →