Multi-Currency Tracking

Does your nonprofit operate in, or receive gifts from, different countries? If so, you can use this module to track donations received in multiple currencies. Local users can track, manage and report on fundraising efforts using their local currencies, while headquarters can use DonorPerfect Online’s integrated currency conversion table to automatically convert the amount of the gift or pledge to their home currency.

How it Works for Gifts

Multi-currency tracking is set up at the user level. For example, if William in the United Kingdom logs into DPO, he will enter gift data amounts in British Pounds. When Mary, working at headquarters in the United States views the data, she will see both the original gift data in Pounds, and the converted amount in US Dollars.

In order to calculate the converted value of a gift, DPO looks at three elements of the transaction:

Gift Date

Amount

Currency

Using a combination of these three fields, the system will check the integrated currency conversion table and convert the amount of the gift (as of the gift date) to your home currency.

How it Works for Pledges

Due to daily exchange rate fluctuations, and the fact that most nonprofits just want to see how much an entire pledge is worth in another currency, only the Pledge Total is converted. The following fields are shown in their original currency:

Billing Amount

Balance

Write-off Amount

Delinquent Amount

Commonly Asked Questions

As part of the module, DPO will be providing an automated process that populates an integrated currency conversion table using data from a 3rd party source. You will be able to review the exchange rates being used right in DPO.

In addition to pledges and gifts, will total amounts also be converted automatically?

Although DPO has several standard “aggregate total” fields, these cannot be converted automatically — because of fluctuations in exchange rates, and because different users might have a different base currency. However, it is possible to calculate aggregate amounts to a particular currency using DPO’s Calculated Fields module and User Defined Fields.

Is there anyway to filter on converted gift amounts?

You may, for example, wish to set a selection filter on all received gifts that have the equivalent value of greater than $50 CAN. To do this, you can create a new field on the gift screen (called AMOUNT_CAN) and create a subsequent conversion of that amount using the Calculated fields module. Since this converted amount is now stored in the database, it can be used in selection filters and custom reports.

Can I report on converted currency fields?

Yes! Any Financial Report that includes actual gift detail records (for example, Solicitation Analysis, Multi-Year Trend, etc.) will perform an on-the-fly conversion of the gift records to the user’s currency. This means that if the user is a US Dollar user, every report he runs will be displayed in US Dollars regardless of whether a gift was made in another currency. Likewise, if a user is a British Pound user, all reports will display in British Pounds.

Benefits

Obtain better insights on local fundraising efforts by tracking original currency data.

Eliminate errors and save time by automating the conversion of multiple currencies to your base (or home) currency.