Reseller Spreadsheet

The flipper's ledger: one row per item, from the day you buy it to the day it sells. Type the sale price and the platform: fees, profit, ROI and days to sell work themselves out. Works in Google Sheets (free) and Excel 365, in the US and Canada.

Get it on Etsy

Google Sheets (free) and Excel 365 · Four themes · Instant download · Works on phone and tablet in the Google Sheets app

WATCH IT WORK

WHY IT'S DIFFERENT

• No double entry: every tab reads the same row, so nothing gets typed twice
• Fees fill themselves from a dated fee table for eBay, Poshmark, Mercari, Depop, Facebook Marketplace, Whatnot, Etsy, Vinted, Amazon and local cash (edit any rate once; override any single sale)
• Lots and bins: a box or storage unit's cost splits across its items, evenly or by list price

WHAT'S INSIDE (11 TABS)

• Inventory: 5,000 rows with brand, size, source, lot, listed, sold, shipping status and tracking
• Dashboard: sales, profit, net profit, profit per hour, ROI, sell-through, stock age, best sources
• Price check: what each platform leaves you at your price, and the price for the profit you want
• Platforms and sources: fees, profit, days to sell, ad ROAS, best sales
• Stale stock: what you've had longest, the cash tied up and a markdown to try
• Expenses (each on its Schedule C or T2125 line) and Trips (mileage deduction)
• Year-end tax summary: cost of goods sold from opening and closing inventory, expenses by line, mileage

YOU GET

• A PDF with a Google Sheets "Make a copy" link for each theme
• The Excel files (Excel 365, Windows and Mac)
• A sample copy with a year of example flips

GOOD TO KNOW

• Digital download: nothing is shipped.
• Not tax advice: the tax page is a summary for your accountant.