How can I transfer excel sheet data to tally in an easy way. I want to transfer stock item from excel to tally. No need to use other softwares for this purpose. Please giver the answer for this mater. I am waiting for your reply. Thanks in advance.
Reghukumar Konni from India
1. First of all you have to configure date format in control panel. It must be DD/MM/YYYY
just go to start menu, then go to control panel, then go to regional and language option and then go to regional option customized, then go to date, then short date format and then DD/MM/YYYY ok.
2. Now, configure Tally.ERP 9
Open the company
open gateway of tally, then go to F12 configure and then go to advance configure
Tally Acting as : Both
Enable ODBC Server : Yes
Master export setting
Open gateway of Tally, then go to display, then go to list of accounts
Excel file should be the format of tally voucher entry
means
Cr. Account and Cr. Amount
Dr. Account and Dr. Amount
Date : DD/MM/YYYY
Narration
VCH No. : Write Voucher no.
Ref. No. Ref. no. of sales or purchase
Now, import in Tally. Just check the utility of excel to tally in tallysolution company website.
If you do not know the import, you can learn at here.