Report "unrealized Exchange gain & Loses" seems to calculate the Gain/Loss properly for ASSETS but incorrectly for LIABILITIES (wrong sign). Is there a work around?

Hey carlos-rosito,

Keeping an accurate record of your exchange gains and losses is a vital part of managing your international sales. This is something QuickBooks Online handles for you, making it easy to know the specific effect fluctuating exchange rates have on your business. Any time you record a payment, the system automatically calculates the difference between the home currency values of the payment and amount owing. This ensures you'll always have accurate balances in your A/R and A/P accounts. The error you're describing is unusual, but I'm confident we'll get to the bottom of it.

You've mentioned Quicken, if this error is occurring in the Quicken software, please reach out to their support. Otherwise, I'd really like to take a closer look to help get a better understanding of what's happening. Choose from the following methods to get in touch with an agent, they'll have the tools to sort this out in no time. 

Phone and Chat: Click Contact Us to learn how to reach phone and chat support.

Schedule a Callback: click (?)Help in the upper right > click Contact Us > explain your situation > click Let's Talk > choose Get a callback (Note: Callback hours are the same as regular phone hours.)

Social Media: Facebook, Twitter, and Instagram from Monday to Friday between 9 a.m. and 8 p.m. ET

Don't be afraid to reach out! I want to make sure everything is recording correctly.

Hi AndreB.  Thank yo for your note.  I had talked to a Quickbooks customer service representative prior to the posting, but her proposed workarounds (ask accountant to manually correct the error, etc., etc.) was not the right solution for us and certainly not for Quickbooks.

How do I escalate the problem within Quickbooks?  the contact info that you provided only takes me to another customer service representative.

I need to get a solution in a couple of weeks or I will have to do my year end using another system.

Thank you

Carlos

Hey again carlos-rosito,

I know how crucial it is to have accurate books. This is especially true when multi-currency is involved. QuickBooks Online is designed to streamline all things foreign currency to empower your international business. Most issues like this one can be resolved using the revalue currency feature, but if that doesn't work it really helps to get a detailed look at how things have been recorded. Please reach out to an agent, and they'll be happy to take a closer look.

Phone and Chat: Click Contact Us to learn how to reach phone and chat support.

Schedule a Callback: click (?)Help in the upper right > click Contact Us > explain your situation > click Let's Talk > choose Get a callback (Note: Callback hours are the same as regular phone hours.)

Social Media: Facebook, Twitter, and Instagram from Monday to Friday between 9 a.m. and 8 p.m. ET

Let me know if there's anything else I can do to help!

Hi AndreB. We evaluated your suggestion of using "revalue currency" and while that may work for few transactions a year, it is completely impractical when we have all our suppliers based in USD and Euros with multiple payments at complete different exchanges every day.

We have not been able to find a way to escalate this issue with Quickbooks so they can fix this bug.

Is there technical support that can be reached so they can do something about this problem?

Due to the large devaluation of the Canadian dollar vs. USD (dropped from 1.32 to 1.45) the FX losses accumulated by the Account Payable in USD are quite large but the "unrealized Exchange Gain and losses" shows them as GAINS!

It reached a point that we do not even trust the FX (GAIN)/LOSS line of the P&L either!

After spending so much time and effort to get Quickbooks online working we will really hate to have to drop it for another software.

Please let us know if there is a way to get the problem resolved.

Thank you

Carlos

Hello again,

Please choose from the following methods to get in touch with an agent. They'll be able to look at your accounts more closely and obtain screenshots to determine the best approach in investigating this issue.

Phone and Chat: Click Contact Us to learn how to reach phone and chat support.

Schedule a Callback: click (?)Help in the upper right > click Contact Us > explain your situation > click Let's Talk > choose Get a callback (Note: Callback hours are the same as regular phone hours.)

Social Media: Facebook, Twitter, and Instagram from Monday to Friday between 9 a.m. and 8 p.m. ET 

Don't be afraid to reach out! I want to make sure your foreign currency accounts balance.

I am finding that too and lots of other bugs too one by one ([email address removed])!

Hi there.

It is clear that the "unrealized Gain and Losses" report in Quickbooks is incorrect.  If you assume that a "+" result is a gain, then the liabilities computation is wrong (wrong sign).  If you assume that a "-" is a gain (like in the p&L) then the asset calculations is wrong (wrong sign)

I have not been able to get hold of someone in QB who can address software bugs.

The good news is that when we reached the end of the year, we used the feature under: Settings->Currencies-> select the currency and then "reevaluate currency".   It creates a JE that adjusts the CAD$ balance to the right amount and records the FX gain/loss in the P&L with the correct amount (it did match our manual calculations).  Right now our Balance Sheet and P&L look correct.  Hope that helps someone.