Which Reports Should a Jeweller Check Every Week? Guide

It is the end of a busy week. The counter did well, members paid, the draw went off without a hitch. Then you sit down to answer one simple question, is the scheme actually on track, and you cannot. The answer is spread across a register, a payment app on your phone, a bundle of card slips and your own memory. Half an hour later you still only have a feeling, not a figure.

That gap is what reports are for. A report is just a number, or a short list, that answers one plain question about your shop. The trick is not to read more reports. It is to read the few that matter, on the same day every week, and to act on them the same day. This guide shows which jewellery reports to check every week, what each one tells you, how to read them in minutes, and when you honestly do not need software to do it.

What is a jewellery report, and why check it weekly?

A jewellery report is a number or short list that answers one plain question about the shop, such as how much you collected or who is behind on payments. Check the important ones weekly because a week is short enough to act on. A problem caught in week one is a quick call. The same problem found at month end is a lost sale.

This matters most for a gold saving scheme, where a customer pays you for many months before buying anything. If the scheme itself is new to you, our guide to how a gold saving scheme runs from joining to redemption walks through the full journey. Across all those months, the only thing holding the scheme together is your record, and a report is how you read that record without going line by line.

Here is the founder's rule I hold to. The software does not run the scheme, trust does, and a report is how trust becomes a fact you can see. When you can show a member exactly what they paid and when, a promise turns into a record nobody can argue with. Reading weekly is what keeps that record honest, because you are checking it while everyone still remembers the week.

Which reports should you check every week?

Check five reports every week: the collection report, the overdue list, new slots sold, defaulter ageing, and a note that any draw was run and locked. Read the match between cash and digital payments every day, and the maturity list every month. Each one answers a single question, and if a report cannot answer its question in one line, drop it.

The test below is the one I use to decide whether a report is worth its space on the page. Give every report one plain question. A report that needs a paragraph to explain what it means is not a report, it is homework.

Notice that none of these questions needs a percentage or a clever chart. They are the questions you would ask a manager if you walked in on a Monday. That is the point. A good weekly report answers the questions you already have in your head, in the order you would ask them.

What does a one page weekly report look like?

The best weekly report fits on one page. It has one line for each thing you check, this week's figure beside last week's figure, and a short note on what to do next. You are not looking for exact accounting here. You are looking for the direction each number is moving, so you can act before a small slip becomes a bad month.

Read across each line, not down the page. Money collected this week against last week tells you if the scheme is speeding up or slowing down. Due but not paid points you at the overdue list. Overdue slots and their trend tell you whether your reminders are working. New slots sold tells you if the next kitty is filling. Cash and digital either match or they do not, and a gap is a job for today, not for month end.

You can rule this page in a notebook or a spreadsheet in ten minutes. The columns never change, so once it is set up, filling it in each week is quick. The daily habits that feed it, one line per payment with its proof, are covered in our guide on tracking gold scheme payments every day. The weekly page simply adds up what the daily sheets already hold.

How do you read each report in five minutes?

Read them in a fixed order, money first, then problems, then growth. Start with the collection report to see if the money came in. Move to the overdue list and defaulter ageing to see who is behind. Then read new slots sold to see if the next kitty is filling. In that order, each report sets up the next, so five minutes is enough.

Here is what to look for in each one.

• Collection report. Received against due. If they are close, the week was healthy. If a gap is opening, do not stop here, go straight to the overdue list to find the names behind the gap.
• Overdue list. The members who are behind, this week. A short list is a few reminders. A growing list is a sign your due dates or reminders need work, which our guide on where a manual scheme quietly loses money covers in depth.
• Defaulter ageing. The same overdue members, sorted by how long they have been behind. Start your calls at the top. A member three months behind is closer to leaving than a member three days behind.
• New slots sold. How fast the next kitty is filling. A quiet week here is easy to miss, because nothing is going wrong today, but it decides how full your scheme is next year.
• Draw record. If a draw fell in the week, one line confirming it was run, locked and announced to every member. Not a number, a yes.

The report you read every day, not weekly, is the match between cash and digital payments. Members pay in a mix, some in cash at the counter, some by card or a local payment method from home, and all of it has to agree with your record. Checking that the different lists agree is called reconciliation, and if the word is new, our guide to payment reconciliation and the lists that must agree explains it plainly. A mismatch is cheap to fix the same evening and expensive to unpick a month later.

How often should you read each report?

Match how often you read a report to how fast its number moves. Read the daily match every day, because a wrong entry today is easy to fix tonight. Read collections, overdue and new slots every week, because a week is short enough to act on. Read the maturity list every month, because those slots end months from now and you plan ahead for them.

The table below sets out each report, what it tells you, and how often to read it. Pin it near your desk until the rhythm becomes a habit.

The maturity list is the one owners read too late. It shows the slots about to reach the end of the scheme, when the member redeems their savings as jewellery and you hand over the gold. Read it a few months ahead so you can arrange the gold and the cover you owe winners in good time. A monthly close pulls all of this together into the full account of the month, and our guide on closing the monthly accounts in one evening shows how the weekly reports make that close painless.

A worked example: one Monday morning

All the figures here are made up to show the method. Say you run a kitty of a hundred slots. You sit down on Monday with your one page weekly report and read across, top to bottom.

Money collected is a little below last week. Not alarming on its own, but it sends you to the next line. Due but not paid is up. So the dip is not fewer members, it is members paying late. Now you know the shape of the problem before you have made a single call.

The overdue list has, say, twelve members on it this week, which is an example figure, against eight last week. Defaulter ageing sorts those twelve. Ten are only a week behind, an easy reminder. Two have been behind for over two months, and those are the two names you act on first, because those are the members drifting towards leaving. Handling them well is its own skill, covered in our guide on handling gold scheme defaulters stage by stage.

New slots sold is steady, so the next kitty is filling on schedule. The draw record shows last week's draw was run, locked and announced, so there is nothing to chase there. Ten minutes in, you have a plan for the week: send the standard reminders to the ten, call the two, and keep selling the next kitty. Without the report, that same Monday would have started with a vague worry and no list.

Common mistakes with weekly reports

• Reading only at month end. The biggest mistake. A branch or a scheme drifting off track is cheap to fix in week one and painful to fix in week four.
• Trusting one grand total. A single collection figure can look fine while cash and digital quietly disagree underneath it. Each mode has to match on its own.
• Too many reports. A screen full of charts nobody acts on is worse than five numbers you read every week. If a report has not changed a decision in months, drop it.
• No last week column. A number on its own means little. The same number beside last week's tells you the direction, which is what you actually act on.
• Reading but not acting. A report you read and then file has cost you time and saved you nothing. Every line on the weekly page should end in a small action, or it should not be there.
• Everyone sees everything. When every staff member can open every report, a number gets changed by someone who did not need to touch it. Match the report to the job.

Each of these looks harmless on the day. Together they are how an owner ends up busy all month and still surprised at month end.

When you do not need reporting software

Be honest before you spend. You may not need software for this at all. If you have one counter, a small scheme, and a tidy register or spreadsheet, you can rule the one page report by hand and read it in five minutes every week. The rhythm is what matters, not the tool. A disciplined owner with a notebook beats an expensive dashboard nobody opens.

I build software and I still say it. The software does not run the scheme, trust does, and trust comes from reading your numbers every week and acting on them, whatever holds those numbers. Software earns its place when the adding up before the reading takes hours, when you have more than one counter or branch, or when the same figures keep disagreeing and someone spends a day making them match. Below that, a spreadsheet and a habit are enough. To see where each method fits, our guide to growing a gold scheme as it gets larger shows what changes at each size.

Do you need software, and how GoldKitty does it

Once the reports take longer to gather than to read, software starts to pay for itself. The whole cost of building the report by hand, pulling figures from a register, a payment app and a card machine, is the part that eats your morning, not the reading. A tool that keeps every payment in one place has the report ready before you sit down.

That is how GoldKitty, our gold scheme software, is built. Cash, counter payments and in app payments land in one reconciled list, so the collection figure is always current. The owner's dashboard shows the morning numbers on one screen: money collected against what was expected, overdue slots, the cover building up for winners, and the next kitty's slot sales. Defaulter ageing and a maturity forecast are ready to read, and every report exports to CSV or PDF for your accountant. Roles decide who sees which report, from counter staff up to the owner. For the wider case, read why jewellers are moving the kitty to software.

Reports are also where scheme software meets the larger shop systems, and it helps to know the difference. Our guide to jewellery ERP software and whether you need it explains when reporting on the scheme is enough and when a shop needs a wider system. If you are weighing a build of your own, launching your own gold saving app covers the features and the reports to plan for from day one.

GoldKitty is modular. It is set up for each shop according to its country and its offer, and payments run through local payment gateways integrated for that market. It is white label, so members only ever see your store's name. There is no published price. Pricing is given after a demo on your own scheme, and it is one of the products appico builds and maintains, so it has a running cost after launch worth asking about at the demo.

Our take

Most owners are not short of numbers. They are short of the few numbers that matter, on one page, at the same time every week. Five reports, read in the right order, will tell you more about your scheme than a month of scattered figures ever will.

Start this week. Rule the one page report, fill it in on Friday, and act on it the same day. Do it for a month and the monthly close stops being a scramble. If the adding up keeps eating your morning, you can watch your own scheme's weekly numbers appear on one dashboard in a demo, on your own figures. Either way, you will finally be able to answer the question you sat down with: is the scheme on track, yes or no.

Frequently asked questions