Tally
Tally

Excel to Tally Import TDL – New Update with Inventory & Without Inventory Import in TallyPrime

Mehul Patel17 November 20260 min read68 views

Simplify Your Accounting with Advanced Excel to Tally Data Import Automation

Managing large volumes of accounting transactions manually can be time-consuming and challenging. Whether you are importing Sales, Purchase, Payment, Receipt, or Journal entries, accurate data entry is essential for smooth business operations.

To make this process faster and easier, Shivansh Infosys introduces an updated version of the Excel to Tally Import TDL, featuring enhanced voucher mapping, inventory management, automatic master creation, and improved data import capabilities.

With this powerful TallyPrime customization, businesses can import multiple transactions directly from Excel into TallyPrime without entering each voucher manually.

What's New in the Excel to Tally Import TDL?

The latest update introduces improved functionality for importing transactions with inventory and without inventory, making the tool suitable for businesses dealing with both products and services.

1. Import Transactions With or Without Inventory

One of the major improvements in the updated Excel to Tally Import TDL is the ability to select the required import method.

Users can choose between:

  • Accounting Only (Without Inventory): Import service invoices and accounting transactions without stock item details.

  • With Inventory: Import transactions containing stock items, quantities, rates, GST details, and other inventory information.

Based on the selected option, the tool displays only the relevant mapping fields, making the configuration process easier and more convenient.

2. Import Multiple Voucher Types from a Single Excel Sheet

The updated Excel to Tally Import tool supports importing multiple voucher types using a single Excel sheet.

Supported transactions include:

  • Sales & Purchase Vouchers

  • Payment & Receipt Vouchers

  • Journal Vouchers

  • Sales Orders & Purchase Orders

  • Credit Notes & other supported transactions

Businesses can maintain transactions for different branches or voucher types in one Excel sheet and import them into their respective voucher types in TallyPrime.

This reduces repetitive work and simplifies bulk transaction processing.

3. Automatic Ledger and Stock Item Creation

Don't have the required ledgers or stock items already created in TallyPrime?

The Excel to Tally Import TDL can automatically create missing masters during the import process.

Key capabilities:

  • Automatic Party Ledger Creation

  • Automatic Sales Ledger Creation

  • Automatic Stock Item Creation

  • Stock Group and Category Mapping

  • Stock Item Unit Mapping

This helps businesses import data without manually creating every required master beforehand.

4. Ledger and Stock Item Alias Support

The updated tool also supports Ledger Alias and Stock Item Alias Mapping.

Businesses can import alias details directly from Excel and associate them with the respective ledgers and stock items in TallyPrime.

This feature is especially useful for organizations that maintain customer codes, product codes, or alternate identification numbers.

5. One-Time Excel Column Mapping

Repeatedly mapping the same Excel columns can take unnecessary time.

With the Excel to Tally Import TDL, users can configure their Excel column mapping once and reuse the same configuration for future imports, provided the Excel format remains unchanged.

Simply update the Excel sheet with new transaction data and import it using the saved mapping.

This makes recurring data imports faster and more efficient.

6. GST, Service Charges and Discount Mapping

The Excel to Tally Import tool supports mapping various accounting and taxation details, including:

  • CGST, SGST and IGST

  • GST Rates and Taxable Values

  • HSN/SAC Codes

  • Service Charges

  • Discount Percentages and Amounts

  • Before-GST and After-GST Expense Ledgers

  • TCS and Round-Off Amounts

The tool also provides item-wise GST calculation options to help import tax details correctly.

Users should verify the imported entries and GST reports to ensure the source data and tax configurations are accurate.

7. Advanced Inventory Import Features

For businesses managing inventory, the tool supports additional stock-related information during Excel imports.

These include:

  • Stock Item Quantity and Rate

  • Actual and Billed Quantity

  • Batch-Wise Inventory

  • Godown Details

  • Stock Item Categories

  • Cost Centre Details

It also supports scenarios involving free quantities, where the actual quantity and billed quantity may differ.

8. Flexible Voucher Numbering

Businesses can select how voucher numbers should be assigned during import.

Manual Numbering: Use voucher numbers available in the Excel sheet.

Automatic Numbering: Allow TallyPrime to assign voucher numbers according to the configured voucher numbering method.

This provides flexibility for businesses following different accounting and invoice numbering processes.

Benefits of Excel to Tally Import TDL

Save Valuable Time

Import bulk accounting transactions directly from Excel instead of entering vouchers individually.

Reduce Manual Data Entry

Minimize repetitive tasks and reduce the chances of manual entry mistakes.

Simplify GST Data Import

Map tax details, expenses, and discounts while importing transactions.

Manage Multiple Branches

Import transactions belonging to different voucher types or branches using a single Excel sheet.

Improve Accounting Productivity

Spend less time on repetitive data entry and focus more on business operations.

Who Can Benefit from This TDL?

The Excel to Tally Import TDL is suitable for:

  • Accountants and Accounting Firms

  • Traders and Distributors

  • Manufacturers

  • Retailers and Wholesalers

  • Service-Based Businesses

  • Businesses Managing Multiple Branches

  • Organizations Handling Large Transaction Volumes

Whether your business manages inventory or provides services, this customization can simplify your Excel-to-Tally data import process.

Watch the Complete Practical Demo

Want to see how the updated Excel to Tally Import TDL works?

In our latest video, the Shivansh Infosys team demonstrates the updated features, including inventory and non-inventory mapping, automatic ledger creation, alias support, GST mapping, and multiple voucher imports.

Watch the Full Video Here:

https://www.youtube.com/watch?v=k0wWnt6Zmk0

Get the Updated Excel to Tally Import TDL

Already using our Excel to Tally Import TDL and looking for the latest updated version?

Contact Shivansh Infosys to learn more about the new features, request an updated version, or schedule a practical demonstration.

Explore our range of TallyPrime customization solutions designed to simplify accounting, inventory management, GST reporting, and business automation.

Website: www.shivanshinfosys.in

Shivansh Infosys
Quick Response – Quick Support

Conclusion

The updated Excel to Tally Import TDL makes accounting data imports more flexible and efficient by introducing separate inventory and non-inventory mapping, automatic master creation, alias support, and multiple voucher imports.

By reducing repetitive manual work and simplifying Excel data mapping, businesses can save time and improve their accounting workflows.

Upgrade your Excel to Tally Import process with Shivansh Infosys and experience smarter accounting automation!

68 readers
M

Written by

Mehul Patel

Part of the Shivansh Infosys team — India's leading Tally partner with 400+ custom TDL add-ons built and a 3-Star Tally Certified Partner.

Quick Overview & Key Takeaways

  • Actionable Insight: Simplify enterprise accounting workflows using certified Tally Prime customizations to maximize reporting speed and minimize ledger entry manual work.
  • Compliance Focus: Stay 100% compliant with real-time statutory settings in Tally Prime for error-free GST returns, e-way bills, and automated e-invoicing.
  • Topical Authority: Shivansh Infosys leverages 15+ years of experience as an authorized Tally Partner to offer secured, compiled TDL integrations.

Workflow Efficiency Matrix

Compare accounting time investment across different system configurations.

Key OperationsManual Ledger EntryTally Prime StandardTally Prime + Custom TDL
Invoicing & GST ReturnsSlow & Error-ProneManual Entry needed✓ Automated Compliance
Workflow AutomationNot PossibleStandard ERP logic only✓ Custom TDL Workflows
Reporting & AnalysisLag of days/weeksNative report screens✓ Instant 1-Click Dashboards

Expert Verification & Authority

This guide has been reviewed and verified by the senior consulting team at Shivansh Infosys. As an authorized 3-Star Tally Partner since 2007, we have implemented over 400+ custom TDL modules and configured robust databases for 500+ small-to-large businesses.

Frequently Asked Questions

Ready to Transform Your Tally Prime Workflow?

Contact Shivansh Infosys, India's leading authorized Tally Partner. Get a free workflow audit and demo of custom TDL add-ons.

Article Stats

Views68
Likes0
Reading Time0 min
Published17 November 2026

Contact Us

+91 8460904467
info@shivanshinfosys.in
Gujarat, India

Recent Posts

WhatsApp Inquiry
Call Now
WhatsApp Inquiry
Call Now