How to reconcile your portfolio against your statements

Here is a question almost nobody asks their portfolio tracker, and it is the only one that matters. Can you reconcile this thing against your statements? I don’t mean “does it look about right” or “is the green number bigger than last month”. I mean can you sit your tracker next to your real broker statement, run a finger down both columns, and prove that every share, every fill and every penny of cash agrees. If the answer is no, then what you have is not a portfolio. It is a vibe. So let me show you how to reconcile your portfolio against statements the boring way, which happens to be the only way that survives contact with reality.

What reconciliation actually means

Reconcile is an old, unglamorous accounting word, and it means exactly what it sounds like. You take two records that are meant to describe the same thing, your book and your broker’s statement, and you check them against each other line by line until they match or you work out why they don’t. That is the whole job. Not exciting, and not a feature anyone puts on a billboard. All it does is tell you whether a number can be trusted or has to be taken on hope.

Your broker’s statement is the source of truth for what happened in your account. Your book is your record of what you think happened. Reconciliation is the act of making those two agree, and chasing every gap until it has a name. A dividend you forgot to log. A fee you didn’t see. A fill that came in at a worse price than your order. A book you cannot reconcile is a book you cannot trust.

Why you cannot reconcile a scraped book

Here is where the convenient option quietly falls apart. If a credential-linking aggregator built your book by logging in as you and copying numbers out, then reconciliation is impossible by construction. Think about it. To reconcile, you compare two independent records and see if they agree. But the scraped book and the statement were never independent. One was copied straight out of the other by a robot you cannot see, running rules you did not write.

So when the two disagree, and they will, you are stuck. Did you fat-finger a trade, or did the scraper double a position when your broker tweaked a login page? Did the cash balance drift because you forgot a transfer, or because the pipeline silently broke three weeks ago and froze at a stale value? You cannot tell. The one record that could check the other is the very record that is wrong, and it never raises its hand to admit it. Reconciling a copy against its original and calling the job done isn’t reconciliation at all. It is a hall of mirrors.

I have written before about how these connections break silently and scramble your numbers, and why Strata is manual by design. Reconciliation is the sharp end of that argument. Type the book yourself and you can check it whenever you like. Let a stranger type it for you and all you can do is take it on faith.

How to reconcile against your statements, line by line

Right, the actual method. It is satisfyingly dull. Pull up your most recent statement from each account next to your book, and walk them in order.

Start with the holdings. For every position the statement lists, confirm your book shows the same share count. A mismatch here is usually a missing trade, a stock split you never recorded, or a dividend reinvestment that bought you a few extra shares while you weren’t looking. Then do the cash. Your book’s cash balance should match the statement’s to the penny, and when it doesn’t, the gap is the receipt for something you missed: a fee, an interest payment, a transfer between pots. Cash never lies, and it never rounds in your favour. Trust it.

Then reconcile the trades themselves. This is where typing the book pays off. Because you entered each buy and sell, you have your version of what happened, and the statement has the broker’s. Match them up. Check the price you got, the commission you paid, and the date it actually settled. This is also where tax lots stop being an abstraction. When your recorded lots line up with the statement, your cost basis is honest and your FIFO ordering is real, so your realised P&L becomes a fact you can defend rather than a guess your software made on your behalf. Do this for every account you hold, whatever the wrapper or wallet. If you keep money in several places, the reconcile-everything-in-one-book approach is what makes a single net-worth number mean anything.

When you find a mistake, void it, don’t erase it

You will find mistakes. Everybody does. The real question is what your tool does about them, and this is where most of them quietly let you down.

The lazy answer is to let you delete the wrong entry and retype it. Clean, tidy, and completely wrong. The moment you can silently edit history, your book stops being a record of what happened and becomes a record of whatever you most recently claimed. Next month, when a number looks off, you have no way to retrace how it got there. The evidence is gone. You erased it.

It is the same reason accountants don’t use erasers. A real ledger is immutable. When you make a mistake you don’t scrub it out. You post a correction, and both the error and the fix stay visible forever. Strata works this way too. The ledger is the source of truth, and your holdings and cash are derived by replaying it from the start. A mistake isn’t deleted, it’s voided: flagged, kept in plain sight, but excluded from the maths. Every entry is attributed and timestamped, so the audit log tells you who changed what and when. None of that is bureaucracy for its own sake. It is how a correction today stops quietly poisoning a number you’ll rely on next year.

The whole point is a book you can stand behind

Reconciliation sounds like a chore, and the first pass is. After that it is a few minutes whenever a statement lands, and it buys you something no scraped feed can. You know your numbers are right because you checked them, not because a dashboard told you so in a confident font.

When you reconcile your portfolio against statements on a book you typed, every figure has a provenance you can point to. The valuation comes from public market data on lots you entered yourself. The realised P&L comes from sells you logged against tax lots you can actually see. The cash agrees with the statement because you made it agree. None of it is inherited from a pipeline you cannot inspect. If you want help choosing a tool that lets you do any of this, the buyer’s guide walks through what to look for.

This is the standard your own money deserves: a book you can hold up against reality and watch it hold. If that sounds right, you can build your portfolio on a ledger you can actually reconcile.