If you have both an invoice and a bank transaction in different foreign currencies (e.g., an invoice in EUR but the payment was received in USD), you need to process this through Mutual Offsetting.
Example:
Invoice = 100 EUR
Bank document = 125 USD
1) Create and post the invoice for 100 EUR in the standard way.
2) Post the bank document for 125 USD to account 261 (money in transit).
3) Next, you need to determine the so-called conversion rate. Divide the value of the bank document in CZK (found on the CZK tab (Abbreviation)) by the invoice value in EUR:
2669/100 = 26.69
Our conversion rate is therefore 26.69.
4) Go to the menu Money – Mutual Offsetting, click the New button, and in the dialog box select "Manually".
5) Fill in the company, number, and date of the offset, set the movement type to Receipt, and post to account 395. Enter the invoice currency and amount — 100 EUR — along with our calculated conversion rate of 26.69:
At the top, click the Match button, select the invoice to be included in the offset, and click "Merge". When you then check the links, you will see an exchange rate difference created in an internal document:
Click Save and Close.
6) The final step is to clear account 261 and create the expense side of the offset. Again, select New and "Manually" at the top, but this time set the movement type to "Issue". Enter the currency and amount from the bank document — 125 USD = 2669 CZK. Post it as 261/395.
This offset is used solely to clear the account balance and should therefore be left unmatched, as bank documents cannot be included in mutual offsetting.