A simple reseller inventory spreadsheet can show which items are profitable, which listings need attention, and how much cash is tied up in unsold stock. This guide provides a practical table structure, calculation formulas, worked examples, and a repeatable workflow for tracking items bought and sold online or locally.
Overview
Reselling becomes difficult to manage when purchase receipts, listing links, shipping costs, platform fees, and sale proceeds are scattered across messages and payment accounts. A reseller inventory spreadsheet brings those details into one record for every item. It can work in Excel, Google Sheets, or another spreadsheet tool, and it can remain useful whether you sell a few items each month or source inventory regularly.
The goal is not to create complicated accounting software. The goal is to answer practical questions:
- What did I pay for this item, including sourcing expenses?
- Where is it listed, and when did the listing go live?
- What will remain after marketplace fees, shipping, supplies, and discounts?
- How long has the item been unsold?
- Should I revise the price, move the item to another platform, bundle it, or stop spending time on it?
Use a separate row for each item or sellable lot. If you buy a group of similar items together, record the lot as one row only when you can reasonably allocate its cost and sales. For category-specific pricing guidance, see How to Price Used Items for Sale.
How to estimate
Start with the item's total cost, then estimate the amount you expect to keep after the sale. A basic reseller profit tracker can use these formulas:
Total cost basis = purchase cost + allocated sourcing cost + preparation cost
Net proceeds = sale price + shipping charged to the buyer − marketplace fees − payment fees − shipping label − packing supplies − discounts or refunds
Estimated profit = net proceeds − total cost basis
Return on cost = estimated profit ÷ total cost basis
Use actual figures after a sale whenever possible. Before listing, label the result as an estimate and note which costs are still uncertain. A fee percentage should not be treated as permanent: marketplace charges, optional promotion costs, payment processing, and shipping arrangements can vary by platform, category, seller settings, or transaction. Record the fee amount from the transaction rather than relying on memory.
A useful spreadsheet layout might include these columns:
| Column | What to record |
|---|---|
| Item ID | A simple code that connects the item to photos, receipts, and storage location |
| Item description | Brand, model, size, color, edition, or other identifying details |
| Category | Furniture, electronics, clothing, collectibles, household goods, or another category |
| Condition | New, used, refurbished, incomplete, damaged, or another honest description |
| Purchase date | When you acquired the item |
| Purchase cost | What you paid for the item or allocated share of a lot |
| Sourcing cost | Allocated travel, buyer premium, delivery, or other acquisition expense |
| Preparation cost | Cleaning materials, replacement parts, testing, or repairs |
| Listing date | When the item became available for sale |
| Platform | Marketplace, local classified site, consignment channel, or direct sale |
| Listing URL | The live listing link, if one exists |
| Asking price | Current listed price |
| Sale date | Leave blank until sold |
| Sale price | The agreed or completed item price |
| Fees | Marketplace, payment, promotion, or other transaction fees |
| Shipping and supplies | Label, postage, packaging, and related fulfillment costs |
| Net proceeds | What remains from the transaction after selling costs |
| Profit | Net proceeds minus the total cost basis |
| Status | Draft, listed, reserved, sold, returned, donated, or removed |
| Storage location | Bin, shelf, room, or other location |
For local sales, include whether payment was received, the pickup date, and any delivery expense. For shipped orders, distinguish shipping charged to the buyer from the shipping amount you actually paid. This prevents a postage reimbursement from being mistaken for profit.
Inputs and assumptions
Consistency matters more than complexity. Decide how you will treat common costs before filling the sheet.
Allocate costs deliberately
If a sourcing trip produces several items, divide the travel or delivery cost using a method you can repeat. You might allocate it evenly, by purchase cost, by item weight, or by another reasonable basis. Record the method in a notes column. Do not change the method from item to item simply to make a particular sale look better.
Separate item cost from selling cost
The purchase price and preparation expenses form the cost basis. Platform fees, payment charges, postage, packaging, discounts, and refunds are selling costs. Keeping these categories separate makes it easier to compare platforms and diagnose weak margins. The Marketplace Fees Compared guide can help you structure that comparison.
Track inventory age
Add an inventory-age column with a formula based on the listing date. For an active listing, calculate the number of days from the listing date to today. For a sold item, calculate the days from listing date to sale date. You can then group stock into useful review ranges, such as newly listed, established, and stale. The exact ranges are a management choice, not a universal rule.
Keep evidence with the row
Save receipts, purchase messages, repair notes, photographs, shipping receipts, and final transaction records in a folder that uses the same Item ID as the spreadsheet. This supports reconciliation and makes it easier to explain your figures when preparing business or tax records. Recordkeeping requirements can vary by location and situation, so use the spreadsheet as an organized record rather than as a substitute for professional tax advice.
Worked examples
Example 1: Shipped marketplace sale
Suppose an illustrative item has a purchase cost of $18, an allocated sourcing cost of $2, and preparation supplies of $1. Its total cost basis is therefore $21. It sells for $48. The transaction includes $6 in marketplace and payment fees, $8 for the shipping label, and $1.50 in packing materials. If the buyer paid shipping separately, the sheet should record that amount as shipping charged rather than treating it as part of the item price.
Using the formula:
Net proceeds = $48 − $6 − $8 − $1.50 = $32.50
Estimated profit = $32.50 − $21 = $11.50
The return on cost is approximately 54.8 percent in this illustration, calculated as $11.50 divided by $21. The result is useful because the sale price alone would have overstated the outcome.
Example 2: Local pickup with a price reduction
Assume a used household item cost $35, with $5 spent on cleaning and minor preparation. The original asking price was $90, but the final local sale price was $70 after negotiation. There was no shipping label, but a $6 delivery expense was incurred. The total cost basis is $40, and the selling expense is $6.
Net proceeds = $70 − $6 = $64
Estimated profit = $64 − $40 = $24
If you had tracked only the purchase price, you would have reported a higher-looking margin and missed the effect of preparation and delivery. Local sales still have costs; they simply appear in different columns. For safety and transaction planning, review How to Sell Items Fast Locally and Safely.
Example 3: Unsold inventory review
An item purchased for $25 has been listed for 75 days. It has received views but no completed sale. The spreadsheet shows an asking price of $60, a likely platform fee, and an estimated shipping cost that would leave little profit after a discount. Instead of leaving the row unchanged, add a review note: verify condition details, compare recent asking prices, improve photographs, test a different platform, or choose local pickup. If the item remains unproductive, calculate the result of accepting a lower price against the cost of continued storage and attention.
When to recalculate
Review the spreadsheet whenever an input changes. Recalculate before lowering a price, accepting an offer, paying for promoted placement, switching platforms, repairing an item, or changing from shipping to local pickup. Recheck the result when a marketplace changes its fee display or shipping process, because a previously accurate estimate may no longer match the transaction.
Set a regular inventory review, such as once a week or once a month, based on your volume. During the review:
- Match completed sales to payment and marketplace records.
- Enter final fees, shipping, refunds, and discounts rather than estimates.
- Find active listings with missing photos, links, condition notes, or storage locations.
- Sort by inventory age and decide a next action for stale items.
- Compare estimated profit with actual profit by category and platform.
- Back up the file and keep supporting records in the matching folder.
Update the assumptions whenever your sourcing method, shipping approach, platform mix, or typical item category changes. A spreadsheet is most valuable when it drives a decision: buy less selectively, price with better evidence, consolidate listings, revise stale stock, or stop pursuing items whose margin does not justify the work. For a broader sourcing and stock workflow, see How to Start Flipping for Profit. Start with the columns above, enter your next purchase immediately, and complete the row when the item sells or leaves your inventory.