Tally


This query is : Resolved 

13 October 2013 how to transfer prepared tally report into excel?

13 October 2013 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

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

Select the required language from the list of Languages displayed.

Select a format from the list of Formats displayed.

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

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.

Press Enter to accept the default Output Sheet Name.

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

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

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

this page will open,

https://www.tallysolutions.com/website/CHM/TallyERP9/Data_Management/images/Export_BalSheet_-_Excel.gif



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.

regards,

13 October 2013 Very well explained by Aryan ji.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
ARTICLESHIP 29 August 2026
Article Assistant

RRPM & ASSOCIATES LLP

Chennai

CA Inter

View Details
Company
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER

Anupam Parashar & Co.

Ghaziabad

CA Final

View Details
Company
Featured 21 September 2026
Consultant - Reporting

Finrep Advisors LLP

Mumbai

CA

View Details
Company
22 September 2026
Account Assistant

Chirag P Shah & Co. Chartered Accountant

Pune

B.Com

View Details
Company
ARTICLESHIP 01 September 2026
Article Assistant

SGNG & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
ARTICLESHIP 21 September 2026
CA Article Assistant

KK & Company Chartered Accountant

Pune

CA Inter

View Details