Tally Guide

Tally Guide
This User Guide helps you efficiently use the online tool to convert Excel data into Tally XML files. It covers working with different templates, step-by-step instructions, and troubleshooting common issues encountered during the import. Please read this guide carefully before starting the conversion process to avoid errors. The tool simplifies the transformation process and ensures compatibility with Tally software by following the structured instructions.
β Import Excel To Tally Tips:
- Use AUTO MENU β For auto make Debit and Credit Ledger amounts, remove errors, validations and more for help to prepare your Excel data quickly without errors and ensuring accuracy in financial entries.
- Template names include VCHR for Vouchers, LED for Ledgers. 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.
- Dont change Excel Template format & 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.
- 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.
- Ensure your system & Excel Date format is always set to DD-MM-YYYY to maintain consistency with Tally.
- If at any point the format is broken, it is best to download a fresh template and start again.
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 Import Template Download Free:
- VCHR_Voucher_Tally_All: Excel template for all types of Vouchers β works with Tally 7.2, ERP 9 & Prime.
- LEDN_Ledger_Tally_All: Excel template for Master Ledgers β works with Tally Prime.
- LEDS_Ledger_Tally_7: Excel template for Master Ledgers β works with Tally 7.2 & ERP 9.
- Auto_Menu: Press F1 to open Auto Menu for data validation, error removal, auto Dr/Cr ledger values, and more.
- Macros Enabled Templates: All templates are macros-enabled (.xlsm) for automated data processing.
- Data Strong Validation Applied: Templates include strong validation rules to prevent Tally import errors.
- Uniform Structure: Templates follow a fixed column order and naming system to ensure accurate XML conversion.
π How to convert Excel to Tally xml file?
- Download the latest Masters or Vouchers Excel template β Download Now.
- Do not rename the downloaded Excel Template file.
- Fill data exactly as per the Excel template format.
- Make Debit all Ledgers Amount in MINUS (-). Take Help of AUTO-MENU for Auto make minus.
- Use the AUTO MENU in Template to automatically generate DR/CR values.
- Ensure all data is correctly validated and error-free.
- Remove all empty rows before uploading. (Use CTRL + END to check)
- Make sure file is saved before uploading.
- Upload the filled Excel file on the website.
- Click on the βGENERATEβ xml button to convert.
- Wait until processing completes and download the XML file.
- The downloaded XML file is ready for Tally import.
- Open Tally and import the XML file to view the entries.
π 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.impfile 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 Solution
π‘ Can’t import check tally.imp for details:
Import failed in Tally. The data file contains issues such as mismatched voucher types, missing ledgers, invalid stock items, or incorrect currency details. Please review the tally.imp / Exceptions log for specific error lines, correct the highlighted mismatches, and then re-import the corrected file to proceed successfully.
π οΈ Tally Error No Accounting Allocation for:
- 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 check Tally imp for details?
- The
Tally.impfile 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 Exception report in Tally Prime?
- 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.
π How to solve Tally error Memory Access Violation?
- Restart Tally & PC
- Move data to simple path (e.g.,
C:\TallyData) - Repair data (Ctrl + Alt + R)
- Run Tally as Administrator
- Remove extra TDLs
- Update/Reinstall Tally
- If still fails, check RAM/disk errors.
π Tally Officialy Error Help Guide:
Learn everything about Tally accounting software with step-by-step guides and troubleshooting tips. Explore features, resolve errors, and improve your accounting efficiency. Access official online help for detailed instructions and updates for both Tally 9 and Tally Prime.
Tally Online Help Links:
List of 10 best of Accounting Software for Small Business
GST checklist for Statutory Audit
How to import vouchers in Tally from Excel?
Top 10 Excel formulas for Accountants & Auditor
How to import bank statement in Tally from Excel?
Accounting Link Between US and India | Excel to Tally XML Guide
How to import sales data from Excel to Tally?
How to import Master in Tally from Excel?
US to Tally XML Converter | Free Excel to Tally Prime Import Tool
What is GST Input Tax Credit (ITC) Reconciliation?