Digital product

Gold Dealer's Daily Cash and Stock Ledger

Excel workbook to record purchases and sales, reconcile your cash drawer, and track gold stock and margin

Know exactly where your cash and your gold are, every day. Small gold buyers often lose money quietly: a drawer that doesn't add up, stock nobody can count, margins nobody has measured. This ledger gives you a simple, structured way to record every buy and sale and to check your cash at closing.

USD 15.00 · one-time payment · instant digital download

The debit will be performed by Digistore24.com. Digistore24 is the reseller and handles payment, invoicing and refunds.

What's inside

  • Purchases sheet. Seller name, phone, ID type and number, weight, tested karat, pure gold content, amount paid, payment method and cost per pure gram. Room for 500 purchases.
  • Sales sheet. Sales to refineries or buyers, with assayed karat, amount received, price per gram and gross margin. Room for 200 sales.
  • Cash sheet. Float top-ups, float taken out and expenses.
  • Daily reconciliation. Expected closing cash against counted cash, with an OK / CHECK flag. 62 days per workbook.
  • Stock and margin summary. Pure gold in stock, average cost per gram, stock value at cost and at market, gross profit and margin.
  • A start-here guide and clear colour-coding of input and result cells.

Who it's for

  • Gold buyers and small dealers
  • Jewellers handling cash and gold daily
  • Anyone who wants clean records of every transaction

Please read: what it is and isn't

This is a record-keeping tool. Karat is the value you test or assay; the workbook does not measure gold. It is not legal, tax or compliance advice and makes no promise of profit or income. Follow the licensing and record-keeping rules where you trade.

Requirements

Microsoft Excel, LibreOffice or Google Sheets.

Frequently asked questions

Does it work in my currency?
Yes. Type your own currency label in Settings.

Does it connect to a bank or app?
No. You enter the data yourself, so it stays private.

Can I use it for more than 62 days?
Save a fresh copy and change the first date in Settings.

How are mobile money payments handled?
Choose the payment method on each row. Only "Cash" changes the cash drawer; other methods are tracked separately.

What about refunds?
You have a 60-day return policy. Refunds are handled by Digistore24, the reseller.

Who do I contact?
support@nyansatek.systems