Assign SKU and bin before the item enters your Poshmark closet.
Poshmark guide
Poshmark inventory spreadsheet for closet reports, SKUs, bins, offers, and bundles.
Keep your closet report, seller-created SKU, storage bin, offer history, bundle notes, platform fee, and true profit in one row. The goal is to know where the item lives and what it earned without digging through old order messages.
Poshmark worksheet columns
Use a marketplace fee column for the flat low-price fee or the percentage fee on higher-value sales.
A B C D E F
| Field | Category | Tracks | Example |
|---|---|---|---|
| SKU | Inventory | Internal stock number used to connect the listing, bin, and sale record. | EX-SKU-001 |
| Item Title | Inventory | Short listing title or product description. | Example denim jacket |
| Platform | Listing | Marketplace where the item is listed or sold. | eBay |
| Date Listed | Listing | Date the item first went live so aging inventory is easy to review. | 2026-05-01 |
| List Price | Listing | Current asking price before offers, discounts, or promoted listing fees. | $38.00 |
| Purchase Cost | Cost | Item-level cost of goods before platform fees and shipping. | $12.00 |
| Bin Location | Storage | Shelf, tote, rack, or box location used to pull sold items quickly. | BIN-A03 |
| Sold Date | Sales | Date the order was paid or accepted. | 2026-05-21 |
| Sale Price | Sales | Buyer-paid item price before marketplace deductions. | $36.00 |
| Marketplace Fee | Profit | Platform commission, payment processing, or selling fee deducted from the sale. | $5.22 |
Poshmark guide intro advertisement
Build the row around closet movement
Poshmark inventory changes through shares, offers, bundles, and occasional relists. A useful spreadsheet keeps the closet report fields separate from the operational fields only you know: purchase cost, SKU, bin location, flaws, and bundle math.
| Field | Use it for | Example |
|---|---|---|
| Closet report | Use exports to audit titles, listing status, and sold dates. | Monthly active closet check |
| SKU/bin | Put the SKU in the listing and on the storage label before sharing. | EX-POSH-BIN-B04-018 |
| Offers | Track offer sent, offer accepted, and final sold price. | $38 list / $30 offer |
| Bundle | Keep included SKUs together so cost and profit are not guessed later. | 3-item bundle: EX-B04-018, EX-B04-022, EX-A01-006 |
| Fee | Use one fee column for the flat low-price fee or percentage fee. | $6.00 marketplace fee |
Use one notes field for size flaws, bundle contents, and relist history.
Move stale closet rows into a review tab before discounting or rephotographing.
Formula guidance
Poshmark profit formulas
Use sale price, purchase cost, prep cost, and the Poshmark platform fee as separate inputs before reviewing profit.
A B C D E F
True profit
Shows item-level cash profit after cost, prep, shipping, fees, and promotion costs.
=Sale Price + Shipping Charged - Purchase Cost - Prep Cost - Shipping Cost - Marketplace Fee - Promotion Fee
Use buyer-paid shipping as revenue only when it is listed separately from the item price.
Gross margin
Compares profit quality across categories, sources, and marketplaces.
=Net Profit / Sale Price
Format the cell as a percentage and review low-margin rows before sourcing more similar items.
Sell-through rate
Measures how much listed inventory sold during the period you are reviewing.
=Sold Items / Listed Items
Run this on a weekly or monthly summary tab, not on each item row.
Days to sell
Flags stale inventory and shows how quickly each SKU turns into cash.
=Sold Date - Date Listed
Leave the cell blank until the item sells so active listings do not distort averages.
When the closet outgrows manual tracking
Start with better bin labels and mailers. Consider crosslisting tools when bundle notes, relists, and multi-platform stock checks take over listing time.
Poshmark guide upgrade advertisement
Other marketplace worksheets
Switch sheets if you also sell on another platform. Each guide keeps the same SKU and profit structure.
Poshmark inventory spreadsheet FAQ
What should a Poshmark inventory spreadsheet track?
Track SKU, title, category, condition, bin location, list price, offer price, sale price, platform fee, bundled sale notes, sold date, and net profit.
How do I use Poshmark closet reports with a spreadsheet?
Use closet reports to review active and sold listings, then keep your own SKU, bin, purchase cost, and offer notes in the master spreadsheet because those fields are seller-specific.
How should Poshmark bundles be recorded?
Record the bundle order as one sale row, list the included SKUs in the notes field, and split purchase costs before calculating net profit.
Poshmark guide FAQ advertisement