Automatic clearing of exchange rate differences during bank statement upload

[iklovski]

Hello,

The situation is very simple. There is a payment in foreign currency which goes out from EUR account. Say, 105 USD which is equivalent of 100 EUR. So, payment run generates this document with those figures. However, when it comes to bank, the rate might change and the bank executes 105 USD payment, which is equivalent to 102 EUR. When the statement is uploaded, it is a EUR account, and the amount communicated in the statement is 102 EUR. The information of payment run document is present, so the system can make a match and clear G/L account of the bank, but there is a clearing difference of 2 EUR, and therefore, reconciliation (clearing) is blocked.

What would be the way to ensure automatic posting, and pass those 2 EUR of difference to exchange loss/gain accounts?

Thanks in advance,

Eli

[Gustavo_Vazquez]

Hi Eli,

I had some scenarios with Invoices on Foreign Currency that are paid in Local currency.

If you get the Exchange Rate with the Bank, complete the payment amount in the Vendor position of the Invoice. You have to enable Payment Amount / Currency in Status Filed of Posting Key.

Kind Regards

[iklovski]

Hi Gustavo,

Thanks for your feedback. The problem is that the bank account is in local currency (EUR), while the payment is done in foreign currency. So, bank, when they send the statement don't specify that there was some exchange rate difference, they just send the amount in EUR for the amount calculated by them when they processed the payment in, say, DKK. So, the EUR amount of payment run and the one of the statement could differ. Manually, it will be cleared almost semi-automatically, but still the user will have to charge off the difference to Forex G/L account, by encoding the reason for partial clearing. I want to save them the burden...

Regards,

Eli