Excel to tally import for bank statements

Dear Sir,

Please find the attached link to update data from excel to tally

Excel Templetes is like bank statements so just copy and paste for  bank entries

Please provide feedback and suggestion for improvment

https://1drv.ms/u/s!AvybD673nMaKgSSMm0HtcrNSdMxR

Replies (3)

In XLtool there is very simple steps to import Excel data in Tally application.

Download the latest software at - www.xltally.in

Follow these steps for import vouchers Excel to Tally -

  • First enable ODBC port in Tally application.
  • Open one Tally application & open only one company.
  • In XLTOOL software ​fillup the data in appropriate voucher template.
  • Open MY MENU by F1 Key.
  • click START button.
  • Data will be imported in Tally.
  • If any errors occurred see the details on REPORT template.
  • Read software in-built HELP template for more details.
  • If any Error then you can get alert in software REPORT template.
  • Rectify the errors and process same steps.

Import data from excel to Tally using udi-Magic Software.

  1. Start Tally ERP and Open a Company.
  2. Start udi-Magic software
  3. Select the option Excel to Tally > Import data into Tally
  4. Click the Browse button and select Standard Excel template provided with udi-Magic converter
  5. Click the Start button

Download link : https://www.rtslink.com/downloads

For more information refer : https://www.udimagic.com

1.start tally select compnay

2. stat Extally click on  bank statement import button.

3. select excle file and click import.

4. set ledger names in bank statement to tally.

5. click post entries.

Using our software Product you can do it easily !!!!!!!!!!!!!!!!
contact use

https://www.extally.com/

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 September 2026
Internal Audit - Team Lead

Consulting & Beyond

Chennai

CA

View Details
Company
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared

Getmyca Consultant Pvt Ltd

New Delhi

CA Inter

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER

Anupam Parashar & Co.

Ghaziabad

CA Final

View Details
Company
Featured 11 September 2026
Audit Executive

RBSM Corporate Advisors Private Limited

Pune

CA

View Details
Company
28 August 2026
Audit Manager

K A R M & CO

Mumbai

CMA

View Details
Company
24 August 2026
Semi-Qualified CA/CA Finalist - Tax, GST, Audit & Accounts

Bharat Shah & Associates

Mumbai

CA Inter

View Details
Company
19 August 2026
PAID ARTCILE ASSISTANT

My Legal Tax Consultants Pvt. Ltd.

Noida

CA Inter

View Details