Designing a portfolio tracker people can trust

The problem: scattered records and unexplained totals

Most households do not have one place where their investments live. There is a broker account, a couple of mutual funds bought through different platforms, a fixed deposit, perhaps some gold or a provident fund, and a spreadsheet that was accurate when it was last updated. Each source shows a different slice, and none of them explains how the slices fit together.

The usual result is uncertainty. People know roughly what they own but cannot easily answer basic questions: how much have I actually put in, how much of this month's change is new money versus market movement, and is this total even correct? Our Portfolio Management tool exists to make those questions quick to answer.

Transactions are the source of truth

The most important design decision is also the least visible: holdings and totals are calculated from individual transactions, rather than typed in as balances.

A balance entered by hand can drift from reality without anyone noticing. A list of buys, sells, dividends and other transactions can be checked against a statement, line by line. When holdings are derived from those records, any total can be explained, and a mistake can be found and corrected at its source rather than patched over in a summary.

Every summary should be traceable

A dashboard total that cannot be explained is worse than no total at all, because it invites either blind trust or complete distrust. We design views so that a user can move from a high-level figure down to the records that produced it.

In practice that means:

• Portfolio value breaks down into holdings, and each holding breaks down into its transactions.
• Allocation views show the underlying amounts, not only percentages.
• Figures are labelled with what they include, so that 'invested amount' and 'current value' are never confused.

Explaining change, not just showing it

The question people most often bring to a finance tool is simply 'what changed?' A portfolio can grow because the market rose, because the owner added money, or both. Treating these as one number makes a deposit look like investment performance and hides a market fall behind a large contribution.

Separating contributions from market movement, and showing allocation over time, lets someone understand their portfolio in a few minutes. It also makes a proper return calculation possible: when every cash flow has a date, time-weighted measures such as XIRR can be computed accurately. We explain those measures in our guide to calculating investment returns.

Handling the awkward cases honestly

Real portfolios contain events that simple trackers ignore: stock splits and bonus issues that change the number of units without changing value, partial sales that raise the question of which units were sold, and dividends that may be paid out or reinvested.

Different methods exist for some of these, and reasonable people choose different ones. What matters most is consistency and transparency: the tool should apply one clear rule and show its working, so the user is never left guessing why a number looks the way it does.

Who it is for

• Individuals organising investments held across multiple sources.
• Households replacing a collection of finance spreadsheets with one consistent record.
• Anyone who values summaries they can verify over dashboards they must take on trust.

Portfolio Management is a record-keeping and understanding tool. It does not give investment advice. You can try it at portfolio.jinhub.co.in, and we welcome feedback through the Contact page.