Correcting RGP Stripe Reconciliation where payment was collected with Stripe but not Recorded in RGP

Occasionally there will be a disconnect in the RGP Stripe Custom integration where the Stripe Terminal charges the transaction, but the response from Stripe to RGP is interrupted. This is most commonly due to an internet blip where the connection is interrupted between Stripe charging the transaction and RGP receiving the success message to record it in RGP. 

In the Stripe Custom Reconciliation Reports these payment issues will show as unmatched payments at the bottom of the report.

To correct the RGP reporting and Journal Entries these payments will need to be recorded in RGP. You may first notice there is a mismatch when attempting to transfer to Quickbooks if your debits and credits do not match.

Step 1: Go to RGP Data Entry - Reporting - General Reports - Stripe Custom Reconciliation by Payout Batch Report. Scroll down to the bottom of the report and find the unmatched transaction.

blobid3.png

If you don't find any, go to RGP Data Entry - Reporting - General Reports - Stripe Custom Reconciliation by Payment Report. Scroll down to the bottom of the report to see if there are any unmatched transactions.

 

Step 2: Find the unmatched payment in the payments dashboard at payments.rockgympro.com by searching for the date/amount of the unmatched transaction.
Transaction list with details button.

Step 3: When you find the transaction click View Details and copy the payment intent field

Payment details with amount and status.

Step 4: In the RGP POS ring up the customer (if it was an anonymous transaction you will want to choose an actual customer/test customer to record this payment on) and products that equal the total of the transaction. In some cases, you may need to make an educated guess of what products were sold, or you can create a specific product to use for these corrections. When the total matches the unmatched payment click Tender - then check the box External/Manual Credit Card Mode - Add an optional transaction memo explaining the correction, and then paste the payment intent from the payments dashboard. Then select the card type and click OK.

Payment method selection screen

Step 5: Correct both the Invoice and Payment date in the customer invoice and payment history. In the Invoice Tab, click Change Invoice Date and enter the date the payment was collected. Then in the Payments tab click Change Payment Date and move that to the same date.
Please note you cannot edit Anonymous customers' invoices and payments which is why in Step 4 we recommend creating a placeholder customer for corrections or using your own staff record.
Customer account invoice details screen.

Customer account payment details screen.

Step 6: Rerun the Stripe Custom Reconciliation by Payout Batch Report and the unmatched payment will be corrected. Then reattempt your QuickBooks Journal Entry Transfer and the credit/debit mismatch will be fixed. 

 

This flow will correct payments made with Stripe but not recorded in RGP. If you have a different scenario causing a mismatched payment reach out to RGP Support to explore how to fix that specific issue.

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.