Google Sheets · Excel · 7 tabs · fees · COGS · FIFO valuation · tax summary
eBay Tax & COGS Tracker
eBay Tax & COGS Tracker — for resellers who want to know what they actually kept. Most reseller spreadsheets stop at "what did I sell it for". This one subtracts every eBay fee — final value, promoted listing, payment processing — and what the item cost you, so each sale shows a real net profit. It values the stock you still hold two ways (FIFO and average cost), and it hands you a tax summary with net income, mileage and deductible expenses for your return.
€14.99 · instant download · Excel and Google Sheets · no subscription · use it forever.
What you get
- DEMO workbook — a pre-filled worked example (8 sales, fees, a purchase log and inventory) so you can watch every tab calculate before you touch your own numbers.
- BLANK workbook — the same system with the sample rows cleared, ready for your own sales.
- Quick-start guide PDF — set up in about 10 minutes, in plain English.
- Works in Microsoft Excel (.xlsx) and Google Sheets. No macros, so nothing breaks.
The tabs
Sales Log
date, item, sold price and shipping, one row per sale.
Fees
final value, promoted listing and payment processing fees, auto-totalled.
COGS
your purchase log: lot cost and quantity, with unit cost calculated.
Inventory Valuation
FIFO and average-cost value of the stock you still hold.
Profit
per-sale net (gross − fees − COGS) and margin, calculated automatically.
Tax Summary
annual net income, deductible expenses and mileage.
Dashboard
sales, fees, COGS, profit, inventory and taxable net at a glance.
Works with
- Excel and Google Sheets (instructions included)
- Print as PDF for a paper copy
Before you buy: For your own use. Tax guidance varies by jurisdiction — confirm with a tax professional.
Get it
€14.99, instant download from the ChurchillCraft shop on Etsy. No subscription, no account, no macros — the file is yours and it keeps working.