============================================================================== RETAINER CLIENT TRACKER & BUSINESS MANAGEMENT SYSTEM From SoloStack — solostack.madethis.app ============================================================================== This file is your complete retainer business management system. Use it as a reference, print it, or copy the tables into your spreadsheet of choice. CONTENTS: 1. Retainer Client Dashboard Template 2. Monthly Retainer Ritual Checklist 3. Retainer Health Scoring Grid 4. Capacity Calculator 5. Offboarding a Retainer Client Gracefully 6. Annual Retainer Review Template ============================================================================== SECTION 1: RETAINER CLIENT DASHBOARD ============================================================================== Copy this into Google Sheets, Notion, Airtable, or any spreadsheet tool. COLUMNS: ┌───────────────┬─────────────────┬─────────────┬──────────┬────────────┬────────────┬────────────┬─────────┐ │ Client Name │ Service/Scope │ Monthly $ │ Hrs Incl │ Overage $ │ Start Date │ Renewal │ Status │ ├───────────────┼─────────────────┼─────────────┼──────────┼────────────┼────────────┼────────────┼─────────┤ │ [CLIENT NAME] │ [SERVICE DESC] │ $[AMOUNT] │ [#] hrs │ $[$/hr] │ [MM/DD/YY] │ [MM/DD/YY] │ Active │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────┴─────────────────┴─────────────┴──────────┴────────────┴────────────┴────────────┴─────────┘ STATUS OPTIONS: Active / Paused / At Risk / Offboarding / Completed ──────────────────────────────────────────────── ADDITIONAL COLUMNS TO TRACK (OPTIONAL) ──────────────────────────────────────────────── → Avg hours used/month (vs. included hours) → Invoiced to date (cumulative) → Last check-in date → Notes / next action → Health score (1–5, from scoring grid below) → NPS / referral likelihood → Contract expiry / cancellation window opens ──────────────────────────────────────────────── EXAMPLE FILLED DASHBOARD ──────────────────────────────────────────────── Client: Brightfield Studio Service: Content strategy — 2 blog posts + 8 LinkedIn posts/month Monthly rate: $2,000 Hours included: N/A (deliverables-based) Overage rate: $150/hr Start date: Feb 1, 2026 Renewal: Every 3 months (next: May 1, 2026) Status: Active Health score: 4/5 Notes: Rate increase conversation needed at May renewal. Client mentioned potential referral — follow up in April. ============================================================================== SECTION 2: MONTHLY RETAINER RITUAL CHECKLIST ============================================================================== Run this ritual every month, every client. It's what prevents retainers from going stale and ending without warning. ──────────────────────────────────────────────── PRE-MONTH PLANNING (Week before month starts) ──────────────────────────────────────────────── □ Review last month's work — what got done, what didn't, what was scope □ Send brief written confirmation of next month's priorities: "Here's what I'm planning to work on in [MONTH]: [BULLET LIST]. Any changes before we kick off? Happy to jump on a quick call if helpful." □ Confirm any time-sensitive deliverables or dates □ Block time in your calendar for this client's work □ Check hours/deliverable tracking — are you on pace to use what they're paying for? □ Note any questions or context you need before starting □ Invoice sent (if invoiced at start of month) ──────────────────────────────────────────────── MID-MONTH CHECK-IN (Around the 15th) ──────────────────────────────────────────────── □ Send a brief written update (3–5 sentences, no fluff): "Quick mid-month update: [WHAT'S DONE], [WHAT'S IN PROGRESS], [WHAT'S UP NEXT]. No blockers — on track for month-end delivery." □ Flag any scope questions or emerging needs: "One thing I'm noticing: [OBSERVATION]. Is this worth addressing this month or should I note it for next month's planning?" □ Check if client has any urgent requests not yet mentioned □ Note any overage risk and flag proactively if approaching limit: "Heads up: we're at [X] hours with ~[Y] remaining. I want to flag this before we get into overage territory — happy to prioritize if needed." ──────────────────────────────────────────────── END-OF-MONTH DELIVERY + REVIEW (Last 3 days of month) ──────────────────────────────────────────────── □ Deliver all agreed work with a summary message: "All [MONTH] deliverables delivered! Here's what we completed: [BULLET LIST WITH LINKS OR ATTACHMENTS]" □ Include a brief results recap where possible: "Early numbers on the [DELIVERABLE]: [METRIC IF AVAILABLE]. More to follow as [TIMEFRAME]." □ Ask one forward-looking question: "Anything from this month you'd like to build on or adjust heading into [NEXT MONTH]?" □ Log hours used this month (compare to included hours) □ Invoice sent (if invoiced at end of month) □ Update dashboard status and notes □ Score client health (see Section 3) ============================================================================== SECTION 3: RETAINER HEALTH SCORING GRID ============================================================================== Rate each indicator 1–5. Add scores for a total out of 25. Do this at month end for every active retainer client. ──────────────────────────────────────────────── THE 5 HEALTH INDICATORS ──────────────────────────────────────────────── INDICATOR 1: ENGAGEMENT Does the client respond, participate, and stay involved? 1 = Unresponsive, weeks between replies, ghosted on deliverables 2 = Slow and minimal — hard to get briefings or approvals 3 = Adequate — gets back to me eventually, asks reasonable questions 4 = Good — responsive, engaged, gives clear feedback 5 = Excellent — proactively shares context, treats this like a partnership INDICATOR 2: SCOPE RESPECT Does the client understand and respect the retainer scope? 1 = Constantly asks for work outside scope; treats retainer as "all you can eat" 2 = Regularly pushes scope edges; needs reminders 3 = Mostly in scope; occasional asks handled well 4 = Respects scope naturally; asks before adding work 5 = Perfect scope discipline; proactive about flagging new needs INDICATOR 3: PAYMENT RELIABILITY Does the client pay on time without chasing? 1 = Consistently late; requires multiple follow-ups; payment uncertain 2 = Usually late; one follow-up needed most months 3 = Sometimes late but pays when reminded 4 = Generally on time with occasional delays 5 = Always on time, often in advance INDICATOR 4: REFERRAL POTENTIAL How likely is this client to refer new clients? 1 = Would not refer; relationship is purely transactional 2 = Unlikely to refer; limited network or low enthusiasm 3 = Might refer if directly asked 4 = Has mentioned referrals; positive about the work publicly 5 = Active referral source; has already sent warm introductions INDICATOR 5: GROWTH POTENTIAL Is this relationship likely to grow over time? 1 = Stagnant or shrinking; budget under pressure; could end soon 2 = Stable but no growth likely; limited budget ceiling 3 = Stable, some potential to expand scope at renewal 4 = Growing business; likely to need more over time 5 = High-growth client; retainer likely to expand significantly ──────────────────────────────────────────────── SCORE INTERPRETATION ──────────────────────────────────────────────── 21–25: THRIVING — Protect and nurture this relationship. Consider a proactive scope expansion conversation. 16–20: HEALTHY — Good relationship with room for improvement. Note which indicator scored lowest and address it. 11–15: WATCH LIST — Something is off. Identify the lowest indicator, address it directly, and set a 60-day improvement timeline. 6–10: AT RISK — This retainer is likely to end without intervention. Have a direct conversation about whether it's working. 1–5: OFFBOARDING — Begin graceful offboarding process (see Section 5). Start building replacement capacity in your pipeline. ============================================================================== SECTION 4: CAPACITY CALCULATOR ============================================================================== How many retainer clients can you realistically manage without burning out? ──────────────────────────────────────────────── STEP 1: YOUR AVAILABLE HOURS ──────────────────────────────────────────────── Working hours per week: _____ hours Working weeks per month (typically 4): _____ weeks Total available hours per month: _____ hours Subtract non-client time: - Admin, invoicing, email: _____ hours/month - Business development (finding new clients): _____ hours/month - Learning, professional development: _____ hours/month - Buffer (sick days, unexpected): _____ hours/month TOTAL NON-CLIENT HOURS: _____ hours/month AVAILABLE CLIENT HOURS = Total - Non-client: _____ hours/month ──────────────────────────────────────────────── STEP 2: HOURS PER RETAINER CLIENT ──────────────────────────────────────────────── Estimate honest hours per client per month: - Direct work (writing, designing, developing, etc.): _____ hrs - Communication (calls, emails, Slack): _____ hrs - Planning and briefing: _____ hrs - Admin (invoicing, tracking): _____ hrs TOTAL HOURS PER CLIENT: _____ hours/month ──────────────────────────────────────────────── STEP 3: MAX RETAINER CLIENTS ──────────────────────────────────────────────── MAX RETAINER CLIENTS = Available client hours ÷ Hours per client Example: 120 available hours ÷ 25 hours per client = 4.8 → MAX = 4 clients Your calculation: _____ ÷ _____ = _____ → MAX RETAINER CLIENTS: _____ ──────────────────────────────────────────────── STEP 4: REVENUE AT CAPACITY ──────────────────────────────────────────────── Max clients × Monthly rate per client = Maximum retainer revenue PRICE POINT EXAMPLES (fill in your own): 3 clients × $1,000/mo = $3,000/mo ($36,000/yr) 3 clients × $2,000/mo = $6,000/mo ($72,000/yr) 3 clients × $3,000/mo = $9,000/mo ($108,000/yr) 4 clients × $2,500/mo = $10,000/mo ($120,000/yr) 5 clients × $2,000/mo = $10,000/mo ($120,000/yr) Your number: _____ clients × $_____ /mo = $_____ /mo ($_____ /yr) ──────────────────────────────────────────────── IMPORTANT NOTE: THE QUALITY CEILING ──────────────────────────────────────────────── Your theoretical max is not your target. Aim for 70–80% of capacity to maintain quality, absorb overages, and have room for project work. Your target: _____ retainer clients at capacity 70% target: _____ retainer clients for sustainable operation ============================================================================== SECTION 5: OFFBOARDING A RETAINER CLIENT GRACEFULLY ============================================================================== Retainers end. How they end determines whether you get a referral or a bad taste in the industry. Offboard gracefully every time. ──────────────────────────────────────────────── 3-STEP OFFBOARDING PROCESS ──────────────────────────────────────────────── STEP 1: THE CONVERSATION When you or the client initiates the end, address it directly and quickly. Don't let it linger — ambiguity is worse than clarity. If the client is ending it: "I appreciate you letting me know. Let's make sure the handoff is as smooth as possible. I'm happy to [wrap up current work / document what I've built / brief a replacement] — just let me know what would be most useful." If you're ending it: "I've been giving this some thought, and I think this is a natural point to wind things down. I want to give you as much notice as possible — [NOTICE PERIOD]. I'll make sure everything is in order for whoever continues this work." STEP 2: THE DELIVERY SPRINT In the final 2–4 weeks, deliver: → All outstanding work completed or handed off clearly → A deliverables log (what was built, where it lives, how to use it) → Access credentials, files, and documentation transferred → A brief summary of work-in-progress and recommended next steps → Any recommendations for continuing the work (tools, approaches, successor) STEP 3: THE FINAL RECAP EMAIL Send this within 48 hours of the last day of the retainer. ──────────────────────────────────────────────── WORD-FOR-WORD FINAL RECAP EMAIL ──────────────────────────────────────────────── Subject: Wrapping up our retainer — summary + final handoff Hi [NAME], With [MONTH] wrapping up, I wanted to close things out properly. It's been a genuine pleasure working with [COMPANY]. Here's a quick summary of what we accomplished together: WHAT WE BUILT: → [MAJOR DELIVERABLE / OUTCOME 1] → [MAJOR DELIVERABLE / OUTCOME 2] → [MAJOR DELIVERABLE / OUTCOME 3] → [ANY RESULTS OR METRICS IF AVAILABLE] HANDOFF NOTES: → All files are in [LOCATION — Google Drive/Dropbox/etc.]: [LINK] → [ANY SPECIFIC NOTES ABOUT ONGOING WORK, TOOLS, OR PROCESSES] → [RECOMMENDED NEXT STEPS FOR WHOEVER CONTINUES THE WORK] I've transferred [LIST ANY ACCOUNTS/ACCESS/CREDENTIALS]. It's been great getting to know the [COMPANY] business — you're building something worth paying attention to. If our paths cross again in the future, I'd be glad to reconnect. If you ever know someone who could use [WHAT YOU DO], I'd welcome the introduction. And if there's anything I can do to make the transition easier, just say the word. Warmly, [YOUR NAME] ──────────────────────────────────────────────── AFTER OFFBOARDING ──────────────────────────────────────────────── → Send a check-in email 3–6 months later (no ask — just genuine interest) → Connect on LinkedIn if not already → Add to your quarterly touchpoint list → Mark as "Warm" in your contact tracker Former retainer clients are your highest-probability referral sources. The relationship doesn't end — it changes form. ============================================================================== SECTION 6: ANNUAL RETAINER REVIEW TEMPLATE ============================================================================== Do this once a year for every active retainer client. Use it to: → Articulate the value you've delivered (makes renewals and rate increases easier) → Identify what's working and what to improve → Set the foundation for Year 2 ──────────────────────────────────────────────── ANNUAL REVIEW TEMPLATE ──────────────────────────────────────────────── CLIENT: _______________________________________________ REVIEW PERIOD: _________________ to _________________ ─── WHAT WE DELIVERED ──────────────────────────────── Total deliverables/outputs this year: ___________________________________________________ Key milestones or wins: ___________________________________________________ Results and metrics where measurable: ___________________________________________________ Hours delivered (if hours-based): _____ vs. included: _____ ─── WHAT WORKED ────────────────────────────────────── What types of work produced the best results? ___________________________________________________ What communication rhythms worked best? ___________________________________________________ What surprised us in a good way? ___________________________________________________ ─── WHAT TO IMPROVE ────────────────────────────────── What types of work were underutilized or less impactful? ___________________________________________________ Where did scope or communication break down? ___________________________________________________ What would I do differently in Year 2? ___________________________________________________ ─── LOOKING AHEAD ──────────────────────────────────── What are the client's biggest goals for next year? ___________________________________________________ How should the retainer scope evolve to support those goals? ___________________________________________________ Is a rate adjustment warranted? By how much? ___________________________________________________ ─── HEALTH SCORE (Annual) ──────────────────────────── Engagement: ___ / 5 Scope respect: ___ / 5 Payment reliability: ___ / 5 Referral potential: ___ / 5 Growth potential: ___ / 5 TOTAL: ___ / 25 ─── RENEWAL DECISION ───────────────────────────────── □ Renew as-is □ Renew with rate increase: new rate = $___________/month □ Renew with scope change: ________________________ □ Offboard — see Section 5 ============================================================================== MORE RESOURCES AT SOLOSTACK.MADETHIS.APP/RESOURCES ==============================================================================