Sales Rep Commission Calculator

💰 Sales & Revenue

▼

🚨 Common Tariff Rates:

• China: 25% (Section 301) + regular duty
• Vietnam/Thailand: 0-10%
• India/Bangladesh: 0-16%
• Mexico (USMCA): 0%
• Use HTS code lookup for exact rates

Gross Sales (Revenue) $

📍 Analytics → Reports → Finances summary (Gross sales) or Overview 'Total sales'

Discounts Given $

📍 Analytics → Reports → Sales by discount or Finances summary → Discounts

Returns/Refunds $

📍 Analytics → Reports → Finances summary → Returns

Chargebacks $

📍 Analytics → Reports → Finances summary → Chargebacks

Orders (Count) #

📍 Analytics → Dashboards → Overview → Total orders

Units Sold #

📍 Analytics → Reports → Sales by product/variant → Units sold

Average Order Value (AOV) $

📍 Analytics → Overview → Average order value (optional if Orders provided)

📦 Product Costs

▼

COGS per Unit $

📍 Products → product → Cost per item or your supplier sheet

Packaging Cost per Order $

📍 Your 3PL/ops sheet or internal estimate (optional)

💳 Fees & Charges

▼

Transaction Fee %

📍 Settings → Payments → Shopify Payments 'View rates'

Transaction Fee Flat per Order $

📍 Finances → Payouts (fee detail) or payment gateway dashboard

App/Subscription Fees for Period $

📍 Settings → Billing → App charges (same date range)

🚚 Shipping & Fulfillment

▼

Shipping Charged to Customer (avg per order) $

📍 Analytics → Reports → Sales over time: Shipping collected

Shipping Cost Paid by You (avg per order) $

📍 Orders → Shipping labels or 3PL/carrier invoices

Fulfillment Pick/Pack Fee per Order $

📍 3PL invoice or rate card (optional)

➕ Optional Inputs

▼

Labor/Staff Allocation for Period $

📍 Payroll/ops sheet for fulfillment portion

Ad Spend for Period $

📍 Meta/Google/TikTok ads dashboards (same date range)

Sales Tax Collected for Period $

📍 Analytics → Reports → Finances summary → Taxes

📊 Profit Analysis

Net Sales

True Profit

$0 0%

Revenue → Profit Flow

Gross Margin 0%

Profit per Order $0

Break-even Price/Unit $0

Revenue Leakage $0

Shopify True Profit Calculator