Skip to main content

How to Reconcile: Transaction Fees

How to read the Transaction Fees Export (Converted USD) and use it to reconcile the Sales Overview panel, with a worked example.

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.

Did this answer your question?