udiMagic Release Notes

udiMagic v12 r7.4 A warning message is displayed when udiMagic connects to Tally that was started by another user. udiMagic v12 r7.3 1. Added COMPANYNAME field in: Vouchers-v12-Sales-Purchase-without-Stockitems-Basic.xls Vouchers-v12-Sales-Purchase-without-Stockitems-Advanced/xls Vouchers-Receipts-and-Payment-with-multiple-references/xls 2. Added support for multiple GSTINs in: Vouchers-Financial-transactions-Advanced.xls Fixes: If the Unqiue-ID contains \ (backslash), an error is thrown. This has been now fixed.

You can now directly import the ICICI [Current account] Bank Statement into Tally ERP using udiMagic Excel to Tally converter. Download the Bank Statement Excel to Tally templates .  Import ICICI Bank Statement from Excel to Tally Start Tally and open a Company Start udiMagic Select option "Excel to Tally" Select option "Import data into Tally" Click the Browse button and select the Excel file "Vouchers-Bank-Statement-ICICI-Current.xls" Select the XML file "Vouchers-Bank-Statement-ICICI-Current-XML-tags.xml" Click the Start button To view the data imported in Tally, use the option "Gateway of Tally | Display | Daybook" If you do NOT have udiMagic Software installed in your computer, you must first download the udiMagic DEMO / Trial version . 

How to map your excel file and import it into Tally ERP 9? Here's a video on how to  map excel file and import it in Tally ERP 9 For reference, the steps are given underneath : Steps to Map your Excel file Start udi-Magic converter Select the option Excel to Tally > Create a Custom template Select the files : udi-Magic Standard Excel template Your Excel file Map the columns Save the Mapping file Steps to Import data into Tally Start Tally ERP 9 and Open a Company. Start udi-Magic software. Select the option Excel to Tally > Import data into Tally. Select the files Your Excel file Xml file (Mapping file generated in the mapping process) Click the Start button.

Excel to Tally templates - Modifications Applicable to : udi-Magic v8.0 Release 2.3 The following new features have been added in the Vouchers-V8-Sales-Purchase-Basic.xls template. Auto Rounding-Off This feature allows automatic "Rounding off" to the nearest rupee. The default value is Yes. Common Ledgers for IGST; CGST; SGST The GST tax ledgers are now created without the tax-rates in Ledger Master. This allows you to have one common GST Tax ledger instead of multiple GST Tax ledgers in Invoice. You can download ( all latest templates for udi-Magic v8.0 ) the zip file from this link : https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip

Preface Some UDIMagic Standard Excel templates like " Voucher-Financial-transactions.xls " support import of all Voucher-types from Excel to Tally. However, when "Bank Payment" or "Bank Receipt" vouchers were uploaded, though these vouchers were successfully imported, they were not reflected in the Bank Reconciliation in Tally. Hence, UDIMagic users had to use other formats specifically designed for Bank Payment and Receipts. UDIMagic v6.0 Release 2.7 (New Feature : Pre-Fetch Tally data) The above has been taken care of in latest release.  The new templates are re-named as "Vouchers-V6-xxxxxxx". Example: Old Name : Vouchers-Financial-transactions.xls New Name : Voucher-V6-Finanical-transactions.xls Old Name : Vouchers-Financial-transactions-single-line-entry.xls New Name : Vouchers-V6-Financial-transactions-single-line-entry.xls Old Name : Vouchers-Financial-transactions-single-line-entry-with-multiple-dr-cr.xls New Name : Vouchers...

FAQs I am having X records (say 10,000 records) in my Excel Sheet. I am using the licensed version of UDI Magic. However, UDI Magic processes only few records (say 100 records). What could be the reason ? It is likely that your Excel Sheet has a BLANK-ROW or HIDDEN-ROW at or near the ROW-number 100 in the Excel Sheet. Remove that and try again. It should work. PS: 1) UDI Magic stops processing if it finds a BLANK-ROW or a HIDDEN-ROW. 2) If you are using DEMO version of UDI Magic, then only 5 or 10 records (Vouchers and Masters resp.) shall be processed.

UDIMagic || Excel to Tally This is in continuation of my previous post wherein we had provided a sample Excel sheet with Receipt Vouchers. Herein, a sample Excel-sheet containing multiple user-defined Receipt Vouchers is being provided. Follow these steps to import data from this Excel-sheet into Tally Software. 1) Download the Excel sheet and copy it to "c:\udi-magic" folder. 2) Start the Tally software and create/open a Dummy Company. 3) Minimize Tally Software 4) Run UDIMagic utility, select option "Excel to Tally -> Voucher". Next, select the Excel sheet when prompted. 5) Next, follow the instructions given in the UDIMagic wizard-screen to import data into Tally. Remarks:- The XML tags are written in cell A1 (comments section) of the Excel sheet. Alternatively, we can write the XML tags in a separate file also.

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 .

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