Loans & debt

Loan and debt register for a household balance sheet

A debt tracker is not a shaming tool. It is the liability half of net worth. Log outstanding principal, keep EMIs in cash flow, and sit loans next to assets so progress is visible.

What belongs on a loan register

Home loan, vehicle loan, education loan, personal loan, gold loan, and any EMI-based consumer debt. Add credit-card revolving balances. Add money you have promised to repay relatives if it is real.

For each line, keep at least: name, type, outstanding principal, and optionally interest rate and a note for the lender. Sanctioned amount is history; outstanding is what net worth needs.

EMI vs principal

EMI is how cash leaves your account. Principal remaining is the liability. If you only track EMIs, prepayments and tenure changes never show up as wealth events.

Use the loan EMI calculator to estimate monthly EMI from loan amount, rate, and tenure. Put upcoming EMIs on an events calendar if you want dates. Put outstanding on the debt register. CapitalMap supports both: liabilities for balances, events for upcoming outflows.

Home loans need the matching asset

A home loan without the house is a horror story. A house without the loan is a fantasy. Log property on the asset side at a conservative value and the loan on the liability side. Equity is then implicit in net worth.

Do not reduce the asset by the loan inside one cell. Keep two rows so you can see each move — a prepayment versus a price estimate change.

Credit cards and “good” vs “bad” debt

Those labels are opinions. The register should be complete regardless. High-interest revolving credit is urgent because it compounds against you; still list the home loan even if the rate is lower.

When the card is paid in full, outstanding should be zero. Leaving a stale ₹80,000 on the tracker after you paid it will understate net worth for months.

Review with assets, not in isolation

Debt-only apps encourage fear. Asset-only apps encourage complacency. A loan and debt register is supporting documentation for net worth, not the whole product.

CapitalMap shows liabilities beside assets, writes both to your Google Sheet, and lets you snapshot the pair over time. That is the habit that matters: debt falling, assets rising, or an honest mix of both.

Frequently asked questions

How do I track loans and debt?
List each facility with outstanding principal. Update from statements after payments or disbursals. Sum them as total liabilities and subtract from assets for net worth.
Should a debt tracker include EMI dates?
Dates help cash-flow planning. They do not replace outstanding balances. Use a calendar for due dates and a register for principal.
Is CapitalMap a loan app?
No. It does not issue, refinance, or collect loans. It is a register and visualisation tool. Data sits in a Google Sheet you own.
How do I track a home loan with assets?
Add the property as an asset and the outstanding home loan as a liability. Net worth then reflects equity plus your other accounts.

Track this in CapitalMap

Create a Google Spreadsheet Vault, or start free in your browser — add assets and loans, and see net worth in a dashboard you control.

Get started free

Related guides