Most small businesses do not have a real pipeline. They have a list of names in someone's head, a stack of business cards, and a vague memory of who said they were "thinking about it." Here is how to fix that with free tools — and what those tools cannot give you.
Every prospect is in exactly one stage. You can see where every deal is, what's stuck, and where revenue is forecast for the next 30, 60, and 90 days. Your team knows who owns what. Nothing falls through the cracks because someone forgot to follow up. You can run a weekly review in 20 minutes instead of 90.
This is the part most people skip and then wonder why their pipeline is meaningless. A stage is not "where I feel like this deal is." A stage is a verifiable state with an objective entry criterion. Something like:
Write down the entry and exit criteria for each stage. Print it. Tape it next to your monitor. Without this, your "pipeline" is fiction.
In Trello, create a board with one column per stage. Each card is a deal — named with the company or contact, with the deal value in the card title or as a custom field. Use labels for source (referral, paid ads, organic, partner). Use due dates for the next required action.
If you prefer Notion, create a database with stage as a select field, value as a number, source as a multi-select, and toggle to a board view. Notion gives you better reporting; Trello gives you faster card movement on mobile.
A deal can only be in one stage at a time. If you find yourself wanting to put a deal "between" stages, your stage definitions are too vague. Tighten them.
Trello and Notion are great for visual management but terrible for reporting. Mirror every deal in a Google Sheet with these columns: deal name, value, stage, source, owner, created date, last activity date, expected close date, actual close date, won or lost, and lost reason.
Update the sheet at the same time you move a card. Yes, this is double entry. No, there is no clean way around it without a paid tool. Apps Script can sync Trello to Sheets via the Trello API, but you will spend a weekend on it and another weekend every time the API changes.
Block 30 minutes every Monday morning. Walk every column left to right and ask:
The "Closed Lost so we stop pretending" question is the most important one. Half of most pipelines is dead deals nobody has the heart to bury. They make your forecast meaningless.
Build a pivot table in your sheet showing total deal value by stage, weighted forecast (value times stage probability), conversion rate stage-to-stage, average cycle time, and win rate by source. This is the real product of having a pipeline. Without these numbers you are just shuffling cards.
If more than one person works deals, you need owner assignment, handoff notes, and a notification when a card moves stages. Trello's free tier handles assignment but not notifications — you will need to set up email rules or use a Slack integration. Notion handles all three but you will spend an afternoon designing the database properly.
The double entry problem kills most DIY pipelines within three months. Your board and your sheet drift apart. The board becomes the "real" view, the sheet becomes stale, and your forecasting becomes guesswork. There is no way to fix this without a tool that owns both the visual layer and the data layer.
You also have no automatic activity tracking. If you call a prospect, you have to remember to log it. If you email them, you have to copy the thread into the card or the sheet. Within weeks, half your activity is undocumented and your "last activity date" column lies to you.
A pipeline is a system for telling yourself the truth about your business. Free tools can simulate one. They cannot enforce one.
The Shortcut
Let VC Suite Do It For You.
Visual pipeline, automatic activity logging, weighted forecasting, owner assignment, stage notifications, and reporting that updates itself — all built in. One source of truth. Zero double entry. Live in your business in days.