If you run a small retail, craft, or e-commerce business, the single most useful number you can know is how much money you keep after each sale. To calculate profit per transaction, use this formula: Profit per Tx = Selling Price – COGS – Variable Cost per Unit. For a $100 sale where the item cost you $60 and payment and shipping fees run $5, your profit is $35. That is the absolute dollar profit per sale, not a percentage. A common side question is “What is 20% profit of $100?”—if you mean a 20% net margin, that’s $20, but many sellers confuse that with their actual per-transaction take-home after all variable costs. In this guide I’ll show you the exact method I use to track this, allocate hidden fees, and build a spreadsheet that scales.
What Profit Per Transaction Actually Means (And Why Most Sellers Track the Wrong Number)
Most dashboard reports show total revenue and total profit. They hide the ugly truth: some individual sales lose money. When I first launched a handmade leather goods store on Etsy in 2019, I celebrated a $4,000 month, only to discover I’d netted $212 after fees. I had tracked gross margin (revenue minus material cost) but ignored per-transaction payment processing and shipping upgrades.
The term profit per transaction means the net cash left from one customer order after every cost that would disappear if that order didn’t happen. It is a unit-economics metric, not a company-wide accounting figure. You can think of it as contribution margin at the micro level, the building block of every larger financial statement.
The Unit-Economics Lens
Viewing your business through this lens changes behavior. Instead of “I sold 100 units,” you ask “I sold 100 units and kept $1,850.” That shift helped me kill a bestselling $15 keychain that actually lost $0.40 each after Etsy fees and letter-mail tracking. The thing nobody tells you about this metric is that payment processor fees are usually percentage-based plus a fixed pad. That means your profit per transaction is not linear with price; a $200 sale does not double the profit of a $100 sale because the 2.9% fee bites deeper in absolute terms.
Most beginners model flat $0.30 fees and wonder why reality hurts. In my second year, I built a simple lookup that applied real percentage fees, and my projected profit dropped 8% across the board. That’s the gap between vanity revenue and real unit economics.
The Core Formula: How to Calculate Profit Per Transaction
The formula is deceptively simple. Profit per Transaction = Selling Price – Cost of Goods Sold (COGS) – Variable Cost per Unit. COGS is what you paid for the product or materials directly used. Variable cost per unit includes payment fees, shipping labels, marketplace commissions, and any consumable packaging.
To answer the generic query “What is a formula to calculate profit?” at the macro level, the textbook version is Profit = Total Revenue – Total Expenses. But that aggregates everything. For per-transaction clarity, you must isolate the expenses that scale with a single sale. If you sell a $100 item with $60 COGS and $5 total variable cost, profit per tx is $35, a 35% margin on price.
Worked Example: The $100 Sale
Let’s ground this with numbers. Suppose you sell a candle for $100. Your COGS (wax, jar, fragrance, labor allocation) is $42. Shopify Payments takes 2.9% + $0.30 = $3.20. Shipping via UPS runs $4.80. Packaging slip and box cost $0.75. Total variable cost per unit = $8.75. Profit per transaction = $100 – $42 – $8.75 = $49.25.
If instead someone asks “What is 20% profit of $100?” they usually mean a 20% profit margin, which is $20. But as you see, my candle yields $49.25 because my costs are lower than 80% of price. Conversely, if your COGS + variable hit $80, then 20% profit of $100 is exactly $20. The percentage is derived from the absolute figure, not the other way around. Always compute the dollar amount first; the percentage is just a ratio for comparison.
COGS Pitfalls Even Experienced Sellers Miss
COGS is not just the item’s purchase price from Alibaba. It should include freight-in, import duties, and a sliver of labor if you assemble. I once omitted a $0.50 label-printing ribbon cost on 500 orders and overstated profit by $250. Small per-unit leaks compound. Also, discounts and coupons reduce selling price, not COGS; never bury them in overhead.
Variable Costs You Cannot Ignore
Common variable costs per transaction include: payment processor cuts (Stripe, PayPal, Square), marketplace referral fees (Amazon’s 15% or Etsy’s 6.5%), shipping labels, insurance, gift wrap, and even credit card chargeback penalties. According to the IRS, these are ordinary deductible business expenses, but deductibility does not rescue your cash flow—they still reduce per-transaction profit.
Edge case: returns. If a customer sends the item back, you may eat outbound shipping and restocking. I allocate a 3% return buffer into variable cost on high-risk categories. That’s a practice most margin calculators skip, yet it prevents nasty surprises in apparel where return rates can hit 20%.
Allocating Shared and Semi-Variable Costs: A Practical Matrix
Not every cost sits neatly on one order. You might buy shipping tape in bulk or pay a monthly software fee. The framework I use is a Variable Cost Allocation Matrix that classifies each cost as fixed, per-unit variable, or shared-variable (allocated by expected volume).
| Cost Type | Example | Allocation Method | Per-Transaction Impact |
|---|---|---|---|
| Direct COGS | Raw material | Actual per item | $30.00 |
| Payment fee | Stripe 2.9%+$0.30 | Percentage + fixed | $3.20 on $100 |
| Shipping | Carrier label | Actual weight-based | $4.80 |
| Shared packaging | Box lot of 200 | Cost / units purchased | $0.75 |
| Marketplace fee | Etsy 6.5% | Percentage | $6.50 |
| Return buffer | Historical 3% | Expected loss rate | $1.50 |
This matrix is the information gap competitors miss. They give you a margin calculator that assumes “expenses” as one blob. In reality, you must separate the costs that vanish when a sale doesn’t happen from those that remain. I print this matrix and tape it to my fulfillment desk; it keeps pickers aware that every free upgrade erodes the number.
Decision Matrix: Trace vs. Average Allocation
When should you trace exact costs versus use a blended average? Use this quick guide:
- Under 50 orders/month: Trace actual fees per row. Accuracy beats time cost.
- 50–500 orders/month: Use the matrix with weighted averages; true-up monthly.
- Over 500 orders/month: Automate via API (e.g., Shopify payout reports) but audit 5% of rows.
The trade-off: exact tracing catches money-losers but eats admin time; averaging is fast but can mask a product that’s secretly unprofitable. I ran averaging for a quarter and found a bundle that looked fine but lost $2.10 per sale due to oversized box dimensions—only caught after a trace.
Margin vs. Markup: The Confusion That Destroys Per-Transaction Math
A frequent question: Is 20% margin the same as 25% markup? In the specific case of an $80 COGS and $100 price, yes—20% margin equals 25% markup because margin = profit/price (20/100) and markup = profit/COGS (20/80). However, the broader confusion is thinking 20% margin equals 20% markup, which is false: 20% markup on $80 yields $96 price and only 16.7% margin. The denominator shift is where sellers misprice.
If you want to double-check your conversions, our Gross Profit Margin Calculator handles the math, but for per-transaction work you still need to subtract absolute fees. Markup thinking leads to “I added 20% to cost” but then fees eat the buffer. Margin thinking starts from the customer price and protects the bottom line.
Converting Between Margin and Markup
Formulas I keep handy: Markup = Margin / (1 – Margin). So a target 30% margin needs 42.9% markup. Margin = Markup / (1 + Markup). Write these on your pricing sheet. When a competitor undercuts, don’t drop markup blindly; recalculate the absolute profit per transaction to see if the volume gain covers fixed costs.
From Single Sales to Portfolio: Averaging Profit Across Many Transactions
Once you can compute one transaction, you need the average across hundreds. The method I use in Google Sheets: list each order with columns for Sale Price, COGS, Payment Fee, Shipping, Other Variable, then a computed Profit column. At the bottom, average the profit column with =AVERAGE(). That gives mean profit per transaction.
Spreadsheet Functions Deep Dive
Here is a copy-paste header set you can use today:
- A: Order ID
- B: Sale Price
- C: COGS
- D: Payment Fee (use formula =B*0.029+0.3)
- E: Shipping Cost
- F: Packaging (allocated)
- G: Profit = B-C-D-E-F
For a quick sanity check without building sheets, the Profit Per Transaction Calculator on our site lets you input one sale’s numbers and see the dollar result instantly. I keep both open: the calculator for client quotes, the sheet for monthly review.
When I scaled to 2,000 orders/month, I switched from per-row fees to a blended rate: total payment fees / total revenue. That reduced spreadsheet lag but required a monthly true-up. The lesson: averaging is a model, not reality, and drift can be 2–3% on mixed baskets. Always reconcile the sum of row profits to your bank deposit minus known fixed pulls.
Why Per-Transaction Profit Matters for Volume and Break-Even
Knowing per-transaction profit turns vague “am I making money?” into a break-even equation. If your fixed monthly costs (rent, software, salaries) are $5,000 and average profit per transaction is $25, you need 200 sales to break even. Miss that number and you’re subsidizing customers.
Fixed Cost Buckets
Fixed costs are those that remain even if you sell zero: Shopify plan, warehouse rent, virtual assistant salary. List them separately. Subtract total fixed from total contribution (sum of per-tx profits) to get operating profit. This bridges to company-level terms.
What is PBT and PBIT? PBT stands for Profit Before Tax—your net operating profit after all expenses except corporate income tax. PBIT is Profit Before Interest and Tax, which excludes interest expense too, focusing on operating performance. They are aggregations of all your per-transaction profits minus fixed overhead. If your 1,000 monthly transactions average $22 profit, total contribution is $22,000; subtract $5,000 fixed to get $17,000 PBIT. That’s the bridge from unit economics to boardroom metrics. Lenders look at PBIT to judge core viability without financing structure noise.
A Practical Spreadsheet Template You Can Build in 10 Minutes
Let’s walk through a complete mini-template. Open Google Sheets, name it “Tx Profit Tracker.” Row 1 headers as above. In row 2, enter a real sale: $100 price, $42 COGS, payment fee auto, $4.80 shipping, $0.75 packaging. Profit shows $49.25. Copy down for 30 days of sales.
Conditional Formatting Steps
Add a dashboard section: Total Revenue =SUM(B2:B100), Total Profit =SUM(G2:G100), Avg Profit/Tx =G101/COUNT(B2:B100). Use conditional formatting to red-flag any row where G is negative. That visual caught two underpriced listings in my store within a week. To set it: select G2:G100, choose “Format cells if less than 0” and pick red fill. It takes 20 seconds and pays for itself.
If you sell via delivery, remember that last-mile costs can vary by zone; incorporate a ZIP-based lookup if you ship nationally. I added a simple VLOOKUP to a zone table and cut mispriced free-shipping claims by 40%.
Common Mistakes and Edge Cases I’ve Learned the Hard Way
First mistake: treating marketplace fees as fixed. Etsy’s 6.5% is variable; ignore it and you overstate profit by that slice. Second: using list price instead of realized price. Coupons and discounts must reduce the selling price in the formula, not sit as a separate “marketing cost” later.
Multi-Currency and Multi-Item Carts
Third edge case: multi-item carts. If a customer buys three items with one shipping label, you must allocate that label across items by weight or value. I use value weighting: shipping * (item price / cart total). It’s imperfect but defensible. Fourth: currency conversion fees for cross-border sales. A 1% FX fee on a $100 sale is $1 that never appears in COGS. Most people don’t realize that even “free shipping” offers shift cost to you and must be added to variable cost per unit.
Trade-off warning: over-engineering the model. If you spend 5 hours perfecting allocation and your margins are 40%, you’re wasting money. Match rigor to margin thinness. A 5% margin business needs daily tracking; a 60% margin art print business can review monthly.
Putting It All Together: Your Next Steps
Start today by picking last week’s 20 sales and computing profit per transaction with the formula. Identify any that fell below $5 or went negative. Then build the simple sheet above and average them. If the average surprises you downward, revisit pricing or negotiate shipping rates.
Weekly Review Ritual
Every Monday I export the previous week’s orders, paste into the tracker, and glance at the average profit per transaction trend. If it dips below my threshold of $18, I pause ad spend because I’m buying unprofitable volume. Remember, per-transaction profit is a leading indicator. Watch it weekly, and the lagging PBT/PBIT at month-end will take care of itself.
The goal isn’t to obsess over pennies but to ensure every sale builds your business rather than quietly draining it. Use the calculator tools linked, but ground them in the real variable costs only you can see. In my experience, the seller who knows their per-transaction profit owns the room during tax season.