How to Create an Inventory Spreadsheet: What You Need to Know First
Last updated: September 2026
Bottom line: a working reseller inventory spreadsheet needs 8 core columns — SKU, item name, source cost, listing price, marketplace, status, date acquired, and days-on-hand — and can be built from a blank Google Sheet in under 30 minutes. Knowing how to create an inventory spreadsheet is one of the first operational habits that separates a hobby seller from someone running resale as a business, because without one there's no reliable way to answer "what's my actual margin on this SKU" or "how many days has this jacket been sitting unsold." A seller moving 40-60 items a month through Poshmark and eBay without a spreadsheet is running blind on cost basis the moment tax season or a platform payout dispute arrives.
Most new resellers put this off because it sounds like bookkeeping busywork, but the spreadsheet earns its keep the first time a buyer disputes a charge or the first time quarterly taxes require a per-item cost basis.
A seller who bought a $180 mixed-lot of women's denim containing 22 pieces needs to allocate that $180 across items before pricing any of them — without a spreadsheet tracking landed cost per unit, that allocation gets guessed instead of calculated, and margin numbers downstream become fiction.
Why a spreadsheet beats a notebook or memory
Paper logs and mental tracking both fail at scale in the same way: neither one can be sorted, filtered, or summed.
A reseller running 150 active listings across three marketplaces needs to instantly filter for "everything sourced from Goodwill Bins in the last 60 days that hasn't sold," and that's a five-second spreadsheet filter versus an impossible manual search through a notebook.
Learning how to create an inventory spreadsheet properly the first time — with consistent SKU formatting and a locked column structure — means it scales from 20 items to 2,000 without a rebuild.
How to Create an Inventory Spreadsheet: The Build Process
- Open a blank Google Sheet or Excel workbook and name the first tab "Active Inventory" — Google Sheets is the more common choice among resellers because it syncs across a phone and laptop for free, which matters when you're logging a haul from the car right after a thrift run.
- Create your columns in this order: SKU, Item Name, Category, Source, Date Acquired, Cost, Listing Price, Marketplace(s), Status, Date Sold, Sale Price, Days on Hand. That's 12 columns, and every one earns its place — cutting corners here is the single most common reason resellers rebuild their sheet three months in.
- Build a SKU format before entering a single row. A simple pattern like "PM-0142" (source initials plus a running number) keeps every item traceable back to a specific sourcing trip, which matters when a $220 lot from an estate sale turns into 30 individual listings.
- Add a Cost column that reflects true landed cost, not just the sticker price. If a $180 lot yields 22 sellable pieces, allocate roughly $8.18 per average item, then adjust individual items up or down based on relative quality — a name-brand Coach bag in that lot deserves more of the allocated cost than a plain t-shirt.
- Set up a Status column with a fixed dropdown: Sourced, Photographed, Listed, Sold, Returned. A dropdown (Data Validation in Google Sheets) prevents the typo drift that turns "listed" and "Listed" and "LISTED" into three different filter results six months later.
- Add a Days on Hand formula that subtracts Date Acquired from today's date automatically, using a simple
=TODAY()-B2style formula. This single column is what flags aging inventory — anything over 90 days on hand is a strong signal to markdown or bundle before it becomes dead stock. - Build one summary tab that sums total cost invested, total revenue, and calculates blended margin percentage across all sold items. This is the number that tells you whether a $65-per-week thrifting habit is actually profitable once shipping supplies and platform fees are subtracted.
Formatting habits that prevent a rebuild
Lock your header row (View > Freeze in Google Sheets) so scrolling through 500 rows never loses the column labels, and apply conditional formatting to flag any item with Days on Hand over 90 in red. Operators who skip these two small steps are the ones who end up rebuilding their sheet from scratch once it outgrows a screen's worth of visible data — a 20-minute setup step avoids a multi-hour cleanup later.
Quick tangent — I use the Closo Demand Insights to track what is actually moving right now, which saves me about three hours a week of manual search. Worth a peek before your next haul.
How to Create an Inventory Spreadsheet: Pitfalls That Break the System Later
Bottom line: the single most common failure mode is starting too simple, and sellers who launch with only 4-5 columns end up rebuilding their entire sheet within 3-4 months once volume passes roughly 100 active listings. Most guides on how to create an inventory spreadsheet undersell how much the early structural decisions matter, because a spreadsheet's problems don't show up on day one — they show up at month three, when 150 rows of inconsistent data can't be trusted for a tax filing or a simple margin question.
The first real pitfall is inconsistent SKU or naming formats. A seller who starts by typing free-text item names — "blue floral dress," then later "Floral Dress Blue," then "dress, blue floral" — loses the ability to search or de-duplicate reliably.
By the time that seller has 300 rows, finding whether a specific dress already has an open listing on eBay means scrolling by eye instead of running a search.
Fixing this after the fact on an established sheet with 400+ rows can eat 3-4 hours of manual cleanup, versus the 10 minutes it takes to set a SKU convention on day one.
The landed-cost allocation mistake
The second pitfall, and the one with the biggest dollar impact, is skipping proper cost allocation on multi-item lots. A reseller who buys a 40-piece liquidation lot for $310 and simply lists every item "at cost = $0" because "it came from a bulk buy" is destroying the ability to calculate real margin per item.
The honest approach: divide $310 across 40 pieces for a baseline $7.75 average cost, then weight individual pieces up or down by resale potential — a pair of barely-worn Levi's 501s might absorb $18 of that cost while a plain basic tee absorbs $2.
Sellers who skip this step consistently overestimate their margins, because the spreadsheet shows 100% margin on items that actually carried real cost basis, and that overestimation compounds into bad reinvestment decisions — buying more of a category that looks profitable on paper but isn't once cost is allocated correctly. , according to IBISWorld industry reports
A third pitfall is treating the spreadsheet as write-only — logging items in but never updating status or sale price when something actually sells.
💡 This is where Closo's tools connect: Wholesale restocks you from manifested lots, the free Crosslister gets it listed everywhere, Direct gives repeat buyers somewhere to come back to, and Finance shows you the real numbers. Learn more →
A sheet with 60 items still marked "Listed" that actually sold three weeks ago isn't tracking inventory anymore, it's generating false inventory counts, and that matters directly on multi-marketplace crosslisting where an item still shown as available on one platform after selling elsewhere risks a double-sale and a refund.
Every sale needs to trigger an update within the same day, not batched weekly, because the gap between sale and update is exactly the window where a double-sale happens.
Formula and formatting drift
The fourth pitfall shows up in the formulas themselves. A Days-on-Hand column built with a hardcoded date instead of a live TODAY() function looks fine on the day it's built and silently stops working a week later, since the number never updates.
Similarly, currency columns that mix plain numbers and text like "$45" in the same column break every SUM formula downstream — Excel and Google Sheets both silently exclude text-formatted cells from a sum, so a margin summary can quietly under-report revenue by hundreds of dollars without any error message.
Operators learning how to create an inventory spreadsheet for the first time should format the Cost, Listing Price, and Sale Price columns as Currency type from the very first row, not after the fact.
The fifth and most costly long-term pitfall is having no backup or version history.
A local Excel file with no cloud backup that gets corrupted or accidentally overwritten erases months of sourcing history and cost basis records with nothing to reconstruct it from — which becomes a real problem at tax time, when the IRS expects a cost basis for every sold item.
Google Sheets' built-in version history (File > Version History) or a simple weekly export to a dated backup file both solve this for free.
How to Create an Inventory Spreadsheet: Frequently Asked Questions
Do I need Excel, or does Google Sheets work fine for reselling?
Google Sheets works fine for the vast majority of resellers and is what most operators reach for first, since it's free, syncs automatically across a phone and laptop, and supports the same formulas and conditional formatting Excel does.
Excel becomes worth the roughly $70-$100/year Microsoft 365 cost mainly once a seller is managing multiple team members editing simultaneously or needs advanced pivot table features Sheets handles more clumsily at very high row counts, generally past 5,000-10,000 rows.
How many columns does a reseller inventory spreadsheet actually need?
Twelve columns cover the core system: SKU, Item Name, Category, Source, Date Acquired, Cost, Listing Price, Marketplace, Status, Date Sold, Sale Price, and Days on Hand.
Sellers learning how to create an inventory spreadsheet for the first time often try to start with 4-5 columns to keep it simple, but that shortcut is exactly what forces a rebuild a few months in once margin questions or tax season demands data the sheet never captured. , according to Federal Trade Commission consumer guides
Should I track inventory per marketplace or in one master sheet?
One master sheet with a Marketplace column beats separate sheets per platform for anyone crosslisting the same item across Poshmark, eBay, Mercari, and similar sites, because a split system creates the exact double-sale risk a spreadsheet is supposed to prevent — an item marked sold on one sheet but still shown active on another.
A single Status column updated the moment something sells keeps every platform's view consistent from one source of truth.
How do I handle inventory bought in bulk lots instead of single items?
Log the lot as one purchase row with the total cost, then break it into individual item rows referencing that lot's source and date, allocating the total cost proportionally across pieces.
A $150 lot yielding 25 items works out to a $6 average allocated cost, adjusted up for standout pieces and down for basics — skipping this step is the single most common reason margin numbers look inflated on lot-sourced inventory.
What's the biggest mistake first-time spreadsheet builders make?
Treating the sheet as a one-time setup instead of a daily habit. A spreadsheet that isn't updated the same day an item sells or ships starts drifting from reality within one or two weeks, and by 30 days it's often unreliable for real decisions.
Building the update step into the actual listing and shipping workflow — not as a separate end-of-week task — is what keeps the data trustworthy.
How to Create an Inventory Spreadsheet: Making It Stick
Bottom line: the spreadsheet only pays off if it gets touched every single day an item moves, and operators who build the update habit into their listing and shipping workflow keep accuracy above 95%, while those who batch updates weekly typically see 15-20% of rows drift out of sync within a month. Now that the structure is built, the real work of how to create an inventory spreadsheet shifts from setup to discipline — the sheet is only as good as the update rhythm behind it.
Where to go from a spreadsheet
A spreadsheet is the right starting point for nearly every reseller, and it stays sufficient well past the point most sellers expect — plenty of operators run 500+ SKUs across three or four marketplaces on nothing but Google Sheets and a disciplined update habit.
The point where a spreadsheet starts to strain is usually around active crosslisting to five or more marketplaces simultaneously, where manually updating stock levels and prices across every platform after each sale becomes its own part-time job.
For sellers at that stage, tools built specifically for multi-marketplace resale — including Closo's crosslisting platform, which syncs quantity and status changes across connected marketplaces automatically — pick up where a manual spreadsheet update process starts costing more time than it saves.
Whether you're still on a spreadsheet or have moved to dedicated software, the fundamentals from this guide carry forward unchanged: consistent SKUs, honest cost allocation on lot purchases, and same-day status updates. For more on sourcing, pricing, and inventory management for resale, browse the Closo blog hub for additional operator guides.
Keep going: Closo Demand Insights · Closo Crosslister · Closo Wholesale.
Restock from manifested lots. List everywhere free. Sell direct to repeat buyers. See your real margins. Closo connects wholesale sourcing, free cross-listing, an owned storefront, and margin tracking into one platform.
Start Free →No credit card required
