Add to Favourites

Import Bank Statements in TallyPrime

Importing bank statements to TallyPrime helps you:

• Auto-create vouchers: TallyPrime reads your bank statement and fills in the payment or receipt details for you – whether you want to create single, multiple, or a consolidated voucher.
• Auto-Reconcile bank transactions: It checks your bank statement against your transactions in books and helps you spot which ones match and which ones might need appropriate actions.

There are two ways to make bank statement entries a part of your Company data:

• Download the bank statement and import it to TallyPrime.
• Get Statement using Connected Banking.

Before you begin, you need to note that you can import a bank statement if:

• The statement is not already open.
• The statement is in the correct format.
• You have the Write permission to the folder.

1. Gateway of Tally > press Alt+O (Import) > Bank Statement.
2. In the Import Bank Statement screen, specify the required information.
   1. Select Bank Ledger.
   2. Specify File Path.
   3. Select File Type as Supported.
   4. Select the File to Import.
   5. Set Show Preview as Yes.
      
3. Press Ctrl+A to import the Bank Statement.
   
4. In the Bank Statement Preview screen, press I (Import) to complete the import.
   You can see the total number of entries imported and exact matches in the Summary of Imported Statement.
   
5. Press S (Bank Reconciliation Summary) to go to the Bank Reconciliation Summary report.

You can then reconcile the book and bank transactions.

At any point in time, you can view imported entries in the Imported Bank Data report.

In case you have imported the statement for a wrong period or reconciled the transactions, you can always reset bank statement data.

Questions & Answers

1. My bank is supported for bank statement import. However, I am unable to import the bank statement. How do I proceed?
   You need to ensure that the bank statement you are importing meets the prerequisites.
   
   
2. Where can I view the bank statement transactions imported to TallyPrime?
   To view Imported Bank Data:
   1. Press Alt+G (Go To) > type or select Imported Bank Data, and press Enter.
      Alternatively, Gateway of Tally > Banking > Imported Bank Data.
   2. Press F2 (Period) to change the period for which you want to view the imported data.
      You can drill down from any of the rows to view transactions for a specific day.
      
      
3. What should I do if I accidentally imported a wrong bank statement?
   In such a case, you can reset the bank statement data.