How to Import Bank Statement in TallyPrime from Excel, CSV or PDF

Importing a bank statement into TallyPrime can save significant time for accountants, bookkeepers, CA firms and businesses that handle regular payments, receipts, UPI transactions, NEFT transfers, RTGS entries, IMPS transactions, bank charges and cheque records.

Instead of manually checking and entering each line from a bank statement, TallyPrime can import supported bank statement files for bank reconciliation. However, the right method depends on the file format you have. Excel, CSV and MT940 bank statements may be imported through TallyPrime’s supported bank statement workflow, while PDF statements often need to be extracted, reviewed and converted into a structured format before they can be used efficiently.

This complete guide explains how to import bank statements in TallyPrime, how to prepare Excel and CSV files, what to do with PDF statements, how bank reconciliation import works and how Snexa StatementTotally Pro can help convert bank statement data into Excel and Tally XML output.

Explore Snexa StatementTotally Pro →

Quick answer: To import a supported bank statement in TallyPrime, open the correct company, go to Gateway of Tally → Alt+O (Import) → Bank Statement, select the relevant bank ledger, choose the file path and supported file type, select the statement file, enable preview and complete the import. For PDF bank statements, first extract and review the transactions or convert them into Excel or Tally XML before using the appropriate Tally workflow.

Can You Import a Bank Statement in TallyPrime?

Yes. TallyPrime provides a workflow to import supported bank statement files and use them for bank reconciliation. According to TallyHelp, users can import a bank statement and then either create vouchers or reconcile company-book transactions with imported bank data.

Supported formats can depend on the bank, the TallyPrime release and the selected bank ledger. Tally’s guidance commonly identifies Excel, CSV and MT940 as supported formats for bank statement import. Your bank must also be supported for bank-statement import in TallyPrime if you want to use its auto-reconciliation features.

Importing a statement for reconciliation is different from importing prepared voucher transactions through Tally XML. The first method brings bank data into the bank reconciliation workflow. The second method is used when bank transaction data has been converted into a structured XML file for transaction voucher import.

Bank Statement Import vs Tally XML Import

Workflow	Purpose	Typical File Formats	When to Use It
Bank Statement Import	Bring bank transactions into TallyPrime for bank reconciliation and related review.	Supported Excel, CSV and MT940 files.	Use when you have a bank-download file supported by TallyPrime and need reconciliation.
Tally XML Import	Import prepared accounting vouchers into Tally.	Tally-compatible XML file.	Use when bank data has been reviewed, mapped and converted into voucher-style XML.
Excel Review Workflow	Review, clean, classify and prepare transaction data before import.	Excel or CSV working file.	Use when statements need correction, mapping or manual verification before conversion.
PDF Extraction and Conversion	Extract transaction data from a PDF statement and prepare it for accounting use.	PDF input; Excel and Tally XML output.	Use when the bank provides a PDF statement rather than a supported direct-import file.

For many businesses, the most practical workflow is to download the statement, review the data in Excel, use a conversion tool where needed, then choose either TallyPrime bank-statement import or Tally XML voucher import based on the accounting objective.

Before You Import a Bank Statement

Before importing any file into TallyPrime, perform the following checks. A few minutes of preparation can prevent duplicated transactions, wrong-period entries and time-consuming cleanup work.

• Confirm that you opened the correct Tally company.
• Download the statement from the official bank portal or authorised source.
• Check that the statement covers the correct date range.
• Verify the bank account and corresponding bank ledger in TallyPrime.
• Check whether your bank and file format are supported by the TallyPrime import workflow.
• Ensure that the Excel, CSV or MT940 file is not already open in another application.
• Review the statement for missing lines, duplicate records, broken dates or unusual entries.
• Take a backup of your Tally data before importing any new external file.

TallyHelp advises users to configure the bank ledger with the appropriate bank name and account information. It also notes that users having CSV files with non-standard formats may need to re-save them as standard CSV (Comma delimited), while older Excel formats may need to be re-saved as an .xlsx workbook before import.

How to Import Bank Statement in TallyPrime

Step 1: Open the Correct Company

Open TallyPrime and select the company in which you want to import and reconcile the bank statement. Confirm the financial year and bank ledger before continuing.

Do not import bank data into a company merely because it has a similar name. Importing transactions into the wrong company can create unnecessary correction work.

Step 2: Go to Bank Statement Import

From the Gateway of Tally, use the following path:

Gateway of Tally → Alt+O (Import) → Bank Statement

Depending on your TallyPrime release and workflow, you may also begin from the Bank Reconciliation report for the relevant bank ledger.

Step 3: Select the Bank Ledger

In the Import Bank Statement screen, select the correct bank ledger. The selected ledger should match the bank account from which the statement was downloaded.

Before importing, confirm that the bank name, bank account number and related details are configured correctly in the bank ledger where required.

Step 4: Select the File Path

Choose the folder in which your bank statement file is saved. Keep a separate, organised folder structure for monthly bank statements, such as:

Bank Statements
├── FY 2026-27
│   ├── April 2026
│   ├── May 2026
│   ├── June 2026
│   └── July 2026

Clear file naming reduces the risk of importing the wrong statement. A good filename format is:

BankName_AccountLast4_Month-Year.xlsx
Example: HDFC_4521_April-2026.xlsx

Step 5: Select the File Type

Select the appropriate file type based on your downloaded statement. TallyPrime’s bank statement import workflow commonly supports bank-specific files in Excel, CSV or MT940 format where the selected bank is supported.

If you do not see the expected file, check whether it is in a supported format, whether the correct folder is selected and whether the statement was downloaded from the correct bank portal.

Step 6: Select the File to Import

Select the bank statement file from the list. Before proceeding, verify:

• The correct bank account is represented by the file.
• The date range is correct.
• The file is not a duplicate of a statement already imported.
• The filename matches the month and account you intend to process.

Step 7: Enable Preview

Set Show Preview to Yes. The preview stage is important because it allows you to review the bank data before importing it into TallyPrime.

Check whether transaction dates, narrations, debit values, credit values and statement rows are displaying correctly. If the preview appears broken or incomplete, stop the process and fix the source file before importing.

Step 8: Import the Bank Statement

Once the preview looks correct, press Ctrl+A to import the bank statement. In the Bank Statement Preview screen, press I to complete the import, following the current prompts in your TallyPrime version.

After import, review the results and move to the relevant bank reconciliation workflow if you need to match bank transactions with company-book entries.

How to Import Excel Bank Statement in TallyPrime

Excel is one of the most common formats used by Indian businesses and accountants. When your bank provides a supported Excel statement, you may be able to use the standard TallyPrime Bank Statement import workflow.

Excel File Preparation Checklist

• Use the latest bank-downloaded file where possible.
• Keep the original bank statement unchanged as a backup.
• Make a working copy if you need to review or modify formatting.
• Use the .xlsx format when possible.
• Remove passwords only through authorised access to the statement.
• Check for visible transaction date, narration, debit, credit and balance fields.
• Do not mix entries from multiple bank accounts into a single statement file.
• Do not combine multiple months unless your workflow specifically requires it.

Excel to TallyPrime Import Process

1. Download the bank statement in Excel format from the bank portal.
2. Open the file and verify the statement period and transaction count.
3. Save a backup copy of the original statement.
4. Open the correct company in TallyPrime.
5. Go to Alt+O (Import) → Bank Statement.
6. Select the relevant bank ledger.
7. Choose the Excel file and enable the preview.
8. Check the preview carefully.
9. Complete the import and review the imported statement data.
10. Use bank reconciliation to match company-book entries and bank transactions.

If your Excel file is in an older format such as .xls, .xlsb or .xlsm, TallyHelp recommends re-saving it as an Excel workbook in .xlsx format before attempting import.

How to Import CSV Bank Statement in TallyPrime

Many bank portals provide CSV bank statements. CSV files are lightweight and easy to download, but they can sometimes have compatibility issues because different CSV encodings and delimiters are available.

CSV File Preparation Checklist

• Open the file and confirm that columns are separated correctly.
• Check that debit and credit values are not mixed into a single unreadable field.
• Confirm the date format and statement period.
• Ensure that narration and reference details remain readable.
• Close the CSV file before importing it into TallyPrime.
• Save the working file in standard CSV (Comma delimited) format if required.

TallyHelp specifically notes that CSV files saved in formats such as CSV UTF-8, CSV Macintosh or CSV MS-DOS may need to be re-saved as standard CSV (Comma delimited) if import problems occur.

CSV to TallyPrime Import Process

1. Download the bank statement in CSV format.
2. Open it in Excel or another spreadsheet tool and check the transaction layout.
3. Re-save it as standard CSV (Comma delimited) if necessary.
4. Close the file before starting the TallyPrime import.
5. Open the relevant company in TallyPrime.
6. Go to Alt+O (Import) → Bank Statement.
7. Select the correct bank ledger and CSV file.
8. Enable the preview and check transactions carefully.
9. Complete the import and review bank reconciliation results.

How to Import a PDF Bank Statement in TallyPrime

A PDF bank statement is different from an Excel, CSV or MT940 statement. A PDF may contain visible transactions, but it is often not designed as a structured data-import file. Therefore, a PDF usually needs extraction, conversion and review before it can be used for Tally workflows.

Do not assume that every PDF can be directly imported into TallyPrime. A digital text-based PDF is generally easier to extract than a scanned image PDF. Both types require checking before they are used for accounting data.

PDF Bank Statement to Tally Workflow

1. Download the PDF statement from the official bank portal.
2. Confirm the correct bank account and date period.
3. Extract or convert transaction data into a structured Excel file.
4. Review transaction date, narration, debit, credit and balance values.
5. Correct broken rows, duplicate lines, incorrect dates and unreadable amount fields.
6. Choose the required output: Excel for review or Tally XML for voucher import preparation.
7. Take a backup of Tally data before importing a new XML file.
8. Import the prepared Tally XML through Tally’s transaction import workflow if appropriate.
9. Review vouchers, bank ledger entries and bank reconciliation after import.

If your bank statement is in PDF or requires structured Excel and Tally XML output, Snexa StatementTotally Pro can help you convert bank statement data for review and Tally import preparation.

How TallyPrime Bank Reconciliation Import Works

Bank reconciliation compares transactions recorded in a company’s books with transactions appearing in the bank statement. It helps identify entries that have been recorded in Tally but are not reflected in the bank, as well as bank transactions that are not yet recorded in the company books.

After importing a supported bank statement, TallyPrime can help users view imported bank data and reconcile it with existing book entries. Depending on configuration and compatibility, users may be able to auto-reconcile transactions or review unmatched items from a single bank-reconciliation screen.

Typical transactions that may need attention include:

• Bank charges not yet entered in company books.
• Interest credited by the bank.
• UPI payments or receipts without clear ledger allocation.
• Cheque deposits that have not been cleared.
• NEFT, RTGS or IMPS transactions pending accounting entry.
• Customer receipts or supplier payments entered with different narration.
• Duplicate transactions or entries from overlapping statement periods.

Bank reconciliation does not mean every imported transaction should automatically become a final accounting voucher. Unmatched transactions should be reviewed and classified according to their real business nature.

How Snexa StatementTotally Pro Helps

Snexa StatementTotally Pro is designed for users who need to convert and prepare bank statement data for Tally and Excel-based accounting workflows.

Snexa StatementTotally Pro can help users:

• Convert bank statement data into Tally XML output.
• Export bank statement data into Excel for review and editing.
• Prepare bank data for Tally import workflows.
• Reduce repetitive manual bank-entry work.
• Support bookkeeping and bank-reconciliation preparation.
• Organise recurring bank statement conversion work for clients or businesses.
• Review transaction data before it is imported into Tally.

View Snexa StatementTotally Pro and Product Details →

Common TallyPrime Bank Statement Import Problems

1. The File Does Not Appear in TallyPrime

Check whether you selected the correct folder, bank ledger and file type. Confirm that the file is in a supported format and that it is not currently open in Excel or another application.

2. CSV File Import Error

Try opening the file in Excel and re-saving it as CSV (Comma delimited). CSV UTF-8, CSV Macintosh and CSV MS-DOS formats may cause compatibility issues in some workflows.

3. Old Excel Format Is Not Accepted

If the statement is in an older Excel format such as .xls, .xlsb or .xlsm, re-save a working copy as an .xlsx file and try again.

4. The Statement File Is Already Open

Close the statement file in Excel or another spreadsheet program. If TallyPrime still reports that the file is open, rename the file by adding -imp at the end of the filename before the extension, then select the renamed file through the import screen.

5. Bank Statement Is Already Imported

Check whether the same statement period or file has already been imported. Re-importing the same bank statement can create duplicate data or duplicate reconciliation work.

6. Dates, Debit or Credit Values Look Incorrect

Stop the import if the preview shows incorrect transaction values. Review the source file for date-format issues, merged cells, negative-value treatment, broken rows or an incorrect bank-statement layout.

7. Bank Is Not Supported for Auto-Reconciliation

TallyPrime’s auto-reconciliation support depends on the selected bank and statement format. If your bank is not supported for direct bank-statement import, use an Excel-review or Tally XML conversion workflow and complete reconciliation carefully after import.

Bank Statement Import Checklist

Checklist Item	What to Verify
Correct company	You opened the intended Tally company and financial year.
Correct bank ledger	The selected Tally bank ledger matches the downloaded bank statement.
Official source file	The statement was downloaded from the official bank portal or obtained through an authorised source.
Date range	The statement covers the intended period and does not overlap with a previously imported file.
File format	The file is Excel, CSV or MT940 in a format supported by the selected TallyPrime workflow.
Preview check	Dates, narrations, debit, credit and transaction rows display correctly before import.
Data backup	A Tally backup was created before the import.
Duplicate check	The same statement or transaction period has not already been imported.
Post-import review	Imported statement data, unmatched entries, vouchers and reconciliation status are checked.

Frequently Asked Questions

How do I import a bank statement in TallyPrime?

Open the correct company in TallyPrime, go to Gateway of Tally → Alt+O (Import) → Bank Statement, select the relevant bank ledger, choose the file path and supported file type, select the bank statement, enable preview and complete the import after checking the data.

Which bank statement formats can be imported into TallyPrime?

TallyPrime commonly supports supported bank statements in Excel, CSV and MT940 formats. Availability can depend on the selected bank, bank ledger configuration and TallyPrime version. Check the import screen and current TallyHelp guidance for your bank and release.

Can I import an Excel bank statement into TallyPrime?

Yes, supported Excel bank statements can be imported through TallyPrime’s Bank Statement import workflow. Use the correct bank ledger, select the file, enable preview and review the statement before completing the import.

Can I import a CSV bank statement into TallyPrime?

Yes, supported CSV statements can be imported. If you face an error, re-save the file as standard CSV (Comma delimited), close the file before importing and verify that the correct bank ledger and file type are selected.

Can I import a PDF bank statement directly into TallyPrime?

A PDF is usually not a direct structured import file. It often needs extraction and review before it can be used efficiently for a Tally workflow. You can convert the PDF bank statement into Excel for review or into Tally XML for prepared voucher import, then verify entries in Tally.

What should I do if the bank statement is already open error appears?

Close the file in Excel or any other program. If the error continues, rename the file by adding -imp before the extension, such as changing bankstatement.csv to bankstatement-imp.csv, then select the renamed file in TallyPrime.

Do I need to take a backup before importing a bank statement?

Yes. Always create a Tally backup before importing new bank statement data, especially when testing a new bank format, importing large transaction volumes or using a newly generated XML file.

Can Snexa StatementTotally Pro replace an accountant or CA?

No. Snexa StatementTotally Pro can help prepare bank statement data for Excel and Tally XML workflows, but it does not replace professional accounting judgment. Ledger selection, voucher classification, final reconciliation, taxation and financial reporting should be reviewed by a qualified accountant or chartered accountant where needed.

Final Verdict

Importing a supported Excel, CSV or MT940 bank statement into TallyPrime can make bank reconciliation more efficient and reduce manual transaction checking. For PDF statements or bank formats that require preparation, a structured conversion workflow is often necessary before using Tally.

For accountants, CA firms, bookkeepers and business owners who need to convert bank statement data into Excel and Tally XML output, Snexa StatementTotally Pro is worth considering. It is designed to support bank-statement conversion, data review and Tally import preparation.

Disclaimer: This article is for general information only and is not accounting, tax, legal or financial advice. TallyPrime features, supported banks, import formats and workflows may vary by product release and configuration. Always preview imported data, verify transaction details, take a data backup before importing files and consult a qualified accountant or chartered accountant where necessary.