Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

Will DoCurrencies affect the value of my closed deals?

If I install DoCurrencies, will the amount of a deal remain fixed once it is closed, or will it fluctuate with changes in the currency exchange rate?

ANSWER:

DoCurrencies uses HubSpot's default behaviour to manage Deals using the latest up-to-date portal rates. 

When Deals are open in your pipeline, their value changes every day based on the current exchange rate in your portal. If your portal updates rates daily, the Deal's value will display the current value of that Deal, until it is finalised. Once the Deal is closed, the portal saves the exchange rate from that specific day, locking the Deal's value.

HubSpot's default behaviour:

  • Open Deals are displayed in Company Currency value, based on the current exchange rates in your portal
  • Closed Deals are updated with the exchange rate of the date that the Deal is closed-won or closed-lost.

DoCurrencies updates your HubSpot Portal Currency Rates each day, It has no permission to change any properties in your closed Deals.

However, if you have many closed Deals with incorrect rates, we have developed a Historical Rate Lookup App designed for one-time use, which you can run in a workflow for updating rates on older closed Deals.  To use this one-time tool, enrol the closed Deals in your workflow. The App then looks up the historical rate for that Deal currency on the Deal closed date. The workflow then replaces the Deal exchange rate with the correct historical rate.

There is an additional cost for running this workflow because it must look up the rate for each Deal for a set date, which could be thousands of lookups, depending how many closed Deals you need to "fix". Please contact support@hubdo.com for more information about our "Historical Rate Lookup App".

The HubSpot Help Document:

Exchange rate property on Deals

For Deals using a currency other than the company currency, the Exchange rate property is calculated as follows:

  • For open Deals, HubSpot automatically updates the Exchange rate value based on the most recent exchange rate you've set for the currency, and the property cannot be manually edited.
  • Once a Deal is closed, the Exchange rate value will not be automatically updated based on your set exchange rate, historical exchange rates, currency code changes, or updates to the company currency. A closed Deal's Exchange rate will be set based on the exchange rate in effect at the time of closing. Moving forward, users with Super Admin permissions or the 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.

Customer Use Case 

Here are examples of customer requests HubDo has solved using custom coding:

1. Customer Request:

Use Case - Subscriptions

Our customer needed their 'subscription customers' cost updated by the daily exchange rate - i.e the 'close won' Deals for customers on a subscription.

Situation: If the subscription is in a different currency, the exchange rate is to be updated in that 'closed' Deal so the reporting value of active subscriptions is up-to-date when viewed in the company currency. 

Usually HubSpot does not touch the exchange rate on 'Dals won' or 'Deals lost', so we had to change HubSpot's default behaviour.  HubSpot usually stores the exchange rate in the Deal on the day it closed. In this case, our customer wanted to override that behaviour because they wanted their active subscriptions to stay updated.

HubDo solved this by creating a custom code in OpsHub to insert the current exchange rate into the right Deals.

 

2. Customer Request:

Use case: Update exchange rates in my old Closed Won and Lost Deals based on the day they closed (One time data cleanup)

This customer needed old Deals updated to the correct amount based on the exchange rates on the day the Deals were closed. 

HubDo solved this be creating custom code to pull the archived exchange rates from the dates the Deals were closed. The code applied each rate to the closed Deal. The customer was then able to see and report on the correct value of the closed won/lost Deals.

Going forward, HubSpot with DoCurrencies is keeping all their new Deals up to date as they close, per the exchange rates on the closed date.

 

3. Customer Request:

Will DoCurrencies update my product prices? 

Use Case: Update product library prices in other currencies, for products bought in other currencies e.g. buy in USD$, sell in CAD$


Situation: For the products the customer purchased in USD$, DoCurrencies needed to update the selling price into CAD$. 

HubDo created a custom code automation in Operations Hub to update only the products bought in USD$ and sold in CAD$ (not all products - just s sub-set of products), with the correct exchange rate value each day.


4. Customer Request:

Can DoCurrencies update ALL my product prices? 

User Case: Update ALL product library prices in other currencies, based on the price in my company currency.

This customer operates in EURO and sells products in GBP£ and USD$. Their 1000's of products are sold via an Ecommerce website which updates HubSpot but their product library in HubSpot needed updating daily.

HubDo solved this using custom code to update the full product library daily, based on looking at the EURO price of every product. It then calculates the selling price in USD$ and GBP£ rates based on the EURO exchange rates updated daily.