Motivated Seller Lead Tracker CRM

Most wholesale deals close on the fifth to seventh touch, and most lost deals die in a forgotten notebook or a spreadsheet nobody rebuilt after the last one broke. If you cannot see today which leads are overdue and which are hot, you are working your pipeline by memory.

This tracker is a 3-sheet Excel workbook with 415 formulas, 3 dropdown lists, and 9 conditional-formatting rules. The Leads sheet holds 200 rows with name, phone, address, source (7-option dropdown), motivation 1-5, estimated ARV, asking price, a spread-percent formula, a 7-stage status dropdown (New through Closed and Dead), next follow-up date, and a lead score formula (motivation x 12 plus spread percent x 100, capped at 100). Each status has its own color, any open lead whose follow-up date is today or past turns red, and scores of 70 or more highlight as hot. The Call Log gives 300 rows for date and time (Ctrl+; and Ctrl+Shift+; enter them), lead name, a 6-type dropdown, notes, and next step date. The Pipeline Dashboard counts every status, follow-ups due, hot leads, average motivation, total estimated equity in negotiation, conversations logged, contact rate, and close rate, all live from the other two sheets.

In the first fifteen minutes: paste your current list into the Leads sheet (name, phone, address at minimum), set a status and a next follow-up date on each row, and open the Dashboard. The red cells tell you who to call first. Log each call on the Call Log as you go, and the dashboard's conversation count and close rate start telling you which sources are worth more money.