How to Export Tally Reports to Excel: Ultimate Configuration Guide
How to Export Tally Reports to Excel: Ultimate Configuration Guide
Exporting financial reports from TallyPrime to Microsoft Excel is essential for audits, reporting, and cash flow modeling. Discover the shortcuts, configurations, and formatting fixes.
Who is this for: Step-by-Step Tutorial
Exporting financial reports from TallyPrime to Microsoft Excel is a standard procedure for audit preparation, corporate reporting, tax filing, and cash flow modeling. Excel provides a flexible environment to analyze numbers, build pivot tables, and run financial comparisons that are difficult to execute within Tally's native interface.
While TallyPrime includes built-in exporters, downloading data with incorrect configurations can result in misaligned columns, text wrapped incorrectly, and numbers formatted as text. This technical guide explains the shortcuts, step-by-step export workflows, and advanced F12 configuration options required to generate clean PDF files from TallyPrime.
1. Export Keyboard Shortcuts in TallyPrime
To export any active report in TallyPrime, use these shortcuts:
- Ctrl+E: Opens the export dialog box for the current report directly, bypassing confirmation menus.
- Alt+E: Opens the main export menu, allowing you to select between the current report, transaction registers, or master lists.
2. Step-by-Step Guide: Exporting Key Reports
Follow these procedures to export the most common financial statements to Excel:
📋 Exporting a Ledger / Day Book
- Navigate to the report (e.g. Gateway of Tally > Display More Reports > Account Books > Ledger).
- Select the ledger name and press Alt+F2 to configure the target period.
- Press Ctrl+E to open the export menu. Click Configure.
- Set File Format to Excel (Spreadsheet). Set Show Opening Balance and Show Transactions to Yes.
- Press Escape, then click Send. TallyPrime will compile and open the Excel sheet.
📊 Exporting a Trial Balance
- Go to Gateway of Tally > Trial Balance.
- Press Alt+F5 to expand the view to show child groups and ledgers.
- Press Ctrl+E, then click Configure.
- Set the export format to Excel. Toggle Nett Transactions Only to No if you want to see both debit and credit transaction columns.
- Press Escape, then click Send.
3. Advanced F12 Configuration Options for Excel Exports
To customize the structure of your exported spreadsheets, adjust the settings in the F12 Configuration menu before sending the file. Below is an overview of the key configurations:
| F12 Configuration Key | Recommended Setting | Description / Impact |
|---|---|---|
| Format of Report | Detailed | Expands sub-ledgers and inventory lines, avoiding condensed rows. |
| Export as Text | No | Ensures numbers are exported as numeric values rather than strings. |
| Show Voucher Type | Yes | Includes voucher types (Sales, Receipt, Payment) in a dedicated column. |
| Show Bill-wise Details | Yes | Lists outstanding bills under the ledger name row. |
4. Troubleshooting Common Export Errors in Excel
When exporting large data files, you may encounter formatting issues. Here is how to fix them:
❌ Issue: Numbers exported as text strings (cannot calculate sum)
Cause: TallyPrime exported cells containing currency tags or spacing characters, causing Excel to interpret them as text.
Fix: In Tally's export configuration screen, click Configure and set Export as Text to No. Additionally, ensure the target file format is set to Excel (Spreadsheet) rather than CSV.
❌ Issue: Misaligned columns in multi-tax vouchers
Cause: Multi-ledger vouchers (such as invoices with CGST/SGST and round-offs) can export with staggered lines if the detailed formatting option is disabled.
Fix: Before exporting, click F12 (Configure) on the report screen and set the formatting to Detailed.
❌ Issue: Exported file does not open automatically
Cause: Excel may be blocked from opening by Windows user control settings, or the output file path is set to a protected folder.
Fix: In the export configuration, change the Folder Path to a local folder like C:\TallyExport\ instead of the system Program Files folder.
TrulyInvoice: Bypassing Manual Export Workflows
Exporting reports to Excel is a helpful way to share financial summaries with auditors and managers. However, if you are exporting data just to reformat it and import it into other business systems, manual exporting is an unnecessary step.
TrulyInvoice automates your accounting pipelines by syncing data directly. Instead of exporting and importing files:
- Direct API Sync: TrulyInvoice connects directly to TallyPrime over a secure Port 9000 connector, sending data straight to your ledger books.
- AI PDF Reader: Upload invoices in PDF format. The system parses details and records vouchers automatically, avoiding Excel intermediary files.
- Predictable Pricing: Sync unlimited transaction records for a flat subscription rate of **plans starting at ₹399/month**, eliminating the need for manual spreadsheet cleanup.
Chartered Accountant & Accounting Automation Specialist