Reseller Inventory & Profit Tracker Spreadsheet 2026 | eBay Poshmark Mercari Whatnot Fee Calculator | 1099-K Bookkeeping Excel Google Sheets

MARKETPLACE SELLER 1099-K, FEE & TAX RECONCILIATION TRACKER

🎁 FREE BONUS INCLUDED — 1099-K Reconciliation + Profit-by-Platform (a $24 value): reconciles your 1099-K and shows real profit by platform. Yours free with this template.

Your platforms told the IRS you made $30,000. You know you did not. This is the workbook that proves it — line by line, in the order an accountant reads it.

Form 1099-K reports GROSS. It includes the sales tax the marketplace already collected and remitted, the shipping the buyer paid, the orders you later refunded, and every single fee taken out before the money ever reached your bank. It has no idea what you paid for the item. Reconciling that number to your actual income is the January panic, and no reseller template on the market does it.

This one does.

WHAT'S INCLUDED — 12 TABS, 14,063 WORKING FORMULAS

• Start Here — set-up in five minutes, in plain English
• Dashboard — the whole year in headline numbers and written insight sentences
• Settings & Fee Model — nine marketplaces pre-loaded, every rate editable
• Sales Ledger — one row per order across every platform you sell on
• Inventory & COGS — cost basis, units sold, units on hand, aging buckets
• 1099-K Reconciliation — the flagship: Box 1a down to Schedule C Line 31
• Expense Log — deductions mapped to real Schedule C line numbers
• Mileage Log — odometer-based, at the rate you set
• Quarterly Tax Planner — profit, set-aside, and the gap you still owe yourself
• Profit by Platform — which marketplace actually pays, after fees
• Profit by Month & Category — seasonality and where your margin really lives
• Tax Prep Checklist — 22-step year-end close-out plus an accountant hand-off summary

THE FEATURE YOU ACTUALLY BOUGHT IT FOR

Type each platform's Box 1a figure into one yellow cell. The workbook:

1. Compares it to what YOUR ledger recorded and flags any platform that does not tie
2. Subtracts the sales tax the marketplace collected and remitted on your behalf
3. Subtracts refunded and cancelled orders that are still sitting inside the gross
4. Gives you Adjusted Gross Receipts — the figure that belongs on Schedule C Line 1
5. Then walks it down through fees, shipping labels, cost of goods, expenses and mileage
6. And lands on Net Profit for Schedule C Line 31

Every dollar of the gap between the two is explained, on one screen, with a source for each line.

TRUE NET ON EVERY SINGLE ORDER

Enter twelve things. The workbook calculates ten more, including listing fee, transaction fee, payment processing, Offsite Ads, shipping label, total selling costs, net payout, cost of goods and your real margin. Change a rate in the fee table and all of it recalculates.

Nine platforms are pre-loaded: eBay, Etsy, Poshmark, Mercari, Depop, Whatnot, Amazon, Shopify and Facebook Marketplace. The rates that ship with the file are commonly published starting points — open your platform's current fee schedule and overwrite them. It takes two minutes and it is what makes every other number in the file true.

KEY FEATURES

• Multi-platform sales ledger — one file instead of one spreadsheet per marketplace
• Per-platform fee model driving automatic true-net-per-sale
• 1099-K reconciliation with per-platform tie-out checks
• Cost of goods pulled in by SKU, so profit is real profit
• Inventory aging buckets — see the cash sitting on your shelf past 180 days
• Schedule C category mapping with business-use % and receipt tracking
• Standard mileage log with start and end odometer readings
• Quarterly estimated-tax set-aside calculator with a should-have-saved gap
• Profit ranked by platform, month and product category
• Charts, drop-down menus, conditional formatting and protected formula cells
• A complete sample tax year already loaded so you can see it working before you touch it

HOW IT WORKS

1. Download instantly after purchase — no waiting, no shipping
2. Open Settings and set your tax year dates, mileage rate and tax set-aside rate
3. Check the nine platform fee rows against your current seller rates and overwrite them
4. Delete the sample rows and start logging purchases and sales
5. In January, enter each 1099-K Box 1a figure and read the bridge

COMPATIBILITY

Works in Microsoft Excel (2016 and later, and Microsoft 365) and in Google Sheets. No macros, no add-ons, no subscription, no array formulas — it opens and calculates anywhere. Use it on desktop, laptop, tablet or phone. Yours forever.

WHO IT IS FOR

Cross-listing resellers, thrift and vintage flippers, sneaker and card sellers, POD and wholesale sellers, anyone running $10k–$80k a year across three or more marketplaces who just received a 1099-K and does not have a bookkeeper.

FREE CUSTOMIZATION

Need a marketplace, a product category or a Schedule C line that is not already in the file? Message the shop and we will add it for you at no charge.

PLEASE NOTE

This is a bookkeeping workbook — a digital download, not a physical product, and not a tax return. It is not tax advice. Schedule C line references and the accountant hand-off summary are there to speed up the conversation with a qualified preparer, not to replace one. Marketplace fee rates, IRS mileage rates and 1099-K reporting thresholds change; verify current figures with your platform, the IRS or your accountant.

Because this is an instant digital download, all sales are final. Any questions before or after you buy — just message us.

ReadySheetGo — spreadsheets that actually do the work.

———————————————
VIDEO TUTORIAL INCLUDED
This template comes with a step-by-step video walkthrough to help you get set up in minutes. Your tutorial link is included with the instant download.