What Is the Pending Transactions Report?
The Shopify Pending Transactions Report lists payment transactions with a Pending status for the transaction date range you select. It brings the related order and transaction amounts into one view so you can review payments that have not yet completed.
Use it to identify pending transactions worth checking, see which payment gateways are involved, and organize follow-up. A pending transaction is not necessarily failed or paid; its outcome should be confirmed in the underlying payment or order record before taking action.
Report Overview
- Report period
- Selected transaction date range.
- Included data
- Eight fields covering order dates, order identifiers, order and transaction amounts, discounts, gateway, and status.
- Best for
- Monitoring incomplete payments and organizing payment follow-up.
- Export
- Excel, CSV, TXT, or PDF, depending on chosen settings.
- Automation
- Schedule delivery by email daily, weekly, or monthly.
What Can You Learn from Pending Payment Transactions?
1. Which orders need payment review
Order Name and Status help you locate orders linked to pending transactions, while Order Date provides context for prioritizing checks.
Example: For example, an order dated Monday still appears with a pending transaction on Thursday.
What you can do: Open that order and confirm its latest payment state before contacting the customer.
2. How much value remains in pending transactions
Transaction Amount lets you review the amounts attached to pending entries. These amounts are not confirmed revenue and should not automatically be summed as unpaid order balances.
Example: For example, two pending transaction entries each show $120.
What you can do: Check for duplicate attempts or later successful payments before treating either as outstanding.
3. Which gateways need closer attention
Gateway helps group or filter pending transactions by payment provider, making it easier to identify where follow-up should begin.
Example: For example, several pending entries are associated with the same gateway.
What you can do: Investigate their status in the relevant payment records and escalate a recurring issue if needed.
4. How order and transaction values differ
Order Amount, Total Discount, Net Order Amount, and Transaction Amount provide context when a transaction amount differs from the associated order amount.
Example: For example, a discounted order has a transaction amount different from its original order amount.
What you can do: Review the order breakdown rather than assuming a processing error.
What Should You Check First in This Report?
Start with the entries that are most useful for payment follow-up:
- Transaction Amount: Review higher-value pending entries first, while avoiding the assumption that they represent unpaid revenue.
- Order Date and Order Name: Find and open affected orders; the order date is not a transaction age measure.
- Gateway: Look for concentrations of pending transactions within the selected period.
- Status: Verify that the transaction is still pending in the latest payment record before acting.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing incomplete payments | Lists Pending transactions and linked orders for a focused follow-up queue. |
| Checking high-value pending entries | Uses Transaction Amount to prioritize closer review. |
| Investigating gateway-related delays | Uses Gateway to narrow pending entries to a provider. |
| Preparing a regular payment-status check | Provides a repeatable snapshot for the chosen transaction date range. |
| Reviewing differences in order and payment amounts | Displays order amounts, discounts, net order amount, and transaction amount together. |
How to Create This Report in Data Export
Start with the Pending Transactions premade report rather than building the field list from scratch.
- Open Data Export and find the premade Pending Transactions report.
- Review the eight preset fields and choose the relevant transaction date range.
- Check the Pending status selection and add any available gateway or order filters you need.
- Save the report; if needed, customize the columns in the report editor.
- Export the report or set a daily, weekly, or monthly email schedule for recurring reviews.
Make the Most of This Report
Keep your review focused with these four practical habits.
01 / PERIOD
Choose a consistent window: Compare equivalent transaction date ranges across reviews to spot unusual changes.
02 / STATUS
Confirm before following up: Pending is a transaction state, not proof that an order ultimately went unpaid.
03 / GATEWAY
Filter by provider: Review one gateway at a time when investigating a cluster of pending payments.
04 / SHARING
Share carefully: Send exports only to colleagues who need order and payment details, using scheduled delivery where useful.
Frequently Asked Questions
What does a pending transaction mean?
It means the payment transaction is marked Pending in the report’s selected data. Confirm its latest outcome in the payment record; it may later succeed or fail.
Does this report show failed or successful transactions?
No. This premade view is for transactions with Pending status. Failed and successful transactions are separate reporting views.
Can I see which payment gateway is involved?
Yes. Gateway is one of the eight included fields.
Does Transaction Amount equal outstanding order balance?
Not necessarily. Transaction Amount is the amount on the transaction entry, and multiple attempts or subsequent payment outcomes can affect interpretation.
Can I automate the report?
Yes. In Data Export you can save the premade report and schedule email delivery daily, weekly, or monthly.