Stripe - Reconciliation of Online Public Fees

Modified on Mon, 18 Jul, 2022 at 10:31 AM

Reconcile payments to Stripe


Quick Process

  1. Select {Reports} icon
  2. Public Bookings Reports
    • Change date range
    • Date Type
      • Booking Date - Reconcile payments to bank account
      • Playing Date - Reconcile public bookings on timesheet
    • Report to Use
      • Select Online Payments Report
    • Payment Confirmed
      • Yes
  3. Download and Save Report
  4. Access Stripe Interface
    • Transactions
      • Select [Payments]
      • Select [Export all Payments]
    • Transfers
      • Select [Transfers]
      • Select [Export]


Step-by-Step Process


In the MiClub website an online payments report can be generated by going to the reports section of the website and scrolling down to the ‘Public Bookings Reports’ section.



 Recon2


Set the applicable date range, whether you want the report to reference the booking date or playing date and select the Online Payments Report option with payment confirmed set to ‘Yes’.


 Recon2


Select ‘Generate Report’ and this will download an excel file with all the payments made over the selected date range.

Log into the Stripe account and select the ‘Payments’ option.


 Recon4


This will display a list of payments which can be reconciled against the payments displayed on the report produced in the MiClub website. These payments can be exported to excel by selecting the ‘Export all payments’ option.

 Recon7

 

 

Bank Account and Stripe Reconciliation

Log into the Stripe account and select the ‘Transfers’ option.


 Recon9


This screen will display all the transfers which have been deposited into the clubs bank account as well as the next scheduled transaction. To view the individual transactions which make up the transfer select the displayed transfer amount.


 Recon11


Viewing the transfer in more detail will display some key information including the number of transaction, the gross amount, the fees taken out of the bookings and the subsequent transfer total.


 Recon12


This page will also allow you to view the individual transactions which make up the transfer which can be exported by selecting the ‘Export’ option.

 Recon14

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article