udi-Magic Free Edition

A free tool for Tally ERP 9

udi-Magic Free Edition is a free utility to export data from Tally to Excel or to merge two ledgers in Tally. This tool is completely free and you can use it without any restrictions. However, no support technical support is provided for udi-Magic Free Edition.

udi-Magic Free Edition works with the latest version of Tally ERP 9.

Download it from here :

Get it from CNET Download.com!

Tally to Excel

The Tally to Excel feature enables you to export data from Tally ERP 9 to MS-Excel. Though, Tally ERP 9 has inbuilt support to export data into MS-Excel format, this functionality is primarily restricted to export of Tally Reports and NOT raw data or selective raw-data. Contrary to this, udi-Magic Free Edition allows you to retrieve selective raw-data using SQL-SELECT statements.

How to export data from Tally to Excel?

  1. Start udi-Magic Free Edition
  2. Select option "Tally to Excel"
  3. Type the SQL statement
  4. Click the Start button

Example of SQL Statements

SQL Statement Table Remarks
SELECT $Name, $LedgerPhone, $Email FROM ledger WHERE $$IsChildOf:$$GroupSundryDebtors Ledger Export data from Tally ERP 9 for all Parties falling under the group Sundry Debtors
SELECT $Name, $LedgerPhone, $Email FROM ledger WHERE $$IsChildOf:$$GroupSundryCreditors Ledger Export data from Tally ERP 9 for all Parties falling under the group Sundry Debtors
SELECT * FROM ledger WHERE $$IsChildOf:$$GroupSundryDebtors Ledger Export all data for all Customers from Tally to Excel
SELECT * FROM ledger WHERE $$IsChildOf:$$GroupSundryCreditors Ledger Export all data for all Vendors from Tally to Excel
SELECT $Name,$AdditionalName as PartNo FROM StockItem StockItem Export Name and PartNo of all StockItems from Tally to Excel
SELECT $Name,$$Alias FROM StockItem StockItem Export Name and Alias of all StockItems from Tally to Excel

Merge two Ledgers

This feature allows you to merge vouchers of two Ledgers in Tally ERP 9. After merging, all vouchers of the "Source Ledger" will appear under the "Destination Ledger" and the Source-ledger will be deleted.

Before you use this feature, you must configure the TDL file as shown below:

Steps to configure the TDL

  1. Start Tally and open a Company
  2. Press F12 [Configuration]
  3. Select option "Product and Features"
  4. Press F4 [Manage local TDL]
  5. Specify the file c:\udiMagicFreeEditionV20\udiMagic.txt in the List of TDLs to preload

If the TDL is configured correctly, then you will be able to see udi-Magic FE in the Gateway of Tally.

How to Merge ledgers in Tally?

  1. Start udi-Magic Free Edition
  2. Select option "Merge two ledgers"
  3. Click the Populate button
  4. Select the Source Ledger
  5. Select the Destination Ledger
  6. Click the Merge button

If you get error "No vouchers found" while merging, kindly recheck the TDL configuration steps.

}