Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Daily Gold Price Board for Your Shop

Daily Gold Price Board for Your Shop

Free sheet for gold shops · A clean price board to hang in the shop and update every day. · العربية

Type today's market prices once and this sheet makes a clean price board to print and hang in the shop: buy and sell per gram for each karat, the gold pound (8 g of 21K) with its half and quarter, and a table of bar prices with the usual fee and the VAT on it. Your shop's own discount, premium and rounding are settings you type; the board applies them the same way to every price.

Download PDF174 KBDownload Excel63 KB

Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells; everything else is worked out for you.

Preview of the first page of the "Daily Gold Price Board for Your Shop" sheet, with its table and worked example

How to use it

  1. Type the market prices: In "Prices" enter today's buy and sell prices per gram for 24K, 21K and 18K, your shop's name, and the date and time of the update.
  2. Set your shop's rates: Type your discount on the buy price, your premium on the sell price and the rounding step. The example figures are only illustrations.
  3. Check the board: Open "Board": the price per gram, the gold pound and the bar table are worked out from your prices and settings.
  4. Print and update: Print it on A4 (or scale it down for A5) and update the yellow prices whenever the market moves.

Example the board of 3 Nov 2026

Market prices in the file: 24K sell 7,032.37 and buy 7,009.37, 21K sell 6,180.25 and buy 6,160.25, 18K sell 5,276.00 and buy 5,259.00. The example shop takes 0.5% off the buy price and adds 0.5% to the sell price, rounded to the nearest pound (example figures, not a recommendation). Bars use the board's sell price and the usual fee per gram.

WeightGold value (24K)Fee per gramBar fee14% VAT on the feeIndicative price
1 g7,068.00210210.0029.407,307.00
2.5 g17,670.00150375.0052.5018,098.00
5 g35,340.00100500.0070.0035,910.00
10 g70,680.0090900.00126.0071,706.00
20 g141,360.00901,800.00252.00143,412.00
31.1 g219,814.80852,643.50370.09222,828.00
50 g353,400.00854,250.00595.00358,245.00
100 g706,800.00858,500.001,190.00716,490.00

Price per gram on the board Example

KaratWe buy (EGP/g)We sell (EGP/g)
24K6,974.007,068.00
21K6,129.006,211.00
18K5,233.005,302.00

Gold pound on the board Example

CoinWeightWe buyWe sell
Gold pound8 g49,032.0049,688.00
Half pound4 g24,516.0024,844.00
Quarter pound2 g12,258.0012,422.00

The usual bar fees are the published figures of 3 Nov 2026; the current ones are in Qintar's calculators. Bar prices in the table are indicative, and every shop sets its own fees.

Explained: A price board customers can trust

The price board is one of the first things a customer reads in a gold shop. A clear, dated board that matches the price on the invoice does more for trust than any sales talk.

A good board shows two prices per karat. "We sell" is the price per gram at which the customer buys; "we buy" is the price per gram at which the shop buys back. Showing both side by side answers a customer's first question, and the gap between them is plain to see. The board in this sheet shows 24K, 21K and 18K, each rounded to the step you choose.

Next come the coins. The Egyptian gold pound is 8 grams of 21K, the half pound 4 grams and the quarter 2 grams, so their gold value is simply the weight times the 21K price on the board. If you charge a making charge on coins, it is added on top, and the board says so.

Bars are priced differently from jewelry: the gold value at the 24K sell price, plus a fee per gram that falls as bars get heavier, plus VAT of 14% on that fee only. The sheet uses the usual fees published on 3 November 2026 and shows an indicative price for the common weights from 1 g to 100 g.

Finally, date and time every board and update it when the market moves; prices change during the day. A QR code on the printed board lets a customer check the live price on Qintar, which tells them your board is up to date.

More on this topic

Questions people ask

What is the difference between "we buy" and "we sell"?

"We sell" is the price per gram at which the customer buys from you; "we buy" is the price per gram at which you buy gold back. The buy price is lower.

How is the gold pound priced on the board?

At its gold value: 8 grams times the 21K price on the board for a full pound, 4 grams for a half and 2 grams for a quarter. Any making charge is added on top.

Are the bar fees on the board fixed?

No. They are the usual figures published on 3 November 2026, for guidance. Every shop sets its own fees, and the current usual figures are in Qintar's calculators.

Related calculators and guides

Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling. Check tax matters with your accountant.

Live prices are in the app. The Qintar app shows gold and silver buy and sell prices in Egypt, your holdings at today's price and a zakat calculator. It is free, with no ads.

More free sheets

All free gold sheets