A Reseller’s Inventory Spreadsheet Guide: Track Stock, Aging, Costs, and Sell-Through

Overview

Reseller inventory tracking works best when every item has a clear identity, location, cost basis, and next action. A spreadsheet is often enough for a small operation because it can combine purchasing, listing, storage, sales, and profitability information in one place without requiring specialized software.

Start with two related sheets rather than placing every detail in one crowded table:

• Inventory sheet: one row for each SKU or identifiable item currently owned.
• Sales and purchase log: transaction-level records for purchases, sales, fees, shipping, returns, and adjustments.

For identical units bought together, a SKU can represent the product while a purchase-lot field records when and at what cost that batch was acquired. For unique goods such as used clothing, collectibles, or refurbished electronics, assign one SKU per item.

The goal is not to produce a perfect accounting system. The goal is to make useful decisions consistently: list an unlisted item, improve a weak listing, move stock to a better channel, discount aging inventory, or reorder a product that is selling at an acceptable margin.

Inventory data is most valuable when connected to your operating decisions. For example, demand research can help you avoid buying weak stock; see how to validate viral product demand before you buy inventory before committing cash to a new item.

How to estimate

Build the spreadsheet around a few repeatable calculations. Use one row per SKU on the main inventory sheet, then add formulas that update as you enter dates, quantities, costs, and sale information.

Core inventory fields

• SKU: Your internal identifier, such as JKT-001 or LOT-2026-04.
• Product name: A short description that matches the listing.
• Category and condition: Useful for filtering and comparing similar stock.
• Purchase date: The date you acquired the item or lot.
• Quantity purchased and quantity available: Separate purchased units from current stock.
• Unit cost: The item cost before selling fees and fulfillment expenses.
• Additional unit cost: Per-unit preparation, packaging, repair, or inbound shipping cost when applicable.
• Listing status: For example, unprocessed, ready to list, listed, reserved, sold, returned, or written off.
• Marketplace: The channel where the item is listed or sold.
• Listing date: When the item became available for sale.
• Storage location: A shelf, bin, drawer, room, or other specific location.
• Asking price and minimum acceptable price: Your current target and decision floor.
• Sale date and sale price: Completed-sale information.
• Fees, shipping, discounts, and refunds: Costs that reduce the amount you keep.

Useful formulas

Total unit cost = unit purchase cost + unit preparation cost + allocated inbound shipping.

Inventory cost value = quantity available × total unit cost.

Days in inventory = current date − purchase date. If you want to measure listing performance instead, use current date − listing date. Keep the two measures separate: an item may have been owned for weeks before it was listed.

Net proceeds = sale price − selling fees − shipping paid by seller − discounts − refunds or adjustments.

Realized profit = net proceeds − total unit cost.

Realized margin = realized profit ÷ sale price. Format the result as a percentage.

Sell-through rate = units sold during a defined period ÷ (units sold during that period + units available at the end of the period). Multiply by 100 for a percentage.

Define the period before comparing products. A weekly sell-through rate and a monthly sell-through rate answer different questions. Also record the calculation date, since a rate without a time window can be misleading.

For a simple spreadsheet formula, if sold units are in cell G2 and ending available units are in H2, use =G2/(G2+H2). Add an error check so an empty row does not return an error. In many spreadsheet programs, a version such as =IFERROR(G2/(G2+H2),0) is sufficient.

Inputs and assumptions

A spreadsheet is only as useful as the assumptions behind it. Write those assumptions at the top of a separate “Settings” tab or in a notes area so you do not silently change your method from one month to the next.

Choose a cost method

For identical products purchased at different prices, decide whether you will use actual lot cost, a first-in-first-out approach, or a weighted average. A small seller can use a straightforward method, but it should be applied consistently. If you use actual lot cost, include a lot ID and reduce that lot’s remaining quantity when units sell.

Separate cash flow from profit

Cash paid at purchase is not the same as realized profit. Buying ten units creates an inventory investment, while profit is calculated as units sell. Track both “cash invested in stock” and “profit from completed sales” to avoid treating unsold inventory as income.

Capture marketplace costs completely

Record the fee categories that apply to each channel rather than using one permanent percentage. Fees, promoted-placement costs, payment charges, shipping, packaging, discounts, and returns can change by marketplace, category, order, or seller arrangement. Review the fee inputs before relying on a margin calculation. The marketplace fees comparison guide and product profit calculator guide can help structure that review.

Set decision bands

Create practical age bands such as 0–30 days, 31–60 days, 61–90 days, and over 90 days. These are operating labels, not universal rules. Adjust them for your product category, seasonality, storage capacity, and cash position. Then assign an action to each band: hold, improve, cross-list, offer a discount, bundle, return to supplier if possible, or liquidate.

Use a separate field for “next action” rather than expecting aging alone to make the decision. An item may be old because it is scarce and correctly priced, while another may be old because the title, photos, condition notes, or shipping settings are weak. For listing improvements, use the marketplace listing optimization checklist.

Worked examples

Example 1: calculating realized margin

Assume a seller buys an item for $18 and spends $2 on preparation and packaging. The total unit cost is therefore $20. It sells for an assumed $42. The marketplace fee is assumed to be $6, seller-paid shipping is $8, and the seller gives a $2 discount.

Net proceeds = $42 − $6 − $8 − $2 = $26.

Realized profit = $26 − $20 = $6.

Realized margin = $6 ÷ $42 = 14.3%, rounded to one decimal place.

These figures are illustrative inputs, not a current fee or pricing benchmark. If the item had been purchased for a different amount, or if a return created an additional cost, update the row rather than changing the original assumptions.

Example 2: using sell-through to guide a restock

Suppose a product had 12 units available at the start of a review period. The seller acquired four more units, sold nine, and ended with seven units. For the period calculation, use units sold divided by units sold plus ending available units:

Sell-through rate = 9 ÷ (9 + 7) = 56.25%.

That result alone does not prove that a restock is correct. Check whether sales came from one marketplace, whether the price was reduced, whether the product is seasonal, and whether the remaining units are in the same condition. Pair the rate with realized margin, days in inventory, listing views or inquiries when available, and the cash required for the next purchase.

Example 3: identifying tied-up cash

If five unlisted items each have a total unit cost of $24, the inventory cost value is $120. The spreadsheet should label the stock as unlisted rather than pretending it is active inventory. The next action might be to photograph and list the items by a specific date. This distinction helps separate a demand problem from a workflow problem.

When to recalculate

Recalculate inventory metrics whenever an input changes, not only at tax time or when the spreadsheet becomes difficult to manage. Review the file at three different rhythms.

Weekly stock review

1. Count new purchases and confirm that every item has a SKU.
2. Match physical items to storage locations in the sheet.
3. Move sold, reserved, returned, and damaged items to the correct status.
4. Check unlisted stock and assign a listing deadline.
5. Review aging items and choose one next action for each.
6. Compare recent sales with the spreadsheet and correct missing fees or shipping costs.

Monthly dead-stock review

Filter for items above your chosen aging threshold, then group them by category, marketplace, purchase lot, and condition. Look for repeated causes: weak photos, inaccurate condition descriptions, high shipping cost, prices above comparable completed sales, or products that never had validated demand. Decide whether to improve, cross-list, bundle, discount, or remove each item from active inventory.

Recalculate after material changes

Update formulas and assumptions when marketplace fees, shipping costs, packaging costs, purchase prices, return costs, or pricing inputs change. Also revisit the system when you add a marketplace, begin paid promotion, change your sourcing model, or move from one-off items to repeatable lots. For demand and sourcing decisions, compare the tracker with the framework for finding winning products to resell.

Once a month, duplicate the current sheet or export a snapshot before making major structural changes. That preserves a simple history of inventory value, aging, sell-through, and realized margin. A consistent weekly count and a monthly dead-stock review will usually produce more useful decisions than a complicated spreadsheet that is rarely updated.