Gold Shop Daily Reports: From Weight Balance to Profit and Loss

A gold shop’s daily report should answer two questions every night: “Does the gold weight on hand match the books?” and “Do cash and bank match today’s invoices?” A daily dashboard, the gold weight balance and the cash and bank movement are enough for each day; review stock cards and counterparty ledgers weekly, and the profit and loss and trial balance monthly. This article gives you a simple reading schedule: which report, when, and to answer which question.

Why Is Reporting in a Gold Shop Different From Ordinary Retail?

In an ordinary store, most reports use one unit: money. In a jewelry store at least two units run side by side: gold weight (in grams or mithqal, the traditional Iranian unit of 4.608 g, at various purities) and money. Coins are often a third unit, counted by number. Your cash drawer may balance perfectly today while a few tenths of a gram are missing from weight stock, or the other way round.

That’s why gold shop reports must show both dimensions. A system that only gives money balances hides half the picture. A prerequisite for all these reports is converting different purities to one standard equivalent so that adding weights makes sense; our gold karat conversion guide explains how.

Daily Gold Shop Reports: Every Night Before Closing

1. Daily dashboard

Your first look each evening. On one screen it should show how many sales and purchase invoices were recorded today, how much gold weight came in and went out, and total money received and paid. The goal is to see the big picture and spot anything unusual, such as a day with high sales by weight but low cash receipts.

2. Gold weight balance

In the Iranian trade this is called the “taraz-e bar”: the running weight balance of gold. Opening weight, plus purchases and receipts, minus sales and deliveries. The result must match the actual weight in the showcase and safe. This is the single most important daily report in a gold shop.

3. Cash and bank movement

Total cash in and out, card terminals, bank transfers and today’s cheques. The physical cash count must equal the system balance.

4. Today’s invoice list

A quick scan of invoices: do the rates match the rate announced for the day? Was any invoice recorded with an odd purity or trade direction? This takes a few minutes but stops many errors and abuses; more methods are in our guide to fraud control in gold shops.

Hypothetical Example: One Day’s Gold Weight Balance

Suppose a gold shop’s 750-equivalent stock was 1,250 g in the morning. These movements were recorded during the day (all figures hypothetical):

That 0.4 g gap is exactly what needs tracing the same night: a scale error, a wrong purity entered on one piece, an unrecorded invoice or something more serious. The longer you wait, the harder the cause is to find. Several small gaps on consecutive days form a pattern that must be taken seriously.

Weekly Reports: Stock Cards, Inventory and Counterparty Ledgers

Some reports are too detailed for daily use, but ignore them for a month and problems pile up. Review these once a week:

• Stock card (kardex): the in-and-out history of each item or item group. To find a piece that’s in stock but not in the showcase, or the reverse, the stock card is your first tool.
• Inventory report: stock by group and purity. Slow movers and items to reorder show up here.
• Counterparty ledgers: money and gold balances of trade partners, wholesalers and customers on account. Confirming balances weekly with the other side keeps month-end differences to a minimum.
• Cheques in progress: cheques due this week or next.

Monthly Reports: Gold Shop Profit and Loss and the Trial Balance

How to read a jewelry store’s profit and loss

A gold shop’s profit usually comes from several sources: sales profit, part of the making charge, and in buy-sell trading, the spread between buying and selling rates. On the other side come expenses such as rent, salaries, insurance and bank fees. One important point in a gold business is that part of your assets is gold itself, and its money value moves with the market; so always read the profit and loss next to the weight balance, so that real trading profit isn’t confused with the effect of rate changes. Agree on how stock is valued in your official books with your accountant.

What does the trial balance show?

The trial balance lists every account with total debits and credits. If the two sides aren’t equal, a document was recorded incompletely or incorrectly somewhere. In accounting software that builds journal entries automatically from invoices, this imbalance happens less often, but the trial balance is still the best place to spot accounts with odd balances. The general journal is where you follow entries document by document at this stage.

Summary Table: Which Report, When, for Which Question?

End-of-Day Checklist in Gold Shop Accounting Software

1. All of today’s paper or handwritten invoices have been entered.
2. Invoice rates have been checked against the day’s announced rate.
3. Weight stock has been counted and compared with the gold weight balance.
4. Cash has been counted and compared with the system balance.
5. Card-terminal transactions have been matched with terminal reports.
6. Every difference has been noted with a description and the person responsible for follow-up.
7. A data backup has been made.

If you still do all this with a notebook and spreadsheets, our comparison of Excel vs software for gold shops helps you see which step takes the most time.

Common Gold Shop Reporting Mistakes

• Looking only at money balances: a drawer that balances doesn’t guarantee the gold weight is right. Never skip the weight balance.
• Adding weights of different purities without conversion: 10 g of 24-karat gold is not the same as 10 g of 18-karat; weight reports must use one base purity.
• Delaying invoice entry: an invoice entered tomorrow makes tonight’s report unreliable.
• Ignoring small differences: gaps of a few tenths of a gram add up to a significant figure by month-end.
• Not looking at trends: comparing this month with last month often says more than one month’s absolute numbers, such as falling sales in one product group or rising receivables from trade partners.

Reports in Zaran Gold Accounting Software

Zaran, P-Soft’s gold and jewelry accounting software, includes a daily dashboard and an always-visible balance bar on every plan, so the shop’s live position is visible without opening a separate report. Full financial reports, meaning stock cards, balance and profit and loss, are added from the Pro plan; detailed ledgers, the general journal and inventory reports are also part of Zaran’s report set. If you have several users and need financial period close and a history of user changes, those are in the Elite plan. Zaran’s interface is in Persian and it is built for the Iranian gold market; the full product overview is on the Zaran gold and jewelry accounting software page.

Frequently Asked Questions

What is the most important daily report for a gold shop?

The gold weight balance, which compares the book weight of gold with the actual weight on hand. Alongside it, the cash drawer should be reconciled every night.

How is the gold weight balance different from the trial balance?

The weight balance shows the gold stock in grams; the trial balance compares debits and credits across all accounts to confirm the books are complete and balanced.

How often should I check my gold shop’s profit and loss?

At least monthly, and always next to the weight balance, so the effect of gold rate changes isn’t mistaken for real trading profit.

Is a small weight difference at the end of the day normal?

It shouldn’t be treated as normal. Even a few tenths of a gram should be traced the same day; repeated gaps are a serious warning sign.

What is a gold stock card (kardex) used for?

It shows the in-and-out history of each item and is the best tool for finding missing or unrecorded pieces.

To see the dashboard, weight balance and reports on real sample data, explore Zaran and request a demo.

Further reading

• How to Choose the Best Gold Accounting Software for Your Shop
• How to Calculate Gold Jewelry Price: Making Charge, Profit, VAT
• Gold Wholesale Accounting: Transfers and Weight-Based Settlement

Complete guide: gold and jewelry accounting software