Arif
unread,Jan 13, 2011, 12:03:53 AM1/13/11Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Tally Academy
Excel to Tally
This is a Utility which directly exports entries from excel to tally.
Excel to tally
Features:
1. Multiple debit & credits in one transaction
2. Exports transaction more than 10,00,000 at a time
3. Imports ledgers from tally
4. Highlights ledger names in transactions in excel which are not
available in tally.
5. Allows creating ledgers not available in tally at run time
System requirements:
1. Windows xp
2. Tally 7.2 / tally 9 / tally erp
3. Excel 2007
4. RAM : 256 MB (512 MB or higher capacity recommended)
How to use:
1. Provide financial year (viz. 2008 – 09, 2009 – 10, 2010 – 11)
2. Tally open method
a. Auto (it will open tally automatically)
(Tally version, tally path, data path, company no., and
company name must be as per tally)
b. Manual (your company in tally must be open)
(It Won’t Check Company Name In Tally)
3. Provide tally version (viz. Tally 7.2, tally 9, tally9.erp)
4. Tally path (eg. C:\tally\tally72.exe )
5. Tally data (eg. C:\tally\data\ )
6. Company no.
7. Company (as given in tally)
8. Click data entry in excel to tally menu
9. Enter you transaction or copy transaction from other excel sheet as
per given columns
10. Click export to tally in excel to tally menu
11. If any ledger is not available in tally it will be highlighted.
a. To create those ledger click create ledger in excel to tally
menu
or
b. If you don’t want to create change name of that ledger in
tally and then click import ledger
list in excel to tally menu after importing ledger, follow
from step no. 10 above.
You may download the file from the link