DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Exchange Rate FIFO Method


#1

Currently, the latest exchange rate is taken to calculate the balance between different currencies. The problem is that we are using FIFO method.

Is there any way I can apply FIFO method due to exchange rate? Thanks.


Exchange Rate should be a separate module that can be selected in customize tab
#2

In my opinion it’ll better if Currency gains (losses) method will be somehow manual and not automatic methodology.


#3

Yeah, it makes me headache; but we can’t omit that currency part only and will not get accurate data. :frowning:


#4

I agree but yes it’s sort of a headache and looks to me that some manual procedure will be better.


#5

Frankly, I’ve never heard of FIFO method in relation to exchange rates or currency valuation. What it is?

@Giora, I think the issue is that Manager doesn’t have a report to explain how did it calculate those exchange gains / losses. I’m working on it. That way you will be able to examine what’s going on with each entry. If you think some amount is way off, the report will give you an answer how did it come to that amount.


#6

Automatic algorithm details required, it can be default mode but In my opinion manual option overriding manager calculations is necessary.


#7

FIFO Method means FIRST IN, FIRST OUT.

For example, We received 10 USD with exchange rate of 1000 MMK on 1st April, 2015. Next day, we received 10 USD with exchange rate of 900 MMK. On 2nd April, we spent 15 USD. Here the calculation of FIFO method. We calculate first 10 USD with 1000 MMK and latter 5 USD with 900 MMK.

Currently in Manager, only the last updated exchange rate is used to calculate the balance. That way, we can’t get the exact valuation. According to my accounting experience, FIFO is the best method.

Hope we can get FIFO method integrated soon. :smile:

Thanks.


#8

FIFO makes no sense to me in the context of exchange rates for at least two reasons:

  1. Whenever you hold cash, its value is represented in the currency in which you hold it, not the exchange rate that applied when you received it. Even in a single-currency implementation of Manager (or any other accounting package, for that matter), the underlying worth of your cash against some external standard may go up or down. But its accounting value is fixed.

  2. When you engage in a transaction that involves currency exchange, the exchange rate is constant for the entire transaction. You may have small gains or losses due to timing of various aspects of the transaction, that is, receiving an invoice, sending a payment, depositing the payment, etc. But whichever rate applies to any portion of the complete transaction applies to the entire amount involved. The fact that you might have received funds that were formerly exchanged at different rates makes no difference.


#9

I totally disagree with this suggestion. To calculate the gains and losses on currencies, historical exchange rates don’t matter. It is the current exchange rate that will be used.

If a transaction happened (maybe with a customer or supplier who deals in a currency other than your base currency) the gains and losses computation will use the current exchange rate as against the exchange rates on the day the transaction happened to compute the gains or losses, manager is doing that already.


#10

Ok then, what will happen to the trial balance? We won’t get balanced tri with the current exchange rate.

Thanks.


#11

Exchange rate gains or losses are recognised in the Profit and loss statement so the trial balance will always balance. You may as well post a picture to further explain your problem maybe i am misunderstanding you