A reseller inventory spreadsheet is a workbook for recording what you buy, what you sell, what remains in stock, and the costs and proceeds tied to each item. In Excel for Microsoft 365 on Windows, start with one inventory row per distinct item or product variant, then use formulas to calculate quantity on hand, unit cost, and estimated profit.
What a reseller inventory spreadsheet tracks
Reselling can involve one-off finds, repeatable products, several sales channels, and costs that are easy to overlook. A spreadsheet puts the records in one place so you can answer practical questions: Is an item still available? What did it cost to prepare? Has it sold, and what did the sale leave after fees and shipping? It is a tracking tool, not automatically a complete accounting or tax system.
A useful workbook usually has an inventory sheet for current stock and, once sales become more involved, a separate sales sheet for completed transactions. The inventory sheet summarizes each item or product variant. The sales sheet records individual sale dates, quantities, prices, channels, fees, and shipping. This distinction matters: a single inventory row cannot accurately represent several sales of the same product at different prices or with different fees unless the workbook records those sale events somewhere else.
For a unique used item, one row per item is often practical. Give each one a distinct SKU or stock ID, even if the item has no manufacturer barcode. For repeat products, a row per SKU and variant—such as size and color—can work for stock totals, while a sales log records each transaction.
Plan the workbook and its columns
Before entering records, decide what one row represents. Consistent rows make sorting, filtering, and formulas much safer. A starter inventory sheet might use these fields:
- Identity: SKU or stock ID, item name, category, brand, condition, and variant.
- Acquisition: date acquired, supplier or source, quantity purchased, purchase cost per unit, and inbound shipping or other allocated acquisition costs.
- Listing: listing channel, listing date, asking price, and listing status.
- Sales and stock: quantity sold, quantity on hand, sale price, marketplace fees, and shipping paid to the buyer.
- Review: storage location, notes, return status, and last-checked date.
Do not make a column do two jobs. For example, keep the asking price separate from the actual sale price, and distinguish shipping charged to the customer from postage you paid. If costs are entered per unit, label them as per-unit amounts; if they are totals for a whole lot, label them as lot totals. Mixing the two leads to misleading margins.
In Excel, select the headings and data area and choose Insert > Table. Confirm that the table has headers. Tables make it easier to filter by status or category and generally extend formulas and formatting when new rows are added. Use clear headings, freeze the top row if helpful, and format dates and currency consistently. Avoid merged cells in the data area because they interfere with sorting and filtering.
Calculate stock on hand
For a simple stock summary, record quantities purchased and sold, then calculate the remainder. With quantity purchased in E2 and quantity sold in F2, enter =E2-F2 in G2 for quantity on hand. If E2 contains 3 and F2 contains 1, the result is 2 units. Copy the formula down the column; in an Excel Table, the formula can fill through the table column automatically.
This subtraction assumes every unit is either still available or has been sold. Returns, damaged stock, samples, and items removed for personal use need to be recorded too. One straightforward approach is to add an adjustment column and subtract net adjustments, or to maintain a stock-movement log with a row for every purchase, sale, return, and write-off. A movement log is more auditable than silently overwriting the quantity.
For unique items, a simple status column can make active stock easier to scan. With quantity on hand in G2, enter =IF(G2<=0,"Out of stock","In stock") in the status cell. If G2 is zero, it displays Out of stock. A listing may still need a separate status such as Draft, Listed, Sold, or Returned: physical stock and listing status describe different things.
Work out unit cost and sale profit
Purchase price is not always the full cost of getting an item ready to sell. Depending on the transaction, a reseller may also track inbound postage, cleaning or repair materials, packaging, and other attributable costs. Choose a consistent method for allocating shared costs. For example, if a lot of five items had $10 of inbound shipping and all items are treated equally, allocating $2 to each is a simple allocation; it may not reflect differences in item size or value.
Assume H2 is purchase cost per unit, I2 is allocated inbound cost per unit, and J2 is preparation cost per unit. With those fields in place, enter =SUM(H2:J2) in K2 for unit cost. If the values are $18.50, $2.00, and $0.00, the result is $20.50 per unit. Keep any allocation method documented in a note or instructions sheet so you apply it consistently.
For a single completed sale, assume M2 is sale price per unit, N2 is marketplace fees per unit, O2 is shipping paid by the seller per unit, and K2 is unit cost. Enter =M2-N2-O2-K2 in P2 for an estimated profit per unit. With a $45.00 sale price, $4.20 in fees, $6.00 in outbound postage, and $20.50 unit cost, the calculation is $45.00 − $4.20 − $6.00 − $20.50 = $14.30. This is a simplified item-level estimate, not necessarily net business profit: it excludes any costs not represented in the columns, such as overhead or taxes.
If G2 is the quantity still on hand and K2 is the unit cost, enter =G2*K2 in a separate inventory-value column. In the example, two units at $20.50 each produce a recorded cost value of $41.00. This is only as reliable as the costs and quantities entered, and it should not be confused with the amount those items might sell for.
Record sales separately when details vary
A sales log becomes important when the same SKU sells more than once, when orders include multiple items, or when transaction details differ. Give each sale a transaction or order ID, and record the date, SKU, quantity sold, actual item price, discount, channel, fees, postage, and any return or refund. This creates a traceable history instead of replacing an old sale price with a new one.
For example, suppose three identical items were bought together for $20.50 each. One sells for $45 with $4.20 in fees and $6 in postage, while another later sells for $39 with different fees. A single “sale price” cell on the inventory row cannot preserve both results. The sales log can retain both transactions, while the inventory sheet summarizes the quantity remaining. If you want to calculate totals from separate sheets, first ensure that each transaction has a consistent SKU and that sales quantities are not counted twice.
Decide how to handle refunds and returns before relying on profit totals. A returned item may go back into sellable stock, remain unavailable pending inspection, or be written off. Record the refund, fee adjustments, shipping, and stock movement as applicable. Do not simply delete the original sale if you need a history of what happened.
Make the sheet easier to use safely
Small spreadsheet habits prevent common data errors. Use one row for each record, avoid blank rows inside the data, and keep headings in a single header row. Add a data-validation dropdown for fields with a fixed set of choices, such as condition or listing status; in Excel for Windows, the command is Data > Data Validation. A controlled list prevents variations such as “listed,” “List,” and “active” from splitting filters and summaries into separate categories.
- Use a unique ID that does not depend on a row number, since sorting changes row positions.
- Keep raw transaction records separate from calculated totals, and do not type over formula cells.
- Use filters to locate items by SKU, location, or status rather than sorting only one column.
- Back up the workbook, especially before bulk edits, importing data, or changing formulas.
- Review negative quantities, blank IDs, and unusually high or low costs as data-quality checks.
Conditional formatting can make low stock or missing information visible. In Excel for Windows, use Home > Conditional Formatting to create a rule, such as highlighting quantity-on-hand values below a chosen threshold. A highlight is a prompt to review the item, not a substitute for checking whether the listing is actually live or the stock count is current.
Common mistakes and limits
The most frequent error is treating revenue as profit. A $45 sale is not $45 of profit if the item cost $20.50 and fees and postage total $10.20. Another is forgetting costs attached to a lot, then comparing one item’s full sale price with only its purchase price. The result can make an item appear more profitable than it was.
Other problems include using inconsistent SKU names, counting a return as both available stock and a new purchase, entering fees as percentages in some rows and dollars in others, and replacing a completed sale with a current listing price. A formula cannot repair incomplete or inconsistent inputs. Add a notes field for unusual cases and review the source transaction records when a result looks wrong.
A spreadsheet also has practical limits. It can be a good fit for an individual seller or a small operation with manageable transaction volume, but it does not inherently synchronize listings across marketplaces, prevent two people from selling the same unit, or provide a robust audit trail. Shared editing and accidental changes can create conflicts. Set clear editing practices and maintain versioned backups; consider dedicated inventory software if manual reconciliation becomes unreliable.
Choose a template or build your own
A blank workbook gives you control over fields and formulas, while a template can save setup time. Neither is automatically accurate. Before using a downloaded template, inspect its formulas, remove fields you will not maintain, and test a few rows with known numbers. Look for separate places to record acquisitions and sales, rather than a sheet that only stores item name and asking price.
Build a simple workbook yourself when the workflow is straightforward and you understand the calculations. Use a template when it matches your channels and record-keeping needs, but treat it as a starting point. If a template includes macros, external links, or unfamiliar formulas, do not enable or trust them without understanding what they do. Keep a clean backup before adapting any workbook.
Frequently Asked Questions
What should a reseller inventory spreadsheet include?
At minimum, include a unique item or SKU ID, description, quantity purchased, quantity sold, quantity on hand, acquisition cost, listing or sale status, and location. Add actual sale price, fees, and postage if you want to estimate item-level profit.
Can I use one row for each item?
Yes, especially for one-off secondhand items. For repeat products, one row per SKU or variant can summarize stock, but record each individual sale in a separate sales log when prices, quantities, or expenses vary.
How do I calculate reseller profit in Excel?
For a simple per-unit estimate, subtract unit cost, seller-paid shipping, and marketplace fees from the sale price. Include all relevant costs consistently, and remember that this item-level figure may exclude general business expenses and other obligations.
Should I track unsold inventory at cost or selling price?
A basic stock-value column can multiply quantity on hand by recorded unit cost, as shown above. That number is a cost-based tracking estimate, not a prediction of what the stock will sell for. Apply any formal reporting rules relevant to your situation with qualified guidance.
When should I move from Excel to inventory software?
Consider a dedicated system when manually updating several sales channels, reconciling frequent returns, sharing edits, or preventing overselling becomes difficult. Compare the software’s supported marketplaces, export options, user permissions, and total cost with the spreadsheet workflow you actually need.
Related
- How to Make a Timeline in PowerPoint: A Step-by-Step Guide
- How to Make a Timeline in PowerPoint
- Jewelry Inventory Spreadsheet: Free Options and Setup
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Dependent Dropdowns in Google Sheets: Setup and FixesTo make a dependent dropdown in Google Sheets, create a named range for each group of choices, then…
- How to Archive Emails in Outlook 365 Online EasilyTo archive emails in Outlook 365 online, select a message in your mailbox and choose Archive on the…
- How to Add a Shared Mailbox in New Outlook for WindowsTo add a shared mailbox in New Outlook for Windows, open Mail, right-click your account name in the…
- Flowchart in PowerPoint: Create, Connect, and FormatYes. In Microsoft PowerPoint for Microsoft 365, make a flowchart by choosing Insert > Shapes, selecting symbols from…
- Goal Seek in Excel Online: What Works in the CloudExcel for the web does not currently include the Goal Seek command, so you cannot run Goal Seek…
- Python Goal Seek Like Excel? Methods and ExamplesYes. Python can do the same basic job as Excel Goal Seek: adjust one input until a formula…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.