Sales pipeline
How to track sales leads for a small business: a Midwest guide
Track sales leads with one shared list, five stages and a weekly review. Plus when a CRM pays off, with real prices, for Midwest small businesses.
Your best salesperson keeps the pipeline in his head. The office manager keeps a spreadsheet that is two weeks behind. Quotes go out from three inboxes, and the business cards from the last farm show are still in a truck console. Nobody is careless. There is just no single place where a lead lives, so follow-ups depend on memory and deals slip without anyone deciding to let them go.
Tracking sales leads in a small business comes down to four habits: put every lead in one shared list, give each lead an owner and a dated next step, move it through a few stages with clear rules, and review the list every week. A spreadsheet can do this well for a while. A CRM earns its cost when more than a few people work the list, or when the history behind every account has to survive staff changes. This guide is written for owners and sales managers at 10 to 75 person companies in Nebraska, Iowa, Kansas, Colorado and the wider Midwest.
Put every lead in one shared list
Leads reach a small business through more doors than most owners count: the phone, the website form, email, walk-ins, texts to a salesperson’s cell, referrals from customers and suppliers, and trade shows. Write down every door you have, then set one rule: if a lead is not in the list, it does not exist. The person who takes the call enters it the same day. Phone and walk-in leads get lost most often because nothing captures them automatically, and a shared list that anyone can update from a phone closes most of that gap.
The list does not need 40 columns. It needs the ones that drive the next action and the ones you will want when you look back.
| Column | What goes in it |
|---|---|
| Date in | The day the lead arrived |
| Company and contact | Business name, person, phone, email |
| Source | Website, referral, phone, show name, repeat customer |
| Need | What they asked about, in their words |
| Estimated value | A rough dollar figure |
| Stage | One of the five stages described below |
| Owner | One person, never “sales” |
| Next step and date | “Send quote by Oct 14” |
| Last contact | The date of the last real conversation |
| Outcome and reason | Won, or lost and why |
Use drop-down lists for Source, Stage and Owner so the values stay consistent. Free text in those columns is what makes a spreadsheet impossible to report on later.
Give every lead a stage, an owner and a dated next step
Stages only help if everyone uses them the same way, so keep them few and give each one a rule for moving forward. A lead is New until someone has had a real conversation. It becomes Qualified once you know what they need, roughly when, and who makes the decision. It is Quoted when a written quote has gone out, with the amount and date recorded. It sits in Decision while they compare options or wait on budget, and it ends as Won or lost, with the reason written down.
Quoted is the stage where small business deals most often slip away. A quote goes out, the customer goes quiet, and three weeks later nobody remembers to call.
The fix is the habit that does the most work in this whole system: every open lead has one owner and one next step with a date. “Follow up” is not a next step. “Call Tuesday to confirm the delivery window” is. When the date passes, the owner does the step, sets a new date, or closes the lead as lost. That rule removes the slow drift where a lead is never lost, just forgotten.
Review the list every week
Pick a fixed time, such as Monday morning, and go through the list together, sorted by next step date. Anything overdue gets a new date or gets closed. Every quote older than two weeks gets a call. Each new lead gets an owner. Twenty minutes is enough when the list is current. If the review takes an hour, the list was not being updated during the week, and that is the real problem to fix.
Once a month, look at four numbers, all of which come from the columns above: leads by source and how many became customers, the time from a lead arriving to the first real contact, the share of quotes that close, and the days from first conversation to signed order. Together they tell you where to spend marketing money, which salesperson needs help, and whether your quotes are priced right.
What changes for Midwest businesses
The habits are the same everywhere, but a few details matter more for a dealer in Kearney, a contractor in Cedar Rapids, a manufacturer in Wichita or a distributor in Greeley.
Seasons move the pipeline. Ag equipment buyers go quiet at planting and harvest, HVAC demand jumps with the first heat wave and the first hard freeze, and construction work bunches into the warm months. A lead that stops answering in October may not be lost. It may be in the field. Set its next step for after the season instead of closing it.
Trade show leads need a 48 hour rule. Business cards from a show like Husker Harvest Days in Grand Island are only useful if they reach the list while the conversation is fresh. Enter them within two days with the show name as the source, and next year you will know whether the booth paid for itself.
Territories are wide and careers are long. One salesperson may cover several counties or cross a state line, so clear ownership by territory and a list that can be updated from the truck matter more here than in a single metro. In family-owned firms, the best customer relationships often sit with one long-serving salesperson. When that person retires, the history leaves too unless it was written down, so ask your senior people to log their top accounts, recent quotes and key contacts while they are still there to explain them. A customer whose equipment is five years old is a lead as well: track replacement timing as a next step, not a memory.
When a spreadsheet stops being enough
We are a Salesforce consultancy, so weigh this accordingly: a shared spreadsheet is the right answer for plenty of small teams. It costs nothing beyond the Microsoft 365 or Google Workspace you already pay for, and for one to three people working one list, it does the job.
The signs that you have outgrown it are practical. More than three people edit it and someone has saved their own copy. You cannot answer “what did we quote them last spring?” in under a minute. Follow-ups happen because someone remembered, not because the list said so. Quotes and orders live in your ERP or accounting system and never match the list. A salesperson leaving would take years of history with them. If two or more of those sound familiar, it is time to look at a CRM seriously.
Cost is usually the first question. Free CRM tiers exist and are a reasonable place to start. Salesforce Starter Suite is $25 per user per month, and Pro Suite, which adds quoting and forecasting, is $100 per user per month billed annually, according to the Salesforce small business pricing page as of October 2026. Ten users on Starter Suite comes to $3,000 a year in licenses. Setup, importing your history and training come on top, whether you do them yourself or hire help.
When you move, keep the history. Clean duplicates first, keep the same five stages so nobody relearns the process on day one, and import with dates and sources intact, because a CRM that starts empty throws away what you already know. Set a cutover date, run both for no more than two weeks, and hold the next weekly review inside the CRM. If your leads connect to quotes and orders in an ERP, plan that connection before go-live. After that, reporting becomes the next question, and Salesforce dashboards have limits worth knowing about.
Common questions
Can I track sales leads in Excel or Google Sheets?
Yes. For one to three people, a shared sheet with the ten columns above, drop-down values and a weekly review works well. Its limits show when several people edit it at once, when you need reminders, or when you need the history of every call and email.
Do I need a consultant to set up lead tracking?
Not to start. Outside help pays off when you are moving years of history, connecting a CRM to an ERP or accounting system, or running several locations.
Where should a small business start?
Build the ten column list this week, enter every open lead, and hold the first review next Monday. You will learn more about your pipeline from those first twenty minutes than from any software demo. If your leads, quotes and orders already sit in systems that disagree with each other, that is the problem our diagnostic is built for.