Reseller Inventory Spreadsheet: Free Template and Setup

How-to basics · Updated November 21, 2026

Yes—you can make a reseller inventory spreadsheet for free in Excel by setting up a simple item table and adding a few formulas. Excel for the web is available at no charge with a Microsoft account; a spreadsheet can track what you own, what you paid, what has sold, and what still needs attention.

What “free” means for a reseller spreadsheet

A free inventory spreadsheet can mean a blank workbook you build yourself, a template offered at no charge, or a spreadsheet tool with a free plan. The first option is the most predictable: create a workbook in Excel and tailor its columns to the way you buy and sell. A template may save setup time, but check whether it requires an account, collects personal information, or locks useful features behind a paid upgrade.

Excel for the web lets you work in a browser without buying a desktop Excel license, though available features and storage can depend on your Microsoft account and current service terms. If you already have Microsoft 365 desktop Excel, you can use that instead. The layout and basic formulas below work in Microsoft Excel for Microsoft 365 on Windows; many also work in Excel for the web and Excel for Mac, although the ribbon layout may differ slightly.

A spreadsheet is a tracking tool, not an automatic connection to a marketplace. Unless you deliberately connect it to another service, you must enter purchases, sales, returns, and adjustments yourself. That manual step is the main trade-off for a no-cost setup.

Choose a tracking method before creating columns

For a small resale operation, a row per item or product type is usually the easiest starting point. If you buy three identical mugs, for example, one row can represent the group, with a quantity of three. If each item is unique—such as vintage clothing with different sizes or condition—give each item its own row and a distinct SKU or inventory ID. The ID helps distinguish similar items and makes it easier to find the correct record later.

There are two useful levels of recordkeeping:

  • Current-stock list: one row per product or unique item, with a current quantity and status. This is quick to maintain and suits a small catalog.
  • Transaction log: a separate row for each purchase, sale, return, or adjustment. This preserves a history and is more reliable when stock changes frequently, but takes more structure to summarize.

Do not mix the two methods casually. If a current-stock row records only the original quantity and total sold, it will not accurately handle later restocks or returns without extra entries or updated fields. Start with a current-stock list if your volume is low; move to a transaction log when you need a dependable change history.

Useful columns for a basic inventory sheet

Start with columns that answer practical questions: What is the item? How many are available? What did it cost? Is it listed, sold, or awaiting work? For a basic current-stock sheet, use a header row such as:

  • SKU or ID: your unique reference, such as BAG-001. Avoid relying on a product name alone when several items are similar.
  • Item name and category: a recognizable description and a broad group, such as “canvas tote” and “Bags.”
  • Date acquired: when you bought or received the item.
  • Starting quantity and quantity sold: the numbers used to calculate remaining stock. If you restock, update the starting quantity or record the restock separately.
  • Unit cost: the item’s purchase cost per unit. Decide how you will treat shipping or other acquisition costs and use that approach consistently.
  • Listing price: your current asking price, not necessarily the final sale price.
  • Condition, storage location, and listing status: optional fields that help you locate the item and know whether it is ready to sell.
  • Notes: defects, bundle details, measurements, or other information that matters to a buyer or to fulfillment.

Keep one value in each cell. For example, put “Blue, size M” in a description or attributes field rather than combining an item name, price, and stock count in one cell. Consistent data makes filters, sorting, and formulas far more useful.

Set it up in Excel

In Excel for Microsoft 365 on Windows, enter the column names in row 1 and add one record per item or product group beneath them. Select the filled range and choose Home > Format as Table, then select a style and confirm that the table has headers. A table adds filter controls to the headers and generally expands as you add rows. On Mac and in Excel for the web, the same command is available, though the ribbon arrangement can vary.

Freeze the header so column names remain visible while scrolling: choose View > Freeze Panes > Freeze Top Row. Consider using Data > Data Validation to create a dropdown for fields such as status or condition. A short fixed list—“Not listed,” “Listed,” “Reserved,” and “Sold,” for example—reduces variations such as “listed,” “Listing,” and “live” that make filtering unreliable.

Use a consistent date format and currency format. Select the relevant cells and use the Number group on the Home tab to apply a date or currency format; formatting changes how a value appears, not the underlying value. Keep an untouched backup before major changes, and save the workbook somewhere you can find it. If multiple people edit the file, agree who enters sales and when, to avoid overwriting each other’s updates.

Simple formulas that calculate stock and value

Formulas are optional, but they reduce arithmetic errors. In the following example, columns E and F hold starting quantity and quantity sold, G holds quantity on hand, H holds unit cost, I holds listing price, J holds the cost value of remaining stock, K holds the difference between asking price and unit cost, and L holds status. Enter the first formula in row 2 and fill it down for other records.

With starting quantity in E2 and quantity sold in F2, enter this in G2. If E2 is 5 and F2 is 2, the result is 3 units on hand.

=E2-F2

With quantity on hand in G2 and unit cost in H2, enter this in J2. If G2 is 3 and H2 is $8, the result is $24 of remaining stock at recorded unit cost.

=G2*H2

With listing price in I2 and unit cost in H2, enter this in K2. If I2 is $20 and H2 is $8, the result is $12 per unit before fees and other costs. This is not net profit: marketplace fees, shipping, discounts, packaging, returns, and other expenses are not included.

=I2-H2

With quantity on hand in G2, enter this in L2 to label a row sold out when its calculated quantity reaches zero. For G2 equal to 3, the result is “In stock.”

=IF(G2=0,"Sold out","In stock")

With remaining-stock values in J2:J100, enter this in J101 to total those values. If the values are $24, $15, and $10 and the rest of the range is blank, the result is $49.

=SUM(J2:J100)

These are illustrative tracking calculations, not accounting or tax advice. A listing-price-minus-cost calculation is not the same as a complete profit calculation, and the correct treatment of costs can depend on your situation. Ask a qualified accounting or tax professional about recordkeeping and reporting questions.

Keep counts accurate as items sell

Choose a routine and update the sheet close to the time each event happens. When an item sells, record the actual sale in your chosen system and reduce stock; do not leave the spreadsheet showing an item as available after it has been sold. For a returned item, check its condition before adding it back to sellable stock. A damaged return may need a separate status rather than being counted as ready inventory.

At a practical level, a weekly reconciliation can catch missed edits: compare a sample of spreadsheet quantities with the items physically on hand, and investigate differences rather than silently changing a number. If you sell across several marketplaces, record the channel and order reference in a transaction log or sales sheet. That makes it easier to trace a discrepancy without turning the inventory list into a sales ledger.

For higher volume, maintain a transaction log with fields such as date, SKU, event type, quantity change, and order or purchase reference. A restock can be a positive quantity change; a sale can be a negative one. The current-stock view can then be summarized from those events, but designing that summary carefully matters. A flat item list is simpler; a transaction log provides a more useful audit trail.

Common spreadsheet problems and safeguards

  • Duplicate IDs: similar names can refer to different items. Assign each unique item or product type a distinct ID, and check for duplicates when adding records.
  • Inconsistent quantities: use numbers only in quantity cells. Text such as “three” or “about 2” can prevent reliable calculations.
  • Accidental sorting of part of the data: sort the table using its header filters, rather than selecting one column and sorting it by itself. Otherwise, item details can become separated from their matching SKU.
  • Overwriting formulas: distinguish calculated columns visually or protect the workbook if appropriate. Keep a backup before structural edits.
  • Confusing asking price with proceeds: the listing price may differ from the amount received after negotiation, fees, shipping, or a refund. Track actual sale amounts separately if you need those figures.
  • One row for unlike items: grouping items with different condition, size, or cost can make the quantity misleading. Split them into separate records when those differences affect sale or valuation.

Inventory files can contain commercially sensitive information, including purchase costs, stock levels, and supplier details. Use a strong password on the account that stores the file, avoid sharing edit access broadly, and think carefully before placing the workbook in a public or shared folder. A worksheet password can deter casual edits, but it is not a substitute for secure account access or a backup.

Spreadsheet versus inventory software

A spreadsheet is often a sensible choice when the catalog is small, stock changes are manageable, and a person can reliably enter updates. It is flexible, easy to inspect, and can be adapted without learning a dedicated system. Its limitations are manual entry, the possibility of formula or sorting mistakes, and the lack of automatic synchronization unless you build or use a supported integration.

Dedicated inventory or marketplace software may be more suitable when you need shared access, barcode scanning, automatic order imports, bundles, multiple warehouses, or real-time stock synchronization across sales channels. Those features may come with subscription costs, setup work, or limits tied to a plan. Compare the actual features, supported marketplaces, export options, and cancellation terms before moving business records into a paid tool.

There is no universal item-count threshold at which a spreadsheet stops working. The more useful test is whether updates are regularly late, duplicate sales occur, or reconciling stock takes too much time. If those problems persist despite a clear process, compare software options. Before switching, export and retain your spreadsheet so you have a copy of your inventory history.

Frequently Asked Questions

Can I get a reseller inventory spreadsheet for free?
Yes. You can build one in a blank Excel workbook, use Excel for the web with a Microsoft account, or look for a no-cost template. Check any template’s terms and avoid assuming that a free download includes support, integrations, or unlimited features.

What should a reseller inventory spreadsheet include?
At minimum, use an item ID, description, quantity, unit cost, and status. Add fields such as acquisition date, listing price, condition, storage location, and sale channel when they help you manage your actual workflow.

Can Excel automatically update inventory when I make a sale?
Not from a basic standalone spreadsheet. You must enter the sale yourself unless you set up a supported integration or use software that syncs with your marketplace. Confirm how any integration handles cancellations, returns, and stock changes before relying on it.

Should each item have its own row?
Give unique goods their own row when condition or characteristics differ. Identical units can share one row with a quantity, provided they have the same cost and other relevant attributes and you can track quantity changes reliably.

Is a spreadsheet enough for taxes or profit tracking?
A stock sheet can preserve useful purchase and sales details, but a simple inventory formula does not calculate complete profit or determine tax treatment. Keep appropriate source records and ask a qualified tax or accounting professional about your obligations.

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.