skip to Main Content
+91-9551052100 Download Pay Help

Steps to Import Bank Statements

Smart Features

How to Import Bank Statement from Excel to Tally

1. Prepare Excel

2. Load Excel and Analyse Data

3. Verify Masters and Configuration

  • Click Verify Masters button (at the bottom of the screen), to check the existence of connected masters of the voucher.
    (Example: ledgers, cost centre, stock items, godown, units, voucher type & etc. can be verified and missing masters can be created automatically.)
  • Click the Configuration button (top right on the grid), to select the default voucher type and additional details.

4. Upload to Tally

  • Now Upload all or Selected Vouchers to tally.
    (Use check box on the left side in the data grid)
  • Now click the “Upload to Tally” button to upload entries in to Tally directly.

5. Verify Import Status

  • Check the Import Process, Log and Report for details of records imported.
  • After upload is completed, users shall check the Tally and verity the same.
Back To Top
Select your currency
Indian rupee