Reseller Inventory Spreadsheet: Track Costs, Listings, Sales, and Unsold Stock
reseller inventoryrecordkeepingprofit trackingsales spreadsheetunsold inventory

Reseller Inventory Spreadsheet: Track Costs, Listings, Sales, and Unsold Stock

SSell My Stuff Editorial Team
2026-11-09
7 min read

Build a reseller inventory spreadsheet that tracks costs, fees, listings, inventory age, sales, and profit with practical formulas and examples.

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:

ColumnWhat to record
Item IDA simple code that connects the item to photos, receipts, and storage location
Item descriptionBrand, model, size, color, edition, or other identifying details
CategoryFurniture, electronics, clothing, collectibles, household goods, or another category
ConditionNew, used, refurbished, incomplete, damaged, or another honest description
Purchase dateWhen you acquired the item
Purchase costWhat you paid for the item or allocated share of a lot
Sourcing costAllocated travel, buyer premium, delivery, or other acquisition expense
Preparation costCleaning materials, replacement parts, testing, or repairs
Listing dateWhen the item became available for sale
PlatformMarketplace, local classified site, consignment channel, or direct sale
Listing URLThe live listing link, if one exists
Asking priceCurrent listed price
Sale dateLeave blank until sold
Sale priceThe agreed or completed item price
FeesMarketplace, payment, promotion, or other transaction fees
Shipping and suppliesLabel, postage, packaging, and related fulfillment costs
Net proceedsWhat remains from the transaction after selling costs
ProfitNet proceeds minus the total cost basis
StatusDraft, listed, reserved, sold, returned, donated, or removed
Storage locationBin, 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:

  1. Match completed sales to payment and marketplace records.
  2. Enter final fees, shipping, refunds, and discounts rather than estimates.
  3. Find active listings with missing photos, links, condition notes, or storage locations.
  4. Sort by inventory age and decide a next action for stale items.
  5. Compare estimated profit with actual profit by category and platform.
  6. 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.

Related Topics

#reseller inventory#recordkeeping#profit tracking#sales spreadsheet#unsold inventory
S

Sell My Stuff Editorial Team

Marketplace and Resale Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.