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