Amounts received in your bank account may not be equal to the total value of orders made on a particular day of trade as shown in your POS (or in any reporting that uses your venue's local time). This is due to the way Stripe groups payments for payout (as explained in When and how do I receive my customers payments?).
Once you're clear on the timing and processing of Stripe's payout processes, you may want to dig deeper to understand the makeup of each payment, or find answers to other questions about the funds received.
Below you will find an outline of some reports that can be useful when reconciling.
Stripe view: Balances
Use this view to answer questions like...
"What funds are being held in my Stripe account and when will they be paid out?"
- Go to Stripe Dashboard
- Select Balances
Here you can see a quick overview of what funds are being held in your account, when you can expect to receive your next payout, and whether there are any recently paid out amounts on their way to your bank account.
📢 Not receiving payouts? More information found here.
Stripe view: Payouts
Use this view to answer questions like...
"What are the amounts I should be receiving in my linked bank account?"
- Go to Stripe Dashboard
- Select Balances
- Select Payouts
The amounts shown here will match directly with those received in your bank account. Use the Export option for more detailed data. You can also drill down into each payout to see all the individual payments included, along with the fees applied to each.
📢 Not receiving payouts? More information found here.
Bopple report: Payments By Day
Use this report to answer questions like...
"How much have I paid in fees for the past X days/weeks/months?"
- Go to Back Office
- Select Reports
- Select Payments By Order
- Enter the desired date range and select Group By: Arrival Date
- Click Run report
The daily totals in the Payment Due column should correspond with the amounts received in your bank account. If there is any slight discrepancy, it will balance out the following day (this would be due to subtle variations in Stripes processing times). View a description of the reports columns here.
Bopple report: Payments By Order
Use this report to answer questions like...
"What orders were included in the Stripe payout I just received in my bank account?"
- Go to Back Office
- Select Reports
- Select Payments By Order
- Enter the desired date range and select Group By: Arrival Date
- Click Run report
This report groups the individual orders using Stripe's timezone so that you can understand the makeup of each Stripe payout received in your bank account. View a description of the reports columns here.
Exporting report data from Bopple
You can export raw data from Bopple Reports using the small icon in the upper right corner of screen, shown below. Click this and then select Excel or CSV
Bopple reports glossary
| Column | Description |
| Trading Date | Day the order was made in your venue's local time |
| UTC Date | Day the order was made in UTC time |
| Arrival Date | Expected arrival date of the payout from Stripe |
| Order Amount | Total value of orders (before discounts) |
| Discount Amount | Total value of discounts on orders |
| Payment Amount | Total paid by customer (after discounts) |
| Payment Fee | Total fees applied to the orders (Bopple Payment Rate & any other fees) |
| Payment Due | Payout due (total for each day) |