Excel to Tally FREE DOWNLOADS

What is Multi Currency (TallyERP9)?

Answer:

Many organizations have transactions in more than one currency. Such transactions have to be recorded either in the base (home) currency or in the foreign currency. If the transactions are recorded in home currency, the rate at which the foreign currency is exchanged should be recorded as well. At times you need to record the transaction in the foreign currency itself when you maintain the balance of the concerned account in foreign currency.

Users can define unlimited currencies (US dollars USD/$ , Singapore dollars SGD | Indian Rupee Rs / ₹ , €/EUR, AED etc.), specify whether to view the currencies either in Lakhs or Millions and use multi-currency concurrently. For example, your company’s balance sheet in India can be viewed by your business partner in Japan in Yen.

How to enable multi currency in TallyERP9?

Answer:

A] Enable Multi-Currency feature in Tally.ERP 9.

Go to Gateway of Tally
Select F11: Accounting Features
Set Allow Multi-Currency to “Yes”
Accept to Save.

B] Creating Currencies

Tally.ERP 9 allows creating unlimited currencies

each with their own specified symbol. To do this:

Go to Gateway of Tally > Accounts Info> Currencies > Create
Enter the required details as shown
below:
Setting ‘No’ to ‘Show Amounts in
Millions’ will display the currency in
Lakhs.
Accept the screen.

3) How to book Sales, Purchase, Receipt, Payment and etc. with Multi Currency from excel to TallyERP9?

Introduction : EazyAUTO4 is a software developed by “Impression Systems and Software Pvt. Ltd.”. It can help to book your voucher entries, ledger accounts, price lists etc. in minimal efforts. Just copy and paste or MAP your data to our standard templates and that’s all. This utility helps user to import data from Excel to tally in various format. You can say it is Excel to Tally converter utility which eliminates your repetitive work and posts financial data to Tally more effectively and easily. There is also an option to Export data from Tally to Excel. We provide standard Excel Templates to import data from Excel to Tally. Know-more...

Using “EazyAUTO4” Excel to Tally Data Converter, book excel’s data into tally like Sales, Purchase, Receipt, Payment and etc with multi currency.

As you can see below in image you should have to provide details of Multi Currency like “Foreign Currency, Forex Amount (Optional), Rate of Exchange and Base Currency”. After all required field filled Click on “Generate Entries” and go thru the process.