Reselling Inventory Spreadsheet: Track Stock and Profit

How-to basics · Updated November 21, 2026

A reselling inventory spreadsheet is a workbook for recording what you buy, what remains in stock, and what each sale earns after item cost, fees, and shipping. In Excel for Microsoft 365 on Windows, a practical starting point is two tabs—Inventory and Sales—with a unique ID for each inventory lot and formulas that calculate stock on hand, cost of goods sold, and net proceeds.

What a Reselling Inventory Spreadsheet Tracks

Resellers often buy items in different places, list them on more than one marketplace, and sell them weeks or months later. A spreadsheet connects those events: it gives each item or batch an identifier, records the purchase details, and links a sale back to the correct cost. Without that link, a sales total can look healthy while the actual margin is unclear.

At a minimum, track an identifier, item description, quantity purchased, unit cost, quantity available, listing status, sale price, fees, shipping expense, and sale date. Other useful fields depend on the business. A clothing seller may need size and condition; a book seller may need ISBN and edition; a vintage reseller may want measurements, repair notes, or provenance.

Keep the spreadsheet focused on operational tracking. It can help estimate item-level profit, but it does not automatically determine taxable income, account for every business expense, or replace bookkeeping records. Tax and accounting treatment can depend on location and circumstances, so use appropriate records and consult a qualified professional for advice.

Set Up the Inventory and Sales Tabs

Create a worksheet named Inventory and another named Sales. On Inventory, use one row per unique purchase lot or cost layer, rather than combining identical-looking items bought at different prices. Suggested columns are:

  • A: Lot ID — a unique identifier such as LOT-001. Use it on the sales record.
  • B: Item — a recognizable description, such as “blue wool coat, medium.”
  • C: Source — the supplier, store, auction, or other purchase source.
  • D: Purchase date — the date acquired.
  • E: Quantity bought — the number of units in that lot.
  • F: Quantity on hand — the remaining quantity, calculated from sales.
  • G: Unit cost — the purchase cost per unit, using a consistent method.
  • H: Lot purchase cost — quantity bought multiplied by unit cost.
  • I: Listing status — for example, not listed, listed, reserved, or sold.

On Sales, record one row per transaction or per item line in an order. Suggested columns are Sale ID, Lot ID, sale date, quantity sold, unit sale price, marketplace and payment fees, shipping paid by the seller, cost of goods sold, and net proceeds before overhead and tax. If an order contains items from multiple lots, separate the lines so each one points to the correct Lot ID. This makes the cost calculation traceable.

Use Formulas to Calculate Stock and Cost

With quantities bought in E2 and unit cost in G2 on the Inventory tab, enter this in H2 to calculate the lot’s original purchase cost. For a lot of 3 items at $8 each, the result is $24. Copy the formula down for other lots.

=E2*G2

To calculate remaining stock, assume the Inventory tab has Lot IDs in A2:A500 and quantities bought in E2:E500, while Sales has Lot IDs in B2:B500 and quantities sold in D2:D500. Enter the following in Inventory F2, then fill it down. If lot LOT-001 began with 5 units and sales rows record 2 units against that ID, the result is 3.

=E2-SUMIFS(Sales!D$2:D$500,Sales!B$2:B$500,A2)

This relies on every sale using the exact Lot ID from Inventory. A typo can make the stock count wrong, so use Excel’s Data Validation list for the Sales Lot ID column if the workbook is used regularly. On Windows, select the cells and choose Data > Data Validation; set Allow to List and use the Inventory ID range as the source. On Mac, the Data Validation command is also on the Data tab, though ribbon layout can vary by release.

Calculate Cost of Goods Sold and Sale Proceeds

For a sale line, calculate cost of goods sold by multiplying quantity sold by that lot’s unit cost. Assume Sales has Lot ID in B2, quantity sold in D2, and Inventory has Lot IDs in A2:A500 with unit costs in G2:G500. Put this formula in the Sales cost-of-goods-sold column. The final 0 is the fallback if an ID is not found; treat a zero result as a warning to check the ID, not as proof the item cost nothing. XLOOKUP is available in Microsoft 365 and Excel 2021 or later.

=D2*XLOOKUP(B2,Inventory!A$2:A$500,Inventory!G$2:G$500,0)

For example, if one unit sold from a lot costing $12 per unit, the formula returns $12. If the sale line has quantity 2, it returns $24. The formula assumes each lot has a single unit cost. When a seller uses a different cost method or needs to allocate a mixed bulk purchase, the workbook must reflect that method consistently; a simple lookup cannot make that decision.

To calculate net proceeds before overhead and tax, assume Sales has quantity in D2, unit sale price in E2, fees in F2, shipping cost paid by the seller in G2, and cost of goods sold in H2. Enter this in I2. If one item sells for $40, fees are $5, seller-paid shipping is $6, and its cost is $12, the formula returns $17.

=D2*E2-F2-G2-H2

This is an item-level estimate, not necessarily business profit. It leaves out costs such as packaging, storage, mileage, subscriptions, returns, and general operating expenses unless you record and allocate them separately. Also distinguish shipping charged to the buyer from shipping actually paid by the seller: the amount collected is revenue, while the carrier charge is an expense. Include both consistently if you want a fuller transaction result.

Make the Workbook Easier to Maintain

In Excel, select each data range and choose Insert > Table, or press Ctrl+T on Windows and confirm that the table has headers. Tables add filter buttons and generally extend formatting and formulas when new rows are added. On Mac, use Insert > Table or Command+T. The precise appearance can differ, but the table feature is available in current desktop Excel.

Use consistent formats: dates as dates, prices as currency, and quantities as whole numbers when fractional units do not apply. Freeze the header row with View > Freeze Panes > Freeze Top Row so column labels remain visible while scrolling. For useful visual checks, select the quantity column and choose Home > Conditional Formatting > Highlight Cells Rules to flag zero or negative stock. Review any highlighted row instead of assuming the color itself corrects the data.

Give IDs a stable format and never reuse an ID for a different lot. A descriptive item name is useful to people, but it is not a dependable key: two items can share a name, and descriptions change. If product variations matter, include the variation in the lot record or assign each variation its own ID.

Choose the Right Level of Detail

A small seller with a few dozen active items can often work with one inventory row per item and one sales row per transaction. A seller buying multiple units at different prices should keep separate lots, because the cost for a unit bought for $10 may not match one bought later for $15. A seller who needs to track bundles, returns, or partial orders may need additional transaction rows and a separate returns log.

Decide whether the spreadsheet is for physical stock, financial reporting support, or both. For physical stock, location fields—such as shelf, bin, or storage box—can save time during picking. For sales analysis, fields for platform, order number, and sale channel help compare performance. Do not add every possible column at the outset; add fields when they answer a real question or prevent a recurring error.

Spreadsheet Versus Reselling Software

A spreadsheet is inexpensive, flexible, and easy to adapt. It is a reasonable choice when one person maintains the records, sales volume is manageable, and stock is not being updated simultaneously by several people. It also makes the underlying calculations visible, which helps a seller understand how a profit estimate was produced.

Dedicated inventory or bookkeeping software may be more appropriate when order volume is high, inventory is shared across marketplaces, or automatic order imports and stock synchronization are important. Software can reduce manual entry, but it still needs accurate setup and review. Compare recurring fees, marketplace integrations, export options, user permissions, and whether it handles the seller’s actual workflow before moving records. A hybrid approach is also possible: use a spreadsheet for product research or one-off analysis while keeping official transaction records in the main system.

Common Errors and How to Prevent Them

  • Updating stock by hand in several places: Choose one source of truth. If sales are logged in Sales, calculate stock from that log rather than also reducing the number manually.
  • Mixing up revenue and profit: A sale price is not the amount earned after item cost, platform fees, and shipping. Keep these amounts in separate columns.
  • Using a product name as a lookup key: Similar names and small spelling differences can lead to missed or incorrect matches. Use unique IDs and validate them.
  • Deleting old sales rows: Historical transactions help explain current stock and past results. Correct errors with a documented adjustment rather than erasing the evidence of a completed sale.
  • Forgetting refunds and returns: A return can change stock, fees, shipping, and the original sale outcome. Record the return as a linked event and state whether the item is sellable again.
  • Assuming the workbook is backed up: Save a working copy in a reliable location and keep periodic backups. Protect sensitive business information with appropriate access controls.

Frequently Asked Questions

What should a reselling inventory spreadsheet include?
Include a unique item or lot ID, description, purchase date and source, quantity bought and remaining, unit cost, sale date, quantity sold, sale price, fees, shipping cost, and a calculated cost and proceeds. Add platform, storage location, condition, or listing URL when those details help with daily work.

How do I calculate profit on a resold item?
For a basic item-level estimate, subtract the item’s cost, selling and payment fees, and seller-paid shipping from the sale revenue. The result does not include every overhead cost or determine taxable profit. Keep the components visible so you can review assumptions and account for additional expenses separately.

Should I use one row per item or one row per purchase lot?
Use one row per lot when identical items were acquired at different unit costs or dates. That lets each sale connect to its actual recorded cost. One row per product can be simpler when all units truly share the same relevant cost and the seller does not need lot-level tracking.

Can Excel automatically reduce my inventory when I make a sale?
Yes. If each sales row includes a valid Lot ID and quantity sold, a SUMIFS formula can subtract total recorded sales from the quantity purchased. It only reflects transactions entered correctly; Excel does not know about an unrecorded marketplace order, refund, or damaged item.

Is a spreadsheet enough for reselling bookkeeping?
It may help organize inventory and transaction details, especially for a small operation, but it is not automatically a complete bookkeeping or tax system. Requirements and useful records vary. Keep original order and expense documentation and check with a qualified accounting or tax professional about your situation.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.