Exercise 23

Update Ledger Name in Tally

Published


This exercise teaches you how to rename existing Ledgers in Tally Prime from Excel. Each row of the Excel sheet holds the ledger's new name and its old name. You will use the OLDNAME tag to tell Tally which ledger to rename.

Step 1 — Prepare the Excel sheet

Create an Excel sheet with one row per ledger. Put the new ledger name in Column B, and the name the ledger has in Tally today in Column C. Sr No is for your reference only and is not imported into Tally.

A B C
1 sr.no name old name
2 1 Sharma Traders Pvt Ltd Sharma Traders
3 2 Gupta Electronics Gupta Electric Store
4 3 Verma & Sons Enterprises Verma Sons
5 4 Patel Industries Ltd Patel Industries
6 5 Singh Hardware Mart Singh Hardware

Step 2 — Write the XML tags in a separate file

Open Notepad (or any plain-text editor) and write the following XML tags:

<!--
  Column A = Sr No (not imported)     Column B = New Ledger Name
  Column C = Old Ledger Name
-->
<XMLTAGS CELLREFERENCE="A1" xmlns:UDF="TallyUDF">
    <MASTER TYPE="LEDGER">
        <!-- New ledger name; skipped when Column B is blank -->
        <NAME SKIP="=len(trim(B#))=0" COLUMNREFERENCE="B"/>
        <!-- Existing ledger name in Tally, which is replaced by the new name -->
        <OLDNAME COLUMNREFERENCE="C"/>
    </MASTER>
</XMLTAGS>

Step 3 — Save the file

Save it as update-ledger-name-xml-tags.xml. In the Save as type box, choose All Files — otherwise Notepad appends .txt and you'll end up with update-ledger-name-xml-tags.xml.txt instead.

Import into Tally

  1. Start Tally Prime and open the company you want to import into.
  2. Minimize Tally (leave it running).
  3. Start udiMagic and select Excel to Tally.
  4. Select option Import data into Tally.
  5. Browse to select both the Excel sheet and the XML tags file — you're prompted for the XML file on the same screen as the Excel sheet.
  6. Follow the wizard to complete the import.
Note:
  1. Old Name is udiMagic supported tag. It is used to update existing masters. Tally looks up the ledger named in Column C and replaces its name with the value in Column B.
  2. See udiMagic XML tags for the full tag/attribute reference. Comments are written using the <!-- --> syntax.
Sample files: Download the sample Excel sheet and matching XML tags file for this exercise. Download update-ledger-name.zip

Ready to import your Excel data into Tally?

Download udiMagic and start a 14-day free trial — no credit card required.

Download udiMagic View Pricing