Import your SHARES purchase and sale transactions into Tally Software

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

Sales Vouchers with Stock-Items and VAT

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.

Using SQL-Select to fetch Ledger Master Closing balances

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 from Tally, using the SELECT statement, Tally returns all ledgers with closing balances. This includes "Profit/Loss a/c" also.

Whereas Trial balance does not display the "Profit/Loss a/c figure".

If you have seen the TDL of Trial balance, you can know that there are several conditions and one of those filters Profit & Loss a/c. You can compare all the balances in your Excel sheet with that in Tally. Only, the Profit/Loss or Gain/Loss will be not there in Tally TB.

If you use RTSlink DLL, even in that case you shall get the same result i.e. Ledgers which include "Profit/Loss account".

Sales Vouchers with VAT and other Taxes

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.

udi-Magic v2.0 Release 1.07

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

Features supported by udi-Magic

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 Registered users i.e. those who have purchased and registered udi-Magic).

For Evaluation purpose we have provided sample Excel sheets. We shall come out with more sample sheets from time-to-time.

udi-Magic v2.0 Release 1.06

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 listed in this Report.

Negative Stock Report in udi-Magic

This report displays all Stock-items which have negative balance on any date during the specified period. This report can be viewed in MS-Excel also.

Problem with Indiatimes Mail-Server

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)

SQL-SELECT statements to pull Tally data

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

StockItem Master with Multiple Locations

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"

Sales Vouchers with Salesman UDF

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 . com (remove spaces)

Ledger Master with Bill-by-Bill details

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.

Sales Vouchers with Cost Centres and Cost Categories

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.

Import MASTERS from Excel to Tally

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

udi-Magic v2.0 Release 1.04

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 data from a Remote Computer

b) You can push (write) Excel data to Tally wherein the Tally Software is running on a Remote Computer.

All you need to do is specify the IP address of the Remote Computer and some Firewalls settings in the Remote Computer.

Please See:
Support to Access Tally data on Remote Computer is available to Registered users only.

Use of XML tags to identify Masters data in Excel

To begin with, let's have a look at how udi-Magic has evolved till now.

- In udi-Magic v1.0, Column-Headings were used to identify the Excel-sheet data.
- In udi-Magic v2.0 Release 1.03, a new concept to read Excel data using XML tags was introduced. However, this was restricted to Vouchers only.
- In udi-Magic v2.0 Release 1.04, XML tags are used to identify Masters as well as Voucher data in Excel-sheet.

XML tags supported by udi-Magic v2.0

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..........
..........tags..........
</LEDGER>

or

<GROUP NAME=".......">
..........tags..........
..........tags..........
</GROUP>

etc.

3) COMPANY object

<COMPANY NAME=".......">
..........tags..........
..........tags..........
</COMPANY>


Which are the Top-level XML tags supported by udi-Magic ?

udi-Magic supports the following Top-level XML tags:-

1) VOUCHER object

<VOUCHER>
...Any Tally supported tags for Voucher Object ......
</VOUCHER>

2) MASTER objects

<MASTER TYPE="LEDGER">
...Any Tally supported tags for Ledger-Master Object ......
</MASTER>

or

<MASTER TYPE="GROUP">
...Any Tally supported tags for Group-Master object ......
</MASTER>

Remarks:-
There are several Masters in Tally. Herein, we have taken up only two Masters (Group and Ledger) for illustration.

Hidden Rows / Columns in Excel sheet

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.

Comments in Excel Sheet

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".

ID or Key-field for Vouchers

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>
</COLUMNNAME.LIST>

Remarks:-
- The above XML tags are to be written in the Comments section of the Cell which contains the Column-heading.
- Refer the sample Excel sheet "Vouchers - Sales Transaction with StockItems" provided with udi-Magic v2.0. Note that the field INV-NO contains XML tags in the Comments section which specify that INV-NO is the key-field.

Can I use alpha-numeric values for the ID field ?

Yes. You can use Alpha-numeric or Numeric values for the ID field. The only thing you need to take care is that it must be unique and must be of eight characters, otherwise udi-Magic trims or pads it with 0's.

Introduction to udi-Magic

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 www.rtslink.com/udimagic.htm