What Is the Total Transaction Value by Gateway Report?
The Total Transaction Value by Gateway report helps Shopify merchants review successful payment transactions across their payment gateways. It brings the gateway name, transaction amount, order value, discounts, net order amount, and payment gateway fee into one exportable view.
Choose a reporting period to examine how much was transacted through each gateway and where processing fees may deserve attention. The report is useful for checking payment activity against order amounts and preparing a gateway-focused review for bookkeeping.
This is a successful-transaction report, not a list of failed or pending charges. Its fields also do not include settlement dates, payout amounts, or transaction status.
Report Overview
- Report period
- Select the date range relevant to your review.
- Data included
- Order Amount, Total Discount, Net Order Amount, Transaction Amount, Gateway, and Payment Gateway Fee.
- Best for
- Comparing successful transaction values and associated fees by payment gateway.
- Export formats
- Excel, CSV, TXT, or PDF, as described in the report specification.
- Delivery
- Save and schedule email delivery daily, weekly, or monthly.
What Can You Learn from Gateway Transaction Values?
1. Which gateway handled the highest transaction value?
Compare Transaction Amount alongside Gateway to see where successful payment value is concentrated. A gateway with more value may merit closer fee review.
Example: For example, in a period, Gateway A records more successful transaction value than Gateway B.
What you can do: Prioritize the gateways with the largest transaction amounts in your payment review.
2. How do processing fees differ across gateways?
Review Payment Gateway Fee with Transaction Amount to understand the reported charge associated with processing payments. Comparisons are most meaningful for similar periods and transaction mixes.
Example: For example, two gateways process similar values but show different total fee amounts.
What you can do: Investigate fee differences and check them against your gateway agreements.
3. How do discounts relate to the order value?
Use Order Amount, Total Discount, and Net Order Amount to see the effect of discounts in the report’s order figures. Do not treat the difference as a payout figure.
Example: For example, promotion period shows higher Total Discount than the prior period.
What you can do: Review the period’s discount activity before comparing its transaction values.
4. Where should payment reconciliation begin?
Transaction Amount and Gateway provide a starting point for comparing successful payment records with a separate payment processor statement. The report alone does not establish the amount deposited into a bank account.
Example: For example, processor statement shows a different total from the filtered gateway transactions.
What you can do: Check date coverage, fee treatment, and any additional transaction types in the processor statement.
What Should You Check First in This Report?
Start with the fields that directly affect your gateway review:
- Gateway — confirm which payment provider each transaction belongs to.
- Transaction Amount — compare the value of successful payments across providers.
- Payment Gateway Fee — identify the recorded processing cost for each transaction.
- Order Amount, Total Discount, and Net Order Amount — review order-side context without equating these fields with processor settlements.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Comparing gateway transaction value | Shows which gateways are associated with the largest successful payment amounts. |
| Reviewing processing costs | Places Payment Gateway Fee next to Transaction Amount for fee-focused checks. |
| Preparing a monthly bookkeeping export | Provides selected-period payment and order figures in a shareable file. |
| Checking a processor statement | Gives a gateway-specific starting point for comparing transaction amounts with external records. |
| Reviewing discount-heavy sale periods | Shows Total Discount and Net Order Amount alongside payment amounts. |
How to Create This Report in Data Export
Use the premade template to keep these fields together without building the report from scratch.
- Open Data Export and locate the premade Total Transaction Value by Gateway report.
- Open the report and review the six included fields.
- Select the relevant date range; if needed, sort or filter to focus on a particular gateway.
- Save the report, then export it in the format suitable for your review.
- If recurring delivery is needed, schedule daily, weekly, or monthly emails to the appropriate recipients.
Make the Most of This Report
Use these four checks before sharing or interpreting the numbers.
01 / PERIOD
Use a consistent date range: Compare like-for-like periods so changes in gateway totals are meaningful.
02 / GATEWAY
Focus on one provider: Filter by Gateway when investigating a fee or transaction discrepancy.
03 / DEFINITIONS
Keep amounts separate: Order value, net order amount, transaction amount, and payouts are not interchangeable.
04 / SHARING
Share the right export: Choose a file format and email recipients appropriate for your finance workflow.
Frequently Asked Questions
Does this report include unsuccessful payments?
The report covers successful payment transactions. It does not list transaction status as a field, so do not use this report to identify failed or pending payments.
Can I compare payment gateway fees?
Yes. Use Gateway, Payment Gateway Fee, and Transaction Amount to review recorded processing charges for successful transactions.
Is Transaction Amount the same as Net Order Amount?
Not necessarily. These are distinct report fields. Their values may reflect different order and payment concepts, so confirm the reporting definitions before reconciling totals.
Can this report confirm the amount paid out to my bank?
No. The listed fields do not include payout amounts or settlement dates. Use payment processor or payout records for deposit reconciliation.
Can I automate and export the report?
You can download Excel, CSV, TXT, and PDF files, schedule email delivery, or send the report to destinations such as Google Sheets, Google Drive, and FTP.