Ir al contenido
Menú
Se marcó esta pregunta
3 Respuestas
5505 Vistas

Dear Odoo (v16) community,

I had a lenghty description of my issue but included an image apparently without Karma, posted the entry, got an error, and the whole long description is gone.


So short version and without image:

When you book a bank payment via bank reconciliation mode where the vendor bill is in a foreign currency, Odoo calculates an exchange rate difference.

1) How does that calculation work?
2) Can the calculated amount be overwritten or does it really have to have a second exchange rate difference booking/line correcting the first one? This means every payment in foreign currency will have two accounting lines instead of one for exchange rate differences, because the calculated one always differs from the real one used by banks.

Thanks very much in advance!

Avatar
Descartar
Mejor respuesta

Odoo 16

Exchange rate differences are only calculated when a Vendor Bill in a foreign currency is paid on a date that is not the date when the Vendor Bill was recorded.

Example:

  • Company currency is USD
  • Bill recorded of EUR 15,363.53 on June 1st
  • Payment recorded of EUC 15,363.53 on June 30th

When you use the payment for the Bill, Odoo will compare the $USD to EUR exchange rate it had for the 1st and the 30th and book a gain or loss automatically for you.  This is based on the Exchange Rate service that you choose in Settings:


Since Odoo doesn't know the exchange rate your bank will use, this is an estimated gain or loss.

ie: For a payment of EUR 15,363.53, Odoo may calculate a $USD equivalent of $16,524.46 on the date of the Bill and another $USD equivalent on the date of the Payment.


When you receive your bank statement, your bank will show the actual $USD needed to pay for the EUR payment, and you will reconcile this actual amount of $USD with the estimated $USD that Odoo calculated. 


ie: Bank charged $USD 16,538.00 to send a payment of EUR 15,363.53, a difference of $13.54


Odoo will automatically book the gain or loss to the configured Gain and/or Loss Account configured in Settings:


Note: If you don't supplement the information provided by your bank by entering the foreign currency amount on each statement line to let Odoo know how many EUR each USD payment was worth, you will need to choose the account each time.  Reconcilation models can give you single click to post the difference to the 'gain' or 'loss' account.


Summary

Odoo will record the "estimated gain/loss" based on the differences between estimated exchange rates when the Bill is paid.

Odoo will record the "actual gain/loss" based on the exchange rate your bank uses when the bank statement is reconciled.

You don't need to create any other entries as both entries are automatically created for you.


Avatar
Descartar

Thank you very much for the reply, it solved my problem as well. I first checked the official documentation but again it is very outdated: https://www.odoo.com/documentation/16.0/applications/finance/accounting/bank/reconciliation.html

Mejor respuesta

Hello, 

Yes, you are correct. It would be better that the reconciliation view would allow you to edit the amount in currency as well. It is somewhat tedious work to go to list view, change it there and go back to the recon view (which still does not show the amount in currency). 

But the good news is that the documentation has been updated to the new bank reconciliation. Kindly mentioned the exchange rate differences  treatment/workflow as well. 


Avatar
Descartar
Autor Mejor respuesta

Thanks Ray, for the very detailed and great reply. I think the functioning of Odoo is more clear to me now.
Issue is our bank doesnt provide the original currency and amount in a structured format via our interface.

What I find still a bit irritating (also PO from Odoo explained to me that there is good reasons for this...) is that you potentially end up with 3 FX entries:
- estimated gain/loss (automatically created by Odoo and not able to change this one, its locked), e.g. 10EUR Gain

- Correction of the estimated one in case the actual currency difference is not a 10€ gain but a 50€ loss --> reduce gain account by 10 to undo the above automatic line

- Booking the actual 50€ loss 

It seems that if you provide manually the original currency and amount in currency Odoo merges the two currency effects in one FX line, which is nice. However, you do have to go back to your list view to enter this information and cant enter the original currency and amount in currency in the reconcilation window.


Correct?

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
0
oct 23
1501
1
jun 23
4472
3
abr 20
12329
0
dic 22
1822
1
ago 22
5454