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.