Excel to tally import for bank statements

A/c entries 2528 views 3 replies

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/

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details