E-Commerce Profit Pack — Free Spreadsheets for SKU Margins, Platform Fees, ROAS & Inventory

The problem

You're driving traffic, moving product, and watching revenue climb — but your actual profit margin is invisible

💵

Platform fees, shipping, and ad spend are silently eroding every sale — and most sellers have no idea by how much

A $35 Etsy listing looks profitable until you stack the transaction fee (6.5%), listing fee ($0.20), payment processing (3% + $0.25), offsite ads (12–15% if triggered), shipping materials, and your COGS. A $35 product that costs $10 to source should have a 71% gross margin — but after fees and fulfillment it often lands at 35–45%. Amazon FBA sellers face the same compression from referral fees, FBA fulfillment rates, storage fees, and return processing. The SKU Margin Tracker in this pack forces every cost onto the page so you see your real net margin per unit, not the number that feels good before the deductions.

⚠

ROAS of 3× looks healthy — but it's not profit, and most sellers don't know the difference until they check the bank account

Return on ad spend tells you how much revenue each ad dollar generated, not how much money you kept. A $10,000 ad spend with a 3× ROAS produces $30,000 in revenue — but if your blended margin on those sales is 28%, you netted $8,400 against $10,000 spent. You lost money running a "profitable" campaign. The ROAS threshold where ads actually generate positive net profit depends on your margin — and every seller has a different number. The ROAS & Ad Spend Tracker calculates your minimum profitable ROAS (break-even ROAS) from your actual margins and shows whether each campaign is above or below it, week by week.

📈

Inventory cash traps and stock-outs are the two ways e-commerce businesses bleed out — and both are calendar problems, not product problems

Overstock ties up working capital in slow-moving SKUs while you're out of stock on your best seller. The average e-commerce seller has 20–30% of their inventory value sitting in products with more than 90 days of supply — cash that could fund ads, new SKUs, or operations but is instead sitting on a shelf or in an Amazon warehouse accruing long-term storage fees. Stock-outs on velocity SKUs cost more than the missed sales: they tank listing rank, kill conversion rate momentum, and push customers to competitors. The Inventory Reorder Planner calculates your reorder point, safety stock, and optimal order quantity per SKU so you're never simultaneously over-invested in slow movers and out of stock on your winners.

What's inside

Six templates that show you the real numbers behind every sale — margin after fees, profit after ads, and cash after inventory

Each template is a CSV file that opens in Google Sheets, Excel, Numbers, or any spreadsheet app. Pre-built formulas, realistic benchmarks, and clear column labels included.

01

SKU Margin Tracker

Per-SKU profitability breakdown: product cost (COGS), platform fee percentage, fixed platform fee, payment processing fee, shipping cost (outbound), packaging cost, advertising cost per unit (based on your CPC and conversion rate), returns provision (refund rate × average refund value), gross revenue per unit, total variable cost per unit, net margin per unit (dollars), net margin percentage, and monthly volume column to calculate aggregate monthly net profit per SKU. The final column is a margin health flag: green for margins above your target, yellow for marginal SKUs worth optimizing, red for SKUs that are cash-flow negative after all costs. Most sellers find 1–3 SKUs in their catalog that have been losing money on every sale once platform fees and ads are fully allocated — this tracker makes that visible before you scale those SKUs further.

Pairs with Profit Margin Calculator & Markup Calculator

02

Platform Fee Calculator

Side-by-side fee comparison across Shopify, Etsy, Amazon FBA, and WooCommerce at any price point you set: listing/subscription fee allocation per unit, transaction fee percentage, payment processing fee (percentage + fixed), platform-specific add-ons (Etsy offsite ads, Amazon FBA fulfillment tier, Shopify plan fee per transaction), net payout per sale, effective fee rate (total fees ÷ sale price), and break-even price required to hit your target margin on each platform. A second tab lets you enter a single product and see how the payout compares across all four platforms simultaneously — the most useful view when deciding where to list a new SKU or whether to migrate an existing one. The effective fee rate column is the number that changes channel strategy: the difference between a 12% and a 22% effective fee rate on a $40 product is $4 per unit, which at 500 units/month is $2,000 in monthly margin that most sellers never explicitly chose to give up.

Pairs with Profit Margin Calculator & E-Commerce ROAS Calculator

03

ROAS & Ad Spend Tracker

Campaign-level ad performance with real profitability context: campaign name, platform (Meta, Google, TikTok, Pinterest, Amazon PPC), weekly ad spend, revenue attributed, ROAS (revenue ÷ spend), impressions, clicks, CPC (cost per click), conversion rate, orders generated, average order value, blended margin for that SKU/campaign, net profit after ad cost (revenue × margin − spend), break-even ROAS (1 ÷ margin), and a profitable flag (yes if ROAS > break-even ROAS). Weekly rows with a rolling 4-week trend per campaign. The break-even ROAS column is what most sellers are missing: it's not a fixed number, it changes with your margin — and campaigns that look identical at 2.5× ROAS can be profitable on a 50% margin product and loss-making on a 25% margin product. This tracker makes the calculation automatic so you stop optimizing campaigns to ROAS benchmarks that don't account for your actual cost structure.

Pairs with ROAS Calculator & CAC/LTV Calculator

04

Inventory Reorder Planner

Per-SKU reorder management: average daily units sold (30-day rolling), lead time in days (supplier to warehouse/FBA), safety stock days (how many days of buffer you want above lead time), reorder point (daily velocity × (lead time + safety stock days)), current units on hand, days of supply remaining, reorder quantity (based on your target stock level at arrival), supplier name and contact, unit cost at reorder quantity, cash required for this reorder, and a reorder urgency flag (red if days of supply ≤ lead time + safety stock, yellow if within 10 days of that threshold, green if comfortable). A second section tracks slow-moving inventory: SKUs with more than 60 days of supply, monthly storage cost, and a liquidation vs. hold recommendation based on your cost of capital. The cash required column is the one that prevents the cash crunch: most e-commerce businesses discover they have multiple reorders converging in the same 2-week window that requires more working capital than they have available.

Pairs with Break-Even Calculator & Business Cash Flow Calculator

05

Returns Cost Tracker

Return reason tracking by SKU and platform: return date, SKU, platform, return reason (size/fit, defective, not as described, changed mind, damaged in shipping, fraudulent), refund amount, return shipping cost (if seller-paid), restocking cost, inspection and disposition time (minutes × hourly labor rate), resaleable vs. write-off outcome, net loss per return, and a rolling 30-day refund rate per SKU. Summary rows show total return costs by reason, by platform, and by SKU — so you can see whether sizing issues on a specific product are costing more than the product earns, whether a shipping carrier is causing disproportionate damage claims, or whether a single SKU's return rate is high enough to require a listing update or supplier conversation. The return rate by SKU column triggers the real investigation: an 8% return rate on a $40 product isn't just lost revenue, it's $3.20 in direct costs per unit sold on top of the lost margin — compounding against every sale.

Pairs with Profit Margin Calculator & Markup Calculator

06

E-Commerce Cash Flow Planner

Seasonal 12-month cash flow model built for product businesses: monthly revenue forecast (by channel: Shopify, Etsy, Amazon, wholesale, other), COGS (variable with revenue), platform fees (calculated from platform mix and average fee rate), advertising spend (seasonal budget by month), fulfillment and shipping costs, returns provision, inventory purchase outflows (timed to reorder schedule, not revenue — this is the key difference from a standard P&L), monthly net cash flow, and running cash balance. A second section shows the peak cash requirement month (when inventory investment peaks before Q4) and the minimum cash reserve you need to fund operations through your lowest-revenue month without dipping below your safety threshold. The inventory outflow timing column is what separates this from a generic cash flow template: most e-commerce businesses buy inventory 60–90 days before the revenue hits, which creates a predictable cash gap that kills operators who only track profit and ignore the payment timing mismatch.

Pairs with Business Cash Flow Calculator & Break-Even Calculator

How to use it

Start with your SKU margins, then check your ads, then plan your inventory cash — in that order

1

Fill in the SKU Margin Tracker for your top 10 SKUs first — the margin health flags will tell you which ones to fix

Pull your product cost, platform fee rates, average shipping cost, and last 30 days of ad spend per SKU. Fill in the SKU Margin Tracker starting with your top 10 revenue-generating products. The margin health flag column will immediately tell you which SKUs are genuinely profitable, which are marginal, and which are losing money at current pricing and ad spend. Most sellers find that 2–4 of their top 10 SKUs have real margins significantly below what they assumed — either because fees weren't fully accounted for, or because ad costs crept up as CAC rose. Identifying those SKUs before you scale ad spend further is the most valuable 30 minutes you'll spend on your business this month.

2

Pull your last 4 weeks of ad campaigns into the ROAS Tracker and calculate your break-even ROAS for each SKU group

Take the margin percentage from the SKU Margin Tracker for each product category you're advertising and enter it into the ROAS Tracker's blended margin column. The break-even ROAS calculates automatically. Now pull your last 4 weeks of campaign data from Meta Ads Manager, Google Ads, or Amazon Campaign Manager and enter spend and attributed revenue per campaign. The profitable flag column shows you immediately which campaigns are generating real profit vs. which ones have ROAS that looks healthy but is below the break-even threshold for your margin. You'll almost certainly find campaigns you've been scaling that are margin-negative — and campaigns you've been underinvesting in that are outperforming their peers on net profit.

3

Map your next 90 days of inventory reorders into the Cash Flow Planner before you spend another dollar on ads

Use the Inventory Reorder Planner to identify which SKUs need reorders in the next 90 days and what cash each reorder requires. Enter those outflows into the E-Commerce Cash Flow Planner in the month the payment is due — not when the revenue arrives. Then add your advertising budget by month. The running cash balance column will show you whether you have the capital to fund both ad spend and inventory simultaneously, or whether you need to phase one or the other. The peak cash requirement month output tells you exactly how much working capital you need to have in reserve before entering your highest-volume quarter — and whether your current balance is enough to fund it without a cash gap.

E-Commerce Profit Pack

Download all 6 templates — free, no email required

CSV files that work in Google Sheets, Excel, Numbers, or LibreOffice. Open, fill in your numbers, and finally see the real margin behind every SKU, campaign, and inventory decision.

💵 SKU Margin Tracker CSV — COGS, platform fees, shipping, ad cost, net margin per unit, margin health flag ⚖ Platform Fee Calculator CSV — Shopify, Etsy, Amazon FBA, WooCommerce — net payout & effective fee rate side-by-side 📈 ROAS & Ad Spend Tracker CSV — spend, revenue, ROAS, break-even ROAS, net profit after ads, weekly trend 📋 Inventory Reorder Planner CSV — reorder point, safety stock, days of supply, reorder qty, cash required, urgency flag 🚀 Returns Cost Tracker CSV — return reason, refund rate per SKU, net loss per return, cost by platform and reason 🏷 E-Commerce Cash Flow Planner CSV — 12-month seasonal view: revenue, COGS, fees, ads, inventory outflows, running balance

Got the templates? Now get a second set of eyes.

Book a free 15-minute e-commerce margin audit using your actual SKU data or ad campaigns

Fill in the SKU Margin Tracker or ROAS Tracker with your real numbers, then bring it to a 15-minute call. We'll run through your margins, flag which SKUs and campaigns are actually profitable vs. cash-draining, check whether your inventory reorder schedule matches your cash position, and tell you the one change most likely to improve your net profit this month — no pitch, just the math.

Name Email Where do you primarily sell? What's the biggest number problem you're trying to solve?

✓ No cost, no obligation ✓ Bring your actual SKU data ✓ We run the math, you keep the worksheets

Stay sharp

New e-commerce templates, margin benchmarks, and platform fee updates — monthly

We ship new calculators, spreadsheets, and seller guides every month. Join the list and get them before anyone else. No spam, unsubscribe anytime.

Related resources

More tools for e-commerce and product sellers

Free calculators built for the same decisions these templates track — run your numbers live, then log results in the spreadsheets.

Creator & E-Commerce Calculators

ROAS calculator, Etsy fee calculator, Amazon FBA fee estimator, CAC/LTV calculator, digital product pricing worksheet, and more — live calculators for every major e-commerce decision. Run the numbers here, log them in your SKU Margin Tracker and ROAS Tracker.

Open calculators

Business & Marketing Calculators

Profit margin calculator, markup calculator, break-even calculator, and business cash flow calculator — the core tools that feed directly into the E-Commerce Profit Pack templates. Use the break-even calculator to validate the numbers you put in the cash flow planner.

Open calculators

Automotive Profit Pack

If you sell automotive parts, accessories, or supplies alongside your main product line — or run a resale business — the Automotive Profit Pack's vehicle acquisition cost tracker and parts margin worksheet share the same SKU-level logic as the E-Commerce pack and are worth stacking.

View pack

Use these with the pack

E-commerce calculators that pair with these templates

Run your numbers live in the calculator, then log the results in the spreadsheets.

View all creator & e-commerce calculators

From the team at CareerKit Digital

More margin in your business starts with more income from your career

CareerKit Digital builds job-search and career-acceleration tools — resume templates, interview prep kits, LinkedIn profile optimizers, and income negotiation guides — so you can increase what you earn and bring more capital to fund inventory, ads, and growth, whether you're scaling a side hustle from a day job or building the cash reserves to go full-time on your store.

Browse CareerKit Digital on Etsy