← All articles

portfolio records / choosing a tracker

Portfolio tracker or spreadsheet: what needs to stay reproducible?

The hard part is maintaining a trustworthy history, not drawing the chart.

A spreadsheet can be an excellent way to inspect a small set of investment records. A portfolio application becomes useful when maintaining the history takes more work than reviewing it.

Keep the input separate from the answer

Original trades should remain traceable to their broker records. Holdings, cost and returns are calculations over that history. Editing a final holding quantity until it matches a statement can conceal the missing purchase or corporate action that caused the difference.

Trackr+ keeps a transaction ledger and derives the portfolio from it. Corrections and verified reference events should retain their evidence rather than erase the original record.

Test repeatability

Import the same supported file twice. The result should not contain the same trade twice. Then choose an earlier date and check that later transactions have not leaked into the answer.

A spreadsheet can enforce these rules too, but they need deliberate formulas, versioning and review.

Watch the shortcuts

A blank price is not zero. A company rename is not a new acquisition. A missing buy-and-sell pair may leave today's quantity unchanged while damaging historical returns.

Saved reconciliation reports can help explain what was checked and when, but they do not repair those gaps automatically or certify the complete history.

Keep spreadsheets where they help you inspect records. Use a tracker when its import, calculation and evidence workflow saves you effort you can verify. See how to choose a tracker.