Quick Answer

To provide Tally Ledger Dump Data of All Ledgers with Narration, export All Ledger Accounts when the customer wants ledger-wise statements, or export the Day Book when they want all company transactions in one dataset. Set the required period, enable Show Narrations, select Excel or the required format, export the file, and verify the data before sending it.

Complete Article

What Is “Tally Ledger Dump Data of All Ledgers with Narration”?

A customer, auditor, CA, accountant, bank, consultant, ERP vendor, or data-processing agency may sometimes ask for:

“Tally Ledger Dump Data of All Ledgers with Narration.”

This normally means they need detailed accounting transactions from TallyPrime, including the ledger entries and the narration recorded against the vouchers.

A typical requirement may include:

Information	Example
Date	01-Apr-2026
Ledger Name	ABC Traders
Particulars / Counter Ledger	HDFC Bank
Voucher Type	Payment
Voucher Number	125
Debit	₹25,000
Credit	—
Narration	Payment against Invoice 458
Reference / Bill Details	Inv-458

However, the phrase “ledger dump” is not a single standard TallyPrime report name. Different customers may use the term for different types of exports.

Therefore, before sending the data, it is important to understand what type of dump is actually required.

What Does the Customer Usually Mean by “All Ledger Dump”?

There are four common possibilities:

Customer Requirement	Recommended TallyPrime Method
Every ledger statement separately, with transactions and narration	All Ledger Accounts
All company transactions together in chronological order	Day Book
Raw accounting data for another software/system	XML/JSON Data Exchange
Custom column-based database-style Excel data	ODBC/custom extraction

For most accounting, audit, and verification requirements, start with either All Ledger Accounts or Day Book.

Method 1: Export All Ledger Accounts with Narration

This is generally the closest match when somebody specifically asks for:

“All Ledgers with Narration.”

TallyPrime supports multi-account reports so that you can work with multiple ledger accounts without opening and exporting each ledger manually. Current TallyPrime documentation also provides configuration options such as Show Narrations for multi-account reports.

Step 1: Open the Company

Open TallyPrime and select the company whose ledger data you want to export.

Before exporting, confirm that you have selected the correct company and financial period.

Step 2: Open the Multi-Account Export

Use:

Alt+E (Export) → Others

From the list of multi-account reports, select the appropriate All Ledger Accounts report.

TallyPrime provides multi-account reports specifically for working with multiple account ledgers together rather than opening every ledger individually.

Step 3: Set the Required Period

Configure the report period according to the customer's requirement.

For example:

01-Apr-2025 to 31-Mar-2026

or

01-Apr-2026 to 31-Aug-2026

Never assume that the customer requires the complete company history. Confirm the financial year or date range before sending the data.

Step 4: Enable Narrations

Open Configure for the multi-account report.

Enable:

Show Narrations → Yes

Depending on the nature of the accounting data and the customer's requirement, you may also want to enable details such as:

• Bill-wise details
• Inventory details
• Voucher numbers
• Group information
• Other relevant transaction information

TallyPrime's multi-account report configuration supports narration and other report details.

Step 5: Include All Required Ledgers

Make sure you have not accidentally restricted the export to a particular group or ledger.

TallyPrime allows multi-account reports to include or exclude specific groups and ledgers. If the customer has requested all ledgers, check these filters carefully before exporting.

For example, you should not accidentally export only:

• Sundry Debtors
• Sundry Creditors
• Bank Accounts
• Cash
• Sales Accounts

when the customer actually requires the entire set of ledger accounts.

Step 6: Select Excel as the Export Format

If the customer has not specified a file format, Excel is normally the most convenient format for human review and further analysis.

Choose the Excel format supported by your TallyPrime release and specify:

• Folder path
• File name
• Export configuration

A useful filename would be:

ABC_Company_All_Ledgers_01-Apr-2025_to_31-Mar-2026.xlsx

Avoid vague filenames such as:

data.xlsx

or

ledger.xlsx

A descriptive filename reduces confusion when multiple companies or financial years are involved.

Method 2: Export Complete Day Book with Narration

If the customer wants a complete transaction dump of the company rather than separate ledger statements, the Day Book is often the better starting point.

TallyPrime's Day Book displays transactions recorded in the company and can be switched to a detailed view.

Step 1: Open Day Book

Go to:

Alt+G (Go To) → Day Book

or open Day Book from the Gateway of Tally.

Step 2: Set the Complete Period

Press:

Alt+F2 (Period)

Enter the required From and To dates.

Example:

From: 01-Apr-2025
To: 31-Mar-2026

This step is extremely important. If the wrong period is selected, the exported dump will be incomplete even though the export itself succeeds.

Step 3: Use Detailed View

Press:

Alt+F5 (Detailed)

The detailed Day Book provides additional transaction breakup compared with the default condensed view.

Review a few transactions before exporting.

Step 4: Do Not Apply Unwanted Filters

If the requirement is for the complete company transaction data, ensure that you have not applied a Range or other filter that limits the transactions.

Official TallyPrime guidance for exporting transactions states that Alt+F12 (Range) can be used to select specific masters; it should be skipped when all transactions are required.

Step 5: Export the Day Book

Use the Export → Current option from the Day Book.

Depending on the screen and TallyPrime release, the export controls may be accessible through the Export menu/current-report shortcut.

TallyPrime officially supports exporting Day Book information to formats such as Excel and PDF.

Step 6: Configure the Export

Open:

Configure

Make sure Narration is enabled.

Also include other information required by the customer.

For example:

• Voucher Number
• Voucher Type
• Narration
• Ledger details
• Bill-wise details
• Inventory details
• Bank details

The exact options displayed can depend on the report, voucher data, export format, and TallyPrime release.

Method 3: Export All Transactions as XML for a True Data Dump

If the customer is a software developer, ERP vendor, data-migration company, auditor using specialised software, or someone importing the information into another system, an Excel report may not be what they mean by “dump.”

They may require the actual structured transaction data.

In that situation, TallyPrime's Data Interchange/Data Exchange XML export is more appropriate.

Official TallyPrime documentation provides a specific procedure for exporting transactions from Day Book with narration.

Procedure

Open:

Alt+G → Day Book

Set the period:

Alt+F2 → From Date / To Date

If all transactions are required, do not restrict them using Range.

Then:

Export → Current → Configure

Set:

Narration → Yes

Set:

Type of Vouchers → All Vouchers

Set:

File Format → XML (Data Interchange)

Specify the destination folder and filename.

For example:

ABC_Company_All_Transactions_2025-26.xml

Then export the file.

TallyPrime's current documentation also supports exporting company data, masters, transactions, vouchers and reports in several formats, including Excel, XML and JSON, depending on the type of export being performed.

Important: Ledger Masters and Ledger Transactions Are Different

This distinction is extremely important.

Suppose your company contains 500 ledgers.

During the selected financial year:

• 430 ledgers have transactions.
• 70 ledgers have no transactions.

A Day Book transaction dump is intended to represent recorded transactions. Therefore, an unused ledger with no transaction during the selected period will not magically appear as a transaction.

If the customer requires the complete ledger master list as well as transactions, consider supplying two datasets:

File 1 – Ledger Masters

Contains the list of ledger accounts, such as:

• Ledger Name
• Parent Group
• Opening Balance
• Other master information as required

File 2 – Transactions

Contains:

• Date
• Voucher Type
• Voucher Number
• Ledger postings
• Amount
• Narration
• Other transaction details

TallyPrime allows ledger masters to be accessed through Chart of Accounts → Ledgers, and current documentation also supports exporting masters separately.

This approach is especially useful when the receiving party is importing or analysing the accounting database.

Voucher Narration vs Ledger Narration in TallyPrime

Another important point is that TallyPrime can contain more than one type of narration.

Common Voucher Narration

This is a narration associated with the overall voucher.

Example:

“Payment made against Invoice 458 through HDFC Bank.”

Ledger-wise Narration

TallyPrime can also be configured to provide narration for individual ledgers within a voucher.

For supported accounting voucher types, this is controlled through the voucher type configuration:

Provide narration for each ledger in voucher → Yes

TallyPrime documentation confirms that common voucher narration and ledger-wise narration can be configured separately.

Therefore, when a customer says “with narration,” it can be useful to determine whether they require:

• Voucher narration only
• Ledger-wise narration
• Both

What If Narration Is Missing from the Export?

If the exported file does not contain narration, first determine whether narration actually exists in the original vouchers.

Open some vouchers in TallyPrime and verify the narration.

If narration was never entered while creating the vouchers, enabling Show Narrations during export cannot create narration retrospectively.

For example, TallyPrime allows narration to be entered while recording accounting transactions, and it also supports ledger-specific narration when the relevant voucher type is configured accordingly.

Example of a Customer-Friendly Ledger Dump

A clean transaction dump may look conceptually like this:

Date	Voucher Type	Voucher No.	Ledger	Debit	Credit	Narration
02-Apr-2026	Payment	15	ABC Traders	25,000	—	Payment against Bill 101
02-Apr-2026	Payment	15	HDFC Bank	—	25,000	Payment against Bill 101
03-Apr-2026	Sales	21	XYZ Pvt Ltd	11,800	—	Sale against PO-245
03-Apr-2026	Sales	21	Sales Account	—	10,000	Sale against PO-245
03-Apr-2026	Sales	21	Output CGST	—	900	Sale against PO-245
03-Apr-2026	Sales	21	Output SGST	—	900	Sale against PO-245

This type of flat, one-ledger-posting-per-row format is particularly useful for:

• Data analysis
• Database import
• Audit software
• ERP migration
• Reconciliation
• Custom reporting
• Power BI or Excel analysis

However, do not assume that a normal TallyPrime report export will always produce exactly this flat table structure. Standard report exports generally retain the structure of the TallyPrime report being exported.

If a receiving system requires a strict column structure, XML, JSON, ODBC, or a custom extraction process may be more suitable.

Advanced Option: Extract TallyPrime Data Using ODBC

For advanced requirements, TallyPrime supports ODBC-based extraction to applications such as Microsoft Excel.

ODBC is useful when a customer wants selected fields or structured data rather than a visually formatted accounting report.

TallyPrime's official documentation describes enabling ODBC through:

Alt+Z (Exchange) → Configure → Client/Server Configuration → Enable ODBC

The data can then be queried from Microsoft Excel using the appropriate data-query functionality.

ODBC should generally be considered an advanced option rather than the first choice for an ordinary ledger statement request.

Which Method Should You Use?

Use this decision table:

Customer Says	Recommended Method
“Send all ledger accounts”	All Ledger Accounts
“Send all ledgers with narration”	All Ledger Accounts + Show Narrations
“Send complete transaction dump”	Day Book
“Send complete Day Book with narration”	Day Book + Narration
“Send data in Excel”	Export required report to Excel
“Send Tally XML data”	XML Data Interchange
“We need data for importing into software”	XML/JSON or specified integration format
“Give every transaction in fixed columns”	ODBC/custom structured extraction may be required
“Send all ledger masters also”	Export Ledger Masters separately
“Send complete Tally data”	Clarify whether Masters + Transactions are required

Recommended Procedure When a Customer Simply Says “Send Tally Ledger Dump”

Do not immediately send random reports.

Ask the customer to confirm these four points:

1. Period: Which financial year/date range?
2. Format: Excel, XML, JSON, PDF, CSV or another format?
3. Data: Ledger-wise statements or complete transaction dump?
4. Narration: Voucher narration, ledger narration, or both?

A simple clarification can prevent you from exporting a large amount of data twice.

Before Sending the Ledger Dump: Verification Checklist

Before sending accounting data to the customer, verify the following:

• Correct company is selected.
• Correct financial year/date range is selected.
• All required ledgers are included.
• No unintended group or ledger filters are active.
• Narrations are visible where they exist.
• Voucher numbers are included if required.
• Debit and credit values are complete.
• Opening balances are included if the requirement needs them.
• The exported file opens correctly.
• The file is not blank or corrupted.
• A few exported transactions match TallyPrime.
• Sensitive financial information is being sent only to an authorised recipient.

Security Warning Before Sending Complete Tally Ledger Data

A complete ledger dump can contain highly sensitive business information, including:

• Customer names
• Supplier names
• Bank transactions
• Sales figures
• Purchase figures
• Expenses
• Outstanding balances
• Payment information
• Tax-related transactions
• Voucher descriptions
• Narrations containing internal business information

Therefore, never send a complete company ledger dump merely because someone informally asks for it.

Verify:

Who requested it → Why they require it → What period they require → What information they actually need → Whether they are authorised to receive it.

Where appropriate, use an approved secure file-sharing method instead of sending sensitive accounting data through an insecure public channel.

Common Mistakes While Exporting All Ledgers with Narration

Mistake 1: Exporting Group Summary

A Group Summary is useful for analysing groups and balances, but it should not automatically be treated as a complete ledger transaction dump.

If detailed transactions and narration are required, use the appropriate ledger or Day Book report.

Mistake 2: Exporting Only One Ledger

Opening one Ledger Vouchers report and exporting it provides that particular ledger's information.

It does not satisfy a request for all company ledgers.

Mistake 3: Forgetting the Period

The report may be correct but contain only the currently selected date or period.

Always verify the From and To dates.

Mistake 4: Narration Is Disabled

The vouchers may contain narration, but the exported report may omit it if the relevant report/export configuration does not include narration.

Mistake 5: Assuming Day Book Includes Unused Ledger Masters

Day Book represents transactions.

If a ledger exists but has no transaction in the selected period, it should not be expected to appear as a transaction.

Export ledger masters separately if the customer requires the complete master list.

Mistake 6: Sending PDF When Data Analysis Is Required

PDF is useful for viewing or printing, but it is usually inconvenient when the customer needs to sort, filter, analyse, reconcile, or import the data.

Use Excel or a structured data format when appropriate.

Mistake 7: Sending XML When the Customer Expected Excel

XML is excellent for structured data exchange but inconvenient for an accountant who simply wants to inspect the ledger information in Excel.

Always confirm the required format.

FAQ

1. Can I export all ledgers from TallyPrime at once?

Yes. TallyPrime provides multi-account reporting/export capabilities for working with multiple accounts, so you do not necessarily need to open every ledger individually.

2. How do I export all ledgers with narration?

Use the All Ledger Accounts multi-account report, configure the required period and enable Show Narrations, then export the report in the required format.

3. What should I use if the customer wants one complete transaction dump?

Use Day Book, set the complete required period, use the detailed view where appropriate, enable narration in the export configuration, and export the data.

4. Can TallyPrime export Day Book to Excel?

Yes. Current TallyPrime documentation confirms that reports/transactions such as Day Book can be exported to Excel and other supported formats.

5. Can I export narration from TallyPrime?

Yes. Narration can be included in relevant report/transaction exports when it exists in the vouchers and the appropriate narration option is enabled.

6. Why is narration blank in some transactions?

The most common reason is that no narration was entered in the original voucher. Enabling Show Narrations displays existing narration; it does not generate missing narration.

7. What is the difference between voucher narration and ledger narration?

Voucher narration describes the overall voucher, whereas ledger-wise narration can provide information relating to an individual ledger entry. TallyPrime supports ledger-specific narration for supported voucher types when Provide narration for each ledger in voucher is enabled.

8. Does Day Book contain all ledgers?

Day Book contains recorded transactions for the selected period. A ledger with no transaction during that period should not be expected to appear as a transaction. If the complete ledger master list is required, export the ledger masters separately.

9. Should I send Excel or XML?

Use Excel when the customer wants to review, filter, analyse, or reconcile the information manually.

Use XML/JSON or another structured format when the data is intended for software integration, migration, or machine processing, subject to the receiving system's requirements.

10. Can TallyPrime export all vouchers?

Yes. TallyPrime's transaction export configuration provides options for exporting voucher entries, including All Vouchers.

11. Can I send all ledger masters and transactions together?

For a formal data migration or complete data handover, it is safer to distinguish Masters from Transactions. TallyPrime's official data exchange guidance treats masters and transactions separately and recommends exporting masters before transactions when transferring complete data to another company.

12. Is Group Summary the same as a ledger dump?

No. Group Summary is primarily a reporting view. A customer requesting detailed ledger transactions with narration generally requires ledger-wise accounts, Day Book data, or a structured transaction export.

13. Can I export ledger data directly to Excel through ODBC?

Yes. TallyPrime supports ODBC connectivity and documents extraction of master data such as ledgers into Microsoft Excel.

14. Can I export only Sundry Debtors or Sundry Creditors?

Yes. Multi-account report configuration provides options to include or exclude particular groups and ledgers.

15. What is the safest option when the customer only says “ledger dump”?

Ask them to confirm the period, file format, whether they want ledger-wise or transaction-wise data, and whether voucher/ledger narration is required. This prevents sending incomplete or unnecessarily sensitive accounting information.

Final Recommendation / Conclusion

When a customer asks for “Tally Ledger Dump Data of All Ledgers with Narration,” first determine what they mean by ledger dump.

For a normal request for all ledger statements, use:

Export → Others → All Ledger Accounts → Configure → Show Narrations → Yes → Select Period → Export

For a complete chronological transaction dump, use:

Day Book → Set Period → Detailed View → Export Current → Configure → Narration → Yes → Export

For software integration or data migration, use a structured format such as XML/JSON, depending on the receiving system's requirements.

And if the customer requires every ledger master, including ledgers without transactions, export the ledger masters separately in addition to the transaction data.

Most importantly, verify the exported file before sending it. Check the company, period, ledger coverage, voucher numbers, amounts and narrations against several transactions in TallyPrime.

 

Official References

TallyHelp – Export Data in TallyPrime

TallyHelp – Import/Export Data FAQ

TallyHelp – Day Book in TallyPrime

TallyHelp – Configure Print, Export and Share

TallyHelp – Extract Data to Excel Using ODBC

 

#TallyPrime #Tally #LedgerDump #TallyLedgerDump #LedgerExport #TallyExport #Narration #VoucherNarration #LedgerNarration #AllLedgers #DayBook #TallyDayBook #ExcelExport #XMLExport #JSONExport #AccountingData #Accounting #Bookkeeping #LedgerAccounts #VoucherExport #TallyVouchers #TallyReports #TallyTips #TallyHelp #TallyTutorial #TallyGuide #TallyAccounting #TallyData #DataExport #CompanyData #FinancialData #AuditData #Accountant #CharteredAccountant #CAData #LedgerStatement #TransactionExport #AllVouchers #ChartOfAccounts #LedgerMasters #MultiAccountReport #AllLedgerAccounts #TallyODBC #Excel #AccountingSoftware #BusinessAccounting #TallyPrimeTips #TallyPrimeGuide #TallyPrimeExport #BisonKnowledgebase