Gold Shop Accounting Software Setup: Entering Opening Balances

To set up gold shop accounting software properly, fix a cut-off day, count your stock by weight and karat at the close of that day, enter each customer’s and trade partner’s balance in money, gold and coins after they confirm it, record cash, bank and cheques, and then test everything against a trial balance. Keep the old ledger running alongside until your daily close matches in both.

What “setting up” gold accounting software really involves

Many jewellers think going live means installing the program and creating a few user accounts. That part is quick. The real work is giving the system a correct starting point, because every weight balance, profit figure and customer statement it produces afterwards is built on top of it. That starting point has three layers:

1. Master data: items with your own coding, the list of customers and trade partners, cash drawers and bank accounts.
2. Opening balances: gold in stock, what each customer and supplier owes you or is owed, cash on hand, bank balances and outstanding cheques at the moment of cut-off.
3. Daily routine: from the day after cut-off, every invoice, receipt and payment goes into the software only.

If layer two is rushed or guessed, layer three can be perfect and your weight and money balances will still never agree with reality. That is why this guide spends more time on balances than on invoicing.

Choosing your cut-off day

The cut-off day is the border between the old books and the new system. Anything before it stays in the ledger or spreadsheet; anything after it lives only in the software. A few practical pointers:

• Pick a close of business followed by a day you can spend counting without customers in the shop.
• Avoid peak seasons, festival weeks and days when the gold price is swinging hard, so trade partners have time to confirm balances.
• Where possible, start at the beginning of a month so monthly reports begin cleanly.
• Tell every staff member the exact hour after which nothing is written in the old book.

Clean the ledger and spreadsheet before you migrate

Moving messy data into a clean system just organises the mistakes. Work through this checklist in the days before cut-off:

• Merge duplicate customer names; “Ahmed K.”, “A. Khan” and “Ahmed (wholesale)” may be the same person.
• Leave out accounts that have been at zero and inactive for years; migrate only live accounts.
• Prepare a short statement for every trade partner and major customer so you can agree the balance with them before cut-off.
• List every post-dated cheque received and issued, with due dates, from the cheque book and stubs.
• Flag items held for customers: repairs, custom orders, items left in safekeeping. These are not your stock.
• Finalise your item coding table so nobody is inventing codes on counting day.

Entering opening stock by weight and karat

Counting on cut-off day is a two-person job: one weighs, one writes. Every item is recorded with its code, weight to the milligram and karat; scrap and melted gold with its tested purity. We cover code design and the counting routine step by step in our article on gold and jewellery inventory coding. Here is how to group the stock so nothing is missed or double-counted:

Once entered, the system’s total weight converted to a standard purity should equal the total on your count sheets. Zaran converts different karats to their standard equivalent automatically (18K to 750, for example), so that comparison takes a single glance.

Moving customer and trade balances off the paper ledger

In a gold business, every counterparty balance has three dimensions: money, gold and coins. The classic mistake is converting everything into one money figure at today’s price. It looks tidy, but a supplier you owe 50 grams of gold will want 50 grams back, not the amount it was worth on cut-off day. Enter each balance in its own unit. A fictional example:

Double-check the direction of every balance. One large balance entered the wrong way round is the most common reason a trial balance refuses to agree in the first weeks. For big trade partners, confirm the figure by phone or with a signed statement before you key it in. Our guide to customer balances in a gold shop explains how to keep the three balance types apart afterwards.

Cash, bank and cheques in transit

Count cash at the close of cut-off day and record each drawer separately. Take each bank balance from that day’s bank statement, not from memory or the ledger. Enter cheques one by one with number, bank, due date and counterparty. If you only enter a total, you will not know which cheque settles which debt when it falls due. Record bounced or disputed cheques with their status too, so they are not forgotten.

The final test: trial balance and weight balance

With everything entered, it is time to test. The trial balance shows whether total debits equal total credits; the weight balance shows whether the gold recorded matches the gold counted. Ask three questions:

1. Does total stock weight in the system equal the count sheets?
2. Do cash and bank balances match the drawer count and the bank statement?
3. Do a handful of randomly chosen customers and partners match their confirmed statements?

If any answer is no, find the difference before the first invoice. Reading these reports is covered in our article on the gold shop trial balance and profit and loss.

Running old and new side by side

During the first days, record every sale in the new system and, at closing, also work out the cash and weight summary the old way. The point is not to do the job twice. It is to know, if a difference appears, whether it comes from the opening balances or from how daily entries are being made. Once several consecutive daily closes match without a gap and staff are comfortable with invoicing and cash, archive the old ledger and stop writing in it.

Which setup features are in which Zaran plan?

In plain terms: to migrate with opening stock, cheques and a full trial balance, you need at least the Pro plan. Year-end period closing and seeing who changed what are in Elite.

Data migration by the P-Soft team

You do not have to key all of this in alone. The P-Soft team migrates your existing data from Excel or your previous software into Zaran; exactly what is moved and to what depth is agreed in your contract and depends on your plan. Even then, the physical count and confirming balances with counterparties remain the shop’s job, because nobody but you can vouch for what is in the display case.

Common setup mistakes

• Writing deals in the old book after cut-off, which unbalances everything again.
• Converting partners’ gold balances into money “to keep it simple”.
• Counting customers’ repair and safekeeping items as stock.
• Entering a cheque total instead of individual cheques.
• Starting to sell before checking the trial balance.
• One shared login for everyone instead of a user per person.

Frequently Asked Questions

At what price should opening gold stock be entered?

Gold stock is fundamentally weight and karat. Record each item with code, weight and karat; its money value follows from the day’s price rather than being frozen at cut-off.

Do I need to enter previous years’ transactions?

Usually not. Cut-off balances are enough to start, and old ledgers are archived. If history sits in Excel or older software, agree the migration scope with P-Soft in your contract.

How do I enter a trade partner’s gold balance?

By weight at a base purity, separate from money and coin balances. Check the debit or credit direction against the partner’s confirmed statement.

How long should I keep the old ledger running?

Until several daily closes in a row match without a difference and staff are confident with invoices and cash. Then archive it.

Which Zaran plan do I need for opening stock?

Opening stock, cheques, wholesale trading and full reports start at the Pro plan. Item coding, cash and bank, and counterparties are in every plan.

Ready to move your shop’s books from paper or spreadsheets into dedicated gold and jewellery accounting software? Request a Zaran demo there and we will walk through the setup and data migration for your own shop.

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