How to Track Your Portfolio Performance Without Stress (2026)

To track your portfolio performance well, record every holding and every dollar that moves in or out, calculate a return figure that ignores the distortion deposits create, then compare that result against a benchmark built from the same asset mix. A basic spreadsheet handles the whole job for most people, and it takes about an hour to set up.

That answer matters because the obvious method is wrong for most households. If you put 20000 into an account and it shows 30000 twelve months later, the account did not earn 50 percent. You added money, and the balance grew for reasons that have nothing to do with your decisions. This guide shows how to remove that noise, which numbers actually describe your results, and how to tell a good year from a lucky one.

I built my own tracker by hand after getting tired of brokerage reports that showed a gain figure with no explanation attached. The method below is the one I still use, and it is deliberately plain: no software required, no paid subscriptions, no account linking. Rules and reporting standards for investments vary by country and by institution, so treat everything here as a framework rather than a standard to sue anyone over.

What You Need

Six items. That is genuinely all it takes, and most of them already exist somewhere in your email.

• Holdings: every position, name or ticker, quantity, and which account it sits in.
• Transaction history: buys, sells, and dates. Your broker can export this as a CSV or PDF, and older history may be worth digging out.
• Cash flows: every deposit and withdrawal, dated. This is the column most people skip, and it is the one that matters most.
• Current values: the closing price and quantity for each holding on your chosen valuation date.
• Distribution records: dividends, interest, and any capital gain distributions, with the dates they landed in the account.
• One benchmark: an index or blend that matches your actual allocation, not whatever is most talked about.

A spreadsheet program you already have is enough. Sheets, Excel, or Numbers all work, and the only formulas required are division and multiplication.

Two additions make life easier. First, a broker export means you never hand-type positions, which removes most transcription errors. Second, if you hold metals or a commodity sleeve, add its own index to the benchmark list, because broad equity indices say nothing useful about that part of the book.

One warning before you start. Dedicated trackers and account aggregators are genuinely convenient, and many people run two or three at once, as threads on r/investing and r/Bogleheads describe. But every aggregator that shows your whole net worth wants read-only credentials to your brokerage and bank accounts. Decide deliberately whether you are comfortable handing that over, and hold the review below if you are not.

Step-by-Step: How to Track Your Portfolio Performance

Step 1: Define What You Are Measuring

Write down five things before you calculate anything: which accounts are in scope, the period you are measuring, the valuation date, the currency, and the benchmark. Ambiguity here is what makes two of your own numbers disagree next month, and it is the most common reason tracking fails before any math happens.

Decide too whether you are measuring investing results or total household wealth. A portfolio that funds a retirement has a finish line, and progress toward that number often tells you more than last quarter’s return. Schwab’s Goal Tracker takes this approach, framing a savings or income target and monitoring progress toward it, and it reframes a flat quarter as still on track.

A concrete definition looks like this: taxable brokerage account plus traditional and Roth retirement accounts, from 1 January through 31 December, valued at the final trading day, all in US dollars, measured against a blend of a broad US equity index and a broad investment-grade bond index in the same proportion as the holdings. Write it at the top of the sheet where you can see it.

Step 2: Build a Holdings and Cash-Flow Record

Give every position a row and give every cash flow its own row too. Keep them separate, because cash flows are not returns and mixing them destroys the math in the next step.

Columns for holdings: asset name or ticker, account, quantity, price paid, date acquired, closing price, market value, cost basis, and unrealized gain. If you deal in more than one currency, add the exchange rate used and convert to your reporting currency once, consistently.

Columns for cash flows: date, type (deposit, withdrawal, dividend, interest, fee), amount, and the account it hit. Deposits and withdrawals are external cash flows. Dividends and fees are investment-related flows, and they belong in your return calculation rather than being treated as contributions.

The habit worth building is a dated note beside every large transaction. A 15000 purchase made in the third week of a market climb is the difference between a healthy return and a disappointing one, and six months later you will not remember the timing without a note.

Step 3: Calculate Investment Returns

The basic formula is straightforward: ending value minus starting value, divided by starting value, multiplied by 100. The complication is that a deposit made halfway through the period inflates the ending value without earning anything.

Here is the problem in plain numbers. The account starts at 10000 and grows 10 percent, reaching 11000. You then add 9000, bringing the balance to 20000, and the portfolio grows another 10 percent to 22000. A naive reading says the account rose 120 percent in the year. Nothing like that happened.

Two legitimate figures come out of that same data set.

Measure	How it handles the deposit	Result	Question it answers
Simple balance change	Ignores it	+120%	None useful
Time-weighted return (TWR)	Splits the year at the deposit and removes its effect	21.0%	How well did the investments do?
Money-weighted return (MWR / IRR)	Weights the periods by how much money was invested	14.8%	How good were my own decisions and timing?

The time-weighted figure chains the sub-periods: 1.10 multiplied by 1.10, minus one, gives 21.0 percent. The money-weighted figure solves for the annual rate that turns 10000 into 22000 given the 9000 added at the start of the second period, which works out near 14.8 percent.

Read that 6-point gap carefully. It means the investments earned well, and the investor earned less because money arrived later in the period. Value investors point at exactly this divergence on r/ValueInvesting, where the money-weighted figure goes negative while the time-weighted figure stays strongly positive.

Neither number is wrong, and professional standards treat both as valid. The Global Investment Performance Standards require cash flows to be handled properly rather than ignored, which is the whole point of these two methods.

For periods without deposits or withdrawals, the simple formula is exact and there is no reason to complicate it. When you do have flows, a simplified method called the Modified Dietz method weights the flows by how much of the period they were present. It is less exact than TWR and easier to compute by hand, and most broker reports use some variation of it.

Step 4: Include Dividends, Fees, and Other Cash Flows

Price-only tracking quietly understates your results. A dividend-paying fund that rose 6 percent while paying 3 percent in distributions returned roughly 9 percent, and the gap compounds for years.

So add every distribution back into the return calculation. Dividends, interest, and capital gain distributions are income your holdings paid you, not new contributions, and leaving them out makes a steady income sleeve look like a disappointment.

Fees run the other way, and they deserve more attention than most trackers give them. Most reporting tools show an expense ratio as a percentage and never convert it to money, which is why the cost stays invisible. Put it in dollars on a 500000 balance at a 7 percent gross return: after a 0.6 percent annual fee the net rate is about 6.4 percent, and after 20 years the fee costs roughly 206000. After 10 years it is about 54000. Those are rough figures that ignore trading costs and taxes, but the direction is not in doubt.

Trading commissions, advisory fees, and bid-ask spread costs belong in the same place. For most long-term investors the fund expense ratio dwarfs commission costs, so check that first.

Step 5: Compare the Portfolio With a Benchmark

A benchmark exists to answer one question: could you have earned this with less thought? Comparing a portfolio holding half bonds to a single equity index produces a permanent, meaningless gap that feels like failure.

Map each sleeve to an index instead.

What you hold	Benchmark to compare against
US large-company equities	S&P 500
US small-company equities	Russell 2000
Developed markets outside the US	MSCI EAFE
US investment-grade bonds	Bloomberg U.S. Aggregate Bond Index
Broad commodity basket	S&P GSCI
Precious metals sleeve	Bloomberg Commodity Index
A 60/40 stock and bond mix	A static 60/40 blend of the equity and aggregate bond indices

Then calculate the difference and read it carefully. Outperformance or underperformance describes what happened, not what will happen, and a single quarter of it carries almost no information. Longer periods matter, and results over a full market cycle mean more than results over three months.

One honest complication: a static 60/40 blend assumes you never rebalanced. If you did rebalance, your real comparison is with a rebalanced index series, which few free tools produce. Understanding why that gap appears prevents a lot of unnecessary second-guessing.

Step 6: Review and Record Your Results on a Fixed Schedule

Pick a cadence and stick to it. A monthly glance takes ten minutes and keeps emotions out of it. A semi-annual deep review covers allocation, fees, and the benchmark comparison. An annual review is where you document decisions and reset the target allocation.

Every review needs a date stamp and a valuation date. If two of your numbers ever disagree, the dates are the first thing to check.

Then add the rebalancing trigger. A widely used rule is to act when any asset class drifts more than 5 percentage points from its target weight, either into or out of that band, which keeps costs low while preventing a portfolio from quietly becoming something you did not intend to own.

Log what you changed and why. Six months later that log is the only record of whether the decision helped, and it is the difference between learning from a mistake and repeating it. Then put the tracker down until the next date. Experienced trackers warn that judging results daily or weekly leads to noise-chasing, and the pull to check after a bad afternoon is exactly the habit to break.

Common Mistakes

Ignoring deposits and withdrawals. This is the big one, and it is the entire reason the time-weighted method exists. Fix: split every period at each cash flow before chaining returns.

Comparing everything to the S&P 500. A portfolio with bonds, cash, or metals will trail an equity index in some years and lead in others, and neither result means anything. Fix: build a blended benchmark from your actual weights.

Forgetting dividends and reinvested income. Price-only tracking understates a long-run return by a wide margin. Fix: add every distribution back in.

Mixing currencies without a fixed method. Converting each holding at a different day’s rate produces numbers that shift without any trade happening. Fix: pick one exchange rate source and use it for every valuation.

Double-counting overlapping funds. Holding two S&P 500 index funds in different accounts and adding them together twice quietly inflates every position count. Fix: consolidate by underlying holding before analysing allocation.

Overlooking fees because they are shown as a percentage. Fix: convert the expense ratio to dollars over your actual horizon, as shown in Step 4.

Checking too often. Daily reviews produce decisions, and most decisions made on a bad afternoon are bad. Fix: schedule reviews and ignore everything between them.

Relying on an incomplete account set. A return computed on one account while the rest sits untracked is not your portfolio return. Fix: verify the account list against every statement you hold before calculating.

Treating any of this as individual financial advice. Nothing here is a recommendation to buy or sell anything. Fix: use the framework to understand your own numbers, and take specific decisions to a qualified, licensed professional. Past performance never guarantees future results.

Tracking tips that make the habit stick

• Show your work. A sheet where you can see the formula behind every number is more trustworthy than a dashboard you cannot inspect.
• Keep one benchmark tab. A broad equity index is the common choice among spreadsheet builders, and pairing it with a bond index covers the rest of a typical allocation.
• Write the cash-flow date beside every deposit on the day you make it, not later.
• Reconcile against your broker once a quarter. If the broker’s number differs, the gap is almost always dividends, a fee, a currency rate, or a different calculation method. Knowing that in advance saves a lot of wasted searching.
• Do not link accounts you have not decided to link. Manual entry is tedious but private, and open-source desktop tools that store files locally are a middle option for people who want the math without handing over credentials.

Frequently Asked Questions

Conclusion

Start with one valuation date. Export every account you hold, enter each position and every deposit, withdrawal, dividend, and fee, then calculate the total return for the period with deposits stripped out. Compare it against a benchmark built from your actual allocation, write down what you find, and repeat on the same schedule next month.

None of this requires software, and none of it is a recommendation to buy or sell anything. It is a way to find out what your investments actually did.

Source: https://www.pgm-blog.com/how-to-track-your-portfolio-performance/