Monday 15 January 2018

Excel to Tally Series Part #1

Excel to Tally Part-I


Free! Download It @ End of this post

Hello Friends, I am  going to introduce a series of Articles For  Excel to Tally Convert. In this series i will try to solve all problems regarding to convert excel data to Tally.




This series of articles will be very helpful for ''Who are using another software and want to migrate to tally." They can easily convert their data into tally using Excel. In this series I will try to guide completely.

In this post i am providing you a excel file that is developed by me. By using this excel file you will learn to prepare data for tally convert. This file provides you drop down select master facility.

Steps:- Convert excel bank statement to tally
0. Export your master into excel file. If you are not maintaining data in tally & want to maintain data in tally create master in tally otherwise wait for my next video.


1. save your bank statement in CVS or excel format.

2. Copy your excel bank statement and master in my given excel file sheet1.

3. insert columns as per requirement for Day, Month, Ledger

4. for ledgers insert
      select cells where you want to enter ledger name
      Create List for Go Data menu > Validate Data > Select List > In Data Ref > Select Masters > Ok

5. Prepare Data and Save

For Download Drop down Excel File


Click Here


38 comments:

  1. DEAR SIR THEIR IS NO EXCEL FILE DOWNLOAD AS PER YOU SIR SHOW IN VIDEO PLEASE EMAIL NITIN.BHAVSAR.NITIN@GMAIL.COM

    ReplyDelete
  2. We could not find the Proper Excel sheet to download. We are able to download Blank SHeet

    ReplyDelete
    Replies
    1. Dear sir
      Kindly share your excel sheet in my mail id

      Delete
  3. see below video, "Click here" to download

    ReplyDelete
  4. Sir, can we expand space of ladger name in tally. When we select ledger input window in which some ledger name is biger then that space, so name get srink and we can not read it proprly. so is thaire any solution?
    my email galajayeshgala@gmail.com
    pls repy



    ReplyDelete
  5. DEAR SIR THEIR IS NO EXCEL FILE DOWNLOAD AS PER YOU SIR SHOW IN VIDEO PLEASE EMAIL nimavatmanish86@gmail.com

    ReplyDelete
  6. Dear Sir,
    Please email the first video excel sheet

    ReplyDelete
  7. sir please give yr contact no of office as i want to share my problem in tally i am a professional accountant holding more than 60 clients i want to import sales entries without inventory from marg sales report. as i have clients more thaa 2000 sales entries in a months

    ReplyDelete
  8. PLEASE MAIL EXCEL SHEET ON AMANMALLIK950@GMAIL.COM

    ReplyDelete
  9. sir please send xls file in mail. pkjmiro@gmail.com. i am interesting to work on this.

    ReplyDelete
  10. Sir, please send your Email.I have some questions to ask you as I am doing a project related to banking only.

    ReplyDelete
  11. Hi THERE IS NO EXCEL FILE IS THERE. STOP SHARING YOUR YOU TUBE --FAKE.
    IF YOU HAVE SEND ME caprincesahni@gmail.com

    ReplyDelete
  12. sir excel file send me my mail rmkv269@gmail.com

    ReplyDelete
  13. hello Sir, kindly share excel utility file with me on my email ID - surajbothra@gmail.com

    ReplyDelete
  14. PLESE SND ME EXCEL FILE MAHESHBABU3001@GMAIL.COM

    ReplyDelete
  15. Dr and credit amount mismatch helps this problem

    ReplyDelete
  16. please send me Excel File. panchalindia@gmail.com

    ReplyDelete
  17. Please Send excel file link at info@leensdetector.com
    Appreciate.....
    Thanks & Regards.

    ReplyDelete
  18. Please send the excel file on iamshivam25@gmail.com

    Thanks

    ReplyDelete
  19. DEAR SIR I CAN'T FOUND IN YOUR SIDE FOR DOWNLOAD THE EXCEL FILE AS PER YOU SHOW IN VIDEO PLEASE EMAIL pradeepd88@gmail.com

    Reply

    ReplyDelete
  20. Sir,

    I really appreciated your efforts & video, but i couldn't find the excel sheet. I'm also willing to pay. I would very grateful, if you could share me as on mail as bkhancma@gmail.com, bkhancma@trinityenergyltd.com.

    Kind regards
    Babar Ali Khan

    ReplyDelete
  21. Sir,
    I really appreciated your efforts & video, but i couldn't find the excel sheet.can usend me the same at suhasgavali@gmail.com

    ReplyDelete
  22. link not available. pls send me to jadhavas09@gmail.com

    ReplyDelete
  23. SIR IN JAN 2020 XLS FILE IS NOT WORKING FOR UPLOADING SALES BILL
    ANY NEW XLS FILE IS AVAILABLE FOR PREPARING XML FILE

    ReplyDelete
  24. no excel file please mail me at opbanka@gmail.com

    ReplyDelete
  25. Password "aasansolution" not working

    ReplyDelete
  26. Sir,
    Please share the password for Excel-Tally.xlsb

    ReplyDelete
  27. file is write protected,unable to paste data

    ReplyDelete
  28. Sir, i used last year , IT IS VERY VERY HELPFUL TO ME, BUT I LOSS YOUR UTILITY , NOW AGAIN REQUEST FOR GIVEN YOUR BEST UTILITY , HOW TO DOWNLAOD, PLEASE

    ReplyDelete
  29. blank excel send mail id sankarguru77@gmail.com

    ReplyDelete