Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to import data from excel file in Tally ERP 9?

user-image
Question added by Razzi Haider Zaidi , Accountant , Batala General Trading LLC
Date Posted: 2017/03/24

 

Follow these steps for import data Excel to Tally -

  • Download Excel template from - www.xltally.in
  • Enable ODBC port in Tally application.
  • Open one Tally application
  • Open only one company.
  • In XLTOOL software ​fillup the data in Voucher / Master template.
  • Open MY MENU by F1 Key.
  • click START button.
  • Data will be imported in Tally.
  • If any errors occurred see the details on REPORT template.
  • Read software in-built HELP template for more details.

Also see videos for details - www.xltally.in/videos

Thanks.

Shaik Alavudeen Amanullah
by Shaik Alavudeen Amanullah , Business Development Executive , Saadi Saad Al Harbi & Partners Company

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 -

  1. ITEM MASTER WITH HSN CODE AND GST RATES,
  2. LEDGER MASTER WITH GST DETAIL AND ADDRESS,
  3. VOUCHER WITH ALL GST RATES AND WITH OR WITHOUT STOCK ITEMS
  4. NOW ITS ERROR FREE, YOU CAN GENERATE ENTRIES WITH ONE CLICK
  5. ADVANCE SALES VOUCHER (INVOICE VIEW, EFFECT IN GST, ALL DESPATCH DETAILS, SEPARATE BUYER AND CONSIGNEE DETAILS.)
  6. ADVANCE PURCHASE VOUCHER (INVOICE VIEW, EFFECT IN GST, ALL DESPATCH DETAILS, SEPARATE BUYER AND CONSIGNEE DETAILS.)
  7. ADVANCE DEBIT NOTE AND CREDIT NOTE ENTRY AS PER GST NORMS
  8. COLUMN FOR BILL WISE DETAIL(IN ACCOUNTING INVOICE SHEET) - REFERENCE NAME, CREDIT PERIOD, AMOUNT , REF TYPE
  9. USE SEPARATE REFERENCE NUMBER AND REFERENCE DATE FOR SALE, PURCHASE, CREDIT NOTE AND DEBIT NOTE
  10. USE VOUCHER NUMBER AS YOU WANT
  11. WRITE YOUR OWN VOUCHER TYPE
  12. SELECT MULTIPLE GODOWN NAME - ENTER YOUR OWN GODOWN THAT YOU CREATED.
  13. EXPORT GODOWN MASTERS
  14. BANK VOUCHERS ENTRY WITH AUTO BANK RECONCILIATION AND WITH BILLWISE DETAILS.
  15. MAINTAIN BATCH WISE DETAIL TAKE BATCH WISE ENTRIES
  16. SEPARATE BUYER AND CONSIGNEE GSTIN
  17. RECEIPT NOTE AND DELIVERY NOTE VOUCHERS (IN ADVANCE ITEM PURCHASE AND ADVANCE ITEM SALES)
  18. NOW POST DISCOUNT IN STOCK ITEMS
  19. ENTER TAX CLASSIFICATION IN ACCOUNTING INVOICE
  20. ENTER TRACKING NUMBER (NOTE NUMBER) IN ADVANCE SALES AND PURCHASE VOUCHERS
  21. IMPORT STOCK JOURNAL AND MANUFACTURING JOURNAL ENTRIES WITH STOCK ITEMS WITH ALL DETAILS INCLUDING SCRAP, GODOWN, BATCHES ETC.
  22. IMPORT ORDERS VOUCHERS

DOWNLOAD LINK: EXCEL2TALLY5.5

Shweta Softwares
by Shweta Softwares , Shweta Softwares , Shweta Softwares

  1. Start Tally ERP and Open a Company.
  2. Start udiMagic software
  3. Select the option Excel to Tally
  4. Select the option Import data into Tally
  5. Click the Browse button and select any Standard Excel template provided with udiMagic converter
  6. Click the Start button

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

 

JOJU KANDOTHPOYL
by JOJU KANDOTHPOYL , ACCOUNTANT , RIDDISIDDHI BULLIONS DMCC

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

E I
by E I , manager it , Equinox International

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

Deleted user
by Deleted user

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 

  • Step-1 : Register on Free download page you will get download Link
  • Step-2 : Download setup file & run using Run as Administrator
  • Step-3 : Fill detail as & click on submit (demo version activated)
  • Step-4 : Open tally & our Software ,now select company in software
  • Step-5 : Select template which you want to import & click on Import.

Free downlaod Sofrware : https://excel-tally.com

Watch free demo Video : https://youtu.be/UOnn7EE8MKo

 

More Questions Like This