How to Export All Ledgers from Tally in Excel

How to Export Ledgers from Tally in Excel

Tally.ERP 9 app was used to create a company: ‘John & Co.’. You want to export its ledger data.

Steps:

• Open the Tally app.
• Select the company whose ledgers you want to export.
• Select Display in Gateway of Tally.
• Press Enter.

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

• Select Statistics.

•  In Types of Accounts, choose Ledgers.

• The list of ledgers will be displayed. Click Export.

In the dialog box:

• Select Default (All Languages) in Language and press Enter.

• Choose Excel (Spreadsheet) in Format and press Enter.

• Set the export location and press Enter.

• Enter the File name (here, ‘Export Ledgers from Tally’).
• Press Enter.

• Enter the sheet name (here,‘List of Ledgers’).
• Press Enter.

• You can skip the next steps and use the default settings.
• In Type of Masters, select Ledgers and press Enter.

• In the confirmation dialog box, select Yes.

An Excel file will open.

Read More: How to Make a Ledger in Excel

Things to Remember

• Double-click or press the Enter to select.
• Some features are not available in the Education mode.
• The exporting location or sheet name must be typed.
• Tally.ERP 9 exports the file in Microsoft Excel 97-2003 Worksheet (.xls) format. To get the XLSX format, open the XLS file and Save it in XLSX format.

Download Practice Workbook

Download the free Excel workbook here.

Related Articles

• How to Make Subsidiary Ledger in Excel
• How to Make a Bank Ledger in Excel
• How to Make General Ledger in Excel
• Create General Ledger in Excel from General Journal Data
• How to Maintain Ledger Book in Excel
• Create a Checkbook Ledger in Excel

<< Go Back to Ledger in Excel | Excel for Accounting | Learn Excel