To import a bank statement into TallyPrime from Excel, use Alt+O (Import) > Bank Statement, not Import Data from Excel. The file has to be the Excel your bank’s net banking produced, unchanged, and your bank has to be on Tally’s supported list. Importing brings the bank’s lines into TallyPrime. To turn them into receipts and payments, you then create vouchers from the Bank Reconciliation screen, and those vouchers arrive as Optional until you mark them Regular.

This guide covers the whole route in order: the one-time ledger setup, the import itself, creating the vouchers, and checking that the month came in complete. It also covers what to do when the Excel you have is not one Tally will take.

Will your Excel file work? Check this first

Most failed imports are decided before you open TallyPrime. Tally’s import does not read any spreadsheet. It recognises each supported bank by that bank’s own file layout, so the question is where your file came from and what has happened to it since.

The Excel you haveWill TallyPrime’s import take it?What to do
Downloaded from net banking as Excel, not edited, and your bank is on Tally’s listYesFollow the steps below
The same download, but someone deleted the logo rows, renamed columns or added notesUsually notDownload a fresh copy and import it as it is
An Excel made from a PDF statement, by a converter or by retypingNo. Tally’s help names this caseSee when your Excel is not the bank’s own file
A bank Tally has no import format forNoWrite to Tally support, or use another route below

Tally’s Import Bank Statements help page (last updated 1 September 2026) puts it plainly. You can import statements in CSV or Excel format downloaded from the bank portal. You cannot import a PDF, or a CSV or Excel converted from a PDF. The same page says TallyPrime supports statement import for 145+ banks, and that if yours is not supported you can write to [email protected] to have it set up.

Do not use Import Data from Excel for a bank statement

TallyPrime has two features with “Excel” in the story, and people searching for this task often land on the wrong one. Import Data from Excel brings in masters and vouchers from a mapped spreadsheet. It does not take bank transactions. Tally’s Import Data FAQ says so directly: “Currently, TallyPrime does not support importing bank transactions via the Import Data from Excel feature.”

The feature you want is the Bank Statement import. Everything below uses it.

Step 1: Set up the bank ledger (once per bank account)

The ledger settings decide two things: whether the import screen lists your bank at all, and which voucher types TallyPrime uses when it creates entries from the statement. Do this once and every later month is quicker.

  1. Open the ledger for alteration and check the Under field. It must be Bank Accounts, or Bank OD A/c for an overdraft or cash credit account. A bank ledger filed under any other group never gets the banking options.
  2. Set Set/Alter Bank configuration to Yes. Choose the bank from Tally’s list of banks and fill in the account number and IFSC. Picking the bank here is how TallyPrime knows which file layout to expect.
  3. Check the Reconciliation Beginning date. It defaults to the first day of the financial year. Tally’s import prerequisites require the statement date to be later than this date, so move it back if your statement starts earlier.
  4. Set Set/Alter Auto Reconciliation configuration to Yes. On that screen, set Deposits to Receipt and Withdrawals to Payment. If you want transfers between your own accounts and cash handled separately, set Use a different Voucher Type for Interbank/Cash transactions to Yes and choose Contra or Journal.
  5. Under Identify Exact Matches for Reconciliation, Tally’s setup page shows matching while importing, and while saving vouchers, both set to Yes, with exact matches reconciled automatically. Save with Ctrl+A.

These field names are from Tally’s one-time setup page, updated 14 August 2026. If the ledger still does not appear on the import screen afterwards, our guide to bank statement import not showing in TallyPrime works through each cause.

Step 2: Download the Excel statement from net banking

  1. In net banking, open the account statement and choose the period. Look for the format option next to the download button. Most portals default to PDF, so change it to Excel (or CSV).
  2. Save the file to a folder on your own PC. Tally’s prerequisites ask for write permission to the folder the file is in.
  3. Do not tidy the file. No deleted header rows, no renamed columns, no removed blank lines. The logo rows and the account summary at the top are part of the layout Tally recognises.
  4. Close the file before importing. Tally’s help lists “the statement is not already open” as a prerequisite.

One thing we see often in Indian bank downloads: a file named .xls that is really comma-separated text inside. Excel opens it, sometimes with a warning that the format and extension do not match. If a file behaves oddly, open it in Notepad. Commas and quotes mean it is a CSV.

Step 3: Import the Excel bank statement into TallyPrime

This is the route on Tally’s Import Bank Statements page:

  1. From the Gateway of Tally, press Alt+O (Import) and choose Bank Statement.
  2. On the Import Bank Statement screen, select the Bank Ledger.
  3. Enter the File Path (the folder holding the Excel file).
  4. Set File Type to Supported.
  5. Select the File to Import.
  6. Set Show Preview to Yes, so you see the rows before they go in.
  7. Press Ctrl+A. Check the dates and amounts on the Bank Statement Preview screen, then press I (Import).

The Summary of Imported Statement shows how many entries came in and how many matched vouchers already in your books. Press S to go to the Bank Reconciliation Summary.

Step 4: Turn the imported lines into vouchers

An imported statement is not the same as entries in your books. What you do next depends on whether you had already passed the entries.

  • You had already entered the month. The import is for reconciliation. Lines that agree with your vouchers show as exact matches, and you work through the rest in the Bank Reconciliation report. Our guide to the bank reconciliation statement in TallyPrime covers each match group and its keys.
  • You have no entries yet. You create the vouchers from the imported lines. This is the part most accountants mean when they ask how to import a bank statement from Excel, and it is set out below.

Creating many vouchers at once

From Tally’s auto-create vouchers page (updated 13 August 2026):

  1. Press Alt+G (Go To), open Banking Activities, and press Enter on the count under the Bank Reconciliation column for your bank.
  2. Select the bank lines you want to post.
  3. Press F7 (Create Vch/Multi-Vch).
  4. Give each line its Ledger Name, or fill the Common Ledger field when every selected line goes to the same ledger.
  5. Press Ctrl+A to save. The vouchers are created as Optional.
  6. Press R (Mark as Regular & Reconcile) to make them regular vouchers and reconcile them.

Two details on the same page save a failed attempt. If your voucher numbering is Manual, or Prevent duplicate voucher numbers is on, Tally asks you to back up and switch numbering to Automatic (Manual Override) first. And from Release 7.1, multi-voucher creation asks for bill-wise details. You can turn that off with F12 (Configure) > Use Bill-wise Details in Multi Voucher Creation: No.

One voucher for many lines

For a run of similar lines you want as a single entry, such as a month of small card charges, select them in the Bank Reconciliation report and press Alt+F7 (Create Voucher (Consolidate)). Choose the ledger and save with Ctrl+A.

Which voucher type each line becomes

The voucher type is not chosen line by line. It comes from the Auto Reconciliation Configuration you set in step 1.

Bank lineVoucher typeSet by
Money in (deposit, NEFT received, UPI received)ReceiptDeposits
Money out (payment, charges, UPI paid)PaymentWithdrawals
Transfer between your own bank accounts, cash deposit or withdrawalContra or JournalInterbank/Cash Transactions, if switched on

If you are unsure which type a line should be, our guide to entering a bank statement in Tally explains when Contra is right and when it is not.

The part that still takes the time: the ledger for each line

The import saves the typing of dates and amounts. It does not decide that a UPI payment to a fuel pump belongs in Vehicle Running Expenses, or that one NEFT credit is a customer receipt and the next is a loan. You still choose the ledger for every line, either one by one or through the Common Ledger field for lines that share one.

On a statement with a few dozen lines, that is quick. On a client’s current account with hundreds of UPI lines a month, the ledger column is where the afternoon goes. Plan for it, and use Common Ledger for batches such as bank charges.

Step 5: Check that the whole month came in

  1. Press Alt+G, open Imported Bank Data, and press F2 to set the period to the statement’s dates. Every line of the statement should be there.
  2. Open the Bank Reconciliation Summary and compare the balance as per the bank with the closing balance printed on the statement.
  3. Look at what is left unreconciled. Lines only in the bank are usually charges and direct debits still to post. Lines only in your books are usually cheques not yet presented.

Our guide on how to check a bank statement in Tally walks through reading these screens.

If the import goes wrong

If the wrong file went in, or a statement was imported for the wrong period, Tally’s Get Statement page gives the reset 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 to keep reconciliation you have already done. Set to No, the statement data is deleted and reconciled transactions go back to unreconciled.
  4. Leave Backup Company Data before Reset on Yes, choose a backup folder, and press Y.

Then import the correct file. For the option missing from the menu, the ledger not listed, or a file refused as not valid, see why the bank statement import is not showing in TallyPrime.

When your Excel is not the bank’s own file

Everything above assumes you hold the Excel your bank’s portal produced. In practice, an accountant often does not:

  • The client forwards the PDF the bank emailed, and nobody will share net banking to download it again.
  • The client “helped” and sent a cleaned-up sheet. One we read recently was an SBI export with the Ref No and Balance columns deleted and the client’s own notes typed into spare columns.
  • The account is with a bank Tally has no format for.
  • Someone converted the PDF to Excel, which Tally’s help says it will not import.

No ledger setting changes the answer for these files. This is the case SmartXtract is built for. You upload the statement as it is, whether a PDF, a scan, an Excel or a CSV. Logo rows, merged headings and subtotal lines are dealt with for you. Each transaction gets a suggested ledger, you review it, and you download a clean Excel. That sheet with the client’s deleted Balance column reads too, because its Debit and Credit columns are still separate.

The reviewed Excel goes into Tally through Tally Connector, our free Windows app that runs on the same PC as TallyPrime. You pick the company and the bank ledger, the Connector creates the receipt, payment and contra vouchers, and it remembers the ledger you set for a payee next time. Undo Import reverses the whole batch. There is no XML file to build. The Excel bank statement to Tally page shows the full flow.

If your bank gives you a supported Excel, use Tally’s own import. It is free and already installed. If it does not, try SmartXtract on one statement. You get 20 pages free, no card needed.

Frequently asked questions

Can I import a bank statement into TallyPrime from Excel?

Yes, if your bank is on Tally’s supported list and the Excel was downloaded from net banking and not edited. Use Gateway of Tally > Alt+O (Import) > Bank Statement, select the bank ledger, set File Type to Supported, pick the file and import. An Excel made from a PDF is not accepted.

Does importing a bank statement create vouchers in TallyPrime?

Not by itself. The import brings the bank’s lines into TallyPrime and matches them against vouchers you already have. To create entries for the rest, open the Bank Reconciliation report from Banking Activities, select the lines and press F7 (Create Vch/Multi-Vch), choose the ledgers and save.

Why are the vouchers created from my bank statement Optional?

TallyPrime creates vouchers from imported bank lines as Optional so you can review them before they affect your books. After saving, press R (Mark as Regular & Reconcile) to turn them into regular vouchers and reconcile them in one step.

Can I use Import Data from Excel for bank transactions?

No. Tally’s Import Data FAQ states that TallyPrime does not support importing bank transactions through the Import Data from Excel feature. Bank statements go through Alt+O (Import) > Bank Statement instead.

Which voucher types does TallyPrime use for imported bank lines?

The ones you set in the bank ledger’s Auto Reconciliation Configuration. Normally deposits become Receipt vouchers and withdrawals become Payment vouchers. If you switch on a separate type for interbank and cash transactions, those become Contra or Journal vouchers.

Can I edit the bank’s Excel file before importing it?

Avoid it. TallyPrime recognises each bank by the layout of its original file, so deleting header rows, renaming columns or removing lines can make a valid statement fail. If you need to leave lines out, import the whole file and deal with those lines in TallyPrime.

How do I undo an Excel bank statement import in TallyPrime?

Press F1 (Help) > Troubleshooting > Reset Bank Statement Data, select the bank ledger and the date range, and choose whether to keep the reconciliation status. Keep the backup option on. Then import the correct file.

Where to go next

If your bank’s Excel is supported, set up the ledger once, import each month through Alt+O > Bank Statement, and create the vouchers with F7. If the import screen gives you trouble, start with import not showing in TallyPrime. If the file you have is a PDF or a sheet Tally will not take, can you import a bank statement in Tally sets out every route, and SmartXtract’s free 20-page trial lets you test it on a real statement.