Upload Excel template & get XML for import in Tally 7.2, ERP 9, PRIME.

Download Templates Demo Video Features Help BUY 15CaCB Bulk XML

Latest Blog Posts:

• List of 10 Best Accounting Software for Small Business
• How to earn daily 1000 rupees earning App without investment?
• How to convert PDF Bank Statement to Tally
• How to Import Multi Currency Voucher in Tally from Excel
• How to import Bank Statement in Tally from Excel
• How to import Stock items in Tally from Excel

How to free convert Excel data into Tally XML file?

• Read the Help Guide before starting.
• Download the latest Masters or Vouchers Excel template – Download Now.
• Do not rename the downloaded Excel file.
• Fill data exactly as per the Excel template format.
• Use the AUTO MENU in the template to automatically generate DR/CR values.
• You don’t need to manually write DR/CR for amount columns.
• Ensure all data is correctly validated and error-free.
• Enable Excel Macros to use auto features effectively.
• 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.

Excel To Tally Templates Details:

• VCHR_VoucherAllTally: Excel template for all types of Vouchers – works with Tally 7.2, ERP 9 & Prime.
• LEDN_LedgerAllTally: Universal Ledger creation template compatible with all Tally versions.
• LEDS_LedgerTally7: Exclusive template for creating Ledgers for Tally 7.2 and ERP 9 only.
• MITM_ItemAllTally: Excel template for creating Stock Items – works with all Tally versions.
• FVCH_CurrencyVoucherAllTally: Excel template for all types of Forex Multi Currency Vouchers – works with all Tally versions.
• BANK_AllTally: Bank ledger Excel format for Bank Statements Transaction with all Tally Versions.
• 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 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.

Free Excel to Tally Features:

• Upload Excel template file up to limited size in free plan.
• Upgrade to Paid Subscription to upload Excel files up to 1 MB.
• Convert unlimited Excel data into Tally-compatible XML format.
• Includes all available templates for Masters and Vouchers.
• Compatible with Tally Prime, ERP 9, Tally 7.2, and higher versions.
• Access to new upcoming template modules at no extra cost.
• Work online by logging into your account anytime, anywhere.
• No software installation required – works directly in browser.
• Secure file processing – no data is stored permanently.
• Easy-to-use interface suitable for all users.
• Smart data validation to reduce conversion errors.
• Auto formatting and mapping of Tally fields.
• Import all types of vouchers: Receipt, Payment, Contra, Journal, Sales, Purchase, Credit Note, Debit Note.
• Fast processing – generates XML in just a few seconds.
• Free help guide and video tutorials available for support.
• No hidden charges for basic features and conversions.