# The Seasonal Inventory Rotation Spreadsheet: Time Your Sourcing So Heavy Items Sell Before Storage Eats Your Margin

_By GradeThread Team · Published October 2, 2026_

> Source heavy seasonal items 8-12 weeks before buyers search, then track holding cost per item. Here's the spreadsheet that keeps storage from eating your margin.

A seasonal inventory planning spreadsheet for resellers works by mapping each clothing category to a sourcing window, a listing window, and a sell-by date, then charging every unsold item a monthly holding cost. Source heavy items like coats and boots weeks before buyers start searching, and you list into rising demand instead of storing into falling demand.

Here is the failure mode. You buy 30 winter coats in January because the racks are full and the prices feel right. Buyers on eBay have been searching since October. By the time your coats are photographed and listed, you are selling into the last six weeks of the season, then holding them for nine months. That is the storage tax, and most resellers never put it on a line item.

## Why heavy seasonal items punish bad timing

Light items forgive mistakes. A tee that misses its season takes up a sliver of a bin. A parka takes up the space of eight tees. Heavy categories carry three costs that compound when timing slips:

- **Space.** Coats, boots, and fleece eat shelf and bin volume out of proportion to their sale price.
- **Capital.** Cash tied up in off-season stock cannot buy in-season inventory that turns faster.
- **Condition drift.** Long storage can introduce odor, compression creases, and pest or moisture risk. An item that was Excellent at intake can slide toward Very Good or Good by the time you relist it, and you will have to re-grade it.

This is inventory holding cost for seasonal items in practice. The purchase price is only the start of your cost basis.

## The sourcing lead-time rule: buy before the search spike

Buyer demand for a season starts earlier than most resellers expect, and thrift supply often peaks later than demand. That gap is your opportunity. The working rule: when you source seasonal clothing categories, aim to have items listed roughly 4-6 weeks before your category's demand peak, which means sourcing 8-12 weeks ahead once you count cleaning, measuring, photographing, and listing.

Treat those week ranges as a starting point, not a law. Your own data from last year's sold items overrides any rule of thumb. Pull your sold dates by category, find the month with the most sales, and count backward.

## Winter vs summer sourcing strategy for resellers

The two seasons behave differently because the items differ in size and price. A practical winter vs summer sourcing strategy for resellers looks like this:

| Factor | Winter (coats, knits, boots) | Summer (shorts, dresses, sandals) |
| --- | --- | --- |
| Storage volume per item | High | Low |
| Typical price per item | Higher | Lower |
| Cost of missing the window | Steep: bulky stock held for months | Moderate: easy to store |
| Sourcing lead time | Start in late summer | Start in late winter |
| Best use of the off-season | Buy cheap, store only what fits your plan | Buy in bulk, store compactly |

The takeaway: summer stock is cheap to hold, so you can afford to be early. Winter stock is expensive to hold, so you need to be precise about quantity and timing.

## Build the spreadsheet: seven columns that matter

You do not need a complicated workbook. You need one row per category and the right columns. Build a tab called Season Plan with these:

1. **Category.** Use specific types: wool coats, puffer jackets, fleece, boots, linen shorts. Broad labels like "outerwear" hide the differences.
2. **Peak sell month.** Pull this from your own sold history, month with the most sales.
3. **Target list-by date.** Peak month minus 4-6 weeks.
4. **Source-by date.** List-by date minus your intake time, usually 2-4 weeks for cleaning, measuring, and photos.
5. **Average days to sell.** Median, not average if you have outliers.
6. **Monthly holding cost per item.** Space plus capital cost, explained below.
7. **Sell-by date.** The date after which the item is either marked down, rotated, or donated.

[Screenshot placeholder: Season Plan tab with category rows and color-coded source-by dates]

## Calculate seasonal turnover rate by clothing type

Seasonal turnover rate by clothing type tells you how many times a category can cycle through your shelf in a season. Use this formula for each category:

**Turnover rate = items sold in the season / average items in stock during the season.**

Example, using illustrative numbers: you average 20 puffer jackets in stock across the season and sell 30. Your turnover rate is 1.5. If you average 20 linen shorts in stock and sell 60, the rate is 3.0. Shorts earn their shelf space twice as fast, so they can accept a lower margin per item and still win.

Compare this to your days-to-sell number. A category with a long days-to-sell and a short selling season is a risk. Cap the quantity you buy for it.

## Put a price on storage: holding cost per item

Add a holding cost to every row. A simple version:

- **Space cost per item per month** = monthly cost of storage space / number of items it holds.
- **Capital cost per item per month** = cost basis x your monthly opportunity rate (what that cash could earn if redeployed).
- **Holding cost per month** = space + capital.

Example, for illustration: a coat with a $14 cost basis sits in a bin where space works out to $0.60 per item per month. With a 3% monthly opportunity rate, capital cost is $0.42. Holding cost is about $1.02 a month. Hold it for nine months off-season and you have added roughly $9 to a $14 cost basis, before gas, cleaning, fees, or shipping supplies. A coat that sells for $45 now might net $18 after fees and shipping. Add $9 of storage and the margin shrinks by half.

Multiply holding cost by months until the next peak, and you can see immediately which items are worth carrying over and which should be sold at a discount now or donated.

## Grade before you store, not after

Off-season is the best time to grade because you are not rushing. Grade each item at intake using the five factors: Fabric Condition, Structural Integrity, Cosmetic Appearance, Functional Elements, and Odor & Cleanliness. Record the tier (NWT, NWOT, Excellent, Very Good, Good, Fair, or Poor) in your spreadsheet.

Why this matters for rotation: tier drives the carry-or-cut decision. An NWT or Excellent coat can justify carrying over because it will still command a strong price next season. A Fair item with a Functional Elements issue like a stuck zipper is a weak candidate to store for nine months. Sell it into the current market, repair it if the math works, or move it on.

Re-check condition when you pull stored items. Odor & Cleanliness is the factor most likely to change in storage, and a returned item for an undisclosed smell costs you more than the item earned. A note in your sheet of the original tier and the re-check tier also helps you spot a storage problem early.

## The monthly rotation review

Once a month, spend 20 minutes on this checklist:

1. Sort the sheet by source-by date and list what you should be buying this month.
2. Sort by sell-by date and pull anything past due.
3. Compare actual sold counts to your plan and adjust next month's quantity caps.
4. Recalculate holding cost on anything still in stock past its average days to sell.
5. Mark down, bundle, or donate items whose holding cost now exceeds the expected margin.

That last step is the one that protects your cash. Selling at a smaller margin now beats holding an item for a margin that storage already consumed.

## Try it on one category first

Do not rebuild your whole operation. Pick your single heaviest seasonal category, pull last year's sold dates, and fill in the seven columns for it. If you want the grade and holding cost to sit on the same row as each item, FlipDesk can track tier, cost basis, and days in stock together. Try grading one coat at intake and see how it changes your carry-or-cut decision.

---

Canonical: [https://gradethread.com/blog/seasonal-inventory-planning-spreadsheet-for-resellers](https://gradethread.com/blog/seasonal-inventory-planning-spreadsheet-for-resellers)