Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO EXPORT ANY LEDGER/VOUCHER IN TALLY IN EXCEL FORMAT.
AND HOW CAN WE SEE THE SAME.
- 6 Answers
- 56692 Views
- PK Roadways, I also Faced
- E-Mail Answers
Answer Posted / tally karthikeyan
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.
You can see it in excel also.
| Is This Answer Correct ? | 17 Yes | 6 No |
Post New Answer View All Answers
what is debit/credit note ? what deffered income and expencess?
why do we charge the depreciation
Expand CASA
How can retify the errors in the trial balance
Why we have to present first and second draft(Bill of Exchange) for bank negotiation.Why cant we present only One draft?
2. You are required to prepare a Profit & Loss Account for the year ending 31st December, 2007 and the Balance Sheet on that date. The Trial Balance of XYZ Ltd. for the year ended 31st December 2007 is as follows:- Trial Balance of XYZ Ltd. as on 31st Dec. 2007 Debit Balances Rs. Credit Balances Rs. Materials used 3,50,000 Sales(including 2% Sales tax) 9,18,000 Cost of Labour 1,50,000 Sale of Scrap 100 Stock, finished and work in process on 31st December, 2006 50,000 Rent received 2,000 Wages : Factory Staff 15,000 Discounts 2,750 Directors Remuneration 50,000 Recovered against fire claim re : Stock 5,000 Salaries : Clerical Staff 75,000 Capital : Equity 25,000 Insurances : Workmen’s Compensation 1,500 Preference- 9% 8,000 General, fire etc. 2,000 Creditors 1,56,000 Directors’ Life Insurance 1,500 Provision for Taxation 1,05,000 Maintenance : Buildings 1,000 Profit & Loss Account 13,750 Plant and Machinery 12,500 Rent and Rates of premises and hire of plant 20,000 Heat, Light and Power 15,000 Experimental and Laboratory Expenses 10,000 Canteen Expenses 5,000 Staff Welfare expenses 2,500 Motor Expenses 12,500 Professional Charges 2,800 Postage and Telephone 3,500 Books, Printing and Stationery 11,000 Sundry expenses 10,000 Carriage and Packing on Sales 3,300 Discounts 5,000 Debtors 1,78,000 Freehold Property 50,000 Plant and Machinery 12,500 Fixtures and Fittings – Offices 3,500 Office machinery and Equipment 3,000 Motor Car and Van 6,500 Stock of materials on 31st Dec. 2007 1,20,000 Bank 38,000 Sales Tax Paid 15,000 12,35,600 12,35,600 Depreciation is to be provided at the following rates: Plant and Machinery 10% Fixture and Fittings 05% Office Machinery, etc. 10% Motor Vans and Cars 25% The stock of finished goods and work in progress as on 31st December, 2007 was Rs. 35,000. Provide for preference dividend and ordinary dividend at 10%. The total taxation liability is estimated at Rs.1,50,000 of which Rs. 75,000 relates to the current year. Debtors include Rs. 10,000 deposited as security against government contracts. The Works Manager is paid partly by salary and partly by a commission; he is entitled to a commission of 5% on the amount by which the surplus in the factory cost exceeds 20% of the sales for the period. Charge the commission if any in the Profit and Loss Account.
What is meant by Revenue Loss
is indian bank or canara bank CBS brach?
What do you mean by custodian/Depository, & what are the different types of Depository? (NSDL/CDSL)
You are given the following information in respect of a company: Fixed cost –Rs.13,000 Variable cost –Rs.14,000 Net profit –Rs.3,000 Net sales-Rs.30,000 Find out: a>BEP b>The profit for sales volume of Rs.50,000 c>The volume of sales to make a profit of Rs.10,000
how MIS statements used in accounts receivables n payables? n what is the advantage of this reports?
Dear Sir, My qus is my co. purchase a laptop from Abc.co. for rs-37200 on credit Emi basis from hdfc bank. i paid every month 6200rs as a installment. so i want to know how i make a entry in tally 9. and also want to know i creat laptop ledger under fixed assets or office expenses. plz tel me soon.or mail me .
please send me last 3 years question & solution
Plz send me the questions that could be asked in an interview for a Bank Clerical job to suja_aln@yahoo.co.in. Thank you.
What is the process of VAT & CST Registration?
