- Qintar
- Sheets
Free gold sheets for individuals and gold shops
Spreadsheets for the sums people do with gold in Egypt, for a household or for a shop: what a piece should cost, what your gold is worth, your zakat, a savings plan, and the daily books of a goldsmith. Every sheet works in Egyptian pounds and grams, and you type today's prices in yourself.
Sheets for individuals
Fair Price Sheet for Any Gold Piece
Free Excel and PDF sheet that works out a fair price for any gold bar, coin or jewelry piece in Egypt: gold value, usual making charge and 14% VAT.
Gold Holdings Log
Free Excel and PDF log for every gold piece you own: weight, karat and price paid, value at today's buy price, profit or loss, and your break-even price.
Gold and Silver Zakat Sheet
Free Excel and PDF zakat sheet for gold and silver: turns any karat into pure gold, checks the 85 g nisab, works out 2.5% zakat and tracks your lunar year.
Gold Quick Reference: Karats, Units, Making Charges
Free one-page gold reference for Egypt, in Excel and PDF: karat purity, troy ounce, tola and gold pound, usual making charges, VAT and a unit converter.
Before You Buy or Sell Gold: Checklist and 3-Shop Comparison
Free checklist in Excel and PDF for buying or selling gold in Egypt: what to check and ask, staying safe with private buyers, and a 3-shop comparison table.
Sheets for goldsmiths and shop owners
Pricing a Piece in Your Gold Shop
Free Excel and PDF pricing sheet for gold shops: gold cost, wastage, making charge, 14% VAT on making only and your margin, rounded, with a price tag.
Gold Shop Daily Ledger: Sales, Purchases, Gold Flow
Free daily ledger for gold shops, in Excel and PDF: every sale, purchase and exchange by karat and weight, with the day's pure-gold change and net cash.
Old-for-New Gold Exchange Quote for Customers
Free Excel and PDF quote for gold shops trading a customer's old gold for a new piece: old value, new gold, making charge, VAT and the difference, itemized.
Gold Stock Count and Manufacturing Loss
Free Excel and PDF sheet for gold shops: monthly stock count by karat and category against the book, plus workshop manufacturing loss with alert limits.
Daily Gold Price Board for Your Shop
Free daily gold price board for shops, in Excel and PDF: buy and sell per gram for 24K, 21K and 18K, the gold pound and its parts, and bar prices with VAT.
More sheets for individuals and savers
Monthly gold savings plan
Free Excel and PDF sheet for a monthly gold savings plan: amount, price and fee each month, grams built up, average cost and today's value.
Shabka budget: what can the budget buy?
Free Excel and PDF shabka budget sheet: price each piece from weight, karat, selling price, making charge and VAT, then compare the total with your budget.
Gold savings goal: how much to put aside each month
Free Excel and PDF sheet for a gold savings goal: the monthly amount to reach a number of grams in a set time, at a price you type, with fee and VAT.
Family gold register: every piece and who owns it
Free Excel and PDF register of a family's gold: each piece, its owner, karat, weight and invoice, the pure gold, today's value and each person's total.
Inherited gold: split the value by the shares you type
Free Excel and PDF calculator that splits the estimated value of inherited gold by shares you type from the official document. Not a fatwa or legal advice.
Gold trading and investing
Entry cost compared: bar, gold pound or jewelry
Free Excel and PDF sheet comparing the cost of buying gold as a bar, a gold pound or jewelry, and the price rise needed for each to break even.
Gold trade journal: gain or loss?
Free Excel and PDF gold trade journal: cost with the fee and VAT, realized gain or loss on closed trades, and open trades at today's buying price.
Local and world gold price: how big is the gap?
Free Excel and PDF sheet comparing the Egyptian gold price with the world price: 24K per gram in EGP from the ounce and dollar, the gap and implied dollar.
Comparing gold bar prices between sellers
Free Excel and PDF sheet to compare gold bar offers: price per gram, the premium over today's 24K price, and the buy-back gap where it is published.
What if it had been gold? Comparing in figures
Free Excel and PDF sheet comparing cash savings with buying gold at the time: grams at each day's price with fee and VAT, and their value today.
Buying gold at several price levels
Free Excel and PDF sheet for buying gold at several price levels: grams and cost with the fee and VAT at each level, running totals and average cost.
Running a gold shop
End-of-day cash close for a gold shop
Free Excel and PDF sheet to close a gold shop's cash drawer each day: count note by note, compare with the expected cash and see if it is over or short.
Credit sales book: what each customer owes
Free Excel and PDF credit book for a gold shop: credit sales and payments per customer, the balance after each entry, and the total owed to you.
Scrap gold and refining: from scrap to pure gold
Free Excel and PDF sheet for scrap gold: turn 21K and 18K scrap into pure gold, then see what returns after refining loss and fees, at today's price.
Wholesaler account: weight, making charge and payments
Free Excel and PDF sheet for a gold shop's wholesaler account: goods in, making charge, payments in gold or cash, and the balance in pure gold and EGP.
Gold shop monthly profit: income and expenses
Free Excel and PDF sheet for a gold shop's monthly profit: making charge income, gold margin, expenses line by line, net profit and cost per day.
Customer orders and deposits
Free Excel and PDF book for custom orders in a gold shop: piece, karat, weight, agreed price, deposit, payments and the amount due on collection.
Customer repairs: weight in and weight out
Free Excel and PDF repairs book for a gold shop: weight when received and returned, gold added, the repair fee, and a check that the weight adds up.
Display stock: pieces and weight by category
Free Excel and PDF sheet for a gold shop's display stock: pieces and weight per category and karat, pure gold, average weight and value at today's price.
Staff sales and commission
Free Excel and PDF sheet for a gold shop's staff sales: grams sold, making charge income, commission per gram or as a percentage, and each person's total.
The price moved: how much did my stock gain or lose?
Free Excel and PDF sheet showing how a gold price move changes a shop's stock value: pure gold per karat, value before and after, and the difference.
Gold position: is the shop long in gold or in cash?
Free Excel and PDF sheet for a gold shop's position: pure gold and cash held, owed to you and owed by you, the net of each, and the total at today's price.
Cash for the days ahead: will it be enough?
Free Excel and PDF sheet for a gold shop's cash in the coming days: the balance day by day from expected cash in and out, with a warning below your minimum.
Comparing suppliers: which making charge is cheaper?
Free Excel and PDF sheet to compare gold suppliers: making charge per gram, discount and payment terms, the effective rate and the total for the same order.
Buying used gold from customers: a daily log
Free Excel and PDF daily log for a gold shop buying used gold: pure gold in each piece, the price paid per pure gram, and the gap to today's price.
Selling on installments: payment, mark-up and balance
Free Excel and PDF sheet for a gold shop selling on installments: the monthly payment from the price, down payment, months and mark-up, and what is left.
Zakat for a gold shop: the base and the nisab
Free Excel and PDF zakat sheet for a gold shop: assets and debts on the zakat day, the base, the nisab of 85 g of 24K and 2.5% zakat. A calculator, not a fatwa.
Break-even: how many grams to sell each month?
Free Excel and PDF break-even sheet for a gold shop: how many grams to sell each month and day to cover rent, salaries and costs, and to reach a target.
Card, InstaPay and wallet reconciliation
Free Excel and PDF sheet for a gold shop to reconcile card, InstaPay and wallet payments with the bank: the fee, what should arrive, and any shortfall.
Gold sale invoice: gold, making charge and VAT
Free Excel and PDF gold sale invoice for several pieces: the gold at the price for its karat, the making charge, 14% VAT on it, and the total due.
Workshop and manufacturing
Alloying gold: turning gold into 21K or 18K
Free Excel and PDF sheet for alloying gold: pure gold and final weight at 21K or 18K, the alloy to add, or the 24K needed to raise the karat.
Craftsman account: gold out, work in and wages
Free Excel and PDF sheet for a gold workshop's craftsman account: gold out, work in, scrap returned, loss against the agreed allowance, and wages.
Casting batch: gold in, gold out and the loss
Free Excel and PDF sheet for casting batches in a gold workshop: gold in, pieces out, sprues returned, the loss against your allowance, and the average.
What a piece costs the workshop
Free Excel and PDF sheet for the cost of a piece in a gold workshop: gold, loss, hours of work and stones, total cost per gram and work cost per gram.
Gold loss at each stage of manufacturing
Free Excel and PDF sheet for gold loss at each stage of manufacturing: weight before and after each stage, the loss and its %, against your allowance.
Filings and sweepings: how much gold came back?
Free Excel and PDF sheet for a gold workshop's filings and sweepings: weight sent, lab purity, expected vs returned pure gold, the fee and the net value.
Order production tracker: which stage ran late?
Free Excel and PDF sheet to track orders in a gold workshop: days in casting, finishing, stone setting and polishing, total, delay and the longest stage.
Silver
Silver: pricing pieces and tracking your holdings
Free Excel and PDF silver sheet: price 999 and 925 silver pieces with their making charge, track your pure silver at today's price, and the nisab.
Pricing silver pieces in the shop
Free Excel and PDF sheet for pricing silver pieces in a shop: silver value by fineness (925 or 999) and weight, loss, making charge, VAT, margin, rounding.
Silver stock count for a shop
Free Excel and PDF silver stock count for a shop: category, fineness, pieces and weight, the pure silver, and the estimated value at today's 999 price.
Gold to silver ratio: a daily log
Free Excel and PDF gold to silver ratio log: the daily local price of 1 g of 24K gold and 1 g of 999 silver, the local ratio and the world ratio.
Monthly silver savings plan
Free Excel and PDF monthly silver savings sheet: amount, 999 price, fineness and making charge each month, grams, pure silver, average cost and value.
How to use them
- Download the file: Pick a sheet below and download the Excel file if you want the calculations done for you, or the PDF if you want a page to print.
- Open it in Excel or Google Sheets: In Excel, open it directly. For Google Sheets, upload the file to Google Drive, click it and choose "Open with Google Sheets".
- Type in the yellow cells: The yellow cells are the ones you fill in: prices, weights and amounts. The rest are formulas; do not type in them.
- Clear the example and enter your numbers: Every sheet has an example marked "Example". Clear it and enter your own data.
Calculations are for information only, and you type the prices in yourself from the gold price today page.
Common questions
Are the sheets really free?
Yes. Every sheet is free to download as PDF and Excel, with no sign-up and no ads.
Are the prices inside the sheets live?
No. You type the prices into the yellow cells from Qintar's gold price today page, and the file has no live data so it works offline. The figures in the examples are dated November 3, 2026.
Can I open the sheets in Google Sheets?
Yes. Upload the Excel file to Google Drive and open it with Google Sheets; the formulas used work in both programs.
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, your holdings at today's price, and the zakat calculator. Free and with no ads.
More from Qintar
- Gold calculatorsFree calculators at today's prices.
- Qintar guidesThe making charge, zakat, karats and selling gold.
- Gold price today24K, 21K, 18K and silver, buy and sell.