← All posts

Cost Tracking for eBay Resellers: Log Your Cost of Goods Without Spreadsheets

Revenue is vanity. Profit is sanity. If you're a high-volume eBay reseller who doesn't track cost of goods sold (COGS), you're flying blind — you know what came in, but not what actually stayed.

Spreadsheets work for a while. But listing hundreds of items a month across multiple sourcing trips, manual COGS tracking becomes a chore you skip. FlipRoute's Cost Tracking replaces the spreadsheet: import your eBay sold history, log what you paid, and see monthly costs in one view — inside the same platform you use to list.

Step 1: Calculate Your Average Cost Per Item

Before importing data, figure out your average cost per item — the fastest way to populate costs across an inventory you've been building for months without tracking individual prices.

1. Total your inventory purchases since day one — every dollar spent buying items to resell (credit-card statements, receipts, accounting software).
2. Count your total listings — currently active eBay listings plus all sold listings since you started. Your Seller Hub dashboard has both.
3. Divide. Total purchases ÷ (active + sold) = average cost per item.

Example: $15,000 spent over three years, 500 active listings, 2,500 sold → $15,000 ÷ 3,000 = $5.00 average cost per item.

Then use the Update Cost tool to apply it — to sold listings (filter by Date Sold) and active listings (filter by Date Listed). This gives you a baseline. Going forward:

• Using the Bulk Lister? Costs are captured automatically when you create a batch — every listing remembers what you paid.
• Not using it? Update individual listings inline, or apply costs by date range after a sourcing trip.

Step 2: Download Your Sold Report From eBay Seller Hub

This is a one-time conversion — you download once to seed your history, then the Refresh button keeps everything in sync.

1. Log in to eBay Seller Hub (ebay.com/sh)
2. Click Reports → Download
3. Click Download Report
4. Select Orders as the source, Paid and shipped as the status
5. Set a Custom Range — go as wide as you want, even back to your first sale
6. Leave format as CSV
7. Download and save the file

The report includes every sold listing with its eBay item number, title, sale date, and sold price.

Pro tip: since it's one-time, import your entire history. FlipRoute deduplicates by eBay item number, so years of data import safely — and you won't touch the CSV again.

Step 3: Upload the CSV — One Time Only

1. Open prd.fliproute.ai/cost-tracking
2. Click "Import CSV Sold" in the sidebar
3. Choose the CSV from eBay
4. Click Upload & Import

FlipRoute matches each row to your listings by eBay item number. Sold listings import with status, sale date, and sold price; still-active items are flagged active so you track live inventory and sold history together. The import screen reports how many listings came in and how many were skipped.

You can re-import safely — the eBay item number is the unique key, so duplicates update rather than multiply. But you won't need to: once history is in, Refresh catches everything going forward.

Step 4: See Your Costs at a Glance

The dashboard summary bar shows Total listings, Active, Sold, Total Cost, and Missing Cost (how many listings still need a cost). Below that, the YTD Cost by Month card breaks down monthly COGS for the year, with arrows to scroll past years and a year total at the bottom.

Step 5: Enter Costs for Your Accounting System

Whether you use QuickBooks, Xero, a spreadsheet, or a CPA, FlipRoute gives you the data to create a clean monthly Cost of Goods Sold journal entry. Two ways to populate costs:

Inline Editing — One Item at a Time

In the listings table, every row has a Cost column. Click the cell, type the cost (e.g. 1.50), press Enter. Journal-entry style — work through your sourcing receipts item by item. You can edit costs on both active and sold listings, so a cost you forgot at listing time can still be added later and your historical COGS stays accurate.

Batch Mode — Update Costs by Date Range

Bought a lot where everything cost about the same? Click "Update Cost," filter by Date Listed or Date Sold, set the range, enter the per-listing cost, and Apply Cost — every listing in that range updates at once. Perfect for estate sales, thrift hauls, and liquidation lots.

Step 6: Refresh to Stay in Sync

Your inventory changes daily. The Refresh button pulls fresh data from eBay: newly active listings are added, recently sold items get their sale date, and ended-unsold listings are removed. It's a one-click operation that runs in seconds — do it before entering costs so you're working with current data.

Refresh replaces the CSV workflow. After the one-time history import, you never download another eBay report — Refresh queries eBay's API directly and updates the dashboard automatically.

Why This Matters for Your Taxes

If you file as a reseller (and you should), COGS is one of the most important numbers on your Schedule C. The IRS cares about profit, and profit = revenue − COGS − expenses. Without accurate COGS you're either overpaying tax, under-reporting (audit risk), or guessing. FlipRoute gives you a clean, auditable record of what you paid for every item — hand it to your CPA or use it to fill out your Schedule C with confidence.

All costs are stored per eBay listing ID in the FlipRoute database, so you can refresh and re-import without losing cost data — it's linked to the listing, not a spreadsheet row.

Tying It Together

Cost Tracking is one of three pillars in FlipRoute's toolkit, alongside Bulk Listing and Box Management. Together they cover the whole workflow: source → list → organize → track profit. No spreadsheets, no separate tools, no context-switching.

It's included with every FlipRoute Web account — Starter, Growth, or Enterprise — at no extra charge. Plans start at $10/mo for 200 listing credits that roll over indefinitely.

Launch FlipRoute Web → and import your first Sold report in under a minute.

Frequently Asked Questions

Does FlipRoute automatically pull cost data from eBay?

No — eBay doesn't expose purchase costs (you paid outside eBay, so it has no idea what your cost was). You enter costs from your own receipts. FlipRoute makes it fast with inline editing and batch mode.

Do I need to import a CSV every month?

No — the CSV import is a one-time conversion. After that, the Refresh button pulls new sales, ended listings, and status changes from eBay automatically.

Can I export my cost data for taxes?

Cost Tracking is viewable in FlipRoute, with CSV export on the roadmap. In the meantime, reference the dashboard when preparing your Schedule C, or reach out to support for raw data.

Does Cost Tracking work with the FlipRoute iOS app?

The iOS Cost Logger lets you enter costs in the field — right at the thrift store or estate sale — and those sync with the web dashboard once the apps are linked. For now, enter costs directly in the web app.

Is Cost Tracking free?

Yes — it's included with every FlipRoute Web account at no extra charge, on every plan.