Free template
Investor Pipeline Tracker
A raise isn't one pitch — it's fifty parallel conversations in different stages, and by week two nobody remembers from memory which partner already has the deck, who promised an intro, and which fund passed for which reason. That is what this template is built for. It tracks partners rather than funds (a fund doesn't invest, a person does), the intro path to each one, and — the underrated part — every pass with a reason and a revisit date. Most checks get written on the second or third contact, not the first. Import the CSV straight into Endearist if you want it next to your contacts; it works just as well as a plain sheet beside your data room.
Opens in Excel, Google Sheets, Numbers — or imports straight into Endearist.
What each column means
| Column | How to use it | Example |
|---|---|---|
| Firm | The fund or family office. Multiple partners at one fund? Multiple rows. | Bluegate Ventures |
| Partner | The specific person who would have to champion your deal — never track just the fund name. | Marcus Okafor |
| Stage focus | Pre-seed, seed, Series A… A fund outside your stage costs you time, not opportunity. | Pre-seed and seed |
| Check size | Typical check per their site or recent deals — decides whether lead or follow is realistic. | $500k–$2M |
| Intro path | Who can credibly introduce you: a portfolio founder, an angel, a mutual contact. Blank = homework remains. | Via Jenna Liu (portfolio founder) |
| Status | Researching → intro requested → intro'd → met → pass / invest. One stage per update — no skipping. | Met 2026-06-04 — awaiting partner meeting |
| Pass reason | The real reason for the no, in their words. "Too early" is an invitation, not an endpoint. | Too early — want to see $50k MRR |
| Revisit date | When you come back with a traction update. Every soft pass gets one. | 2026-10-01 |
| Notes | Theses, portfolio conflicts, personal details from calls — anything that sharpens the next update. | Writes about vertical SaaS — read her blog before the call |
How to use this template
- Build the list before the raise, not during it
Research 40 to 60 fitting partners before the first deck goes out: stage, check size, portfolio adjacency, intro path. Once the raise is live you won't have time — you'll be chasing calls instead. A pre-built pipeline lets you launch conversations in parallel batches, which builds momentum, and momentum is what improves terms.
- Fill the intro path column before you knock
Sort the sheet by intro_path and work the rows with a name in them first. For the blank rows, do the research: which portfolio founders do you know? Who among your angels knows the fund? A warm intro multiplies your response rate — and for many investors, your ability to find one is itself the first screen.
- Weekly pipeline review, sorted by status
Once a week, sort by status and ask one question per row: what is the next concrete step, and whose move is it? Any row without an answer is a deal dying quietly. Investors rarely say no outright — they let threads expire. Your review is the antidote: a polite nudge before the thread snaps.
- Turn passes into an update list
Filter by revisit_date monthly. Every soft pass ("too early", "come back with more revenue") gets a short, factual update the moment you hit the milestone they named: metric reached, here's the proof. These emails are the cheapest meetings you'll ever book, because the fund already knows you — you're just supplying the missing data point.
Mistakes to avoid
- Asking for money before there is warmth
The cold blast to forty funds feels productive and almost never converts. Investors price in the fact that you couldn't find a path through your network. Spend the same hours on the intro path column instead: one credible warm introduction beats forty cold emails — and doesn't burn funds you'll want in the next round.
- Tracking funds instead of people
"Bluegate Ventures — in conversation" is a useless row. Which partner? Who holds the internal pen? Who introduced you? An investment needs one person willing to defend your deal in Monday's partner meeting. If your sheet doesn't know who that person is, you don't actually know where your deal stands.
- Treating a pass as final
Deleting the row after a no throws away the most valuable part of the conversation: the reason. "Too early" means "show me traction"; "portfolio conflict" means "ask again at the next fund". Without pass_reason and revisit_date your next round starts from zero — with them, it starts with thirty pre-warmed contacts.
- Killing momentum with drip outreach
Emailing two funds a week means you'll never have two interested parties at the same time — and therefore never any leverage. Use the finished pipeline to launch in waves of ten to fifteen conversations. Scarcity and parallelism aren't tricks; they're the only honest way a fair price gets discovered.
Frequently asked questions
- How many investors should be in a seed pipeline?
- Plan on 50 to 100 researched partners, of whom you actually approach 30 to 50. Typical funnels are steep: 50 first contacts become maybe 20 meetings, five second meetings, and one to three term sheets. Starting with ten names confuses a wish list with a pipeline — after three passes you're out of options.
- What exactly is an intro path?
- The shortest credible connection between you and a partner: a portfolio founder who can vouch for you, an angel already on your cap table, a mutual ex-colleague. Credible means the person knows your work and the fund respects their judgment. A weak intro from someone the partner barely knows is scarcely better than a cold email.
- Should I send investor updates to funds that passed?
- Yes — to every soft pass that showed genuine interest. A short monthly or quarterly update with metrics keeps you in mind and demonstrates reliability, the founder trait investors weight most. Many follow-on rounds start exactly this way: a fund that passed at seed leads the Series A because it watched twelve months of progress in real time.
- Do I need a CRM for this, or is a spreadsheet enough?
- For a single raise, a spreadsheet is entirely sufficient — fast, flexible, and yours. It gets tight between rounds: keeping forty partner relationships warm over two years usually fails in a sheet for lack of reminders. That's when moving to a personal CRM pays off; this CSV is deliberately built so the import is lossless.
Last updated: 2026-06-10
When the spreadsheet gets too small.
Endearist imports this CSV directly — and reminds you before contacts go quiet. Free up to 25 contacts.
Start free