Skip to main content

What exchange rate does Bob use when adding different currencies in reports?

  • May 30, 2023
  • 7 replies
  • 594 views

Bob uses https://openexchangerates.org/ for currency conversions at the start of every month.

 

7 replies

Terri Lemon Platypus

@Pedro Catarino is there a way for the report field to look at the exchange rates added via Settings > Currencies > Exchange Rates which can be set by the company, as a lot of companies will use a set exchange rate determined by their Finance teams.


Netta Brodsky
Bobber

Hello @Terri Lemon Platypus ,

Thank you for your question!

Unfortunately, Bob does not currently support exchange rate calculations in the way you described. However, you can use the formula feature to calculate salary data using any exchange rate you prefer. 

You can find more information about the formula feature in this Help Center article - Use custom formulas in tables.

 


Hi ​@Netta Brodsky !

We have multiple sites with localization currency that is standard for that country.

When downloading reports for all sites together, is there an option the report to be in only 1 currency (to convert all different-currency amounts in 1 standard currency for reporting)?

Thank you!


Maital Terdiman
Bobber

Hi ​@Marina Petrovska 

When downloading reports for all sites together, there is currently no option in Bob to automatically convert all different-currency amounts into one standard currency for reporting purposes.

I would recommend exploring the formula feature to see if it can assist you in calculating salary data in the relevant currency.

 Additionally, in the settings under Financials - Currencies, you can set a default currency, which may help in reporting, but it does not automatically convert all reports to a single currency


Liv Söderqvist

@Maital Terdiman ​@Netta Brodsky Just following up the last question here from Terri. What is this then? https://help.hibob.com/hc/en-us/articles/21660456966801-Import-exchange-rates#h_01HM78KZBM52SXWGZPSPBFDE9J Is is an update done after Terri asked their question.


Netta Brodsky
Bobber

Hi ​@Liv Söderqvist  😊

Yes, this is a newer update that was released after I originally posted my comment.

It’s also worth highlighting that this feature is available as part of the WFP model, which is a paid add-on.


When generating a historical point-in-time report that includes currency conversions (e.g., converting local base pay to a USD reporting currency), which exchange rate does HiBob use? Does the system strictly apply the exchange rate that was active on the report's historical 'As Of' date, or does it apply the exchange rate active on the actual day the user clicks 'generate'?