A Simple Jewelry Inventory Worksheet for a Small Boutique

Define the unit before you count the stock

A useful jewelry inventory template starts with a deceptively simple decision: what does one unit mean? For earrings it may mean a complete pair, not one physical earring. For a coordinated set it may mean a brooch plus two earrings. If that definition changes between receiving, selling, and counting, a neat spreadsheet can still produce a misleading total.

Write the sellable unit in its own column. Keep component counts in a separate note when they matter. Three complete earring pairs equal three sellable units and six physical earrings. A lone earring from an incomplete pair is an item you possess, but it is not automatically another sellable unit of the pair SKU.

This worksheet is for small-boutique stock control, not accounting or a promise that a product will sell. It can sit beside your existing system as a clearly dated count sheet. Decide which system is authoritative before using it; two independent editable totals invite disagreement.

Give each meaningful variant its own row

A SKU is an internal stock identifier. It should distinguish the item you actually pick from a tray, including a color or fastening option when those are separately sold. Shopify's SKU guide explains the role of these seller-created codes. Your code does not need to imitate a manufacturer's identifier or contain every descriptive word.

Use a stable format you can read aloud. For example, DEMO-E14-CLR-ST could identify an illustrative Clear stud pair, while DEMO-E14-GRN-ST identifies a green version. Keep the full color label in another column; abbreviations are helpful only if their meanings remain consistent. Do not reuse a retired code for an unrelated design.

The public product offers distinct color choices and describes the sale unit as one pair. That is enough to illustrate the structure, not to infer wholesale stock quantities. A retail availability indicator is not a count of units in your own boutique.

Build two tabs: items and movements

Put relatively stable information in an Items tab: SKU, product name, exact variant, sellable unit, component description, supplier reference, and normal location. Add a link to an approved reference image. Record the supplier's wording faithfully rather than allowing a shortened title to become a new material claim.

Use a Movements tab for changes: date and time, SKU, movement type, quantity, from-location, to-location, reference, and person recording it. Receipts, sales, returns, transfers, holds, and approved corrections should be distinguishable. You do not need an elaborate application to keep that distinction visible.

Keep customer information out of a general inventory worksheet. An internal transaction reference is usually enough to locate a sale in the authorized system without copying personal details into an operational sheet.

Reconcile one fictional row all the way through

Suppose your demonstration SKU begins the week with eight complete pairs. You receive four pairs and sell three. With no other changes, the expected physical balance is nine pairs: eight plus four minus three. Moving two pairs from a drawer to a display changes their location, not the boutique's total.

At the count, you find eight complete pairs and two loose earrings that no longer form a matching pair. Record what you observed: eight complete pairs plus two unmatched components held separately. Do not write nine available pairs simply because there are eighteen physical earrings. Matching and sale-unit completeness matter.

The discrepancy investigation might reveal a mixing error between two color rows. If the correct partners are located and checked, record the approved correction and release. If they are not found, the discrepancy stays unresolved. Preserve the original count and add a correction entry rather than silently replacing it.

The same principle applies to sets. Two brooches and four earrings do not establish two complete sets until the expected designs, variants, and components match. A component count is a useful cross-check, not the final answer.

Make counting repeatable in a small shop

Choose a clearly bounded count area and pause movement through it while counting. If a sale must occur, record that movement against the count's actual time. Mark completed trays so they are not counted twice, and keep uncounted stock physically separate from finished work.

Count by SKU and location rather than by a broad phrase such as blue earrings. Compare the product label, image, and fastening where necessary. A second person can recount a discrepancy without seeing the expected quantity first; this helps avoid simply agreeing with the spreadsheet.

Use status labels that mean one thing each: available, reserved, held, or awaiting receipt, for example. Write your definitions at the top of the sheet. An item expected from a supplier is not on hand, and an item awaiting inspection should not quietly join the sale-ready quantity.

Maintain the worksheet without turning it into a second shop

Limit editing to a named owner or a controlled routine. Protect formulas if your spreadsheet supports it, retain dated exports, and keep correction reasons short and factual. A worksheet that nobody can explain is less useful than a simple one with reliable definitions.

Review missing identifiers and unresolved holds before using counts for another buying decision. The existing boutique buyer guide addresses assortment direction; this worksheet supplies the operational picture behind that decision.

For a focused sourcing conversation, bring a category summary and your defined units to Wholesale and Private Client Inquiries. Share the information needed for the request, not the entire private stock ledger. Clear counts make the conversation more specific without promising demand, availability, or a financial result.