Filters and options in the Revaluation Preview report
Control what data appears in the report and how it is organized.
Jul 11, 2026
Filter and option reference
| Filter / Option | Purpose | How to use |
|---|---|---|
| Revaluation date | Sets the date for which the report calculates exchange-rate adjustments and shows unrealized gains/losses. | Click the date picker and choose your desired date. The report will use the exchange rate you have recorded for that date (or the nearest date if none exists for the exact date). Most teams use today's date or the last day of the accounting period. |
| Accounts | Limits the report to specific accounts in your chart of accounts. | Leave blank to include all multi-currency accounts. To filter, begin typing the account name or code. Select one or more accounts from the dropdown. The report will show only the selected accounts. |
| Group by currency | Reorganizes the report so that rows are grouped by currency instead of by account. | Check the box to enable. When enabled, all USD balances appear together, all EUR balances together, etc. This view can help you see the total exposure in each currency at a glance. |
| Include zero balances | Controls whether accounts with zero balance in the foreign currency appear in the report. | Check the box to include them. Uncheck to hide accounts that have no unrealized gain or loss (balance = 0). By default, zero-balance accounts are hidden. |
| Show exchange rate details | Adds columns that show the exchange rate used, the original carrying amount, and the revalued amount side-by-side. | Check the box to enable. When disabled, only the account name, currency, balance, and gain/loss are shown. Enabling this option gives you the full calculation. |
Common filter combinations
"I want to review only my bank accounts in foreign currencies"
- Set Revaluation date to today (or your period-end date).
- In Accounts, select only your bank accounts (e.g., "Bank USD", "Bank EUR").
- Leave Group by currency unchecked to see each bank account on its own row.
- Check Show exchange rate details so you can verify the rates used.
"I want to see the total unrealized gain/loss per currency"
- Set Revaluation date.
- Leave Accounts blank to include all multi-currency accounts.
- Check Group by currency to organize by currency.
- You will see subtotals for each currency's total gain/loss.
"I am posting a revaluation at month-end and need to verify all accounts"
- Set Revaluation date to your month-end date.
- Leave Accounts blank to see the full picture.
- Check Show exchange rate details to confirm the rates are correct.
- Optionally check Include zero balances to confirm that accounts with no movement are correctly excluded.
Was this helpful?