Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 1, 2021
Question

Exchange Gain or Loss

  • November 1, 2021
  • 1 reply
  • 40 views

Hi everyone!

Help me with a few situations about QBO multicurrency mode, please.

In general, home currency is CAD, additional currencies USD & EUR.

1. For example, at 15th of August I received 1 000 USD on my USD bank account and in Finance Statments I saw 1 100 CAD. For now I have generated FS for September and see the same 1 100 CAD, but shoud be 1 100 CAD Income and 100 CAD Exchange Gain or Loss (=1 200 CAD). How I can set up or turn on foreign currencies recalculation on monthly basis?

2. For example, at 21th of May I received 500 USD on my USD bank account and in Finance Statments I saw 550 CAD. It was Deferred Revenue. But I failed my work and had to gave money back at August when Refund Reseipt was 530 CAD. So I gave back 500 USD that was 530 CAD and 20 CAD left on my Deferred Revenue. How I can transfer 20 CAD to Exchange Gain or Loss?

    1 reply

    Moderator
    November 1, 2021

    Hello, Alex_St. 

     

    Thanks for considering using the Multicurrency tool in managing your foreign currency. Allow me to provide some information on how this option works. 


    The feature mentioned above is only available in QuickBooks Online Essentials, Plus, and Advanced. Once you turn it on, the following fields and labels are added to your company.

     

    • Chart of Accounts: A Currency column appears on the Chart of Accounts, identifying each account's currency. Once an account has had a transaction posted to it, you can no longer change the account's currency,
    • Bank and Credit card registers: A currency notation appears in the headings of the Payment, Deposit, Sales tax, and Balance Due columns on Bank and Credit card registers (or account histories). 

     

    After activating the Multicurrency option, you’ll no longer be able to turn it off and change the home currency. If you wish to turn it on, let me share the steps on how to accomplish this task in QBO.

     

    1. Go to the Gear icon at the top and pick Account and settings under Your Company.
    2. Choose the Advanced menu on the left panel and click the Pencil icon for Currency.
    3. Toggle the slider for Multicurrency to the right to turn it on.
    4. Click Save and Close.


    Let me share this article for additional information. It provides an overview on how to add or delete currencies, enter the exchange rate, add foreign customers or suppliers to name a few: About Multicurrency

     

    In regard to your second question, Exchange gain or loss expense happens if the current exchange rate is higher or lower than the previous rate. For more details about exchange rates, see the Learn about exchange rates in QuickBooks Online article.  

     

    Feel free to get back to me if you have additional questions about Exchange Gain Or Loss in QuickBooks Online. Have a good one. Stay safe!

    Alex_StAuthor
    November 2, 2021

    Hi, AileneA!

    Thanks for your answer, but I need a littele bit more explanation about how Exchange Gain or Loss works in QBO Plus.

     

    Really good explanation article you gave me to read (https://quickbooks.intuit.com/learn-support/en-us/multi-currency/about-exchange-rates/00/186361). Do you have any article what is going on next in profit and loss report when you don't exchange 20 CAD till the next reporting date with another exchange rates (not 0.79)? After a year you will have the same 20 x 0.79 = 15.77 USD in your Balance Sheet?

    According to IAS, GAAP and other Standarts the Monetary Assets have to be revaluate / re-evaluate / reastemate / recalculate to new exchange rate at the reporting date (in most cases every month).