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