Go to particular ledger/voucher, then press “Alt” + “E”,
then press “Backspace”, after that we need to select the
language, then Format (Excel – Spreadsheet), then Output
File Name, then just press “Enter” till it exports.
It will be automatically exported to “Excel”.
Dear , it is very easy to export ledger accounts and
voucher entries from tally to Excel , in menu of ledger or
voucher ( in day book ) you have to select export and then
save it with name of excel file and then see your c drive
or the drive where is your tally software and you can get
your ledger and voucher in excel format
From Gateway of Tally, GoT -> D -> A -> L -> Select ledger
account -> Press Alt+E -> Enter default in language , Select
Format Excel(Spreadsheet) -> Output file name < ledger name
. xls > Press Ctrl+A -> press Yes or ctrl + A again
Now your ledger account within a few seconds exported and
return back to normal screen. If you like to see the export
file ( ledger name .xls ) Goto Desktop -> Right click Tally
icon -> Click " Properties " -> Click " Find Target " -> you
will find excel file in that folder.
When you want to transfer any details to micro soft excel
from tally,you have to select that items and you have to
press Alt+e.Your file will directly transfer to micro soft
excel and automatically will started.
Calculate the profit/loss on sale of the following assets
as on 30th september 2000
cost of the asset on 01.05.95 50000/-
Salvage Value 5000/-
Method of depriciation & date WDV 15%
sales of asset on 30.09.2000 Rs 25000/-