Shopify shows gross sales, but true margin is buried under layers of fees, shipping costs, and payment processing. Your best-selling SKUs might be losing money once you account for Shopify fees, fulfillment, and actual shipping vs. what customers paid.
Your first run is free - no card.
Get a ready-to-use file with everything you need
Revenue → COGS → fees → shipping → net profit per product
Payment, platform, transaction fees separated by type
Actual carrier cost vs. what customers paid
Raise prices, drop losers, renegotiate shipping
Real outcomes for your Shopify business
Quick wins ready: Find 5-10 fixes worth $1,000-$3,000/month - raise prices, drop losers
True margin exposed: SKU-level breakdown with fees, shipping, COGS - no hidden costs
No more vanity: Replace revenue dashboards with honest profit metrics
What this Excel Decision Kit tracks from your Shopify data
Revenue - COGS - Shopify fees - payment fees - shipping cost (actual vs. charged)
Total fees (Shopify subscription + transaction + payment) as % of sales
Where you're paying shipping that customers didn't - by carrier and zone
Every variant's full cost stack: retail price → COGS → fees → shipping → net
Top 5-10 products where small price increases recover margin without hurting sales
From revenue to net profit, layer by layer
Definition: (Revenue - COGS - Payment Fees - Shipping Cost - Platform Fees) ÷ Revenue × 100
Source: Order revenue + itemized cost stack
Granularity: Per-SKU, per-category, per-platform
Definition: (Total Fees) ÷ Revenue × 100
Source: Payment gateway fees + platform commissions
Granularity: By platform, by product category
Definition: (Actual Shipping Cost - Customer Paid Shipping) ÷ Revenue × 100
Source: Carrier costs vs. shipping charged to customer
Granularity: Per-order, aggregated by zone/carrier
What makes Shopify different and how we handle it
line_item.variant_id: links to cost data
shipping_lines[].discounted_price: free shipping impact
presentment_currency: for multi-currency margin calc
Shopify-specific setup in 3 steps
OAuth2 authorization for orders, products, and transaction fees
step 2
Pre-sorted list: raise these prices, drop these losers, fix these shipping zones
Start automating your Shopify reporting today and save hours every week.
Our report recipes are designed by e-commerce experts who understand what metrics matter most for your business decisions.
Connect your platforms in minutes, not hours. Our OAuth2 integration makes setup secure and simple.
Reports are delivered in perfectly formatted Excel files that work seamlessly with your existing workflow.
Our report recipes are designed to provide actionable insights and recommendations for your business.
Common questions for Shopify users
You tell us your plan tier once, we apply correct rates (Basic 2.9%+30¢, Shopify 2.7%+30¢, Advanced 2.5%+30¢, Plus negotiated). We also handle Shopify Payments vs third-party gateways.
Upload a CSV mapping SKU to cost, or we can use category average margins. Missing COGS = we can only show gross margin, but still better than nothing.
We calculate shipping subsidy: actual carrier cost minus what customer paid (often $0). Shows true cost of 'free shipping' promotions.
Yes - connect each store, we consolidate margin analysis and flag if one store has better economics than others.
Yes - wholesale orders tracked separately with their different pricing and fee structures clearly distinguished from retail.
"We thought we had 40% margins. After Shopify fees, shipping subsidy, and payment processing, it was 18%. We raised prices 12% on low-margin SKUs and nobody noticed."
Tom Anderson
Owner, Fitness Gear Pro
$42,000 annual margin recovery
23 SKUs repriced or discontinued
Other decision kits for your Shopify data
Connect your Shopify account and generate your first reconciliation in under 5 minutes. First report free.
No card • Keep the file forever • Cancel anytime