Skip to main content

Settlement of a Received CZK Invoice by EUR Bank Document via Mutual Offsetting

Settlement of a Received CZK Invoice with a EUR Bank Document via Mutual Offset

Written by Zuzana Sýkorová

There are two ways to settle domestic documents in a foreign currency. The first is directly in the bank via services and by creating a payment link — however, this method will leave a discrepancy in the balance (the amount in the foreign currency will not have a corresponding amount in the foreign currency against it, so the case will only be settled in the domestic currency). In such a case, it is sufficient to check "exclude from balance" on the documents. The second method, which we will demonstrate below, is through mutual set-offs, where complete matching occurs both in the domestic and foreign currency, along with exchange rate differences.

___________________________________________________________________________________

Settling a domestic invoice with a foreign currency document using a set-off

A received invoice recorded at a value of 79,654.22 CZK:

A bank transaction recorded at a value of 3,359.52 €, which we will post to account 261:

At the same time, note down the CZK value on the bank document (80,326.12) and the exchange rate 23.909999. Then navigate to the Money - Mutual Set-offs agenda and create a new record. Flexi will ask whether you want to create the set-off using the wizard or manually — select the manual option:

First, fill in the set-off that will settle the received invoice. Enter the set-off date (this can be the same date as the document payment), the set-off number, variable symbol, posting account, and amount (the bank payment value). After filling in the details, click Match (highlighted in blue).

A list of Received Invoices will open — select the invoice you need to settle. After selecting it, a summary table will appear showing the difference, which represents the exchange rate difference:

Confirm by clicking the Link button and Flexi will ask what to do with the exchange rate difference. This is a full invoice payment and we want to post the difference.

The document will be matched and a link to an internal document for the exchange rate difference will be created. Since we are creating a payment link via a mutual set-off, the system will automatically assign account 395000 (or whichever account you have configured for set-offs) as the contra account in the internal document. It is therefore necessary to re-post this entry. We are now back on the mutual set-off window — click on Links:

A links overview will open showing the received invoice and the internal document. Select the internal document and choose the option to open the document:

A preview of the internal document will open, where you can directly update the account for the exchange rate difference:

Save the document and close the links to return to the set-off entry. Then select Save and New and create the counterpart entry for the bank payment. The movement type will now be Receipt, posted to account 261. Enter the exchange rate 23.909999 and the EUR amount 3,359.52 (also verify that the CZK value equals the CZK value on the bank document, i.e. 80,326.12).

Save and close the mutual set-off. The set-off is now balanced.

Now navigate to the Accounting - Accounting Outputs - Balance module to verify that the amounts are settled in both CZK and EUR:

_______________________________________________________________________________

Final tip:

If you do not see certain accounts or transactions in the balance, they most likely do not have balance tracking enabled. You can enable this via Accounting - Chart of Accounts — edit the specific account and check the Balance checkbox:

_______________________________________________________________________________

Useful links:

Did this answer your question?