Understanding & reconciling Stripe payments

This article will help you understand your stripe payments and how to reconcile them.

🗒️ 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?"

🗒️ 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.

mceclip4.png

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 your Stripe Dashboard
  • Select Balances from 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? More information found here.

mceclip5.png

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 your Venue Manager
  • 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). 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 your Venue Manager
  • 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. 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

Screen_Shot_2020-04-22_at_8.00.38_am.png

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)