Can foreign currencies be used in bexio? Yes, because it's possible to record a foreign currency and an exchange rate. The account form reports each show the foreign currency with the final balance. Realised exchange rate gains and losses are posted correctly when the payment is made. Unrealised exchange rate gains and losses need to be posted manually. Posting a pure base currency is also permitted in banks in a foreign currency. It is therefore important that the posting is correct and that the foreign currency is not forgotten. If the bank account is connected via banking, the correct posting is automatically carried out in the foreign currency in question. The exchange rates can be stored manually in an exchange rate table or changed, depending on the module, when the posting is made.
This ability to handle foreign currency postings flexibly also allows income accounts to be evaluated with foreign currencies (in all their variety). Interesting key figures on foreign currency risks can thus also be evaluated, and it is possible to quickly and efficiently check whether exchange rates are being used correctly (especially with regard to VAT).
- Foreign exchange rate table settings
- Receipt of payment
- Example – invoicing/incoming payments in euros
Foreign exchange rate table settings
The foreign currency master data can be found under "Settings" → "All Settings" → "Functions & Modules" → "Currencies and exchange rates".
In the case of companies liable to pay tax, the use of the correct exchange rate is very important. The currency exchange rate that corresponds to the invoice date must therefore be checked or adjusted in the settings.
To edit a currency and its exchange rate, click on the "three-point menu" on the right-hand side of the overview. Then select "Edit currency". The exchange rates are entered according to the following principle: 1 Euro corresponds to 1.05000 Swiss Francs, 1 Indian Rupee corresponds to 0.012 Swiss Francs, etc.
In most cases, the monthly average rate published by the Swiss Federal Tax Administration (FTA) is sufficient. This exchange rate is always published by the FTA on the 25th of the month, or the first working day following this, always with respect to the following month. Example: On 25th May, the monthly average exchange rate for the month of June is published.
The current monthly average exchange rate can be found on the website of the FTA under the following link: FTA monthly average exchange rate
The receipt is now issued in the relevant foreign currency. The incoming payment is made to the foreign currency bank account that has been set. The exchange rate and the associated foreign currency bank account can be selected in the invoice settings.
Receipt of payment
The customer's payment is made to the foreign currency account recorded on the invoice. The bank posts the amount received in the specified foreign currency. The incoming payment is posted either in banking or via the manual incoming payment.
When the payment in foreign currency is posted in the sub-ledger, bexio automatically posts exchange rate gains or losses if the calculated base currency invoice amount does not match the calculated base currency payment amount. This posting primarily balances the customer collective account (debit/credit) in the base currency (which, in most cases, is CHF). When the exchange rate gains and losses are automatically posted, all discounts, partial payments, etc., are then correctly taken into account in a thorough calculation of all posting options.
Example – invoicing/incoming payments in euros
Customer account cleared, holdings of Euro = 0, no valuation necessary
Account form 1100 (accounts receivable)