Help Guide

Help Guide

The User Guide provides all the information and step-by-step instructions needed to use the Excel to Tally XML Converter tool and related services. It covers how to select and use different templates, manage data correctly in Excel, and convert it into Tally XML format without errors. By following this guide, users can save time, avoid mistakes, and ensure smooth migration of accounting data from Excel to Tally. Reading this help guide before starting will give you clarity on the process and help you avoid common errors that may occur during import.

---

✅ Import Excel To Tally Tips:

• Use AUTO MENU – This automatically calculates Debit and Credit Ledger amounts, saving you the hassle of manual calculation and ensuring accuracy in financial entries.
• Template names include VCHR for Vouchers, LED for Ledgers, MITM for Items, and BANK for Bank transactions. Each template is designed with a fixed structure to avoid errors.
• Do not change the file name of the downloaded Excel template, otherwise the system may not recognize it during conversion.
• Each column in the Excel template has a defined purpose. Modifying the layout can break the format and lead to Tally import failures.
• When you need to clear data, use Delete Rows or Delete Columns instead of altering structure.
• If at any point the format is broken, it is best to download a fresh template and start again.
• Use Copy and Paste Special → Values to retain formatting and ensure Tally accepts the data smoothly.
• Always create all master records in Tally before importing vouchers to avoid mismatched references.
• In the Master Ledger Template – if a Ledger Name contains &, replace it with & to avoid XML errors.
• Ensure your system and Excel date format is always set to DD-MM-YYYY to maintain consistency with Tally requirements.

Following these tips ensures your Excel to Tally XML import process runs without issues. By maintaining the correct template structure and applying the right methods, you can save hours of manual entry while avoiding common accounting mistakes.

---

Excel To Tally Templates Details:

• VCHR_VoucherAllTally: Excel template for all types of vouchers. This format works with Tally 7.2, ERP 9, and Prime. It is designed to manage sales, purchases, journals, and receipts.
• LEDN_LedgerAllTally: Universal Ledger creation template that works across all Tally versions. Helps create consistent ledgers without manual effort.
• LEDS_LedgerTally7: Template made for Ledger creation in older Tally versions like 7.2 and ERP 9. Useful for businesses still using older systems.
• MITM_ItemAllTally: Template for creating Stock Items in bulk. Compatible with all Tally versions, this saves time when creating hundreds of inventory items.
• FVCH_CurrencyVoucherAllTally: For companies dealing in multiple currencies, this template is essential. It supports Forex and currency conversion vouchers.
• BANK_AllTally: Bank ledger format designed for importing bulk bank transactions into Tally. Works with all versions.
• Auto_Menu: With a single press of F1, users can open Auto Menu to validate data, remove errors, and automatically assign Debit/Credit values.
• All templates are macros-enabled (.xlsm) and come with built-in data validation, reducing the chance of errors during XML generation.
• Each template follows a uniform column structure, ensuring data is correctly converted into XML and imported into Tally without rejections.

These templates are the backbone of Excel to Tally XML Converter. They allow businesses to handle vouchers, ledgers, bank statements, and stock items systematically. By using the right template, you can drastically reduce manual work and achieve a reliable import process.

---

📥 How to Import Data to Tally from Excel?

• Download the required Master or Voucher Excel template depending on your need.
• Never rename the downloaded template file because the system matches the file name during conversion.
• Enter your accounting data exactly as per the template structure.
• Use the Template Button to auto-adjust Debit values into negative format for easy balance.
• Before uploading, delete all empty rows. Press CTRL + END to check for hidden empty rows.
• Upload the file and click on Generate XML. The converter will process it automatically.
• Once complete, an XML file will be downloaded on your system.
• Use this XML file directly to import into Tally, saving time and effort of manual entry.

This process is simple yet powerful. With a few clicks, you can migrate hundreds of accounting records from Excel into Tally, ensuring accuracy and consistency. It is recommended to validate your Excel file before generating XML to avoid errors in Tally import.

---

📂 How to Import XML File in Tally?

• Open Tally and choose the company where you want to import data.
• Go to the Import of Data section.
• Select either Masters or Vouchers option depending on your file.
• Enter the full file path of the XML file, for example c:\vch.xml.
• The import process will begin automatically.
• Ensure all Master entries like Ledgers, Items, and Groups are created before importing vouchers.
• If errors occur, check the Tally.imp file for detailed error messages.

Importing XML files into Tally is straightforward but requires attention to detail. By following the exact path and ensuring pre-created masters, you can avoid rejections. The error log file helps troubleshoot issues quickly so you can re-import successfully.

---

💻 Prerequisite Software:

• Operating System: Windows 7 or higher.
• Microsoft Excel 2007 or later versions for compatibility.
• Supports all versions of Tally including Tally 7.2, 8.1, 9, ERP, ERP 9, Prime and above.
• Recommended browser: Google Chrome for smooth operation.

Having the right software setup ensures smooth operation of Excel to Tally XML Converter. Keeping your system updated also prevents unexpected issues during data conversion.

---

📘 Excel To Tally Training:

• No professional training is required.
• Basic knowledge of Microsoft Excel and Tally is enough to use this tool effectively.
• Users should go through the Help Guide before starting the import process.
• Demo videos and screenshots are available for additional clarity.

The training requirement is minimal. This tool is designed to be user-friendly, so anyone with working knowledge of Excel and Tally can start importing data within minutes.

---

❌ Tally Error Handling:

Error: Can’t Import – Check Tally.imp?

• In Tally, go to Gateway of Tally → F12 → General.
• Set “Ignore errors during data import” to YES.

Error: No Accounting Allocation?

• This error occurs when inventory is enabled in Ledger settings.
• Go to Alter → Ledger for the affected ledger.
• Set “Inventory values are affected” to YES.

How to View & Fix Errors?

• The Tally.imp file contains a complete error log with reasons.
• It is located in the Tally installation folder.
• Right-click the Tally icon → Properties → Open File Location.
• Look for the file type “IMP file” and open it with Notepad.
• Review errors, fix them in Excel, re-upload, and re-import the XML file.

How to Check Errors in Tally Prime via Exception Reports?

• In Tally Prime, navigate to Gateway of Tally → Display More Reports → Exception Reports.
• Select exception types such as Errors in Vouchers, Negative Stock, etc.
• Click on the row to open detailed error information and fix it directly inside Tally.
• This helps detect missing or unlisted errors after XML import.