SMART - Excel To Tally Software 104
Simple tool for creating Tally input data
SMART - Excel To Tally Software is a reliable tool that comes as an Excel spreadsheet template and enables you to easily convert the existent data to the proper format, then save it as a XML file. The template includes a preset template in which you simply need to enter the required data, then convert the columns to row format.
The template file contains several worksheets, including mLEDGER, mITEM, Single, VAT, Multi and Stock. Each sheet is designed to help you import the data from a specific column to the required row. For instance, from the mLEDGER you can import the Masters ledgers accounts data, while from the VAT sheet, you may easily extract VAT vouchers entries.
The CTR sheet contains the table template for custom information, created so you can easily convert the column wise data to row wise format. Additionally, you may import fields from the Voucher entry, such as Ledger A/C name and amount, narration, voucher number, stock inventory numbers, Godown, batch number and bank cheque details.
Moreover, the Master Ledger field contains the name of ledger, address, inventory or tax definitions that you can easily import to your file. Also, from the master Stock Item fields, you can extract name of stock item, group alias, Godown, as well as standard cost rate, sell rate and time stamp.
Extract data in Tally.ERP format from Excel in a few clicks
SMART - Excel To Tally Software is especially designed for those who require XML format sheets, for editing in Tally.ERP. The tool offers you a convenient environment where you can enter the required data, then translate it into a supported XML file. You need to simply fill in the data to the proper sheet template, export and save it to XML format, then import it in your business managing software.
Reviewed by Elizabeta Virlan on August 4th, 2014
In a hurry? Add it to your Download Basket!
- New CTR sheet template
- In mITEM Master Sheet Template added new columns fileds ie. Godown Names, Batch No., Standard Cost Date, Standard Cost Rate, Standard Sell Date & Standard Sell Rate.
- In STOCK Sheet Template added new columns fields ie. Item Godown Name & Batch No.
Application descriptionSMART - Excel To Tally Software is a simple tool in the form of an Excel template that enables you to create XML files...