Multi-Currency Setup
If your business deals in multiple currencies, OurBooks can handle foreign currency transactions and reporting.
Enabling Multi-Currency:
- Go to Company Settings.
- Turn on "Enable Multi-Currency" and set its start date.
- Your base (reporting) currency is the Default Currency in Company Settings — this is the currency your financial reports use.
Working with Foreign Currency:
- When creating invoices or bills, select the transaction currency.
- With an ECB source, OurBooks looks up exchange rates on demand from the European Central Bank when you need one for a transaction date. Rates aren't fetched in the background, so a historical date shows no rate until it's requested. With Manual Only, you enter rates yourself.
- Transactions are recorded at the transaction-date exchange rate.
- Foreign currency accounts show balances in both the foreign currency and your base currency.
Exchange Rate Gains/Losses: As exchange rates fluctuate, the base-currency value of foreign balances changes. OurBooks handles:
- Realized gains/losses — Automatically calculated when you receive/make payment at a different rate than the original transaction.
- Unrealized gains/losses — Calculated during period-end revaluation for outstanding foreign-currency balances.
Setup Tips:
- Set your FX Realized Gain/Loss Account and FX Unrealized Gain/Loss Account under General Ledger > GL Setup > Currency before processing foreign currency transactions.
- Review the Exchange Rate Source on the same page — the choices are ECB (European Central Bank), ECB with Manual Override, Aggregated (200+ Currencies), Aggregated with Manual Override, and Manual Only.
- Run FX Revaluation (General Ledger > Period End) at month-end to keep your balance sheet accurate.
Next steps
Get Started Free
No credit card required