This article covers a few reports that are available in Stripe that are helpful for your reconciliation reporting. Stripe reports are helpful for reconciliation because they include the total fees assessed with each payment, including both the platform fee and processing fee. In Stripe, you can also access specific payout reports which include the details of funds deposited to your bank account.
It's good to know that in Funraise, you can always view the platform fee with each transaction, this is the fee Funraise assesses to cover platform costs. The processing fee is charged by your payment processor, for example, Stripe or PayPal. Because Funraise does not always know the final processing fee for payments, you'll need to access a payments report from your payment processor to see the full picture.
Funraise Payments is backed by Stripe which means you can log into Stripe to view and access transactions with Stripe's excellent payment reporting tools. At Stripe's documentation, you can learn more about accessing and exporting these reports. Below are two types of reports that may be helpful.
A Stripe payments report can display a filtered list of payments. This report can be helpful to see Fee data and Funraise data with each payment.
The Stripe payout reconciliation report helps you match the payouts you receive in your bank account with the batches of payments included in a payout.
There are many fields included in the Stripe payments and payout exports, including metadata fields from Funraise that contain helpful data for a reconciliation report. Below we've detailed some helpful fields available with each payment in Stripe.
Total amount of the payment in the currency it was submitted
Total amount of the payment when converted to your platform's currency
Total amount of fees assessed with a payment, including both the platform fee and processing fee
Giving Form name
Did the donor cover fees?
Was the donation eligible for Donors Cover Fees?
Is this a recurring donation?
Was this donation marked as anonymous?
Did the donor submit a company match with this donation?
The URL where this donation occurred
UTM parameters captured with this donation
Organization Id + Transaction Id
If this payment included a soft credit, the email address of the soft credited supporter will appear here