How to Interpret a Stripe Report
To find the transactions associated with a payout, you can filter all transactions with the same payout ID. This payout ID will be listed on the payout transaction in the “campaign ID/ payout ID” column as well as in the summary of payouts at the bottom of the sheet.
In some cases, the system won’t be able to logically link transactions to a payout. This can be the case when there is a manual payout. The summary will then show that some payouts couldn’t accurately match the transactions it assumed were linked to it.
To illustrate with a simple example, if there were two donations of $100 each there could be a manual payout of $150 and later $50. But the $150 includes one full donation and half of another donation, and the $50 payout includes only half of a donation. In such a case you can review the transactions to understand the sequence of transactions.
In many cases you will see charges that have a net of 0 since the Charidy fee took the rest of the charge after the gateway fee was deducted. This is due to how the system handles splitting the Charidy fee.
In many cases, there are other payment methods used (including offline donations) that we can’t deduct a fee from directly, so instead of deducting a percentage from each charge, we will keep a balance of the fees deducted until it reaches the full Charidy fee. Similarly, if there was a flat rate fee instead of a percentage, or agreed additional fees (for 3rd party vendors etc.), it will be deducted the same way.
For example, if the fee on a campaign totaled to $10,000, the system will deduct the full amount from each donation as it’s processed until it reaches $10,000. The remaining donations will be processed without deducting any further fee. So if the first charge was $100, the gateway may take $3.20 (2.9% + 30 cents) and Charidy may take the remaining $96.80, and so on from the next donations until the balance of the fee is reached.
Please note that giving days or other events may have a unique fee structure. Please reach out to your campaign manager or email@example.com with any questions.
Page One - Payouts Summary
- Stripe Account - The Stripe account id of the transaction. This will be the same for all transactions on the same tab. For example, acct_1A2AyFEiIkBftAXp.
- Deposit Date - The date on which the payout was available in your bank account
- Payout ID - The unique ID of the payout (deposit) that is associated with this transaction.
- Deposit Amount - The value of the funds which were deposited in your account
- Currency - Currency of the funds which were deposited in your account
- Campaign ID - The Charidy campaign ID that is associated with the funds which were deposited
- Amount for Campaign - If the payout contains funds for more than one Charidy campaign, this shows how much was deposited for each campaign
- Bank Account - The name and number of the bank account which received the funds
- Organization Name - The name of your organization
- Campaign Name - The name of your Charidy campaign
Page Two - Donation Breakdown
- A. Stripe Account - The Stripe account id of the transaction. This will be the same for all transactions on the same tab. For example, acct_1A2AyFEiIkBftAXp.
- B. Transaction ID - The ID assigned by the Stripe gateway. For charges, the ID is prefixed with ch_ and can be linked to the transaction id listed on the donation export that can be generated from the organization dashboard.
- C. Created Date - The date stamp of when the transaction was created. If it’s a charge (donation) then this is the date the charge was captured. This can be different from the date of the donation (which will appear on the donations export) since in many cases a donation is first authorized and only later captured.
- D. Available / Deposit Date - For charges, this is the date the funds become available in Stripe to pay out to a bank. If the Stripe account is on an automatic payout schedule, the deposit is typically sent on this date, though if it’s not a business day, it will be delayed until the next business day. For payout transactions, this is the date the payout was sent to the bank.
- E. Payout Group - The ID of the payout (deposit) that is associated with this transaction. All transactions that are part of the same payout will have the same ID in the payout group field.
- F. Campaign ID / Payout ID - The Charidy campaign id associated with the transaction. In the case of payout transactions, this is the id of the payout.
- G. Payout Type - This lists the type of payout. Typically it will be an automatic payout, but in some cases, there are manual payouts. Automatic payouts are created by Stripe and have a strict association with transactions that are included in the payout. Manual payouts are done by Charidy finance, and may not be directly linked to specific transactions, since it can be an arbitrary amount from the available balance. However, we will try to logically link previous transactions to these payouts.
- H. Net - The net amount of the donation or payout. In the case of charges, the net is the amount after fees have been deducted.
- I. Currency - The currency that the charge was settled in. This is the currency of the bank account listed on the account. The actual charge can be in a different currency, but it will be converted by Stripe to this currency in order to be sent to the bank.
- J. Payout Status - A payout can be in pending or in-transit status before it is actually deposited to the bank. It’s also possible to have failed (for incorrect account information) or have been canceled. This is the status at the time the report was generated.
- K. Transaction Type - The transaction can be a payout (listed as a transfer), one-time donation, recurring donation, charge-back (refund), etc.
- L. Name - The name listed on the card used. It may not always be available.
- M. Donation ID - The donations ID as it’s recorded in Charidy’s system. Not all transactions may have a Charidy ID listed here, specifically recurring donations, since they are handled differently, but the donation ID will be listed in the export from the organization dashboard. You can still match the transaction ID with the donations in the export.
- N. Payment Type - The type of payment method (usually credit card)
- O. Brand - The brand of the credit card used (Visa, Amex, etc.)
- P. Last 4 - Shows the last 4 digits of the credit card used.
- Q. Donated Amount - The amount charged on the card (before any fees or conversion to the bank currency).
- R. Stripe Fee - The fee the gateway deducts for processing this charge.
- S. Charidy Fee - The amount Charidy deducted from the charge toward the total fee of the campaign. This amount is not specific to this transaction, and may not be a specific percentage. See notes.
- T. Refund Charges - The amount refunded, if this is a refund transaction.
- U. Refund Fee - The amount of the fees that were refunded, if this is a refund transaction.
- V. Charge Currency - The actual currency of the charge. For example, say someone donates in EUR and it is converted by Stripe to USD (if that is the bank’s currency). In such a case “donated_amount” would show the USD amount and “charged amount” shows the EUR amount.
- W. Charged Amount - The amount charged in the “charge currency”.
- X. Exchange Rate - If the charged amount was in a different currency from the bank’s currency, this shows the rate Stripe used to convert it to the bank’s currency.
Please sign in to leave a comment.