udiMagic Release Notes

Simple Excel Template Often people ask: "I need a simple excel template to import sales data in Tally. Which one should I use?" udiMagic comes with several predefined Standard Excel templates. For Sales and Purchase excel formats, two different versions are provided viz BASIC and ADVANCED (with advanced features). To begin with, start with the BASIC template. If you requirements are NOT fulfilled with the BASIC template, then go for the ADVANCED template.  CHOOSE What You Want Alternatively, you can Create A New Template by selecting the fields / columns that you want from an existing template. This can be done using the udiMagic Online Template Builder here:  https://www.rtslink.com/excel-to-tally-templates/ Read more on udiMagic at: https://www.rtslink.com   If you face any problems, post your comments in the comments box below.

Decimal Places in Tally ERP Change Decimal Places In Amount - udiMagic Settings By default, the udiMagic Software supports two "Decimals Places in Amount". In simple words, w hen we import data from Excel to Tally ERP, the amount is rounded off to 2 decimals. However, in some countries (like Oman), the transactions are generally recorded with 3 decimals in amount. In this latest release, a new option has been included in the udiMagic Settings which allows you to set / change the "Decimal Places in Amount" as shown below: In addition, ensure that you specify the correct decimal places  in the Excel sheet wherever the ROUND() function is used. NOTE: In certain excel templates provided with udiMagic Software, the ROUND() function is used. You must change the ROUND() to specify the decimal places as per your requirement.

Multi-currency Import Excel to Tally Recording multi-currency vouchers in Tally ERP can be a difficult task, unless you are an experienced Tally user. udiMagic v10 The excel templates provided with udiMagic software, help you import vouchers with multi-currency in Tally ERP, quickly and easily. You need to specify the Currency, Forex Amount, Rate of Exchange for recording payment, receipt and other entries. You can also import Base-currency vouchers by keeping these columns blank viz. Currency, Forex Amount, ROE. Supports all financial vouchers like Payment, Receipt, Journal, Contra, Sales and Purchase without inventory. Forex and Base Currency To import vouchers with Forex, specify the "Currency, Forex Amount, ROE". To import vouchers in Base currency, keep the "Currency, Forex Amount and ROE" columns blank. Download Multi-Currency Excel templates