Multi-Currency in Tally ERP

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

Cess based on Quantity, GST entries in Tally ERP

Cess based on Quantity - Tally ERP

Under the GST regime, some products attract "Additional Cess" based on quantity (in addition to Cess based on value). This feature "Cess based on qty" is now supported by udiMagic Software. 

Excel Template Name : Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls

Location : C:\udiMagicDemo

Kindly note that the "Cess based on Quantity" has to be specified in the column RATE/per unit in the aforesaid excel template. 

udiMagic Demo download link:

udiMagic Excel to Tally Software - Free to try

INTRODUCING UDIMAGIC V10.0

We are pleased to announce the launch of udiMagic v10 

The details are as under :-

Backward compatibility for Old Templates

With udiMagic v10 onwards, the old-templates (i.e. excel templates  of v9.0 r2.3 or higher) are  included in a folder named "old-templates" within the folder where the udiMagic software is installed. 

Here's what is means. 

In udiMagic v10, if you use an old template (i.e. v9. r2.3 or higher), the XML file for that template will be selected automatically by the udiMagic software. Prior to this, if you used a template of  older version, you had to manually select the XML file for that template to upload data into Tally.

Bulk record processing for UNDO entries

UNDO entries is a feature which allows the user to remove / delete the entries which were previously imported into Tally using udiMagic. By default, when you use the option UNDO entries, the records are processed one-by-one and are removed / deleted from Tally. 

A new option "Bulk upload / record processing for UNDO entries" has been now included in udiMagic Settings. When this option is ticked / enabled, the records are processed in Bulk. By default, this option is disabled.

Templates Modifications

1. Vouchers-V10-Receipts-and-Payments-with-multiple-references.xls
The DATE (Column B) has been shifted after the VCHNO column.

Import ICICI Bank statement from Excel to Tally

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

1. Start Tally and open a Company
2. Start udiMagic
3. Select option "Excel to Tally"
4. Select option "Import data into Tally"
5. Click the Browse button and select the Excel file "Vouchers-Bank-Statement-ICICI-Current.xls"
6. Select the XML file "Vouchers-Bank-Statement-ICICI-Current-XML-tags.xml"
7. 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. 

udiMagic v9.0 Release 2.3

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 2.3

NEW TEMPLATEs

1. Vouchers-Bank-statement-Single-Column-Dr-Cr.xls

This template is similar to the existing template Vouchers-Bank-statement.xls. The difference is that is contains only 1 column for Debit and Credit amounts.

2. Master-GSTClassifications.xls

This template allows you to create new GST Classifications in Tally ERP 9. To use the GST Classifications, you must first enable the GST feature and GST Classifications in Tally.

TEMPLATEs (Modifications)

1. Vouchers-Bank-statement.xls

Fixes: In some Bank statements, the amount greater than 1,00,000 has commas. This creates problem if you are using Excel 2007 or lower as the amount with commas is not converted to numeric value. In udiMagic v9.0 R2.3, we have this issue has been addressed and now even amounts with commas can be imported from Excel to Tally.

2. Vouchers-V9-Sales-Purchase-Basic.xls

Fixes: Discount ledger gets created even though the discount is not specified. This has now been resolved.

3. Vouchers-V9-Sales-Purchase.xls

Fixes: Discount ledger gets created even though the discount is not specified. This has now been resolved.

udiMagic v9.0 Release 2.2

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 2.2

Fixes:
While importing data from Excel to Tally using udiMagic, if there is an invalid XML character in the Excel sheet, the whole batch / bunch of records is not uploaded into Tally. Also, udiMagic does not display any error message. This has now been rectified in udiMagic v9.0 r2.2 and an error message "Unable to to XML tags" is displayed if an invalid XML character is found in the Excel sheet. The xml details are written to "parse.err" file.

udiMagic v9.0 Release 2.1

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 2.1

TEMPLATEs (Modifications)

1. Vouchers-V9-Sales-Purchase.xls

Fixes:
The Round Off ledger amount is not displayed correctly in the Voucher modification screen in following cases:
a. Purchase with Items + Voucher Mode
b. Purchase without Items + Voucher Mode

2. Vouchers-V9-Sales-Purchase-Basic.xls

Fixes:
The Round Off ledger amount is not displayed correctly in the Voucher modification screen in following cases:
a. Purchase with Items + Voucher Mode
b. Purchase without Items + Voucher Mode

3. Vouchers-Stock-Journal.xls

This format now supports Material IN and Material OUT vouchers also. A new column to specify the Party Ledger Name has been added in this template.