Trial Balance and Profit & Loss for a Jewellery Store

A jewellery store’s trial balance lists every account with its total debits and credits, but each account speaks two languages: money and metal (grams of gold, plus a count of coins). Profit and loss only tells the truth when you separate what the shop earned from making charges and buy-sell spreads from the effect of the gold price moving on the stock in the safe; closing the period records and locks that separation.

Many jewellers look at a month-end figure, see a healthy number and still cannot say whether the shop performed well or the gold price simply rose. This article tackles that problem head-on: how to read a dual-unit trial balance, how weight-based profit differs from money-based profit, and what to check before you lock an accounting period. Nightly and weekly reports are covered separately in our daily reporting guide for gold shops; here the focus is the end of the period.

What makes a jeweller’s trial balance different?

A clothing retailer carries stock at purchase cost, and until it sells, that value barely moves in the books. A jewellery store’s main asset is the metal itself, and its market value changes every day. For that reason a jeweller’s accounts normally carry three columns:

• Money balance: cash, bank, cheques and what customers or trade partners owe in currency.
• Gold weight balance: grams of gold, converted to one reference purity before anything is added together.
• Coin balance: the number of coins by type, because coins settle against coins and cannot be summed with grams.

A healthy trial balance agrees in every column. It is entirely possible for the money column to balance while the weight column does not, for example when a gold transfer to a wholesaler was posted on one side only, or when 18-carat and 22-carat weights were added without conversion. A balanced money column alone proves very little.

How to read the trial balance in three passes

1. Overall agreement: compare total debits and credits separately for money, grams and coins. Any gap means a document is incomplete.
2. Odd balances: an account that should be in debit but shows a credit, or a stock account with a negative weight, points to an error or a missing invoice.
3. Drill down: for each suspicious balance, move from the trial balance to the account ledger and from there to the journal until you reach the source document. The stock card (kardex) traces the movement of a single item in the same way.

Where does a jewellery store’s profit come from?

Profit in a gold business has several sources that behave very differently. Collapsing them into one figure makes decisions harder:

The last two rows cause most misunderstandings. In a month when gold jumps, the money-based report shows a large profit even if sales were weak. In a month when gold falls, a busy shop can show a paper loss. How stock is valued in your statutory accounts is a question for your accountant; for management purposes, keep the market effect visible as a separate line.

Weight-based profit vs money-based profit

Experienced jewellers often measure profit in grams: “How much metal did the business add this month?” That view strips out price swings and shows how well the shop actually traded. Rent and wages, however, are paid in money, so without the money view you cannot tell whether running costs are covered.

Illustrative example: a store opens the month with stock equivalent to 2,400 grams at reference purity. During the month it sells 310 grams, buys 260 grams of second-hand gold and receives 40 grams on consignment from a supplier, which creates a weight liability. Physical stock at month end is 2,390 grams, but 40 of those belong to the supplier. Net stock is therefore 2,350 grams, 50 grams below the opening figure. If making charges and margins earned in the month exceed the value of those 50 grams plus running costs, the shop genuinely made money; if not, a big money figure merely reflects a rising gold price.

The practical rule: always read the profit and loss report next to the change in net weight. Each tells half the story.

Closing the accounting period: checklist before you lock

Closing a period means its documents become final and balances roll forward. Errors that are not caught before closing travel into the next period with them.

• All sales, purchase and wholesale invoices for the period are entered; no handwritten invoices are waiting.
• Gold and coins have been physically counted and agreed with the weight balances in the books.
• Melting and separation jobs are posted with input weight, output weight and loss.
• Gold transfers and weight settlements with trade partners are confirmed by both sides.
• Cash, bank and cheque balances are reconciled with statements.
• The trial balance agrees in all three units and any odd balance is explained.
• The period’s profit and loss report is saved together with the net weight change.
• A backup has been taken.

Decide the closing rhythm in advance, monthly or quarterly, and stick to it so that periods remain comparable.

Common mistakes in gold profit reporting

• Treating physical stock as net stock: consignment or trade-partner gold may sit in your safe without being yours.
• Ignoring melt loss: weight lost in refining that is never posted shows up later as an unexplained shortage.
• Editing a closed period: backdated changes invalidate reports already used for decisions; post a correcting entry in the current period instead.
• Judging the shop by money profit alone: in a volatile market the money figure says more about the gold price than about the business.

Trial balance and P&L in Zaran jewellery accounting software

Zaran gold and jewellery accounting software builds period-end reports from the same invoices you issue every day. Features relevant to this article:

• Account ledgers, journal, stock and kardex, trial balance and profit and loss; the full financial reports (kardex, trial balance, P&L) come with the Pro plan and above.
• Automatic conversion of purities to a standard equivalent, with per-gram and per-mithqal pricing, so weights can be added correctly.
• Customer balances split into money, gold and coins, and weight settlement with trade partners (gold for gold, coin for coin), from the Pro plan.
• Opening stock and precise input and output recording for melting and separation, from the Pro plan.
• Period closing, a complete history of user changes and automatic flagging of suspicious invoices on the Elite plan.
• Every plan includes the daily dashboard with its balance bar permanently on screen, and backups are taken regularly with restore checks.

Multi-branch management is coming soon. Its screens use Persian with right-to-left layout and Solar Hijri dates. If your existing books live in Excel or another program, the P-Soft team migrates the data, with scope set in the contract. For how making charges are calculated on invoices, see our guide to gold making charges.

Frequently Asked Questions

What is a trial balance for a jewellery store?

A list of all accounts with total debits and credits, prepared separately for money, gold weight and coin count. Agreement in all three columns shows that documents are complete.

How do I calculate profit and loss for a gold shop?

Add making charges, retail margin and buy-sell spread, deduct running costs, then compare the result with the change in net gold weight so that price movements are separated from real performance.

What does weight-based profit mean?

Measuring profit in grams: how much more or less metal the business owns at the end of the period after removing gold that belongs to others.

Why does the money column balance while the weight column does not?

Usually a gold transfer was posted on one side only, a melt loss was missed, or weights of different purities were added without converting to the reference purity. Start with the ledger and the stock card.

How often should a jewellery store close its period?

The shop decides; monthly or quarterly is common. What matters is completing the physical count, partner reconciliations and a balanced trial balance before closing.

See the trial balance and profit and loss reports on sample data: request a Zaran 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