Stripe Custom Payout Reconciliation Reports

(In Beta 9/1/2022 - Cloud Release 9/27/2022, General Release to local installs will be a few weeks later)

Please note that once your database is updated to version 133928 it can take a few days for RGP to backfill the matches on these reports.
--------------------------------------------------------------------------------------------------------------------


Stripe batches out their day for payouts at midnight Universal Time (12 am UTC) this can cause confusion reconciling your Stripe Custom payouts to your sales reports in RGP showing payments made in your local 24-hour time period.

  • From 2012-2022, facilities have used RGP's Stripe Reconciliation Report to break up Stripe Payments into split days (local 24-hour time periods) for reconciliation with their Stripe Payouts. It's helpful but imperfect. There historically have been issues with refunded payments being applied to earlier payout deposits that can throw off the numbers from matching.

  • These new Stripe Custom Payout Reconciliation Reports allow you to quickly and easily reconcile your RGP payments to your Stripe Custom deposits. There are 2 new reports one lumps all the payments included in your Stripe Custom payout and then matches to your RGP Payments. The other reports on your local 24-hour time and matches all your RGP Payments to payments included in your Stripe payout deposit.

  • Any payments (on either side) that do not match/throw off the reconciliation are easily identified at the bottom of each report.

  • These reports can be scheduled to be automatically emailed on a set schedule.

Please note these reports only show for facilities using the RGP Stripe Custom integration. If you'd like more information about switching your database to the new payment integration please reach out to support@rockgympro.com for more information.

------------------------------------------------------------------------------------------------------------------

By Payout Batch Report: 

This report shows payments made with your RGP Stripe Custom account by payout batches (24-hour UTC). The Payout Batches will match your payout deposits from your RGP Stripe Custom account.  

Ideally, each payment will match a payment paid out from your Stripe Custom account.

If this report cannot match a payment by the transfer ID, it will appear at the bottom of the report as an unmatched payment. You can then investigate those payments to see if an error occurred. If you cannot figure out why a payment is unmatched, please reach out to support@rockgympro.com  
 
Description of Report Columns: 
Stripe Transaction = transaction ID can be used by RGP Support to troubleshoot any issues 
Stripe Payment Date = Date Payment was made 
Trans Type = payment or refund 
Stripe Amt = Gross Revenue per transaction 
Fee = Fees Stripe took for each transaction 
Net = Net Revenue deposited per transaction 
Transfer ID = what ties Stripe Payments to RGP Payments 
Payment ID = RGP Payment ID on each transaction  
RGP Payment Date: Date Payment was recorded in RGP (local time) 
Source = Was the transaction Online, POS, or through Billing 
RGP Amt = Gross Total Sale in RGP Data 
Rpt Fee = Reported Fee from Stripe Custom 
RGP Net = Reported Net Sale in RGP Data 
Description = Customer information, online purchase information 

 By Payout Batch Report Example:
mceclip0.png

-------------------------------------------------------------------------------------------------------------------

By Payment Report: 

This report shows payments made in your RGP Database in your local 24-hour time zone. The daily totals will match your Journal Entry Report for Stripe Custom Gross Sales. 

Ideally, each payment will match a payment paid out from your Stripe Custom account.

If this report cannot match a payment by the transfer ID, it will appear at the bottom of the report as an unmatched payment. You can then investigate those payments to see if an error occurred. If you cannot figure out why a payment is unmatched, please reach out to support@rockgympro.com  
 
Description of Report Columns:  
Payment ID = RGP Payment ID on each transaction  
RGP Payment Date: Date Payment was recorded in RGP (local time) 
UTC Date = UTC Date Payment was recorded 
Source = Was the transaction Online, POS, or through Billing 
RGP Amt = Gross Total Sale in RGP Data 
Rpt Fee = Reported Fee from Stripe Custom 
RGP Net = Reported Net Sale in RGP Data 
Description = Customer information, online purchase information 
Transfer ID = what ties Stripe Payments to RGP Payments 
Stripe Transaction = transaction ID can be used by RGP Support to troubleshoot any issues 
Stripe Payment Date = Date Payment was made 
Trans Type = payment or refund 
Stripe Amt = Gross Revenue per transaction 
Fee = Fees Stripe took for each transaction 
Net = Net Revenue deposited per transaction 
Payout ID = Stripe Payout ID can be used by RGP Support to troubleshoot any issues 

 By Payment Report Example:

mceclip1.png
 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.