# Facing Forex gains/losses problem

**URL:** <https://forum.manager.io/t/facing-forex-gains-losses-problem/34688>\
**Category:** Uncategorized\
**Created:** [May 1, 2021, 4:34pm UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688 "2021-05-01T16:34:24Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Inline](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@Inline](https://forum.manager.io/u/Inline)\
**Post date:** [May 1, 2021, 4:34pm UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/1 "2021-05-01T16:34:24Z")

</div>

Hi all, i really need help on this _Forex gains/losses_ problem i am having.

I believe when updating the system this may have caused this because the _lock date_ was set after the audit was completed and nothing was changed, in which everything was okay back then with the value being 74.221 BHD.

Surprisingly some of the _Forex gains/losses_ are higher than the actual transactions and i am unable to find out why.

See images below for easier explanation.

 ![Summary Foreign Exchange](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/a/aa7d266f47f00b545103481fa15167d48550b330.jpeg)

Below is one of the transaction of 30 USD but _Forex gains/losses_ being 36.399 BHD which is equal to 96.45 USD when calculation with the set exchange rate.

 ![Summary Foreign Exchange Expense](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/0/806f2f006fda1feb4c53d65bff545fc5dea46366.jpeg)

 ![forex](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/b/3b9ca558697fef1a619aad77084ab8a1fed71c7f.png)

Any idea of why this is happening is much appreciated.

Thank you.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [May 1, 2021, 5:01pm UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/2 "2021-05-01T17:01:12Z")

</div>

Is your expense claim still outstanding?

Has it been paid?

What is your base currency?

What edition and version of Manager are you using?

What OS are you using?

---

<div class="post-metadata">

**Author:** ![Inline](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@Inline](https://forum.manager.io/u/Inline)\
**Post date:** [May 1, 2021, 5:13pm UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/3 "2021-05-01T17:13:16Z")

</div>

Hi @Joe91, thanks for replying.

Payer _FLA_ is a partner so the expense claims goes straight to _FLA_ capital account.

Base Currency is BHD.

I am using Manager desktop version 21.4.27

MAC OS Big Sur 11.0.1

For some reason that i cannot identify, all transactions since 2017 until date, the only problem are with these 4 transactions, everything else is 0.001 BHD which is okay.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [May 1, 2021, 5:16pm UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/4 "2021-05-01T17:16:59Z")

</div>

delete one of them and re-enter

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [May 1, 2021, 5:26pm UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/5 "2021-05-01T17:26:09Z")

</div>

You are, of course, many hundreds of versions behind so a forex problem may have been identified and corrected in the meantime

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [May 1, 2021, 5:42pm UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/6 "2021-05-01T17:42:04Z")

</div>

I setup a Test company and entered an Expense in USD, a foreign currency, for a Capital Account Holder and it all worked as I expected

---

<div class="post-metadata">

**Author:** ![Inline](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@Inline](https://forum.manager.io/u/Inline)\
**Post date:** [May 1, 2021, 5:46pm UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/7 "2021-05-01T17:46:10Z")

</div>

@Joe91 thank you so much, so simple to do.

I never thought about it trying to delete and re-enter, but look everywhere thinking that the problem was more complex.

It worked, perhaps a small bug happen when updating the versions.

---

<div class="post-metadata">

**Author:** ![Inline](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@Inline](https://forum.manager.io/u/Inline)\
**Post date:** [May 1, 2021, 5:46pm UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/8 "2021-05-01T17:46:59Z")

</div>

@Joe91 thanks for spending your time helping.

Thumbs up!

---

<div class="post-metadata">

**Author:** ![Inline](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@Inline](https://forum.manager.io/u/Inline)\
**Post date:** [May 2, 2021, 8:16am UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/9 "2021-05-02T08:16:26Z")

</div>

@Joe91 now the problem i am facing is what to do with the difference, because it was a glitch in the system since in some entry the system calculated the _FOREX_ as one-to-one, and in some cases one-to-multiple and it was not caught up by the auditor back in time.

See below the entries where the _FOREX_ did not follow USD 2.65 to BHD 1.

 ![Screen Shot 2021-05-02 at 10.58.00 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/a/3a90f64b8c30c218642b7200b1071b2d214571ee.png)

 ![Screen Shot 2021-05-02 at 11.01.28 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/f/df122eaff3d2fbf600c3c76dd0a3288d774c62b4.png)

 ![Screen Shot 2021-05-02 at 11.07.02 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/1/7/17bc8c1a49fdc694c51a9ff1a6a67942166af557.png)

Note: before deleting and re-entering i made a backup and now i am comparing what changed.

@lubos you may find this interesting to review, perhaps if this happens again in future.

Thank you.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [May 2, 2021, 8:37am UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/10 "2021-05-02T08:37:15Z")

</div>

You have a choice between restating previous year’s accounts or using a journal entry to adjust the Capital and Retained earnings account in the current year

---

<div class="post-metadata">

**Author:** ![Inline](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@Inline](https://forum.manager.io/u/Inline)\
**Post date:** [May 2, 2021, 8:43am UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/11 "2021-05-02T08:43:19Z")

</div>

@Joe91 now the more i investigate, more confuse i get.

Since USD has a fixed _FOREX_ in settings, why there is a huge revaluation difference?

Shouldn’t USD be zero since the exchange rate never changes?

 ![Screen Shot 2021-05-02 at 11.37.47 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/7/87242b4c016712ab195e75f0cf3d3ed1efc9789e.png)

.  
Also 3 of the 4 entries i have re-enter is no longer showing Gains/Loss (See updated Summary below)

 ![Screen Shot 2021-05-02 at 11.48.57 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/5/35f8638afd60fd6a76e079768365acd576b7a35b.jpeg)

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [May 2, 2021, 9:00am UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/12 "2021-05-02T09:00:37Z")

</div>

If you search the forum you will see that there was a bug in Forex some time ago.

The small Forex changes are because the transactions are split into 2 or more lines and when each line is converted into your base currency there is a rounding difference which is sometimes positive, sometimes negative.

You can drill down on the Reevaluation figure to see how it is calculated

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [May 2, 2021, 9:08am UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/13 "2021-05-02T09:08:32Z")

</div>

For the USD balances, you will have to examine the invoices and payments to make sure they all used the correct exchange rate

Same for AED - check the entries in the Accounts Payable - there is a mis-match somewhere

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 2:46pm UTC](https://forum.manager.io/t/facing-forex-gains-losses-problem/34688/14 "2023-01-18T14:46:26Z")

</div>

Closed on January 18, 2023, 2:46pm UTC


