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
You can import data with transaction date, Transaction id & Descriptions
You can import data with cheque Number, Date, Bank Name & Branch
You can import data with Party, bank , Cash, Suspense Ledgers
You can import data with Payment voucher as per Debit Amount
You can import data with Receipt Voucher as per Credit Amount
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