Amr MagdySalesforce CRM Consultant
Free download · no email needed

The wholesaling CRM field kit.

The fields, picklists, automation rules and Monday report that keep deals from leaking between the marketing dollar and the closed deal. Copy them into Salesforce, REsimpli, Podio, HubSpot or a spreadsheet. Free to use and change.

1. Lead fields (13)

Where each lead came from, what happens next and how fast you reached the seller. The two that matter most: Lead Source required before a lead leaves New, and Next Task Date required on every open lead.

Field nameTypeRequired whenWhy it matters
Lead SourcePicklistBefore Status can leave NewWithout it, no report can tie a contract or a closed deal back to the channel that paid for it.
CampaignLookup to Campaign (or text)Before Status can leave New, when Lead Source is a paid channelLead Source says which channel; Campaign says which mailer, list or ad. Spend is entered on the campaign, so cost per appointment and ROI need this link.
MarketPicklistAlwaysLets you compare channels and reps market by market instead of mixing a strong market with a weak one.
StatusPicklistAlwaysOne shared list of stages, so a report can count how many leads sit at each step and how long they stay there.
Next Task DateDateWhile the lead is open (Status is not Dead or Under Contract)An open lead with no next date is a lead nobody is working. This field makes the gap visible and lets you block it.
Touch CountNumber (auto)Never entered by hand; counted from logged calls, texts and emails to the sellerShows how much follow-up a lead actually got before it was marked Dead or went under contract.
Download lead-fields.csv

Video: Leads with no next step →Video: Missed seller calls →

2. Deal fields (23)

Underwriting on the deal itself: MAO as a formula, your repair estimate next to the buyer's, and booked fees kept separate from the fees you actually receive.

Field nameTypeRequired whenWhy it matters
Lead SourcePicklist (copied from lead, locked)Copied when the deal is created; not editable afterKeeps attribution intact from first call to closing so contracts and fees count for the right channel.
CampaignLookup to Campaign (copied from lead, locked)Copied when the deal is created; not editable afterContracts per campaign and ROI by campaign both read this field.
Deal StatusPicklistAlwaysSeparates deals that are booked from deals that are actually kept.
ARVCurrencyBefore Deal Status can move to Offer SentAfter-repair value from comps. Everything in MAO starts here.
Your Repair EstimateCurrencyBefore Deal Status can move to Offer SentYour team's repair number, the one MAO uses.
Buyer's Repair EstimateCurrencyWhen a buyer walks the property (optional)What the end buyer thinks repairs cost. Comparing it with yours shows whether your estimates run low.
Download deal-fields.csv

Video: Offers off-formula →Deal analyzer (MAO) →

3. Buyer fields (10)

Turn the buyer list into a database, so each deal goes to the buyers who actually buy that kind of house first.

Field nameTypeRequired whenWhy it matters
ZipsLong text (comma-separated) or multi-selectBefore the buyer gets deal blastsLets you send each deal only to buyers who buy in that zip.
Max PriceCurrencyBefore the buyer gets deal blastsFilters out buyers who can't pay your price, so the list stays short and relevant.
Rehab LevelMulti-select picklistBefore the buyer gets deal blastsA buyer who only wants light rehabs ignores a full gut, and the reverse.
Closing Speed (days)NumberOptionalWhen an inspection period is short, you want the buyers who actually close fast.
Last Bought DateDateUpdated when the buyer closes one of your deals (or from public records)Separates active buyers from names on a list.

Using a spreadsheet for buyers? Start from the free cash buyers list template (CSV).

Download buyer-fields.csv

Wholesaling CRM glossary →

4. Automation rules (10)

Plain-English rules that keep the fields filled in and honest, each with a Salesforce hint and an any-CRM hint.

  • No lead leaves New without a source
  • Every logged touch counts, and the first one is stamped
  • A missed seller call becomes a callback task in 5 minutes
  • No open lead without a next date
  • Dead needs a reason
  • Dead Reason sets the revisit date
  • Offers above MAO need a second pair of eyes
  • Signing a contract stamps the numbers that matter later
  • A fall-out zeroes the fee and records why
  • Every Monday, list the hot leads nobody touched
Download automation-rules.md

Questions

Is it really free? Do I need to give my email?
Yes, it's free and there's no form. Download the files, copy them, change them. Credit is nice but not required.
Does it only work in Salesforce?
No. Every field and rule has a plain-English version for any CRM, including REsimpli, Podio, HubSpot or a spreadsheet. Where Salesforce needs something specific, there's a one-line Salesforce hint.
Where should I start if I can only do one thing?
Make Lead Source required before a lead leaves New, and make Next Task Date required on every open lead. Those two fields fix the most common leaks: not knowing which marketing pays, and leads nobody follows up.
Why these fields and not others?
Each one exists so a specific weekly number can be counted: cost per appointment by campaign, contracts per campaign, time from contract to first seller call, booked vs. kept profit, and campaign ROI including the houses you keep.

On Salesforce and want it checked in your own org? Here's what the audit covers, or see a sample report. On another CRM? See how a move to Salesforce works.

See also: the wholesaling CRM checklist, stage by stage.

Found this useful?

Ask me how this would work in your CRM.

Send one question about your setup, whether you're on Podio, an investor CRM, spreadsheets or Salesforce. No pitch, just a straight answer.

Email a question WhatsApp Message on LinkedIn Book a 30-minute call
Amr Magdy

About the author: Amr Magdy

Amr Magdy is a Salesforce CRM Consultant for US real estate investors and wholesalers. He runs the Salesforce for a two-market home-buying company in Ohio, where he built campaign ROI by market, missed-call alerts, shared lead queues and underwriting on the deal record, and he builds the same system for other investor teams. LinkedIn · Free tools · CRM Revenue Audit

Book a free callThe audit