Sales Tracker for Resellers: Track Every Dollar You Make

Last month a reseller I know had $4,200 in eBay payouts and thought he was crushing it. After running his actual numbers — cost of inventory, shipping, fees, supplies, mileage — his real profit was $1,380.

He was working 25 hours a week for $55 an hour on the surface. The real number was $18 an hour.

A sales tracker changes that. Not because tracking is fun, but because you cannot fix a profit problem you cannot see. This guide covers the exact sales tracker setup I use, the formulas that matter, the free and paid app options, and why most reseller spreadsheets miss the metrics that actually drive decisions.

In this guide:

• The 6 numbers every reseller sales tracker must capture
• A complete free Google Sheets sales tracker template (copy and use)
• The profit dashboard: what to look at each week
• Free vs. paid tracker apps compared
• Category-by-category profit analysis: what your tracker reveals
• FAQ: taxes, 1099-K, COGS, and sell-through rate

What a Sales Tracker Is (and Isn’t)

A sales tracker is not the same as an inventory tracking system. The distinction matters.

Inventory tracking tells you what you have, where it is, and what you paid. SKU systems, bin locations, photo organization — that’s inventory.

Sales tracking tells you what you earned, what it cost you, and whether each category is worth your time. Revenue, fees, profit, margins, sell-through rate — that’s sales tracking.

Most resellers conflate the two and end up with a spreadsheet that does neither well.

The goal of a sales tracker is to answer three questions every week:

1. How much did I actually make? (Not gross revenue — net profit after all costs)
2. Which categories or platforms are making me the most money per hour?
3. Am I improving? (Month-over-month comparison)

Without a tracker, you’re guessing at all three.

The 6 Core Fields Every Reseller Sales Tracker Needs

Most reseller spreadsheets track too much or too little. Here are the six non-negotiable fields — everything else is optional:

1. Sale Date

When did it sell? This drives your weekly/monthly P&L and sell-through calculations.

2. Sale Price

Gross amount the buyer paid (before any fees are deducted). Pull this directly from your platform’s transaction history. For eBay, this is the “total amount” including any buyer-paid shipping if it was embedded in your price.

3. Platform Fees

What the platform actually kept. Not an estimate — pull the exact number from your transaction record. Platform fees in 2026 by category:

4. Shipping Cost

What you actually paid to ship the item. Not what the buyer paid — what came out of your pocket. If you offer free shipping, every dollar of postage is a direct deduction from your net. Track it as a negative.

5. Cost of Goods Sold (COGS)

What you paid to source the item. This is your cost basis and it’s what the IRS cares about. Without it, your platform’s 1099-K gross revenue looks like taxable income. With it, you prove your actual profit.

The 1099-K reporting threshold is $600 in 2026 — if you’re selling at any volume, you’re getting a 1099-K, and you need COGS records.

6. Net Profit

The formula is simple:

Net Profit = Sale Price − Platform Fees − Shipping Cost − COGS

Everything else in your sales tracker is derived from these six fields.

The Complete Free Sales Tracker (Google Sheets Setup)

Copy this column structure into a new Google Sheet. Each row is one sold item.

Column Layout

The Formulas That Matter

Net Profit (Column I):

=F2-G2-H2-E2

Profit Margin % (Column J):

=IF(F2>0,I2/F2,"")

ROI (Return on Investment — add as Column M if you want it):

=IF(E2>0,(I2/E2),"")

ROI and profit margin answer different questions. Margin tells you what percent of revenue you keep. ROI tells you what return you got on your sourcing investment. If you buy a jacket for $8 and sell it for $30 net profit of $18, your margin is 60% and your ROI is 225%. Both numbers matter. ROI is the one most resellers ignore — and the one that reveals whether your sourcing capital is working hard.

Dashboard Tab: The 8 Metrics You Need Weekly

Create a second tab called “Dashboard” with these summary formulas. Assume your sales data is in a tab called “Sales”:

Review these 8 numbers every Sunday. They’ll tell you exactly where your business stands in under 5 minutes.

Category-by-Category Profit Analysis: What Your Tracker Reveals

The most valuable output of a sales tracker is category-level profit data. Most resellers discover they’re spending 60% of their sourcing time on categories that generate 20% of their profit.

Here’s how to build this analysis in your tracker:

Step 1: Use Consistent Category Labels

Every item you log needs a Category. Use a dropdown to enforce consistency:

• Electronics
• Clothing (General)
• Clothing (Premium/Brand)
• Books
• Collectibles
• Home & Decor
• Tools
• Sporting Goods
• Toys & Games
• Other

Step 2: Add a Category Analysis Tab

Create a third tab with a table:

Use SUMIF formulas to pull these from your sales tab. The results are often surprising.

Common patterns resellers discover:

• Books look boring but crush it: At $680 profit on $82 COGS in the example above, that’s an 829% ROI. The margins are high because thrift prices are low. The hourly rate improves once you learn to scan ISBNs quickly.

• Premium clothing is the workhorse: The best resellers I’ve talked to make 60–65% margins on brand-name outerwear (Patagonia, Arc’teryx, lululemon) sourced at thrift stores. That’s $40–$70 net on a $15 buy.

• Electronics are a trap for beginners: High revenue, lower margins, and returns eat your profit. Successful electronics flippers run tight testing protocols. If you skip testing, your effective margin on electronics drops below 30%.

• Collectibles have the worst velocity: Great for big one-time scores, terrible for cash flow. Keep them as a small percentage of your volume unless you’re a specialist.

Platform-by-Platform Profit Analysis

Your sales tracker should also tell you whether the platform you’re using is the right one for your inventory. Add a Platform column and track it the same way as Category.

Platform P&L Table (Example)

Facebook Marketplace’s 78.6% effective margin in this example isn’t magic — it’s the 0% fee on local pickup. Any item you can sell locally without shipping instantly becomes more profitable.

The insight for this seller: shift more furniture and tools to Facebook Marketplace pickup. They were shipping heavy items and eating $12–18 in postage per sale when a local buyer would have paid the same price with zero shipping cost.

Your tracker will surface this. You won’t see it until you run the numbers.

Sell-Through Rate: The Metric That Predicts Cash Flow

Sell-through rate tells you what percentage of your listed inventory sells within a given timeframe. It’s the early-warning system for sourcing mistakes.

Formula:

Sell-Through Rate = (Items Sold ÷ Items Listed at Start of Period) × 100

What the numbers mean:

You can also track sell-through by category and platform. A reseller who sees 85% sell-through on books and 28% on collectibles knows immediately where to reduce sourcing volume.

Track sell-through monthly. A declining trend over 3 months means something changed — either your sourcing, your pricing, or the market. Your tracker tells you which categories are driving the decline.

Sales Tracker Apps for Resellers: Free vs. Paid

Your Google Sheets tracker is powerful for most volumes, but dedicated apps add automation that saves real time as you scale.

Comparison Table

When to Upgrade from Spreadsheets

Stay on Google Sheets until at least one of these is true:

• You’re selling 100+ items per month and manual entry takes more than 30 min/day
• You’ve had a double-sell because you didn’t delist fast enough after a sale
• You crosslist on 3+ platforms and spend too much time delisting manually
• You can’t quickly answer “which category makes me the most money?”

Before that point, the complexity of a paid app adds friction without proportional value.

How to Use Your Sales Tracker for Taxes

This is where your sales tracker pays for itself every April.

The IRS and platforms both report gross revenue — the total amount buyers paid. If eBay paid you $35,000 in 2026, they’ll file a 1099-K showing $35,000. If you have no cost records, the IRS may treat $35,000 as income.

Your sales tracker captures:

• COGS (cost of inventory sold) — your largest deduction
• Platform fees — deductible as business expenses
• Shipping costs — deductible
• Shipping supplies — deductible (track separately in an Expenses tab)
• Mileage — deductible at ~$0.70/mile in 2026; track with MileIQ or Stride

The calculation that saves you money:

Taxable Income = Gross Revenue − COGS − Platform Fees − Shipping − Supplies − Mileage

In real numbers: if you made $35,000 gross but had $14,000 in COGS, $4,800 in fees, $3,200 in shipping, $800 in supplies, and $1,400 in mileage, your taxable income is $10,800 — not $35,000.

At a 25% marginal rate, that’s $6,050 in tax you don’t pay because you tracked your numbers.

For the full picture, see our complete reseller tax guide for 2026 and 1099-K guide.

Step-by-Step: Build Your Sales Tracker This Week

Here’s a concrete five-step plan to have a working sales tracker by Friday:

Step 1: Create the Google Sheet (15 minutes)

Open Google Sheets. Add the 12 columns from the layout above. Set up dropdowns for Category and Platform using Data → Data Validation.

Step 2: Backfill the Last 30 Days (30–60 minutes)

Pull your transaction history from each platform:

• eBay: Seller Hub → Reports → Transaction report (CSV)
• Poshmark: Account → My Sales → Export (CSV)
• Mercari: Account → Selling History
• Facebook Marketplace: No export; enter manually from your messages

Enter the last 30 days of sales. This gives you a baseline to compare against next month.

Step 3: Set Up the Dashboard Tab (15 minutes)

Create the Dashboard tab with the 8 summary metrics. Adjust the date ranges to pull the current calendar month.

Step 4: Set Up Category and Platform Analysis (15 minutes)

Add the third tab with SUMIF formulas breaking down profit by category and platform. Update it monthly.

Step 5: Commit to Daily Entry (2–5 minutes/day)

The system only works if you use it. Build a habit: after your end-of-day shipping run, open the sheet and enter every sale from that day. It takes under 5 minutes when you do it daily. It takes 2 hours and is full of errors when you batch it monthly.

Sell More by Knowing Your Numbers: The Compound Effect

The difference between a reseller making $800/month and one making $3,000/month on the same number of hours usually isn’t sourcing skill or platform knowledge. It’s data.

The $3,000/month reseller knows:

• That premium outerwear converts at 85% and makes $42 average profit vs. $11 for general clothing
• That eBay outperforms Poshmark for their electronics by 18 percentage points
• That items sourced from estate sales have 3.2× the ROI of thrift store picks for their specific inventory
• That anything unsold at 60 days needs a 15% price drop immediately

All of that comes from a sales tracker. None of it is visible without one.

Use our ROI calculator to evaluate individual deals before you buy, and cross-reference against your category-level tracker data to see how each potential purchase fits your actual historical performance.

Frequently Asked Questions

What’s the simplest sales tracker setup for a beginner?

A Google Sheet with six columns: Sale Date, Item, Sale Price, Platform Fees, Shipping, COGS. Derive Net Profit with =C2-D2-E2-F2. That’s it. You can add complexity later — but capturing those six fields from day one is what matters. Most resellers who “start tracking later” never actually start. The habit is built by keeping it dead simple at the beginning.

Even at 15–20 items per month, a tracker shows you things that surprise you. One reseller I know tracked for 90 days and found that 80% of her profit came from one category (premium activewear) that represented 30% of her sourcing time. She doubled her activewear sourcing and cut everything else. Income doubled in 60 days. None of that was visible without the data.

What’s the difference between a sales tracker and an inventory tracker?

An inventory tracker tells you what you have in stock, where it is, and what you paid for it — before it sells. A sales tracker captures what happened after the sale: revenue, fees, shipping, COGS, and net profit. You need both, but they serve different purposes. Inventory tracking is operational (find the item, ship it, delist it). Sales tracking is strategic (which categories and platforms are actually profitable). Most reseller apps try to combine both — which works well at scale but is unnecessarily complex when starting out. See our complete inventory tracking guide for the other half of the system.

Do I really need to track shipping separately from fees?

Yes. Shipping is one of the biggest hidden profit killers in reselling, and most resellers don’t track it precisely. If you offer free shipping, every dollar of postage is a direct reduction in your net profit. The difference between a $40 sale with $4 shipping and a $40 sale with $11 shipping is $7 — more than 17% of your revenue. Platform fee calculators handle fees automatically, but shipping is variable and category-specific. Heavier items have higher shipping costs that can wipe out margins that look fine on paper. Once you track shipping by category, you’ll find certain item types that look profitable are actually break-even or worse after postage. That insight changes how you source. Use our eBay fee and shipping calculator to model any sale before you list.

How do I track COGS for lot purchases?

Divide the total lot cost by the number of items as your baseline COGS per item. If you paid $120 for 24 items at a garage sale, each item’s COGS is $5. For more accuracy, do a proportional allocation: estimate a rough resale value for each tier of items in the lot and assign costs proportionally. The simple method is fine for the IRS as long as you’re consistent. The key rule: document your lot purchases. After any garage sale, estate sale, or liquidation purchase, create a record showing date, location, amount paid, and approximate item count. A note in your phone app works — the IRS accepts contemporaneous records, not just formal receipts.

What sell-through rate should I aim for?

Target 70%+ sell-through within 60 days of listing. If your overall sell-through drops below 50%, you have a sourcing problem (buying things that don’t sell), a pricing problem (listing too high), or a listing quality problem (poor photos, weak titles). Your tracker will tell you which categories are dragging down the average. Most commonly, resellers find one or two categories with low sell-through that they keep sourcing out of habit rather than data. Once the tracker makes it visible, the fix is obvious: stop sourcing that category until you understand why it’s stalling. Run your inventory turnover metrics alongside your sell-through rate for the complete picture.

Can I use my sales tracker data at tax time?

Your sales tracker is your primary supporting document for Schedule C expenses. The data you need: total gross sales (from 1099-K — this is given to you), total COGS (sum of all COGS for items sold during the tax year), total platform fees, total shipping costs, and total supplies/overhead. Your tracker produces all of these with a simple filter and sum. Export it as a CSV and give it to your CPA, or use it to fill Schedule C yourself. The more detailed your records, the more defensible your deductions. Keep the tracker backed up to Google Drive, and don’t delete historical data. For the complete tax picture including mileage, home office, and equipment deductions, see our reseller tax deductions guide.

What’s the best free sales tracker app specifically for resellers?

For most resellers under 100 sales per month, Google Sheets remains the best free option because it’s completely flexible and you own your data. For eBay-focused sellers who want automatic import, Flipwise (~$15/month) connects directly to your eBay seller account and pulls transaction data automatically — the ROI is positive if you’re selling more than 30–40 items per month and the manual entry time adds up. Vendoo’s free tier (25 crosslists per month) includes basic profit tracking and works if you crosslist. AirTable’s free tier gives you 1,000 records with a more visual interface than Google Sheets. If you’re full-time and care about proper bookkeeping, connect your platform exports to QuickBooks via Link My Books — but that’s a $30/month+ investment better suited to sellers doing $5,000+ in monthly revenue.

How often should I update my sales tracker?

Daily — but it doesn’t have to take long. Build a 5-minute end-of-day routine: open the tracker, enter every sale that came through today, and record the exact fees and shipping from your platform notification. Doing it daily prevents the memory errors that come from batching data entry weekly or monthly. It also means your dashboard metrics are always current, so when you’re deciding what to source next weekend, you’re looking at accurate data rather than rough estimates. The resellers who batch their tracking monthly tend to underestimate costs (they forget individual shipping amounts, don’t capture returns accurately, and miss expenses that blur together over 30 days). Daily entry, even for 10 items, takes 3–5 minutes.

Bottom Line

A sales tracker doesn’t make you a better sourcer, photographer, or lister. It makes every other skill you develop more effective by pointing it at the categories and platforms where it pays off most.

The free Google Sheets setup in this guide is good enough to run a six-figure reselling business. The formulas aren’t complicated. The habit of entering data daily is what separates resellers who know their numbers from those who guess.

Start this week. Backfill 30 days of sales. Set up the dashboard. Run the category analysis. The patterns you find in your first 90 days of real data will change how you source more than any guide you’ll ever read.

Related tools:

• ROI Calculator for Resellers — Calculate flip profit before you buy
• eBay Fee Calculator — Exact fees on any sale across platforms
• Break-Even Price Calculator — Minimum profitable price for any item
• Flip Profit Calculator — Fast deal analysis on the go

Related guides:

• Reseller Inventory Tracking: SKUs, Spreadsheets & Apps — The other half of your tracking system
• Reseller Tax Deductions: Complete Guide for 2026 — Every deduction your tracker supports
• 1099-K Guide for Resellers 2026 — What the forms mean and what to do
• Best Items to Resell in 2026 — Once you know your numbers, know where to source
• Reseller Profit Margin Guide — Deep dive on margins, fees, and costs