Profit Calculator Setup 2026: Stop Margin Bleed

Why Am I Losing Money on Items That Look Profitable on Paper?

That's the question that kept me up at night three years into my reselling business. I was sourcing inventory across estate sales, clearance racks, and wholesale lots—selling on eBay, Amazon, and Etsy simultaneously—and my spreadsheet said I was making money. But my bank account disagreed. The gap between looks profitable and is profitable was quietly eating my business alive.

If you're selling online across multiple platforms and still tracking profit with a basic spreadsheet or, worse, a calculator and a gut feeling, you're operating with a blindfold on. The right free profit calculation tool setup changes that immediately. Not someday. Not after you scale. Today.

Let me walk you through exactly how I built a zero-cost profit tracking system that finally showed me where my money was actually going—and how you can set up the same thing for your online selling business.

What Free Tools Do I Actually Need to Calculate Profit as an Online Seller?

You don't need paid software to get this right. I tried them all—InventoryLab, Profit Bandit, the works. Some are genuinely good. But when you're starting out or running a lean operation, dropping $30–$50/month on tools before you've nailed your profit math is backwards thinking.

Here's the stack I use now, all free:

The Core Setup

Google Sheets is the foundation. Not Excel. Not Numbers. Google Sheets, because you need cloud access from your phone while you're standing in a thrift store aisle deciding whether to buy. Your profit calculator has to be mobile-accessible or it won't get used consistently.

Platform fee calculators from each marketplace you sell on. eBay's fee calculator, Amazon's FBA Revenue Calculator, and Etsy's fee calculator are all free and give you the exact current fee structure. Bookmark them. Use them before every single listing.

A shipping cost reference sheet. I built mine in the same Google Sheet. Every carrier, every zone, every package size I commonly ship. Flat rate, regional, cubic pricing—logged with real dimensions. This is non-negotiable because shipping is where most sellers bleed profit without realizing it.

How Do I Calculate True Profit When Selling Across Multiple Platforms?

This is where most online sellers get it wrong. They calculate profit per platform instead of profit per item. Here's why that matters: I sell the same vintage Pyrex bowl on eBay for $32 and on Etsy for $38. The eBay sale looks worse on paper, but after eBay's 13.25% final value fee, PayPal processing, and shipping, my net profit is $19.40. The Etsy sale? After Etsy's transaction fee, payment processing, and listing fee, my net is $21.85. The higher sale price didn't tell me where the profit actually lived.

Your profit calculation needs to track per-item profitability across every platform, not aggregate sales by channel. Here's the formula I built into my sheet:

Sale Price − Platform Fees − Payment Processing − Shipping Cost − Cost of Goods Sold − Packaging Supplies = True Profit

Let me give you a real example from last month. I sourced a lot of 12 vintage t-shirts at an estate sale for $45 total, so $3.75 per shirt. I sold eight on eBay at an average of $22 each and four on Depop at an average of $26 each.

On eBay: $22 sale − $2.92 final value fee − $0.62 payment processing − $4.85 shipping − $3.75 COGS − $0.40 poly mailer = $9.46 profit per shirt

On Depop: $26 sale − $2.60 transaction fee − $0.78 payment processing − $5.20 shipping − $3.75 COGS − $0.40 poly mailer = $13.27 profit per shirt

Same inventory, different platforms, dramatically different profit outcomes. Without this calculation running on every sale, I'd have kept pushing eBay listings thinking volume was the answer when Depop was quietly generating 40% more profit per unit.

Which Costs Are Online Sellers Forgetting to Include in Profit Calculations?

This is the question that separates profitable sellers from ones who quit after a year wondering why they're broke. Here's what I see sellers leave out of their profit math constantly:

Hidden Costs That Kill Profitability

Storage costs. Even if you're using your garage, that space has value. I assign a per-cubic-foot monthly cost to my inventory. If an item sits for three months, that cost gets added to its COGS. A $15 profit item that sits for four months isn't a $15 profit item anymore—it's a $9 profit item, and that changes whether it was worth sourcing.

Return reserves. If your return rate is 6%, you need to build that into your profit calculation. For every $100 in sales, $6 is effectively erased by returns. I subtract this from every sale in my sheet. It's not pessimism—it's realism.

Gas and sourcing time. This one's controversial. Some sellers say your time isn't a cost. I disagree. If I spend three hours driving to estate sales and spend $12 on gas to source $200 worth of inventory, that gas is a business expense and those hours have an opportunity cost. I log mileage and assign a modest hourly rate to sourcing time. It goes into the calculation.

Tax obligations. Sales tax collection is mostly handled by platforms now, but income tax on your profit is not. If your effective tax rate is 22%, a $10 profit item is really $7.80 in your pocket. Your profit calculator should show both pre-tax and post-tax profit so you're making decisions based on what you actually keep.

How Do I Set Up a Free Profit Tracking System That Actually Works?

Open a new Google Sheet. Create four tabs. Here's exactly what goes in each one:

Tab 1: Item Database

Columns: Date Sourced, Item Description, Source Location, Total Lot Cost, Number of Items, Per-Item COGS, Target Platform, Listing Price, Status (Listed/Sold/Pending).

This is your inventory ledger. Every item gets a row the moment you source it. Not when you list it—when you buy it. Sourcing without logging is how inventory disappears and costs get forgotten.

Tab 2: Sale Log

Columns: Sale Date, Item ID (matching Tab 1), Platform, Sale Price, Platform Fee, Payment Processing Fee, Shipping Cost, Packaging Cost, Adjusted COGS (includes storage time if applicable), True Profit, Profit Margin %, Notes.

Every sale gets logged here within 24 hours. No exceptions. The formula for True Profit auto-calculates once you enter the fee and cost columns. The Profit Margin column uses conditional formatting—green above 30%, yellow between 15–30%, red below 15%. Visual cues matter when you're scanning 50 sales at a time.

Tab 3: Platform Fee Reference

Current fee structures for every platform you sell on. Update this quarterly because platforms change their fees constantly and silently. eBay's final value fee changed three times in one year recently. If your calculator is using old fee percentages, your profit math is fiction.

Tab 4: Monthly Summary

Pivot table pulling from Tab 2, showing total revenue, total costs, total profit, and average profit margin by platform and by month. This is where patterns emerge. You'll see that Etsy outperforms eBay on handmade items by 18% margin but eBay crushes it on vintage electronics. Without this summary view, you're making platform decisions based on feelings instead of data.

What Profit Margin Should Online Sellers Actually Aim For?

Forget the generic advice about aiming for 20% margins. That number is meaningless without context. Here's what I've learned from tracking every sale for three years:

Reselling sourced inventory: 30–40% margin is sustainable. Below 25%, you're working for minimum wage after accounting for time and taxes. Above 50% consistently means you're either underpricing your shipping or sourcing at unrealistically low costs that won't last.

Handmade or manufactured products: 40–60% margin. Your labor and materials need higher markup because you're creating value, not just reselling it.

Clearance and retail arbitrage: 15–25% margin is normal because volume is the game. But your profit calculator needs to show that a 15% margin on a $3 item that sells in two days is better than a 40% margin on a $15 item that sits for six months. Time-value of inventory matters.

The point isn't hitting a magic percentage. The point is knowing your actual margin on every item so you can make informed decisions about what to source, where to list, and when to walk away from a deal that looks good but calculates bad.

How Often Should I Recalculate My Business Profitability?

Every sale. That's not obsessive—that's operational. If your profit calculation isn't running on every transaction, you're accumulating blind spots that compound over time.

But reviewing profitability is different from calculating it. Calculation happens per sale. Review happens weekly and monthly. Every Sunday, I spend 20 minutes scanning my Sale Log tab for patterns. Every month-end, I review the Monthly Summary to decide whether to shift inventory between platforms, adjust pricing, or stop sourcing certain categories entirely.

The sellers who fail aren't the ones with bad products. They're the ones who can't see their own numbers clearly. A free profit calculation tool setup—built in Google Sheets, maintained with discipline, reviewed with honesty—is the difference between a hobby that drains your bank account and a business that grows because you finally know where every dollar goes.

Set it up this week. Not next month. Not when you scale. The sellers who wait are the ones who quit, and they quit because they never actually knew whether they were profitable. Don't be that seller.