VIP Client List Template

Your firm's VIP clients generate 60-80% of revenue but often lack formal escalation protocols. When a partner is unreachable, a system goes down, or a deadline crisis hits, your team scrambles to figure out who owns what and how fast to respond.

This template eliminates that chaos. It's a dual-format system: a CRM

field configuration guide for firms using practice management software, plus a standalone spreadsheet for firms that need immediate deployment.

CRM

Field Setup Guide: Exact field names, data types, and visibility rules for Clio, MyCase, PracticePanther, or any CRM

CRM

Click to read the full definition in our AI & Automation Glossary.

with custom fields.

Excel/Google Sheets Template: Pre-formatted spreadsheet with conditional formatting, dropdown menus, and automatic escalation alerts.

Four Core Data Points:

• Client Name (legal entity, not DBA)
• Primary Owner (partner/director with P&L responsibility)
• Backup Owner (must be peer-level, not junior associate)
• Escalation Window (measured in hours, not "ASAP" or "urgent")

Field Configuration

Create four custom fields in your CRM

's client/matter record:

Field 1: VIP Status

• Field Type: Checkbox or Yes/No toggle
• Visibility: All users (read-only for associates, editable by partners)
• Purpose: Flags the client record for priority filtering

Field 2: Primary Relationship Owner

• Field Type: User lookup (single select)
• Validation Rule: Must be partner or director level
• Purpose: P&L owner, not just the person who opened the file

Field 3: Backup Relationship Owner

• Field Type: User lookup (single select)
• Validation Rule: Cannot be the same as Primary Owner, must be partner/director level
• Purpose: Peer-level coverage, not a junior team member

Field 4: Escalation Window (Hours)

• Field Type: Dropdown menu
• Options: 1 hour, 2 hours, 4 hours, 8 hours, 24 hours
• Purpose: Maximum response time for critical client issues

Clio-Specific Setup

1. Navigate to Settings > Custom Fields > Contacts
2. Click "Add Custom Field"
3. Name: "VIP Client Status" | Type: Checkbox
4. Name: "Primary Owner" | Type: User | Filter: Partners only
5. Name: "Backup Owner" | Type: User | Filter: Partners only
6. Name: "Escalation SLA (Hours)" | Type: Dropdown | Values: 1, 2, 4, 8, 24
7. Set field permissions: Partners = Edit, Associates = View Only
8. Create a saved filter: "VIP Clients" = VIP Status checkbox is checked

MyCase-Specific Setup

1. Go to Settings > Case Custom Fields
2. Add Field: "VIP Tier" | Type: Yes/No
3. Add Field: "Relationship Owner" | Type: Text (no native user lookup, use email)
4. Add Field: "Backup Contact" | Type: Text
5. Add Field: "Response SLA" | Type: Dropdown | Options: Same hour, Same day, Next day
6. Create a case tag: "VIP" and apply to all flagged clients
7. Build a dashboard widget filtering for the "VIP" tag

PracticePanther-Specific Setup

1. Settings > Custom Fields > Contacts
2. New Field: "VIP Client" | Type: Checkbox
3. New Field: "Primary Partner" | Type: User Dropdown
4. New Field: "Secondary Partner" | Type: User Dropdown
5. New Field: "Max Response Time" | Type: Number | Unit: Hours
6. Enable notifications: When VIP client emails arrive, alert both Primary and Secondary Partner
7. Create a Smart List: VIP Clients = VIP Client field = Yes

Use this if your CRM

lacks custom fields or you need a working system today.

Column Structure

| Column | Data Type | Validation Rule | Example | |--------|-----------|-----------------|---------| | A: Client Name | Text | Must match legal entity name | Acme Industries LLC | | B: Annual Revenue | Currency | >$50K for VIP status | $250,000 | | C: Primary Owner | Dropdown | Partner names only | Sarah Chen | | D: Primary Email | Email | Auto-validate format | schen@firm.com | | E: Primary Mobile | Phone | Format: (555) 555-5555 | (415) 555-0123 | | F: Backup Owner | Dropdown | Cannot = Primary Owner | Michael Torres | | G: Backup Email | Email | Auto-validate format | mtorres@firm.com | | H: Backup Mobile | Phone | Format: (555) 555-5555 | (415) 555-0198 | | I: Escalation Window | Dropdown | 1, 2, 4, 8, 24 hours | 2 | | J: Last Contact Date | Date | Auto-highlight if >30 days | 2024-03-15 | | K: Next Review Date | Date | Auto-calculate (Last + 90 days) | 2024-06-15 |

Excel Formula Setup

Conditional Formatting for Overdue Reviews:

• Select column J (Last Contact Date)
• Home > Conditional Formatting > New Rule
• Formula: =TODAY()-J2>30
• Format: Red fill, bold text

Auto-Calculate Next Review:

• Cell K2 formula: =J2+90
• Copy down for all rows

Dropdown Menu for Primary Owner:

• Create a "Staff" tab with partner names in column A
• Select column C in main sheet
• Data > Data Validation > List > Source: =Staff!$A$2:$A$20

Dropdown Menu for Escalation Window:

• Select column I
• Data > Data Validation > List > Source: 1,2,4,8,24

Google Sheets Notification Setup

1. Tools > Notification Rules
2. Trigger: "A user submits a form" (if using Google Forms for updates)
3. Or: Extensions > Apps Script > Add this code:

function sendEscalationAlert() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("VIP Clients");
  var data = sheet.getDataRange().getValues();
  
  for (var i = 1; i < data.length; i++) {
    var lastContact = new Date(data[i][9]); // Column J
    var daysSince = (new Date() - lastContact) / (1000 * 60 * 60 * 24);
    
    if (daysSince > 30) {
      MailApp.sendEmail({
        to: data[i][3], // Primary Email
        subject: "VIP Client Review Overdue: " + data[i][0],
        body: "Last contact with " + data[i][0] + " was " + Math.floor(daysSince) + " days ago."
      });
    }
  }
}

4. Set trigger: Edit > Current project's triggers > Add Trigger > Time-driven > Week timer > Every Monday

Do not use subjective terms like "strategic importance" or "key relationship." Use these objective thresholds:

Revenue Threshold: Annual billings exceed $50K (small firms) or $250K (large firms).

Concentration Risk: Client represents >5% of total firm revenue.

Regulatory Exposure: Client operates in finance, healthcare, or government sectors where service failures trigger compliance violations.

Reputational Leverage: Client has >10,000 employees, is publicly traded, or operates in your firm's target growth sector.

Referral Value: Client has referred >3 new clients in the past 24 months.

Apply at least two criteria. If a client meets only one, they're Tier 2, not VIP.

Match the window to client risk, not client preference.

1-Hour Window: Financial services clients during market hours, healthcare clients with HIPAA obligations, clients in active litigation.

2-Hour Window: Public companies during earnings season, clients with regulatory filing deadlines, clients in M&A transactions.

4-Hour Window: Clients with ongoing projects, retainer clients with monthly deliverables.

8-Hour Window: Standard VIP clients with no active deadlines.

24-Hour Window: VIP clients in maintenance mode (annual compliance, routine advisory).

Do not promise same-hour response unless you have 24/7 partner coverage. Under-promise and over-deliver.

The backup owner must be a peer, not a subordinate. If the primary owner is a partner, the backup is another partner. If the primary is a director, the backup is another director.

Avoid These Mistakes:

• Naming a senior associate as backup for a partner (client will notice the downgrade)
• Naming someone in a different practice area with no client context
• Naming someone who is already backup for 10+ other VIP clients

Ideal Backup Profile:

• Same practice area or adjacent specialty
• Has met the client at least once
• Carries fewer than 5 VIP backup assignments
• Works in the same office (if multi-location firm)

Assign a client services coordinator or practice manager to update the list monthly.

Monthly Review Checklist:

• Verify all Primary and Backup Owners are still employed
• Check Last Contact Date for any clients exceeding 30 days
• Update Annual Revenue figures after billing cycle closes
• Remove clients who no longer meet VIP criteria (revenue drop, matter closed)
• Add new clients who crossed the VIP threshold

Quarterly Leadership Review:

• Managing partner reviews the full list with practice group heads
• Confirm escalation windows still match client risk profiles
• Identify clients who need relationship development (low contact frequency)
• Reassign clients if Primary Owner workload is unbalanced

Annual Audit:

• Export the list and compare to top 20 revenue-generating clients
• If a top-20 client is missing from the VIP list, add them immediately
• Survey VIP clients: "How quickly do you expect a response to urgent issues?" Compare answers to your escalation windows

Scenario 1: Primary Owner Sudden Departure

Partner resigns effective immediately. You have 47 VIP clients assigned to them.

Hour 1: Managing partner emails all 47 Backup Owners: "You are now Primary Owner for [Client Name]. Review open matters and contact client within 24 hours."

Hour 2: Client services coordinator updates CRM

and spreadsheet, moving Backup Owner to Primary Owner field.

Hour 4: Managing partner assigns new Backup Owners (cannot leave the field blank).

Day 2: New Primary Owners send personalized emails to each VIP client: "I'm now your primary contact. Here's my direct line and mobile number."

Scenario 2: Ransomware Attack, CRM

CRM

Click to read the full definition in our AI & Automation Glossary.

Offline

Your CRM

is encrypted. You cannot access client contact information.

Minute 1: Client services coordinator opens the VIP spreadsheet (stored in Google Drive, not on local server).

Minute 5: Managing partner texts all Primary Owners: "CRM

is down. Use the VIP spreadsheet. Contact your clients via personal mobile if they reach out."

Hour 1: Firm sends a mass email to all clients (using email marketing platform, separate from CRM

): "We are experiencing technical issues. VIP clients: Your relationship partner will contact you directly within [X] hours."

Hour 2: Primary Owners manually email their VIP clients from personal devices with status updates.

This is why the spreadsheet must exist even if you use a CRM

. It's your offline backup.

Scenario 3: Client Escalation After Hours

VIP client emails at 9 PM on Friday. Matter involves a Monday morning court filing. Primary Owner is on a flight (unreachable).

9:15 PM: Client services coordinator (monitoring VIP inbox) sees the email, checks the VIP list, identifies Backup Owner.

9:20 PM: Coordinator texts Backup Owner: "VIP escalation. [Client Name] needs brief revisions by Sunday. Primary Owner is traveling."

9:30 PM: Backup Owner calls client directly, confirms scope, assigns associate to draft revisions.

10:00 PM: Backup Owner emails client: "We're on it. You'll have revisions by 8 AM Sunday."

This only works if the Backup Owner's mobile number is in the spreadsheet and the coordinator has authority to escalate after hours.

If you cannot answer these three questions in under 60 seconds, your VIP list is broken:

1. Who owns the relationship with your top revenue client?
2. Who covers that client if the primary owner is unreachable?
3. How fast must someone respond to that client's urgent email?

Build the spreadsheet today. Migrate to CRM

fields within 30 days. Review monthly. Audit annually. Your VIP clients will never wonder who to call when things go wrong.