Jewelry business reporting: the 5 numbers every store owner should track weekly

Most jewelry store owners check their business numbers once a month, usually when the accountant asks for something or when a slow week makes them nervous enough to open a spreadsheet. By that point, the information is already history. A margin problem that started three weeks ago has had three weeks to compound. A slow product category that stopped moving in week one has been taking up display space ever since.

Weekly reporting does not require more time than monthly reporting. It requires different habits and the right five numbers. Not fifty. Not a full financial statement. Five metrics that tell you, in under fifteen minutes, whether your business is moving in the right direction and where to look if it is not.

This guide covers which numbers matter most for a jewelry store specifically, what each one tells you, and how to track them without spending your Sunday evenings in a spreadsheet.

Why jewelry stores need different reporting habits than general retail

A clothing store can look at units sold and call it a day. Jewelry is more complicated.

• Your stock is not uniform. A single slow-moving diamond piece ties up more capital than fifty fast-moving silver items. Volume metrics without margin context are misleading. A week where you sold twelve pieces at thin margins may be worse for the business than a week where you sold three pieces at strong ones.
• Your revenue sources are not all equal. A week with high gift card redemptions looks good in total turnover but does not represent new product sales. If you do not separate the two, you can mistake stored value being spent for actual business growth.
• Your cost base fluctuates with the market. The price of gold you sold last week may have moved since you bought it. If you are not tracking margin against current metal costs, your profit picture is always slightly fictional.
• Your customer base has a long tail. Jewelry customers do not buy every week. But when they come back, they often spend significantly. Missing a customer who is overdue for a follow-up is not a missed transaction today, it is a missed relationship that quietly erodes over months.

Weekly reporting for jewelers needs to account for all of this. Here are the five numbers that do.

1. Weekly turnover, split by product sales and gift card redemptions

The first number is total revenue for the week, but with one important separation: how much came from actual product sales, and how much came from gift card redemptions.

Gift card redemptions are not new revenue. The cash was collected when the card was sold. When the card is redeemed, it is stored value being spent, not a new sale. Combining the two into a single revenue figure makes your week look better than it is when redemption activity is high, and it masks what is actually happening with product sales.

Gem Logic separates gift card turnover from product turnover automatically in every report. You see both numbers side by side without any manual calculation. For a multi-currency store, each currency is broken out separately so you always know which market is moving.

Look at this number on Monday morning for the week just ended. Compare it to the same week last year if you have the data, and to the previous four weeks as a running trend. You are not looking for perfection. You are looking for direction and for anything that breaks the pattern without an obvious explanation.

2. Net profit margin for the week

Turnover tells you how much you sold. Margin tells you what you kept.

For a jewelry store, gross margin is the difference between what you sold a piece for and what it cost you, including the metal value at current market rates, the stone cost, and any workshop or setting costs. Net margin subtracts your operating costs on top of that.

A week where turnover looks healthy but margin is thin is a week worth investigating. Did a large sale go through at an unusual discount? Did you sell a batch of older pieces below current replacement cost because metal prices have moved since you bought them? Did a consignment sale generate revenue but very little net return after the owner payout?

Gem Logic calculates net profit by subtracting incoming invoices from outgoing invoices, per currency, so you see the financial health of any period without waiting for your accountant to reconcile it. The invoice profit report is available in real time, which means your weekly margin check takes as long as it takes to open the report.

If you only ever look at one number beyond turnover, make it this one. A business with growing turnover and shrinking margins is a business moving in the wrong direction, and weekly visibility is what lets you catch it before it becomes a structural problem.

3. Repair jobs completed versus open and overdue

Repairs are the most recurring revenue in most jewelry stores, and the most likely to create customer service problems if they are not tracked consistently.

Every week, you want to know three things about your repair pipeline. How many jobs were completed and ready for pickup. How many are currently open and within deadline. And how many are overdue, meaning the promised date has passed and the piece is not ready or has not been collected.

Overdue repairs are a dual problem. An uncompleted job past deadline means an unhappy customer waiting for their piece. An uncollected job past pickup date means capital tied up in a finished repair sitting in a drawer, sometimes for months. Both need active management.

Gem Logic tracks every repair ticket with deadlines, status updates, and customer notifications. The repair overview gives you the full pipeline at a glance: what is in progress, what is ready, what is overdue, and which customers have not yet responded to a pickup notification. Running this check weekly keeps the backlog from building silently.

A healthy repair operation should have a near-zero overdue rate and a short average time from completion to collection. If either number trends in the wrong direction for two or three weeks in a row, that is a workflow conversation worth having with the team.

4. Customer purchases and old gold acquisitions

This number matters more for jewelers than for almost any other retail category: how much are you buying, from whom, and at what cost.

Gold buying and trade-ins are a significant part of the business for many independent jewelers. The margin on resale depends on what you paid when you acquired the piece. Without a clear weekly picture of what you bought, at what weight, and at what price, your purchasing decisions become instinctive rather than informed.

There is also a customer relationship dimension. A customer who sells you old gold is a warm lead. They have just freed up capital and have a reason to think about jewelry. How you follow up after an acquisition is a direct revenue opportunity that most stores leave on the table.

Gem Logic records every customer purchase with weight, price, date, and a link to the customer profile in the CRM. The weekly old gold report shows total weight acquired, total spent, and individual transactions, all filterable by date range. Looking at this number weekly tells you whether your acquisition activity is consistent with your production needs and gives you a list of customers worth following up with.

5. Top-selling products and slow movers

The fifth weekly number is a quick scan of what sold and what did not.

You do not need a full inventory analysis every week. What you need is a sense of which product categories or individual pieces are moving, and whether anything that should be selling is sitting still. A piece that has not sold in four weeks on a prominent display spot is a visual merchandising question. A category that is consistently underperforming across multiple weeks is a buying or pricing question.

The flip side is equally useful. A product type that sells reliably every week is worth keeping well stocked. A piece that sells fast every time you get it in is worth reordering before you run out, not after.

Gem Logic's sales reports can be filtered by product, category, seller, and date range, so pulling a weekly top-ten and bottom-ten takes a few clicks. Export to Excel if you want to keep a running log or share it with a buying partner.

Over time, this weekly habit builds a clear picture of what your customers actually want rather than what you assume they want. That picture is worth more than any trend report from an industry association.

How to make this a fifteen-minute weekly habit

The goal is not a deep analysis session. It is a brief, consistent check that keeps you oriented and flags anything that needs attention before it becomes urgent.

The simplest structure is a fixed time slot, same day every week, with the same five reports open in sequence. Monday morning works well because it covers the week just ended and sets the context for decisions in the week ahead, much like a good daily opening routine sets up the day.

Open turnover split by product and gift cards. Note the trend versus the previous four weeks. Open invoice profit for the same period and check margin direction. Open the repair pipeline and flag anything overdue for immediate follow-up. Open customer purchases from the past seven days and identify anyone worth a follow-up call or message. Open the sales report filtered to the past seven days and scan the top and bottom performers.

That is the check. Fifteen minutes if nothing unusual surfaces. Longer if something does, but only because something genuinely warranted it, not because the process itself is slow.

Because Gem Logic updates every report in real time as sales and transactions are processed, there is no data preparation involved. The numbers are current the moment you open them. No exports, no manual tallies, no waiting for someone to pull a file together.

What to do when the numbers tell you something is wrong

Weekly reporting is only useful if it changes behavior. A number that prompts no action is just noise.

• When turnover drops two weeks in a row without an obvious seasonal explanation, that is a prompt to look at foot traffic, marketing activity, and whether a recent display change affected conversion.
• When margin falls while turnover holds steady, that is a prompt to review recent discounting, check whether metal costs have moved against your pricing, and look at whether any consignment sales are disproportionately heavy that week.
• When the repair overdue count climbs, that is a prompt to check workshop capacity, supplier timelines for parts, and whether customer communication is happening proactively before deadlines pass.
• When old gold acquisition is higher than usual, that is both a cost management prompt and a sales opportunity. Who bought in this week, and have they been followed up with?

None of these require complex analysis. They require a weekly habit of looking at the right five numbers and asking a single question each time: does this make sense, and if not, what needs to change?

Conclusion

Most jewelry store owners are not short of data. They are short of the habit of looking at the right data, at the right frequency, in a way that actually informs decisions.

Five numbers, checked weekly, cover the essential health of a jewelry business: whether revenue is growing or contracting, whether margin is holding or eroding, whether repairs are running smoothly or building up problems, whether buying activity is consistent and well-followed-up, and whether the right products are getting the right floor space.

The stores that grow reliably are usually not the ones with the most complex reporting. They are the ones where the owner looks at a small number of the right metrics every single week and responds to what they see.

Key takeaways

Track weekly turnover split between product sales and gift card redemptions to see what is actually selling. Monitor net profit margin weekly, not just at month end, to catch margin erosion before it compounds. Keep a close eye on repair pipeline status and overdue jobs to protect both customer relationships and workshop efficiency.

Review customer purchase and old gold acquisition data weekly as both a cost management and a follow-up sales tool. And run a quick scan of top sellers and slow movers every week to keep your display and buying decisions grounded in actual customer behavior rather than assumption.