udiMagic Release Notes

You can now import your SHARES purchase and sale transactions from your online-trading portal a/c into Tally Accounting Software using UDIMagic .

Here's a sample Excel file that contains Sales Vouchers with Stock-Items and VAT . Steps:- 1) Download the Excel file Sales Vouchers with Stock-Items and VAT 2) Copy it into "c:\udi-Magic" folder. 3) Run the udi-Magic utility and import data from this file into Tally.

FAQs: Tally data from Tally to MS-Excel using udi-Magic I have downloaded udi-Magic and used the option "Tally to Excel" to pull Ledger master data. i.e. Name and Closingbalance. When I view the same in MS-Excel and add totals to it, there is difference in Debit, Credit Totals. What could be the reason ? My Trial balance totals match and their is no such difference. The SQL-SELECT statement used is :- SELECT $name,$closingbalance FROM ledger When you pull data using the above SELECT-statement, Tally returns all Ledgers and their closing balances. This may include :- a) "Profit & Loss a/c" b) "Gain/loss on Forex transactions" Remarks :- Point 1 Excel sheet data will show "Profit & Loss a/c" figure and/or "Gain/loss on Forex transactions". Trial Balance in Tally will not show the "Profit & Loss" figure and/or "Gain/Loss on Forex transactions". Point 2 This is not a bug with udi-Magic. When we fetch data fro...

Here's a sample Excel file that contains Sales Vouchers with VAT and other Taxes . Steps:- 1) Download the Excel file Sales Vouchers with VAT and other Taxes 2) Copy it into "c:\udi-Magic" folder. 3) Run the udi-Magic utility and import data from this file into Tally.

The new Release 1.07 uses advanced techniques to process Master/Voucher records more efficiently and thereby reducing the processing time.

FAQs: Transfer data from MS-Excel to Tally using udi-Magic I have an Excel file with a different data-format. This type of data is not there in the sample Excel sheets provided with along udi-Magic. Can I import this into Tally using udi-Magic ? Yes. There can be hundreds of formats. For evaluation purpose, few sample Excel sheets have been provided that include both Vouchers and Masters. UDI-Magic supports all data that you can manually enter in Tally software for any type of Voucher or Master . The only thing you need to do is to tell what data you have in your Excel sheet and where is it stored in the Excel sheet. This is done using XML tags which are to be written in the comments section of cell A1 (or any cell in 1st row). I do not know XML. Can I still use udi-Magic ? Yes. Full support is provided to Registered users for writing XML tags. Alternatively, just provide us the Excel-sheet which contains your data and we shall do the rest. (Support services available to Register...

New features in Release 1.06 - Negative Stock (Customized) Report Negative Stock Report udi-Magic v2.0 Release 1.06 incorporates a new feature called "Tally Reports". Right now, only one Report (i.e. Negative Stock) is available under this option. First, let us have a look at the Tally software Negative Stock report. Negative Stock Report in Tally Software You can access the Negative Stock Report in Tally using the following option:- "Gateway of Tally -> Display -> Exception Reports -Negative Stock" The Negative Stock report in Tally list all Stock-items having Negative stock. However, the limitation with this report is that it lists only those Stock-items which have negative balance on the last date. Assuming you have specified the period as 1-4-2007 to 31-3-2008, the Report displays Stock-items which have negative balance on 31-3-2008. In case, if any stock-item has a negative balance during the year but has positive balance on 31-3-2008, it will not be lis...

There is some technical problem since yesterday afternoon with the Indiatimes Mail-server. As our site is hosted by Indiatimes, emails sent to our email accounts may have been returned . You can alternatively send emails to our Yahoo or Gmail accounts as given below:- shwetarajkot @ yahoo. co. in (remove spaces) shwetarajkot @ gmail. com (remove spaces)

Here are some SQL-SELECT statements to retrieve data from Tally Software using udi-Magic. a) Retrieve Voucher details in a specified format b) Retrieve Voucher details with Ledger and Stock-item details More on how to pull data from Tally Software

FAQs: Transfer data from MS-Excel to Tally using UDI-Magic Can I use Multiple locations in Stock Item master and transfer it to Tally using udi-Magic ? Yes. udi-Magic v2.0 Release 1.05 supports Multiple Locations. Download the sample Excel file "Masters - StockItemMaster with Multiple Locations.xls"

FAQs: Transfer data from MS-Excel to Tally using UDI-Magic Can I use Voucher data with UDFs and transfer it from MS-Excel to Tally ? Yes. UDI-Magic v2.0 Release 1.05 supports UDF's. To try-out Importing Vouchers with UDF's into Tally, you need to have the following:- a) udi-Magic v2.0 Release 1.05 b) TDL24 (TDL code for Salesman UDF) c) Vouchers - Sales Transactions with Salesman UDF.xls (Excel sheet) Step 1 Download the TDL24 program. This TDL code creates a new field SALESNAME which appears in the Sales Voucher entry screen. Step 2 To use the above TDL, you need to make changes in your Tally.ini file and specify the TDL24 file as given below:- User TDL = YES TDL = C:\tally\tdl24.txt Step 3 Download and Install the udi-Magic software Step 4 Download the Excel sheet "Vouchers - Sales Transctions with Salesman UDF.xls" and copy it to C:\udi-Magic folder Step 5 Run the udi-Magic software and import Voucher data. For any clarifications, write to sales @ rtslink...

FAQs: Transfer data from MS-Excel to Tally using UDIMagic Can I import Ledger Masters with Bill-by-bill details from Excel into Tally using udi-Magic ? Yes. You can use UDIMagic to Import Masters as well as Vouchers from Excel to Tally. Herein, we shall focus on how to import Ledger Master with Bill-by-bill details into Tally. Click here for details on how to Import data into Tally software .

FAQs: Transfer data from MS-Excel to Tally software using UDI-Magic Can we use Cost Centres and Cost Categories with udi-Magic ? Yes. You can use any feature that is supported by Tally like Cost Centres; Cost Categories; Multiple Currencies; Multiple Godowns etc. Using Cost Centres and Cost Categories with udi-Magic Using udiMagic software, you can transfer Vouchers from MS-Excel to Tally Software. Herein, we shall focus on Sales Vouchers having Cost Centres and Cost Categories. Click here for details on how Import Sales Vouchers into Tally Accounting Software .

Understanding XML tags used in "Masters - StockItemMaster.xls" udi-Magic v2.0 uses XML tags to identify and read data from the Excel sheet for both Masters and Vouchers. Let take up the sample Excel-sheet "Masters - StockItemMaster.xls" provided with udi-Magic v2.0 to understand the XML tags used therein. Click here for more details on how to Import Masters into Tally Software

Release 1.04 supports the following new features:- - Transfer of data from Tally to Excel using SQL-SELECT statements - Push or pull Tally data from a Remote Computer - Use of XML tags to identify Masters data in MS-Excel Transfer of data from Tally into Excel (Pull data from Tally Software into Excel) You can now easily get Tally data into MS-Excel using simple SQL-SELECT Statements like :- Select $Name, $ClosingBalance from LEDGER For more information of using SQL-SELECT statements, refer :- http://www.rtslink.com For more samples, visit http://www.rtslink.blogspot.com You can download the udi-Magic v2.0 Release 1.04 from www.rtslink.com/udimagic.htm Please see: Support for writing SQL-SELECT statements to fetch data from Tally Software available to Registered users of udi-Magic. Push or pull Tally data from a Remote Computer udi-Magic v2.0 Release 1.04 allows you to access Tally data from a Remote Computer located in a different city or country. a) You can pull (retrieve) Tally d...

FAQs: Transfer Excel data to Tally Software using udi-Magic Which XML tags are supported by udi-Magic ? udi-Magic v2.0 Release 1.03 supports all XML tags for Vouchers and Masters in Tally Software irrespective of its version. In simple words, you can use any XML tag for Vouchers and Masters that is supported by Tally 7.2 or Tally 9 or any higher version. Which XML tags are NOT supported by udi-Magic ? udi-Magic v2.0 Release 1.03 does NOT support XML tags for Company object. In other words, you cannot use XML tags to change Company features that are done using F11 key in Tally. Though this is not supported at present, it shall be incorporated in future versions of udi-Magic. Which are the Top-level XML tags supported by Tally ? Tally supports the following Top-level XML tags:- 1) VOUCHER object <VOUCHER REMOTEID="............"> ..........tags.......... ..........tags.......... </VOUCHER> 2) MASTER objects <LEDGER NAME="......."> ..........tags......

FAQs: Transfer Excel data to Tally Software using UDI-Magic Can I have hidden Rows and Columns in Excel sheet which contains data that I want to transfer to Tally ? Hidden Rows UDI-Magic v2.0 Release 1.03 does not support hidden Rows. Hence, you must not have hidden Rows in your Excel sheet. Hidden Columns You can however, have hidden Columns in your Excel sheet. The hidden Columns are skipped by udi-Magic utility.

FAQs : Transfer Excel data to Tally Software using udi-Magic How do I insert / view Comments in Excel sheet ? Right-click on any Cell and select "Insert Comments" or "Edit Comments".

FAQs: Transfer of Voucher data from Excel to Tally using udi-Magic v2.0 The sample Excel sheets provided with udi-Magic v2.0 (for Vouchers) contains a Column titled as ID. What is this ID and why is it required ? To identify records in any Database, a key field (also known as primary key-field) is required. This key-field contains unique values. Tally Software uses a key-field (i.e. GUID) to uniquely identify the Voucher Transactions. In short, to transfer Vouchers from Excel to Tally using udi-Magic, your Excel sheet must have a key-field . How to specify the key-field in Excel sheet ? This can be done in two ways:- 1) Specify the Column-heading as ID Remarks:- Refer the sample Excel sheet "Vouchers - Financial Transactions" provided withe udi-Magic v2.0. Note that this Excel sheet contains a Column titled as ID . 2) If you want to have a different Column-heading, then you need to use XML tags as given below:- <COLUMNNAME.LIST> <COLUMNNAME>ID</COLUMNNAME...

udi-Magic is utility software that allows you to Import Excel data into Tally Accounting Software. It works with Tally 6.3 and higher versions. Features - Supports transfer of Voucher data and Master's data from Excel to Tally Software. - Supports all Voucher-types including User-defined Vouchers-types. - Supports all Tally XML tags for all Vouchers-type and all Masters-types. - udi-Magic is designed to be simple and scalable. - udi-Magic comes with a Wizard-interface and is easy to use. For more information, please refer https://udimagic.in