Reconciling Facebook bank payments with GivePanel

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