A boutique's stock can't be counted by product, because nobody buys "a linen shirt". They buy a white one in a medium. So a boutique inventory has one row for each style, color and size, and the sheet's most useful job is showing a broken size run: five shirts on the rack, none in the size most people ask for. Beside that it has to handle two things basics don't have. Seasonal pieces arrive once and have a date after which they're worth much less, so they get a mark-down date where basics get a reorder level. And consignment from local makers sits on your racks without being yours. Below is a sheet for a made-up boutique in November, how to read a size run, what to do with the season's leftovers, and the file.
The short version
- One row for each style, color and size.
- Reorder basics by size, not by style.
- Seasonal pieces: a mark-down date, not a reorder level.
- Consignment on the sheet, out of your stock value.
- Count a rack a week; everything twice a year.
- TaroStack counts on a phone and flags what's sitting. More below.
An example sheet
| Item | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|
| Linen shirt, white, S | 2 | 2 | $28.00 | $56.00 | REORDER |
| Linen shirt, white, M | 0 | 3 | $28.00 | $0.00 | REORDER |
| Linen shirt, white, L | 3 | 2 | $28.00 | $84.00 | OK |
| Wrap dress, navy, S | 1 | 1 | $46.00 | $46.00 | REORDER |
| Wrap dress, navy, M | 1 | 2 | $46.00 | $46.00 | REORDER |
| Wrap dress, navy, L | 4 | 1 | $46.00 | $184.00 | OK |
Twelve rows in all, $2,040 on the sheet, of which $132 is a local jeweler's earrings on consignment. The shop's own stock is $1,908 at cost.
Reading a size run
"Five linen shirts" sounds like enough. By size: two smalls, no mediums, three larges. The shirt is sold out for the customers most likely to buy it.
| S | M | L | |
|---|---|---|---|
| Ordered in September | 4 | 8 | 4 |
| Sold | 2 | 8 | 1 |
| On hand | 2 | 0 | 3 |
Two things to take from that. Reorder by size: the order to place is mediums, and perhaps one small, not "a dozen shirts". And next season's buy: this shop sells twice as many mediums as it planned for and almost no larges in this cut. Write the size curve that actually sold beside the one you bought, and next year's order writes itself.
The wrap dress tells the opposite story. Four larges left and one each of the others: the larges are the mark-down candidates, and the style isn't the problem.
Seasonal pieces
A wool coat bought in September can't be reordered and won't sell in March. It doesn't get a reorder level. It gets a date.
| Piece | Bought | Sold | Left | Mark down from |
|---|---|---|---|---|
| Wool coat, camel | 12 | 6 | 6 | January 15 |
| Summer sundress, floral | 24 | 17 | 7 | September 1 (now 40% off) |
Six coats in ten weeks with the cold months ahead is on track. The seven sundresses have been at 40% off since September and are taking a rack in November. Three honest choices: a deeper cut to clear them this month, pack them away for a spring sale, or donate them. Each week they hang there, they cost you the space a coat would earn in.
Set the mark-down date when the order arrives, and set the steps too: 25% off on the date, 40% a month later, out the month after. Deciding in advance is easier than deciding when you're looking at a dress you still love.
Consignment
Earrings from a local jeweler are on your sheet so you know what's in the case. They aren't your stock: you pay the maker their share when a pair sells, and they can take the rest back. Keep them on rows marked with the maker's name, count them when the maker visits, and both initial the count. What the maker keeps at their end is in craft business inventory spreadsheet.
Counting
Clothes move: tried on, put back on the wrong rack, left in a fitting room. Count one rack a week against the sheet, and everything at the end of each season before the mark-downs. Small, expensive and easy to pocket (jewelry, scarves) gets counted most often. The method is in how to count inventory. A sheet for a shop with fewer sizes and more gifts is in gift shop inventory, and for printed tees in t-shirt inventory template.
Get the spreadsheet
Download the boutique inventory spreadsheet. Four sheets: inventory by style, color and size with value and a REORDER flag; a lots sheet for each season's orders with mark-down dates; a count sheet to print; and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Forty styles in three colors and four sizes is 480 rows. Each sale should take one off the right row, and on a Saturday nobody opens a spreadsheet between customers. By closing the sheet is thirty sales behind, and the medium that the sheet says is there was sold at eleven.
How TaroStack does it
TaroStack keeps the count close to the rack between full counts.
Each style, color and size is an item, with its own stock and reorder level.
Counting on a phone, rack by rack. It suggests what to count first, and shows what a difference is worth before it's posted.
A reorder list in days of cover, by supplier: the mediums, before they're gone.
Dates on seasonal orders, with an alert as a mark-down date comes up, and what the stock is worth.
Every adjustment carries a reason: damaged, lost, sample. Shrink is a figure, by item.
Stock value by month, for the accounts.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Count a rack | Clipboard, typed in later | On a phone, at the rack |
| Reorder the right size | Read 480 rows | The reorder list |
| When to mark down | When you notice | An alert on the date |
| What went missing | A feeling | The count, in dollars |
TaroStack isn't a till. It connects to Square. Stock and counting are on every plan; Starter holds 50 items, so a boutique's sizes want Growth, at $39 a month for 3,000. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
