A sporting goods inventory spreadsheet that already knows used gear.
One row per set, bike or rod, with the columns a shop actually fills in: brand, model, year, the spec for its kind, how much it was used, what comes with it, what you paid or the trade-in value and what it sold for, with dropdowns where a dropdown belongs. A Sold sheet works out what each piece made after fees, and a Summary adds it all up by category and channel. Free, in Excel, and it opens in Google Sheets and Numbers too.
- The columns are the fields a piece gets in Sellevry, the inventory software we build for used sporting goods shops, so nothing a buyer asks about is missing
- Dropdowns for the clubs, the shaft, the hand, the use, what comes with it and the status, so every row is written the same way; three example rows show how
- The Sold sheet looks a piece up by its number, puts fees and shipping against the sale, and works out the net; the Summary adds up stock, sales and profit by category and channel
- A field guide lists each column, whether it is text, a number or a dropdown, and the choices
Your spreadsheet is ready
Download the used sporting goods inventory spreadsheetYou get the file now. No automatic emails: we may write to you once, personally.
What's in the file
Six sheets, every figure a formula, every list a dropdown. No macros, nothing hidden.
Inventory
One row per item, with the fields a used sporting goods buyer asks about. Dropdowns wherever there is a list; cost, price and the margin as money. Three example rows show how.
Sold
One row per sale. Pick the item by its number and its name and cost come over; type the date, the channel, the sale price, the fees and the shipping, and the net profit and margin are worked out.
Summary
Stock on hand and its value at cost and at price, sales, fees and net profit, then the same by category and by channel. Formulas, so it keeps up as you add rows.
Plus a Field guide, the Lists sheet the dropdowns read from, and a Start here page.
What it looks like
The Inventory sheet, with the example rows. Dropdowns where you see the arrow; the margin works itself out.
Plus 19 more columns on Inventory: location, where and when you bought it, status, where it is listed, notes and the rest of the used sporting goods fields. The Field guide sheet lists them all.
The same columns, as software.
A spreadsheet is fine for one floor and one person. It stops keeping up when the same bike is on eBay and your website at once, when two people edit it, or when a consignor asks what they are owed. That is where Sellevry starts: the same columns, with every piece listed from one record and the profit worked out after the workshop and the fees. When you get there, send us the sheet and we move it in, free.
Questions
Is it really free?
Yes. You give us your name, your email and what you sell, and the file is yours. We may write to you once, personally, to ask how it is going. There is no automatic mailing and nothing to unsubscribe from.
Does it work in Google Sheets or Numbers?
Yes. It is a plain Excel file with no macros, so Google Sheets, Numbers and LibreOffice open it as it is. The dropdowns and the formulas come across in Google Sheets; Numbers keeps the formulas and shows the lists as plain cells.
Which columns does it have?
The columns every item has: SKU, name, category, brand, condition, quantity, cost, price, margin, location, where it came from, the date, its status, where it is listed and notes. Then the gear fields: clubs, shaft, hand, year, use and what comes with it for golf, frame or wheel size, material and colour for cycling, type and line weight for fishing, type and size for fitness and outdoors. The field guide sheet lists them all, with each dropdown's choices.
Can I add my own columns?
Yes. It is your file. Add a column for anything you track, such as the frame number, the groupset or the loft. If you later move to Sellevry, we bring your columns over as fields.
What is on the Sold sheet?
One row per sale: pick the piece by its number and its name and cost come over from Inventory; type the date, the channel, the order number, the sale price, the fees and the shipping, and the net profit and the margin are worked out. The Summary sheet adds every sale up by channel.
What happens when I outgrow it?
Send us the spreadsheet when you subscribe to Sellevry and we move your gear, stock, customers and past sales in, free on every plan. Moving 20,000 items takes about three days.