How to Export All Ledgers from Tally in Excel

While using the Tally app, we frequently need to export many necessary data. Like we may need to export all the ledgers from tally and if you don’t know how to do that then you have come to the right place. Hope this article will provide you with the easiest guideline to export all the ledgers from Tally in Excel with every required image.


Download Practice Workbook

You can download the free Excel workbook from here to see our exported output.


What Is Ledger in Tally?

A ledger is used to keep the information of every transaction like purchases, payments, sales, receipts, and other accounts. It is used in all accounting calculations. You can’t record any transaction without a ledger. In the Tally app, we have the Ledger option to keep transaction records. The Tally app has some easy ways to export data.


How to Export Ledgers from Tally in Excel

Now I’ll show the easy steps to export all the ledgers from the Tally.ERP 9 app. I’m using this just for demonstration purposes. Here, I created a company in the Tally app named ‘John & Co.’. We’ll export its ledger data.

Steps:

  • First, open your Tally app.
  • Select the company which ledgers you want to export.
  • Then, select Display from the Gateway of Tally section.
  • Hit the Enter button.

  • Next, from the Display Menu, select Statements of Accounts and press Enter.

How to Export All Ledgers from Tally in Excel

  • At this moment, select Statistics from the appeared menu.

How to Export All Ledgers from Tally in Excel

  • After that, we’ll get the Ledgers option in the Types of Accounts section.

How to Export All Ledgers from Tally in Excel

  • Soon after, we’ll get all the list of ledgers. Just click on the Export option now.

How to Export All Ledgers from Tally in Excel

Later, we’ll get a dialog box to set every required setting to export ledgers.

  • First, select Default (All Languages) from the Language box and hit the Enter button.

How to Export All Ledgers from Tally in Excel

  • Then choose Excel (Spreadsheet) from the Format box and hit the Enter button.

Have a look that, there are more formats like HTML, JPEG, PDF to export. If you want then you can export in those formats too.

How to Export All Ledgers from Tally in Excel

  • Next, set the export location and press the Enter button.

How to Export All Ledgers from Tally in Excel

  • After that, write the File name. I typed- ‘Export Ledgers from Tally’.
  • Then hit the Enter button.

  • Later, type the sheet name. I gave the sheet name- ‘List of Ledgers’.
  • Then press the Enter button to move to the next step.

  • You can skip the next steps because the default settings are ok to export.
  • Finally from the Type of Masters section, select Ledgers and hit the Enter button.

How to Export All Ledgers from Tally in Excel

  • It will open a little confirmation dialog box, select Yes to continue. Or if you want to change anything then press No and edit.

Soon after, an Excel file will open up like the image below.

Read More: How to Make a Ledger in Excel (with Easy Steps)


Things to Remember

  • While using Tally, double-click your mouse or press the Enter button to select anything.
  • If you use the Education mode in Tally then you will get some features unavailable.
  • Copy and pasting of exporting location or sheet name won’t work, you will have to type them.
  • Tally.ERP 9 will export the file in Microsoft Excel 97-2003 Worksheet (.xls) format. If you want to get the XLSX format then open the XLS file and Save it in XLSX format.

Conclusion

I hope the procedures described above will be good enough to export all ledgers from tally in Excel. Feel free to ask any questions in the comment section and give me feedback. Visit ExcelDemy to explore more.


Related Articles

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo