What Is the Stripe Details and Reconciliation Report?
The Stripe Details and Reconciliation report lists Shopify transaction information associated with the Stripe gateway for the transaction date range you select. It brings together an order reference, customer email, amounts, checkout identifier, and authorization code so you can trace individual payments more easily.
Use it to cross-reference a Shopify order with a Stripe payment record, review customer payment history, or investigate an unexpected amount. The report provides transaction-level reference details; it is not, by itself, a full settlement-to-bank reconciliation.
In particular, the report columns do not include payout IDs, bank deposit amounts, processing fees, refund amounts, or settlement dates. Those records must be obtained separately to explain the difference between sales and a bank deposit.
Report Overview
- Report period
- selected transaction date range.
- Fields included
- gateway, order date/name, net order amount, customer email, payment amount, checkout ID, and authorization code.
- Best for
- reviewing Stripe-related orders and locating records for transaction matching.
- Export
- Excel, CSV, TXT, or PDF.
- Automation
- save and schedule delivery by email daily, weekly, or monthly, where configured.
What Can You Learn from Stripe Transaction Details?
1. Find the Shopify order behind a payment
Order Name and Checkout ID provide reference points when searching for a Stripe transaction.
Example: A support request includes a checkout ID but no order number.
What you can do: Search the corresponding records and confirm the payment against the order.
2. Review differences between order and payment amounts
Compare Net Order Amount and Payment Amount to flag rows that deserve investigation. The difference alone does not identify a fee or refund.
Example: For example, order shows 120 in net order amount and 100 in payment amount.
What you can do: Check the underlying payment timeline and order adjustments before classifying the difference.
3. Trace customer payment inquiries
Customer Email, Order Date, and Order Name help narrow down a payment reported by a shopper.
Example: A customer asks about a charge from last Tuesday.
What you can do: Filter the date range and locate matching order/payment references.
4. Identify transactions needing closer review
Sort Payment Amount to surface unusually large transactions or use the gateway column to validate the payment source.
Example: For example, payment of 2,500 appears among much smaller transactions.
What you can do: Verify the order and authorization reference in your payment records.
What Should You Check First in This Report?
Start with the fields most helpful for a reliable transaction match:
- Gateway: confirm the row refers to Stripe rather than another processor.
- Order Name and Checkout ID: match the Shopify record to the processor-side transaction.
- Payment Amount versus Net Order Amount: investigate differences rather than treating them automatically as fees.
- Authorization code and Order Date: confirm the transaction reference and the relevant timeframe.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Matching a Stripe payment to an order | Use Order Name, Checkout ID, and authorization code as cross-reference points. |
| Investigating a payment amount mismatch | Compare Payment Amount with Net Order Amount and review exceptions. |
| Responding to a customer charge inquiry | Find likely transactions using Customer Email, Order Date, and order reference. |
| Reviewing high-value Stripe activity | Sort payment amounts to identify transactions to verify. |
| Preparing transaction support for bookkeeping | Export transaction references to compare with separate Stripe balance and payout records. |
How to Create This Report in Data Export
Start with the premade Stripe Details and Reconciliation report and adjust it to your review process.
- Open Data Export and find the premade Stripe Details and Reconciliation report.
- Choose the transaction date range and review the nine preset columns.
- Confirm the gateway selection or apply an available Stripe filter; adjust or remove columns if needed.
- Save the report and export it in the format your reviewer needs.
- Optionally schedule email delivery daily, weekly, or monthly for regular transaction reviews.
Make the Most of This Report
These four habits make transaction matching faster and less error-prone.
01 / DATE RANGE
Keep the report period aligned with the time window being investigated. Order dates and payout dates may differ.
02 / MATCHING
Use Checkout ID and authorization code together with Order Name; names alone are not always sufficient.
03 / AMOUNT CHECKS
Treat differences between payment and net order amounts as questions to investigate, not automatic fee totals.
04 / SHARING
Share only the fields the recipient needs; customer email and payment identifiers deserve careful handling.
Frequently Asked Questions
Does this report show Stripe payout fees or bank deposits?
No. The report fields do not contain fees, payout IDs, or bank deposit amounts. Match this export with Stripe payout and balance transaction records for settlement reconciliation.
Can I find a Stripe charge using a Shopify order?
The Order Name, Checkout ID, Payment Amount, and authorization code provide useful identifiers. Confirm the match in Stripe because the precise identifier correspondence may vary.
Why can Payment Amount and Net Order Amount differ?
They represent different values in the report. Review the order and payment activity before attributing a difference to discounts, refunds, fees, or other causes.
Can I review a particular customer’s Stripe payments?
Use Customer Email along with Order Date and Order Name to locate relevant rows within your selected transaction range.
Can I automate the report?
Yes. Save the report and schedule email delivery daily, weekly, or monthly.