Developer ToolsFree generatorPDF, Excel, Word exportTally PrimeIndia

Tally XML Ledger Import Generator

When a business moves customers or vendors into Tally from Excel, creating ledgers one by one is slow. An XML import lets you create masters in bulk. This generator shows the structure for one party ledger, which you can repeat for every row.

Fill in

Company name

Ledger name

Under group

Address line

State

Pincode

GSTIN

Generated code

Download:

Import request

<ENVELOPE>
  <HEADER>
    <TALLYREQUEST>Import Data</TALLYREQUEST>
  </HEADER>
  <BODY>
    <IMPORTDATA>
      <REQUESTDESC>
        <REPORTNAME>All Masters</REPORTNAME>
        <STATICVARIABLES>
          <SVCURRENTCOMPANY>Sharma Engineering Works</SVCURRENTCOMPANY>
        </STATICVARIABLES>
      </REQUESTDESC>
      <REQUESTDATA>
        <TALLYMESSAGE xmlns:UDF="TallyUDF">
          <LEDGER NAME="Kaveri Auto Components Pvt Ltd" ACTION="Create">
            <NAME>Kaveri Auto Components Pvt Ltd</NAME>
            <PARENT>Sundry Debtors</PARENT>
            <ISBILLWISEON>Yes</ISBILLWISEON>
            <COUNTRYOFRESIDENCE>India</COUNTRYOFRESIDENCE>
            <LEDSTATENAME>Karnataka</LEDSTATENAME>
            <PINCODE>560058</PINCODE>
            <PARTYGSTIN>29AABCK1234F1Z5</PARTYGSTIN>
            <ADDRESS.LIST>
              <ADDRESS>Plot 14, Peenya Industrial Area</ADDRESS>
            </ADDRESS.LIST>
          </LEDGER>
        </TALLYMESSAGE>
      </REQUESTDATA>
    </IMPORTDATA>
  </BODY>
</ENVELOPE>

Tag names and GST fields differ between Tally releases. Export an existing ledger with the export request generator and compare the tags before a bulk run. Always import into a test company first and take a backup.

Plan a master data migration

Optional expert review of party and item master clean-up before moving off Tally.

Optional. The tool and every export work without this. No spam.

How to use it

Fill the fields for one party and copy the XML. Post it to the Tally HTTP port, or save it as a file and use the Import option for masters in Tally. For a bulk load, repeat the LEDGER block inside TALLYMESSAGE for each row of your spreadsheet, using a short script or Excel formulas to build the text.

Structure explained

The TALLYREQUEST value Import Data and the REPORTNAME All Masters tell Tally you are loading masters. Each LEDGER needs a name and a parent group. For GST the party GSTIN and state fill the registration details. ISBILLWISEON controls whether bill by bill outstanding is tracked, which is usually Yes for debtors and creditors.

Parent group names must already exist in the company.
Check the GSTIN with the validator tool before importing.
State names must match the Tally state list.

Testing and rollback

Take a data backup, import into a test company and compare ledger counts against your source. Tally replies with counts of created, altered and errored objects, and the error list tells you which names failed. Duplicate names are a common reason for failure.

Common mistakes

Unescaped ampersands in party names, missing parent groups, extra spaces in names that create near duplicates, and invalid GSTINs that fail validation in a later e-invoice step.

Frequently Asked Questions

Can I import ledgers from Excel into Tally?

Yes. Build the XML from your sheet rows with a script or formulas and import it, or use Tally's own import options for masters. Always test in a copy of the company first.

What does ACTION Create do?

It tells Tally to add a new ledger. If the name already exists the import reports an error, so use Alter only when you intend to change an existing master.

Do I need to escape special characters?

Yes. An ampersand in a party name must be written as & and less-than signs as < or the XML will be rejected.

Will this work for stock items?

Stock items use a STOCKITEM block with different tags such as a base unit and opening balance. Export an existing stock item first to see the exact tags for your release.

For larger migrations from Tally to a full ERP, we can help assess data quality and plan the cutover with your implementation partner.

Talk to an Expert Explore More Free Tools

Related Tools

Developer Tools

More Developer Tools tools

See all

Back to All Tools