MyTaxFlow — Convert Bank Statement to Tally XML

Which Data Can Be Imported into Tally Prime Using XML?

Masters, ledgers, vouchers and transactions — the full list, the XML structure, and the field formats Tally actually accepts.

Updated November 2026 · 7 min read
Short answer: All of the above. Tally Prime can import both masters (accounting ledgers, groups, stock items, voucher types) and transactions (vouchers such as Payment, Receipt and Sales) through XML. The multiple-choice question “accounting ledger, voucher, master, transaction” has one correct option: all of them.

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

MastersTransactions
What they areDefinitions reused across vouchersActual accounting entries
XML REPORTNAMEAll MastersVouchers
Main object<LEDGER>, <GROUP>, <STOCKITEM>, <VOUCHERTYPE><VOUCHER>
Import menuAlt+O → MastersAlt+O → Transactions
OrderImport firstImport after masters exist

What Counts as Master Data

These are the master types Tally can create or alter from XML:

MasterTypical use
GroupsChart of accounts hierarchy: Bank Accounts, Sundry Debtors, Expenses
LedgersBank, party, expense, income, tax and loan accounts
Stock groupsProduct categories
Stock itemsInventory items with units and opening balances
Units of measureNos, Kg, Ltr, Box and compound units
Voucher typesPayment, Receipt, Contra, Sales, Purchase and custom types
Cost centres and categoriesDepartmental or project cost allocation
GodownsStorage 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:

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>
Two legs, opposite signs. A voucher is only accepted when the ledger entries balance to zero. Debit legs carry a negative AMOUNT with ISDEEMEDPOSITIVE = Yes; credit legs carry a positive amount with No.

Field Formats Tally Expects

TagFormatExample
DATE, EFFECTIVEDATEYYYYMMDD20261001
AMOUNTDecimal, no commas, no currency symbol-1250.00
ISDEEMEDPOSITIVEYes / NoYes for debit
VOUCHERTYPENAMEExact voucher type namePayment
LEDGERNAMEExact ledger spellingHDFC Bank - Current A/c
NARRATIONPlain text, XML-escapedUPI/DR/123/ABC &amp; CO

Escape &, <, >, quotes and apostrophes. An unescaped ampersand in a narration is enough to make the whole file invalid XML.

Import Steps

Import masters

  1. Open the company.
  2. Press Alt+O (Import) → Masters.
  3. Select the XML file and press Enter.
  4. Check the Chart of Accounts for the new masters.

Import transactions

  1. Confirm the masters named in the file already exist.
  2. Press Alt+O (Import) → Transactions.
  3. Select the XML file, choose Add for existing vouchers, and press Enter.
  4. 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:

  1. Convert the PDF into Tally voucher XML — one Payment voucher per debit, one Receipt voucher per credit.
  2. Set the bank ledger and the opposite/Suspense ledger to names that already exist in Tally.
  3. Import the XML through Alt+O → Transactions.
  4. 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

ErrorCauseFix
Masters missingLedger, group or stock item referenced but not presentImport masters first, or create them manually
Voucher type not foundType disabled or spelled differentlyEnable it in F11 features or correct the name
Date errorSeparators or DDMMYYYY usedUse YYYYMMDD
Nothing importedWrong REPORTNAME or wrong menuUse Vouchers with Alt+O → Transactions
Existing vouchers replacedDuplicate voucher IDsUse Add, remove remote voucher IDs, keep backups
Invalid XMLUnescaped characters or truncated fileValidate 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 2026

Sources

Turn a PDF Statement into Tally Voucher XML

Payment and Receipt vouchers, editable ledger names, 100+ Indian banks.

Convert Bank Statement to Tally XML

Related Guides