Reseller Inventory & Profit Tracker

Reseller spreadsheet for flippers and resale shops: one running inventory list from purchase to sale, with profit per item, sales tax split by channel, monthly totals and an invoice that fills itself, in one Excel workbook.

WHAT IT DOES

• Inventory: one running list. Add an item when you buy it, fill in the sale when it sells. No monthly copying
• Status, invoice number, profit and days to sell calculate for every item
• Sales tax split by channel: mark which channels collect sales tax for you. Tax you collected yourself (to remit) is kept apart from tax the marketplace handled
• Expenses: supplies, subscriptions, storage, mileage and anything else that isn't stock
• Monthly summary: items sold, sales, cost of goods, platform fees, shipping, other expenses, net profit and both tax totals for every month, plus stock on hand at cost
• Invoice: pick an invoice number and the buyer, item, price, shipping, tax and total fill in. Print it or save it as a PDF
• Settings: your business name, tax name and rate (GST, HST, VAT or sales tax), up to 10 sales channels and 10 expense categories
• Room for 2,000 items and 2,000 expenses. Works in any currency

WHAT YOU GET

• Reseller-Inventory-Profit-Tracker.xlsx (blank)
• Reseller-Inventory-Profit-Tracker-with-Sample-Data.xlsx (a filled-in example: 11 items, 8 sold)
• Quick-start guide (PDF)

HOW YOU GET IT

Digital download. After checkout you get a download page right away, plus a receipt by email. Nothing is shipped.

COMPATIBILITY

• Microsoft Excel 2016 or newer
• Google Sheets: upload the .xlsx to Google Drive and open it
• Needs a computer or tablet with a spreadsheet app. This is not an app or a printable planner

GOOD FOR

Resellers and flippers who buy and sell secondhand, vintage or thrifted items through online marketplaces and local sales, and anyone who wants to know their real profit per item and which sales tax is theirs to remit.

PLEASE NOTE

A record-keeping tool, not accounting or tax software. Check your tax rate and which marketplaces collect tax for you with your accountant. For use in your own business; please don't resell or share the files.

DISCLAIMER

This template is a planning tool and does not replace advice from a qualified or licensed professional (such as an accountant, financial advisor or lawyer). Check the results before you rely on them.

HOW IT WAS MADE

Designed by VARS Digital with AI-assisted tools. Every formula is checked before release, and the sample file shows each tab working.

QUESTIONS

Email varsdigitals@gmail.com and we'll help you get set up.