Help · Sales
Currencies and exchange rates
Your organization has a home currency. Reports total in it. A deal, a quote, a product or a subscription can be in another currency, and each one keeps the exchange rate of the day its amount was set. Reports then show its value in your home currency, converted at the day's rate.
Your home currency
Your home currency is the currency on Settings, then Organization. New deals are in it unless you choose another one.
Changing your home currency does not change any deal's own amount. Reports convert every record into the new home currency at the rate for the day the record's amount was set.
Where the rates come from
Open Settings, then Currencies and exchange rates. The page lists:
- Your home currency.
- Whether daily rates are read for you. When they are, ContactRoll reads the European Central Bank's reference rates once a day, after they are published in the afternoon, Central European Time. The bank publishes none on weekends and its holidays, so a record saved then keeps the latest rate before it. The bank publishes these rates for information; ContactRoll uses them to show your amounts in your home currency, and moves no money with them.
- Each currency your records use, and the rate a record saved today would keep.
- The rates entered by hand.
When daily rates are not read, or a currency has none, enter the rate yourself.
Enter a rate by hand
Owners and Administrators can enter rates. Anyone in the organization can see them.
- Under Rates entered by hand, type the currency's three-letter code, such as EUR.
- Choose the day. It can be today or a day in the last year.
- Type how much one unit of that currency is in your home currency, such as 1.0825. Use a point for the decimal, with up to 10 decimal places.
- Press Save rate.
A second rate for the same currency and day replaces the first one. A rate entered by hand is used from its day for up to 31 days, until a newer rate comes in. On the same day, a rate entered by hand is used before a daily rate. Every rate entered or removed is in the audit log.
Which rate a record keeps
When a record's amount or currency is set, it keeps the newest rate from that day or the 31 days before it. The record keeps the rate, the rate's date and where it came from: a daily rate, or one entered by hand.
The record keeps that rate when you change its name, stage or anything else. It takes the day's rate again only when its amount or currency changes.
If there was no rate for that day, the record keeps none. Reports then look for a rate for that day each time they run. If you enter a rate for that day later, reports use it.
In reports
In the report builder, deals have Value in your home currency and Value at the stage's probability in your home currency. Both say "converted at the day's rate". A deal with no rate for its day is left out of these totals. Its own amount is still counted in its own currency under Value.
A deal's page also shows its value in your home currency, the rate and the rate's date. If it has no rate, the page says so.
The arithmetic
Amounts are never rounded along the way. An amount is multiplied by the exact rate and rounded once, to the nearest cent, or the smallest unit of the currency. An amount exactly halfway is rounded away from zero. A rate worked out between two currencies through the euro is kept to 10 decimal places.
In your export
The organization's export keeps both amounts. Each deal, quote, product and subscription has its own amount and currency, the day, the rate, the rate's date, where the rate came from, your home currency of that day and the converted amount. The rates entered by hand are in the export too.
Didn’t find what you needed? Ask us on the help center: the form is at the foot of its page, and the people who build ContactRoll answer.