Friday, January 11, 2019

Multi-Currency Excel templates

Import FOREX entries in Tally

Using the Excel templates provided with udiMagic v10 Release 1.2, you can now upload Sales and  Purchase entries with Inventory and Multi-Currency into Tally ERP 9.

In these latest Excel templates, two additional columns have been provided for CURRENCY and ROE (Rate of Exchange). If you specify the Currency and ROE, the entries are automatically reflected in FOREX currency in Tally ERP 9. If you keep these columns blank, then the entries are uploaded in Tally in base currency.

The multi-currency feature is now supported in the following Excel templates :

Sales, Purchase, Debit Note, Credit Note entries with Multi-currency

Vouchers-V10-Sales-Purchase-With-Stockitems-Basic.xls
Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls

For Receipt, Payment, Journal, Contra entries with Multi-currency

Vouchers-V10-Financial-Transactions-Basic.xls
Vouchers-V10-Financial-Transactions-Advanced.xls

No comments: