TCV and ACV in company currency

Status: Idea Submitted

Hi,

Currently the TCV and ACV are default HubSpot properties displayed in deal currency.

It would be great if the tool had a property just like ‘Amount in company currency’ to convert the TCV and ACV into the company currency.

Thanks,

Reshma

@hubspot how could I do ACV in my company currency, do you have a shortcut?

Hi,

Yes there is an alternat route untill HS creates that property.

I created 2 properties -

  • Annual ammount in company currency = Annual contract value * Currency conversion rate (Field type - Calcualtion)
  • Currency conversion rate - Workflow (Field type - Unformatted number)

Workflow

Enrollment trigger = Deal currency is known (Activate re-enrolment option)

Create a branch for each currency option using If/Then branch

For each currency add the corresponding conversion rate as a fixed number to the property Currency conversion rate

You can get the rates from Settings > Account Defualts > Currency. Just copy-paste the rates under Excahnge rate coloumn

Thats it!

The only issue with this approach is that it wont follow same rule as ‘Ammount in company currency’ mentioned below here:

If a deal has a closed status and a specified Close date, the property will use the exchange rate that was in effect at the specified Close date. If no exchange rate was in effect at the time, then the property will use the exchange rate in effect at a time closest to the Close date.

This means there will be cases with the Ammount in company currency shows values based on past exchange rates.

Hope this helps.

Thanks,

Reshma