Tally Bank Statement Import Option Not Showing

1. The menu option isn't there at all
2. The option is there, but your bank ledger isn't in the list
3. Everything appears, but the file is refused or imports nothing

1. The menu option isn't there

Check your Tally release. Bank statement import with auto-reconciliation is a Tally Prime feature, and auto-creation of vouchers from the statement needs Release 6.0 or later. If you are on Tally ERP 9, this feature does not exist there — ERP 9 can import vouchers from XML, but not bank statements with matching. Upgrade, or use the XML voucher route.

Check you are pressing Import, not Export. From the Gateway of Tally the shortcut is Alt+O. Bank Statement appears in that list alongside Vouchers, Masters and so on.

Check banking features are enabled for the company. If banking is switched off in company features, the banking-related options don't render.

2. Your bank ledger isn't in the list

This is the most common version of the problem, and the cause is almost always an incomplete ledger.

Tally will only offer a ledger for bank statement import if it has been set up as a bank account properly. Open the ledger and confirm all of these are filled in:

• Bank Name
• Bank Account No.
• IFSC

A ledger grouped under Bank Accounts but missing the account number or IFSC will exist happily for ordinary vouchers and simply not appear in the import list. Fill in the missing fields, save, and reopen the import screen.

Also confirm the ledger is under the Bank Accounts group rather than a general group that happens to be named after your bank.

3. The file is refused, or imports nothing

Assuming the ledger is right and the screen appears, the problem is the file.

If your file came from a PDF, this is expected. Tally's documentation is explicit that PDF files, and Excel or CSV converted from a PDF, are not supported by the bank statement import. This is not a setup error and there is no configuration that enables it — see why converted files are refused. Use Tally XML and the voucher import instead.

If it came from your bank's portal, check in this order:

• Was the file edited after downloading? Deleting header rows, reordering columns or reformatting dates stops Tally recognising the layout. Re-download a clean copy and import that without touching it.
• Is your bank on the supported list? Tally recognises 200+ banks, but not every bank, and not every account type at a supported bank. If yours isn't recognised, Tally's guidance is to write to support@tallysolutions.com and ask for the format to be added.
• Is File Type set to Supported? On the import screen this has to be selected explicitly.
• Does the statement period overlap the company's financial year? Rows dated outside it won't create vouchers.

Always set Show Preview to Yes. The preview screen shows what Tally parsed before anything is written. A file that parses into visible nonsense tells you immediately that the layout wasn't recognised, rather than after it has created vouchers.

When none of that works

The voucher import route doesn't depend on any of this. It needs no bank ledger configuration, no supported-bank list, and no recognised layout, because Tally XML states what every value means rather than being pattern-matched.

1. Convert your statement with the Tally XML converter
2. Create any ledgers the file names — Gateway of Tally → Create → Ledger
3. Gateway of Tally → Alt+O → Vouchers, choose Add

You can still reconcile afterwards: import the vouchers, then run Bank Reconciliation against them inside Tally.