Add to Favourites

Get Bank Statement Using Connected Banking in TallyPrime

With Connected Banking, you can seamlessly get bank statements. You can then use the bank statements to reconcile the transactions in books. 

1. Press Alt+Z (Exchange) > All Banking Options > Get Statement.
2. Set the period for which you want to get the statement.
   1. Select the bank ledger and press Alt+S (Set Statement Period).

      At a time, you can select only one bank account to get bank statement.

   2. Enter the From and To dates and press Enter.
3. Press S (Get Statement).
   
4. Import the statement.
   1. Select the request that is ready to import.
   2. Press S to import the statement.
      
      The statement becomes a part of your Company data.

You can view the transactions from the imported statements in the Imported Bank Data and Bank Reconciliation reports.

If you are not using Connected Banking services, then you can import bank statements to perform auto reconciliation.

Delete Statement Request

You might want to delete a statement request when it was requested for the wrong period.

1. Bring the cursor to the request. 
2. Press Alt+R (Delete Request).
3. Press Y to confirm.
   
   The request gets deleted.

Reset Bank Statement Data

You can reset the bank statement data when:

• You have imported the statement for a wrong period.
• You have already reconciled your transactions. Therefore, you do not want the imported bank statements in your Company data anymore.

1. Press F1 (Help) > Troubleshooting.
2. Select Reset Bank Statement Data and press Enter.
3. In the Reset Bank Statement Data screen, select the Bank Ledger. 
4. Retain Reconciliation Status: Yes.
   The reconciliation status of the fully reconciled transactions gets retained. However, if there are any partially reconciled transactions, then their status becomes Unreconciled.
   If the option is set to No, then the statement data will get deleted and transactions reconciled or even partially reconciled via linking will become Unreconciled.
5. Enter the From and To dates.
   The Bank Statement data will get cleared for the specified status.
6. Take a backup of the Company data, if needed.
   1. Backup Company Data before Reset: Yes.
   2. Backup Destination Path: Select or specify the folder path and press Enter.
      
7. Press Y to confirm.
   
   The bank statement data gets cleared.