How to import a bank statement into Tally

The short answer on “bank statement to Tally XML”

Many converters sell a “bank statement to Tally XML” step. You often don’t need it. TallyPrime has two Excel-based routes, and which one works depends on where your file came from.

Your file	Tally route	Works?
Excel or CSV downloaded from your bank’s portal	Alt+O (Import) → Bank Statement	Yes, if Tally supports your bank and format
PDF statement (emailed, old, from a client)	Bank Statement import	No. Tally says PDF and CSV/Excel converted from PDF aren’t accepted
PDF converted to Excel, reshaped as vouchers	Import from Excel (vouchers)	Yes, in TallyPrime releases that include Excel import
PDF converted to Excel	Manual reconciliation in Excel	Yes, any release

BankConv converts PDF statements to Excel, CSV and Google Sheets. It doesn’t produce Tally XML. Below is the honest route for each case.

Route 1: Use the bank’s own Excel download when you can

If you can still download the period from net banking, do that. It’s the route Tally supports best.

Most Indian banks let you download recent account statements as Excel or CSV from internet banking. The HDFC Bank, ICICI Bank, SBI and Axis Bank pages explain where. Then in TallyPrime:

1. From Gateway of Tally, press Alt+O (Import) and choose Bank Statement.
2. Select the Bank Ledger, the File Path and the file. Set Show Preview to Yes.
3. Press Ctrl+A to import, then I on the preview screen.
4. Press S for the Bank Reconciliation Summary.

Before importing, Tally checks three things: the statement date is after the ledger’s Reconciliation Beginning Date, the file isn’t open in Excel, and you have write permission on the folder. Tally publishes the list of supported banks and formats. Shortcut keys and screens can differ between TallyPrime releases, so check against your version.

Route 2: PDF-only statements, converted to Excel and imported as vouchers

When the PDF is all you have, convert it, then import vouchers instead of a bank statement. This is the route most “Tally XML” tools automate.

PDF-only cases are common: e-statements emailed as password-protected PDFs, statements older than the portal’s download window, and PDFs a client sends their CA.

Step 1: Convert the PDF to Excel

1. Upload the PDF to BankConv’s bank statement to Excel converter. Enter the PDF password when asked; it is used once and never stored.
2. Compare the rows on screen with the PDF.
3. Download the Excel file. A free account is needed to download.

You get one row per transaction with Date, Narration, Cheque/Ref No., Withdrawal, Deposit and Balance, in the bank’s own column names.

Step 2: Reshape the rows as vouchers

Tally’s Import from Excel creates vouchers, not statement lines. Tally’s FAQ says bank transactions can’t come in through Import from Excel as such, so each row must become a voucher with ledgers.

Add these columns next to the converted data:

Column	What goes in it
Voucher Type	Payment for withdrawals, Receipt for deposits, Contra for cash or transfers between your own accounts
Voucher Date	The transaction date
Bank ledger	Your bank ledger name, spelled exactly as in Tally
Party or expense ledger	The other side, such as Electricity Charges or the customer’s ledger
Amount	The withdrawal or deposit amount, as a positive number
Narration	The bank’s description, so you can trace it later

A formula such as =IF(E2>0,"Payment","Receipt"), where E is Withdrawal, fills Voucher Type quickly. Filling in the other-side ledger is the real bookkeeping work. Group by narration (UPI IDs, NEFT names) to fill in repeat parties at once.

Step 3: Import from Excel in TallyPrime

1. Back up the company, or practise on a test company first.
2. Open Alt+O (Import) and look for the option to import Transactions from Excel. In recent releases it sits alongside Bank Statement.
3. Create a mapping template. Tally requires Voucher Type Name, Voucher Date, Ledger Name and Ledger Amount to be mapped.
4. Preview, then import. Tally can’t cancel an import once it starts, so read the summary first.

Tally’s FAQ groups Excel import under TallyPrime Release 4.0. Older versions, including Tally.ERP 9, don’t have it; check Help → About for your release.

What to check before and after importing

Tally won’t tell you a voucher is missing, and a wrong ledger name stops an import. Check these points.

Before:

• Ledger names in the sheet match Tally exactly, including spaces and case.
• Dates are real Excel dates, not text. Indian statements use DD/MM/YYYY; Excel on a US-locale PC may misread them.
• Cheque and UPI reference numbers are stored as text, so long numbers don’t turn into 1.23E+11.
• Opening balance, closing balance and “B/F” rows are deleted.
• Use one worksheet only; Tally imports one sheet at a time.

After:

1. Open the Day Book for the period and count the vouchers. They should equal the transactions on the statement.
2. Open the bank ledger. Its closing balance should equal the statement’s closing balance for the same date.
3. Run Bank Reconciliation and confirm the bank dates.

If the balance is off, filter the sheet by Voucher Type and compare totals of withdrawals and deposits with the statement summary.

When to stay in Excel instead

For a one-off check, a loan file or an audit query, you may not need vouchers at all. Convert the statement to Excel, then tick off entries against the Tally ledger exported to Excel. A COUNTIFS on date and amount finds the unmatched rows quickly.

For pricing on large backlogs, see pricing. Uploaded files and outputs are deleted after 24 hours; see security. The India banks hub lists the banks covered.