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
- Start Tally Prime and open the company you want to import into.
- Minimize Tally (leave it running).
- Start udiMagic and select
Excel to Tally. - Select option
Import data into Tally. - 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.
- Follow the wizard to complete the import.
- 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.
- See udiMagic XML tags for the full tag/attribute reference. Comments are written using the <!-- --> syntax.
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