Stripe Reconciliation Report

Stripe Reconciliation Report

Purpose


The Stripe Reconciliation Report helps you reconcile your Stripe payouts to the transactions recorded in Rental Car Manager. Any transactions found in Stripe that are missing from RCM will be highlighted for you to manually match/reconcile. RCM transactions that are not found in Stripe will also be highlighted for you to review.

If you require access to the Stripe Reconciliation Report, please email RCM Support at support@rentalcarmanager.com.

Accessing the Stripe Reconciliation Report

Reports > Other Reports > Stripe Reconciliation Report

Reconciling a Stripe Payout

Upon opening the Stripe Reconciliation Report a list of unreconciled Stripe payouts will be displayed containing the payout created and arrival dates, payout amount and a “Reconcile” button.

To begin the reconciliation process for a payout, click on the “Reconcile” button. Payouts must be reconciled in order; you cannot reconcile a payout until the previous payout has been reconciled.

The more transactions there are in a payout the longer the transaction matching process will take as each transaction must be matched to a Stripe payment/refund in RCM.

Once the matching process is complete the payout details and any transactions that need to be reviewed/reconciled will be displayed.

If all transactions have been matched to a Stripe payment/refund in RCM a success message will be displayed. You can then click the “Reconcile” button to mark the payout as reconciled in RCM.


If there are unmatched transactions, they will be displayed to be manually reconciled. The payout cannot be marked as reconciled until the unmatched Stripe transactions are resolved. You can still reconcile a payout if there are unmatched RCM transactions.


Please see the "Reconciling Unmatched Stripe Transactions" section for information on dealing with unmatched Stripe transactions. Unmatched RCM payments can be deleted in situations where the payment recorded in RCM is incorrect or was never successfully processed by Stripe.

Reconciling Unmatched Stripe Transactions

Clicking on the “Reconcile” button for an unmatched Stripe transaction will open a pop-up containing details about the transaction and two methods of reconciling the transaction. 


Reconcile Method 1: Match to Existing RCM Payment/Refund

Clicking on the “Search for matching RCM payments” button will load any RCM payments/refunds that potentially match the Stripe transaction using the following criteria:
  1. Matching payment amount.
  2. Hasn’t already been matched to another Stripe transaction.
This will include any potential RCM payments/refunds that were manually recorded or have a different Stripe identifier to the transaction being reconciled. 
If the list of returned RCM payments/refunds contains a matching transaction you can click on the “Select” button to mark it as a match and click “Reconcile” to mark the Stripe transaction as reconciled. 

When no matching RCM payments/refunds are found a warning message will be displayed along with a refresh button. In this situation you may be able to use the transaction details at the top of the pop-up to find the correct reservation, manually record a payment and refresh the pop-up to display the newly added RCM payment/refund.

Reconcile Method 2: Manually reconcile transaction

You can also tick the “Manually reconcile transaction” checkbox to mark the Stripe transaction as reconciled without matching it to an RCM transaction.

    Important Articles


      • Related Articles

      • Stripe Subscriptions

        Purpose You are able to set up automated, recurring payments through Stripe known as Subscriptions. This allows you to automatically invoice and charge a certain amount of money from a customer a certain number of times, or recurrences. These are ...

      • Stripe User Guide

        Overview Rental Car Manager integrates with Stripe to allow you create payments and refunds from within RCM. Payments can be created from either the Booking Details page or from the Booking form: From the Booking Details page: From the Booking ...

      • Sept 2023: New - Stripe Subscriptions

        RCM now allows you to set up Subscriptions through Stripe. This feature is available to all customers with Stripe Accounts connected to RCM, please contact support@rentalcarmanager.com to set up Stripe Subscriptions in your RCM system. This feature ...

      • Stripe Connect Onboarding

        Purpose: Rental Car Manager has partnered with Stripe to make their platform the default payment processing option in RCM. To use the Stripe integration in Rental Car Manager you will need to create your own Stripe Connect account which is linked to ...

      • New - Stripe Unlinked Refunds

        RCM now allows for the processing of unlinked refunds for customers using Stripe. Unlinked Refunds are: A refund separate from any charge - they can be processed for an unlimited amount with or without a prior payment. Processed immediately and ...