A gift shop sells a few of a great many things, which makes its inventory awkward: hundreds of items, most selling one or two a week, and a third of the year's sales in six weeks. Counting every card by its design isn't worth the time. Counting nothing means buying blind. The workable middle has four parts. Track your fast lines item by item. Track everything else by group, at an average cost. Treat seasonal stock as its own thing, with a date after which it's worth a fraction. And keep consignment goods on the sheet, and out of the value, because they aren't yours. Then count on a rota, and look at what each category has tied up against what it sells. Below is a sheet for a made-up shop in late November, how to buy for a season, and the file.
The short version
- Fast sellers by the item. Slow, varied lines by the group.
- Every row: on hand, reorder level, cost, supplier, where it is.
- Seasonal lines have a sell-by date, not a reorder level.
- Consignment: on the sheet, not in your stock value. Pay the maker when it sells.
- Count one category a week.
- TaroStack counts on a phone and shows what's sitting. More below.
An example sheet
| Item | Category | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Greeting cards, assorted | Cards and paper | 310 | 200 | $1.75 | $542.50 | OK |
| Soy candle, 8 oz, local | Home | 22 | 18 | $12.00 | $264.00 | OK |
| Earrings, assorted (consignment) | Jewelry | 44 | 30 | $9.00 | $396.00 | OK |
| Chocolate bar, local | Food | 36 | 48 | $3.10 | $111.60 | REORDER |
| Jam, 8 oz, local | Food | 19 | 24 | $5.50 | $104.50 | REORDER |
| Holiday ornament, glass | Seasonal | 140 | $4.20 | $588.00 | OK |
Thirteen rows in all. The sheet's total is $3,218.30, of which $794 is consignment jewelry and mugs that belong to their makers. The shop's own stock is $2,424.30.
By item or by group
| Kind of line | Example | Track |
|---|---|---|
| Few designs, steady sales | The local candle, the jam, the best-selling mug | By item: one row each |
| Many designs, each selling slowly | Greeting cards, earrings, stickers | By group: one row, a count, an average cost |
| One-offs | A single hand-carved bowl | By group, or not at all under a set value |
Cards are the classic case. Three hundred cards in eighty designs is one row: 310 at an average of $1.75. When you reorder, you walk the spinner and fill the empty pockets. You don't need a spreadsheet to tell you which pocket is empty.
The test for moving something from a group to its own row: would you be annoyed to run out of it? If a particular card sells ten a week, give it a row.
Seasonal stock
Seasonal goods break the usual rule. There's no reordering: the order went in in the summer, it arrives once, and on a known date it's nearly worthless.
| Holiday ornaments | Advent calendars | |
|---|---|---|
| Bought | 240 | 60 |
| Sold by November 20 | 100 | 26 |
| On hand | 140 | 34 |
| Worth little after | December 24 | December 1 |
| Weeks left | 5 | Under 2 |
| Selling a week so far | 10 | 3 |
The ornaments have sold about ten a week since they went out, and the big weeks are ahead: they may be fine. The advent calendars aren't. Thirty-four left, three a week, and after December 1 nobody wants one. The time to mark them down is now, while a discount still sells them, not on December 2.
Write three numbers when you place a seasonal order: how many, the date they stop selling, and the date you'll start marking down if they're behind. Then keep what's left in a note for next year's order: "bought 240, sold 190" is worth more than any forecast.
How much to buy
A simple version of what retailers call open-to-buy, for one category and one month:
| Home, December | |
|---|---|
| Sales you expect, at cost | $2,400 |
| Stock you want at the end of the month | $900 |
| Less stock on hand now | −$1,150 |
| Less already on order | −$600 |
| You can still buy | $1,550 |
It stops the commonest gift shop mistake, which is buying at a trade show by eye. If the number is $1,550, the lovely $2,000 range of ceramics waits.
Consignment
Local makers' work on consignment is on your shelves and isn't your stock. Keep it on the sheet, marked, so you know what's there and what's sold. When a piece sells, you owe the maker their share, here 60%. Count it with the maker when they restock, and both sign. What the maker should be keeping at their end is in craft business inventory spreadsheet, and terms worth writing down in wholesale agreement template.
Counting
A full count of a gift shop is a long evening. Do it once a year, for the accounts. In between, count one category a week: jewelry this Monday, food next. Small, expensive and easy to pocket gets counted most. The method is in how to count inventory. What the shop should make on what it sells is in gift shop profit margin, and the plan for the business in gift shop business plan.
Food lines have dates. Chocolate and jam get a row on the dated-stock tab, oldest to the front.
Get the sheet
Download the gift shop inventory sheet. Four sheets: inventory with value and a REORDER flag, a lots sheet for seasonal orders, dated food and consignment drops, 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
The sheet is right on the night you count. A gift shop in December sells two hundred items a day, and nobody updates a spreadsheet from the till roll. By the second week the candle row says 22 and the table is empty. The reorder that should have gone on the 5th goes on the 14th, and arrives on the 23rd.
How TaroStack does it
TaroStack keeps the counts moving between full counts.
Counting on a phone, by category, in a few minutes, as often as you like. It suggests what to count first.
The count shows what a difference is worth before it's posted: six missing pairs of earrings is a dollar figure.
A reorder list in days of cover, with each supplier's lead time, so the candles are ordered while there's still a week of them.
Lots and dates for food lines, with an alert before a best-by passes.
Every adjustment carries a reason: damaged, lost, sample. Shrink is reported by reason and item.
Stock value by month, for the accountant.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Count a category | Clipboard, then type it in | On a phone, at the shelf |
| When to reorder the candles | When the table looks thin | The reorder list |
| What went missing | A feeling | The count, in dollars |
| Chocolate near its date | Found in March | An alert |
TaroStack isn't a till. It connects to Square. Stock, counting and the reorder list are on every plan; Starter holds 50 items, and a shop's range wants 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.
