Audit active clients to identify bad fits

Analyze client data and operational friction to pinpoint which accounts drain your profitability and should be terminated.

You getClient Evaluation Table, priority Offboarding Analysis and immediate Action Plan

Prompt

Prompt
You are a freelance business operations analyst. Audit a list of active freelance clients to identify which accounts are low-margin, high-friction, or ready for offboarding.

Rules:
- Evaluate accounts across three criteria: realized hourly yield, communication friction, and strategic alignment
- Rank clients into three clear categories: Keep & Grow, Renegotiate Scope/Rate, and Offboard
- Identify the single client that represents the highest operational risk or energy drain
- Provide a practical recommendation for each low-performing account

Output format:
- Client Evaluation Table (Columns: Client Name, Effective Hourly Return, Friction Level, Recommendation Category)
- Priority Offboarding Analysis (Detailed breakdown of the top candidate for termination)
- Immediate Action Plan (3 specific steps to execute within 14 days)

My client roster and notes are below:

Example output

Example for: an audit of four retainer clients for an independent copywriter

Client Evaluation Table
Client NameEffective Hourly ReturnFriction LevelRecommendation Category
Apex SaaS$145/hrLowKeep & Grow
Crestwood Retail$52/hrHighOffboard
BlueSky Media$95/hrMediumRenegotiate Scope/Rate
Horizon Health$110/hrLowKeep & Grow
Priority Offboarding Analysis: Crestwood Retail

Crestwood Retail generates $1,800 monthly but consumes 35 hours due to unmanaged revisions, disorganized Slack pings, and last-minute weekend requests. This reduces your effective hourly rate to $52, far below your target floor of $100. Furthermore, the team routinely shifts campaign briefs mid-sprint, creating emotional fatigue and delaying work for higher-paying accounts. The engagement shows severe scope creep with zero willingness to adopt formal project management software.

Immediate Action Plan
  1. Review the existing contract: Confirm the notice period for Crestwood Retail (typically 14 to 30 days) and check for pending deliverable clauses.
  2. Freeze extra revisions: Enforce the two-round revision limit on current open assets for Crestwood to protect time over the final billing cycle.
  3. Send standard termination notice: Issue a capacity-based notice on the 1st of next month, redirecting released hours toward expanding work with Apex SaaS.
Written by AI from this prompt. Your results will vary.

In ChatGPT, Claude, or Gemini, paste the prompt followed by a list of your clients, their monthly revenue, estimated hours spent, and any notes on communication issues. Ask for a transition timeline if you need to offboard someone immediately.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Freelancing & Consulting
Freelancing & Consulting

Hold your freelance rates when clients push back

Turn pricing objections into constructive scope conversations without discounting your rates. Use this when a potential client pushes back on your estimate or quote.