Currently when you close a deal the Amount in Company Currency property stops updating, so if you move a deal to closed won and the exchange rate is updated the next day, the conversion to company currency on that deal doesn’t update which means your reporting is incorrect.
This is a big challenge for any business who needs to reporting acorss currencies.
This feature would allow for dashboard revenue reporting in HubSpot to reconcile to other financial systems, and ensure that the reporting is accurate. Currently the rates have to be manually updated every day, and unless the dels are closed in HubSpot on the same day as they are invoiced that rates will be out of sync and the rpeorting unreliable.
Guidance should also be provided on what rates to use. We are using HubSpot in the UK and originally set up our USD:GBP rates in the standard way (e.g.1.4) when we should have been using the inverse (0.714), so ur reporting in Hubspot is wildly inaccurate and of little value.
We need this too! Also adjusting the exchange rate for closed deals. Due to the fluctuation, you can’t influence this now, so the financial reporting is not correct :(.
Hi,
I have just inherited a Hubspot system where all retrospective deals have been pulled in from Salesforce and had the wrong (reverse) exchange rates on. I cannot get any sensible attribution data from the system and have the nightmare of reporting from Salesforce (urgh)
It would be foolish of me to try to move the deals back then to Closed Won again without fear of destroying all company attribution on the other platforms we use. Netsuite, Salesforce etc.
There must be a way of implementing a re-calculate company currency on past Deals.
I have deals worth millions that are worth the 1/100 and a system that has 10 months of useless deal amount data. A simple re-calculate button could fix this!
Please, can someone in @hubspot help with this.
Thanks,
Rob
+1 for this.
With the current fluctuations in currencies, we are struggling to reconcile our hubspot contract data to what we report on and calculate commission on outside of hubspot.
We manually recalculate contract values to the spot rate at the beginning of each quarter to get the true ACV value for those contracts not in USD (our base currency). However as we have not done this in HubSpot at the beginning of each quarter, we can no longer edit the exchange rates.
Clicking through to Settings>Account Defaults>Currency>GBP Actions>View currency history>Exchange rate history and actions edit does not solve this problem for us as the effective dates for historical exchange rates can’t be edited.
Ideally we would like to edit the effective dates or have this changed for us by developers.
It would also be useful to have an automatic workflow to update the exchange rates every period (for us the 1st of each quarter). By having to manually update this could lead to incorrect effective periods (e.g the 1st of the month falls on a saturday, this won’t be updated until Monday)
The lack of currency flexibility is really limiting our reporting capabilities from HubSpot. We are having to export to Excel and manually use exchange rates there to match what we use for reporting.
It would be really helpful to be able to edit the “effective dates” on currencies in settings the same way that the rate itself can be edited. For us, we generally use a fixed rate for each quarter - but if this isn’t done on the 1st of the month (e.g. if weekend, someone on holiday), then there is no way to backdate the change.
Please help up get this into a Beta at least! Agree with all the comments above. We had this functionality with the previous CRM we were using and now that we are upgrading to Hubspot, this is not possible, not even through a back end solution by the dev team. This is frustrating. Running external reports and not be able to integrate to the analytics, while at the same time having to deal with incorrect historical data that was synced from the previous CRM is not ideal to say the least..
This is a major pain point in many migrations to HubSpot. Please enable changing and importing exchange rates retroactively.
I accidentally put the exchange rate backwards, 10:1 instead of 1:10. When I discovered this some months later I corrected it… but al deals closed in the period before I noted the error are TOTALLY wrong. 5 million EUR instead of 50k Euro.
You can edit the rate back in time if you click on history and then edit
Thanks, I eventually discovered this.
However, editing the exchange rate back in time only applies to NEW Deals that you Close in the applicable date range. It does not retroactively change old Deals that were closed in this period.
The solution in the end was to create a new Deal so the amount was correct in all currencies… then merge the old Deal into the new Deal to capture all the Notes, Conversations, etc that had been logged on the Deal.
Hi @Shiran, thanks for sharing! That is correct--the system only updates the exchange rate property for open deals. If you’re using the automated exchange rate feature, once a deal closes, the system will capture the exchange rate that was in effect on the deal’s close date. No further updates will be made to the exchange rate after that; however, admins can edit the exchange rate property for any closed deals.
This was an intentional design, while still offering flexibility for admins to set the rate as they see fit after a deal closes. Here’s the section of the Knowledge Base article that addresses this:
For deals using a currency other than the company currency, the Exchange rate property is calculated as follows:
multi-currency-write scope can manually update the Exchange rate value on individual deals or for multiple deals in bulk. The value can also be updated via workflows, integrations, or API calls that do not check for a user ID.