# Free gold sheets in Excel and PDF for Egypt

> Free gold sheets in Excel and PDF for Egypt: fair price, holdings, zakat, savings plans and gold shop books, each with a ready example. No sign-up.

Source: https://qintar.app/en/sheets/
Language: English
قنطار (Qintar)، qintar.app

---

# Free gold sheets for individuals and gold shops

52 free sheets · Excel and PDF · each with a ready example

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

- ![Preview of the sheet: Fair Price Sheet for Any Gold Piece](https://qintar.app/en/sheets/fair-price-sheet.png) [Fair Price Sheet for Any Gold Piece](https://qintar.app/en/sheets/fair-price-sheet.html) 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. [Download PDF169 KB](https://qintar.app/en/sheets/fair-price-sheet.pdf)[Download Excel64 KB](https://qintar.app/en/sheets/fair-price-sheet.xlsx)
- ![Preview of the sheet: Gold Holdings Log](https://qintar.app/en/sheets/gold-holdings-log.png) [Gold Holdings Log](https://qintar.app/en/sheets/gold-holdings-log.html) 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. [Download PDF158 KB](https://qintar.app/en/sheets/gold-holdings-log.pdf)[Download Excel66 KB](https://qintar.app/en/sheets/gold-holdings-log.xlsx)
- ![Preview of the sheet: Gold and Silver Zakat Sheet](https://qintar.app/en/sheets/gold-zakat-sheet.png) [Gold and Silver Zakat Sheet](https://qintar.app/en/sheets/gold-zakat-sheet.html) 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. [Download PDF155 KB](https://qintar.app/en/sheets/gold-zakat-sheet.pdf)[Download Excel63 KB](https://qintar.app/en/sheets/gold-zakat-sheet.xlsx)
- ![Preview of the sheet: Gold Quick Reference: Karats, Units, Making Charges](https://qintar.app/en/sheets/gold-quick-reference.png) [Gold Quick Reference: Karats, Units, Making Charges](https://qintar.app/en/sheets/gold-quick-reference.html) 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. [Download PDF156 KB](https://qintar.app/en/sheets/gold-quick-reference.pdf)[Download Excel64 KB](https://qintar.app/en/sheets/gold-quick-reference.xlsx)
- ![Preview of the sheet: Before You Buy or Sell Gold: Checklist and 3-Shop Comparison](https://qintar.app/en/sheets/buy-sell-checklist.png) [Before You Buy or Sell Gold: Checklist and 3-Shop Comparison](https://qintar.app/en/sheets/buy-sell-checklist.html) 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. [Download PDF143 KB](https://qintar.app/en/sheets/buy-sell-checklist.pdf)[Download Excel63 KB](https://qintar.app/en/sheets/buy-sell-checklist.xlsx)

## Sheets for goldsmiths and shop owners

- ![Preview of the sheet: Pricing a Piece in Your Gold Shop](https://qintar.app/en/sheets/shop-piece-pricing.png) [Pricing a Piece in Your Gold Shop](https://qintar.app/en/sheets/shop-piece-pricing.html) 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. [Download PDF145 KB](https://qintar.app/en/sheets/shop-piece-pricing.pdf)[Download Excel65 KB](https://qintar.app/en/sheets/shop-piece-pricing.xlsx)
- ![Preview of the sheet: Gold Shop Daily Ledger: Sales, Purchases, Gold Flow](https://qintar.app/en/sheets/shop-daily-ledger.png) [Gold Shop Daily Ledger: Sales, Purchases, Gold Flow](https://qintar.app/en/sheets/shop-daily-ledger.html) 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. [Download PDF158 KB](https://qintar.app/en/sheets/shop-daily-ledger.pdf)[Download Excel64 KB](https://qintar.app/en/sheets/shop-daily-ledger.xlsx)
- ![Preview of the sheet: Old-for-New Gold Exchange Quote for Customers](https://qintar.app/en/sheets/shop-exchange-quote.png) [Old-for-New Gold Exchange Quote for Customers](https://qintar.app/en/sheets/shop-exchange-quote.html) 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. [Download PDF131 KB](https://qintar.app/en/sheets/shop-exchange-quote.pdf)[Download Excel62 KB](https://qintar.app/en/sheets/shop-exchange-quote.xlsx)
- ![Preview of the sheet: Gold Stock Count and Manufacturing Loss](https://qintar.app/en/sheets/shop-stock-and-loss.png) [Gold Stock Count and Manufacturing Loss](https://qintar.app/en/sheets/shop-stock-and-loss.html) 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. [Download PDF165 KB](https://qintar.app/en/sheets/shop-stock-and-loss.pdf)[Download Excel68 KB](https://qintar.app/en/sheets/shop-stock-and-loss.xlsx)
- ![Preview of the sheet: Daily Gold Price Board for Your Shop](https://qintar.app/en/sheets/shop-price-board.png) [Daily Gold Price Board for Your Shop](https://qintar.app/en/sheets/shop-price-board.html) 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. [Download PDF174 KB](https://qintar.app/en/sheets/shop-price-board.pdf)[Download Excel63 KB](https://qintar.app/en/sheets/shop-price-board.xlsx)

## More sheets for individuals and savers

- ![Preview of the sheet: Monthly gold savings plan](https://qintar.app/en/sheets/gold-savings-plan.png) [Monthly gold savings plan](https://qintar.app/en/sheets/gold-savings-plan.html) 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. [Download PDF140 KB](https://qintar.app/en/sheets/gold-savings-plan.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/gold-savings-plan.xlsx)
- ![Preview of the sheet: Shabka budget: what can the budget buy?](https://qintar.app/en/sheets/bride-shabka-budget.png) [Shabka budget: what can the budget buy?](https://qintar.app/en/sheets/bride-shabka-budget.html) 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. [Download PDF137 KB](https://qintar.app/en/sheets/bride-shabka-budget.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/bride-shabka-budget.xlsx)
- ![Preview of the sheet: Gold savings goal: how much to put aside each month](https://qintar.app/en/sheets/gold-goal-planner.png) [Gold savings goal: how much to put aside each month](https://qintar.app/en/sheets/gold-goal-planner.html) 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. [Download PDF132 KB](https://qintar.app/en/sheets/gold-goal-planner.pdf)[Download Excel59 KB](https://qintar.app/en/sheets/gold-goal-planner.xlsx)
- ![Preview of the sheet: Family gold register: every piece and who owns it](https://qintar.app/en/sheets/family-gold-register.png) [Family gold register: every piece and who owns it](https://qintar.app/en/sheets/family-gold-register.html) 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. [Download PDF136 KB](https://qintar.app/en/sheets/family-gold-register.pdf)[Download Excel62 KB](https://qintar.app/en/sheets/family-gold-register.xlsx)
- ![Preview of the sheet: Inherited gold: split the value by the shares you type](https://qintar.app/en/sheets/inherited-gold-split.png) [Inherited gold: split the value by the shares you type](https://qintar.app/en/sheets/inherited-gold-split.html) 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. [Download PDF141 KB](https://qintar.app/en/sheets/inherited-gold-split.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/inherited-gold-split.xlsx)

## Gold trading and investing

- ![Preview of the sheet: Entry cost compared: bar, gold pound or jewelry](https://qintar.app/en/sheets/gold-entry-cost-compare.png) [Entry cost compared: bar, gold pound or jewelry](https://qintar.app/en/sheets/gold-entry-cost-compare.html) 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. [Download PDF138 KB](https://qintar.app/en/sheets/gold-entry-cost-compare.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/gold-entry-cost-compare.xlsx)
- ![Preview of the sheet: Gold trade journal: gain or loss?](https://qintar.app/en/sheets/gold-trade-journal.png) [Gold trade journal: gain or loss?](https://qintar.app/en/sheets/gold-trade-journal.html) 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. [Download PDF137 KB](https://qintar.app/en/sheets/gold-trade-journal.pdf)[Download Excel62 KB](https://qintar.app/en/sheets/gold-trade-journal.xlsx)
- ![Preview of the sheet: Local and world gold price: how big is the gap?](https://qintar.app/en/sheets/local-premium-tracker.png) [Local and world gold price: how big is the gap?](https://qintar.app/en/sheets/local-premium-tracker.html) 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. [Download PDF133 KB](https://qintar.app/en/sheets/local-premium-tracker.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/local-premium-tracker.xlsx)
- ![Preview of the sheet: Comparing gold bar prices between sellers](https://qintar.app/en/sheets/bar-prices-compare.png) [Comparing gold bar prices between sellers](https://qintar.app/en/sheets/bar-prices-compare.html) 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. [Download PDF131 KB](https://qintar.app/en/sheets/bar-prices-compare.pdf)[Download Excel59 KB](https://qintar.app/en/sheets/bar-prices-compare.xlsx)
- ![Preview of the sheet: What if it had been gold? Comparing in figures](https://qintar.app/en/sheets/gold-vs-cash-log.png) [What if it had been gold? Comparing in figures](https://qintar.app/en/sheets/gold-vs-cash-log.html) 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. [Download PDF133 KB](https://qintar.app/en/sheets/gold-vs-cash-log.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/gold-vs-cash-log.xlsx)
- ![Preview of the sheet: Buying gold at several price levels](https://qintar.app/en/sheets/buy-sell-levels-plan.png) [Buying gold at several price levels](https://qintar.app/en/sheets/buy-sell-levels-plan.html) 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. [Download PDF132 KB](https://qintar.app/en/sheets/buy-sell-levels-plan.pdf)[Download Excel59 KB](https://qintar.app/en/sheets/buy-sell-levels-plan.xlsx)

## Running a gold shop

- ![Preview of the sheet: End-of-day cash close for a gold shop](https://qintar.app/en/sheets/shop-cash-close.png) [End-of-day cash close for a gold shop](https://qintar.app/en/sheets/shop-cash-close.html) 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. [Download PDF130 KB](https://qintar.app/en/sheets/shop-cash-close.pdf)[Download Excel59 KB](https://qintar.app/en/sheets/shop-cash-close.xlsx)
- ![Preview of the sheet: Credit sales book: what each customer owes](https://qintar.app/en/sheets/shop-credit-book.png) [Credit sales book: what each customer owes](https://qintar.app/en/sheets/shop-credit-book.html) 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. [Download PDF138 KB](https://qintar.app/en/sheets/shop-credit-book.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-credit-book.xlsx)
- ![Preview of the sheet: Scrap gold and refining: from scrap to pure gold](https://qintar.app/en/sheets/shop-scrap-refining.png) [Scrap gold and refining: from scrap to pure gold](https://qintar.app/en/sheets/shop-scrap-refining.html) 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. [Download PDF135 KB](https://qintar.app/en/sheets/shop-scrap-refining.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-scrap-refining.xlsx)
- ![Preview of the sheet: Wholesaler account: weight, making charge and payments](https://qintar.app/en/sheets/shop-wholesaler-account.png) [Wholesaler account: weight, making charge and payments](https://qintar.app/en/sheets/shop-wholesaler-account.html) 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. [Download PDF142 KB](https://qintar.app/en/sheets/shop-wholesaler-account.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/shop-wholesaler-account.xlsx)
- ![Preview of the sheet: Gold shop monthly profit: income and expenses](https://qintar.app/en/sheets/shop-monthly-profit.png) [Gold shop monthly profit: income and expenses](https://qintar.app/en/sheets/shop-monthly-profit.html) 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. [Download PDF129 KB](https://qintar.app/en/sheets/shop-monthly-profit.pdf)[Download Excel59 KB](https://qintar.app/en/sheets/shop-monthly-profit.xlsx)
- ![Preview of the sheet: Customer orders and deposits](https://qintar.app/en/sheets/shop-orders-deposits.png) [Customer orders and deposits](https://qintar.app/en/sheets/shop-orders-deposits.html) 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. [Download PDF137 KB](https://qintar.app/en/sheets/shop-orders-deposits.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-orders-deposits.xlsx)
- ![Preview of the sheet: Customer repairs: weight in and weight out](https://qintar.app/en/sheets/shop-repairs-log.png) [Customer repairs: weight in and weight out](https://qintar.app/en/sheets/shop-repairs-log.html) 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. [Download PDF136 KB](https://qintar.app/en/sheets/shop-repairs-log.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/shop-repairs-log.xlsx)
- ![Preview of the sheet: Display stock: pieces and weight by category](https://qintar.app/en/sheets/shop-inventory-by-category.png) [Display stock: pieces and weight by category](https://qintar.app/en/sheets/shop-inventory-by-category.html) 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. [Download PDF144 KB](https://qintar.app/en/sheets/shop-inventory-by-category.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/shop-inventory-by-category.xlsx)
- ![Preview of the sheet: Staff sales and commission](https://qintar.app/en/sheets/shop-staff-sales.png) [Staff sales and commission](https://qintar.app/en/sheets/shop-staff-sales.html) 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. [Download PDF137 KB](https://qintar.app/en/sheets/shop-staff-sales.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/shop-staff-sales.xlsx)
- ![Preview of the sheet: The price moved: how much did my stock gain or lose?](https://qintar.app/en/sheets/shop-price-move-impact.png) [The price moved: how much did my stock gain or lose?](https://qintar.app/en/sheets/shop-price-move-impact.html) 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. [Download PDF137 KB](https://qintar.app/en/sheets/shop-price-move-impact.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-price-move-impact.xlsx)
- ![Preview of the sheet: Gold position: is the shop long in gold or in cash?](https://qintar.app/en/sheets/shop-gold-position.png) [Gold position: is the shop long in gold or in cash?](https://qintar.app/en/sheets/shop-gold-position.html) 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. [Download PDF141 KB](https://qintar.app/en/sheets/shop-gold-position.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-gold-position.xlsx)
- ![Preview of the sheet: Cash for the days ahead: will it be enough?](https://qintar.app/en/sheets/shop-cashflow-week.png) [Cash for the days ahead: will it be enough?](https://qintar.app/en/sheets/shop-cashflow-week.html) 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. [Download PDF136 KB](https://qintar.app/en/sheets/shop-cashflow-week.pdf)[Download Excel59 KB](https://qintar.app/en/sheets/shop-cashflow-week.xlsx)
- ![Preview of the sheet: Comparing suppliers: which making charge is cheaper?](https://qintar.app/en/sheets/shop-supplier-compare.png) [Comparing suppliers: which making charge is cheaper?](https://qintar.app/en/sheets/shop-supplier-compare.html) 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. [Download PDF129 KB](https://qintar.app/en/sheets/shop-supplier-compare.pdf)[Download Excel59 KB](https://qintar.app/en/sheets/shop-supplier-compare.xlsx)
- ![Preview of the sheet: Buying used gold from customers: a daily log](https://qintar.app/en/sheets/shop-used-gold-buying.png) [Buying used gold from customers: a daily log](https://qintar.app/en/sheets/shop-used-gold-buying.html) 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. [Download PDF142 KB](https://qintar.app/en/sheets/shop-used-gold-buying.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-used-gold-buying.xlsx)
- ![Preview of the sheet: Selling on installments: payment, mark-up and balance](https://qintar.app/en/sheets/shop-installment-sales.png) [Selling on installments: payment, mark-up and balance](https://qintar.app/en/sheets/shop-installment-sales.html) 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. [Download PDF136 KB](https://qintar.app/en/sheets/shop-installment-sales.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-installment-sales.xlsx)
- ![Preview of the sheet: Zakat for a gold shop: the base and the nisab](https://qintar.app/en/sheets/shop-zakat.png) [Zakat for a gold shop: the base and the nisab](https://qintar.app/en/sheets/shop-zakat.html) 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. [Download PDF132 KB](https://qintar.app/en/sheets/shop-zakat.pdf)[Download Excel59 KB](https://qintar.app/en/sheets/shop-zakat.xlsx)
- ![Preview of the sheet: Break-even: how many grams to sell each month?](https://qintar.app/en/sheets/shop-break-even.png) [Break-even: how many grams to sell each month?](https://qintar.app/en/sheets/shop-break-even.html) 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. [Download PDF132 KB](https://qintar.app/en/sheets/shop-break-even.pdf)[Download Excel59 KB](https://qintar.app/en/sheets/shop-break-even.xlsx)
- ![Preview of the sheet: Card, InstaPay and wallet reconciliation](https://qintar.app/en/sheets/shop-payments-reconcile.png) [Card, InstaPay and wallet reconciliation](https://qintar.app/en/sheets/shop-payments-reconcile.html) 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. [Download PDF142 KB](https://qintar.app/en/sheets/shop-payments-reconcile.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-payments-reconcile.xlsx)
- ![Preview of the sheet: Gold sale invoice: gold, making charge and VAT](https://qintar.app/en/sheets/shop-sale-invoice.png) [Gold sale invoice: gold, making charge and VAT](https://qintar.app/en/sheets/shop-sale-invoice.html) 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. [Download PDF142 KB](https://qintar.app/en/sheets/shop-sale-invoice.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-sale-invoice.xlsx)

## Workshop and manufacturing

- ![Preview of the sheet: Alloying gold: turning gold into 21K or 18K](https://qintar.app/en/sheets/workshop-alloying.png) [Alloying gold: turning gold into 21K or 18K](https://qintar.app/en/sheets/workshop-alloying.html) 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. [Download PDF137 KB](https://qintar.app/en/sheets/workshop-alloying.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/workshop-alloying.xlsx)
- ![Preview of the sheet: Craftsman account: gold out, work in and wages](https://qintar.app/en/sheets/workshop-job-orders.png) [Craftsman account: gold out, work in and wages](https://qintar.app/en/sheets/workshop-job-orders.html) 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. [Download PDF144 KB](https://qintar.app/en/sheets/workshop-job-orders.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/workshop-job-orders.xlsx)
- ![Preview of the sheet: Casting batch: gold in, gold out and the loss](https://qintar.app/en/sheets/workshop-casting-batch.png) [Casting batch: gold in, gold out and the loss](https://qintar.app/en/sheets/workshop-casting-batch.html) 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. [Download PDF136 KB](https://qintar.app/en/sheets/workshop-casting-batch.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/workshop-casting-batch.xlsx)
- ![Preview of the sheet: What a piece costs the workshop](https://qintar.app/en/sheets/workshop-piece-costing.png) [What a piece costs the workshop](https://qintar.app/en/sheets/workshop-piece-costing.html) 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. [Download PDF139 KB](https://qintar.app/en/sheets/workshop-piece-costing.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/workshop-piece-costing.xlsx)
- ![Preview of the sheet: Gold loss at each stage of manufacturing](https://qintar.app/en/sheets/workshop-process-wastage.png) [Gold loss at each stage of manufacturing](https://qintar.app/en/sheets/workshop-process-wastage.html) 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. [Download PDF133 KB](https://qintar.app/en/sheets/workshop-process-wastage.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/workshop-process-wastage.xlsx)
- ![Preview of the sheet: Filings and sweepings: how much gold came back?](https://qintar.app/en/sheets/workshop-dust-recovery.png) [Filings and sweepings: how much gold came back?](https://qintar.app/en/sheets/workshop-dust-recovery.html) 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. [Download PDF136 KB](https://qintar.app/en/sheets/workshop-dust-recovery.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/workshop-dust-recovery.xlsx)
- ![Preview of the sheet: Order production tracker: which stage ran late?](https://qintar.app/en/sheets/workshop-production-tracker.png) [Order production tracker: which stage ran late?](https://qintar.app/en/sheets/workshop-production-tracker.html) 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. [Download PDF133 KB](https://qintar.app/en/sheets/workshop-production-tracker.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/workshop-production-tracker.xlsx)

## Silver

- ![Preview of the sheet: Silver: pricing pieces and tracking your holdings](https://qintar.app/en/sheets/silver-holdings-pricing.png) [Silver: pricing pieces and tracking your holdings](https://qintar.app/en/sheets/silver-holdings-pricing.html) 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. [Download PDF137 KB](https://qintar.app/en/sheets/silver-holdings-pricing.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/silver-holdings-pricing.xlsx)
- ![Preview of the sheet: Pricing silver pieces in the shop](https://qintar.app/en/sheets/silver-shop-pricing.png) [Pricing silver pieces in the shop](https://qintar.app/en/sheets/silver-shop-pricing.html) 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. [Download PDF133 KB](https://qintar.app/en/sheets/silver-shop-pricing.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/silver-shop-pricing.xlsx)
- ![Preview of the sheet: Silver stock count for a shop](https://qintar.app/en/sheets/silver-stock-count.png) [Silver stock count for a shop](https://qintar.app/en/sheets/silver-stock-count.html) 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. [Download PDF133 KB](https://qintar.app/en/sheets/silver-stock-count.pdf)[Download Excel59 KB](https://qintar.app/en/sheets/silver-stock-count.xlsx)
- ![Preview of the sheet: Gold to silver ratio: a daily log](https://qintar.app/en/sheets/gold-silver-ratio-log.png) [Gold to silver ratio: a daily log](https://qintar.app/en/sheets/gold-silver-ratio-log.html) 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. [Download PDF126 KB](https://qintar.app/en/sheets/gold-silver-ratio-log.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/gold-silver-ratio-log.xlsx)
- ![Preview of the sheet: Monthly silver savings plan](https://qintar.app/en/sheets/silver-savings-plan.png) [Monthly silver savings plan](https://qintar.app/en/sheets/silver-savings-plan.html) Free Excel and PDF monthly silver savings sheet: amount, 999 price, fineness and making charge each month, grams, pure silver, average cost and value. [Download PDF136 KB](https://qintar.app/en/sheets/silver-savings-plan.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/silver-savings-plan.xlsx)

## How to use them

1. **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.
2. **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".
3. **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.
4. **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](https://qintar.app/en/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.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More from Qintar

- [Gold calculators](https://qintar.app/en/tools/)Free calculators at today's prices.
- [Qintar guides](https://qintar.app/en/articles/)The making charge, zakat, karats and selling gold.
- [Gold price today](https://qintar.app/en/gold-price-today/)24K, 21K, 18K and silver, buy and sell.
