Glossary · Accounting & Bookkeeping
Tally XML Export
Definition
Tally XML export is the option in Tally that saves a report, masters or vouchers as an XML file in Tally's Data Interchange format. The file keeps the structure of the data, such as ledgers, groups, voucher types, dates and amounts. Another Tally company or another software can then import it instead of re-keying every entry.
At a glance
- Category
- Accounting & Bookkeeping
- In this entry
- Where Indian businesses use it How it works · Example
In detail
01 Where Indian businesses use it
A business meets XML export mainly when it changes or connects systems. A distributor moving from Tally to Zoho Books or Odoo exports its masters and transactions as XML. The migration process then maps each Tally ledger to an account in the new system and loads the data. The same file is used to move data between two Tally companies or into a custom reporting tool.
XML is for machines. Excel and PDF exports are for people to read: they give a flat report without the links between masters and vouchers, so they are fine for review but weak for import.
How it works
02 How it works
- Open the source
Go to the report or list that holds the data, for example the Day Book or a list of masters.
- Choose Export
Use the Export option on the report (Alt+E).
- Set the format
Select XML (Data Interchange) as the file format.
- Set period and scope
Confirm the date range and filters so all needed records are included.
- Save and check
Choose the folder and file name, generate the file, and check that it opens and holds the expected records.
- Import and reconcile
Load the file into the target and match its totals with Tally's trial balance.
Masters (ledgers, stock items) should go across before the vouchers that use them.
Worked example
03 Example
An example, not advice on your facts.
A distributor moves to new software from 1 April 2026 and carries over FY 2025-26 history.
| Step | Amount (₹) | Result |
|---|---|---|
| Ledger masters exported as XML | - | Party and account structure kept |
| FY 2025-26 vouchers exported as XML | 2,10,00,000 | Full year's transactions |
| Imported into new system | 2,10,00,000 | Mapped to destination ledgers |
| Trial balance after import | 2,10,00,000 | Matches Tally; nothing lost |
If the import had shown ₹2,05,00,000, the ₹5,00,000 gap would point to a missing period or vouchers whose ledgers were not exported first.
Watch out
04 Common mistakes
- Exporting only part of the year.
- Choosing Excel or PDF when the data is meant for import.
- Importing vouchers before their masters, which breaks references.
- Skipping the post-import trial balance check.
- Expecting the GST portal to accept a Tally XML file. GST returns are uploaded in the portal's own format, so XML only feeds a tool that prepares that file.
Need help with Tally XML export? See our Tally to Zoho Books Migration or Tally to Odoo Migration.
