Every accountant and CA knows the routine: open the client’s bank statement, read each line, decide the ledger — rent, salary, bank charges, a vendor — and type a voucher into TallyPrime. An active current account can produce hundreds of voucher entries in a year. This guide shows you a faster path: convert the PDF or Excel bank statement to a Tally XML import file that carries every reviewed voucher and required ledger master, ready for import.
By the numbers: Over 7.28 crore Income Tax Returns were filed for AY 2024‑25 — a record high — reflecting the scale of bookkeeping work Indian CAs and accountants handle every filing season. Clean, reconciled books that match the bank statement are essential for every one of those returns. Source: Press Information Bureau, Government of India.
Manual bank entry vs. Tally XML import: at a glance
| Method | Voucher setup | Review control | Ledger masters |
|---|---|---|---|
| Manual typing in TallyPrime | Each voucher entered separately | Checks happen during data entry | Created one by one |
| Spreadsheet template upload | Rows mapped to a fixed template | Format and classification reviewed in the sheet | Depends on the template and company setup |
| Generated Tally XML (TaxFetch) | Statement rows converted in bulk | Suggested vouchers and Suspense rows reviewed before export | Required masters included in the import file |
“The most common bookkeeping mistake is importing without reviewing the ledger suggestions. Run through the review table first so ambiguous entries do not become avoidable clean-up work later.” — CA Juber Attar, TaxFetch e-CA Tax Expert
What is Tally XML import and why does it matter?
TallyPrime supports a standard XML import format that lets you load vouchers and ledger masters from an external file directly into a company. Instead of entering 200 bank transactions one by one, you import a single XML file via Gateway of Tally → Import Data → Vouchers (or Import → Transactions in newer TallyPrime builds) and every entry appears in the books instantly. The same file can include ledger master definitions, so new ledgers — a vendor you have never billed before, a new expense head — are created automatically on import without any pre-setup in Tally.
The critical requirement is that the XML must conform to Tally’s schema: the right envelope tags, correct voucher types (Receipt, Payment, Contra), and valid debit/credit pairs that balance to zero. Generating this by hand from a bank statement is tedious and error-prone. Automation handles the structure so you can focus on reviewing and approving the ledger suggestions before anything enters the books.
How to convert a bank statement to TallyPrime step by step
- Download your bank statement. Log in to your bank’s net banking portal and download the statement in PDF (preferred) or Excel/CSV format. Password-protected PDFs are supported. If you have multiple months or multiple accounts, you can upload several files together.
- Upload to TaxFetch. Go to TaxFetch Bank Statement to Tally and drag-and-drop your file (or use the upload button). The tool parses 32+ Indian banks — SBI, HDFC, ICICI, Axis, PNB, Bank of Baroda, Kotak, Canara, and more — in both PDF and Excel formats.
- Let the analyser categorise every transaction. TaxFetch reads each row, detects whether it is a credit or debit, identifies the transaction type (rent, salary, bank charges, UPI vendor, EMI, etc.), and groups repeated counterparties — a supplier who appears 40 times gets a single Sundry Creditor ledger instead of 40 separate entries.
- Open the Tally Export tab and set your bank ledger name. In the Tally Export tab you will see a full review table: one row per transaction, each with a suggested voucher type and a suggested ledger head. Type the ledger name your Tally company uses for this bank account (e.g., HDFC Bank Current A/C).
- Review and edit the suggested ledger heads. Every suggestion is editable. Check high-value entries and any rows the tool has placed into Suspense (a safe fallback for unrecognised transactions). Correct the ledger name and group where needed. This review step is the most important part — what you approve here is exactly what enters TallyPrime.
- Download the Tally XML (or TallyPrime-style Excel workbook). Click Download Tally XML for a direct import file. Alternatively, download the Excel workbook (Accounting Voucher + Ledger + Import Instructions sheets) if you prefer a client-review hand-off before the final import.
- Import into TallyPrime. Open your company in Tally, go to Gateway of Tally → Import Data → Vouchers, select the downloaded XML file, and confirm. All vouchers and any new ledger masters are created automatically. No pre-setup required. See the live tool for a walkthrough.
Which voucher types are generated?
The converter maps each bank transaction to the correct TallyPrime voucher type:
| Bank transaction | Tally voucher type | Debit | Credit |
|---|---|---|---|
| Outward payment (debit) | Payment | Expense / vendor ledger | Bank ledger |
| Inward receipt (credit) | Receipt | Bank ledger | Income / customer ledger |
| Cash deposit | Contra | Bank ledger | Cash ledger |
| Cash withdrawal | Contra | Cash ledger | Bank ledger |
| Bank charges / interest debit | Payment | Bank Charges / Interest ledger | Bank ledger |
Unrecognised transactions fall into a Suspense ledger so nothing is silently mis-posted — you spot them in the review table and reclassify before downloading.
How are ledger heads suggested automatically?
The tool maps each detected transaction category to a standard ledger name:
- Rent payments → Rent Paid (Indirect Expenses)
- Salary credits received → Salary Received (Indirect Income)
- Bank charges, SMS alerts → Bank Charges (Indirect Expenses)
- Loan EMI debits → Loan Repayment / EMI Paid
- Repeated UPI vendor (e.g., same merchant 15 times) → its own Sundry Creditor ledger
- Insurance premium → Insurance Premium (Indirect Expenses)
- Interest income → Interest Received (Indirect Income)
Every ledger name and group is editable in the review table before you download, so your chart-of-accounts discipline is preserved. The tool makes suggestions — a qualified accountant makes the final call. For deeper transaction insights, also see TaxFetch Bank Statement Analysis for CAs.
What about password-protected bank PDFs?
Most Indian bank PDFs are password-protected with the account holder’s date of birth or PAN. TaxFetch accepts password-protected PDFs — you enter the password during upload and it is used only to unlock the file for parsing; it is never stored. If you are unsure of the password format, check your bank’s net-banking help page (most SBI statements use DD-MM-YYYY, most HDFC statements use the first four letters of the account holder’s name plus the date of birth).
Can I upload multiple bank accounts or months together?
Yes. You can upload multiple PDF or Excel files in one session — for example, three months of a current account plus a savings account. The tool parses each file and combines all transactions into one review table. This is particularly useful for CAs handling a client’s full financial year in one pass.
Is it safe to import without reviewing?
The short answer is: always review before importing. The suggested ledger heads are automated — common, clearly labelled transactions such as bank charges or rent are easier to classify, while ambiguous narrations may need correction. Scan the Suspense rows, check high-value payments and confirm vendor names before export. TaxFetch does not claim Tally affiliation, and the tool is not a substitute for professional accounting judgment.
Stop re-typing bank entries into Tally
Upload your bank statement — PDF or Excel, 32+ Indian banks — review the auto-suggested vouchers and ledger heads, and import a clean Tally XML in minutes. Free to try on your first statement.
Try Bank Statement to Tally →Frequently asked questions
Which banks and file formats are supported?
TaxFetch supports 32+ Indian banks including SBI, HDFC Bank, ICICI Bank, Axis Bank, PNB, Bank of Baroda, Kotak Mahindra Bank, Canara Bank, Union Bank, IDFC FIRST Bank, Yes Bank, IndusInd Bank, and more — in PDF (including password-protected) or Excel/CSV format. You can also upload multiple files together.
Which TallyPrime versions does the import file work with?
The generated XML uses Tally’s standard voucher-import format for TallyPrime and Tally.ERP 9 versions that accept XML imports. The menu path varies by release: use the Transactions option under Import in TallyPrime, or Import Data → Vouchers in Tally.ERP 9. Always take a company backup or test the first import in a copy.
Do ledger masters need to be created in Tally before importing?
No. The Tally XML file includes ledger master definitions alongside the vouchers. Any ledger that does not yet exist in the company is created automatically on import — no pre-setup required. You can also download the TallyPrime-style Excel workbook, which contains a separate Ledger sheet for review before import.
What happens to unrecognised transactions?
Any transaction the tool cannot confidently categorise is assigned to a Suspense ledger. You see these clearly in the review table and can reclassify them before downloading. Nothing is silently mis-posted.
Is there a cost to use the tool?
Uploading a statement and viewing the transaction summary is free. Signing in unlocks the full Tally Export tab (voucher review + download) with a free first run so you can verify the output on a real statement before committing. Visit the Bank Statement to Tally page for current plan details.
Key takeaways
- Upload a PDF or Excel bank statement → get a complete Tally XML with Receipt, Payment, and Contra vouchers.
- Ledger heads are suggested automatically and are editable before download — your chart-of-accounts stays intact.
- Ledger masters are included in the import file — no pre-setup in TallyPrime needed.
- Repeated UPI vendors and counterparties are grouped into their own ledgers.
- Always review the suggestions before importing so ambiguous entries are corrected before they reach the books.
- Works with 32+ Indian banks, PDF & Excel, TallyPrime & Tally.ERP 9.
Ready to cut your bank-entry time? Try the Bank Statement to Tally tool on a real statement — or explore Bank Statement Analysis for CAs for deeper financial red-flag detection alongside the Tally export.
