The Transaction Fees Export (Converted USD) is the most granular fee report GiddyUp offers — one row per transaction, every fee type broken out. This is the report to reach for when you need to verify a specific charge or reconcile the Sales Overview panel down to individual orders.
Key Columns
Column | What it shows |
Transaction Type | Payment or Refund. |
Gross Sales / Shipping / Taxes / Total Sales | What the shopper paid, broken into components. |
Platform Fee / Merchant Fee / Currency Conversion Fee / Dispute Fee / Shopify App | Individual fee types — see Transaction Fee Schedule for rates. The Merchant Fee column also includes the Tax Calculation fee when tax collection is enabled for the shopper's region. |
CPA Total | Commission owed on this transaction. |
CPA Deducted PayPal / CPA Deducted Stripe / CPA Invoiced | How the CPA Total was actually collected — see the Glossary for definitions of each. |
Balance Offset Adjustment | A manual true-up to a prior period. Rare — flag it if you see one you don't recognize. |
Total Fees | Every fee above added together, including CPA Total. |
Net Sales | Total Sales − Total Fees. What you keep from this transaction. |
👉 Some cells will read "Pending" instead of a number. CPA Total, Total Fees, Net Sales, and CPA Invoiced all depend on your affiliate commission being fully reconciled with the marketing partner network, which happens on a weekly cycle. Until that reconciliation completes for a given order, these four columns show the text "Pending" rather than a dollar amount — even if every other column on that row is already filled in with real numbers, and even if a Stripe Payout ID and Payout Date are already assigned. In other words, a transaction can already be paid out to your bank while its CPA-related columns are still catching up.
If you're building a spreadsheet formula or pulling this into another tool, filter out or handle "Pending" rows first — summing a column that mixes numbers and the text "Pending" will error out or silently produce a wrong total. Re-export after the next weekly reconciliation to get final numbers for those rows.
Worked Example
A single payment row, illustrative numbers:
Field | Value |
Gross Sales | $59.99 |
Shipping | $4.99 |
Taxes | $3.89 |
Total Sales | $68.87 |
Platform Fee | $1.88 |
Merchant Fee | $3.44 |
CPA Total | $42.00 |
↳ CPA Deducted PayPal | $42.00 |
↳ CPA Deducted Stripe | $0.00 |
↳ CPA Invoiced | $0.00 |
Total Fees | $47.32 |
Net Sales | $21.55 |
Check: $68.87 − $47.32 = $21.55 ✓
Using This to Reconcile the Sales Overview Panel
Every figure on the Sales Overview panel is a sum of this report over your selected date range:
Total Sales (panel) = sum of Total Sales (report)
CPA Total (panel) = sum of CPA Total (report)
Transaction Fees (panel) = sum of everything except CPA Total (report)
Net Sales (panel) = sum of Net Sales (report)
If a panel total looks off, pull this export for the same date range and check it row by row.
Still have a charge you can't account for? Contact support@giddyup.io with the Order ID or Transaction ID.
