An investor on our Series A call asked me a question I could not answer cleanly: what's your pipeline coverage for next quarter, by stage? I had a spreadsheet with color-coded rows and a gut feeling, and neither one turned into a number I trusted enough to say out loud.
Three weeks later we had a CRM running, a forecast I could defend line by line, and a signed term sheet. This is what actually happened in between, and why the tool mattered less than the discipline it forced on us.
The question that broke the spreadsheet
Up to that call, our spreadsheet had worked fine for us. It had never worked for anyone outside the company. I could scroll through it and narrate the story: this deal is close, that one's stalled, this founder ghosted us in March. What I could not do was hand it to someone else and have it mean the same thing without me sitting next to them explaining the colors.
The investor wasn't trying to catch me out. She was doing exactly what diligence is supposed to do: testing whether the numbers in the deck came from a process or from optimism. My answer, an honest 'we're tracking it closely,' told her the number came from optimism. She didn't say that. She just moved to the next question, and I spent the rest of the call distracted, doing math in my head that I should have already had on a slide.
Why 'trust me' doesn't survive diligence
Founders raising a round tend to assume investors are underwriting the team and the market. They are, but they are also underwriting your operating discipline, and pipeline is the cheapest place to check it. A spreadsheet-only sales process is not automatically a red flag at pre-seed. By Series A, it starts to read as a signal that reporting lives in your head instead of in a system, which means the next hire who touches sales has to rebuild your intuition from scratch.
That's the part I hadn't priced in. It wasn't that our pipeline was weak. It was that I was the only system of record, and a business that depends on one person's memory doesn't scale past that person's calendar. The CRM conversation I'd been postponing for six months stopped being a nice-to-have the moment someone outside the company needed the answer faster than I could produce it.
What we actually built in three weeks
We didn't have time for a proper evaluation process, and honestly we didn't need one. I picked a CRM built for small teams, migrated only the deals that were still open and moving, and gave myself one weekend to get stages, owners, and close dates entered correctly. Everything closed or dead from before that quarter stayed in the old spreadsheet, archived and untouched.
The part that actually mattered wasn't the software. It was that entering a deal now forced me to answer three questions I used to answer with a feeling: what stage is this really at, what has to happen for it to move, and by when. Doing that for forty open deals in one weekend was the closest thing to an audit our sales process had ever had, and it surfaced four deals I'd been quietly counting as 'likely' that had gone cold weeks earlier without me registering it.
By the follow-up call, I could show pipeline coverage by stage, average deal age, and a forecast built from actual close-date fields instead of a target divided evenly across the quarter. The investor didn't comment on the tool. She commented that the number moved by less than 10 percent between that call and the one after, which told her more about how the business actually ran than the first number ever could have.
The lesson wasn't about tooling
It's tempting to walk away from this thinking the fix was buying software. The real fix was that diligence forced a level of honesty about our own pipeline that day-to-day operating never had. Nobody makes you reconcile a spreadsheet against reality until someone outside the company asks you to defend it in front of a term sheet.
If you're raising in the next two quarters, don't wait for the question to expose the gap. Run your own version of that audit now, on your own schedule, without an investor watching you do it live.
Before your next diligence call:
- Pull every deal you'd call 'likely to close' this quarter and re-verify the close date against the last real conversation, not the date you first typed in
- Write down, per deal, the single next action that has to happen for it to move stage — if you can't name one, it isn't actually in motion
- Check whether anyone besides you could produce this quarter's pipeline coverage number without asking you first
- If the answer is no, that's the gap investors will find. Close it before they do, not after
Frequently asked questions
Do investors actually check your CRM during diligence?
Not usually directly. What they check is whether your pipeline numbers hold up under a second or third round of questioning. A spreadsheet can hold up fine if you're disciplined about it. What fails is when the numbers only exist in one founder's head.
Is it too late to switch tools once diligence has already started?
No. A weekend spent migrating only open, active deals is faster than most founders expect, and a cleaner pipeline mid-diligence reads better than a messy one you never touched.
What's the minimum a pre-Series A startup needs before fundraising?
A single source of truth for open deals, a next action logged against each one, and a forecast built from real close dates rather than a target spread evenly across the quarter. The tool matters less than whether someone besides you could produce that report on request.
The question that catches most founders off guard isn't about your market size or your growth rate. It's whether you can prove, on the spot, that you know your own pipeline as well as you claim to.