How to Convert a Bank Statement to TallyPrime XML/Excel

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 either a direct Tally XML import file or one TallyPrime Excel workbook carrying reviewed vouchers and ledger masters.

What are Tally XML and Tally Excel imports?

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.

If your office prefers the spreadsheet route, TaxFetch creates one TallyPrime-ready Excel workbook: TallyPrime_Import.xlsx. It contains Ledger and Accounting Voucher sheets using Tally’s default-template headers. This is not the original bank Excel statement: upload the raw bank file to TaxFetch first, review the classifications, then download the transformed Tally workbook.

How to convert a bank statement to TallyPrime step by step

1. 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.
2. 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.
3. 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.
4. 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).
5. 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.
6. Choose Tally XML or Tally Excel. Click Download Tally XML for the direct route, or click Tally Excel for one workbook containing both Ledger and Accounting Voucher sheets.
7. Import the selected format into TallyPrime. For XML, open your company and go to Gateway of Tally → Import Data → Vouchers, select the XML file and confirm. For Excel, follow the spreadsheet import steps below. See the live tool for a walkthrough.

How to upload Tally Excel into TallyPrime

Use this path only for the TallyPrime_Import.xlsx workbook generated after your TaxFetch review. Do not try to import the bank’s raw Excel statement directly into TallyPrime.

1. Open the correct company and take a backup. Confirm that the bank ledger name in the export matches the ledger name used by that company.
2. Import ledger masters only when needed. Open Alt+O → Import → Masters, choose Default Template, set Type of Master: Ledger, select TallyPrime_Import.xlsx and choose its Ledger worksheet.
3. Review the Masters import result. Confirm the required bank, party and expense ledgers were created under the reviewed groups.
4. Import vouchers. Go to Alt+O → Import → Transactions, choose Default Template, select the same workbook and choose its Accounting Voucher worksheet.
5. Confirm the import and check the Day Book. Review TallyPrime’s import summary, then inspect a sample of Receipt, Payment and Contra vouchers and any exceptions before treating the batch as final.

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.

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. For Excel, the same workbook includes a Ledger sheet that you can import before its Accounting Voucher sheet when required ledgers do not already exist.

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 direct Tally XML or one TallyPrime workbook with Ledger and Accounting Voucher sheets.
• Ledger heads are suggested automatically and are editable before download — your chart-of-accounts stays intact.
• For Excel imports, choose the workbook’s Ledger sheet first only when masters are missing, then choose its Accounting Voucher sheet for Transactions.
• 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.