Beacon

Working with money in multiple currencies

Updated 2 years ago

If you're getting paid or applying for grants in multiple countries, there's a good chance you're working with more than 1 currency. In a world where exchange rates are constantly changing - this can get confusing, and fast!

In Beacon, you can store money in any currency that you like:

Screen Recording 2018-05-05 at 03.14 pm

Tip: every account has one primary currency. You can enable as many secondary currencies as you like.


Enabling secondary currencies

To save amounts in currencies different than your account's primary currency, first you need to enable secondary currencies:

1) Visit the Charity Preferences page.

2) Click the secondary currencies dropdown:

Screen Shot 2018-05-05 at 15.11.04

3) Choose the currencies that you'd like to enable:

Screen Shot 2018-05-05 at 15.11.23

4) That's it! You can now save currency fields in any of your secondary currencies, as well as your primary currency.


Filtering records in multiple currencies

When filtering records in Beacon, it's possible to filter based on currency fields.

For example, if your primary currency is British Pound (£), you can view all payments over £10 with this filter:

Screen Shot 2018-05-05 at 15.20.56

Secondary currency values are handled automatically. Beacon stores a "primary currency value" for values stored in other currencies, based on real-time exchange rates.

This means that a donation of $20 would also appear in your filtered payments. (The £ equivalent is £14.78, at the time of writing)


Reporting in multiple currencies

When running reports in multiple currencies, Beacon shows currency values in your account's primary currency:

Screen Shot 2018-05-05 at 15.33.44

Values in other currencies are also stored in your account's primary currency, based on real-time exchange rates. This enables Beacon to report accurately on payments.


Other considerations when working with multiple currencies

Roll up fields

Rollup fields enable you to summarise data that happened in related records in the "parent" record. For example, the total amount a person has paid you from all their payments.

Rollup fields do not support rollups in multiple currencies. For your rollup value to appear correctly, all currency values "rolled up" should be in the same currency.

Smart fields

Smart fields with currency fields let you create formulas based on other data stored in a record. For example, the total amount that someone still owes you.

Similar to rollup fields, currency smart fields do not support multiple currencies. All values stored on a record must be the same currency for smart fields to calculate correctly.

Conversion rates

When any currency value is stored, the value in your account's primary currency is also saved behind the scenes. This is based on real-time (daily) exchange rates provided by OpenExchangeRates - using the record's created date as the date to determine the correct rates.

This is more than sufficient for most CRM needs - but it might not be for your finance/accounts team. Feel free to reach out to us if you'd like to discuss this in more detail.

close

Contact Us

It'd be great to hear from you! To reach out, fill in your details below and we'll get back to you.

close

Register for webinar

To join this webinar, please enter your details below and we'll send you details on how to join.



close