Memo and Consignment Tracking for Jewelry Stores
Memo and consignment are how the jewelry industry actually moves goods. A retailer borrows a stone or a piece from a vendor, shows it, sells it (or returns it), and settles up. It's a system built on trust, paperwork, and tight clocks — and it's where most stores quietly lose money. A piece sits in a case for nine months, the memo expires, the customer mentions it on a Saturday, the vendor wants it back on Monday, and nobody can find the original document. This guide explains how to keep memo and consignment goods straight, and how WJewel handles the whole lifecycle in one place.
Memo vs Consignment: What's the Difference?
- Memo — a vendor lends you a specific piece for a defined period (often 30, 60, or 90 days). You owe the piece back or the money. Title stays with the vendor.
- Consignment — broader and usually longer-term. Goods sit in your store, you sell them, you remit. Title stays with the consignor until sale.
- Both — are not your inventory for accounting purposes. They are off-balance-sheet until sold.
Why Stores Lose Money on Memo
- Lost paperwork. The memo document gets buried; the piece becomes "untraceable."
- Aging blindness. Nobody runs the report, the 90-day clock blows past, and the vendor calls.
- Sold-not-reported. The piece sells, the salesperson forgets it's memo, the vendor isn't notified, and now you owe back-cost plus an awkward conversation.
- Mixed into own stock. Memo goods get counted as owned inventory, which inflates the balance sheet and triggers a tax problem.
- Vendor returns without documentation. The piece goes back, the memo isn't closed, and it shows on next month's aging report as still outstanding.
What Proper Memo Tracking Looks Like
- Separate ownership flag on every line — Owned / Memo / Consignment.
- Vendor reference — who it belongs to, plus their memo number.
- Receive date and due date — both visible at POS so a salesperson knows it's borrowed.
- Aging buckets — 0–30, 31–60, 61–90, 90+ — by vendor.
- Sold workflow — when memo sells, the system auto-creates an invoice payable to the vendor at memo cost.
- Return workflow — closes the memo with a vendor-signed return slip.
- Audit log — every status change is stamped with user and time.
The Memo Lifecycle in WJewel
- Receive — scan the vendor's memo document or import via Excel; pieces enter as Memo, not Owned.
- Tag & display — tag with barcode or RFID; the case sees it as normal stock at POS, but the system knows it's borrowed.
- Sell or return — at sale, WJewel auto-builds a payable to the vendor at memo cost. At return, scan the piece out, capture the vendor signature, and the memo closes.
- Age — daily aging report by vendor; configurable alerts at 60 / 75 / 85 days.
- Settle — push the vendor payable to QuickBooks; no double entry.
Accounting: Why This Matters at Year-End
Memo and consignment goods do not belong on your balance sheet as inventory — they are not yours. Counting them inflates assets, inflates insurance premiums, and creates a tax mismatch when the auditor pulls vendor confirmations. WJewel keeps memo and owned stock in separate columns in every report, so your physical count and your books actually agree. This is one of the most common audit findings in jewelry retail, and the easiest to prevent.
Memo for Wholesalers and Manufacturers
If you're on the other side of the transaction — sending memo out to retailers — the same data needs to flow in reverse: who has what, when it's due back, when it sells, and what they owe you. WJewel handles outbound memo with the same workflow, so wholesalers and retailers using WJewel can reconcile in minutes instead of days. See more on our software for jewelry wholesalers page.
Reports Owners Actually Use
- Open memo by vendor — total dollars on memo, oldest first.
- Memo conversion rate — what percent of memo'd dollars actually sell vs return.
- Aging dashboard — pieces approaching due date this week.
- Vendor profitability — margin earned on each vendor's memo over 12 months.
- Lost / missing — pieces flagged as on memo but not located on the last audit.
FAQs
Can a memo piece be sold on a layaway or special order?
Yes. WJewel converts it to a deposit-backed special order and notifies the vendor that the piece is committed.
Can I take a piece from owned stock and put it on memo to a customer?
Yes — that's a customer memo (a take-home approval). WJewel tracks customer memos separately from vendor memos, with their own aging.
What happens if the vendor wants the piece back early?
You can close the memo with a return at any time; the audit log captures who returned what, when, and to whom.
Does the system handle partial returns from a multi-piece memo?
Yes. Each piece on a memo has its own line and its own status.