Transactions Report
A transaction-centric view of business performance — track what ultimately happened to every sale including its full lifecycle of adjustments, costs, and profitability.
The Transactions Report is your most complete view of business performance, consolidating every sale and capture transaction into a single, powerful analysis. It covers the full transaction lifecycle — from initial charge attempts through revenue collection, adjustments, costs, and ultimately profit. Use this report to understand how effectively your business converts charge attempts into revenue and how adjustments and costs impact your bottom line.
This report is transaction-centric — it starts from sale and capture transactions processed during your selected date range, then looks up what ultimately happened to each one. Adjustments like refunds, voids, chargebacks, and alerts are tied back to the original transaction's processed date, not the date the adjustment occurred.
For example, if a sale is processed on January 15 and a chargeback is filed on February 2, this report will show that chargeback under January 15 — because it answers the question: "Of the transactions processed in this period, what was their complete outcome?"
This differs from the Profit & Loss - Cash Basis Report, which reports every financial event based on when it happened. In that report, the same chargeback would appear under February 2. Both perspectives are valuable:
- Transactions Report → "What happened to the sales I processed this month?" (outcome-based)
- P&L - Cash Basis Report → "What money moved this month?" (cash-flow-based)
What This Report Includes
This report analyzes all completed sale and capture transactions based on the date each transaction was processed, with adjustments attributed back to the originating transaction.
Transactions Included:
- Sale and capture transaction types
- Looks at the transaction's line items
- Adjustments (refunds, voids, chargebacks, and alerts) are attributed back to the originating sale transaction
- Test orders are excluded
- Date range is based on Transaction Completed Date (when the transaction was processed)
Why This Matters: Because adjustments are attributed to the original transaction, this report gives you the true, complete picture of how a period's sales ultimately performed — even if some adjustments occurred weeks or months later. This is essential for evaluating acquisition quality, merchant performance, and campaign ROI where you need to know the final outcome of the transactions you processed.
Revenue calculations depend on your Company Profile settings for shipping and tax inclusion.
Prerequisites
For cost and profitability metrics, fees must be configured. Learn how to set up fees here.
Report Metrics
Attempted Charges
The total number of charge attempts made during the selected period. This includes every transaction attempt regardless of outcome, giving you a baseline for measuring conversion performance.
Declined Charges
The number of charge attempts that were declined by the payment processor or issuing bank. A high number of declines may indicate issues with payment routing, card quality, or fraud filters.
Declined Charge Rate
The percentage of total charge attempts that resulted in a decline. This is calculated as Declined Charges divided by Attempted Charges. Monitor this rate to identify processor or merchant account issues early.
Successful Charges
The number of charge attempts that were approved and completed successfully. This is the primary indicator of how many transactions converted into actual revenue.
Success Charge Rate
The percentage of charge attempts that were successful. Calculated as Successful Charges divided by Attempted Charges. This is one of the most important health metrics for your payment operations.
Unique Cycle Attempts
The number of unique billing cycle attempts, counting each subscription cycle only once even if multiple retry attempts were made. This gives you a true picture of how many individual billing events occurred.
Declined Unique Cycle Attempts
The number of unique billing cycles where all attempts were ultimately declined. This represents cycles that never successfully collected payment despite any retry efforts.
Declined Unique Cycle Attempt Rate
The percentage of unique cycles that ended in a decline. Calculated as Declined Unique Cycle Attempts divided by Unique Cycle Attempts.
Successful Unique Cycle Attempts
The number of unique billing cycles where at least one charge attempt was successful. This represents the true collection rate for your subscription billing.
Success Unique Cycle Attempt Rate
The percentage of unique cycles that were successfully collected. Calculated as Successful Unique Cycle Attempts divided by Unique Cycle Attempts.
Cycle 1 Attempts
The number of initial (first billing cycle) charge attempts. These represent new customer acquisitions or first-time purchases.
Cycle 1 Success
The number of initial cycle charges that were approved. This tells you how effectively you're converting new customer payment attempts.
Cycle 1 Revenue
The total revenue generated from successful initial cycle transactions. This represents your front-end acquisition revenue.
Cycle 1 Decline
The number of initial cycle charge attempts that were declined. High Cycle 1 declines may point to issues with traffic quality or fraud screening.
Cycle 1 Success Rate
The percentage of initial cycle attempts that were successful. Calculated as Cycle 1 Success divided by Cycle 1 Attempts.
Renewal Attempts
The number of charge attempts for recurring billing cycles (cycle 2 and beyond). These represent your existing subscriber base being billed for continuity.
Renewal Success
The number of renewal charges that were approved. This is a key indicator of subscriber retention at the payment level.
Renewal Revenue
The total revenue generated from successful renewal transactions. This represents your recurring revenue stream.
Renewal Decline
The number of renewal charge attempts that were declined. Renewal declines are a leading indicator of involuntary churn.
Renewal Success Rate
The percentage of renewal attempts that were successful. Calculated as Renewal Success divided by Renewal Attempts. Compare this to your Cycle 1 Success Rate to understand retention dynamics.
Successful Offers
The total number of individual offers (line items) that were part of successful transactions. A single transaction may include multiple offers.
Item Quantity
The total quantity of items sold across all successful transactions. This accounts for orders where a customer purchases multiple units of the same item.
Successful Customers
The number of unique customers who had at least one successful transaction. This helps you understand your actual customer reach versus raw transaction counts.
Gross Product Revenue
The total product revenue before any discounts, rewards, or adjustments are applied. This is your top-line product sales figure.
Discounts
The total value of discounts applied to successful transactions. Tracking discounts helps you understand the impact of promotions on your margins.
Rewards
The total value of reward credits applied to successful transactions. This shows how much of your revenue is offset by loyalty or reward programs.
Net Product Revenue
Product revenue after discounts and rewards have been subtracted. Calculated as Gross Product Revenue minus Discounts minus Rewards.
Shipping
The total shipping charges collected on successful transactions.
Gift Cards
The total value of gift card payments applied to transactions.
Total Revenue
The total revenue collected from all successful transactions. This is your headline revenue number for the selected period.
Tax
The total tax amount collected on successful transactions.
Processed
The total dollar amount processed through payment gateways. This may differ from Total Revenue depending on your shipping and tax inclusion settings.
Adjustments
The total dollar value of all post-transaction adjustments, including refunds, voids, chargebacks, and alerts combined. This is your overall adjustment exposure.
Adjustment Rate
The percentage of revenue that was adjusted. This gives you a single metric to track your overall adjustment health.
Refunds
The number of refund transactions issued during the period. Refunds represent voluntary returns of payment to customers.
Refund Rate
The percentage of successful charges that resulted in a refund. Calculated as Refunds divided by Successful Charges.
Refunded Revenue
The total dollar amount refunded to customers.
Refunded Revenue Rate
The percentage of total revenue that was refunded. Calculated as Refunded Revenue divided by Total Revenue.
Voids
The number of voided transactions. Voids cancel a transaction before it settles, so no funds are transferred.
Void Rate
The percentage of successful charges that were voided. Calculated as Voids divided by Successful Charges.
Voided Revenue
The total dollar amount of voided transactions.
Void Revenue Rate
The percentage of total revenue that was voided. Calculated as Voided Revenue divided by Total Revenue.
Chargebacks
The number of chargeback disputes received. Chargebacks occur when a customer disputes a charge with their bank.
Chargeback Rate
The percentage of successful charges that resulted in a chargeback. Calculated as Chargebacks divided by Successful Charges. Keeping this rate below card network thresholds is critical.
Chargeback Revenue
The total dollar amount of chargebacks received.
Chargeback Revenue Rate
The percentage of total revenue lost to chargebacks. Calculated as Chargeback Revenue divided by Total Revenue.
Alerts
The number of chargeback alerts received. Alerts are early warnings from chargeback prevention services that give you the opportunity to refund before a formal chargeback is filed.
Alert Rate
The percentage of successful charges that triggered an alert. Calculated as Alerts divided by Successful Charges.
Alert Revenue
The total dollar amount associated with alert transactions.
Alert Revenue Rate
The percentage of total revenue associated with alerts. Calculated as Alert Revenue divided by Total Revenue.
Net Revenue
Total Revenue minus all adjustments (refunds, voids, chargebacks, and alerts). This is your revenue after all money returned to customers and disputed amounts are accounted for.
Cost of Revenue
The total of all costs subtracted from revenue to calculate profit. This rolls up COGS, ad spend, chargeback fees, alert fees, and processing fees into a single number.
Cost of Goods Sold
The combined cost of goods for all successful transactions, including both initial and renewal orders.
Cycle 1 Cost of Goods Sold
The cost of goods associated specifically with initial (Cycle 1) transactions. Useful for understanding front-end acquisition costs.
Recurring Cost of Goods Sold
The cost of goods associated with renewal transactions. Compare this to Renewal Revenue to understand recurring unit economics.
Ad Spend
The total advertising spend attributed to the selected period. This is used to calculate your return on ad spend and overall profitability.
Ad Spend Rate
Ad Spend as a percentage of Total Revenue. This tells you how much of every revenue dollar goes toward advertising.
Chargeback Fees
The total fees charged by processors for chargeback disputes, separate from the chargeback amount itself.
Chargeback Fees Rate
Chargeback Fees as a percentage of Total Revenue.
Alert Fees
The total fees charged by alert services for chargeback prevention alerts.
Alert Fees Rate
Alert Fees as a percentage of Total Revenue.
Processing Fees
The total payment processing fees charged by gateways and processors for transaction handling.
Processing Fees Rate
Processing Fees as a percentage of Total Revenue.
Profit
Your bottom-line profit, calculated as Net Revenue minus Cost of Revenue. This is the definitive measure of business profitability for the period.
Profit Margin
Profit expressed as a percentage of Total Revenue. This tells you how many cents of every revenue dollar you keep after all costs and adjustments.
Available Dimensions
Dimensions let you group, filter, and drill into your data. Select any dimension to break down your metrics by that attribute.
| Dimension | Description |
|---|---|
| Transaction Date | The date the transaction was processed |
| Transaction Hour | Hour of day the transaction was processed |
| Transaction Day Of Week | Day of the week the transaction was processed |
| Transaction Week | Year-week of the transaction |
| Transaction Month | Year-month of the transaction |
| Transaction Year | Year the transaction was processed |
| Order Date | The date the original order was placed |
| Order Week | Year-week of the original order |
| Order Month | Year-month of the original order |
| Order Year | Year the original order was placed |
| Customer Email | Customer's email address |
| Customer ID | Customer identifier |
| Customer Name | Customer's full name |
| Customer Information | Combined name, email, and phone for quick lookup |
| Connection | The connection (storefront) the customer belongs to |
| Order ID | Order identifier |
| Order Offer ID | Order-offer line item identifier |
| Transaction ID | Transaction identifier |
| Transaction Total | Dollar amount of the transaction |
| Transaction Attempt | The attempt number for this charge |
| Transaction Cycle | The billing cycle number |
| Is Blacklist | Whether the customer is blacklisted |
| Offer | The offer associated with the transaction |
| Offer Name | Offer name (text-searchable) |
| Offer Code | Offer code identifier |
| Primary Offer Category | Primary category assigned to the offer |
| Secondary Offer Category | Secondary category assigned to the offer |
| Item | The item on the transaction |
| Item SKU | SKU of the item (uses shipped SKU if available) |
| Item Category | Category of the item |
| Campaign | The campaign attributed to the order |
| Primary Campaign Category | Primary category assigned to the campaign |
| Secondary Campaign Category | Secondary category assigned to the campaign |
| Charge Frequency | Billing frequency of the offer cycle |
| Plan Type | Recurring, Non-Recurring Pre-paid, or Non-Recurring One Time |
| Is Recurring | Whether the offer is a recurring subscription |
| Is Prepaid Offer | Whether the offer is a prepaid subscription |
| Discount Code | Coupon or discount code applied |
| Discount Name | Name of the discount applied |
| Discount Category | Category of the discount |
| Used Discount Code | Whether a discount code was used (Yes/No) |
| Is Gift | Whether the order was marked as a gift |
| Merchant | The merchant account used for the transaction |
| Merchant Group | Merchant group the account belongs to |
| Merchant Descriptor | Billing descriptor on the merchant account |
| Merchant MCC Code | Merchant category code |
| Primary Merchant Category | Primary category assigned to the merchant |
| Secondary Merchant Category | Secondary category assigned to the merchant |
| Processor | Payment processor name |
| Gateway | Payment gateway used |
| Payment Method | Payment method type (credit card, PayPal, etc.) |
| Currency | Transaction currency |
| Card Type | Card brand (Visa, Mastercard, etc.) |
| Card Bin Number | First 6 digits of the card number |
| Card Bin Number + Card Last 4 | BIN and last 4 combined |
| Card Last 4 | Last 4 digits of the card number |
| Card Issuer | Issuing bank name |
| Card Category | Card category (consumer, business, etc.) |
| Card Country | Country of the card issuer |
| Is Prepaid Card | Whether the card is a prepaid card |
| Gateway Response Code | Response code returned by the gateway |
| Gateway AVS Code | Address Verification System response code |
| Gateway CVV Code | CVV verification response code |
| Gateway Transaction ID | Gateway's transaction reference ID |
| Processor Response | Response text from the payment processor |
| Transaction Type | Sale, capture, refund, void, chargeback, or alert |
| Transaction Descriptor | Descriptor that appeared on the transaction |
| Transaction Created User | User who created the transaction |
| Alert|Chargeback Code | Reason code for alerts or chargebacks |
| 3DS Verified Status | 3D Secure verification status |
| Is Add On | Whether this is an add-on charge to an existing cycle |
| Ship Country | Customer's shipping country |
| Ship State | Customer's shipping state |
| Shipping Frequency | Shipping frequency of the offer |
| Tracking 1–20 | Custom tracking parameters on the order |
| Referrer Domain | Full referring domain |
| Referrer Base Domain | Base referring domain |
| Device | Device used for the order |
| Device Type | Device type category |
Key Business Insights
1. Approval Rate Trend Analysis Track your Success Charge Rate over time to identify processor degradation or improvements. A sudden drop may indicate a gateway issue, while a gradual decline could signal changing customer payment demographics.
2. Front-End vs. Back-End Economics Compare Cycle 1 Revenue and Cycle 1 COGS against Renewal Revenue and Recurring COGS. Healthy subscription businesses typically lose money or break even on Cycle 1 and generate profit on renewals.
3. Effective Revenue Calculation Calculate your true effective revenue: Total Revenue − Adjustments − Cost of Revenue = Profit. Understanding each component's contribution helps you prioritize improvement efforts.
4. Chargeback Threshold Monitoring Card networks typically flag merchants when chargeback rates exceed 1% of transactions. Monitor your Chargeback Rate closely and ensure your alert services are working to deflect disputes before they become formal chargebacks.
5. Customer vs. Transaction Analysis Compare Successful Charges to Successful Customers. A high ratio means customers are placing multiple orders, which is a positive signal for customer engagement and lifetime value.
Optimization Strategies
Improve Approval Rates
- Compare Success Charge Rate across different merchant accounts and gateways to identify underperformers
- Monitor Declined Charge Rate by time of day or day of week to spot patterns
- Use Cycle 1 Success Rate vs. Renewal Success Rate to determine if declines are concentrated in acquisition or retention
Reduce Adjustments
- Track Chargeback Rate weekly and set internal thresholds well below card network limits
- Monitor Refund Rate trends — a rising rate may indicate product quality or expectation issues
- Leverage Alert Rate to measure the effectiveness of your chargeback prevention tools
Optimize Costs
- Review Processing Fees Rate across merchants to negotiate better rates with high-volume processors
- Compare Ad Spend Rate against Cycle 1 Revenue to calculate true customer acquisition cost
- Track COGS trends to identify supply chain cost increases before they erode margins
Maximize Profitability
- Set Profit Margin benchmarks by product line and monitor weekly for deviations
- Use the cycle breakdown columns to identify which billing cycles generate the most profit
- Balance discount strategies by monitoring the Discounts column against its impact on conversion and retention
Pro Tips
-
Start with the defaults, then expand. The default visible columns give you a high-level overview. Enable hidden columns when you need to drill into specific areas like cycle breakdowns or individual adjustment types.
-
Use Unique Cycles for true retention metrics. Successful Charges may count retries, making your numbers look better than reality. Unique Cycle metrics give you a de-duplicated view of actual billing cycle outcomes.
-
Compare Net Revenue to Profit regularly. If Net Revenue is healthy but Profit is declining, your costs are growing faster than revenue — investigate Cost of Revenue components to find the culprit.
-
Monitor Adjustment Rate as an early warning system. This single metric combines all adjustment types. If it spikes, drill into the individual adjustment columns (refunds, voids, chargebacks, alerts) to pinpoint the source.
Frequently Asked Questions
Q: Why does my Total Revenue differ from Processed? A: Total Revenue reflects the business revenue figure based on your Company Profile settings for shipping and tax inclusion. Processed reflects the actual dollar amount sent through payment gateways. Depending on your settings, these may include or exclude shipping and tax differently.
Q: What's the difference between Charges and Unique Cycles? A: Charges count every individual transaction attempt, including retries. Unique Cycles count each billing cycle only once, regardless of how many retry attempts were made. For example, if a subscription renewal is retried 3 times before succeeding, that's 3 Attempted Charges but only 1 Unique Cycle Attempt.
Q: How is Profit calculated? A: Profit = Net Revenue − Cost of Revenue. Net Revenue is Total Revenue minus all adjustments (refunds, voids, chargebacks, alerts). Cost of Revenue includes Cost of Goods Sold, Ad Spend, Chargeback Fees, Alert Fees, and Processing Fees.
Q: Why do my adjustment numbers differ between this report and the P&L report? A: The two reports use different accounting perspectives. This report ties adjustments to the original sale's processed date (transaction-centric), while the P&L - Cash Basis Report reports adjustments on the date they occurred. If you run both reports for January, the Transactions Report shows chargebacks on January sales regardless of when the chargeback was filed, while the P&L shows chargebacks filed in January regardless of when the original sale occurred. Over a long enough time horizon, the totals will converge, but for any specific period they can differ.
Q: Which report should I use — Transactions or P&L? A: Use the Transactions Report when you want to evaluate the quality and outcome of sales processed in a specific period (e.g., "How did my January sales ultimately perform?"). Use the P&L - Cash Basis Report when you need to understand actual cash flow for a period (e.g., "What was my net cash position in January?"). For financial reconciliation and cash management, P&L is typically more appropriate. For performance analysis and acquisition quality, the Transactions Report is more insightful.
Updated 6 days ago