Currencies not lining up

[galvanA81]

Hello,

Because of some of hubspots limitations in regards to how it handles currencies; for the time being we set each currency used in the system to be equal to 1 USD (our company currency).

We were looking at a deal pipeline and found the following inconsistency: 

This is happening only on some Deal Stages but on other the values do line up; any idea as to why?

[Shae_Taylor · Accepted solution]

Hi!

What you’re seeing is related to how HubSpot handles exchange rates on Closed Won deals.

Were any of the deals already Closed Won before you set currencies to 1:1?

When a deal moves into a closed stage, HubSpot freezes the exchange rate that was active at that moment. That historical rate is then used to calculate Amount in company currency, and it won’t update even if you later change the system-wide exchange rate (for example, setting everything to 1:1).

So if a deal was closed before you normalized all currencies, it will still be using the older rate. Deals closed after the change will use the new 1:1 rate. Pipeline stage totals sum the “Amount in company currency,” which is why some stages line up perfectly and others don’t.

If you open one of the inconsistent deals and check the Exchange rate property, you’ll probably see that it isn’t set to 1. That’s the value HubSpot is using behind the scenes.

If you need fully aligned totals, you can manually update the exchange rate on those closed deals, but HubSpot won’t overwrite the frozen historical rate automatically.

[RubenBurdin · Accepted solution]

Hi @galvanA81 , you already got the core explanation from Shae, and it’s spot on. The key concept to keep in mind is that HubSpot does not recalculate historical currency conversions once a deal enters a closed stage.

When a deal hits Closed Won or Closed Lost, HubSpot snapshots the exchange rate at that exact moment and stores it on the deal via the hidden “Exchange rate” property. From then on, all rollups in reports and pipeline totals use Amount in company currency, which is derived from that frozen rate. Changing your currency table later to force everything to 1:1 does not retroactively affect those deals.

That’s why the inconsistency shows up only in some stages. Open stages recalculate dynamically using the current exchange rate settings, while closed stages rely on whatever rate was active at close time. If some stages line up and others don’t, it usually means those deals were closed across different moments in time, before and after you normalized currencies.

One subtle detail that trips people up is that even moving a deal back out of Closed Won and re-closing it won’t always fix things unless the exchange rate field itself is updated. HubSpot treats that value as authoritative once set.

If you need absolute alignment for reporting, you basically have three options:

• Manually edit the Exchange rate on affected closed deals.

• Use a workflow to update that property in bulk, knowing this overrides historical accuracy.

• Build reports off the raw Amount field instead of Amount in company currency, if your 1:1 model is purely internal and controlled.

It’s a frustrating limitation, but it’s working as designed. Hope this helps you sanity-check what you’re seeing.

[Shae_Taylor · Accepted solution]

Hi!

What you’re seeing is related to how HubSpot handles exchange rates on Closed Won deals.

Were any of the deals already Closed Won before you set currencies to 1:1?

When a deal moves into a closed stage, HubSpot freezes the exchange rate that was active at that moment. That historical rate is then used to calculate Amount in company currency, and it won’t update even if you later change the system-wide exchange rate (for example, setting everything to 1:1).

So if a deal was closed before you normalized all currencies, it will still be using the older rate. Deals closed after the change will use the new 1:1 rate. Pipeline stage totals sum the “Amount in company currency,” which is why some stages line up perfectly and others don’t.

If you open one of the inconsistent deals and check the Exchange rate property, you’ll probably see that it isn’t set to 1. That’s the value HubSpot is using behind the scenes.

If you need fully aligned totals, you can manually update the exchange rate on those closed deals, but HubSpot won’t overwrite the frozen historical rate automatically.