For CAs, Accountants & Businesses

Bank statement to Tally-ready vouchers in one upload

Stop re-typing bank entries into Tally. Upload the statement (PDF or Excel, 32+ Indian banks), review the auto-suggested ledger heads — rent, salary, bank charges, repeated UPI vendors grouped automatically — and download a Tally XML you import in one step.

Tally XMLOne-step import
Auto ledgersHeads suggested
32+ banksPDF & Excel
EditableReview before import

The most repetitive job in every accounts office, automated

Bank-entry punching is the most repetitive task in bookkeeping: someone opens the client’s statement, reads each line, decides the ledger — rent, salary, bank charges, a vendor — and types a voucher into Tally. A year’s statement means hundreds of vouchers typed by hand.

TaxFetch already parses and categorises every transaction in the statement. The Tally Export tab turns that into accounting vouchers automatically: payments and receipts get suggested ledger heads from the transaction category, cash deposits and withdrawals become Contra entries, and a counterparty that repeats — a supplier, a customer, a regular UPI vendor — is grouped into its own ledger.

You review the suggestions in a table (every ledger name is editable), then download a Tally XML. Import it via Gateway of Tally → Import Data and every voucher appears in the books — ledger masters are created automatically by the same file. You can also download a TallyPrime-style Excel workbook with Accounting Voucher, Ledger and Import Instructions sheets.

How do I convert a bank statement into Tally entries automatically?

Upload the bank statement PDF or Excel to TaxFetch, open the Tally Export tab, and every transaction is converted into a Receipt, Payment or Contra voucher with a suggested ledger head — rent, salary, bank charges, and repeated vendors grouped into their own ledgers. Review or edit the ledger names, download the Tally XML, and import it via Gateway of Tally → Import Data. Missing ledger masters are created automatically by the same file.

A single year’s bank statement can run to several hundred transactions — each one a voucher an accountant would otherwise type into Tally by hand. · Source: Income Tax Department, Government of India

How statement transactions map to Tally vouchers

Transaction in statementVoucher typeSuggested ledger
Money received (NEFT/UPI credit)ReceiptIncome head or party ledger
Money paid (NEFT/UPI debit)PaymentExpense head or party ledger
Cash deposit / ATM withdrawalContraCash ↔ Bank ledger
Repeated vendor or customerReceipt/PaymentOwn Sundry Debtor/Creditor ledger
Bookkeeping is the most repetitive task in a CA office — converting the statement once and importing it beats typing every voucher by hand.— CA Juber Attar, TaxFetch e-CA Tax Expert

What this tool does for you

Everything you need, built in — no spreadsheets, no guesswork.

📒

Tally XML vouchers

Receipt, Payment and Contra vouchers generated per transaction — import via Gateway of Tally → Import Data in one step.

🏷️

Suggested ledger heads

Rent, salary, interest, bank charges, insurance, EMI and more — mapped automatically from the transaction category.

👥

Vendors auto-grouped

A counterparty that repeats becomes its own Sundry Debtor / Creditor ledger — 40 payments to one supplier land in one ledger.

✏️

Review before import

Every suggested ledger name is editable in the review table, so what enters the books is what you approve.

🧾

Ledger masters included

Ledgers that don’t exist in the company yet are created automatically by the import file — no pre-setup in Tally.

📊

TallyPrime-style Excel

Download Accounting Voucher, Ledger and Import Instructions sheets in one review-friendly workbook.

See it in action

A look inside Bank Statement to Tally

This is exactly what you'll see when you open the tool.

taxfetchindia.com/tools/bank-statement-to-tally
Screenshot of the Bank Statement to Tally tool

Upload a bank statement (PDF or Excel) and get every transaction converted into Tally-ready vouchers with suggested ledger heads — download as Tally XML and import in one step.

Try Bank Statement to Tally →
Watch it work

See Bank Statement to Tally in action

A live demo of what happens the moment you run the tool.

Real results

See what Bank Statement to Tally gives you

Actual screens from the tool — here is exactly what your result looks like.

taxfetchindia.com/tools/bank-statement-to-tallyReview actual Tally vouchers before import

Review actual Tally vouchers before import

See the real Tally Export table with Receipt, Payment and Contra vouchers, editable ledger names and heads, plus the Download Tally XML and Tally Excel actions.

Try Bank Statement to Tally →

How it works

From start to result in four simple steps.

1

Upload the statement

PDF (including password-protected) or Excel from any of 32+ Indian banks — multiple files together if needed.

2

Review suggested ledgers

Open the Tally Export tab, set your bank ledger name, and edit any suggested head in the review table.

3

Download the import file

Choose Tally XML for a direct import, or the TallyPrime-style Excel workbook for a review-friendly hand-off.

4

Import into Tally

Import the reviewed file from Gateway of Tally → Import Data; the required voucher and ledger masters are included.

What users say

Loved by taxpayers across India

Real people who got things done faster with Bank Statement to Tally.

★★★★★
The ledger suggestions removed the slowest part of bank-entry work. We reviewed the few exceptions, imported the XML and had the month booked in a fraction of the usual time.
VSVivek SharmaAccounts manager, Pune✔ Verified
★★★★★
Being able to change both the ledger name and the group before download matters. It gives us automation without giving up our chart-of-accounts discipline.
CNCA Neha KapoorPractising CA, Delhi✔ Verified
★★★★★
The Tally Excel workbook is ideal for a client review. They can see the suggested heads clearly before we import anything into the company books.
KMKunal MehtaAccountant, Mumbai✔ Verified
★★★★★
Repeated UPI suppliers are grouped into their own ledgers instead of being dumped into one generic expense head. That saved a lot of cleanup after import.
RNRiya NairBookkeeper, Kochi✔ Verified
★★★★★
We process statements from several banks every month. The combination of editable vouchers and a ready-to-import XML has made our bookkeeping workflow much more consistent.
CACA Arvind RaoCA firm partner, Bengaluru✔ Verified

Frequently asked questions

Everything you need to know before you start.

How do I import the file into Tally?

Open the company in Tally, go to Gateway of Tally → Import Data → Vouchers (in TallyPrime: Import → Transactions), and select the downloaded XML file. Vouchers and any missing ledger masters are created automatically.

Which Tally versions are supported?

The file uses Tally’s standard XML import format, which works with TallyPrime and Tally.ERP 9.

How are ledger heads decided?

Each transaction’s detected category maps to a standard ledger (rent to Rent Paid, bank charges to Bank Charges, salary credit to Salary Received, and so on). Counterparties that appear repeatedly get their own Sundry Debtor or Creditor ledger. Everything else goes to Suspense so nothing is silently mis-posted — and every name is editable before download.

What about cash deposits and withdrawals?

They are generated as Contra vouchers between Cash and your bank ledger, the way an accountant would enter them.

Which banks and formats are supported?

32+ Indian banks including SBI, HDFC, ICICI, Axis, PNB, Bank of Baroda, Kotak and Canara — as PDF (including password-protected files) or Excel, multiple statements together.

What does it cost?

Uploading and seeing the summary is free. Signing in unlocks the full analysis including the Tally Export tab and downloads — with a free first run to try it on a real statement.

Explore more TaxFetch tools

A complete toolkit for your taxes — all in one place.

Ready to try Bank Statement to Tally?

It's quick, easy and your first use is free. See it work for yourself.

Try the tool →