Reconciling payments and refunds with Stripe
You may need to reconcile payments and refunds with Stripe for accounting purposes. The Transaction_id is recorded in both Recharge and Stripe and can be used to link Recharge with your payment processor.
- Migrated Shopify Checkout Integration
- This applies to customers that are billed through Recharge. For customers that are billed through Shopify, you can refer to Issuing a refund through the Shopify Checkout Integration.
- Recharge Checkout on BigCommerce
Reconcile Recharge charges with Stripe
Step 1 - Export your Recharge store data
- Click Tools & apps in the merchant portal and select Exports from the dropdown.
- Click Create export and select the Charges - Processed export from the dropdown.
- Select the date range for the time period you need.
- Under Select your columns, Recharge preselects the most relevant columns for the export. You can choose additional columns from Additional columns section based on your needs. However, Recharge recommends limiting the number of additional columns to avoid impacting performance.
- Click Create export.
The Charges - Processed export contains all of the information you need including:
- Charge IDs
- Order IDs
- Transaction IDs
- Customer emails
You can also use the Recharge API to pull this data by using the charge endpoint. This has both metadata pieces for orders and transaction ids.
Step 2 - Access the Transaction ID in Stripe
Pull the Transaction IDs from Stripe for the same time period.
Step 3 - Compare data between Stripe and Recharge
Use the Transaction ID that you obtained from Stripe and match it to the Transaction ID on your Recharge Export.
Reconcile refunds with Stripe
Step 1 - Export your Recharge and Stripe data
- Export your Recharge store data. Run the Charges - Processed export for the time period your need.
- Pull the Transaction IDs from Stripe for the same time period.
Step 2 - Match the refund ID
Use the Transaction ID for a charge to match the Refund ID with your payment processor.