How do I reconcile Stripe payouts?

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.

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 Dashboard ➞ Balances

Use this view to answer questions like...
"What funds are being held in my Stripe account and when will they be paid out?"

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? Please see Delayed Stripe payouts

Stripe Dashboard ➞ Payouts

Use this view to answer questions like...
"What are the amounts I should be receiving in my linked bank account?"

  • Go to your Stripe Dashboard
  • Select Balances in the side menu
  • 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? Please see Delayed Stripe payouts

Bopple Reports 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 your Bopple Back Office
  • Click Reports in the toolbar at top of screen
  • Select Payments By Day from the side menu
  • 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). Scroll down for a description of the columns included.

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 your Bopple Back Office
  • Click Reports in the toolbar at top of screen
  • Select Payments By Order from the side menu
  • 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. Scroll down for a description of the columns included.

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)