Tally XML is not a single feature. It is the data interchange format for two different operations: importing masters and importing transactions. The file structure is almost identical, but the REPORTNAME and the object inside TALLYMESSAGE change.
Masters vs Transactions
| Masters | Transactions | |
|---|---|---|
| What they are | Definitions reused across vouchers | Actual accounting entries |
XML REPORTNAME | All Masters | Vouchers |
| Main object | <LEDGER>, <GROUP>, <STOCKITEM>, <VOUCHERTYPE> | <VOUCHER> |
| Import menu | Alt+O → Masters | Alt+O → Transactions |
| Order | Import first | Import after masters exist |
What Counts as Master Data
These are the master types Tally can create or alter from XML:
| Master | Typical use |
|---|---|
| Groups | Chart of accounts hierarchy: Bank Accounts, Sundry Debtors, Expenses |
| Ledgers | Bank, party, expense, income, tax and loan accounts |
| Stock groups | Product categories |
| Stock items | Inventory items with units and opening balances |
| Units of measure | Nos, Kg, Ltr, Box and compound units |
| Voucher types | Payment, Receipt, Contra, Sales, Purchase and custom types |
| Cost centres and categories | Departmental or project cost allocation |
| Godowns | Storage locations for inventory |
Example: a ledger master
<ENVELOPE>
<HEADER>
<TALLYREQUEST>Import Data</TALLYREQUEST>
</HEADER>
<BODY>
<IMPORTDATA>
<REQUESTDESC>
<REPORTNAME>All Masters</REPORTNAME>
</REQUESTDESC>
<REQUESTDATA>
<TALLYMESSAGE>
<LEDGER NAME="HDFC Bank - Current A/c" ACTION="Create">
<NAME>HDFC Bank - Current A/c</NAME>
<PARENT>Bank Accounts</PARENT>
<OPENINGBALANCE>0</OPENINGBALANCE>
</LEDGER>
</TALLYMESSAGE>
</REQUESTDATA>
</IMPORTDATA>
</BODY>
</ENVELOPE>
What Counts as Transaction Data
Vouchers are the accounting and inventory entries. Common types:
- Accounting vouchers — Payment, Receipt, Contra, Journal, Sales, Purchase, Credit Note, Debit Note.
- Inventory vouchers — Delivery Note, Receipt Note, Rejection In, Rejection Out, Stock Journal, Physical Stock.
- Order vouchers — Purchase Order, Sales Order.
The voucher type must exist in the company and be enabled. If you import a Payment voucher into a company where the Payment voucher type is disabled, the voucher is skipped.
Example: a Payment voucher
<TALLYMESSAGE>
<VOUCHER VCHTYPE="Payment" ACTION="Create">
<DATE>20261001</DATE>
<EFFECTIVEDATE>20261001</EFFECTIVEDATE>
<VOUCHERTYPENAME>Payment</VOUCHERTYPENAME>
<NARRATION>NEFT/UTR123456/VENDOR PAYMENT</NARRATION>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>Suspense Account</LEDGERNAME>
<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
<AMOUNT>-25000.00</AMOUNT>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>HDFC Bank - Current A/c</LEDGERNAME>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<AMOUNT>25000.00</AMOUNT>
</ALLLEDGERENTRIES.LIST>
</VOUCHER>
</TALLYMESSAGE>
AMOUNT with ISDEEMEDPOSITIVE = Yes; credit legs carry a positive amount with No.
Field Formats Tally Expects
| Tag | Format | Example |
|---|---|---|
DATE, EFFECTIVEDATE | YYYYMMDD | 20261001 |
AMOUNT | Decimal, no commas, no currency symbol | -1250.00 |
ISDEEMEDPOSITIVE | Yes / No | Yes for debit |
VOUCHERTYPENAME | Exact voucher type name | Payment |
LEDGERNAME | Exact ledger spelling | HDFC Bank - Current A/c |
NARRATION | Plain text, XML-escaped | UPI/DR/123/ABC & CO |
Escape &, <, >, quotes and apostrophes. An unescaped ampersand in a narration is enough to make the whole file invalid XML.
Import Steps
Import masters
- Open the company.
- Press Alt+O (Import) → Masters.
- Select the XML file and press Enter.
- Check the Chart of Accounts for the new masters.
Import transactions
- Confirm the masters named in the file already exist.
- Press Alt+O (Import) → Transactions.
- Select the XML file, choose Add for existing vouchers, and press Enter.
- Check the Day Book and the imported/skipped counts.
On Tally.ERP 9 the paths are Import of Data → Masters and Import of Data → Vouchers.
How This Applies to Bank Statements
A PDF bank statement is not structured data, so it cannot be imported directly. The practical workflow is:
- Convert the PDF into Tally voucher XML — one Payment voucher per debit, one Receipt voucher per credit.
- Set the bank ledger and the opposite/Suspense ledger to names that already exist in Tally.
- Import the XML through Alt+O → Transactions.
- Reclassify the Suspense leg to the correct expense, income or party ledger.
Full walkthrough: how to import PDF bank statement in Tally Prime. If you need the converter, start with the bank statement to Tally XML converter.
Common Import Errors
| Error | Cause | Fix |
|---|---|---|
| Masters missing | Ledger, group or stock item referenced but not present | Import masters first, or create them manually |
| Voucher type not found | Type disabled or spelled differently | Enable it in F11 features or correct the name |
| Date error | Separators or DDMMYYYY used | Use YYYYMMDD |
| Nothing imported | Wrong REPORTNAME or wrong menu | Use Vouchers with Alt+O → Transactions |
| Existing vouchers replaced | Duplicate voucher IDs | Use Add, remove remote voucher IDs, keep backups |
| Invalid XML | Unescaped characters or truncated file | Validate the file before import |
Frequently Asked Questions
Which of the following data can be imported into Tally Prime using the XML format?
All of the above. Tally XML can import accounting ledgers and other masters, vouchers and transactions. Ledgers and groups are masters; Payment, Receipt, Sales and Purchase entries are vouchers or transactions.
What is the difference between masters and transactions in Tally XML?
Masters are reusable definitions such as ledgers, groups, stock items, units, godowns, cost centres and voucher types. Transactions are vouchers that reference those masters, such as a Payment or Sales voucher. Import masters first.
Which voucher types can be imported through Tally XML?
Accounting vouchers including Payment, Receipt, Contra, Journal, Sales, Purchase, Credit Note and Debit Note, plus inventory vouchers such as Delivery Note, Receipt Note, Stock Journal and Physical Stock, provided the voucher type is enabled in the company.
What REPORTNAME should a Tally XML import file use?
Use Vouchers for transaction data and All Masters for master data such as ledgers and stock items. The value sits inside REQUESTDESC in the IMPORTDATA block.
Can Tally XML import a PDF bank statement?
No. XML is a structured data format, so the PDF must first be converted into voucher XML. Once converted, the XML imports as Payment and Receipt vouchers through Alt+O → Transactions.
What date format does Tally XML import require?
The DATE and EFFECTIVEDATE tags use YYYYMMDD with no separators, for example 20261001. A wrong date format is one of the most common reasons vouchers are skipped.
How this guide was checked
The list of importable masters and transactions comes from Tally's import documentation and from testing each data type in a TallyPrime company. Read the editorial policy for how we handle corrections.
Last reviewed: 4 November 2026Sources
Turn a PDF Statement into Tally Voucher XML
Payment and Receipt vouchers, editable ledger names, 100+ Indian banks.
Convert Bank Statement to Tally XML