Step 03 The Plan — Profit Blueprint, May 2026

Implementation Plan

The week-by-week roadmap for turning audit findings into operating control: ten priorities, named owners, a spreadsheet kill order, and the recoverable impact behind each move.

Based on staff interviews across every department, 5 financial reports, and a 5-day onsite audit (May 7–13, 2026)

Present this plan as slides → PDF version

The Numbers

12 months ended March 31, 2026. Every number below comes from your P&L, your case management system, or your staff’s own words.

$7.78M
Total Revenue (+35% YoY)
3,109
Clients Hired
1,963
Cases Filed
1,146
Hired but Never Filed (36.9%)
$2.48M
Revenue Sitting in Pipeline
25+
Spreadsheet Control Risks Identified
14
Reporting Sources to Connect
$850K–$1.57M
Recoverable Annual Impact

How the Blueprint Is Organized

The software is not the strategy. The software enables reporting, queue ownership, required fields, and accountability. The Blueprint is organized around the business lanes Geller must control every week.

Business LaneOperating QuestionReporting NeededSoftware RoleSpreadsheet Rule
Revenue InAre leads becoming consults, shows, hires, and files?Lead → set → show → hire → file by source and owner.CRM stages, booking, call data, attribution dashboard.Retire manual conversion sheets once dashboard matches trusted totals.
Case FiledWhich hired clients are stuck before filing?Hired-not-filed aging, missing docs, signing readiness, paralegal owner.Document collection, intake fields, checklist stages, filing reports.Allowed only as temporary audit/export; not source of truth.
Money CollectedWhere is cash stuck or failing?Bounces, ACH failures, refunds, chargebacks, old balances, recovery owner.Payment exception queue, finance dashboard, task automation.Replace billing tabs with exception queues and owner-level recovery reporting.
Client Issues ResolvedWhich clients need action and who owns it?Open escalations, response age, communication queue, issue category.Client service queue, SLA timers, unified messaging/case notes.Client service spreadsheets become the build spec, then get retired.
Court / 341 ReadinessAre post-filing obligations ready before deadlines?341 dates, trustee docs, 2nd courses, reschedules, concluded vs continued.Calendar, notice parsing, reminders, trustee checklist automation.Keep only court-required exports; operational tracking moves to calendar/workflow.
Management DecisionsWhat number should leadership act on this week?Executive scorecard, trend lines, blockers, owner list, monthly financial overlay.Zoho dashboards plus Iron Noodle reporting bridge for cross-system truth.Analysis spreadsheets are fine; recurring operating spreadsheets are the risk.
Answer to the spreadsheet question: spreadsheets are not automatically bad. They are a problem when they become the source of truth, the workflow, or the only report leadership trusts. They are acceptable as temporary analysis, imports/exports, and validation tools when a system-owned workflow has the final answer.

Deployment Roadmap

Aligned with David Minckiewicz (Detroit Software Solutions, Zoho Engineer) — May 18, 2026.

Week-by-week execution plan. GetDocs.ai deploys first — document collection is the #1 bottleneck across every department. All other actions sequence from there.

W1

Week 1 — GetDocs.ai Deployment

START HERE IRT

Every department named document collection as their #1 pain. Best Case’s doc collection module is broken — Robert Geller confirmed it “doesn’t calculate the numbers right, doesn’t upload correctly.” Maria Herrera’s 341 team spends 2+ hours per session manually reviewing, compressing, converting, and organizing client documents. 1,146 clients hired but never filed — many stalled on document submission. This is the single largest revenue leak.

DayDeliverableDetailImpact
Day 1–2GetDocs.ai configured for Geller BK case typesCh7 + Ch13 document checklists built from Selene Gonzalez’s current filing requirements. Mapped to case stages: pre-filing docs (pay stubs, bank statements, tax returns, credit counseling cert) and post-filing docs (2nd course cert, trustee requests). Spanish language enabled from Day 1 — Fer confirmed many clients are not tech-savvy; bilingual reduces phone volume.Replaces broken Best Case module
Day 2–3Auto-compression + format conversion on uploadClient uploads a photo of a bank statement → GetDocs auto-converts to PDF, compresses to under 5MB, names file by document type. Eliminates Maria’s team manually processing every document for every case. Currently 200 cases/month, 4 staff — 35% of their 23 daily tasks are doc-related.8 of 23 daily 341 tasks eliminated
Day 3–4Automated client reminders activatedSMS + email follow-up sequences for outstanding documents. Configurable cadence (Day 3, Day 7, Day 14 after request). Replaces Fer’s team sending daily manual reminders “through Practice Panther.” Replaces the cycle of: notice → checklist → wait → call → wait → follow up → call again.Daily manual reminder routine eliminated
Day 4–5Array credit report integration liveAutomated credit pulls at case creation. Current spend: $143,647/yr at ~$73/case across ~1,963 filed cases. Array integration: $8–$10/case. Credit data auto-populates into case record — no manual entry, no separate login, no per-pull cost shock.$120,000+/yr savings, Day 1
Day 5Missing document dashboard deployedReal-time view: which clients owe what documents, how long they’ve been outstanding, escalation status. Replaces spreadsheet-based tracking used by 341 team, intake team, and paralegals. Selene, Fer, and Angie all maintained separate versions of this list.3 redundant tracking spreadsheets killed
Day 5341 group email: 341@robertgellerlaw.comCourt notices (PACER, email from clerk) route directly to 341 department. Staff added/removed as needed. Eliminates: “Only attorneys get the actual notices… they might miss one or two” (Fer). This was the #1 bottleneck Fer identified — she and Roberto aligned on this fix during the May 18 interview.Attorney forwarding bottleneck killed

Week 1 Financial Impact

Credit report savings (annualized)$120,000+/yr
341 staff time recovered (8 of 23 tasks × 4 staff)~30–40% of department capacity freed
Paralegal doc-chasing reduction (9 paralegals × 30–40% time)3–4 FTE redeployed to casework
Pipeline unblock beginsClients receive auto-reminders for first time
W2

Week 2 — Contract Automation + 341 Workflow

HIGH Dave + IRT
DayDeliverableDetailOwner
Day 8–9Zoho Sign replaces Dropbox Sign + Hello SignDave configures 3 BK contract templates (Initial Retainer, Pre-Petition, Post-Petition) with field mapping from Zoho CRM deal record. One-button populate → approval chain → client e-signs → executed doc auto-saves to case file. Replaces Angie Morales’s manual fill (2–5 min/client × 3 agreements). Already in Geller’s Zoho license — no new cost. Dave confirmed this is a “high-priority easy win.”Dave
Day 9–10Auto-folder creation on hireZoho workflow triggers SharePoint folder (Last, First naming convention) + Best Case profile at deal stage change to “Hired.” Currently: Angie creates manually (2–3 min), Selene creates separately (3–5 min). GetDocs collects documents before folder exists — prevents “ghost folders” for clients who never complete intake.Dave + IRT
Day 10–11Automated daily 341 remindersSMS/email triggered from Zoho calendar data — all clients with 341 hearings tomorrow get auto-reminder at 9 AM. Currently Fer’s team sends these “manually as a text through Practice Panther” every single day. At 200 cases/month, that’s 8–10 reminders daily, handwritten.IRT
Day 11–12Trustee checklist auto-generationTemplate pre-populated from case data: client name, case number, chapter, filing date, trustee assignment, required documents. Currently hand-built per client by 341 staff. At 200 cases/month = 200 checklists built from scratch.IRT
Day 12–14GetDocs auto-population from intake dataClient info captured at consult flows into GetDocs document checklist. No copy-paste between CRM and doc collection tool. Case type determines which documents are required — conditional logic matches intake form branching.IRT

Week 2 Financial Impact

Contract fill time eliminated (2–5 min × 3 docs × 3,109 hires/yr)103–259 hrs/yr recovered
Folder creation + PP profile time eliminated (5–8 min × 3,109)259–414 hrs/yr recovered
Total manual onboarding per client: 12–21 min → under 2 min620–1,087 hrs/yr freed
W3–4

Weeks 3–4 — Intake Rebuild + Scheduling + Spreadsheet Kill (Batch 1)

HIGH Dave + IRT + Upwork
WhenDeliverableDetailOwner
Week 3Zoho Forms intake — BK versionReplaces 2019 PDF intake sheet. Conditional if/then logic: form expands based on case type (Ch7 vs Ch13), employment type, marital status, property ownership. Auto-populates from consult data captured by phone team. Editable fee field. Calendar color-coding for appointment types. Ana Guerrero reviews and approves UX before staff rollout. Dave builds logic; Upwork ($12/hr) handles template labor per Roberto’s recommendation.Dave + Upwork
Week 3Zoho Bookings — round-robin schedulingReplaces current widget that allows staff to manually override calendars (cherry-picking problem — agents select preferred attorney calendars). Zoho Bookings enforces available-slot booking with round-robin assignment to consultants/attorneys. Dave confirmed Zoho Bookings can handle this “if the team adjusts to available-slot booking.” Anna Barajas “enthusiastically received” round-robin during onsite.Dave
Week 3Four Eyes overlay — KILLPhone sales team already in Zoho. Four Eyes was a “nightmare to build because the scope kept changing” (Dave). It lacks auto-dialing, relies on manual clicks, breaks when staff switch between versions. All functionality (priming calls, scripts, appointment scheduling, call outcome forms) moves to Zoho-native. Both versions killed. Calendar sync with Office 365 stays — it’s already a Zoho bridge, not a Four Eyes feature. Savings: ~$8K/yr.Dave
Week 3–4Spreadsheet kill — Valeria Beltrán’s 10 client service spreadsheetsPP incidents, discharge notifications, attendance, coaching, call performance, escalated clients, CTM faxes, FYF text categorization, and more. These are the most detailed functional requirements Dave will ever get — she already defined what the system needs to do. Migrate to Zoho Desk + dashboards. Valeria built the spec; Dave builds the system.Dave
Week 42nd course tracking automationCurrently 4 tasks on Fer’s daily list: file 2nd courses, put in SharePoint, update spreadsheet, check/request from delinquent clients. Zoho workflow handles all 4: auto-track completion status, auto-remind clients who haven’t completed, auto-file certificate to case record, auto-update report. 4 daily tasks become 0.IRT + Dave
Week 4AI Voice — after-hours + overflow24/7 phone coverage targeting 95%+ answer rate (current: 79–80% after dropping from 6 to 4 phone staff). AI answers, qualifies, books into Zoho Bookings round-robin. Overflow during business hours when all 4 staff are on calls. After-hours handles the calls that currently go to voicemail — every missed call at $2,161 avg case value.IRT
W5–8

Weeks 5–8 — Spreadsheet Kill (Batch 2) + Reporting Bridge + Texting

SYSTEMATIC Dave + IRT
WhenDeliverableDetailOwner
Week 5Helene’s 7-tab billing Google Doc → Zoho Finance + LawPay syncHelene runs weekly marketing meetings pulling PCLC data (leads/sets/shows/hires by source) manually from multiple systems since 2016. That doc becomes a Zoho Analytics dashboard fed by CRM pipeline data.Dave
Week 5–6Daily retains/cancellations + bounce tracking spreadsheetsAnna Barajas’s daily retains + Angie Morales’s bounce tracking → Zoho CRM auto-reports and task auto-creation from LawPay webhook.Dave
Week 5–6IRT reporting bridge deployedExternal cloud database pulling CTM + Zoho + invoicing via API connections. Consolidates data across systems into a single reporting layer. Handles court-specific data, trustee data (NDC), and cross-system matching that Zoho can’t do natively. Bridge persists even after full Zoho migration for data Zoho won’t ever handle. Dave confirmed value: “especially with the stuff with good API documentation which Zoho is not bad.”IRT
Week 5–6Call intelligence & escalation layer (on the reporting bridge)Reads CTM call data continuously, scores each call for urgency and sentiment, and auto-flags escalation language (“supervisor,” “manager,” “demand,” “speak to someone else”) plus angry or hostile call summaries. Surfaces a single prioritized action queue and pushes hot leads into the CRM — replacing Valeria B’s manual “escalated clients” spreadsheet with system-enforced SLA timers so escalations can no longer sit 24–48 hours unseen.IRT
Week 6Kill Fix Your Funnel (~$5K/yr) + Connect texting (~$6K/yr)Move all texting to Zoho-native or CRM integration. One inbox, one thread per client, one notification system. Eliminates Valeria B’s daily manual text categorization from FYF. Maria’s 341 reminders already automated in Week 2.Dave + IRT
Week 6–7Filing tracker + rescheduling + post-filing spreadsheetsSelene Gonzalez’s filing tracker + Betty Jo’s 6+ post-filing spreadsheets → Zoho pipeline stage reports + workflow triggers + custom module.Dave
Week 7–8Signing report + 341 scheduling spreadsheets → Zoho calendar + auto-notice parsingFer’s signing report and PACER-based 341 scheduling move to Zoho. Court notices parsed from 341@ group email (live since Week 1) into calendar entries automatically. Replaces: “We used to be able to download a monthly report from PACER… but we’re not able to do that anymore” (Fer).Dave + IRT
W8–12

Weeks 8–12 — Keep Sunset + Remaining Spreadsheets + Pipeline Recovery

CLEANUP Dave + IRT
WhenDeliverableDetailOwner
Week 8Kill Infusionsoft (Keep) + GraphlyDave already built sync bridges feeding data between Zoho and Keep. Once Zoho dashboards are live (Weeks 5–8), Keep has no remaining function. Graphly accuracy already questioned by staff — Zoho-native dashboards replace it. Savings: ~$12K/yr (Keep) + ~$4K/yr (Graphly). “There is little long-term reason to retain Keep” (Dave + Roberto, aligned May 18).Dave
Week 8–9Conversion reporting + marketing tracking docChris Garcia’s conversion reports + Helene’s marketing tracking doc (maintained since 2016) → Zoho PCLC dashboard + Zoho analytics from CRM pipeline. Single source of truth for leads → sets → shows → hires by source.Dave
Week 9–10Ana Guerrero’s sticky notes + Word doc → Zoho assignment rulesPersonal Word document and sticky notes for paralegal/attorney assignment by client surname and case type. If Ana is out, nobody knows the system. Moves to Zoho assignment rules — surname + case type logic automated. Single point of failure eliminated.Dave
Week 10–11Signing checklist + retain form → Zoho Blueprint transitionsParalegals currently coordinate via Slack for signing prep steps. Move to Zoho Blueprint (stage transition checklists) + Zoho forms. Each stage change requires completion of previous checklist items.Dave
Week 10+Pipeline recovery campaign — 1,146 unfiled casesGetDocs now working (Week 1). Intake form rebuilt (Week 3). AI Voice deployed (Week 4). Now run outbound campaign: AI Voice calls aged pipeline, live-transfers on connect, GetDocs re-engagement link in follow-up SMS. Even 10% recovery (115 filings) = $248K. 20% = $495K. Requires all upstream systems functional first.IRT
P3

Phase 3 (Post Week 12) — Practice Panther + AR Billing

FUTURE Dave + IRT + Geller Mgmt

Practice Panther handles case management and accounts receivable billing. This is the most complex migration — it touches attorney workflows, billing, trust accounting, and court filing integrations. Addressed after the CRM layer (Zoho) is stable and the team has adapted to the new intake/signature/doc collection stack. Roberto and Dave aligned on this sequencing: “those steps involve more complex processes” (May 18). The 80/20 rule applies — Phases 1–2 capture 80%+ of the operational savings. Phase 3 is about completing the architecture.

Action Items — Owner Assignments

FROM MAY 18 CALL
OwnerActionWeekStatus
IRTDeploy GetDocs.ai — BK document collection, auto-compression, AI classification, automated reminders, Array credit integration, missing doc dashboard1FIRST
IRTDeploy 341@robertgellerlaw.com group email — court notices direct to department1PENDING
DaveIntegrate Zoho Sign — 3 BK contract templates, field mapping from CRM deal record, approval chains, auto-save executed docs2PENDING
DaveBuild Zoho Forms intake — conditional if/then logic by case type, chapter, employment. Ana Guerrero approves UX. Upwork ($12/hr) handles template labor.3PENDING
DaveConfigure Zoho Bookings — round-robin scheduling, prevent calendar override/cherry-picking3PENDING
DaveKill Four Eyes (both versions) — move all phone team functionality to Zoho-native3PENDING
DaveAudit 341 call list — contact Anna Guerrero to verify why specific call list is failing in Four Eyes2–3PENDING
DaveMigrate Valeria Beltrán’s 10 spreadsheets to Zoho Desk + dashboards (Batch 1)3–4PENDING
IRTDeploy AI Voice — after-hours + overflow, target 95%+ answer rate4PENDING
IRTBuild reporting bridge — external cloud DB pulling CTM + Zoho + invoicing via API5–6PENDING
RobertoDeliver Blueprint Plan to Geller management teamBy June 1IN PROGRESS
RobertoGuide outsourcing setup — session with Dave on hiring/managing Upwork freelancers for template + form building2–3PENDING
RobertoAudit Keep campaigns — secure access to follow-up side, evaluate all items for migration or kill4–5PENDING
RobertoDocument 341 workflow — interview Maria Guerrero, transcribe process into project documentationDONE
Roberto + DaveRecurring check-in meetings — review progress, identify blockers. Adjusted for Roberto’s travel schedule (WI and NY client sites).OngoingSCHEDULED

Change Management & Adoption Strategy

CRITICAL TO SUCCESS

Why This Matters (from the May 18 call)

“Building rapport with the management team and staff to ensure smooth adoption of new systems. Using the ‘easy button’ concept to identify what would make staff work easier — reduce frustration for new hires, improve overall retention in an organization approaching 100 employees.”
— Roberto Stanley, May 18
“Four Eyes often fails when staff switch between versions” — current system instability is driving staff frustration and workarounds.
— David Minckiewicz, May 18
“Part of the reason they have spreadsheets is they don’t trust the data that’s displayed.” — Staff built shadow systems because the primary systems are unreliable.
— Roberto Stanley, May 18
  • Lead with document collection: GetDocs Week 1. Every department named it as pain point #1. When staff see documents auto-compress, auto-classify, and auto-remind on Day 1, they trust the rest of the rollout.
  • Kill the spreadsheets by replacing them, not banning them. Each spreadsheet dies only when its Zoho replacement is live and verified. Staff switch when the new system is provably better — not when they’re told to.
  • Outsource the grind: Template creation and form building to Upwork ($12/hr). Dave focuses on Zoho configuration and logic. Roberto facilitates a session with Dave on managing outsourced resources.
  • GetDocs before SharePoint folders: Collect documents first, create folders after. Prevents accumulation of “ghost folders” for clients who never complete intake (Roberto + Dave, aligned May 18).
  • No big bang. Each week delivers one working system. Staff never face “learn everything new at once.” By Week 4, the team has been using GetDocs for a month before the next wave of changes arrives.
#1

Document Collection & Pipeline Recovery

CRITICAL $615K–$1.17M/yr recoverable Weeks 1–4 IRT + Selene + Fer

Every department named document collection as the #1 pain. It is the bottleneck between hire and filing, the primary cause of your 36.9% pipeline drop-off, and the single largest revenue leak in the firm.

What Your Team Said

“Best Case doc collection is not working — doesn’t calculate the numbers right, doesn’t upload correctly.”
— Robert Geller, Principal (Discovery Call)
“She’s college-educated, collecting documents — she could do a lot more than that.”
— Brooke Geller, referring to paralegal time lost to document chasing (May 13)
“Trying to get the documents from the clients is hard… that doesn’t depend on us all, right? Because we can’t make them send them on time.”
— Maria Herrera, 341 Dept Head (May 18)
More from your team (6 more)
“Checking and processing documents is a major pain point — sometimes spending two hours reviewing files and sorting through numerous PDFs.”
— Maria Herrera, describing daily document review sessions (May 18)
“We have too many manual things that can be forgotten — not that people forget so much, but you get too busy and then you’re supposed to be doing something else.”
— Maria Herrera, on why documents get missed (May 18)
“They love their triple redundant systems… the reason they like that is because they can’t trust what they have.”
— David Minckiewicz, Zoho Engineer, on why staff keep spreadsheets (May 18)
“The tool will automatically compress and fix large files — which Fer agrees will significantly reduce the time spent manually processing large images or documents before sending them to trustees.”
— Maria Herrera, reacting to GetDocs demo (May 18)
Sarah Broom (Ch13 Post-Filing): “Very positive on GetDocs, agreed to hearing calendaring automation.”
— Onsite interview, May 13
Selene Gonzalez (Paralegal Manager): Confirmed Best Case cloud can’t export cases and doc collection module is broken. Receptive to GetDocs during live demo.
— Onsite interview, May 11

The Math

Clients hired (12 months)3,109
Cases filed1,963
Hired but never filed1,146 (36.9%)
Avg case value (BK blended)$2,161
Revenue sitting in pipeline$2,476,406
Recovery target (20–40%)$495,000 – $990,000

Paralegal Time Lost to Doc Chasing

Paralegals on staff9
Estimated % of time on doc collection30–40%
FTE equivalent on document chasing3–4 FTE
Annual labor cost of doc chasing$150,000 – $200,000
Recoverable with automation (60–70%)$90,000 – $140,000

341 Department Impact (Maria Herrera’s Team)

Monthly cases filed~200 (up from 72 in May 2024)
341 staff4 people
Daily tasks (documented)29 (23 daily + 7 management)
Doc-related tasks on the list8 of 23 (35%)
Time spent reviewing/sorting docs per session2+ hours
Manual compression/conversionEvery document, every case

Credit Reporting Cost Reduction

Current annual credit report spend$143,647
Current cost per case (~1,963 filed)~$73/case
Array integration cost per case$8–$10/case
Immediate annual savings$120,000+

The Plan

  • Week 1: Deploy GetDocs.ai for new BK cases — automated document portal replaces broken Best Case doc collection. Client uploads via secure link (no passwords). AI auto-classifies documents by type.
  • Week 1: Enable automated reminders — SMS, email, and voice follow-up for outstanding documents. Eliminates 341 team’s daily manual text reminders via Practice Panther.
  • Week 2: Auto-compression and format conversion on upload — eliminates Maria’s team’s manual file processing before trustee submission.
  • Week 2: Array credit report integration — automated credit pulls at case creation. Cost drops from $73/case to $8–$10/case. Savings begin Day 1.
  • Week 3: Missing document dashboard — real-time view of which clients owe what. Replaces spreadsheet-based tracking across 341, intake, and legal teams.
  • Week 3: Auto-population from intake data into document checklist — client info flows from CRM to doc requirements without copy-paste.
  • Week 4: Spanish language support enabled — client-facing portal translates automatically. (Fer confirmed many clients are not tech-savvy; bilingual interface reduces phone calls.)
  • Week 4: Filing deadline countdown timers — tracks estimated filing dates, auto-escalates stalled cases. Replaces manual “signing report” spreadsheet tracking.

Total Priority #1 Impact

Pipeline recovery (20–40% of $2.48M)$495,000 – $990,000
Paralegal time redeployment$90,000 – $140,000
Credit report savings$120,000+
341 dept efficiency gain (est.)$30,000 – $50,000
Annual recoverable impact$735,000 – $1,300,000
#2

Contract & Signature Automation

HIGH 620–1,087 hrs/yr recovered Weeks 2–4 Dave + IRT

What Your Team Said

Angie Morales manually fills Dropbox Sign contracts: 2–5 minutes per client, 3 agreements per BK case (Initial Retainer, Pre-Petition, Post-Petition).
— Onsite interview, May 8
“Migrating to Zoho Sign is a high-priority easy win — the firm already has access through their licensing agreement, which would allow for direct document population from the CRM.”
— David Minckiewicz, Zoho Engineer (May 18)
Manual per-client onboarding: contract fill (2–5 min) + PP profile (3–5 min) + SharePoint folder (2–3 min) + Best Case folder (3–5 min) + calendar appointment (2–3 min) = 12–21 minutes of copy-paste per new client.
— Composite from Angie Morales, Ana Guerrero, Selene Gonzalez interviews

The Math

Hires per year3,109
Manual entry per hire12–21 minutes
Total annual hours on copy-paste620 – 1,087 hours
Contract fill alone (2–5 min × 3,109)103 – 259 hours/yr
FTE equivalent on data entry~0.5 FTE

The Plan

  • Dropbox Sign → Zoho Sign: Already in Geller’s Zoho license. One-button populate from deal record. Approval chains. Signed docs auto-save to case file.
  • Auto-folder creation: Zoho workflow triggers SharePoint folder (last, first naming) + Best Case profile at hire stage. Zero copy-paste.
  • Auto-calendar: Paralegal assignment + appointment auto-scheduled from deal record.
  • Dave configures Zoho Sign (confirmed May 18 he will do this). IRT provides templates and field mapping.
#3

Spreadsheet Elimination

HIGH $150K–$250K risk + efficiency Weeks 3–12 Dave + IRT + Valeria B

What Your Team Said

“You guys have 80,000 spreadsheets and that’s a single point of failure for everybody.”
— Roberto Stanley to David Minckiewicz (May 18)
“The feedback I received from the team — part of the reason they have spreadsheets is they don’t trust the data that’s displayed.”
— Roberto Stanley (May 18)
“One gal in the office is pulling native reports from three systems and then compiling that and creating their own spreadsheet.”
— Roberto Stanley, describing the spreadsheet origin story (May 18)
Ana Guerrero (Intake Team Lead) keeps a personal Word document and sticky notes for paralegal/attorney assignment lookups by client surname and case type. If Ana is out, nobody knows the system.
— Onsite interview, May 13
Valeria Beltrán (Client Service) maintains 10+ spreadsheets covering PP incidents, discharge notifications, attendance, coaching, call performance, escalated clients, CTM faxes, FYF text categorization, and more.
— Onsite interview, May 13

23 Identified Spreadsheets — Migration Order

PhaseSpreadsheetsOwnerZoho Replacement
Week 3–510 client service spreadsheetsValeria BeltránZoho Desk + dashboards (she built the spec)
Week 4–67-tab billing Google DocHelene GellerZoho Finance + LawPay sync
Week 5–7Daily retains + cancellationsAnna BarajasZoho CRM auto-reports
Week 5–7Bounce trackingAngie MoralesZoho task auto-creation from LawPay webhook
Week 6–8Filing tracker + reschedulingSelene GonzalezZoho pipeline stage reports
Week 6–86+ post-filing spreadsheetsBetty JoZoho workflow triggers + custom module
Week 7–9Signing report + 341 schedulingMaria HerreraZoho calendar + auto-notice parsing
Week 8–10Conversion reportingChris GarciaZoho PCLC dashboard
Week 8–10Marketing tracking doc (since 2016)HeleneZoho analytics from CRM pipeline
Week 9–11Sticky notes + Word doc lookupAna GuerreroZoho assignment rules (surname + case type)
Week 10–12Signing checklist + retain formParalegals / SlackZoho Blueprint transitions + forms
Key insight: Valeria Beltrán’s 10 spreadsheets are the most detailed functional requirements Dave will ever get. She already defined what the system needs to do. Migrate her spreadsheets first — they become the Zoho build spec.
#4

Intake Form Rebuild

HIGH ~200 hrs/yr on copy-paste Weeks 4–6 Dave + Ana Guerrero

What Your Team Said

Ana Guerrero requested a CRM-native form with drop-downs and radio buttons to replace the 2019 PDF. Missing fields include employment type. 15-minute intake limit too short to capture everything.
— Onsite interview, May 13
“Transitioning to Zoho Forms with conditional if/then logic would allow forms to expand based on user answers, significantly reducing the 200 hours per year currently lost to manual copy-pasting for approximately 3,100 clients.”
— David Minckiewicz + Roberto Stanley, aligned May 18
Valeria Escobar built an alternative intake form that Ana rejected for bad UX. The right form hasn’t been built yet.
— Ana Guerrero, May 13

The Plan

  • Build Zoho Forms with conditional logic (if/then branching by case type, chapter, employment)
  • Auto-populate from consult data (consultant fills during call → flows to intake)
  • Editable fee field, calendar color-coding for appointment types
  • Dave builds in Zoho; Upwork resources ($12/hr) handle template labor
  • Ana Guerrero reviews and approves UX before rollout
#5

341 Department Automation

CRITICAL 4 staff / 200 cases — unsustainable Weeks 2–8 IRT + Fer + Dave

What Your Team Said

“We used to be able to download a monthly report from Pacer with all the 341 meetings for the month. But we’re not able to do that anymore.”
— Maria Herrera, May 18 — lost their safety net for tracking hearings
“Only attorneys get the actual notices… It’s pretty hard to get the notices sometimes because every single notice, since the attorneys forward them to us, they might miss one or two.”
— Maria Herrera, May 18 — the #1 341 bottleneck
“It should be like maybe a group email like 341, right?” — “Yeah. Exactly.”
— Roberto Stanley + Maria Herrera, aligned on the fix (May 18)
More from your team (3 more)
“We’ve had situations where the meetings were either erased or moved and then trying to find the space a day before the actual meeting — that was a problem.”
— Maria Herrera, on calendar management chaos (May 18)
Volume has nearly tripled: ~72 cases/month filed in May 2024 → ~200 cases/month now. Only 4 staff.
— Maria Herrera, May 18
“There wasn’t actually an actual protocol to how to follow up… the team has been coming up with all of this process.”
— Maria Herrera, describing how the 341 team built their own process from scratch (May 18)

Task Automation Analysis (29 Documented Tasks)

Total daily tasks23
Management tasks7
Fully automatable15+ tasks
Doc-related (compression, review, convert, redact, send)8 tasks (35%)
Reminder/follow-up (manual daily)4 tasks
Spreadsheet maintenance (signing report, 2nd courses)3 tasks

The Plan

  • Week 2: Create 341@robertgellerlaw.com group email — court notices go directly to the department. Remove dependency on attorney forwarding. Add/remove staff as needed.
  • Week 2: Automated daily 341 reminders — SMS/email triggered from calendar data. Kills the daily manual text routine.
  • Week 3: GetDocs handles doc compression, format conversion, and organization on upload — eliminates 8 of 23 daily tasks.
  • Week 4: Auto-generate trustee checklists from case data — pre-populated, not hand-built per client.
  • Week 5: 2nd course tracking automation — Zoho workflow tracks completion, auto-reminds, auto-updates. Kills 4 spreadsheet tasks.
  • Week 6: Concluded 341 auto-notifications — stage change triggers client message. Zero manual effort.
  • Week 8: Pre-341 scheduling automation — auto-schedule 1 week before hearing date, pull missing doc list from GetDocs dashboard.
#6

Texting Consolidation

HIGH ~$11K/yr software + hours of manual sorting Weeks 4–6 Dave + IRT

What Your Team Said

Practice Panther texting has character limits, no read receipts, and no notifications. Connect texting is a workaround. Fix Your Funnel requires Valeria B to manually categorize every text.
— Danielle Austin + Valeria Beltrán, onsite interviews
Maria Herrera sends daily 341 reminders “manually as a text through Practice Panther.”
— Maria Herrera, May 18

The Plan

  • Kill Fix Your Funnel (~$5K/yr) — manual text categorization ends
  • Kill Connect texting (~$6K/yr) — redundant once CRM texting is live
  • Move all texting to Zoho-native or CRM integration — one inbox, one thread per client, one notification system
  • 341 reminders move from manual PP texts to automated CRM triggers
#7

Phone & Lead Recovery

HIGH $100K–$200K in recovered leads Weeks 1–4 IRT + Anna Barajas

What Your Team Said

Call answer rate dropped from 92% to 79–80% after going from 6 to 4 phone staff. Cherry-picking problem: agents select preferred attorney calendars.
— Anna Barajas + Valeria Beltrán, onsite interviews
Anna Barajas “enthusiastically received” round-robin scheduling during onsite.
— May 8
“Can Zoho handle round-robin assignment to consultants/attorneys with calendar availability checks?” — Dave confirmed Zoho Bookings can handle it if the team adjusts to available-slot booking.
— David Minckiewicz, May 18

The Math

Current answer rate79–80%
Inbound calls/week (est.)~200
Missed calls/week~42
Potential hires in missed (20%)~8/week
At $2,161 avg case value~$18K/week lost
Annualized lost revenue potential~$936K/yr

The Plan

  • Week 1: Deploy AI Voice for after-hours + overflow — target 95%+ answer rate
  • Week 2: Round-robin scheduling in Zoho Bookings — eliminates cherry-picking
  • Week 3: CTM fax auto-forward to email/CRM — eliminates Valeria B’s daily manual login
  • Week 4: Replace broken Four Eyes with Zoho call analytics dashboards
  • Phase 2: AI Voice outbound for aged pipeline (1,146 unfiled cases)
#8

Software Sunset Schedule

MEDIUM $35K–$45K/yr in eliminated subscriptions Rolling, Weeks 1–12 Dave + IRT

What Your Team Said

“Four Eyes was a nightmare to build because the scope kept changing. I definitely don’t need it.”
— David Minckiewicz, May 18
“There is little long-term reason to retain Keep, noting that automated emails and dashboard features like Graphly can be replicated within Zoho.”
— David Minckiewicz + Roberto Stanley, aligned May 18
SystemKill DateDependencyAnnual Savings
Four Eyes (both versions)Week 1None — already broken~$8K
Fix Your FunnelWeek 6CRM texting live~$5K
Connect (texting)Week 6CRM texting live~$6K
GraphlyDay 60With Keep sunset~$4K
Keep (Infusionsoft)Day 60Zoho migration complete~$12K
Google Docs (as database)RollingZoho dashboards replace each docRisk reduction
#9

Dashboard & Reporting

HIGH Replaces manual weekly compilation Weeks 2–10 IRT + Dave

What Your Team Said

“We’ve been building our own cloud reporting system that pulls from all sources… pulling the data in via API into an external database and then matching you know either phone number or name or email.”
— Roberto Stanley, describing the IRT reporting bridge approach (May 18)
Dave confirmed the approach has value: “especially with the stuff with good API documentation which Zoho is not bad.”
— David Minckiewicz, May 18
Helene runs a weekly marketing meeting pulling PCLC data (leads/sets/shows/hires by source) manually from multiple systems since 2016.
— Helene Geller, May 7

The Plan

  • Dave builds: Zoho-native dashboards for pipeline, PCLC, billing, and phone metrics
  • IRT builds: Cloud reporting bridge pulling CTM + Zoho + invoicing via API — consolidates data sources Dave can’t natively connect
  • Call intelligence & escalation: The bridge scores CTM calls for urgency and sentiment, auto-detects escalation language, and surfaces a prioritized action queue — replacing Valeria B’s manual “escalated clients” tracker with enforced SLA timers
  • Bridge handles: Court-specific data, trustee data (NDC), and cross-system matching that Zoho can’t do natively
  • Result: One dashboard replaces Helene’s weekly manual PCLC compilation, Chris’s conversion reports, Selene’s filing tracker, and Valeria B’s call performance spreadsheet
#10

Pipeline Recovery Campaign

HIGH 1,146 unfiled cases — $2.48M at stake Week 10+ IRT + Anna Barajas

Once GetDocs is live and the intake process is fixed, run an outbound campaign targeting the 1,146 clients who were hired but never filed. AI Voice handles initial contact, live-transfers on connect. Even 10% recovery = $247K.

Recovery Scenarios

Unfiled clients1,146
10% recovery (115 filings)$248,515
20% recovery (229 filings)$495,069
40% recovery (458 filings)$989,738

Execution & Governance

Who owns what, which system answers which question, and the operating rhythm that keeps the rollout honest.

The first 90 days are not a software project. They are a control project. Spreadsheets are only a problem when they replace accountable queues, dashboards, required fields, or owner-level reporting. Each phase moves one recurring spreadsheet into a system-owned workflow or a governed reporting layer.

Roles & Responsibilities

RolePrimary OwnerResponsible ForDecision / Output
Executive SponsorRobert / Helene GellerApproves operating changes, priorities, vendor decisions, and adoption expectations.Final signoff on phase priorities and internal enforcement.
Blueprint LeadBlueprint teamKeeps the plan tied to business impact, resolves sequencing, and leads weekly accountability.Weekly executive progress brief and blocker decisions.
Zoho Build OwnerDavidBuilds Zoho-native forms, workflows, dashboards, queues, fields, and migration items.Configured working system, not just migration notes.
Operations / Staff AdoptionGeller department leadsValidates workflow reality, tests new queues, confirms fields, and enforces staff usage.Department acceptance and staff rollout.
Billing / Finance OwnerHelene + billing teamDefines payment exceptions, bounce rules, recovery reports, refund/chargeback handling.Billing control center and recovery queue.
Client Service OwnerValeria B. / client service leadershipConverts client service spreadsheets into issue queues, escalation rules, and dashboards.Client service control board.
Filing / 341 OwnerFer / filing and 341 leadershipValidates filing, 341, trustee, 2nd-course, and missing-document workflows.Calendar, reminder, and checklist workflow acceptance.
Reporting Layer OwnerImplementation team + DavidConnects data that Zoho can own with data that needs a separate reporting bridge.One leadership dashboard with source-of-truth rules.

Source-of-Truth Rules

QuestionSystem of RecordReporting LayerSpreadsheet Policy
Who is the lead and what happened?CRM / booking / phone dataRevenue funnel dashboardNo manual weekly conversion spreadsheet after dashboard is trusted.
Why has a hired client not filed?Case stage + document checklistHired-not-filed aging dashboardExports allowed for audit; daily tracking sheet retired.
Where is money stuck?Payment/billing system + exception queueFinance control centerBilling tabs replaced by owner/status exception queue.
Who owns the client issue?Client service queueEscalation/SLA dashboardClient service spreadsheets become specs, not operations.
What should leadership act on?Trusted source systemsExecutive scorecard + reporting bridgeSpreadsheet analysis is allowed; recurring manual compilation is not.

30-60-90 Day Goals

Goal WindowBusiness GoalMeasurable OutcomesOwner Group
Day 0–30Stop the highest-friction handoffs.Document dashboard live; 341 notice routing live; contract/signature flow started; first client-service trackers migrated.Implementation team + David + department leads
Day 31–60Kill the highest-risk spreadsheets.Billing exception queue live; retain/cancellation/bounce tracking automated; filing/post-filing reports live; first leadership dashboard active.David + Helene + Anna + Angie + Selene + Betty Jo
Day 61–90Run from dashboards, queues, and rules.Conversion and marketing dashboards live; assignment rules live; retain/checklist transitions live; pipeline recovery campaign launched.Geller leadership + Implementation team + David

Weekly Governance

Monday: Build Review

What shipped last week? What is blocked? Which spreadsheet or workflow is next?

Wednesday: Staff Validation

Department lead tests the workflow. Required fields and exceptions are corrected. Training gaps are logged.

Friday: Executive Scorecard

Progress against 30-60-90 goals. Open decisions for Robert and Helene. Next week’s owner list locked.

Retirement rule: no spreadsheet is retired until its replacement has an owner, required fields, reporting output, and staff acceptance.
Delivery + payment trigger: delivery of this plan, together with the Blueprint findings and recommendations, completes the Phase 1 findings-and-plan milestone. Per the accepted Phase 1 structure, the second $5,000 installment is due upon delivery.

Total Annual Impact

Pipeline recovery (20–40%)$495,000 – $990,000
Credit reporting savings$120,000+
Software elimination$35,000 – $45,000
Labor efficiency (redeployment)$150,000 – $250,000
Improved phone answer rate$50,000 – $150,000
Total Recoverable Impact$850,000 – $1,565,000

How the Bottom Line Changes

Net operating income today, plus each recovery lane at its midpoint scenario

$0.0M$0.5M$1.0M$1.5M$2.0M$2.5M$3.0M$1.63MCurrent NOI+$742KPipeline+$200KLabor+$120KCredit+$100KPhone+$40KSoftware$2.84MProjected NOI$3.19M$2.48Mhonest band

Midpoints of the published ranges, shown for scale — the honest band is $2.48M–$3.19M projected NOI ($850K conservative to $1.57M aggressive recovery). No outcome is guaranteed; every lane’s math is sourced above.

Path to $10M: Current revenue $7.78M + pipeline recovery + improved conversion + faster filings + natural growth = $10M within 24 months. The constraint isn’t leads or attorneys. It’s the space between the hire and the filing.
01 · 02 · 03 · 04