If your organization uses a Stripe Express account, Stripe applies a small additional fee to every payout. The Stripe Express fee is $2.25 + 0.25% of the payout amount.
At the moment, this specific payout fee is not itemized in the auto-generated payout report. Custom reporting options are planned for our Dashboard 2.0 update, which we’re aiming to release this year!
In the meantime, you can confirm the payout amount manually using the steps below.
Go to your Payouts page: https://dashboard.betterworld.org/payouts and click the three dots (⋯) next to the payout you would like to reconcile. Then select View details.
2. Scroll to the bottom of the Payout summary page and click the download icon in the top-right corner of the table to download the CSV report of all transactions included in that payout.
3. Open this file in Google Sheets, Excel, or another spreadsheet tool. Here's an example of what the uploaded report will look like (using Google Sheets):
4. Scroll to the bottom of the sheet and create a new row titled Total so you can add or find the sum of the following columns:
Payment total
Fee offset
Transaction fee
Refund amount
Total paid out
Tip: (You can use the SUM formula in your spreadsheet to calculate these totals.)
5. Now, create a small section in your sheet to summarize the total amounts, as shown below.
Gross
= Sum of the Payment total column
Refunds
= Sum of the Refund amount column
Transaction Fees
= Sum of the Transaction fee column
Adjustments
= Any adjustments shown on the Payout Summary page (if applicable). These may include manual adjustments such as partial refunds or fee corrections. See example below. If your payout includes Adjustments, you can click the “i” icon next to Adjustments on the payout page to see additional details.
6. Calculate the Subtotal using this formula:
Subtotal = Gross − Refunds − Transaction Fees + Adjustments
This represents the total amount eligible for payout before Stripe’s additional payout fee.
7. To calculate Stripe’s payout fee, which is $2.25 + 0.25% of the payout amount, you can use this formula:
Payout Fee = (Subtotal × 0.0025) + 2.25
8. Now you can calculate the final payout amount by subtracting the payout fee from the subtotal:
Total Paid Out = Subtotal − Stripe Payout Fee
9. After your calculations, the Total Paid Out amount should match the amount shown on your Payout summary page in your dashboard next to Total paid out.
In our example above, you can see it matches the amount shown on the dashboard:
Done- now that you know how to reconcile a payout, you can use this same process to verify any future payouts!