Debt

How much gold loan interest have you paid in total? A simple tally

Add up the total gold loan interest you have paid across months and renewals from receipts or bank statements, with an invented 18-month example.

Editorial illustration for How much gold loan interest have you paid in total? A simple tally

Receipts are the best source for gold loan interest paid so far, and the bank statement fills the gaps. List every interest payment with its date, add them up, then add any charges separately. Divide the total by the number of months to see what the loan really costs you each month.

Where do the numbers come from?

  1. Receipts from the lender, which show interest and charges separately.
  2. Your bank or UPI statement, searched for the lender's name or the loan reference.
  3. Your own notes for any payment made in cash, ideally with a receipt.

If a receipt and a statement disagree, trust the receipt for what the payment was for and the statement for the date and amount that left your account. If a payment is missing from both, ask the lender for a statement of account for the loan.

An invented 18-month history

Say you took a gold loan in April 2025 and renewed it in October 2025 at a higher amount. You paid ₹1,200 a month for the first six months, ₹1,500 a month for the next six, and then ₹1,500 for five of the last six months. In the month you were late, you paid ₹1,650 because of a late fee included in that payment.

PeriodMonthsInterest each monthSubtotal
April to September 20256₹1,200₹7,200
October 2025 to March 20266₹1,500₹9,000
April to August 2026 (five on time)5₹1,500₹7,500
September 2026 (late)1₹1,650₹1,650

The total is ₹7,200 plus ₹9,000 plus ₹7,500 plus ₹1,650, which is ₹25,350. If you also paid a one-time renewal charge of ₹500, the total cost of the 18 months is ₹25,850. The late amount contains ₹150 extra, so you may wish to track it as a charge rather than interest, which would put interest at ₹25,200 and charges at ₹650.

What is the effective monthly cost?

Divide the total interest by the months: ₹25,350 divided by 18 is about ₹1,408 a month. That is a plain average of what left your pocket. To compare with another loan, you would also need the amounts borrowed, which changed here, so this figure is a cost to you and not a lender's rate.

How do you add it up in a sheet?

Keep a list with the date in column A, the type in column B (Interest or Charge) and the amount in column C, for rows 2 to 100. Then:

  • Total of everything: =SUM($C$2:$C$100)
  • Interest only: =SUMIFS($C$2:$C$100,$B$2:$B$100,"Interest")
  • Charges only: =SUMIFS($C$2:$C$100,$B$2:$B$100,"Charge")
  • Average per month over 18 months: =SUM($C$2:$C$100)/18

These work the same in Excel and Google Sheets. When a sheet stops being enough, SpendixAI can take statement uploads and let you filter and group by merchant in its Report builder, which helps if you have several loans and many months.

What if some months are missing?

Do not guess. Mark the month as unverified in your list and look for the payment in three places: the lender's receipt book, your bank or UPI history and the lender's statement of account. If you find nothing, add a line with an estimate in brackets so you remember it is an estimate, and ask the lender for the month's receipt. A total with a few honest question marks is more useful than a tidy one that may be wrong.

If the loan was renewed, add the interest from each loan in the chain to the same list, but keep a column for the loan label so you can also see the interest for each one on its own.

What should you do with the number?

  • Compare it with what you borrowed to see whether the loan is still worth carrying
  • Check whether you could repay part from savings
  • Keep the total for the day of closure, when you compare it with the lender's figures
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports