Default rates

As of September 30, 2025, JustConsolidate provides default exchange rates for foreign currency translation, sourced from openexchangerates.org.


What's included:

  • Historical rates for over 200 worldwide and digital currencies
  • Monthly average and month-end rates going back to January 2000
  • Data captured daily at a 23:59:59 UTC cutoff
  • Monthly averages calculated as the average of daily ending rates


Modifying rates

If you need to use your own rates instead of the system defaults:

  1. Open the Forex Management workflow.
  2. Toggle Enable Modification of Rates on.
  3. Click any rate cell, enter the new rate, and press Enter to save.

You can also modify rates in bulk by exporting the rate table to Excel, making your changes, and re-importing. Any modified rates are displayed in red font, making it easy to see at a glance which rates differ from the system defaults.


Reverting to default rates

To restore all rate tables to system defaults across every period:

  1. Open the Forex Management workflow.
  2. Toggle Use Default Rates on.
  3. Confirm the warning dialog.

Note: This action erases all your manually entered rates and replaces them with system defaults. There's no undo.


Current month rates

During the current month, default exchange rates are supplied using month-to-date data through the previous day's close:

  • Monthly average — Average of daily ending rates, month-to-date
  • Month-end rate — Previous day's ending rate

At month close, the rates settle to the final monthly values.


Rounding behavior

  • Rates sourced from the provider are not rounded. All cross-rate calculations are stored in our database at full precision.
  • For display purposes, rate tables and consolidation workflows show rates rounded to 6 decimal places by default.
  • A toggle at the top of the exchange rate table lets you display the full, unrounded rate used in actual translations.
  • Excel exports of the rate table are unrounded, matching the rates used for actual translation.



A note for users who joined before September 30, 2025

Before this date, default rates weren't provided — you were required to enter rates manually for every period. When we rolled out the default rate system, all your previously entered rates were carried over and are displayed in red font (consistent with how modified rates are now shown).


What you should do:

  • Your historical rates are preserved — no action needed for prior periods.
  • For future periods, you can continue entering rates manually, or switch to using system-provided default rates. Either approach is fine.