Pathway Learners

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 OR There is one utility available for import data from excel to Tally.ERP9. Using this utility u can generate vat report in Tally. Features of utility: Book your voucher entries, ledger accounts, price lists etc from exceltotally.in minimal efforts. Just copy and paste your data to our standard templates and that’s all. Post entries in Daybook format or in Register format there are no limitations. This utility helps user to import data from Excel to tally in various format. You can say it is converter utility for excel which eliminates your repetitive work and posts financial data to Tally more effectively and easily. There is also an option to Export data from Tally to MS Excel. EazyAUTO4 Excel-to-Tally: * Excel to Tally Inventory Data Entries Posting (Sales with Inventory, Purchase with Inventory, Debit Not With Inventory, Credit Not With Inventory, Journal Mode Entry with Inventory) * Excel to Tally Ledger Creation * Excel to Tally inventory Item Master Creation * Excel to Tally Multilevel Price List Creation * Excel to Tally Multiple Modes Entries Posting * Excel to Tally Sub-Group Creation * Excel to Tally Day Book Entries Posting in vertical Format with Multiple Ledgers * Select Ledgers by activating "List of Accounts" in Excel to fast & error free entries * Post Voucher Entries in Tally via Excel in Specific Ledger which is Created under Sub-Group * Automatic Ledger Creation while Booking Entries Excel to Tally * Set up to 81 Fixed Ledgers Heads to import voucher entries excel to tally * No Need to import / Export * No Port Settings * No Need to Create / Generate XML files all steps are automatic

A Company "Global Enterprises" was using external software as on 31st March 2008. As on 1st April 2008, they have procured Tally.ERP 9. There is a requirement for all their ledgers and inventory masters to be transferred to Tally without entering them. The external software has an option to export its master data to Excel. Using the same, all ledger and inventory masters have been exported in Excel Sheets. The data files thus exported are displayed below. A Company Global Enterprises has been created in Tally.ERP 9 and only default masters exist as shown in the screen below: The data in Excel needs to be converted to Tally understandable XML format and sent to the port in which Tally.ERP 9 is running. To achieve this, an interface is built in VB to import all the masters from Excel and generate a Tally compatible XML which is subsequently posted in Tally.ERP 9. The interface application created for the same has been displayed below. On selecting Type "Stock Items" or "Ledgers" and clicking on Export to Tally button, it transfers all the relevant masters to Tally.ERP 9. On the Export to Tally Button, required XML as discussed earlier is constructed and posted to Tally.ERP 9 which is up at a predefined port. The XML is generated through the following VB Code Snippet:- On importing both Ledgers and Inventory Masters, statistics is as shown below: In the above figure, we can observe that 5 Ledgers and 6 Stock Items have been imported from Excel. If there are some errors while Importing, Tally.imp can be referred for Import Log.