Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
T
tomegranate
September 2, 2020
Question

Forex Gain / Loss

  • September 2, 2020
  • 3 replies
  • 102 views

Hello -

 

We purchase product from a European vendor.

 

I am noticing in QB online there are a ton of FX gain/loss entries automatically booked when we post a bill from that vendor. However, an FX gain/loss should not arise until we pay that bill. But, the gain/loss on FX is posting while the bill is still sitting as AP

 

The fx gain/loss entries which are showing up are always +0.01/-0.01 cents. This doesnt make sense and is allowing for messy report generation.


Anyone ever seen this before?

3 replies

LieraMarie_A
LieraMarie_A
Level 8
September 3, 2020

I'm here to share some insights about foreign exchange gains or loss, @tomegranate.

 

The amounts that you're seeing are unrealized forex gains or loss. It means that it has an increase/decrease in the value of assets, yet no cash has taken place. Some accountants call it as "Paper loss/gain."

 

These gains or losses are only realized after the transactions have been completed or when money has been collected or paid.

 

That is why it shows the effect of a home currency adjustment on Accounts Payable or Accounts Receivable as an unrealized gain or loss, and the effect on account types such as bank accounts as a realized foreign exchange gain or loss. Unrealized gains or losses are also not reflected in the general ledger or the trial balance.

 

I'm also adding this article for more FAQs about unrealized gains and losses: Frequently Asked Questions about Home Currency Adjustments.

 

Please let me know if you have other questions or concerns. We're always here to help. Have a great day, @tomegranate. 

Buck Tsai
Buck Tsai
October 27, 2021

how can i pull a TB from QBO that include unrealised forex gain and loss?

M
Mark_RModerator
Moderator
October 27, 2021

I've got your back, @Buck Tsai.

 

In QuickBooks Online (QBO), there are specific reports that include unrealized forex gains or losses. However, the Trial Balance report isn't listed. You can consider pulling up these reports to display such information:

 

  • Profit and Loss report
  • Balance sheet
  • Customer Balance Detail report
  • Vendor Balance Detail report
  • Statement of Cash Flows

 

To learn more about forex gains or losses, feel free to check out this article: Frequently Asked Questions about Home Currency Adjustments.

 

As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.

 

Our doors are always open to help you again if you have any other concerns or follow-up questions. Have a pleasant day ahead.

Fiat Lux - ASIA
Fiat Lux - ASIA
Level 14
September 3, 2020

@tomegranate 

As other options, if you are dealing with multi currency transactions, explore these solutions and integrate it with your QBO to get a better exchange rate and a lower fee.

https:// veem.grsm.io/veems

https:// prf.hn/l/7gg1NWy

 

Hope it helps.

 

M
MicaelaPalacios
November 11, 2025

I’ve seen a lot of threads about FX gains & losses. I’m collecting responses to a student research survey on month-end accounting pain points and structural gaps, and would value your input. Here’s the quick survey: https://forms.gle/yZF8uJMCZmWQ4Y9t5

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement