Today using the “amount in home currency” to report is broken for us.
We sell in 6 currencies, AUD, CND, NZD, EU, USD, and GBP.
HubSpot in settings, under currency, asks for a conversion rate from your “home currency” to each of the other “non-home currencies” you sell in. This then converts your deal amounts in foreign currency to the “amount in home currency” field for reporting purposes. The field it’self is super helpful, however, it’s not overly useful for companies like us, or for that matter if you are like Spotify, apple or multiple saas companies who sell with rounded numbers, meaning each product level has its own conversion rate.
This is fine if you take the exact exchange rate and always sell in the resulting converted currency amount.
E.g. our home currency is USD, our product is $39 USD per month.
Converted to AUD at our set rate of AUD $1 = USD $0.74
$39/$0.74 = $52.7 AUD
However $52.7 AUD does not fit with our pricing strategy and as such we sell our product in Australia for $49 AUD. All of our final sale pricing in non-home currencies are rounded up or down to be in line with psychological pricing.
This then poses a reporting problem in that each of our products is then reported incorrectly using the field “amount in home currency” based on the one currency exchange rate option within HubSpot.
We need the ability to set product pricing of non-home currencies at the product level and not the global exchange rate set in settings. Or, if available, the ability to have the “amount in home currency” set to reflect the home currency amount in USD rather than using the set exchange rate.
Right now for us, deals reporting is largely broken as we’re summing all currencies into a report.