Skip to main content

Matching Different Currencies

Matching foreign currency invoices with CZK bank payments

Written by Lenka Haringerová

Examples of foreign currency matching in Flexi
​
​
Outgoing invoice in foreign currency 100 € (exchange rate 27.43 CZK/€), payment in CZK 2,700.00 = 100 € (bank exchange rate 27.00 CZK/€)
​
VF1-0035/14 = 100 € = 2,743.00 CZK
​
B+0015/14 = 2,700.00 CZK, full payment 100 € (bank exchange rate 27.00 CZK/€)
​
- Services - Create payment link - select the invoice - confirm with the Select button - a message will appear: "The paying document is set to CZK currency. Do you want to change it to the currency of the document being paid, EUR?"
​
- enter YES
​
- in the dialog box - "Enter the exchange rate to be used on the paying document" - enter the exchange rate = 27.00 according to the rate used by the bank - press OK
​
- in the dialog box "The amount in (€) is not filled in on the paying document. Please enter the amount in €." - the invoice amount of 100 € will be displayed and you can match the documents by clicking the Link button.
​
​An exchange rate loss of 43.00 CZK will be generated, the invoice will be fully paid, the bank entry will be updated with the € currency and the entered exchange rate = 27.00. Bank totals: account in CZK = 2,700.00 + additionally documents in € = 100.00 €. After initialization, the correct value in CZK plus the additional account value in € will appear in the opening balances of the bank account.
​
​
​
Outgoing invoice in foreign currency 100 € (exchange rate 27.43 CZK/€), partial payment in CZK 1,890.00 = 70 € (bank exchange rate 27.00 CZK/€)
​
VF1-0035/14 = 100 € = 2,743.00 CZK,
​
B+0015/14 = 1,890.00 CZK, partial payment 70 € (bank exchange rate 27.00 CZK/€)
​
- Services - Create payment link - select the invoice - confirm with the Select button - a message will appear: "The paying document is set to CZK currency. Do you want to change it to the currency of the document being paid, EUR?"
​
- enter YES
​
- in the dialog box - "Enter the exchange rate to be used on the paying document" - enter the exchange rate = 27.00 according to the rate used by the bank - press OK
​

- in the dialog box "The amount in (€) is not filled in on the paying document. Please enter the amount in €." - the invoice amount of 100 € will be displayed — delete it and enter the amount of 70 € and match the documents by clicking the Link button. In the following dialog box, select that this is a Partial payment.
​
​An exchange rate loss of 30.10 CZK will be generated, the invoice will be partially paid, the bank entry will be updated with the € currency and the entered exchange rate = 27.00. Bank totals: account in CZK = 1,890.00 + additionally documents in € = 70.00 €. After initialization, the correct value in CZK plus the additional account value in € will appear in the opening balances of the bank account.
​
​Note: For partial payments, the options "ignore difference" and "post difference" cannot be used.
​

Note: The same procedures also apply to received invoices.
​

Did this answer your question?