HomeTallyPrimeAccountingMulti-Currency Accounting

 

Explore Categories

 

 PDF

Multi-Currency Accounting in TallyPrime

In your business, when you need to do transactions in more than one currency, you can create multiple currencies in TallyPrime. You will need to use foreign currencies in your transactions based on the currency in which your customers want the invoice, the geographical location in which the transaction is carried out, or other such reasons. In TallyPrime, you can define the base currency at the time of Company creation. Base currency is the primary currency used in all the transactions, unless you create other currencies and use those in the transactions, based on your business needMulti-currency in TallyPrime enables you to record vouchers in a foreign currency and view reports in a specific currency as needed. 

Moreover, you can define exchange rates for a specific currency with respect to the base currency, and you can also calculate forex gain or loss.

You can also provide opening balance for ledger accounts in any currency created in TallyPrime. 

You can change the base currency and alter or delete other currencies created in TallyPrime, as per your requirement. 

Transactions in Foreign Currency

Based on the currency in which your customer requires invoices, international trading, or other reasons, you may need to record transactions in a foreign currency in TallyPrime. You can create foreign currency in TallyPrime, using which you can record transactions, define forex rates, and calculate forex gain or loss, as needed.

Create Currency 

Like any other master, you can create a currency master in TallyPrime and use it while recording transactions and also view reports. 

  1. Press Alt+G (Go To) > Alter Master > Currency > and press Enter.
    Alternatively, Gateway of Tally > Create > Currency > and press Enter.
    The Currency Creation screen appears.
    Note: When only the base currency is available, you will be prompted to create a new currency or alter the existing currency. 
    Select Create or press C to create a new currency.
  2. Specify the currency details.
    1. Symbol: enter the currency symbol.
      This symbol appears in your transactions.
    2. Formal name: enter the name of the currency accepted globally. 
      For example, enter US Dollars to distinguish different currencies having the same symbol.
      If you have two companies (ABC & XYZ) in TallyPrime, then you can set different currencies for ABC and XYZ companies. ABC uses symbol $ for Australian Dollars and XYZ uses the symbol $ for U.S. Dollars. The formal name distinguishes two different currencies with the same symbol, which helps when you compare the books of accounts for both the companies. The company that is loaded first retains the original symbol for display purposes. The other company’s currency symbol will be prefixed with the first letter/first few letters (to make it unique) of the formal name. Here, if ABC is loaded first then the symbol $ is for Australian Dollars and in XYZ (loaded next) the symbol $ is prefixed with the letter U (first letter of its formal name).
      Note: You cannot assign a duplicate Formal name for a currency.
  3. Number of decimal places: enter the number of decimal places, based on the practice you follow in your business. 
  4. Set the option Show amounts in millions, as needed.
  5. Suffix symbol to amountYes
    This ensures that the symbol appears after the amount.
  6. Add space between amount and symbolYes.
  7. Specify details for the word representing amount after decimal.
    1. Enter the Word representing amount after decimal, for example, Paise.
    2. Enter the No. of decimal places for amounts in words.
      This number should be equal to or lesser than the number specified in Number of decimal places field.
      Create Currency in TallyPrime
  8. Press Ctrl+A to save.

Define forex rate

In TallyPrime, you need to define forex rate for a particular currency based on the rate of exchange on a specific date. You can also define forex rates for multiple dates based on the variation in the rate of exchange. It enables you to calculate forex gain or loss for transactions in which the sales order/purchase order and sales invoice/payment voucher are recorded at different points in time. TallyPrime also gives you flexibility to change the rate of exchange while recording a transaction. 

From the Currency Alteration screen, follow the steps given below.

  1. Date: enter the data at which the rate of exchange is applicable.
  2. Std Rate: standard rate (optional), which is used to calculate variances from the actual transaction rates.
  3. Provide the details of forex rates.
    1. Specify Standard rate.
      1. Date: enter the standard rate of exchange at which the currency will be exchanged with base currency.
      2. Specified rate: enter the standard rate.
    2. Specify Selling rate.
      1. Date: enter the date of sales.
      2. Selling Rate: your selling rate.
    3. Specify Buying rate.
      1. Date: enter the date of purchase.
      2. Specified Rate: your buying rate.
        A sample Currency Alteration screen with the defined rates of exchange appears as shown below.
        Altering Currency to Define Forex Rates in TallyPrime
  4. Press Ctrl+A to save, as always.
Note: For currencies that have been used in transactions, the Last Voucher Rate appears for reference. Moreover, you can specify rates for multiple dates, as needed. 

Define forex rates of multiple Currencies (multi-alter)

There may be more than one currencies in TallyPrime for which you want to define forex rates. You can do so using Chart of Accounts.

  1. Press Alt+G (Go To) > type or select Chart of Accounts and press Enter > type or select Currencies and press Enter.
    Alternatively, Gateway of Tally > Chart of Accounts > type or select Currencies and press Enter.
    Chart of Accounts with List of Currencies appears.
  2. Press Alt+H (Multi-Alter) > Rate of Exchange and press Enter.
  3. Provide the details of forex rates.
    1. Std Rate: enter the standard rate of exchange.
    2. Selling Rate: enter the rate used while selling.
    3. Buying Rate: enter the rate used while creating buying.
      Define Rate of Exchange for a Foreign Currency - Multi-Currency Accounting in TallyPrime

Record transactions

Once you create the currency in TallyPrime, you can record transaction using the same. In the transaction, you can either retain the rate of exchange, if defined in the master, or can change, as needed.

Record sales invoice with multi-currency

You may be selling goods or services to a customer based in a country other than India. And the customer may need an invoice in the currency of that country. In cases wherein the base currency and the currency of the sales transaction are different, you will need to create sales invoice with the foreign currency.

  1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales).
    Alternatively, Gateway of Tally > Vouchers > F8 (Sales). 
  2. Select the Party A/c Name.
  3. Select the Name of Item, and enter the Quantity.
  4. Provide the foreign currency details.
    1. Enter the Rate of the item in the required foreign currency.
    2. Press Enter to view the Rate of Exchange screen, as shown below.
    3. Enter the latest Rate of Exchange.
    4. Press Ctrl+A to save.
      A sample sales invoice with the foreign currency appears as shown below.
      Sales Invoice with Foreign Currency in TallyPrime
  5. Press Ctrl+A to save, as in other transactions.

Record purchase voucher with multi-currency

You may be purchasing goods or services from a vendor based in a country other than India. And the vendor may be expecting payments to be made in that country’s currency. In cases wherein the base currency and the currency of the purchase transaction are different, you will need to create purchase voucher with the foreign currency.

  1. Press Alt+G (Go To) > Create Voucher > press F9 (Purchase).
    Alternatively, Gateway of Tally > Vouchers > F9 (Purchase). 
  2. Select the Party A/c Name.
  3. Select the Name of Item, and enter the Quantity.
  4. Provide the foreign currency details.
    1. Enter the Rate of the item in the foreign currency.
    2. Press Enter to view the Rate of Exchange screen, as shown below.
    3. Enter the latest Rate of Exchange.
    4. Press Ctrl+A to save.
      A sample purchase voucher with the foreign currency appears as shown below.
      Purchase Voucher with Foreign Currency in TallyPrime
  5. Press Ctrl+A to save, as in other transactions.

Print invoice with multi-currency

It may be possible that your customer needs a copy of invoice with foreign currency. You may also want to keep a copy of the invoice with foreign currency for your record. In TallyPrime, you can easily print an invoice with the currency used in the transaction.

From the Accounting Voucher Creation or Accounting Voucher Alteration screen, following the steps given below.

  1. Press Ctrl+P (Print) and press Enter on Current.
    The Print screen appears.
  2. Configure the print to include foreign currency.
    1. Press F12 (Configure) or press C.
      List of Configurations appears. 
    2. press Enter on Show Base & Foreign Currency for Total to enable it.
      Print Configuration for Multi-Currency Accounting in TallyPrime
    3. Press Ctrl+A to save the setting.
  3. Press I (Preview) to check the invoice before printing, if needed.
  4. Press P (Print) to print.

The print preview of the sales invoice appears as shown below.

Print with Foreign Currency in TallyPrime

The Total Invoice Amount appears in both the base currency and the foreign currency.

Forex gain or loss

The rate of exchange keeps fluctuating based on the economic changes across the globe. So, you may have sold a particular set of items or provided service at a certain rate of exchange on a date or time and received payment for the same on a different date or time. In such cases, the rate of exchange may not be necessarily the same at both the points in time. So, your business may experience forex gain or loss due to the fluctuation rate of exchange.

To understanding this, let us take an example.

Consider that your base currency in TallyPrime is INR and the other currency in which the transaction is carried out is USD.

Now, you sold a set of items on 11-May-2022 to a specific customer based in the U.S., and the total amount was $100. 

On 11-May-2022, the rate of exchange was INR 70 per USD, which makes the total amount INR 7000.

The customer makes the payment at a different time on 11-May-2022, 12-May-2022, or later, and the rate of exchange changes to INR 71 per USD.

The change in rate of exchange makes the final billing amount INR 7100. 

So, you made a forex gain of INR 100 on the transaction.

In TallyPrime, you can see such gains and losses as Unadjusted Forex Gain/Loss in Balance Sheet. As per accounting standard, you will need to record a transaction to account for such forex gains or losses. TallyPrime gives you easy way to record these transactions.

Create a ledger for forex gain or loss

To account for forex gain or loss, you need to create a ledger under Indirect Expenses or Indirect Income in TallyPrime. 

Subsequently, you can use the ledger in the voucher class using which you can account for forex gain or loss.

Create Journal Voucher Class

Once you create a ledger, you can create a Journal Voucher Class in TallyPrime with that pre-defined ledger. Thereafter, you can record your forex gain or loss using the voucher class.

You can create multiple Journal Voucher Class for multiple currencies, if needed. 

  1. Press Alt+G (Go To) > Alter Master > type or select Voucher Type> select Journal and press Enter.
  2. Specify a Voucher Class name.
    For example, Forex Gain Or Loss.
  3. Use Class for Forex Gain/Loss AdjustmentsYes.
  4. Select Forex gain or loss ledger, as shown below.
    Voucher Class to Account for Forex Gain or Loss
  5. As always, you can press Ctrl+A to save.

Record forex gain or loss using Journal Voucher Class

Once you create a Journal Voucher Class in TallyPrime, you can record forex gain or loss.

  1. Press Alt+G (Go To) > type or select Create Voucher > press F7 (Journal).
    Alternatively, Gateway of Tally > Vouchers > press F7 (Journal). 
  2. Select the Voucher Class created for forex gain or loss.
    TallyPrime will display all the ledgers created to account for forex gain or loss.
    Forex Gain or Loss Using Voucher Class in TallyPrime
  3. Select the required ledger and enter the amount.
    Journal Voucher to Account for Forex Gain or Loss
  4. Press Ctrl+A to save.

The adjusted amount will not be displayed in the Balance sheet as it gets transferred to Profit and Loss Account.

Note: If the currency of the ledger and the base currency are same, then the bill-wise details will appear only for those masters while adjusting the Forex Gain or Loss.

View Reports in Foreign Currency

Your business may be based out of a specific country, but it may be a franchise of a multi-national company. In such cases, if you want to share your financial statements with the finance department of your company, then you will need to share it in the currency that the multi-national company uses.

You can view reports in base currency and any other currency created in TallyPrime.

After opening the report, follow the steps given below.

  1. Press Alt+A (Alter Column).
  2. Currency: select the currency in which you want to view the report.
    A sample Trial Balance report in the selected currency appears as shown below.
    Viewing Report in Foreign Currency in TallyPrime

View reports in multiple currencies

You can view reports in multiple currencies on a single screen, making it all the easier for you to share with different branches based out of different locations.

After opening the report, follow the steps given below.

  1. Press Alt+C (New Column).
  2. Currency: select a currency.
  3. Repeat the above steps for all the currencies in which you want to view the report.

A sample Trial Balance report in the selected currencies appears as shown below.

Viewing Report in Multiple Currencies in TallyPrime

Alter or Delete Currencies and Provide Ledger Opening Balance in Any Currency

In TallyPrime, you may want to change the base currency, based on the frequency of use in transactions. You may want to alter or delete currencies created in TallyPrime. Furthermore, you may also want to provide ledger opening balance in a specific currency based on the location of the party for who the ledger is created.

Change Base Currency

TallyPrime chooses the base currency based on the country selected during company creation. For example, if you select the country as India, TallyPrime chooses INR as your base currency. And if you select USA as the country, then TallyPrime chooses $ as the Base Currency. However, you may want to change the same for your company.

For instance, your base currency may be INR, but you may want to change it to USD or any other based on the frequency of usage it the transactions. 

For example, you may have customers only in the U.S. who need invoices in USD. So, in such a case, you can change your base currency. 

You can change the base currency in TallyPrime at any point in time.

In the Company Creation or Company Alteration screen, follow the steps given below.

  1. Base Currency symbol: enter the symbol of the currency.
    For Rupees, it is .
  2. Forman name: enter the Formal name that is used globally for the currency.
    For Rupees, it is INR
  3. Configure how the amount will be displayed with the currency in transactions and reports, if needed.
    1. Press F12 (Configure) > Provide Additional Base currency detailsYes and press Ctrl+A to save.
    2. Suffix symbol to amountYes, if needed.
      This will ensure that the symbol is added after the amount; for example, 200 .
    3. Add space between amount and symbolYes or No, as needed.
      A sample Company Alteration screen with the currency appears as shown below.
      Selecting the Base Currency for a Company in TallyPrime
  4. Press Ctrl+A to save the changes, as always.
Note: Once you change the base currency in TallyPrime, you will need to define the rate of exchange for other currencies with respect to the new base currency. 

Provide ledger Opening Balance in a foreign currency

For customers who deal in a currency other than your base currency, you may want to provide the Opening Balance in their currency.

In the ledgers created for such customers, you have a flexibility to provide Opening Balance in a currency used in the transactions with them. 

In the Ledger Creation or Ledger Alteration screen, follow the steps given below.

  1. Place the cursor on the Opening Balance field and press Enter.
    The Bill-wise Breakup screen appears.
  2. Provide the bill-wise details, as applicable.
    1. Enter the bill-wise amounts with the foreign exchange rates as shown below.
      Providing Opening Balance in Foreign Currency for a Ledger Account in TallyPrime Using Bill-wise Breakup screen
    2. Press Ctrl+A to save the Bill-wise Breakup screen.
  3. Press Ctrl+A to save the ledger.

Alter Currency

For a currency created in TallyPrime, you may have provided a SymbolFormal Name, or ISO Currency Code that is different than that used in the market. 

You may also want to change the Number of decimal places, as per the system followed in your business.

In such cases, you can alter currency in TallyPrime. 

In the Currency Alteration screen, follow the steps given below.

  1. Date: the date at which the Specified Rate is applicable.
    For example, the base currency is INR and the rate of $1 is INR 76.25 from 1-April-2022, then enter the date 1-Apr-22.
    Alter Currency in TallyPrime
  2. Specified Rate: the rate of the foreign currency with respect to the base currency.
  3. Modify other details, if needed.

Note:

If you want to provide forex rate a specific date, then you can do so while altering the currency. Refer to the Define forex rate section to know more. 

On any given date, when the rate of exchange is available in both Last Voucher Rate and Specified Rate fields in the currency master, it will consider the rate available in the Last Voucher Rate field only.

In a remote connection, if the Formal Name defined in a ledger while passing a transaction is not the same as defined in the company selected, an error message will appear. For example, Must use currency “$” for ledger “Sales”. 

Delete Currency

You may want to delete a currency, if you do not use it in any transaction. You can delete the currency in TallyPrime only if the currency is not used in any transaction in TallyPrime.

If you want to delete the currency used in one or more transactions, you can either:

  • Change the currency in the respective transactions.
  • Split the data in such a way that the data in the current period does not have transactions with the currency.
  • Delete the transactions in which the currency is used.
  1. In the Currency Alteration screen, press Alt+D (Delete).
  2. Press Enter or Y (Yes) to confirm.

If you have any other query regarding multi-currency accounting in TallyPrime, then refer to Currency in TallyPrime – FAQ.

Post a Comment

Is this information useful?
YesNo
Helpful?