What Is the Payment Gateway Report?
The Payment Gateway Report brings payment transaction details into a single view for a selected transaction date range. It shows the payment gateway, transaction status and amount alongside the related order number, date, order values, discounts and payment gateway fee.
Use it to review successful, failed or pending transaction records, compare processing fees across gateways and investigate payment activity linked to specific orders. The transaction amount and order amount are separate fields, so they should not automatically be treated as equivalent.
In Data Export, you can open the premade report, adjust the view for your store, and export or schedule the results for regular reviews.
Report Overview
- Period
- Selected transaction date range.
- Fields
- Nine fields covering order details, transaction amount, gateway, status and gateway fee.
- Best for
- Payment monitoring, fee checks and transaction-to-order review.
- Export
- Excel, CSV, TXT or PDF.
- Delivery
- Scheduled email sharing, plus Google Sheets, Google Drive and FTP destinations.
What Can You Learn from Payment Gateway Data?
1. Which payments may need follow-up
Use Status with Order Number and Transaction Amount to locate payment records that have not completed successfully.
Example: A pending transaction appears beside an order you expected to be paid.
What you can do: Check the order and gateway record before contacting the customer.
2. Where processing fees are adding up
Review Payment Gateway Fee alongside Gateway and Transaction Amount to see which payment records carry larger charges.
Example: Two gateways show different recorded fees on transactions of similar size.
What you can do: Compare those records and investigate the relevant gateway pricing.
3. Which order and transaction amounts need review
Compare Order Amount, Total Discount, Net Order Amount and Transaction Amount to locate differences worth checking; they do not necessarily indicate an error.
Example: An order has a different transaction amount from its net order amount.
What you can do: Open the related order and payment history to understand the difference.
4. How gateway activity changes over time
Use the date range and gateway fields to review transaction activity over busy or promotional periods.
Example: A sale weekend shows more failed transactions for one gateway.
What you can do: Review gateway performance during that window and follow up on affected orders.
What Should You Check First in This Report?
Start with the fields that can reveal payment exceptions and costs quickly:
Status: Filter failed or pending transactions and inspect their order numbers.
Payment Gateway Fee: Sort highest-first to find fees that merit a closer look.
Gateway: Compare records across providers within the same date range.
Transaction Amount vs. Net Order Amount: Review differences with the related order before drawing conclusions.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Investigating failed payments | Find relevant transaction statuses, amounts and order numbers for follow-up. |
| Reviewing processing costs | Spot payment records with higher gateway fees and compare gateway entries. |
| Checking payments after a promotion | Review transactions and discounts for the selected campaign period. |
| Preparing a finance review | Export order-linked transaction values, statuses and gateway fees for examination. |
| Comparing gateway activity | Filter or chart payment records by gateway to see differences in volume or fee totals. |
How to Create This Report in Data Export
The premade report already includes the transaction and payment fields listed above.
Open Data Export and find the premade Payment Gateway Report.
Open the report and review the nine included fields.
Select your transaction date range and apply gateway or status filters if needed.
Save the report; export it in the format appropriate for your review.
Optionally schedule delivery by email daily, weekly or monthly and share with the relevant team.
Make the Most of This Report
A few focused adjustments can make payment reviews more useful:
01 / TIME WINDOW
Use a consistent period: Compare matching date ranges when reviewing payment activity.
02 / EXCEPTIONS
Start with status: Check failed and pending records before scanning completed transactions.
03 / FEES
Sort by fee: Look at high-fee records alongside transaction amounts and gateways.
04 / SHARING
Share carefully: Payment and order information should go only to the people who need it.
Frequently Asked Questions
What does the Payment Gateway Report show?
It displays order details, discounts, net order amount, transaction amount, payment gateway, transaction status and recorded gateway fees for a selected transaction date range.
Can I see failed or pending payments?
Yes. Use the Status field to identify those records when they appear in your selected date range.
Does this report show payment processing fees?
Yes. Payment Gateway Fee is one of the nine included fields. Check the relevant gateway records if you need to validate how a fee was calculated.
Is the transaction amount the same as the order amount?
Not necessarily. They are distinct fields and can differ; use the order and gateway records to investigate the cause.
Can I export or schedule the report?
Yes. You can export Excel, CSV, TXT and PDF files and set daily, weekly or monthly email schedules. Available destinations depend on your configuration.