In TallyPrime, the bank statement import is in the Import menu, not under Banking: Gateway of Tally > Alt+O (Import) > Bank Statement. If you are in the right place and the option, your bank ledger or your file still will not appear, the cause is almost always one of seven things. Most of them are a ledger setting, not a problem with your file.

Work through them in this order. Each fix says what you will see when it is the cause.

The seven causes at a glance

What you seeMost likely causeFix
No bank statement option under BankingIt moved to the Import menu1
Import screen opens, but your bank ledger is not in the listThe ledger is not under Bank Accounts2
Ledger is under Bank Accounts and still not listedBank name, account number or IFSC missing from the ledger3
Your bank is not in the List of Banks at allTally has no import format for that bank yet4
Everything is listed, but the file is refusedWrong file type, file open, or no write permission5
Import finishes, but no transactions appearDates outside the period or before the Reconciliation Beginning Date6
“Bank Statement already imported”The same statement went in before7

1. You are looking under Banking instead of Import

Most guides written for Tally.ERP 9 send you to Banking > Bank Reconciliation and tell you to look for an import button there. In ERP 9 that is where it lived, and Tally’s ERP 9 help states that those import and view buttons were available only for bank ledgers with auto reconciliation switched on. So on ERP 9, a missing button usually meant the ledger had not been configured.

TallyPrime moved it. Tally’s current help gives the route as:

  1. From the Gateway of Tally, press Alt+O (Import).
  2. Choose Bank Statement.
  3. Select the Bank Ledger, set the File Path, pick the file, and set Show Preview to Yes so you can check the rows before they go in.

Tally’s bank reconciliation help is written for TallyPrime Release 6.0 and later. If you are on an older release, the screens may not match the help you are reading. Check your release under Help (F1) > About before you go further.

2. Your bank ledger is not under Bank Accounts

This is the most common reason the import screen opens with your bank missing from the Bank Ledger list. Tally only treats a ledger as a bank, with the banking options that come with it, when it sits under the Bank Accounts group, or Bank OD A/c for an overdraft or cash credit account.

Ledgers created in a hurry often end up under Current Assets, Loans (Liability) or a group someone made for the client. They show balances like any other ledger. They just never get the bank settings.

To check: open the ledger for alteration (Gateway of Tally > Alter > Ledger), look at the Under field, and change it to Bank Accounts or Bank OD A/c. Save with Ctrl+A. The bank configuration fields described in the next fix only appear after this change.

3. The bank details are missing from the ledger

Tally’s own answer to “I am not seeing my Bank Ledger in the list of options” is to set up the bank ledger with its Bank Name, Bank Account No and IFSC. The Bank Name has to be chosen from Tally’s List of Banks, not typed into the ledger name. That selection is how Tally knows which bank’s statement layout to expect.

While the ledger is open, set Set/Alter Bank configuration to Yes. On the Bank Configuration screen:

  • Check the Reconciliation Beginning date. It defaults to the first day of the financial year, which matters in fix 6.
  • Set Set/Alter Auto Reconciliation configuration to Yes if you want imported rows matched against your entries, or turned into vouchers. This is where you choose the voucher type for deposits (usually Receipt) and withdrawals (usually Payment), and a separate type for transfers between your own accounts if you want one.

Save the ledger and run Alt+O > Bank Statement again. The ledger should now be in the list.

4. Your bank is not on Tally’s supported list

TallyPrime’s Bank Statement import is not a general spreadsheet reader. It holds a format for each bank it supports, so a bank missing from the List of Banks has no format to import against. Tally’s help is direct about this: if your bank or its statement format is not supported, write to [email protected] and they will set it up.

Two other routes exist while you wait:

  • Connected Banking. For banks Tally has connected, TallyPrime can fetch the statement for you, with no file to download.
  • Entering the vouchers some other way. Typing them, building a Tally XML voucher file, or a connector that creates the vouchers. These do not depend on Tally’s bank list at all. They are compared in what TallyPrime will and will not import.

5. The option is there, but your file is refused

If the ledger is listed and the import still fails, look at the file. Tally’s help and FAQ name these causes:

Problem with the fileWhat to do
It is a PDFNot accepted. Download the statement again from net banking as Excel or CSV
It is an Excel or CSV made from a PDFAlso not accepted. Tally’s help names this case separately. A tidy spreadsheet in your own column order matches no bank’s format
CSV that is not comma-separatedTally’s FAQ asks for comma-delimited CSV
Excel in an older formatTally’s FAQ asks for .xlsx. Open the bank’s file and save it as .xlsx without editing it
The file is open in ExcelClose it. Tally will not read a statement that is open
“Not a valid format”Tally has to set up that statement format. Send a sample to Tally support
The folder is read-onlyTally needs write permission to the folder the file is in. Move the file to a local folder you own

One more cause, from the statements we read every day: some Indian banks download a CSV with an .XLS name. It is plain comma-separated text with a spreadsheet extension. Excel opens it, often with a warning that the format and extension do not match. Import tools that trust the extension can call it corrupt. If a file behaves strangely, open it in Notepad. If you see commas and quotes instead of garbled characters, it is a CSV, and you should save it as one.

If Tally says the statement is already open after you have closed it, Tally’s FAQ suggests adding -imp to the file name and choosing the file again through Show More.

If you edited the file, deleting header rows, renaming columns or removing blank lines, you have moved it away from the bank’s layout. Download a fresh copy and import that as it is.

6. The import worked, but no transactions show

TallyPrime only shows imported rows that fall inside the period you are viewing and after the bank ledger’s Reconciliation Beginning date. Anything earlier is held back without much warning.

  • To see what came in, press Alt+G (Go To), open Imported Bank Data, and press F2 to widen the period.
  • If the rows are there but missing from Bank Reconciliation, the statement starts before the Reconciliation Beginning date. Move that date back in the ledger’s Bank Configuration screen, or enter the earlier items through Opening BRS. Back-dated bank reconciliation in TallyPrime walks through both, step by step.

Once the rows are visible, the Bank Reconciliation Summary shows the balance as per your books beside the balance as per the bank. How to check a bank statement in Tally walks through reading that screen.

7. “Bank Statement already imported”, or the wrong statement went in

Tally warns when you import a statement it already holds, which protects you from importing the same month twice. If the wrong file went in, or a bad import needs undoing, Tally’s FAQ gives this route:

  1. Press F1 (Help) > Troubleshooting > Reset Bank Statement Data.
  2. Select the bank ledger and enter the From and To dates.
  3. Set Retain Reconciliation Status to Yes if you want to keep the reconciliation you have already done.

You cannot delete one imported transaction on its own. The smallest unit you can reset is one date, so reset the period and import the correct file again.

When the real problem is that the statement is a PDF

Fixes 1 to 7 assume you have the file your bank’s portal produced. Often you do not. Clients forward the PDF their bank emailed them, branches hand over printouts, and nobody gives their accountant net banking access to download it again as Excel. No ledger setting will make TallyPrime accept that file.

That is the case SmartXtract is built for. You upload the statement as a PDF, scan, Excel or CSV. Password-protected files are opened by typing the password at upload. Every row is checked against the statement’s own running balance, so a misread figure shows up as a break instead of sitting quietly in your books. You get a clean Excel file. How a bank statement PDF gets into Tally shows the full flow.

That Excel goes into Tally through Tally Connector, a free Windows app that runs beside TallyPrime on the same PC. It suggests a ledger for each narration and remembers a payee you have mapped once. You review and Apply, then it creates the receipt, payment and contra vouchers. Because it creates vouchers rather than importing a bank statement, it does not depend on your bank being on Tally’s import list. Undo Import reverses a whole batch if something went in wrong.

If your bank does give you a supported Excel file, Tally’s own import is free and already installed, so use it: importing a bank statement into TallyPrime from Excel covers every step. If it does not, try SmartXtract on one statement. You get 20 pages free with no card.

The order to check things in

When the option or the ledger is missing, check the ledger before the file. Start with the menu (Alt+O, not Banking), then the group (Bank Accounts), then the bank details (Bank Name from the list, account number, IFSC), then whether your bank is supported. Only once the ledger appears does the file matter.

If the bank is not supported, or all you have is a PDF, stop changing settings. Ask the bank for Excel, ask Tally support to add the format, or use a route that creates the vouchers directly. For a monthly flow of PDF statements across clients, start free with 20 pages.

Frequently asked questions

Where is the bank statement import option in TallyPrime?

In the Import menu. From the Gateway of Tally press Alt+O (Import) and choose Bank Statement. It is not under Banking > Bank Reconciliation, where Tally.ERP 9 kept it, which is why guides written for ERP 9 send people to the wrong screen.

Why is my bank ledger not showing when I import a bank statement in TallyPrime?

Usually because the ledger is not set up as a bank. It must sit under the Bank Accounts group, or Bank OD A/c for an overdraft, and it must have the Bank Name chosen from Tally’s List of Banks, with the account number and IFSC filled in. Fix those in the ledger, save, and the ledger appears in the import list.

Why does TallyPrime say my bank statement is not a valid format?

Either the file is not your bank’s original download, or Tally has not set up that bank’s statement format. PDFs, and Excel or CSV files made from a PDF, are always refused. An unedited Excel (.xlsx) or comma-delimited CSV from net banking should import. If it still fails, send a sample to [email protected] so they can add the format.

Why are imported bank transactions not showing in TallyPrime?

TallyPrime only shows imported rows inside the current period and after the bank ledger’s Reconciliation Beginning date. Open Alt+G > Imported Bank Data and press F2 to widen the period. If the rows are there but missing from reconciliation, move the Reconciliation Beginning date back in the ledger’s Bank Configuration.

How do I delete a wrongly imported bank statement in TallyPrime?

Go to F1 (Help) > Troubleshooting > Reset Bank Statement Data, select the bank ledger and enter the dates. Set Retain Reconciliation Status to Yes to keep your reconciliation. Single transactions cannot be deleted. The smallest unit you can reset is one date.

What can I do if my bank is not supported for statement import in TallyPrime?

Write to [email protected] with a sample statement and ask for the format to be added. Check whether your bank works with Connected Banking, which fetches statements without a file. Or enter the vouchers by a route that does not use the bank list: typing them, a Tally XML voucher file, or a connector that creates the vouchers in Tally directly.