Skip to main content
Custom exchange rates are used for accounting and reporting when Use custom conversion rate is enabled in Company accounting settings. Open Company > Company Settings > Currency Conversion Rates. The summary shows counts and the latest available dates for Individual Rates and Monthly Average Rates.

​
Choose the correct currency pair and period

The Base is the currency you are converting from; the Target is the currency you are converting to. The rate tells Spacebase how much target currency equals one unit of base currency. For example, a EUR-to-USD rate of 1.05 converts EUR 1,000 to USD 1,050. Reversing the currencies requires a different rate. Individual rates are dated exchange rates. Monthly average rates provide a rate for a whole month when a calculation uses monthly averages. Check which kind your reporting process calls for before importing; the two lists serve different purposes.

​
Individual rates

  1. Click View Individual Rates.
  2. Use Showing rates for to select a date.
  3. Review the Base, Target, Date, and Rate columns.
  4. Use Export Currency Conversion Rates to download the displayed date’s rates.
If your company allows users to edit individual rates, you can click Create Currency Conversion Rate, or select a rate’s row to edit it. Users with permission to manage company settings can also upload a CSV under Import Currency Conversion Rates. The CSV must include these headers:
This example records USD 1.05 per EUR on January 31, 2026. Replace the illustrative rate with your organization’s approved rate and use the currency pair and date your report needs.

​
Monthly average rates

  1. Return to Currency Conversion Rates and click View Monthly Average Rates.
  2. Set the available filters and click Filter to review a specific set of rates.
  3. Click Export Rates to download the filtered results.
  4. To upload rates, click Import Rates, select your CSV, and click Import. This requires permission to manage company settings.
Monthly average imports use these headers:
Importing a rate for an existing currency pair and date, or an existing currency pair and month, replaces that rate. Export the relevant rates before an import if you need a copy of the previous values, and review the results afterward.
If Currency Conversion Rates or the individual-rate edit controls are unavailable, ask your company administrator or Spacebase representative to check your configuration.