Portfolio tracking
The Angel Investment Tracking Spreadsheet (Free Template)
Most angels start tracking their investments in their head. It works for the first three or four deals. Then you wake up one day with eleven positions, you can't remember the cap on the SAFE you signed eighteen months ago, and you definitely can't remember why you said yes to two of them.
Your portfolio outgrew your memory. That's not a discipline problem. It's a tooling problem, and a spreadsheet fixes most of it.
Here's the template we'd use, free, plus the one column almost everyone leaves out and regrets later.
Your positions, your reasons, and the documents, in one place you can actually search.
Free, no signup required.
Optional. We'll send the template plus the companion set, and the occasional note on how small investor groups operate. No spam, unsubscribe anytime.
What to track
For every position, you want the basics and the memory.
The basics: company, the entity you hold it under, date, instrument, amount, round, lead, the cap or post-money, status, and your current estimate of value. The template calculates MOIC for you so you can see at a glance what's working.
The memory is one column, and it's the one that matters most in five years: why you invested. One line, written the day you wired the money. Future you, trying to decide whether to follow on or write the thing off, will be grateful you spent the ten seconds.
How to use it
Add a row per deal. Keep the status current as things move from active to exited to written off. Update your value estimates when you get real marks from a new round or a secondary.
The summary tab gives you the numbers you'll actually want when someone asks how the angel portfolio is doing: total deployed, how many are still alive, your overall multiple, and the split across your entities.
Don't overthink the value column. A rough, honest estimate beats a precise number you never update.
Where the spreadsheet breaks
A tracker like this is genuinely useful. We're telling you to use it. We're also telling you where it stops, because that's the honest part.
Your obligations live somewhere else.
The capital calls and K-1s tied to these positions end up in your inbox and your accountant's folder, disconnected from the row that tracks the investment.
Aleva
Capital calls and K-1s attach to the position they belong to.
Sharing it with a partner is a mess.
The moment you invest with someone, you're emailing copies, and within a month nobody knows which version is the real one.
Aleva
Give a partner access instead of emailing a copy that goes stale by Friday.
The "why" disappears anyway.
Even with the column, a spreadsheet buries your reasoning in a cell. It was never built to hold the story of a decision, so the story fades.
Aleva
The reason you invested becomes a permanent, searchable record.
What the free version does instead
Aleva keeps the same portfolio, with the parts a spreadsheet can't hold. The reason you invested becomes a permanent, searchable record instead of a cell you'll never reread. Capital calls and K-1s attach to the position they belong to. And when you want a partner to see a deal, you give them access instead of emailing a copy that's out of date by Friday.
Free, single player, ready in a minute. Start with one position and see how it feels.
Create your free Aleva workspace and give your portfolio a home that remembers more than a spreadsheet can.
Use it free in AlevaFAQ
What should I track for my angel investments?
At minimum: company, amount, instrument, date, the cap or valuation, ownership, status, and your current value estimate. The one most people skip and later wish they hadn't is a single line on why you invested, captured at the time.
Is a spreadsheet good enough, or do I need a tool?
A spreadsheet is plenty for a handful of positions you manage alone. You outgrow it when capital calls and K-1s pile up, when you invest with partners, or when you want the reasoning behind each deal to survive longer than your memory does.
How do I track SAFEs versus priced equity?
Use the instrument column to mark each one, and record the cap for SAFEs and the post-money for priced rounds. The number you compare across them is the value estimate and the resulting multiple, which the template calculates for you.
How do I calculate MOIC?
MOIC is your current estimated value divided by the amount you invested. A 2.0x means the position is worth twice what you put in. The template does this automatically as you update your value estimates.
Related: the Capital Call Tracker for the obligations these deals create, and the Multi-Entity Tracker if you hold investments across several LLCs.