Prospect List Template (Excel): The Business Development Tracker Contractors Actually Fill In

Repeat customers generated 69% of work volume and 44% of revenue for contractors in 2022, according to ServiceMonster’s repeat rate research. The industry average for second-job retention sits at 38%; top performers hit 65-75%.

That gap is your prospect list. The contractors who track builders, referral partners, and past customers in a real spreadsheet are the ones converting cold names into recurring revenue. Everyone else starts over every January.

A homeowner lead tracker logs inbound demand. A prospect list does the opposite: it tracks named accounts you want to be doing business with - the commercial GC with 4 multifamily jobs coming, the realtor who closes 20 homes a year, the customer whose AC you replaced in 2022 due for a service plan. Different game, different sheet.

What is a business development tracker actually for?

A prospect tracking spreadsheet monitors named accounts you have decided to pursue, not random inbound leads.

QuickMail’s prospect list template structure puts it directly: company, contact name, title, email, phone, status, priority, last contacted, next step. Built for outbound, not inbound.

A commercial roofer chasing property management companies, a plumber building a builder book, an electrician staying in front of last year’s panel-upgrade customers - all three need the same sheet.

The inbound lead tracker answers “who called today.” The prospect list answers “who haven’t I touched in 60 days who could send me $80,000 of work this quarter.”

If you have not built the inbound side, the free 9-column lead tracker covers that job. This post is the next sheet over.

Why do contractors need a prospect list when they have a CRM?

Most contractor CRMs were built for inbound dispatch, not outbound BD.

Housecall Pro, Jobber, and ServiceTitan are great at “a homeowner called, dispatch a tech, invoice the job.” They are weak at “stay in front of 40 builders and 25 past customers for 6 months without any of them booking a job today.”

The named accounts you want to court do not have an open ticket. They show up as nothing in your CRM until they call - by which point a competitor often beat you there.

A spreadsheet you actually maintain beats a CRM module nobody opens. The Focus 40 tracker concept - 40 referral partners worth touching every quarter - works for contractors the same way it works for mortgage brokers. Build the list, work the list.

What columns does a contractor prospect list need?

Eleven columns cover GCs, builders, realtors, property managers, and past customers without becoming busywork.

#	Column	What goes in it
1	Account Name	Company or homeowner full name
2	Account Type	Builder, GC, Realtor, Property Mgr, Past Customer, Referral Partner
3	Primary Contact	Name + title (Project Manager, Owner, Office Manager)
4	Phone / Email	Both if you have them
5	Annual Potential ($)	Best-guess estimate of yearly revenue this account could send
6	Status	Cold, Warm, Active, Dormant, Lost
7	Last Touch Date	The day you last talked, emailed, or showed up
8	Next Touch Date	A specific date - drives your week
9	Touch Type Owed	Call, drop-by, lunch, holiday card, project update
10	Last Job (Date / $)	Most recent job done for or with this account
11	Notes	Kids’ names, equipment brand preference, last bid lost on, anything useful next call

The croclub.com prospect tracking spreadsheet guide and Bricks’ BD tracker template both land on the same skeleton because these are the fields that matter when you are chasing accounts instead of dispatching jobs. Anything more and your office manager stops opening the file.

How do you set up the formulas that drive the week?

Three formulas turn a static list into a working BD pipeline.

Days since last touch: =TODAY()-G2 in a helper column. Sort descending. The top of the list is who you have been ignoring longest.

Overdue follow-up flag: Conditional format on “Next Touch Date” with =AND(H2<TODAY(), F2<>"Lost"). Red background. Open the sheet Monday, the red rows are the calls you owe.

Pipeline value by status: On a Summary tab, =SUMIFS(E:E, F:F, "Active") shows total dollars of active opportunities. Same formula with “Warm” tells you what is one good conversation away.

The Djaboo Excel prospecting dashboard guide and the Bricks BD-tracker-in-Excel walkthrough both push the same math. Conditional formatting plus a few SUMIFS replaces 80% of what a $129/month CRM dashboard does.

Which account types should a contractor track separately?

Lumping everyone into “leads” is why most contractor BD lists die in month two. Five account types each get a different touch cadence:

• Commercial GCs and builders - quarterly project-pipeline calls, monthly drive-bys
• Realtors and property managers - monthly value drops, quarterly lunch
• Past customers (1-3 years out) - semiannual maintenance reminders, annual seasonal email
• Referral partners - monthly check-ins, reciprocal lead tracking
• Dormant past customers (3+ years) - annual reactivation email

A commercial roofer on ContractorTalk described tagging his list this way and finding 80% of his next-year revenue was sitting in “past customer” and “GC” rows he had not touched in 9 months. Three weeks of outreach reopened five projects worth $147,000 in signed contracts.

Contractor referral programs and getting leads from realtors and property managers go deeper on each account type.

How often should you touch each type of prospect?

Cadence separates a list from a system.

Tier 1 - Active opportunities: Weekly. Mid-deal, mid-quote. Go quiet 14 days and you lose it.

Tier 2 - Warm builders, GCs, property managers: Every 30 days. A project photo, code update, or material price tip.

Tier 3 - Realtors, referral partners: Every 45-60 days. Lunch quarterly.

Tier 4 - Past customers (1-3 years): Every 90 days. Direct call when seasonal service is due.

Tier 5 - Dormant accounts (3+ years): Annual reactivation with a specific reason to call.

A plumbing owner on r/sweatystartup ran this cadence on a 60-row prospect list for one year. He tracked $214,000 in revenue directly attributed to follow-up touches on the list, against zero new ad spend. The unit cost: 90 minutes a week of disciplined calling.

This is the same math behind getting more repeat customers in home service.

What does the BD math actually look like?

Level’s contractor benchmark report found the median contractor converts 73.9% of quotes that reach the customer with a clear decision. Raw conversion across all quote stages drops to 42%.

The same report puts the dollar value on it: moving from 60% to 85% close rate on the same quote volume is worth $1.25M on a $5M pipeline.

ServiceMonster’s repeat-rate research shows the average home service business retains 38% of customers for a second job; top performers hit 65-75%. A repeat customer spends roughly 67% more than a new one, and improving retention by 5% lifts profits 25-95%.

The prospect list is where all three numbers compound. Cost per lead vs cost per booked job shows why the math on a tracked prospect almost always beats a cold ad-driven lead.

How do you build this in Excel or Google Sheets in 20 minutes?

Open a new Google Sheet (or Excel file). Name it “Prospect List [Year].” Add the 11 columns as row 1.

Account Type dropdown: Column B, Data > Data validation, paste: Builder, GC, Realtor, Property Manager, Past Customer, Referral Partner, Dormant.

Status dropdown: Column F: Cold, Warm, Active, Dormant, Lost.

Conditional formatting:

• Column H “Next Touch Date”: =AND(H2<TODAY(), F2<>"Lost", F2<>"Dormant"), red fill
• Column G “Last Touch Date”: =TODAY()-G2>90, yellow fill
• Column E “Annual Potential”: gradient fill, bigger dollars darker

Summary tab formulas:

• Active pipeline: =SUMIFS(E:E, F:F, "Active")
• Warm pipeline: =SUMIFS(E:E, F:F, "Warm")
• Overdue accounts: =COUNTIFS(H:H, "<"&TODAY(), F:F, "<>Lost")

Share with your office manager and one other person on the team. The single biggest predictor of whether this sheet works is whether two people own it. One person abandons inside a quarter. Two keep each other accountable.

For the inbound side, the free lead tracker template covers the 9-column sheet that handles incoming calls.

What stories from real contractors show this working?

An HVAC owner on r/sweatystartup posted his BD playbook after using a 73-account prospect list for 18 months. Out of 73 accounts, 51 generated at least one job, totaling $387,000 in revenue. No paid ads against that list - 6 hours a week of his office manager’s time.

A commercial electrician on ContractorTalk tracked 22 GCs and builders. 9 sent zero work for 12 months, then 3 of those 9 turned into $94,000 of signed work in month 13 because he kept showing up with project updates while competitors went silent.

A residential remodeler in the Owned and Operated podcast referenced his “past customer 4-touch year” sheet: spring service email, summer photo of nearby work, fall maintenance reminder, holiday card. He attributed 23% of annual revenue to repeat work driven by the touch sequence, at 2 hours per week.

The discipline is the variable, not the software.

When should you upgrade from spreadsheet to CRM for BD?

Upgrade when:

• The prospect list crosses 200 active rows
• You have 3+ people doing outreach against the same accounts (duplicate-touch risk)
• You need real email tracking - open rates, reply rates, deal-stage automation
• You want pipeline forecasting tied to actual project bids

Until then, the spreadsheet wins on speed, cost, and simplicity. A prospect list you actually update every Monday beats a Pipedrive seat nobody logs into.

When that day comes, CRM for small contractors and the contractor CRM showdown cover the upgrade decision. Lead management system and sales tracking software go deeper if you have real outbound BD, not just dispatch.

What about prospects who never raise their hand?

The biggest gap in any prospect list is the named accounts you do not know to chase yet.

The GC who searched your service area three times last month and never called. The property manager who pulled up your website during a Tuesday lunch and bounced. The realtor who reads your case studies but never reaches out.

That gap is the same gap on the inbound side - the 96% of website visitors who never become leads - except on the BD side it is the named decision-makers at companies you would love to land.

Identifying anonymous website visitors and the parent guide to paid ads analytics tools for contractors cover how to surface those accounts before they show up in a competitor’s pipeline.

Frequently Asked Questions

What is a prospect list template in Excel?

A prospect list template is a structured spreadsheet for tracking named accounts you want to do business with - commercial GCs, builders, realtors, property managers, past customers, and referral partners. The standard template has 10-12 columns covering company name, contact, status, annual potential, last touch, next touch, and notes. It differs from an inbound lead tracker because it tracks accounts you are chasing.

What is the difference between a lead tracker and a business development tracker?

A lead tracker logs inbound demand - someone called, submitted a form, or walked in. A business development tracker manages outbound effort against named accounts. The columns overlap on contact info and status, but the BD tracker adds annual potential, last touch date, next touch date, and account type fields because the work is staying in front of named accounts, not dispatching incoming calls.

How do I track referral partners in a spreadsheet?

Use the prospect list structure with “Account Type” set to Referral Partner. Track last touch date, next touch date, and touch type owed on a 45-60 day cadence. Add a column for reciprocal leads sent to track the relationship’s two-way value.

What columns should a commercial contractor prospect list include?

Eleven columns cover it: account name, account type, primary contact, phone/email, annual potential, status, last touch date, next touch date, touch type owed, last job, and notes. Add a “decision-maker” and “project pipeline visibility” column if you are chasing multifamily or commercial GCs with multi-million dollar annual programs.

How often should I update a prospect list?

Weekly at minimum. Block 60-90 minutes every Monday to update statuses, schedule outreach, and review red overdue rows. A prospect list updated once a quarter is worse than no list because it gives you false confidence the work is happening when it is not.

---

Build the 11-column sheet, set the conditional formatting, and block a Monday hour to work it. A disciplined prospect list - past customers, referral partners, builders, GCs - is where the next $200K of revenue is hiding for most contractors who have already maxed their ad budget.

Once the sheet is humming and you want to see the GCs, property managers, and realtors researching you in silence - PipelineOn identifies anonymous website visitors so your prospect list keeps growing from demand you cannot see today.