www.TallyERP9Help.Com
 
Select Your Language :

Export to Excel - in Tally.ERP 9

Using the Export feature you can export Tally.ERP 9 data to Excel. Data exported to Excel can be e-mailed as an attachment, used to generate graphs for better presentation and further analysis.

Go to Gateway of Tally > Balance Sheet

  1. In the Balance sheet screen click E : Export or press Alt+E.

  2. Select the required language from the list of Languages displayed.

  3. Select a format from the list of Formats displayed.

  4. By default, the exported file will be stored in C:\Program Files\Tally.ERP 9 for Windows 7 and C:\Tally.ERP 9 for Windows XP operating systems

  5. Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.

  6. Press Enter to accept the default Output Sheet Name.

  7. To update the existing file select Yes in Update Existing File.

  8. To format the contents of the file select Yes in Excel (Spreadsheet) formatting.

  9. Select Yes for the Field with Colour, to retain the background colour in the exported file.

 
[Img-37]

  1. Accept to export the Balance Sheet to an excel file.

The exported file is saved in the default Tally.ERP9 or the specified folder, you can use this file for further analysis. 

 
 
 
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
 
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications