FrontAccounting forum — Exchange Variance

Re: Exchange Variance

null@example.com (A.A) — Wed, 20 Jan 2021 13:12:16 +0000

Hello

is there any idea about this issue?

Re: Exchange Variance

null@example.com (A.A) — Sat, 26 Dec 2020 08:17:05 +0000

what kind of detail do you need?

I have problem with 5 account indeed. most of should be zero based on currency but the FA calculate Exchange VAriance.

could you tell me what kind of detail you need?

Re: Exchange Variance

null@example.com (kvvaradha) — Mon, 21 Dec 2020 14:51:40 +0000

Dude,

Its not easy to tell you without checking the program. If you want me to help you on this issue contact me with details. I will look into it.

Re: Exchange Variance

null@example.com (A.A) — Mon, 21 Dec 2020 08:36:58 +0000

Dear kvvaradha

Let me get clear about my data.

I have 3 active bank account every of them work with at least 3 currencies.

in this case I have some supplier or customer which works in EURO or POUND and we some time do our payments in USD or Emirate Dirham.

now these account make a periodic wrong exchange variance based on my revaluation but not my rates.

I use xe.com rates in order to make a unified the calculation in exchange variance. I can't imaging the several rates in one day when there is a several active bank account. this is the right way where I live. (""if you think it's wrong I insist to describe me right way or a guidance link"")

now please let me the solution. possibly manually, if not please let me know the cost of program and the way I can achieve it.

Thnks for ur help

Re: Exchange Variance

null@example.com (kvvaradha) — Sun, 20 Dec 2020 07:13:52 +0000

You can't do this manually. You need to write a program to store it. And also you need exchange rates of each rate that you have journal entry it. If it's one or few entries you can do manually. And for more entries, You need program to do this.

Re: Exchange Variance

null@example.com (A.A) — Sun, 20 Dec 2020 06:28:43 +0000

thanks dear kvvaradha

unfortunately I record All my data based on XE.com rates during years.
could you tell me how can I adjust them manually?

I try it with Journal and Bank payment and Deposit many times, but it doesn't work and by revaluation all of them get back.

Re: Exchange Variance

null@example.com (kvvaradha) — Wed, 16 Dec 2020 11:43:34 +0000

There is a difference between bank to bank exchange rates in real. And from exchange rate provider it has some difference. So whenever you record payment, confirm with bank and record the amount to the invoice. And bring the exchange rate values as of it's. Otherwise you will be in trouble at the end. Try to identify the more affected transactions and adjust them manually to solve the problem. Each transaction records exchange rate in its own entry. And compare them and alter your gl_trans entires.
This is the only way. And keep your developers an accountant without during the edit.
I feel there is no option without it.

Exchange Variance

null@example.com (A.A) — Wed, 16 Dec 2020 10:13:34 +0000

when I re-evaluate at the end of period, the banks get change based on the exchange rate that I record in FA.

but about AR and AP it doesn't happened. it looks FA found a new Rate from some where or calculate new rate.

it make a big amount of Exchange variance in my Trial Balance. is there any solution for it.

Regards