Register now or log in to join your professional community.
Follow these steps for import data Excel to Tally -
Also see videos for details - www.xltally.in/videos
Thanks.
Download XLTOOL - Excel to Tally Software
Follow these steps for import vouchers Excel to Tally -
- First enable ODBC port in Tally application.
- Open one Tally application & open only one company.
- In XLTOOL software fillup the data in appropriate voucher template.
- Open MY MENU by F1 Key. -
click START button. -
Data will be imported in Tally.
You can do it with Excel2Tally Utility. with this website https://www.learnwells.com
It is best to transfer your excel data into tally.
THIS EXCEL TO TALLY MANUFACTURING EDITION SOFTWARE HELP YOU TO EXPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY LIKE TALLY7.2, TALLY ERP9, TALLY ERP, OR GST READY TALLY THROUGH EXCEL SHEET. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME.NOW WITH UPDATED VERSION YOU CAN GENERATE -
DOWNLOAD LINK: EXCEL2TALLY5.5
udiMagic processes the excel data and imports it into Tally. To view the data imported in Tally ERP, use the option Gateway of Tally > Display > Daybook
For more information, visit https://www.rtslink.com
go to the report file for which you need to export and the just click Alt+ E then select the option to excel and location to save the file
Well
You can check with Equinox International. We have experienced faculties.
http://www.equinoxdistribution.com/
You can check here. Our executives will advice you which will be best for your enterprise
Thank you
1) Configure Date Format in Control Panel (Recommended) Excel to Tally uses DD/MMM/YYYY format for date for example 05/Apr/2013. To set this format in your computer follow these steps a) Windows XP i) Start Menu > Control Panel > Regional & Language Option > Regional Option > Customized > Date > Short Date Format > DD/MMM/YYYY > OK > OK b) Windows 7 i) Start Menu > Control Panel > Regional & Language Option > Short Date Format > DD/MM/YYYY > OK 2) Configure Tally ERP 9 (Mandatory) Open any Company a) Port Setting: Port 9000 i) Open: Gateway of Tally > F12: Configure > Advanced Configuration ii) Tally Acting as : Both iii) Enable ODBC Server: Yes iv) PORT: 9000 b) Master Export XML Setting i) Open Gateway of Tally > Display > List of Accounts ii) Press Alt + E iii) Press N iv) Language: Default v) Format: XML vi) Press Ctrl + A vii) Yes > Yes 3) How to Export Entry from Excel to Tally ERP 9 a) Copy Paste from Other Excel File i) Take your Tally Company Back Up (Recommended) ii) Open Tally ERP and Company in which you want to Export Entries from Excel to Tally iii) Make Sure that only one Tally is Open and Only One Company is Open iv) Now Open You Excel File which contains data you want to transfer to tally v) And then Open Excel To Tally ERP 2014-1.exe vi) A Excel File Will open vii) Do Not Enter any data in 1st two columns i.e. “STATUS” AND “REMARKS” viii) Explanation to Remaining Columns (1) VCH Type: Paste Here Voucher Type Column (2) VCH No.: Paste Vch No. If Manual in Tally (3) Ref. No.: Paste Ref. No. for Sales / Purchase (4) Date: Paste Date (DD/MMM/YYYY) (5) Narration (6) Cr. Account & Cr. Amount (7) Dr. Account & Dr. Amount (8) For More than one Dr / Cr in single transaction use other Dr / Cr Columns given and leave empty for those not required ix) Click Export to Tally x) After Clicking Export to Tally if you see any message and some cells turned to YELLOW it means these ledgers are not Created in Tally. To Create it Click on Create Ledger, Define Group Name and Click Export to Tally. b) Direct Entry in Excel to Tally i) Follow above steps but instead of Copy Paste Type Entries in Excel to Tally
Free downlaod Sofrware : https://excel-tally.com
Watch free demo Video : https://youtu.be/UOnn7EE8MKo