Working with money in multiple currencies

Updated 2 months ago

help_outline Heads up! This is a guide for admins. If you're not an admin yet, ask your Beacon admin to promote you so you can start managing fields.

If you're receiving payments from 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:

switching multiple currencies

help_outline Every account has one primary currency. You can enable as many secondary currencies as you like.

link 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:

Screenshot 2020-01-21 at 17.00.19

  1. Choose the currencies that you'd like to enable:

Screenshot 2020-01-21 at 17.00.39

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

link 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:

Screenshot 2020-01-21 at 17.02.10

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)

link Reporting in multiple currencies

When creating charts 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.

link Other considerations when working with multiple currencies

link Forms

If you have multiple currencies enabled, Beacon lets you take single and recurring donations in any of them.

When you create a form, the currency will default to your account's primary currency. In the form settings, you can change this to any other currency you like:

Screenshot 2020-05-28 at 12.44.36

Screenshot 2020-05-28 at 12.44.41

link 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.

link 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.

link 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 payment date (if the record is a payment), and created date for all other records 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.


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.


Register for webinar

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