This article will walk through how to reconcile payments in the Stripe Admin area.
Required Access:
You will need the Stripe Administrator or Administrator access level.
Where to Go:
To get to the Reconcile page in Stripe Admin, follow these steps:
- From the home page, hover your mouse over Admin
- Go to Member Management
- Click Stripe Admin
- Click the arrow next to Administration (Transactions) in the bar at the top of the page
- Click Reconcile
Creating Batches:
- On this page, you'll see any Batches that have been created by your organization.
- Click the + at the top right of the table.
- Enter a Batch Name - usually something descriptive like September 2023.
- Enter a Start Date and an End Date. (The End Date should be in the past and currently ends at midnight)
- For Group by, you can use Transaction Date or Payout Date, which will filter your transactions based on these dates. Transaction Dates will be based on when the transaction was purchased and Payout Date is when these transaction will be paid to your bank account from Stripe.
- Take note, transactions can't overlap dates. You can only have one set of dates per batch. i.e. If you create a batch for September 2023 where the date range is 9/1/2023-9/30/2023 and group by Transaction Date, this equals one batch. If you try the same thing for Payout date, the results will not be accurate.
- Click Add.
Viewing and Exporting Batches:
- Once your Batch has been created, click View in the Action column to see the Batch Details.
- If you need to export the Batch, click the Export button to have the system generate an Excel file (.XLSX) with the same information.
- Take note, if you notice any missing transactions in your batch, you should extend the end date.
- i.e. If you created a batch from 9/1/23-9/30/23, set the end date to 10/1/23 because of the way the system reads the payment at midnight the next day. There are plans to improve this in the future.
- Take note, if you notice any missing transactions in your batch, you should extend the end date.