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
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
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 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
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
