Facebook has had some issues with the data they are sending charities in the transaction report / Reporting API.
Although we can’t change this at GivePanel, we do try our best to help you solve these problems. This glitch means that some donations are being converted randomly to different currencies, such as US dollars. The result is that some donations present themselves as dollars in the transaction data. This is causing lots of issues with reconciliation for the charities that we are working with. We update Meta regularly on the impact this will be having.
For example, the Facebook data that has been uploaded into your GivePanel account could look like this;
£58,107.77
$21,108.92.
This will make it very hard for you to reconcile the amount received in your bank account and the amounts that appear in GivePanel. The amount in your bank account will be a combination of donations in pounds (GBP) and dollars (USD), but all converted into your usual currency.
To achieve this single payment, Facebook will have automatically converted the donations that have appeared in dollars at the exchange rate at that time. The exchange rate value isn’t a number they share in their reports.
The first step is to identify which donations have been affected. To do this create a donations report in report builder and include the ''donation currency' field to the report. You will then be able to see which donations are in USD and which are in GBP.
You will then be able to isolate which donations have the currencies that are unusual to your normal currency.
The next step will depend on your internal finance processes. You will be able to show the Finance team which donations have been converted and then make a calculation using the exchange rate for that day, based on the differing amounts between your bank account and the GivePanel amount.
Facebook have shared the exchange rate they used for the dates this issue was impacting the transaction data.
Note from Meta: this is the closest approximation of currency conversion they were able to share.
Download Table Below:
GBP / Dollars
Euros / Dollars
Date | Currency | Currency | Conversion |
2022-11-07 |
USD |
GBP |
0.8883840025 |
2022-11-08 |
USD |
GBP |
0.8775775462 |
2022-11-09 |
USD |
GBP |
0.885012675 |
2022-11-10 |
USD |
GBP |
0.8800728959 |
2022-11-11 |
USD |
GBP |
0.8800728959 |
2022-11-12 |
USD |
GBP |
0.8800728959 |
2022-11-13 |
USD |
GBP |
0.8800728959 |
2022-11-14 |
USD |
GBP |
0.8565882481 |
2022-11-15 |
USD |
GBP |
0.8543696747 |
2022-11-16 |
USD |
GBP |
0.8477537087 |
2022-11-17 |
USD |
GBP |
0.8527277738 |
2022-11-18 |
USD |
GBP |
0.8459658023 |
2022-11-19 |
USD |
GBP |
0.8459658023 |
2022-11-20 |
USD |
GBP |
0.8459658023 |
2022-11-21 |
USD |
GBP |
0.8515691763 |
2022-11-22 |
USD |
GBP |
0.8489019402 |
2022-11-23 |
USD |
GBP |
0.8448966737 |
2022-11-24 |
USD |
GBP |
0.8326202773 |
2022-11-25 |
USD |
GBP |
0.8318605243 |
2022-11-26 |
USD |
GBP |
0.8318605243 |
2022-11-27 |
USD |
GBP |
0.8318605243 |
2022-11-28 |
USD |
GBP |
0.8400836575 |
2022-11-29 |
USD |
GBP |
0.8398022461 |
2022-11-30 |
USD |
GBP |
0.8429081802 |
2022-12-01 |
USD |
GBP |
0.8328968954 |
2022-12-02 |
USD |
GBP |
0.8265127026 |
2022-12-03 |
USD |
GBP |
0.8265127026 |
2022-12-04 |
USD |
GBP |
0.8265127026 |
2022-12-05 |
USD |
GBP |
0.8248131782 |
2022-12-06 |
USD |
GBP |
0.8271262471 |
2022-12-07 |
USD |
GBP |
0.8285613997 |
2022-12-08 |
USD |
GBP |
0.8252883401 |
2022-12-09 |
USD |
GBP |
0.8217042462 |
2022-12-10 |
USD |
GBP |
0.8217042462 |
2022-12-11 |
USD |
GBP |
0.8217042462 |
2022-12-12 |
USD |
GBP |
0.8215696068 |
2022-12-13 |
USD |
GBP |
0.8189529294 |
2022-12-14 |
USD |
GBP |
0.8127140465 |
2022-12-15 |
USD |
GBP |
0.8251525237 |
2022-12-16 |
USD |
GBP |
0.8276723853 |
2022-12-17 |
USD |
GBP |
0.8276723853 |
2022-12-18 |
USD |
GBP |
0.8276723853 |
2022-12-19 |
USD |
GBP |
0.8276040786 |
2022-12-20 |
USD |
GBP |
0.8300015411 |