Format Download |work| - Tally Bank Statement Import Excel

If your bank statement is not automatically recognized, or you are using Tally.ERP 9, you may need a specific Excel template to map columns correctly.

: Some templates require the Excel sheet to be named specifically as "Bank" to be recognized. tally bank statement import excel format download

: Specify the File Path and File Type (Excel/CSV). Select the file you downloaded from your bank. If your bank statement is not automatically recognized,

: You may need to manually add a Ledger Name column to your Excel file so Tally knows which account to debit or credit for each entry. Where to Download Excel Templates Select the file you downloaded from your bank

: A compatible Excel sheet typically requires: Date , Particulars/Narration , Debit Amount , Credit Amount , and Cheque/Ref Number .

From the , press Alt+O (Import) and select Bank Statement .

Alternatively, go to > Bank Reconciliation , select your bank, and click Import Bank Statement .