Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Is there any method to import excel data to tally automatically.
There are many way to import vouchers from Excel to Tally. You can create XML file can import it in Tally under import of data option. But for that you have to know knowledge of Tally XML tag. Also some online tool is available which it auto create XML from Excel data and directly import it in Tally.
In XLtool there is very simple steps to import Excel data in Tally application.
Follow these steps for import vouchers Excel to Tally -
• 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.
• Download Excel template from - www.xltally.in
Following are the Tally XML tag for Vouchers -
XmlCode = "<TALLYMESSAGE xmlns:UDF=""TallyUDF"">"_
"<VOUCHER VCHTYPE="" ACTION="Create">"
<VOUCHERTYPENAME></VOUCHERTYPENAME>
<VOUCHERNUMBER></VOUCHERNUMBER>
<REFERENCE></REFERENCE>
<REFERENCEDATE></REFERENCEDATE>
<DATE></DATE>
<PARTYLEDGERNAME></PARTYLEDGERNAME>
<ALLLEDGERENTRIES.LIST
<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<LEDGERFROMITEM>No</LEDGERFROMITEM>
<LEDGERNAME>Sachin</LEDGERNAME>
<AMOUNT> 500</AMOUNT>
</ALLLEDGERENTRIES.LIST>
</VOUCHER>
</TALLYMESSAGE>"
End Sub

Please Login To Add Reply






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™