In any professional software, exporting of data is a very important aspect and Tally has taken utmost care with regards to exporting of data.
Primarily Tally is used by most of the people for accounting purposes. Therefore exporting of different accounts and reports is even more necessary.
If you want to file a simple income tax return, you would want the figures from profit and loss account and balance sheet and for that you need to export the information from Tally.
Specifically in Tally, exporting different reports and accounts is required every day.
Imagine you are running a company.
- Your auditor would want different accounts for the audit of your company.
- To know what the costs of manufacturing are, you will need inventory vouchers.
- For taking important decisions, you will require ratio analysis.
- Banking will be required to take care of daily transactions.
- Payroll reports will be required for tracking employee costs.
And many more information is required for on daily basis by different persons in a company to run a single business.
All these information can be obtained in Tally in the form different reports.
In Tally, you can export every single account, report or any information you want by just one command.
That command is ALT+E.
This is true.
In whichever report you are, just press ALT+E and you will be able to export it.
6 Different Exporting Formats in Tally
In Tally, information can be exported in total six different formats.
- ASCII (Comma Delimited)
- Excel (Spreadsheet)
- HTML (Web-publishing)
- JPEG (Image)
- PDF (Portable Document Format)
- XML (Data Interchange)
Of the six formats, most used ones according to my knowledge and experience are Excel and PDF formats.
In the image below, I am exporting Balance Sheet from Tally.
If you have Tally try exporting in different formats and you will see the differences. Though there are not many of them.
People use Excel format for exporting because they can later edit the numbers in file. On the other hand, PDF format is used when you don’t want anyone to edit your file.
Where to find that Export Option in Tally
I said earlier in this post that you can export information from any report or any account in Tally.
The option of exporting is on the top of every screen in Tally.
In the image below, you are seeing Export option in Balance Sheet.
In this picture down, you are seeing Export Option in Trial Balance.
As you can see, the export option remains at the same place. What changes is the screen under it.
If you have noticed, you can also email anything directly from Tally to anybody if you want. That is just another cool feature Tally has.
Other Options while Exporting data in Tally
These options which you are seeing in the picture above, change according to what you are exporting from Tally.
But they are useful and that is the reason, they are there.
Certain options like Scale Factor for values which means showing numbers in millions or crores or to show percentages or not are quite useful.
At the end…
If you want to export anything in Tally, it is simple and easy. I have clearly shown you how you can do it.
Simplicity is what makes Tally beautiful.
If you have any questions, comment down below and I will be happy to answer them.