A gold purchase tracker records each purchase exactly as the bill shows it: date, shop, item, weight in grams, rate per gram, making charges, GST printed on the bill and the total, with a link to a photo of the bill. A second tab keeps monthly instalments for any jeweller savings scheme. The aim is a clear record, not a valuation, so the sheet never assumes today's rate.
Which columns should the main sheet have?
- A Date, B Shop, C Item, D Weight in grams (as on the bill)
- E Rate per gram on the bill, F Gold value =D2*E2
- G Making charges, H GST on the bill, I Bill total
- J Check =I2-(F2+G2+H2), which should be 0
- K Payment mode (UPI, card, cheque, cash), L Bill photo link, M Notes (purity as printed, hallmark details, exchange of old gold)
Copy values from the bill as printed. If the bill lists gross weight and net weight, add both columns and use the weight the rate was applied to in column D. Never retype purity or hallmark details from memory; copy what the bill says.
What does a filled row look like?
Say a bill shows 10 grams at ₹7,000 a gram, making charges of ₹5,600 and GST of ₹2,300. These are made-up numbers.
| Column | Entry |
|---|---|
| Weight | 10 g |
| Rate per gram on the bill | ₹7,000 |
| Gold value | 10 x 7,000 = ₹70,000 |
| Making charges | ₹5,600 |
| GST on the bill | ₹2,300 |
| Bill total | ₹77,900 |
| Check | 77,900 - (70,000 + 5,600 + 2,300) = 0 |
The check column catches typing errors and also any line you missed, such as a hallmarking fee or a discount. If it shows a non-zero number, look at the bill again.
How do I total grams across purchases?
Under the table, write =SUM(D2:D200) for total grams and =SUM(I2:I200) for total spent. To split by shop, list shop names in a summary and use =SUMIFS($D$2:$D$200,$B$2:$B$200,"Shop name"). For average amount paid per gram including everything on the bill, divide total spent by total grams: =SUM(I2:I200)/SUM(D2:D200). On the example row, that is 77,900 / 10 = ₹7,790 a gram, which is more than the bill rate because making charges and GST are inside it.
If you exchanged old gold, record it in Notes and show the credit on its own line, so the total still matches the bill.
How do I track a jeweller's saving scheme?
Add a tab called Scheme. At the top, type the terms in words exactly as given to you: jeweller, scheme name, instalment amount, number of months, and what happens at the end. Do not assume a bonus or a value; write what the paper says, or leave the cell empty.
Below, list the instalments: A Month number, B Due date, C Amount paid, D Paid on, E Mode, F Running total. In F2 write =C2 and in F3 write =F2+C3, filled down. A cell for Months paid is =COUNT(D2:D13), and one for Months pending is =12-COUNT(D2:D13) if the scheme is twelve months. Make a missed payment visible with =IF(AND(B2<TODAY(),D2=""),"Missed","").
If you pay ₹5,000 a month for 11 months, the running total after the last payment is 5,000 x 11 = ₹55,000. What that earns you at the end is stated in the scheme terms, not in your sheet.
Where does the payment trail live?
Each instalment or purchase also appears on your bank or card statement. Importing statements into SpendixAI and filing jewellery under its own category gives you a second record of the amounts and dates, useful if a bill photo goes missing.
Checklist after each purchase
- Enter the row the same day, copying numbers from the bill.
- Confirm the Check column reads 0.
- Photograph the bill and add the link.
- Store the original bill safely with any warranty or purity card.
- If it was a scheme instalment, update the Scheme tab.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

