Onboarding Process Mapping Worksheet

Your client onboarding process is costing you money. Every manual handoff, every duplicated data entry, every "I'll follow up on that" creates friction that delays revenue recognition and burns billable hours on administrative work.

This worksheet gives you a systematic method to document your current onboarding workflow, quantify the time drain, and identify which steps to automate first. You'll walk away with a prioritized roadmap that cuts onboarding time by 40-60% and eliminates the most common client complaints about getting started.

By the end of this exercise, you'll have:

• A complete process map showing every onboarding step, owner, and average time requirement
• A bottleneck analysis highlighting where clients get stuck and why
• An automation priority matrix ranking opportunities by impact and implementation difficulty
• A 90-day implementation plan with specific tools and owners assigned

Plan to spend 2-3 hours completing this worksheet. Involve your operations manager, a senior project manager, and someone from IT or systems administration.

Document every step in your existing onboarding workflow. The goal is brutal honesty about what actually happens, not what your procedures manual says should happen.

Step 1: List Every Onboarding Task

Open a spreadsheet or use the table template below. List every single task from "prospect becomes client" to "delivery team takes over." Include the invisible work: the follow-up emails, the "quick calls" to clarify information, the manual data transfers between systems.

Example task list for a mid-sized law firm:

1. Client signs engagement letter (DocuSign)
2. Intake coordinator receives notification
3. Intake coordinator creates client folder in document management system (NetDocuments)
4. Intake coordinator creates client record in practice management system (Clio)
5. Intake coordinator creates client record in accounting system (QuickBooks)
6. Intake coordinator requests W-9 and insurance certificates via email
7. Intake coordinator follows up on missing documents (average 2.3 follow-ups per client)
8. Conflicts analyst runs conflicts check in conflicts database
9. Conflicts analyst emails results to engagement partner
10. Engagement partner reviews and approves
11. IT provisions email distribution list for matter team
12. IT provisions shared drive access for matter team
13. Intake coordinator schedules kickoff call (average 3 emails to find time)
14. Engagement partner conducts kickoff call
15. Engagement partner sends kickoff summary email
16. Intake coordinator updates matter details in practice management system
17. Intake coordinator sends welcome packet with portal login instructions
18. Intake coordinator follows up if client hasn't logged into portal (average 1.8 follow-ups)
19. Intake coordinator notifies delivery team that client is ready
20. Delivery team lead reviews client file and confirms readiness

Your list will be different. The point is to capture the real workflow, including all the "glue work" that happens between the official steps.

Step 2: Map Owners, Duration, and Pain Points

For each task, document:

• Owner: Who actually does this work (name or role)
• Avg. Time: How long it typically takes (be realistic)
• Wait Time: How long until the next step starts (this reveals bottlenecks)
• Pain Points: What goes wrong, what causes delays, what frustrates people

Example mapping table:

| Step | Owner | Avg. Time | Wait Time | Pain Points | |------|-------|-----------|-----------|-------------| | Client signs engagement letter | Client | 5 min | 3-7 days | Clients forget to sign, no automated reminders | | Create client folder in NetDocuments | Sarah (Intake) | 8 min | 0 | Manual folder structure setup, inconsistent naming | | Create client record in Clio | Sarah (Intake) | 12 min | 0 | Re-entering data already in DocuSign | | Create client record in QuickBooks | Sarah (Intake) | 10 min | 0 | Re-entering same data a third time | | Request W-9 and insurance certs | Sarah (Intake) | 5 min | 4-10 days | Generic email template, no tracking system | | Follow up on missing documents | Sarah (Intake) | 15 min | 3-5 days | Manual tracking in spreadsheet, clients claim they never got first email | | Run conflicts check | Mike (Conflicts) | 20 min | 1-2 days | Waiting for Mike's availability, manual database queries | | Review conflicts results | Partner | 10 min | 0-3 days | Depends on partner's schedule, sometimes forgotten | | Provision email distribution list | IT | 15 min | 1-2 days | IT ticket queue, unclear naming conventions | | Provision shared drive access | IT | 10 min | Same ticket | Manual permission assignment | | Schedule kickoff call | Sarah (Intake) | 25 min | 5-8 days | Email tennis with 4-6 people, no calendar integration |

Continue this for all tasks. The "Wait Time" column is critical. It reveals where clients sit idle while your team juggles other priorities.

Step 3: Calculate Total Time and Cost

Add up the numbers:

• Total Active Time: Sum of all "Avg. Time" values (time your team spends working)
• Total Elapsed Time: Sum of all "Wait Time" values plus active time (calendar days from start to finish)
• Labor Cost: Total active time × average hourly rate of people involved

Example calculation:

• Total Active Time: 4.2 hours per client
• Total Elapsed Time: 18-35 calendar days
• Labor Cost: 4.2 hours × $75/hour = $315 per client in administrative overhead

If you onboard 120 clients per year, that's $37,800 in pure administrative cost, plus the opportunity cost of delayed project starts.

Now identify which tasks to automate. Not everything should be automated. Focus on high-volume, rules-based work that doesn't require human judgment.

Step 1: Score Each Task

Rate each task on two dimensions:

Automation Feasibility (1-5 scale):

• 5 = Fully automatable with existing tools (API

  API

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

  integrations, Zapier, built-in features)
• 4 = Automatable with moderate configuration (custom scripts, workflow builders)
• 3 = Requires new software or significant development
• 2 = Partially automatable (can reduce manual work but not eliminate it)
• 1 = Must remain manual (requires human judgment or relationship building)

Impact Score (1-5 scale):

• 5 = Saves >30 minutes per client OR eliminates a major client complaint
• 4 = Saves 15-30 minutes per client OR significantly improves client experience
• 3 = Saves 5-15 minutes per client OR moderately improves experience
• 2 = Saves <5 minutes per client OR minor experience improvement
• 1 = Minimal time savings and experience impact

Example scoring:

| Task | Feasibility | Impact | Priority Score | |------|-------------|--------|----------------| | Create client folder in NetDocuments | 5 | 3 | 15 | | Create client record in Clio | 5 | 4 | 20 | | Create client record in QuickBooks | 5 | 4 | 20 | | Request W-9 and insurance certs | 4 | 4 | 16 | | Follow up on missing documents | 5 | 5 | 25 | | Run conflicts check | 3 | 4 | 12 | | Schedule kickoff call | 4 | 5 | 20 | | Provision email distribution list | 4 | 3 | 12 | | Conduct kickoff call | 1 | 5 | 5 |

Priority Score = Feasibility × Impact. Focus on scores of 15 or higher.

Step 2: Identify Specific Automation Solutions

For your top-scoring tasks, specify exactly how you'll automate them. Name the tools, describe the workflow, estimate implementation time.

Example automation specifications:

Task: Create client records in Clio and QuickBooks

• Solution: Zapier integration triggered by DocuSign completion
• Workflow: DocuSign completion → Zapier extracts client data → Creates Clio matter → Creates QuickBooks customer → Sends Slack notification to intake coordinator
• Tools Needed: Zapier Professional plan ($49/month), existing DocuSign/Clio/QuickBooks accounts
• Implementation Time: 4-6 hours to build and test
• Owner: Operations Manager + IT
• Time Savings: 22 minutes per client × 120 clients = 44 hours/year

Task: Follow up on missing documents

• Solution: Automated email sequence in practice management system
• Workflow: Initial document request sent → If not received in 3 days, send reminder 1 → If not received in 3 more days, send reminder 2 → If still not received, create task for intake coordinator to call
• Tools Needed: Clio Grow (add-on to existing Clio subscription, $39/user/month)
• Implementation Time: 2 hours to set up email templates and automation rules
• Owner: Intake Coordinator + Operations Manager
• Time Savings: 15 minutes per client × 120 clients × 1.8 follow-ups = 54 hours/year

Task: Schedule kickoff call

• Solution: Calendly integration with round-robin scheduling
• Workflow: Intake coordinator sends Calendly link → Client selects time from available slots across all relevant team members → Meeting auto-added to everyone's calendar → Automated reminder emails sent
• Tools Needed: Calendly Professional ($12/user/month)
• Implementation Time: 3 hours to configure availability rules and integrate with Google Calendar
• Owner: IT + Intake Coordinator
• Time Savings: 20 minutes per client × 120 clients = 40 hours/year

Repeat this for each high-priority task. Be specific about tools, costs, and owners.

Step 3: Build Your Automation Priority Matrix

Plot your tasks on a 2×2 matrix:

Quick Wins (High Impact, High Feasibility)

• Automate these first
• Target: Implement within 30 days
• Example: Automated document follow-ups, Calendly scheduling

Strategic Projects (High Impact, Lower Feasibility)

• Plan these for months 2-3
• May require vendor evaluation or custom development
• Example: Full CRM

  CRM

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

  -to-accounting integration, conflicts database automation

Low-Hanging Fruit (Lower Impact, High Feasibility)

• Implement if you have spare capacity
• Don't prioritize over Quick Wins
• Example: Automated welcome emails, folder structure templates

Deprioritize (Lower Impact, Lower Feasibility)

• Don't automate these
• Accept that some manual work will remain
• Example: Kickoff call facilitation, complex conflicts reviews

Design your optimized onboarding workflow. Show what happens automatically, what requires human input, and where clients experience the process.

Step 1: Map the Automated Workflow

Create a new process map showing your future state. Use these conventions:

• [AUTO] = Fully automated, no human intervention
• [HUMAN] = Requires human work, but streamlined
• [CLIENT] = Client self-service action
• [TRIGGER] = Event that starts an automated sequence

Example future-state workflow:

1. [CLIENT] Client signs engagement letter in DocuSign
2. [TRIGGER] DocuSign completion triggers automation sequence
3. [AUTO] Zapier creates client records in Clio, QuickBooks, NetDocuments
4. [AUTO] Zapier sends Slack notification to intake coordinator and conflicts analyst
5. [AUTO] Clio Grow sends document request email to client (W-9, insurance certs)
6. [HUMAN] Conflicts analyst runs conflicts check (20 min)
7. [AUTO] Conflicts analyst marks "approved" in Clio, triggers next sequence
8. [AUTO] IT provisioning script creates email distribution list and shared drive (runs nightly)
9. [AUTO] Clio Grow sends Calendly link to client for kickoff call
10. [CLIENT] Client selects kickoff time from available slots
11. [AUTO] Calendar invites sent to all participants
12. [HUMAN] Engagement partner conducts kickoff call (60 min)
13. [HUMAN] Engagement partner updates matter details in Clio (10 min)
14. [AUTO] Clio sends welcome packet email with portal login
15. [AUTO] If client doesn't log in within 3 days, automated reminder sent
16. [AUTO] Once all documents received and portal accessed, Slack notification to delivery team
17. [HUMAN] Delivery team lead reviews file and confirms readiness (15 min)

New metrics:

• Total Active Time: 1.75 hours (down from 4.2 hours)
• Total Elapsed Time: 7-10 calendar days (down from 18-35 days)
• Labor Cost: $131 per client (down from $315)
• Annual Savings: $22,080 in labor + faster time-to-revenue

Step 2: Define Success Metrics

Establish baseline metrics and targets:

| Metric | Current | Target | Measurement Method | |--------|---------|--------|-------------------| | Avg. onboarding elapsed time | 26 days | 10 days | Clio report: engagement letter signed to delivery team notified | | Intake coordinator hours per client | 2.1 hours | 0.8 hours | Time tracking in Harvest | | Document collection completion rate | 68% within 7 days | 90% within 7 days | Clio Grow analytics | | Client portal activation rate | 73% | 95% | Clio analytics | | Kickoff call scheduling time | 5.2 days | 2 days | Calendar data analysis | | Client satisfaction (onboarding) | 7.8/10 | 9.0/10 | Post-onboarding survey (Typeform) |

Review these metrics monthly for the first quarter, then quarterly after that.

Step 3: Create Your 90-Day Implementation Plan

Break your automation roadmap into three 30-day sprints.

Days 1-30: Quick Wins

Week 1:

• Set up Calendly accounts for all partners and senior associates
• Configure availability rules and integrate with Google Calendar
• Create email template with Calendly link
• Owner: IT Lead
• Success Metric: 100% of new clients scheduled via Calendly

Week 2:

• Build Zapier workflow: DocuSign → Clio + QuickBooks + NetDocuments
• Test with 3 dummy clients
• Document troubleshooting steps
• Owner: Operations Manager
• Success Metric: Zero manual data entry for new client records

Week 3:

• Set up Clio Grow document request automation
• Create email templates for initial request and 2 follow-ups
• Configure 3-day and 6-day reminder triggers
• Owner: Intake Coordinator + Operations Manager
• Success Metric: 85% document collection within 7 days

Week 4:

• Monitor all new automations
• Fix bugs and edge cases
• Train intake team on new workflows
• Owner: Operations Manager
• Success Metric: All automations running without manual intervention

Days 31-60: Strategic Projects

Week 5-6:

• Evaluate conflicts database automation options
• If using external vendor, request demos and pricing
• If building in-house, scope requirements with IT
• Owner: Conflicts Analyst + IT Lead

Week 7-8:

• Implement chosen conflicts automation solution
• Migrate historical data if needed
• Build integration with Clio for automatic triggering
• Owner: IT Lead + Conflicts Analyst

Days 61-90: Optimization and Measurement

Week 9:

• Pull baseline metrics for all KPIs
• Compare to targets
• Identify remaining bottlenecks
• Owner: Operations Manager

Week 10-11:

• Address any automation failures or edge cases
• Optimize email templates based on client feedback
• Refine Calendly availability rules
• Owner: Intake Coordinator + Operations Manager

Week 12:

• Document all new processes in operations manual
• Create training videos for new hires
• Present results to leadership team
• Plan next phase of automation
• Owner: Operations Manager

1. Schedule the mapping session (2-3 hours with key stakeholders)
2. Complete Section 1 (current state mapping)
3. Score automation opportunities (Section 2, Step 1)
4. Select your top 3-5 automation projects (Section 2, Step 2)
5. Assign owners and deadlines