Popular Posts

  • Basic Accounting
    Basic concept of accounting Accounting: It is an art of recording, classifying and summarizing in significant manner and in terms of mo...
  • Tally Shortcut Key's
    Function Key Combination Windows Functionality Availability F1 To select a company At all masters...
  • Basic Accounting For Tally
  • Accounting Policies
    DISCLOSURE OF ACCOUNTING POLICY                                                                   Accounting policies are the speci...
  • TDS (Tax Deducted at Source) - Tally.ERP 9
    Introduction TDS refers to Tax Deducted at Source . The concept of TDS was introduced in the Income Tax Act, 1961, with the objective ...
  • Export Formats Available In Tally.Erp9
    The Export functionality available in Tally.ERP 9 allows the user to export data or report in any one of the standard available formats. ...
  • F11: Audit Features
    The Auditor needs to set the following Tax Audit Rules and Payment Due dates for various clauses: Tax Audit Rules for Amounts ...
  • Tally Erp.9 Back up of data
    Back up of data can be carried out by executing the following steps: Go to Gateway of Tally > Press F3: Company Info or Press Alt+F...
  • Schedule-VI Balance Sheet
    Schedule-VI Balance Sheet provides the representation of company's financial position at any point in time in the Schedule VI format ...
  • Import Masters (how To import Data In Tally)
    Import Formats Tally.ERP 9 supports XML format to import data.  To Import Masters execute the following steps: Go to Gateway of Ta...

Tuesday 18 September 2012

Export Tally to Excel

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.
  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.
Posted by at

2 comments:

Subscribe to: Post Comments (Atom)