TALLY ERP 9 - Multiple entry altration
This query is : Resolved
27 August 2024
Sir,
Sir i have made 1500 entries in Tally ERP 9 Indian Rupees. Now i need to convert these entries to Omani Riyal ( Ex. INR/216). Is there is any easy way to convert these entries to Omani Riyal. I tried to export the Day book and divided the entries by 216. Then converted it to XML format, and import it to a new Tally ERP 9. But It's not working. Please help me in this matter.
Sir i have made 1500 entries in Tally ERP 9 Indian Rupees. Now i need to convert these entries to Omani Riyal ( Ex. INR/216). Is there is any easy way to convert these entries to Omani Riyal. I tried to export the Day book and divided the entries by 216. Then converted it to XML format, and import it to a new Tally ERP 9. But It's not working. Please help me in this matter.
12 August 2025
This is a common challenge in **Tally ERP 9**, which doesn’t natively support **bulk currency conversion** for existing entries — especially after they’re recorded in one base currency.
Let me break down the situation and possible solutions:
---
## 🎯 Objective:
You entered 1500 vouchers in **INR** but now need to **recreate them in Omani Riyal (OMR)** using a conversion rate of **₹216 = 1 OMR**.
---
## ⚠️ Why Your XML Import Isn’t Working:
1. **Tally XML import** is **very sensitive** to structure and syntax.
2. When you modify exported XML and re-import it, **currency mismatches**, **missing masters**, or **wrong data types** can cause silent failures or no import.
3. Tally doesn’t automatically recalculate foreign exchange values from XML unless you set it up properly.
---
## ✅ Practical Workarounds:
### 🔹 Option 1: Use Tally's **Multi-Currency Feature**
> This works only **if entries are not yet made** or you want to recreate them.
1. **Enable Multi-Currency**:
* Go to: `F11 → Accounting Features → Enable Multi-Currency: Yes`
2. **Create New Currency – OMR**:
* Gateway of Tally → Accounts Info → Currencies → Create
* Name: Omani Riyal (OMR)
* ISO Code: OMR
* Standard Rate: 1 OMR = ₹216
3. **Create New Ledger(s)** (if needed) under Debtors/Creditors with foreign currency set to OMR.
4. **Re-enter the Vouchers** manually (or through import) with currency set to OMR.
> ✅ You will now see the INR and OMR split in reports.
---
### 🔹 Option 2: Use **Tally TDL or Add-on Tools** (Recommended for bulk edit)
You can use a **custom TDL (Tally Definition Language)** script or a **third-party Tally data migration tool** to:
* **Read existing vouchers**
* **Recalculate the values (INR ÷ 216)**
* **Recreate new vouchers in OMR**
There are TDL developers and tools like:
* **Shweta Softwares**
* **TDL developers on Fiverr/Upwork**
* **Tally customisation partners**
> 🔐 If you need help drafting a sample TDL logic, I can help you start with that too.
---
### 🔹 Option 3: Excel + XML Import (Advanced, but risky)
Since you already tried:
* Export Day Book to Excel
* Divide values by 216
* Convert back to XML for import
Make sure of the following:
* Currency master “OMR” exists in Tally before importing.
* Ledger names and group names exactly match.
* XML format is valid (no extra characters or malformed tags).
* Each voucher has unique `VOUCHERNUMBER` and date.
* Use Tally’s sample XML structure as a base.
Still, **Tally ERP 9 is not robust with manual XML import for foreign currencies** — and even minor errors will cause it to ignore your import without messages.
---
## 🧾 Recommendation:
If re-entering 1500 vouchers manually is not an option:
* Either go for a **TDL solution**, or
* Use Tally Prime + Tally Developer Tools (if you have access) to script this conversion.
---
## ✅ Summary:
| Method | Works? | Notes |
| ----------------------- | ------ | ----------------------------------------------- |
| Manual Re-entry in OMR | ✅ | Accurate, time-consuming |
| Excel → XML Import | ⚠️ | Needs 100% correct structure, prone to failure |
| Multi-Currency in Tally | ✅ | Works well if used from the start |
| TDL Script/Automation | ✅ | Best for bulk conversion with correct structure |
---
Would you like a sample XML structure or a draft TDL logic to start with? Let me know!
Let me break down the situation and possible solutions:
---
## 🎯 Objective:
You entered 1500 vouchers in **INR** but now need to **recreate them in Omani Riyal (OMR)** using a conversion rate of **₹216 = 1 OMR**.
---
## ⚠️ Why Your XML Import Isn’t Working:
1. **Tally XML import** is **very sensitive** to structure and syntax.
2. When you modify exported XML and re-import it, **currency mismatches**, **missing masters**, or **wrong data types** can cause silent failures or no import.
3. Tally doesn’t automatically recalculate foreign exchange values from XML unless you set it up properly.
---
## ✅ Practical Workarounds:
### 🔹 Option 1: Use Tally's **Multi-Currency Feature**
> This works only **if entries are not yet made** or you want to recreate them.
1. **Enable Multi-Currency**:
* Go to: `F11 → Accounting Features → Enable Multi-Currency: Yes`
2. **Create New Currency – OMR**:
* Gateway of Tally → Accounts Info → Currencies → Create
* Name: Omani Riyal (OMR)
* ISO Code: OMR
* Standard Rate: 1 OMR = ₹216
3. **Create New Ledger(s)** (if needed) under Debtors/Creditors with foreign currency set to OMR.
4. **Re-enter the Vouchers** manually (or through import) with currency set to OMR.
> ✅ You will now see the INR and OMR split in reports.
---
### 🔹 Option 2: Use **Tally TDL or Add-on Tools** (Recommended for bulk edit)
You can use a **custom TDL (Tally Definition Language)** script or a **third-party Tally data migration tool** to:
* **Read existing vouchers**
* **Recalculate the values (INR ÷ 216)**
* **Recreate new vouchers in OMR**
There are TDL developers and tools like:
* **Shweta Softwares**
* **TDL developers on Fiverr/Upwork**
* **Tally customisation partners**
> 🔐 If you need help drafting a sample TDL logic, I can help you start with that too.
---
### 🔹 Option 3: Excel + XML Import (Advanced, but risky)
Since you already tried:
* Export Day Book to Excel
* Divide values by 216
* Convert back to XML for import
Make sure of the following:
* Currency master “OMR” exists in Tally before importing.
* Ledger names and group names exactly match.
* XML format is valid (no extra characters or malformed tags).
* Each voucher has unique `VOUCHERNUMBER` and date.
* Use Tally’s sample XML structure as a base.
Still, **Tally ERP 9 is not robust with manual XML import for foreign currencies** — and even minor errors will cause it to ignore your import without messages.
---
## 🧾 Recommendation:
If re-entering 1500 vouchers manually is not an option:
* Either go for a **TDL solution**, or
* Use Tally Prime + Tally Developer Tools (if you have access) to script this conversion.
---
## ✅ Summary:
| Method | Works? | Notes |
| ----------------------- | ------ | ----------------------------------------------- |
| Manual Re-entry in OMR | ✅ | Accurate, time-consuming |
| Excel → XML Import | ⚠️ | Needs 100% correct structure, prone to failure |
| Multi-Currency in Tally | ✅ | Works well if used from the start |
| TDL Script/Automation | ✅ | Best for bulk conversion with correct structure |
---
Would you like a sample XML structure or a draft TDL logic to start with? Let me know!
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Relief Calculation u/s 89 of ITax 1961 in TableA Form10E
- Can we claim ITC in 28%
- Regarding E-invoice Generation
- Forgot to update debit note in gst
- CA Final exam Form
- Can we claim RCM ITC paid on Gst audit of earlier years,
- Expenses add back in profit
- GST APPLICATION
- Wrongly goods delivered to other state
- Running non ac bus under contract with roadways
- Issue with PTEC Registration – PAN Already Used
- Tds on GST in connection with sale to public company
- B2B Amendment
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- Regarding Advance Tax not claimed in the Return of Income for A.Y. 2025-26
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
- Address Change to another state of a Registered Trust with 12AB approval
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
