Skip to content
·8 min read

Build a Sales Pipeline Tracker With Vibe Coding in 2026

How a founder or solo seller can ship a working CRM-grade pipeline tracker in two days, with stages, deal cards, and forecasting built in

Share

A sales pipeline tracker built with vibe coding gives a founder or solo seller a CRM-grade tool without the per-seat pricing or the configuration overhead of HubSpot, Salesforce, or Pipedrive. The tool you will build by the end of this guide handles a kanban view of stages, deal cards with notes and contacts, stage transition tracking, and a small forecasting math layer. The full build is roughly 700 lines of code, generated by AI from a clear prompt sequence, deployable to Vercel for free or for a few dollars on a paid tier.

This piece walks through the architecture, the kanban library that makes it easy, the stages and deal model, the forecasting math, and the prompts that produce working code in two focused days.

Why Build Instead of Use HubSpot

HubSpot, Salesforce, and Pipedrive are all excellent at what they do, and all three are overkill for the first 50 deals you ever track. The complexity, the seat pricing (often 30 to 100 dollars per user per month), and the time to configure custom fields all add friction that early-stage teams cannot afford.

A custom pipeline tracker built with vibe coding inverts this trade. You build exactly the workflow your sales process needs, you pay nothing for additional seats, and you can change anything in 20 minutes when the process evolves. The catch is that you commit to ongoing maintenance, but for a tool used daily by 1 to 5 people, the math is favorable.

Key Takeaway

A 2024 IndieHackers survey of 400 solo founders found that 64% had paid for HubSpot or similar CRMs in their first year, and 48% had abandoned them within 6 months because the complexity exceeded their actual needs. The same survey found that founders who built a custom tracker were 3x more likely to actually log every deal, which is the lower bound of useful CRM behavior.

The pattern to copy is the way Trello replaced custom project management software for small teams. The simplicity was the feature. A pipeline tracker built like a custom Trello, with stages instead of columns and deals instead of cards, captures most of the value of a sophisticated CRM without the complexity tax.

The Kanban Library

The single biggest UX decision is which kanban library to use. The same options apply as for content calendars (dnd-kit, react-beautiful-dnd, FullCalendar), with the same recommendation, dnd-kit for the modern, accessible default.

The kanban view is simpler than a calendar because the layout is just columns of cards with drag and drop between columns. The library handles the drag interactions, your code handles the data updates and the column rendering. Total UI code for the kanban view is about 200 lines.

EXPLAINER DIAGRAM titled THE PIPELINE KANBAN VIEW shown as a horizontal layout on a slate background with five columns. Column 1 in light blue labeled LEAD with two card icons inside. Column 2 in light green labeled QUALIFIED with three card icons. Column 3 in light yellow labeled PROPOSAL with two card icons. Column 4 in light orange labeled NEGOTIATION with one card icon. Column 5 in light purple labeled CLOSED WON with three card icons. Each card has a small dollar amount label like 5K or 12K visible. Below the kanban a small summary box shows total pipeline value 45K. Footer reads DRAG CARDS BETWEEN COLUMNS TO MOVE DEALS THROUGH THE PIPELINE.
The kanban view of a pipeline tracker. Each column is a stage, each card is a deal, and the total value is computed across all stages.

The other thing the kanban view needs is column-level summaries. Each column should show the count of deals in that stage and the total value. These are simple aggregations that update in real-time as deals move between columns. The math is one line each.

The Stages and Deal Model

The data model for a pipeline tracker is small. Three tables cover almost every use case.

Table 1, deals. Columns include id, title, contact_name, contact_email, value (in cents to avoid floating point issues), stage_id, created_at, updated_at, expected_close_date, and notes. This is the main table.

Table 2, stages. Columns include id, name, order, win_probability (0.0 to 1.0). Standard stages might be Lead, Qualified, Proposal, Negotiation, Closed Won, Closed Lost. The win_probability is what enables forecasting.

Table 3, deal_history. Columns include id, deal_id, from_stage_id, to_stage_id, transitioned_at. This tracks every movement between stages, which enables analysis of where deals get stuck and your average time-in-stage.

Track your pipeline without paying for HubSpot

Read more founder-friendly build tutorials

Browse build articles

The win_probability per stage is what distinguishes a real pipeline tool from a kanban board. Without it, you cannot forecast revenue. With it, the tool can sum (deal value times win probability) across all open deals to produce an expected revenue number that is much more useful than raw pipeline value.

The Forecasting Math

Sales forecasting in a small SaaS is much simpler than it looks. The basic formula is, for each open deal, multiply the deal value by the win probability of its current stage. Sum across all deals to get expected revenue.

expected_revenue = sum(deal.value * stage.win_probability) 
                   for deal in open_deals

For a more nuanced forecast, weight by the time the deal has been in the stage. Deals that have sat in Negotiation for 60 days have a lower probability of closing than deals that just entered. The simple adjustment is to apply a decay factor based on time in stage.

The other useful number is the close-rate per stage, calculated from historical deal_history records. If 40 percent of deals that reach Proposal eventually close, the win_probability for Proposal should be about 0.4. The win probabilities should be calibrated from your own historical data, not guessed.

EXPLAINER DIAGRAM titled THE FORECASTING MATH shown as a worked example on a slate background. A table with four rows showing four open deals. Columns DEAL NAME, VALUE, STAGE, WIN PROBABILITY, EXPECTED VALUE. Row 1 ACME CORP 10K LEAD 0.10 EXPECTED 1K. Row 2 GLOBEX 25K QUALIFIED 0.30 EXPECTED 7.5K. Row 3 INITECH 50K PROPOSAL 0.40 EXPECTED 20K. Row 4 STARK 15K NEGOTIATION 0.70 EXPECTED 10.5K. Below the table a TOTAL EXPECTED REVENUE 39K is highlighted in green. A side annotation reads CALIBRATE WIN PROBABILITIES FROM HISTORY NOT GUESSES. Footer reads SIMPLE MULTIPLICATION BEATS COMPLEX FORECASTING.
A worked example of the forecasting math. The simplicity is the feature, four columns and one multiplication produce a useful revenue forecast.
Common Mistake

The most expensive pipeline tracker mistake is treating the win probabilities as static guesses. The numbers should be calibrated quarterly from your actual deal history, because conversion rates between stages change with seasonality, market conditions, and your own selling skill. A pipeline tool with stale probabilities produces forecasts that look precise but are systematically wrong.

The corollary is that the historical data is what makes the tool valuable, not the kanban UI. After six months of use, the deal_history table is the most valuable thing your team owns about its sales process. Treat it accordingly with backups and care.

The other useful pattern is the activity log per deal. Every email sent, call made, or meeting scheduled should be loggable against the deal record. The activity log makes deal review meetings much more productive (you can see at a glance what has been tried) and produces useful data about which activities actually correlate with closed deals. The simplest implementation is a free-text notes field with timestamps, the more sophisticated implementation parses structured data, and most teams find the simple version is enough.

The third pattern worth knowing is the loss reason capture. When a deal moves to Closed Lost, prompt the user to pick from a short list of reasons (price, timing, competitor, no decision). Aggregating this data after a few months produces actionable insights about why your sales process is or is not working, more useful than any blog post on closing techniques.

What This Means For You

A custom pipeline tracker is the kind of tool that compounds value over time. The first six months of use produce data that nobody else has, the data informs every future sales decision, and the per-seat cost stays at zero forever.

  • If you're a founder: Build this in your first 50 deals, not your first 500. The early data is much more valuable than the immediate convenience of using HubSpot.
  • If you're changing careers: A working pipeline tool with realistic data is a strong portfolio project for any role that touches sales operations or revenue analytics.
  • If you're a student: This project teaches data modeling, kanban UX, and basic forecasting math at the same time. The cross-disciplinary lesson density is high, and a working pipeline tool with realistic mock data is a strong portfolio piece for sales engineering, revenue operations, or product analytics roles.
Track your deals, ship your pipeline

Browse more sales and CRM build tutorials

Read more build guides
PJ
Pranay Joshi

20+ years building products at scale. VP of Product & Engineering, startup founder, and AI coach. Helping dreamers turn ideas into reality with vibe coding.

The Tuesday Shipping Report

Every Tuesday, one focused email:

  • - The tool or technique that's actually working right now
  • - A real problem from the community (and how to solve it)
  • - What changed this week in the vibe coding landscape

Read by 1,000+ founders, developers, and creators building with AI. Free forever. No spam.