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


11 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