Import Bank Statement from Excel to Tally

Bank Statement data

All businesses need to connect with their banks. Today, even small businesses will have thousands of banking transactions per month and these are usually carried out on a daily basis Record and monitor multiple transaction types (like Inter-Bank Transfer, Cheque, DD, etc.)As data include transaction details with debit & Credit Amount by understanding this we have separate Receipt, Payment, Contra voucher records with their details & reconcile date respective ledgers.

Its Very tedious process but don’t worry, we have solution for you Excel-Tally software auto detect voucher type & auto reconcile your data in a single click lets learn more about software


How to import Bank Statement data using
Excel-Tally Software in just a click 

Step 1- Put Data In Template Using Smart Mapping

Excel-Tally software provides you smart data mapping functionality, that helps you to copy all your data from your file to a template without any mistakes. 

or simply copy-paste your data column-wise from your sheet to the software template file.

Step 2- Create Receipt , payment Contra vouchers using Button

 Click on  Create Receipt Payment Voucher button

Software will auto create Receipt & payment voucher by validating Debit & Credit Amounts

 Click on  Create on Contra Voucher Button

Software will auto create Contra voucher by validating Cash ,Bank , Suspense A/c Ledgers


Step 3- Now Select Bank Statement Template In Software & Click Import

Open Excel-Tally Software, it will shows you Dashboard here you can select company in which you want to import data.

Now All set just select template file in software using BANK STATEMENT Button & Click on Import Button,

check the software dashboard it will show you Count of Ledgers,Invoice Records created.

check in tally all your records are imported successfully

You can Import Bank Statement with Following details

Transaction details

You can import data with transaction date, Transaction id & Descriptions

Cheque Details

You can import data with cheque Number, Date, Bank Name & Branch

Ledgers details

You can import data with Party, bank , Cash, Suspense Ledgers 

Payment Vouchers

You can import data with Payment voucher as per Debit Amount

Receipt Vouchers

You can import data with Receipt Voucher as per Credit Amount

Contra Vouchers

Your can import data with Contra vouchers as per ledgers Cash or bank

Can Import Multi Currency data using Same voucher Template

You can import Multi Currency data in same Voucher template by Providing Amount , Foreign Currency Symbol, Rate Of Exchange