Log the loan, not the EMI
On the liability side, record outstanding principal from the lender statement. EMI is a cash-flow event; principal remaining is the debt. Use the loan EMI calculator to estimate EMI from amount, rate, and tenure.
Update after each month’s payment or whenever the statement shows a new outstanding. Prepayments should drop this number immediately.
Log the property as an asset
Use a conservative market estimate, not the purchase price forever, and not an optimistic broker quote. Review yearly unless you have a better local index.
Net worth then includes home equity automatically: property value minus outstanding loan, plus everything else you own.
Do not forget the rest of the balance sheet
A home loan sitting alone looks alarming. Next to EPF, mutual funds, and gold it is usually one line in a larger story. That is why an asset–liability tracker belongs with a loan register.
CapitalMap keeps assets, loans, and net worth in one dashboard and writes them back to tabs in your Google Sheet.