Excel Data to Tally

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.


Vinod Kumar

Educator

Prof. Vinod Kumar is an Indian Educator, Motivational Speaker, Naturopathic Practitioner and Entrepreneur . He is the founder of Svtuition... read more »

0 comments:

Post a Comment