⚙️ Firebase not configured yet. The app is running in demo mode with local storage. See SETUP.md for cloud setup steps.
Law Office of Gilda McDowell

Firm Command

Law Office of Gilda McDowell
IMMIGRATION ATTORNEY ABOGADA DE INMIGRACION GILDA MCDOWELL LAW OFFICE
Command Dashboard

Firm Command

— VIEWER
Our magic statementWe help Spanish-speaking immigrant families secure their status with trusted guidance, clear steps, and peace of mind.
Gilda McDowell
Firm Command
build 2026-11-13k2 · HOTFIX case log + Español + docs clock restart
build 07-24 · graphs
▾My day
RHYTHM
TODAY
WAITING ROOM
PHONE
▾Intake
INTAKE
+ Lead Entry
▾Sales
DRAGONS
UNDERWRITING
GAS CALLS
TEAM 100
▾Production
PRODUCTION
DEADLINES
PROD MEETING
CASES
▾Money
CLIENT PAYMENTS
LETTERS
CASH FLOW
VAULT
SKU'S
▾Scores and growth
KPIs
SCORECARD
CALL SCORES
MY REVIEW
TRAINING
CLIENT REVIEWS
▾Numbers
THE NUMBER
MONTH
YEAR
GRAPHS
DAN'S VIEW
▾Team
PEOPLE
EMPLOYEES
FRIDAY MEETING
TURNOVER
ROLES AT FIRM
ORG CHART
C-SUITE SEATS
▾Leadership
COO
FATHOM
BRAIN
BRAIN DUMP
FIRM BLUEPRINT
RISK REGISTER
INSURANCE
▾Admin and reference
RESOURCES
DATA QUALITY
CONTENT CALENDAR
SETUP

Rhythm

Your day, your week, your month, your quarter. Verified items read the dashboard; self-reported items are your word. Start my day walks you through it in order. Close the day before you leave.

Loading…

Daily Pulse

Pick a period below. Switch to Compare to see two periods side by side.

How we work · our core values
01
Truth First
02
Client Compassion
03
Ownership, No Excuses
04
Excellence & Structure
05
Team Player
—
Side-by-Side Comparison

Period A

Period B

Variance — A vs B
MetricPeriod APeriod BVariance% Change
Weekly 12 · Daily 7 + the 5 below
8 · Avg Case Value MTD
$0
premium pricing health
9 · Cash % at Signing
0%
closer discipline
10 · Top Lost Reason
—
action coverage —
11 · Repeat + Referral % Hires
0%
premium book health
12 · Hire → USCIS (avg days)
—
production velocity
💵 Cost Per Hired Case (CAC) — MTD
Firm Cash Collected MTD
$0
Today: $0
Total Revenue (incl. USCIS)
$0
USCIS pass-through: $0
Goal Pacing
0%
— vs expected pace
Cases Hired MTD
0
Today: 0
📅 Sched · Main
0
Non-gas pipeline
📞 Sched · Gas
0
Total —
Projected Hired (Month End)
—
Based on pace
Avg Case Value (MTD)
$0
Per case sold
Cash % Collected
0%
Down / Sold
Year over Year — Cases & Revenue
Cash Collected — Math Breakdown
Today's Activity —

Live snapshot of what's happening today. Refreshes when leads or AR entries update. Use this throughout the day to know where you stand.

Contacts
0
Total inbound today
Leads (Talked)
0
Actually spoke
Qualified
0
Have a remedy
DC Completed
0
Discovery done
Consults Booked
0
Booked today
Consults Held
0
Held today
Cases Hired
0
Signed today
📅 Scheduled to Start
0
Future starts · not in revenue
Cash Collected
$0
Manual AR today
Yesterday's Activity —

Final snapshot of what closed yesterday. Use this in the morning huddle: what did we do, what fell through, what carries into today.

Contacts
0
Total inbound
Leads (Talked)
0
Actually spoke
Qualified
0
Have a remedy
DC Completed
0
Discovery done
Consults Booked
0
Booked yesterday
Consults Held
0
Held yesterday
Cases Hired
0
Signed yesterday
Cash Collected
$0
Manual AR yesterday
Follow-Up Watch DO NOT LOSE THESE

Two leakage points the firm cannot afford to lose: (1) qualified leads with a Discovery Call done but no consult appointment booked, and (2) consults that were booked after a DC but never marked Held. Tracked by intake date for the lead, and by consult date for the appointment. The Last Month column is your rollover reminder, do not let those carry forward forgotten.

Row A · Qualified + DC done, no appointment booked
Today
—
Intake today, still owe an appt
This Week
—
Intake Mon to Sun (CT)
MTD
—
Intake this month
Last Month
—
Rollover, follow up this week
Row B · DC done + consult booked, never marked Held
Today
—
Consult today, no Held set
This Week
—
Consult Mon to Sun (CT)
MTD
—
Consults this month
Last Month
—
Rollover, close these out
Show names · drill into the lists
Repeat & Referral Watch PREMIUM CLOSE RATIO

Repeat clients and referrals close at a meaningfully higher rate than cold sources, so they get priority follow-up. Counts are by intake date for the lead. Pending consults from these two sources should never sit untouched.

Repeat · MTD Leads
—
New intake this month
Referral · MTD Leads
—
New intake this month
Pending Consults
—
Repeat+Referral, DC done, not Held
Hired MTD (R+R)
—
Signed this month
Critical Alerts ADMIN ONLY

Patterns auto-detected from your live data. Refreshes when leads update. Visible only to you.

Alert Evidence Owner / Action Severity
Funnel — Selected Period
Export window
★ New Standard (Jun 2026) Unpaid consults discontinued. Conversion gauge: Qualified → Booked Paid Consult < 50% Below Min 50% At Min 55% Good 60%+ Great
Coaching Priorities (Auto-Generated) ADMIN ONLY

Detected weekly from rep performance vs targets. Use this to plan your 1:1s and Monday huddle. Sorted by impact.

Priority Person Gap (Current vs Target) Coaching Action Owner Severity
Lead Source Impact ADMIN ONLY did the spend change move the needle?

Every lead source across five windows. The current month is pace-matched against the same days of the two prior months, so a partial month is never judged against a full one. Spend is prorated for partial windows.

Measure
Source & SKU Economics

One view: which sources produce which cases, and what the money looks like. Top — sources × SKUs with counts and revenue. Below — the economics of each SKU with its sources. No client names; the CAC detail is collapsed at the bottom.

Export window through
SKU Economics — same period
Case Type (SKU) Lead Sources Sold Count Case Value (Retail $) Sold Price ($) Collected / Down Pmt ($) Discount % Down Pmt %
📈 Conversion & CAC detail — quality %, spend, cost per acquisition (click to open)
Lead Source Leads
intake this period
Bad / No Remedy Quality % Hired
closed this period
Hired / Leads % Revenue
SKU sold price
Spent
ad / marketing (editable)
Cost / Acquisition
spend ÷ hired
Status

Note: "Leads" counts new intake this period. "Hired" counts cases that signed this period (hire date in range) regardless of when the lead first came in — so a Feb lead that closes in April credits April's WhatsApp row. Decision rule: Quality > 80% with Hired/Leads > 10% = SCALE. Quality 60-80% = OPTIMIZE targeting. Quality < 60% = TIGHTEN or KILL.

Speed Metrics
Avg Days — Lead to Consult Held
—
From lead date to consult held
Avg Days — Lead to Sold
—
From lead date to hired date

Content Calendar

52 weeks, September 7 2026 to August 30 2027, one post a week. This is a read-only view. The source of truth is Marketing Brain/Content-Calendar-v1.0.md and the working tracker is Gilda-Content-Calendar-2026-2027.xlsx. Everything below was verified against the live site anonymously on September 7, 2026. Do not quote a status from here without checking the date it was built.

Posts on the calendar
52
Page drafted
48
Attorney signed
33
Drafted, NOT signed
15
No page at all
4
Weeks with zero broken links
19 / 52
The finding that governs everything else

Run the calendar exactly as written, one post a week in order, and 39 of the 52 weeks ship with a dead internal link. Only 6 of the 55 distinct link targets on the whole calendar are live today, and five of those six are pillar pages that already existed.

If we…Weeks that break
Publish only as the calendar runs, in order39 of 52
Publish every attorney-signed page now, ignoring its calendar slot29 of 52
Publish every page that exists on disk now3 of 52

The cause is a framing error. We have been treating the calendar as a publishing schedule. It is a promotion schedule. A cluster page does not need to wait for its blog slot to exist on the website, and every sibling that links to it needs it live. Full reasoning: PLAN-Clear-To-Post-Every-Week-2026-09-07-v1.0.md.

The next six weeks
WeekPublishLangPostRowSignedStill blocked by
W1Sep 7ENThe Public Charge Rule Changes September 18, 2026. Your Filing Date Is What Decides Which Rule AA-C03September 7, 2026—
W2Sep 14ESCarga Pública: El 18 de Septiembre de 2026 Cambia la Regla, y la Fecha Que Cuenta Es la de Su EnA-C15September 7, 2026A-P02
W3Sep 21ENThe I-130 and the I-485 Are Two Different Cases. Here Is Why Filing One Does Not Start the OtherI130-C10August 29, 2026—
W4Sep 28ESLos Beneficios Públicos Que NO Cuentan en Su Caso de Residencia: La Lista Que Casi Nadie Le ExplA-C16August 28, 2026A-P02
W5Oct 5ENYou Have to Have Met in Person Within the Last Two Years. The Exceptions Are Narrower Than PeoplK-C05August 29, 2026—
W6Oct 12ESSalió de Detención y Le Dieron Papeles: Eso No Es Parole, y la Diferencia Decide Su CasoA-C25August 28, 2026A-C18, A-C26, A-P02
What has to happen, in order
#MoveOwnerWeeks it unblocks
1Publish every signed page on signature, not on its calendar dateDan and Muhammad10
2One checkbox to Gilda on the twin rule, plus the A-C17 and A-C18 pairGildamost of the remaining 26
3Decide A-P02 and the four other Spanish pillarsDan, then Gilda19
4Write six pages, four of which already have their research doneContent6

Three of the four are decisions, not work. Only move 4 is writing.

Stop items · these cannot publish
BlockerWhat it blocksOwner
A-P02, the Spanish adjustment pillar, does not exist. Its URL 301s to the live /es/ajuste-de-estatus-i-485/10 weeks, the largest single blocker on the calendarDan
15 calendar pages are drafted but not attorney signed. Fourteen of the fifteen are SpanishThose weeks cannot publishGilda
Six pages do not exist. W10 N-A01, W13 needs a sitemap row, W40 K-C08, W43 A-A01, plus A-C22 and N-C054 calendar weeks and 2 link targetsContent
52 Blog Video Companions cannot be produced. Module 5.3 specs 3 to 5 minutes; HeyGen hard-caps at 60 secondsEvery video companion, including the three already writtenDan
FOIA pillars must be live before October 12, 2026. That date appears in no document outside the video systemA quarter of the video calendarDan
F-C02 and F-C07 are on a client-safety hold pending the ICE and FOIA escalationDeliberately absent from all 52Gilda
All 52 weeks
WkPublishLangPostMatterRowSignedBlocked by
W109/07/26ENThe Public Charge Rule Changes September 18, 2026. Your Filing Date Is What Decides Which Rule Applies to You.Adjustment of StatusA-C03September 7, 2026—
W209/14/26ESCarga Pública: El 18 de Septiembre de 2026 Cambia la Regla, y la Fecha Que Cuenta Es la de Su EnvíoAdjustment of StatusA-C15September 7, 2026A-P02
W309/21/26ENThe I-130 and the I-485 Are Two Different Cases. Here Is Why Filing One Does Not Start the Other.Family Petitions I-130I130-C10August 29, 2026—
W409/28/26ESLos Beneficios Públicos Que NO Cuentan en Su Caso de Residencia: La Lista Que Casi Nadie Le ExplicaAdjustment of StatusA-C16August 28, 2026A-P02
W510/05/26ENYou Have to Have Met in Person Within the Last Two Years. The Exceptions Are Narrower Than People Think.Fiance VisaK-C05August 29, 2026—
W610/12/26ESSalió de Detención y Le Dieron Papeles: Eso No Es Parole, y la Diferencia Decide Su CasoAdjustment of StatusA-C25August 28, 2026A-C18, A-C26, A-P02
W710/19/26ENYour I-130 Was Approved. That Is Not a Green Card, and Here Is What Actually Happens Next.Family Petitions I-130I130-C01August 29, 2026—
W810/26/26ESLo Pasaron Sin Preguntarle Nada en la Garita: Por Qué Eso Puede Contar Como Entrada LegalAdjustment of StatusA-C18NOT SIGNEDA-C26, A-P02
W911/02/26ENYour Fiancé's Children Can Come Too. There Is a One-Year Clock on It That Families Miss Every Year.Fiance VisaK-C12August 29, 2026—
W1011/09/26ENWhy You Have to Become a Citizen Before You Can Petition Your Mother, and How Long Each Step Really TakesNaturalizationN-A01NO PAGE—
W1111/16/26ES¿Puede un Residente Pedir a Sus Padres? La Respuesta Honesta Es No, y Existe un Camino Que Sí FuncionaFamily Petitions I-130I130-C18NOT SIGNEDN-C11
W1211/23/26ESTener TPS No Es Lo Mismo Que Haber Entrado Legalmente: El Error Que Puede Costarle el CasoAdjustment of StatusA-C24August 28, 2026A-C18, A-C26, A-P02
W1311/30/26ENPetitioning Your Brother From Mexico: The Honest Wait Time, and What to Do With Those YearsFamily Petitions I-130NEWNO PAGE—
W1412/07/26ES¿Puede Arreglar Aquí o Tiene Que Salir del País? La Pregunta Que Decide Todo Su CasoAdjustment of StatusA-C29NOT SIGNED601A-C29, A-C27, A-P02, CP-A01
W1512/14/26ESLo Pararon en la Frontera Hace Veinte Años: Por Qué Todavía Puede Aparecer en Su ExpedienteFOIA and Record ReviewF-C20NOT SIGNEDF-C06, F-C17, F-C19
W1612/21/26ESQué Preguntan de Verdad en la Entrevista de Residencia, Pregunta por PreguntaAdjustment of StatusA-C30NOT SIGNEDA-C27, A-C28, A-P02, I130-C20
W1712/28/26ESEl Tiempo Sin Estatus No Empieza a Contar Como Usted Cree: Salir del País Es Lo Que Activa el CastigoI-601A Provisional Waiver601A-C32August 29, 2026601A-P02
W1801/04/27ENWhat Happens If You Do Not Marry Within 90 Days of the Fiancé Visa, Explained Without the Scare StoriesFiance VisaK-C02August 29, 2026—
W1901/11/27ES¿Le Pueden Quitar la Residencia Si Pide la Ciudadanía? La Respuesta Honesta, Sin Alarmar y Sin EndulzarNaturalizationN-C28August 28, 2026N-C11, N-P02
W2001/18/27ENThe Fiancé Visa Has One Door: Why Someone Who Enters on It Cannot Marry a Different PersonFiance VisaK-C09August 29, 2026—
W2101/25/27ESLa 245(i) No Expiró: Si Presentaron Algo a Su Nombre Antes del 30 de Abril de 2001, Todavía Puede ServirleAdjustment of StatusA-C26NOT SIGNEDA-C18, A-P02
W2202/01/27ENWhat Actually Counts as Proof of a Real Marriage, and What the Officer Is Really WeighingFamily Petitions I-130I130-C07August 29, 2026—
W2302/08/27ESQuién Puede Arreglar Sus Papeles Dentro del País Sin Salir, y Quién No: La Regla General ExplicadaAdjustment of StatusA-C27NOT SIGNEDA-C18, A-C26, A-P02
W2402/15/27ENFiancé Visa or Marriage Green Card? Choosing by Speed Is the Mistake That Costs Couples the Most.Fiance VisaK-C01August 29, 2026—
W2502/22/27ENWaved Through at the Border Without a Single Question: Why That May Legally Count as Being AdmittedAdjustment of StatusA-C17NOT SIGNEDA-C18
W2603/01/27ENI-134 or I-864? The Fiancé Visa Uses Both, at Two Different Stages, and This Gets Misstated Constantly.Fiance VisaK-C11August 29, 2026—
W2703/08/27ENReleased From Immigration Detention Is Not the Same as Parole. Filing as If It Were Can End the Case.Adjustment of StatusA-C20August 28, 2026A-C17, A-C22
W2803/15/27ESSi Falleció la Persona Que Lo Pidió, Su Caso Puede Seguir Vivo: Lo Que Dice la Ley y Casi Nadie ExplicaFamily Petitions I-130I130-C22August 29, 2026I130-C03, I130-P02
W2903/22/27ENSomething Was Filed for You Before April 30, 2001: Why That Paper May Still Be the Most Valuable Thing You OwnAdjustment of StatusA-C21August 29, 2026A-C17
W3003/29/27ENAfter the Fiancé Visa Comes a Conditional Green Card. The Trigger Is Not the Date Most Couples Think.Fiance VisaK-C13August 29, 2026—
W3104/05/27ENWhat “Extreme Hardship” Actually Means on a Waiver, and Why It Is Not a Measure of How Sad the Family IsI-601A Provisional Waiver601A-C09August 29, 2026—
W3204/12/27ESSi No Gana lo Suficiente para Patrocinar: Quién Puede Ser Patrocinador Conjunto y Cuándo Hay Que DecidirloAdjustment of StatusA-C28NOT SIGNEDA-C27, A-P02
W3304/19/27ESCómo Saber Si Tiene una Orden de Deportación, Paso por Paso, Sin Presentarse Ante NadieFOIA and Record ReviewF-C06NOT SIGNEDF-C07, F-C17
W3404/26/27ESCuánto Tarda de Verdad la Residencia por Matrimonio: Rangos Reales y de Qué Depende Cada EtapaFamily Petitions I-130I130-C23August 29, 2026A-C29, I130-C03, I130-C19, I130-P02
W3505/03/27ES¿Sus Hijos Ciudadanos Lo Pueden Arreglar con el Perdón I-601A? La Respuesta Es No, y Aquí Está Por QuéI-601A Provisional Waiver601A-C26August 28, 2026601A-C28, 601A-P02
W3605/10/27ENCan a Green Card Holder Petition Their Parents? No. Here Is the Two-Case Path That Does Work.Family Petitions I-130I130-C04August 29, 2026N-A01
W3705/17/27ENDoes TPS Count as a Legal Entry for a Green Card? The Answer Turns on Something Most Articles Get Wrong.Adjustment of StatusA-C19August 28, 2026A-C17
W3805/24/27ENThe Real Reason the Fiancé Petition Asks About Your Criminal History: A Law Called IMBRA That Nobody ExplainsFiance VisaK-C10August 29, 2026—
W3905/31/27ESCómo Saber Qué Presentaron a Su Nombre: Si Alguien Le Cobró por un Trámite, Su Expediente Lo DiceFOIA and Record ReviewF-C18NOT SIGNEDF-C06, F-C07, F-C17
W4006/07/27ENMarry Abroad or File a Fiancé Visa? The Tradeoff Is Not Speed, It Is What Happens After Arrival.Fiance VisaK-C08NO PAGE—
W4106/14/27ESQué Significa “Sufrimiento Extremo” en el Perdón Provisional: Es un Estándar Legal, No una Historia TristeI-601A Provisional Waiver601A-C27NOT SIGNED601A-C28, 601A-P02
W4206/21/27ESLa Regla de los 90 Días de la Visa de Prometido: Qué Pasa Si la Boda No Ocurre a TiempoFiance VisaK-C18August 29, 2026K-C15, K-P02
W4306/28/27ENYou Have DACA and You Married a U.S. Citizen. Whether That Opens a Green Card Comes Down to One Fact.Adjustment of StatusA-A01NO PAGE—
W4407/05/27ESCartas de Recomendación para la Ciudadanía: Lo Que USCIS Sí Toma en Cuenta, y Quién Debe EscribirlasNaturalizationN-C27NOT SIGNEDN-C11, N-P02
W4507/12/27ENHow Long a Marriage Green Card Actually Takes, Start to Finish, and the Three Things That Change the AnswerFamily Petitions I-130I130-C09August 29, 2026—
W4607/19/27ENHow to Find Out If You Have a Deportation Order, Step by Step, Without Walking Into an OfficeFOIA and Record ReviewF-C01August 29, 2026—
W4707/26/27ENPetitioning a Spouse as a Citizen Versus as a Green Card Holder: The Wait Is the Whole DifferenceFamily Petitions I-130I130-C06August 29, 2026—
W4808/02/27ENCan Your U.S. Citizen Children Qualify You for the I-601A Waiver? No, and Being Told Otherwise Costs Families Thousands.I-601A Provisional Waiver601A-C03August 28, 2026—
W4908/09/27ENWhat They Actually Ask a Married Couple at the Green Card Interview, and What the Officer Is Listening ForAdjustment of StatusA-C02August 29, 2026—
W5008/16/27ESQué Pruebas Piden para Demostrar Que un Matrimonio Es Real: La Lista y el Estándar Que de Verdad Se AplicaFamily Petitions I-130I130-C20NOT SIGNED—
W5108/23/27ESVisa de Prometido o Residencia por Matrimonio: Elegir por Rapidez Es el Error Más CaroFiance VisaK-C14NOT SIGNEDK-C15, K-P02
W5208/30/27ENCharacter Reference Letters and the USCIS Neighborhood Investigation: The One Part of Your Case You Can Still InfluenceNaturalizationN-C15August 29, 2026N-C05

Data Quality

Read this before you quote a number off this dashboard. Every item here is a known defect in the firm's own reporting, verified against the live data. None of them are bugs. They are denominator and tagging problems that the dashboard does not warn you about, and each one has already produced a wrong figure in a real document. Full register: DATA-INTEGRITY-REGISTER-v1.0.md.

D-1 · The denominator rule

The Case Type Funnel counts only leads carrying a SKU tag. It sees about half the business. These two views on this same dashboard disagree over the last 90 days, and they are supposed to.

Case Type Funnel
tagged only
Sold ACV table
all cases
Cases58117
Dollars$150,370$312,273
Blended ACV$2,592$2,669
Cases the funnel can see
50%
Dollars the funnel can see
48%

What it caused. The claim “FOIA is 43 percent of all cases sold” reached a strategy memo. FOIA is 25 of 58 tagged cases. Against all 117 cases sold it is roughly 21 percent of cases and 7 percent of dollars. The claim overstated it about 2x.

The rule. Never quote a share percentage from the funnel without naming the denominator. Write “of tagged cases” or “of all cases sold.” Never a bare “of all cases.”

Still valid: tagged-to-tagged comparisons across time, and per-SKU ACV, because dollars and cases come from the same tagged rows.

D-2 · The SKU field is free text, and it produced a false zero

The funnel reported I-601 A Waiver: 5 leads, 0 hired, $0. That number is wrong. Filtering the Lead Log on remedy containing “601” returns 9 records between June 12 and August 19, 2026, including three recorded hires: two at $9,500 and one I-601 at $4,500.

Why. SKU and remedy are free text carrying at least five spellings of one practice area: I-601 A Waiver, I-601A, I-601, I-601 + I-212, plus the funnel's own bucket. The funnel groups on exact string, so a practice area scatters and its hires never land in the row anyone reads.

Spellings of one practice area
5
Leads with no SKU at all
1,387

Do not build a plan, a scoreboard, or a spending decision on a single-SKU funnel number without opening the Lead Log behind it.

D-3 · History only reaches back about six months

On the Sold ACV table, Rolling 12 Months and Last 6 Months are identical: 162 cases, $486,923. The “rolling 12 month” Sold ACV of $3,006 is really a six-month figure. Any year-over-year framing built on that column is not year over year.

D-4 · Three revenue bases that do not reconcile

They were never meant to. The problem is that they get quoted interchangeably.

SourceFigureBasis
BTDNS package, July 2026$768,317 YTD thru JulyCollected
Path to $10M model, June 2026$502,905 thru MayContracted
This dashboard$430,657 all timeSold, tagged only

Pick one basis for any plan and state it on the document. Recommend collected, because that is what pays salaries and it is the basis the liquidity figure is measured against.

D-5 · Books integrity flags and possible duplicates

The banner at the top of this dashboard reports 207 books-integrity flags across Lead, Production and Payments, and 46 deletions on record. Nobody owns clearing them.

Suspected duplicates in the waiver records. Two rows dated 07/30/2026 carry different client initials but identical dragon, source, next-call date, hired date and $9,500 value. Either one case entered twice, or a petitioner and beneficiary entered as two records. Case counts in that SKU may be inflated. Not yet audited beyond this one pair.

The check before you quote a number
  1. Name the denominator. Tagged cases, or all cases sold?
  2. Check it against a second view on this dashboard. If the two disagree, say so rather than picking the friendlier one.
  3. If a SKU number looks extreme, open the Lead Log and read the records first.
  4. State the basis on any revenue figure: collected, contracted, or sold.
  5. Say the window. All time, 90 days, or current month. A four-day month is not a trend.
Fix queue
IDFixEffortOwner
F-1Convert SKU and remedy from free text to a controlled dropdown on the 32 accepted case typesSmallDan
F-2Back-fill the 1,387 untagged leads, or mark them explicitly untaggedMediumIntake
F-3Normalize the five existing spellings to one canonical label per practice areaSmallDan
F-4Add a denominator caption under the funnel table on this dashboardSmallDan
F-5Clear or assign the 207 books-integrity flagsMediumMarimar
F-6Audit the waiver records for duplicatesSmallKaren

F-1 and F-4 together are the highest-value pair. One stops new bad data, the other stops bad readings of the data already there.

No client names, phone numbers or email addresses appear anywhere in this tab. The Lead Log review behind D-2 and D-5 was conducted using initials only, per the firm's Client Privilege and Confidentiality SOP.

Deadlines — Calendario de Stickies

The office wall calendar, digitized. Add a deadline and it lands on its day in the right sticky color. RFE deadlines from the Case Log show up automatically in pink. Mark items done as they are handled — anything past due glows red.

Lead Entry

Log a new lead

Date, source, name, intake rep and qualified are the five that matter. Everything else can be filled in later as the lead moves.

New Lead
1IntakeWho called, what they need⌄
Source & timing
Who they are
Qualification
Consultation
2SalesConsult, outcome and money⌄
The consult
Outcome
Money
Follow-up
Recovery
3ProductionOnboarding and contract⌄
Onboarding
Contract
Sections 2 and 3 stay closed for a new lead — open them when the lead moves forward.

Intake

Your leads, your follow-ups, your consults, your numbers. One screen, nothing else on it. Switch to any teammate when you are covering for them.

Loading…

Dragons

Your consults, your chase, your QR calls, your numbers against goal. Same rule as intake: one screen, only your work, and any dragon can open any board to cover.

Loading…

The Number

Owner benefit first. The business exists to pay the owners the life the family deserves; everything else is math.

Loading…

Lead Log

All leads. Filter, search, edit, or delete. Stoplight colors update automatically.

Showing: All Time
INTAKE SALES PRODUCTION Actions
DateSourceIntakeNamePhonePhone 2Email Case #TalkedQualDCRemedyFPS Follow-upConsult TypeConsult DateIntake Notes HeldDragonHas RemedyHired DateLostObjectionNext Sales Call Case ValueSoldDown RecoveryRecovery OutcomeRecovery RevSales Notes Onboard DateOnboarded ByContractContract DateCase WorkerNotes

0 leads shown.

Cases

Every hired case with production tracking. Onboarding, contract status, case worker, and balance owed.

# Case # · Sold By Client Name Dates Source Onboarding Contract SKU 💰 Money Worker 🐉 Dragon QR Calls Notes
0 cases shown $0 total contract value $0 total down payments $0 total owed (AR)

Consults — Daily View

Pick a day to see who had a consult scheduled with a Discovery Call completed. Show / No Show status, remedy, and objections.

📅 Consult Calendar click to open
💰 Sales Calendar click to open
—
Total Consults Scheduled
—
Selected day
Shown
—
Held = Y
No Shows
—
Held = N
Show Rate
—
Industry std 70-85%
Client DC By Case Type Showed Dragon Outcome Follow-Up Action

Only leads with DC Completed = Y and Consult Date = selected day. Gas Call leads are excluded — they live in the GAS CALLS tab. DC By = the intake person who completed the discovery call. Scheduled to Start = client committed to start on a future date but hasn't paid yet. Counted separately from hires. Time now sits as a chip under the client's name rather than its own column. It still sorts the day top to bottom and is still editable right here — a chip reading SET TIME in amber is an appointment nobody has actually pinned down. Columns were grouped in Sep 2026 so the table fits a laptop without scrolling: Client carries the source pill and phone, Showed holds show status plus mode, Outcome holds hired plus start date, and Follow-Up holds objection plus manager follow-up and its due date. Every field is still here and still editable.

💰 Daily Sales — Day Review HIRED THIS DAY
Cases Sold
—
Hire date = selected day
Sold $
—
Contract value signed
Down Collected
—
Cash in the door
Cash % at Signing
—
Down ÷ Sold · 50-70% std
Client Source Dragon Case Type Sold $ Down $ Cash % Consult Date Days to Close Action

Every case hired on the selected day, including Gas Call closes — this is the firm's real daily number, so nothing is filtered out. Gas-call rows carry a badge. Days to Close = consult date to hire date; 0d means it closed in the room. Cash % is the down payment over the contract value — a big sold number with a thin cash percentage is a collections problem waiting to happen, and it shows up here before it shows up in A/R.

Monthly Pace

Pick a month or compare two months. Goals come from Goals & Setup.

—
Side-by-Side Pace Comparison

Month A

Month B

Variance — A vs B
MetricABVariance% Change
Pace Cards (At a Glance)
Pace by Category (Detail)
CategoryGoalExpected Pace (calendar days)MTD ActualVarianceDaily Run Rate NeededStatus
Daily Sales Tracker — Heatmap (People × Days)

Sales manager heatmap. Rows = Karen / Hector / Sergio / Marimar / Other / Firm Total. Columns = days of current month with weekly subtotals + MTD totals on the right. Cell color intensity = hires activity. Close % color: ≥60% elite · 50-60% on pace · <50% below

Karla — Gas Call Outreach OUTBOUND

Karla's outbound lead-gen tracker. 50 calls/day target · 5 cases/week goal (≈ 20 cases/month). ADDITIVE to firm 40-case target — these gas-call cases sit on top of Karen / Hector / Sergio's closing volume, not inside it. Pipeline KPIs auto-populate from any lead logged with source = Gas Call (90-day hire attribution). FPS hires shown separately from non-FPS so you can see the skill-vs-volume mix.

Daily Sales Tracker — Heatmap (Intake · DCs by Person × Days)

Intake heatmap. Rows = Karla / Sergio / Karen / Hector / Isaac / Marimar / ⚠ Missing Intake. Columns = days of selected month, plus weekly subtotals and MTD total on the right. Cell value = count of Discovery Calls (DC = Y) attributed to that intake person on that day (by lead intake date). The Missing row catches any DC done where the intake field is blank or not in the tracked list, so nothing falls through the cracks.

Daily Sales Tracker — Detail (Days × People)

Detailed daily breakdown. Rows = days of selected month. Each rep block shows the day's Held → Hires → Sold $ → Cash $. Weekly subtotals every Friday and an MTD total row at the bottom. Tied to the period selector at the top of TODAY, so it refreshes when you pick a different month.

Manual AR / Payment Plan Entries

Log walk-ins, cash payments, USCIS fees, or any AR collection that doesn't come through a tracked lead. Routes to the correct revenue bucket (Payment Plans, Consult Revenue) across the dashboard. Refunds subtract from cash. USCIS Fees are pass-through and do NOT count as firm revenue. Every authenticated team member can add, edit, save, and delete — there is no admin gate in the dashboard.

📥 Bulk Import / Reconcile from Master Ledger (paste CSV or text)

Paste your master ledger CSV (the firm's "Payment Log" spreadsheet) or upload the file. Tool parses every row, compares date+amount+client against existing AR cache, and tells you exactly which entries are missing. Then one click to bulk-create.

Expected columns (in order): Date, Type of Payment, Taken By, Name, Type (How), Date of Consult, Amount, USCIS Fees, Reason, Case#. Headers auto-skipped. Rows with BOTH Amount AND USCIS Fees create two AR entries.

or paste below ↓
🔧 Team can't edit or delete? Click here to deploy the correct Firestore Rules ADMIN

If your team gets "Permission denied" when editing or deleting AR entries, the Firestore Rules in your Firebase Console are out of date. Paste the rules below into Firebase Console → Firestore → Rules and click Publish. One-time setup.

rules_version = '2';
service cloud.firestore {
  match /databases/{database}/documents {
    function isAuthorized() {
      return request.auth != null
        && request.auth.token.email in [
          'daniloelleon@gmail.com',
          'gmcdowell@gildaimmigration.com',
          'legal2@gildaimmigration.com',
          'hector@gildaimmigration.com',
          's.martinez@gildaimmigration.com',
          'k.calderon@gildaimmigration.com',
          'm.espinoza@gildaimmigration.com',
          'isaac@gildaimmigration.com',
          'oscar@gildaimmigration.com',
          'legal@gildaimmigration.com',
          'gloria@gildaimmigration.com',
          'alejandro@gildaimmigration.com'
          // 'assistant2@gildaimmigration.com' — Roberto, terminated Sep 2026
        ];
    }
    function isAdmin() {
      return request.auth != null
        && request.auth.token.email in [
          'daniloelleon@gmail.com'
          // Add other admin emails here
        ];
    }

    match /leads/{leadId} {
      allow read: if isAuthorized();
      allow create, update: if isAuthorized();
      allow delete: if isAdmin();
    }
    match /goals/{monthId} {
      allow read: if isAuthorized();
      allow write: if isAdmin();
    }
    match /config/{configId} {
      allow read: if isAuthorized();
      allow write: if isAdmin();
    }
    match /marketingSpend/{monthId} {
      allow read, write: if isAdmin();
    }
    // CRITICAL: this block is what lets all team members edit and delete AR entries
    match /arEntries/{entryId} {
      allow read, create, update, delete: if isAuthorized();
    }
    match /annualGoals/{yearId} {
      allow read: if isAuthorized();
      allow write: if isAdmin();
    }
    // Historical month overrides (manual YTD entry for pre-Firestore months)
    match /historicalMonths/{monthId} {
      allow read: if isAuthorized();
      allow write: if isAdmin();
    }
    // Prior year totals (2024, 2025) for YoY comparison
    match /priorYearTotals/{yearId} {
      allow read: if isAuthorized();
      allow write: if isAdmin();
    }
    // Manual employee KPI values (admin-entered, visible to all)
    match /manualEmployeeKpis/{employeeId} {
      allow read: if isAuthorized();
      allow write: if isAdmin();
    }
    // Production case logs — Roberto / Erick / Oscar edit their own cases
    match /caseLogs/{caseId} {
      allow read, create, update, delete: if isAuthorized();
    }
    // Daily Production KPI log (auto + manual counts per worker per day)
    match /productionEntries/{dateId} {
      allow read, create, update, delete: if isAuthorized();
    }
    // Marketing spend per lead source per month (Lead Source Performance)
    match /sourceSpend/{monthId} {
      allow read, create, update, delete: if isAuthorized();
    }
    // Karla gas-call daily activity entries
    match /gasCallEntries/{dateId} {
      allow read, create, update, delete: if isAuthorized();
    }
    // Client deadline assignments per production worker
    match /productionAssignments/{employeeId} {
      allow read, create, update, delete: if isAuthorized();
    }
    // Client payment plans + audit trail
    match /clientPayments/{docId} {
      allow read, create, update, delete: if isAuthorized();
    }
    match /clientPaymentChanges/{changeId} {
      allow read, create, update, delete: if isAuthorized();
    }
    // Letter generation log (disengagement / termination / approval)
    match /letterLog/{entryId} {
      allow read, create, update, delete: if isAuthorized();
    }
    match /{document=**} {
      allow read, write: if false;
    }
  }
}

Test after publishing: Have a non-admin team member sign in and try editing an AR entry. If it still fails, double-check their email is listed under isAuthorized().

🧾 Individual Manual Entries click to open
DateTypeHowClient PaymentsClient / NotesEntry ByAmountActions

Default view shows every entry stacked top-to-bottom (newest first). Flip Compact view on if you want a sticky-header pane that caps height to 65vh.

SKU Cleanup ADMIN ONLY merge duplicate case types

Every distinct value ever typed into Remedy (SKU). Rows grouped in the same block are the same case type written different ways. Use Map all or the Roll up into dropdown to merge them. Lead records are never modified — mapping is applied when reports are read, so it affects every SKU report at once and can be undone at any time.

Case Type Funnel ADMIN ONLY stage-by-stage conversion per SKU
Sold ACV & Collection CASES TAB

Average case value per period, and how much of it actually came in. Sold ACV = total sold ÷ number of cases. Collected ACV = total collected ÷ number of cases. Collected % = collected ÷ sold. Universe is every hired case in the CASES tab, dated by hired date. Trailing columns end with the last complete month so they never move mid-month.

Business Days Tracker (Mon - Fri Only)
Selling Days This Month
—
Mon to Fri only
Days Passed
—
Including today
Days Remaining
—
Excluding today
% of Month Complete
—
By selling days
Daily DC Targets — Backwards Math to 40 Cases DRIVE THE WORK
Daily Activity (MTD)

Stoplight cells: green at or above daily goal, red below. Weekends excluded. Revenue columns (Case Rev / FPS / Consult Rev / Payment Plans / Total) come ONLY from Manual AR entries. Cases / Consults / Leads counts come from Lead Log.

DateDay Case GoalCases StartedCases MTD Consults HeldConsults Needed Sales GoalCase Rev FPSConsult RevPayment Plans Total Daily Rev Lead GoalActual Leads
AR Routing Audit (Selected Month)

Every Manual AR entry in the selected month, grouped by date, showing exactly which Daily Activity column it lands in. If May 12 or May 22 looks wrong upstairs, the answer is here. Anything in the USCIS — excluded or ⚠ Needs Review buckets is not being counted in Case Rev / Consult Rev / Payment Plans (by design).

How routing works (priority order)
  1. Type = Refund → subtracts from Case Rev. Always wins.
  2. Type = NSF Returned → a bounced check. Subtracts like a refund, counted separately so bounces are visible.
  3. Type = NSF Redeposit → the bounced check made good. Adds to Payment Plans.
  4. Type = USCIS Fees → excluded (pass-through, not firm revenue). Always wins.
  5. Type = Consult Revenue → counted in Consult Rev. Consults are never installments.
  6. Client Payments = Installment or Final Payment → counted in Payment Plans, EVEN IF Type says New Case Revenue. An "Installment" signal means it's a payment-plan installment on an existing case, not a new down payment. The row will be flagged ⚠ Client Payments overrode Type=New Case Revenue so the team can clean up entry habits.
  7. Type = New Case Revenue + Client Payments blank → counted in Case Rev (initial down payment).
  8. Type = Payment Plan + Client Payments blank → counted in Payment Plans.
  9. Legacy Type (Walk-in / Cash / Other) OR Legacy Stage (New Case / Paid Off (Final)) → quarantined to Needs Review, NOT counted anywhere. Click Edit on the row in Manual Entries above to reclassify.
🔍 Show the routing audit — every entry and the column it lands in
Weekly Summary (Auto)
WeekDate RangeSelling Days Cases StartedConsults Held Total RevenueLeads Avg Cases / DayAvg Rev / Day
Custom Date Range

Pick any date range and see the rollup. Useful for comparing weeks, periods, or short windows.

Metric Count / Value Notes

📈 Weekly Scorecard

One scorecard per seat, read off the firm’s KPI definitions and the operating numbers, compared week over week, month over month, and year over year. Coaching priorities are generated from the numbers. Dan and Gilda lock a week’s priorities and the Friday Meeting shows the locked list. You see your own; managers see their reports.

⭐ Client Reviews

Every review a client leaves us gets logged here with who earned it. The month runs as a pyramid: the champion on top, then second and third, then the team. Each person's count against their monthly target shows on TODAY.

🗓️ Training Calendar

Every training session on one calendar, tied to the PEOPLE modules and the Library SOP behind each one. Dan, Gilda, Karla and Karen schedule and take attendance; everyone sees the calendar and their own sessions. "Needs training" lists every required module someone has not passed, with one click to schedule it.

✅ Monthly Review

You grade yourself first: your numbers for the month are already colored green, yellow and red from the KPI definitions, you score the four lines, write your wins, gaps and commitments, and submit. Your manager grades second, checks every line off with you in the one-on-one, and closes it. Last month's commitments come back automatically.

📞 Intake Call Scorecard

Recorded intake calls graded on ten lines, 0 / 1 / 2 each. Graders score their reps, Dan spot-checks, and every person sees their own trend: average, last five, the lines to coach first, and eight weeks of history. The 30-day average feeds the Weekly Scorecard.

👤 People

Every hire from day one: onboarding checklist, training modules with a certification gate, and the documents file. Hire and separation dates live here and feed Employees and Turnover. Dan and Gilda work every record; Karla and Karen sign off their own reports; everyone sees their own card.

Employee Performance & KPI Scorecards

Per-employee KPI scorecards mapped to firm role definitions. Auto-computed from Lead Log where data exists; manual-tracking targets shown for production/admin roles.

Call Credit Audit ADMIN ONLY

Every Discovery Call credited to a person, checked against the evidence a real call leaves behind. A flag means the corroborating field is missing, not that the call did not happen. Use it to find sloppy logging first, and only then to ask harder questions.

Viewing: Month to Date

💰 Payroll Snapshot — Paid Consults Booked ALWAYS MTD · PAYROLL LOCK
⚡ Simplified Scorecards AUTO-FED FROM DASHBOARD DATA

3–5 key KPIs per employee, pulled live from Lead Log / Case Logs / Client Payments. Color-coded against firm standards (Min · Good · Elite). Period follows the picker above.

▶ Detailed KPI Scorecards by Role (incl. manual KPIs)

Intake KPIs now live in the KPIs tab (Intake closing ratio, every way): every teammate side by side, booking discipline, close % seven ways, drop-off, money per lead, speed to hire and source. Open it →

Intake Team (Lead → Discovery → Paid Consult)

Coaching columns (Jun 2026): Need to Collect = lead committed but payment hasn't landed yet, owns this number, must follow up daily. DNW to Pay = lead refused, rep needs coaching on payment objection handling.

Intake Rep Total Leads DC Done DC % ★ Paid Booked Lead → Paid % Need to Collect DNW to Pay FPS Offered

Sales Team (Consult Held → Hired)

Closer Consults Held Hired Lost Close % Revenue Generated Avg Case Value

📊 KPIs

Role scorecards and the sales table for a chosen month, with a comparison month and a rolling 90-day average beside them. Employee profiles, evaluations and the detailed manual scorecards stay on the EMPLOYEES tab.

Open scoreboard. Everyone on the team can see this tab and everyone's numbers are on it, including yours. That is on purpose. You cannot hit a standard you are not allowed to look at. Numbers here are not a verdict on anyone; they are where the coaching starts.

📞
Intake
Lead handling → paid consult booked. What intake controls and is paid on.

Production

Your queue, your deadlines, what is waiting on the client, your numbers against target. Team is the scoreboard, Case Log is the full record, Manager is the deep stats.

Loading…
Loading…
📮 USCIS Submission Calendar click to open
Daily Activity Tracker
Saved.

Gas Calls — Karla's Outbound Outreach

Restricted to Dan, Karen Molina, Karla Calderon, Marimar Espinoza, Erick. Manual call activity + auto-derived pipeline from leads tagged source = Gas Call (90-day hire attribution). Additive on top of the firm's 40-case target.

Gas Call Consults — Day Review INSIDE SALES
—
Gas Call Consults
—
Selected day · Gas Call source
Shown
—
Held = Y
No Shows
—
Held = N
Show Rate
—
Industry std 70-85%
Name Source DC By Remedy Show / No Show Mode Objection Dragon Hired Scheduled to Start Mgr Follow-Up Action

Only leads with source = Gas Call, DC Completed = Y, and Consult Date = selected day. Edit inline — saves to the same lead record as the main Consults tab.

Daily Sales Tracker — Heatmap (Karla × Days) GAS CALL SALES

Karla's closes by day. Source = Gas Call only. Cell shade = activity intensity. Weekly subtotals + MTD totals on the right. Close % color: ≥60% elite · 50-60% on pace · <50% below

Daily Sales Tracker — Heatmap (Intake · DCs by Person × Days) GAS CALL DCs

Discovery Calls (DC = Y) on gas-call leads, attributed to whoever ran the DC. Rows = intake person. Columns = days of the selected month with weekly subtotals + MTD total on the right.

Client Payments

What every client owes, and every payment they make.

Loading client payment schedule…

YTD & Monthly Strategic

Monthly Strategic Review at the top (CEO-level monthly read). Year-to-Date roll-up below for board reviews and the annual goal trajectory.

Monthly Strategic Review
—
Sold MTD
—
—
Cash Collected MTD
—
—
Avg Case Value
—
—
FPS Attach
—
Target: 60%
Refund Rate
—
Below 5% healthy
Lead to hire (days)
—
Avg days from lead date to hire date
Rev / Employee
—
Setup → headcount
Annual Goal Trajectory
—
—
SKU Performance (MTD)
Case TypeClosedAvg ValueRevenue
Time & Speed (Avg, Last 30d)

Marketing ROI by Source (MTD) ADMIN

Spend per source comes from Setup (read-only here). Clients + Revenue auto-pull from Lead Log by hire date. CPC and ROAS auto-calculate.

SourceSpend ($) edit in SetupClientsRevenueCPCROASAction

To change spend, edit in Setup (Monthly Marketing Spend).

Year to Date — Full-Year Roll-Up
—
Revenue YTD
$0
—
Cash Collected YTD
$0
—
Cases Hired YTD
0
—
% to Annual Goal
—
—
Avg Case Value YTD
—
Across all hired cases
Total Leads YTD
—
—
Lead → Hired %
—
Net annual conversion
FPS Hired YTD
—
—
Loss Recovery YTD
—
—
Manual AR YTD
—
Walk-ins + cash payments
Best Month
—
—
Annualized Run Rate
—
—
Funnel — Year to Date

Full-year funnel. Each stage combines Firestore-tracked leads with any per-month historical overrides you logged below. Override months show a gold ★ in the conversion column.

★ New Standard (Jun 2026) Unpaid consults discontinued. Conversion gauge: Qualified → Booked Paid Consult < 50% Below Min 50% At Min 55% Good 60%+ Great

Monthly Expenses ADMIN ONLY

Enter total operating expenses (payroll, rent, marketing, software, etc.) for any month this year. These expenses show in the Year tab's Monthly Breakdown (QuickBooks expenses column, marked manual when QuickBooks has no number) and in the Year over Year panel. It does not change your live leads, cases, or cash for that month — so this is all you need for current-year expenses like June.

Historical Month Overrides ADMIN ONLY

For months where leads/AR aren't in Firestore yet (e.g. Jan-Mar 2026), enter the totals here. When an override exists for a month, the Monthly Breakdown below USES the override values instead of calculating from leads + AR. Override case-type counts also feed the SKU Performance YTD table.

Funnel Stages (feeds YTD Funnel)
SKU Economics — Case Types Sold (count + sold $ per remedy, feeds SKU YTD)

Enter count of cases AND total sold $ per case type. The SKU YTD table will compute ACV (sold ÷ count) automatically. List below is dynamic — it shows every SKU used in Lead Log + every SKU in any override + baseline standards. Add a new SKU by logging a lead with that remedy or by typing it into the field at the bottom.

Saved Overrides
Monthly Breakdown

QuickBooks is the books of record (cash basis, USCIS fees excluded). Dashboard cash is what the team logged in Manual AR. A highlighted gap means the two don't match.

A gold ★ means some numbers that month came from a manual override. Hover the star to see which ones. Everything else is calculated from Lead Log + Manual AR.

Month Leads Cases Sold QuickBooks revenue Dashboard cash entry Gap QuickBooks expenses Net ACV Cumulative QB revenue % of YTD
SKU Performance YTD
Case TypeCasesACVRevenue% of YTD
Sales Team YTD
CloserHeldHiredClose %Revenue
Lead Source Performance YTD
SourceLeadsHiredCases by SKULead → Hired %RevenueAvg per Lead
Annual Goal Trajectory ADMIN ONLY
$0 collected Goal: $0

Goals & Setup

Set monthly revenue goals. These drive the Pace tab.

Firm Closed Dates ADMIN ONLY

Mark dates when the firm is closed (holidays, ops days, weather). The dashboard treats these as non-business days for all forecast and run-rate projections. The firm's normal schedule is Mon-Fri. Saturdays and Sundays are already excluded automatically.

Set Monthly Revenue Goals (Current Month) ADMIN ONLY

Only admin (Dan) can edit these. Goals saved here drive the Pace tab for both you and Gilda.

Saved.
Annual Goals ADMIN ONLY

Set goals for the full year. These drive the Year tab (% to Annual Goal, Trajectory) and the annual goal on Monthly Strategic for that year. If a year has no annual goal here, the Annual Revenue Goal in Firm Settings is used. Use "Distribute Evenly" to split into 12 equal monthly goals (you can override per month later).

Total Annual Revenue Goal:$0
Saved.

Note: "Distribute Evenly" sets the current month's goals to (Annual Goal / 12). To set a different month, change the year above, change the input values, and use the Monthly Pace tab to fine-tune that specific month.

Firm Settings (Drives Strategic KPIs) ADMIN ONLY

Used by Monthly Strategic Review for Revenue per Employee, Annual Goal pacing, and Refund Rate.

Saved.
📊 Monthly Marketing Spend (drives CAC) ADMIN ONLY

Enter what you spent on each source this month. The dashboard divides spend ÷ hired cases per source to compute CAC (Cost Per Hired Case). Hidden until you populate — the premium positioning question is "what does it cost to acquire a case from this channel?" Per-source spend uses the current calendar month by default; pick a different month to backfill history.

Saved.

Note: Repeat, Referral, and Walk-in sources are zero-CAC by definition (no acquisition spend). Those will show up in the CAC table as "Free" with their hires counted but no $ value.

Prior Year Monthly Totals (YoY Comparison) ADMIN ONLY

Enter Cases Hired, Revenue Collected (firm cash, USCIS fees excluded), and Expenses (total operating spend) for the two prior years. The Year over Year panel will compare current month vs same month prior years. Annual totals auto-calculate. For current year expenses, use the Monthly Expenses box above (just pick the month and enter the amount).

2024 Monthly
Total: 0 cases · $0
2025 Monthly
Total: 0 cases · $0
Daily Digest Email ADMIN ONLY

Drives the 📧 Send Daily Digest button on TODAY (manual, any time) and the 6:00 PM CT scheduled Cloud Function (automatic). Paste your Make.com webhook URL below. Make then formats the email and sends through your Gmail or Outlook to the team.

Setup walkthrough: see daily-digest-function/DEPLOY-AND-SETUP.md in your project folder. The Cloud Function uses this same URL when it deploys, so both manual and scheduled emails flow through the same Make scenario (single source of email design).

Saved.

Drives the 📊 Send Production Report button on the PRODUCTION tab. This is a separate Make.com webhook so the email can go to a different recipient list (e.g. Karen, Gilda, Dan) with the management accountability template. Top 10 cases per worker, with status, notes, and last contact date.

Saved.
Intake & Sales KPI Targets ADMIN ONLY

Locking-in targets that drive Coaching Priorities auto-detection. Admin only edits. Visible to all so the team knows the bar.

Stage Current (MTD) 30-Day Target 90-Day Target
Calls → Discovery % — % %
Discovery → Paid Consult % — % %
Paid Consult → Show % — % %
Show → Hired % — % %
Net Lead → Hired % — % %
Saved.
Marketing Budget — Auto-Calculated

Formula: $300 per case sold the month prior. Scales with results. No spend without revenue earned.

Prior Month Cases
0
—
Current Month Marketing Budget
$0
$300 × prior month cases
Implied CAC Cap
$300
Max acceptable cost per acquired client

Strategic note: This budget is a ceiling, not a target. The goal each month is to spend it on the highest-ROAS sources, not all of it. Look at the Marketing tab next month to see source-by-source ROAS and the recommended allocation.

Sample Data ADMIN ONLY

Load 12 sample leads scoped to the month and year you pick. Useful for testing dashboards before live data. Restricted to admin.

Bulk Import (CSV) ADMIN ONLY

Upload a CSV of leads to import into Firebase. Use the column headers Claude generates for you. Each row becomes a lead record. Duplicates are NOT auto-detected — wipe target month first if reimporting.

Required CSV columns: date, source, intake, name. Optional: phone, email, qualified, dc, remedy, fps, booked, consultType, consultDate, consultTime, held, dragon, hasRemedy, hired, hiredDate, lost, caseValue, sold, down, notes (and more).

Data Cleanup — Normalize Lead Sources ADMIN ONLY

Some leads have source variants like "whatsapp", "WhatsApp ", "Whats App" that all should roll up into "WhatsApp". The dashboard already groups them visually via runtime normalization — this button rewrites the underlying records so future filters / exports / CSV downloads are clean too. Safe to run any time. Shows what will change before committing.

Lead Inventory & Delete ADMIN ONLY · DESTRUCTIVE

See how many leads you have per month before deleting anything. Pick a specific month to delete just that month's leads, or use Delete All Leads with the count shown in the confirmation.

Lead Counts by Month

MonthTotal LeadsHiredCash Generated

Delete by Month

Nuclear Option

Stoplight Reference

Intake Stage:

  • RED  Not Qualified — lead has no remedy / not a fit
  • YELLOW  Qualified - DC Pending — has remedy, discovery call not yet completed
  • GREEN  DC Completed — discovery call done (paid or unpaid)

Sales Stage:

  • GREEN  Hired — sale closed
  • YELLOW  Has Remedy - Pending — has remedy but hasn't hired yet
  • RED  Lost or No Remedy

📵 Haven't Talked To

Every lead marked Talked = N, on the same structured chase as Docs Collection. The clock starts at the lead date. Click a due-date cell when the call attempt is made — it stamps date + initials. Set Talked to Y and the lead leaves this list automatically.

🛎 Waiting Room

Every contact in GoHighLevel's Intake pipeline, by stage. Dispatch it to a rep (it becomes a lead, follow-up running) or remove it with a reason. Only new leads leave here as leads. Nobody types a lead by hand.

📋 Touches Due

Every follow-up touch owed today across the three intake sequences: never talked (PNC), talked with no consult (TNC), and the Over 30 slow chase. Late first. One click stamps the touch with your initials. A sequence that runs out gets a decision here, and no open lead is allowed to sit without a next date.

🗓 Talked · No Consult

Leads we spoke with who haven't paid for a consultation — Need to Collect, Does Not Want to Pay, or never set. Same Day 2/3/7/14/21/30 chase from the lead date. Mark the consult Paid (or Waived / Repeat / Internal) and they leave this list; after Day 30 they move to Dead Leads. Lost and unqualified leads are excluded.

💼 Sales Buckets

Every consult held and not hired, in the bucket it lives in. The bucket is the GHL Sales stage and it sets the follow-up. Pick the reason, the bucket follows, the cadence runs. Red rows are over 90 days since the consult.

🐉 Dragon Follow Up

Consults flagged by the manager in the day review: 🔥 Hot Lead or 💰 Sold — Need to Collect. The Mgr Follow-Up date is Day 1 of the chase; the cadence runs Day 1 · 2 · 7 · 14 · 21 · 30 · 60 (weekends roll to Monday). Click a cell when the touch is made — it stamps date + initials. Mark ✓ Completed and the lead drops off here.

📋 Touches Due

The closer’s touches owed today on consults that have not retained: Hot Lead and Sold, Need to Collect, on the Day 1 · 2 · 7 · 14 · 21 · 30 · 60 sequence. Late first. One click stamps the touch. When Day 60 passes with no decision, decide here: Dead, Nurture, or Reassign.

📞 QR Calls

Post-sale relationship calls on hired cases. Day 1 is the sale: Open call Day 2, QR1 days 7 to 10, QR2 days 20 to 30, QR3 days 80 to 90. Check the box when the call is made. Same boxes as the CASES tab, filtered to what is open or late.

⏳ Over 30 Days

Leads that finished the 30-day chase without a conversation. Not dead: they get a slower second cadence, every 3 weeks for 90 days, then every 4 weeks for 90 more. Only a person marks a lead dead, and it can be revived.

👥 Duplicates

The same person on the Lead Log more than once. For each group: leave them as separate cases (a second or third case is its own lead), merge a double entry into the copy you keep, or delete one copy. Every merge and delete is logged with your name.

📋 Activity Roll-up

Calls and activities each teammate completed, in one view. Pick a period; click any number to see the list behind it.

🪑 Friday Meeting

The week in one place: Rhythm discipline per person, the activity roll-up, wins, and the locked priorities for the meeting.

🪑 C-Suite Seats

The firm one executive seat at a time. Each seat sees all seven parts of the business through its own lens, with live numbers from the dashboard and a 15-minute weekly review. Part status is shared across seats and feeds the Firm Blueprint and the COO risk radar.

Roles at Firm

One skeleton per role: the competencies that make the seat work. Under each role, every person who holds it is graded Green, Yellow or Red each quarter, so what each person needs is visible and tracked over time.

Org Chart

The firm as seats: humans, open seats and AI employees side by side by department. Every AI seat has a human owner, a job and a standard. Open seats are the hiring plan. English and Spanish.

🔄 Turnover & Retention

Fortune 500 retention structure: YTD turnover by department (Management · Admin · Intake · Sales · Production), annualized rates, starting-cohort retention, tenure, and 90-day new-hire survival. Maintain the roster below — every metric computes from it.

🔐 Emergency Access Vault

The Emergency Continuity File, live and editable. Fifteen registers covering every account, bill, policy, property, vendor and person connected to the household and the firm — plus the one thing the workbook deliberately will not carry: the passwords.

📐 Firm Blueprint

Who owns this firm, who steps in, what it sells, and who is on the chart. The business plan as a working document instead of a file someone remembers to open — and it exports back to Dropbox in the shape it came.

🧮 SKU’s — Capacity & Margin Calculator

What each case type actually earns once labor is counted, and whether the team has the hours to deliver the volume. Type in the yellow fields; everything grey calculates itself and saves as you go.

⚠ Risk Register

Insurance, contracts, bar and compliance dates, money, operations, people, technology. Likelihood × impact, an owner, a mitigation, a key date and a review date on every row. Review dates post to DEADLINES. Dan and Gilda only.

🏦 Underwriting

Every payment plan goes through an application before terms are quoted. Pending review waits on Dan or Gilda. The hit list is what they answered: tell the client today and mark it done.

🛡 Insurance Register

Every policy the firm carries, who to call when something happens, and when each one has to be renewed. A lapsed policy is not a paperwork problem, it is an uninsured month. Everything typed here saves as you go.

📈 Dan's View

Every angle of the business on one screen: the ops radar, month-to-date against last month, and the month-end forecast at the current pace. Private to the owner.

📊 Graphs

The whole firm at a glance — leads, sales, production, docs, and the chase, drawn from live data across every tab. Restricted like MONTH.

Case Flow Chart

Internal training reference. Sequence of steps for each major case path. Owner: Dan DeLeon, COO.

Intake Call Guide

Interactive bilingual script for discovery calls. Read each question, click what the client says, and the guide opens the exact follow-ups. Use ↻ New Call between calls.

Intake Call Guide v2

The Filter runs first: three binary questions (existing case, who decides, ready to start) in the first 3 minutes. Only three greens continue to Discovery. Read each question, click what the client says, and the guide opens the follow-ups and the exit scripts. Mark the five flags on the lead at the end. Use ↻ New Call between calls.

Date Line — Call Script

Interactive bilingual script for discovery calls. Read each question, click what the client says, and the guide opens the exact follow-ups. Use ↻ New Call between calls.

Protecting Gilda's Time — Master SOP

The 19 rules that protect attorney capacity and keep staff out of unauthorized legal advice. Every section carries the approved script in English and Spanish. Search it during a call — type what the client asked, like travel, vendor or emergency, and only the relevant section stays on screen. Press / to jump to the search box.

💵 Cash Flow Forecast

PRIVATE · DANWeekly forecast starting June 1, 2026. Grey cells auto-fill from live data (leads, consults held, sold, and A/R, consult, and new-case cash); every cell is editable, and your edits stick. Rows I don't have data for start blank for you to fill. Ending balance rolls into the next week automatically.

✉️ Disengagement & Case Letters PRIVATE · DAN + MARIMAR

Search a client, generate one of the three letters (Disengagement, Termination, Approval), and every one is logged below with the client, the letter, the date, and who ran it.

📚 Resources Library

Every SOP, policy, script and guide, with its version, effective date and review date, and who is required to read it. Read it, then sign: your name, the version and the time go on record. A new version asks you to sign again. Dan and Gilda publish.

Case Types — Onboarding Guide

Internal training reference for the team. 32 case types across 8 categories. Owner: Dan DeLeon, COO. Attorney of Record: Gilda McDowell, Esq. Version 1.0 — Effective May 2026.

Part 01 — Welcome

You are joining a firm that exists to help Spanish-speaking immigrant families secure their status with trusted guidance, clear steps, and peace of mind.

Our clients walk through our door scared. They have heard horror stories. They have been to other firms that made promises they could not keep. Our job is to be the trusted, honest guide that walks them through clearly, step by step. That starts with you knowing the case types and respecting the process.

Three Rules Before You Go Further
  1. Only Gilda or an attorney-approved consult gives legal direction. Nobody else.
  2. We never promise outcomes. We promise process, clarity, and effort.
  3. In client-facing language, use "adjustment of status," not "AOS." Use "fiancé visa," not "K-1."
Part 03 — Key Terms You Need to Know

Master these eleven terms in your first week. They show up in every conversation, every file, every case.

TermDefinition
USCUnited States Citizen. Person born in the US or naturalized.
LPRLawful Permanent Resident. A green card holder.
USCISUnited States Citizenship and Immigration Services. The agency that decides most petitions.
NVCNational Visa Center. Handles documents between USCIS and US Consulates abroad.
Consular ProcessingPath where the client receives their immigrant visa at a US Consulate outside the US, then enters the US as an LPR.
AOS (adjustment of status)Path where the client becomes an LPR while inside the US, without leaving.
I-130 PetitionerThe USC or LPR who files for a relative. The sponsor.
BeneficiaryThe relative being petitioned for. The client receiving the benefit.
InadmissibilityA legal bar to entering the US or getting a green card (unlawful presence, certain crimes, prior removals). May require a waiver.
WaiverA request to forgive an inadmissibility ground. The firm files I-601A, I-601, and I-212 waivers.
Joint SponsorA second sponsor added when the petitioner does not meet income requirements.
Category 01 — Family-Based Petitions (I-130)

The I-130 is the petition a USC or LPR files to start a family-based immigration case. It establishes the family relationship. It does not give the relative a green card by itself. It is the door, not the destination.

I-130 Spouse

What it is. Petition filed by a USC or LPR for their husband or wife to start a family-based green card case.

Who it is for. USCs and LPRs married to a foreign national.

What comes next. If beneficiary is inside the US legally and married to a USC, adjustment of status. If outside the US, consular processing.

I-130 Child of USC

What it is. Petition by a USC parent for their unmarried child under twenty-one.

Who it is for. USC parents with foreign-born children.

What comes next. Adjustment of status if the child is inside the US legally, or consular processing if abroad.

I-130 Parents

What it is. Petition filed by a USC age twenty-one or older for their parent.

Who it is for. USCs ages twenty-one and up petitioning a foreign-national parent.

What comes next. Adjustment of status if parent is inside the US legally, or consular processing abroad.

I-130 Siblings

What it is. Petition by a USC age twenty-one or older for their brother or sister.

Who it is for. USCs petitioning foreign-national siblings. Long wait times (often more than ten years for visa availability).

What comes next. Wait for priority date to become current, then NVC consular processing.

Category 02 — Adjustment of Status

Adjustment of status is the path a person uses to become a Lawful Permanent Resident while staying inside the US. The client must have a valid basis (family petition, VAWA self-petition, fiancé entry) and meet eligibility requirements.

AOS Spouse

What it is. Standard adjustment of status filed by a foreign-national spouse of a USC while inside the US.

Who it is for. Couples married to a USC where the foreign spouse is inside the US legally.

What comes next. Biometrics, then AOS interview, then conditional or ten-year green card depending on marriage length.

AOS Spouse (Fine Variant)

What it is. Same as AOS Spouse but where a USCIS fine or specific fee scenario applies. (Confirm internal pricing rule with leadership.)

Who it is for. Spouse AOS cases that trigger additional government fees.

What comes next. Same as AOS Spouse. The fine is paid in addition to standard filing fees.

AOS after Fiancé Visa

What it is. Adjustment of status filed after the client entered on a fiancé visa and married the USC petitioner within ninety days.

Who it is for. Fiancé visa holders who have married their USC sponsor.

What comes next. Biometrics, interview, conditional green card, then I-751 after about two years.

AOS with Joint Sponsor

What it is. Adjustment of status case where a second sponsor is added because the petitioner does not meet income requirements.

Who it is for. Any AOS case where petitioner's income is below 125% of the federal poverty line.

What comes next. Joint sponsor signs Form I-864. Case proceeds normally from there.

AOS with VAWA

What it is. Adjustment of status filed after a VAWA self-petition is approved.

Who it is for. Abused spouses, children, or parents of USCs or LPRs.

What comes next. Biometrics, interview, green card.

AOS Child of USC

What it is. Adjustment of status for an unmarried child of a USC who is inside the US.

Who it is for. Foreign-born unmarried children of USCs inside the US.

What comes next. Biometrics, interview, green card.

AOS Cuban National

What it is. Adjustment of status under the Cuban Adjustment Act. Special path that does not require an immigrant visa petition.

Who it is for. Cuban nationals admitted or paroled into the US for at least one year.

What comes next. File I-485 with proof of Cuban nationality and one-year physical presence. Biometrics, interview, green card.

AOS Parents

What it is. Adjustment of status for a parent of a USC who is inside the US.

Who it is for. Foreign-national parents of USCs ages twenty-one and up who are present in the US.

What comes next. Biometrics, interview, green card.

Category 03 — Waivers

Waivers ask USCIS to forgive a legal bar so the client can move forward. The firm files three main waivers: I-601A (provisional unlawful presence), I-601 (broad inadmissibility waiver), and I-212 (permission to reapply after a prior removal).

I-601A Waiver, First Step

What it is. Provisional waiver of unlawful presence, filed while the client is still inside the US.

Who it is for. Clients with an approved I-130 who have accumulated unlawful presence and need to leave the US to consular-process.

What comes next. If approved, client moves to the Second Step (consular processing abroad).

I-601A, Second Step

What it is. Consular processing after the I-601A waiver is approved. NVC and consulate prepare the case.

Who it is for. Clients with an approved I-601A waiver ready to depart for their consular interview.

What comes next. Interview at the US Consulate abroad.

I-601A Interview

What it is. The actual interview at the US Consulate abroad for an I-601A path case.

Who it is for. Clients who have completed Steps One and Two and have a consulate interview scheduled.

What comes next. If approved, immigrant visa issued and client returns to the US as an LPR.

I-601 / I-212

What it is. Broader inadmissibility waivers for crimes, fraud, prior removals, and other grounds.

Who it is for. Clients with inadmissibility issues outside the standard unlawful presence I-601A path.

What comes next. Filed alone or alongside another case. Approval allows the underlying case to proceed.

Category 04 — Consular Processing and Fiancé Visa

Consular processing is the path for clients receiving their immigrant visa abroad. The fiancé visa is its own path where the foreign fiancé enters the US to marry the USC, then files adjustment of status.

I-864 Consular Process, Second Step

What it is. Sponsor signs Form I-864 Affidavit of Support and submits documents to NVC. Final step before consulate interview.

Who it is for. Cases where the beneficiary is abroad and the I-130 has been approved.

What comes next. Consulate interview. If approved, immigrant visa issued, client enters US as LPR.

Fiancé Visa

What it is. USC petitions for their foreign fiancé to enter the US to marry within ninety days of arrival.

Who it is for. USCs engaged to a foreign national living abroad.

What comes next. After entry and marriage within ninety days, adjustment of status.

Category 05 — Naturalization and Citizenship

Naturalization is the process of becoming a US citizen. The N-400 is the main application. N-565 and N-600 cover citizenship documents.

N-400 (Standard Requirements)

What it is. Application for US citizenship by an LPR who meets the standard residency requirements.

Who it is for. LPRs with five years as a green card holder (three years if married to and living with a USC).

What comes next. Biometrics, interview, English and civics test, oath ceremony.

N-400 (with Criminal Record) ATTORNEY REVIEW

What it is. Same N-400, but the client has a criminal history that needs careful legal review before filing.

Who it is for. LPRs with arrests, convictions, or any record that could trigger inadmissibility or removal.

What comes next. Mandatory attorney review before filing. Risk of denial or removal proceedings must be evaluated.

N-565

What it is. Application to replace a lost, stolen, or damaged Naturalization Certificate or Citizenship Certificate.

Who it is for. Naturalized citizens or derivative citizens who lost their certificate.

What comes next. USCIS issues a replacement certificate.

N-600 (Certificate of Citizenship)

What it is. Application for a Certificate of Citizenship by a person who automatically derived US citizenship through a parent.

Who it is for. Children of USCs who derived citizenship but never received their own certificate.

What comes next. USCIS issues the Certificate of Citizenship.

Category 06 — Green Card Maintenance

These cases keep a green card valid and properly documented after it has been issued.

I-751 Removal of Conditions

What it is. Petition to remove the two-year conditional status from a marriage-based green card. Filed in the ninety days before the conditional card expires.

Who it is for. Conditional permanent residents (married less than two years at the time of green card approval).

What comes next. If approved, client receives a ten-year green card.

I-131 Permit to Travel (Advance Parole)

What it is. Permission to travel while a case is pending, and it protects the case from being treated as abandoned. It is not permission to travel safely. As of August 13, 2026, travel on advance parole can trigger the three or ten year unlawful presence bar. No client travels on advance parole without attorney review of their unlawful presence history.

Who it is for. Clients with pending AOS, DACA, or certain humanitarian cases who need to travel.

What comes next. Travel document issued. Client must re-enter on parole and continue their case.

I-102

What it is. Application to replace a lost or stolen I-94 arrival-departure record.

Who it is for. Anyone who needs a replacement I-94 for proof of legal entry.

What comes next. USCIS issues a replacement I-94.

Category 07 — Humanitarian and Protective

These case types protect victims of abuse, crime, or special humanitarian situations.

U Visa

What it is. Nonimmigrant visa for victims of qualifying crimes who help law enforcement.

Who it is for. Victims of crimes like domestic violence, sexual assault, or human trafficking who cooperate with police.

What comes next. If approved, client receives U status, then may apply for a green card after three years.

VAWA Only

What it is. Self-petition (without an AOS attached) for an abused spouse, child, or parent of a USC or LPR.

Who it is for. Survivors of domestic abuse who cannot rely on the abuser to file for them.

What comes next. If approved, client may later file AOS (with VAWA) or consular processing.

Military Parole in Place

What it is. Parole in place for undocumented family members of US military personnel or veterans.

Who it is for. Spouses, parents, and unmarried children of active-duty military, reservists, or veterans.

What comes next. If granted, client may pursue adjustment of status from inside the US.

Category 08 — Other Status and Records
TN Visa

What it is. Nonimmigrant work visa for Canadian and Mexican professionals under USMCA (formerly NAFTA).

Who it is for. Canadian and Mexican professionals in qualifying occupations with a US job offer.

What comes next. Renewable. Does not lead directly to a green card.

DACA Renewal

What it is. Renewal of Deferred Action for Childhood Arrivals status. The firm handles renewals only, not initial DACA filings.

Who it is for. Current DACA holders renewing their status.

What comes next. If approved, DACA extended by two years. Recipient may also need to renew work permit.

FOIA

What it is. Freedom of Information Act request to obtain the client's immigration file from a government agency.

Who it is for. Anyone who needs a copy of their immigration records (often used to build a case strategy).

What comes next. Records are used to plan or support another case (waiver, defense, AOS).

Part 05 — What We Do Not Handle

If a lead asks about any of the following, tell them politely that the firm does not handle this and refer them per the intake script. Do not attempt to advise them.

  • Asylum cases. The firm declines asylum, by policy.
  • Removal or deportation defense (unless added in writing by Gilda).
  • Employment-based immigration outside of TN visa (unless Gilda approves).
  • Federal court litigation (unless Gilda approves co-counsel).
Part 06 — What To Do When a Case Comes In

Your job at intake is qualification, not legal analysis. Use this sequence:

  1. Identify the case type using this guide. If you do not know, ask your team lead.
  2. Confirm the client's situation matches the case type definition. If unsure, escalate to a consult.
  3. Route the lead to the right consult track per the intake SOP.
  4. Log every detail in the case management system. No detail is too small.
  5. Never give legal advice. Only Gilda or an attorney-approved consult does that.
Our Promise

We help Spanish-speaking immigrant families secure their status with trusted guidance, clear steps, and peace of mind.

Ayudamos a familias inmigrantes de habla hispana a asegurar su estatus con guía de confianza, pasos claros y tranquilidad.

Welcome to the team. · Bienvenido al equipo.

Law Office of Gilda McDowell · Case Types Onboarding Guide · Version 1.0 · Effective May 2026

SOPs & Policies — Employee Resource Library

Every standard operating procedure and firm policy in one place. Click a card to expand the full document. Owned by Dan DeLeon, COO. Final authority: Gilda McDowell, Attorney of Record.

📚 Library Index · ${(function(){return 4;})()} Policies Active
💰 Money & Collections
Payment Plan & Collections Policy EN
Version 2.0 · Effective 09/15/26 · Owner: Dan DeLeon
💰 Dinero y Cobranza ES
Política de Planes de Pago y Cobranza
Versión 2.0 · Vigente 15/09/26 · Dueño: Dan DeLeon
📝 Sales
The "Perfect" Sales Call — Consultation Worksheet
Version 1.0 · Effective 08/03/26 · Owner: The Rep on the Call
🔒 Compliance & Confidentiality
Client Privilege & Confidentiality
Version 1.0 · Effective 07/06/26 · Owner: Gilda McDowell / Dan DeLeon
Standard Operating Procedure · 📝 Sales

The "Perfect" Sales Call — Bilingual Worksheet

Law Office of Gilda McDowell · Lubbock, Texas
PurposeTurn discovery into commitment. Capture the client's own words — what they want, why now, the emotional, family, and financial cost, and the TRUE objection — so the close is built from their words, not ours.
OwnerThe rep on the call. Whoever runs the consultation fills it, saves it, and files it.
Version / Effective1.0 · August 3, 2026
Applies toEvery consultation — in office or by phone.
Record keepingAnswers save to the client's record automatically as you type, and reload when the worksheet is reopened. Also download the PDF and attach it to the client's GHL record the same day.
Final authorityDan DeLeon, COO

The Four Stages (HTM "Perfect Sales Call")

Open it from Today's Consults. Click the red 💰 Make the Sale button next to the client's name. Client, date, rep, callback number, and case type prefill. Set the Decision Stage. Then run the four stages in order — each stage earns the right to the next. (FOIA case types also show a blue 📄 FOIA button for the FOIA questionnaire.)

Stage 1 · The Opening. Confirm the time. Assure confidentiality. Get permission — to record, to take notes, to propose the agenda. Read the agenda script word for word, and collect NOW what you'll need at the close: who else is part of the decision. A call opened wrong cannot be closed right.

Stage 2 · Problem Identification. The heart of the call. What they want → why now → what they already tried and why it didn't work → the emotional cost → the family cost → the financial cost. Write THEIR words, verbatim: "I can't sleep because my husband could be picked up" closes cases; "client is worried" closes nothing. The money questions need real numbers — the gap between what they make now and what they could make resolved is the case paying for itself. Let the client say it.

Stage 3 · Possible Solutions. Present the four doors, out loud: do nothing, do it yourself, keep searching, or we help you begin making this better today. Let them choose door four — people defend choices they made themselves. Then present the plan and the investment, and run the objection-clarity questions to name the TRUE objection (money, timing, uncertainty, or trust) while they're still in front of you.

Stage 4 · The Close. WHO is going to do WHAT by WHEN — said out loud, written in the grid, before anyone stands up. Then the rep summary (top emotional driver, financial driver, true objection) and the final next step: decision made, payment direction, follow-up time, or spouse call scheduled. A call without a WHO/WHAT/WHEN is a lost lead.

Save and file. The worksheet saves to the client automatically as you type — reopen it any time and the answers are there. Still hit 🖨 Download PDF and attach it to the client's GHL record the same day. Then close from their words: "You told me…"

Standards & Accountability

· The worksheet is used on EVERY consultation — no exceptions for "easy" closes.

· Verbatim answers, not paraphrases. Quotes are ammunition; summaries are noise.

· The WHO / WHAT / by WHEN grid is never blank. Every consultation ends with a committed next step and a time.

· Answers autosave to the client's record — but the PDF still gets downloaded and attached to GHL the same day. A consult with no worksheet is an unworked consult, and it lands on the rep.

Standard Operating Procedure · 💰 Money & Collections

Payment Plan & Collections Policy

Law Office of Gilda McDowell · Lubbock, Texas
VERSION 2.0 · SUPERSEDES V1.0
PolicyPayment Plan & Collections Policy
PurposeClose more cases by meeting the client where they are, without turning the firm back into a free finance company. Flexibility on term, discipline on minimums.
Owner (Policy)Dan DeLeon, COO
Owner (Sales / Point of Sale)Hector and the intake closers (the Dragons)
Owner (Collections)Collections team member
Final AuthorityGilda McDowell, Attorney of Record
Version2.0
Effective Date09/15/26
Applies ToAll new engagements. Active plans keep their existing terms.
Changed in 2.0Term extended to 12 payments max · $500 minimum payment introduced · flat $299 financing fee replaces the tiered setup fee · 3% card processing charge added · one-third-down rule replaced with maximum down

1. What Changed, and Why

Version 1.0 fixed a real problem. We were financing cases at zero percent with no floor and no end date, and the firm was carrying debt it had no business carrying. Three payments, one-third down, card on file. That policy did its job.

It also cost us cases. A rigid three-payment structure told a client who could genuinely pay us over eight months that the answer was no. That is a case we did not take, a family we did not help, and revenue we did not earn, all to avoid a problem we can solve a better way.

Version 2.0 moves the discipline from the term to the minimum. We will be flexible on how long a client takes. We will not be flexible on how small each payment is, on getting real money down, or on the card being on file. A $500 floor is what makes a longer term safe.

The Principle
Be flexible. Flexibility is not the absence of a rule, it is a wider rule with a hard floor. The floor is $500 a payment, 12 payments maximum, card on file, and as much down as the client can put down.

2. Payment Structure (Point of Sale)

Option A — Pay in Full or Two Payments

  • Pay in full at signing, or half down at signing with the balance due when the case is ready to file with USCIS.
  • If the case is ready in two weeks, the balance is due in two weeks.
  • The $299 financing fee is waived under this option. The firm is not carrying a balance, so there is nothing to charge for.

Option B — Payment Plan

This is where the flexibility lives. Three numbers govern every plan and they are not negotiable.

  • Maximum down. Ask for the largest down payment the client can actually make today, then ask once more. There is no fixed percentage any more, and that is not permission to take less, it is permission to take more. The down payment is the single best predictor of whether a plan gets paid.
  • $500 minimum per payment. No payment on any plan is under $500. Not the second one, not the last one. This is the floor that makes everything else work.
  • Stretch to 6 internally before extending the term. A closer can write up to six payments on their own authority. Work the down payment and the payment amount first; reach for term last.
  • 12 payments is the ceiling. Seven through twelve requires Hector’s approval on the file before the contract is signed. Not after.

The Term Follows the Math, Not the Negotiation

Term is not something a client talks us into. It falls out of the balance divided by $500, capped at 12. Run the math in front of the client and the number is simply what it is.

Financed balanceMax paymentsAt the $500 floorWho approves
$1,5003$500Closer
$2,5005$500Closer
$3,0006$500Closer
$4,0008$500Hector approves
$5,00010$500Hector approves
$6,00012$500Hector approves
$9,00012$750Hector approves
$12,00012$1,000Hector approves
Read the table this way
A $3,000 balance cannot be a 12-month plan, because that would be $250 a month and $250 is under the floor. The client is not being told no, they are being told the term that their own number produces. If they want longer, they put more down or they fund it outside.

Hard Limits

  • $500 minimum payment. No exceptions. There is no $100 a month plan at this firm and there never will be again.
  • 12 payments maximum. There is no 18, no 24, and no open-ended arrangement.
  • Amounts and due dates are fixed at signing. No “I will pay $800 this month and $300 next month.”
  • Payments are monthly and dated. A plan with no dates is not a plan.
  • If the client cannot meet the $500 floor, the answer is outside financing (Section 6), not a longer term. Term flexibility is not a substitute for the client finding the money.

3. Card on File (Unchanged and Non-Negotiable)

  • Every financed case requires a valid card on file. No card, no financing. Full stop. Longer terms make this more important, not less.
  • The card authorization form is signed at the time of contract, on every file, with no exceptions.
  • The card does not have to be the client’s own. A family member’s, a friend’s, or an employer’s card is fine. The obligation is that a card exists.
  • No cash-only arrangements. No “I will come pay when I get my taxes.” No Venmo or Cash App without a card on file.

We are flexible on whose card it is. We are not flexible on whether there is one.

4. What Financing Costs

Version 1.0 offered financing at zero percent with a tiered setup fee. Version 2.0 keeps the structure honest and simple: one flat fee for carrying the balance, and the actual cost of taking a card, passed through.

4.1 — $299 Financing Fee

  • $299 flat, on every payment plan, regardless of case size. This replaces the old $199 / $299 tiered setup fee.
  • Added to the balance. It is not collected as a separate charge at signing, so it never competes with the down payment.
  • Waived on pay-in-full and two-payment engagements (Option A). The fee exists because the firm is carrying the balance. If we are not carrying it, there is nothing to charge.

4.2 — 3% Card Processing Charge

  • 3% is added to every card transaction, including the down payment and every installment we run on the card on file.
  • It is disclosed at the point of sale, written into the fee agreement, and shown on the receipt. The client hears it from the closer before they ever see it on a statement.
  • It is a pass-through of what it costs us to accept the card, not a profit line. Say it that way, because that is what it is, and because that is what the card networks require it to be.
LineAmountNote
Case fee$6,000The legal fee, unchanged
Down payment$2,000As much as the client can put down
Financing fee+$299Added to balance
Remaining balance$4,299$6,000 + $299 − $2,000
Term9 payments$4,299 ÷ $500 = 8.6, rounds to 9 · Hector approves
Each payment$477.67 + 3%$491.99 charged to the card
Down payment charged$2,000 + 3%$2,060 charged at signing
Before the 3% goes live
Card surcharging is legal in Texas but it is governed by federal law, card-network rules, and our fee agreement — see Section 9. Do not begin charging it until Gilda has approved the contract language and the processor has confirmed registration and the debit-card exclusion. Sales can quote the $299 fee and the new terms immediately.

5. Collections Cadence (Unchanged)

The cadence does not change, and the reason is worth saying out loud: longer terms mean the firm carries balances further into the year, so the cost of letting one age is higher now, not lower. A client three payments behind on a 12-month plan is the same problem as a client three payments behind on a 3-month plan. We act on the same clock.

TriggerAction / Owner
30 days past dueCollections outreach with urgency. State the consequence plainly: an unpaid account leads to disengagement. (Collections team member)
60 days past dueFinal urgency and formal written warning that the firm will withdraw if the account is not brought current. (Collections team member)
90 days past dueDisengagement letter sent and the firm withdraws as attorney of record. The client must be disengaged by the time 90 days rolls around. (Collections drafts; Gilda McDowell approves and signs)

Excuses do not change the cadence. Because the terms are disclosed at signing, the client has already been told exactly what happens.

6. Outside Financing

Closing is not the problem. The job is to close the client and then help them find the money. The urgency to fund the case belongs to the client.

  • Use our approved outside financing partners: the legal-services financing company, and the option for clients without a Social Security number.
  • The closer walks the client through the application in the office when they are not comfortable with the forms. We do not hand them a link and hope.
  • Outside financing is the answer when a client cannot clear the $500 floor. It is not a fallback we mention once, it is the path, and the closer owns walking them down it.
Frame for the team
A client will put $10,000 on a credit card at 30% before they will look elsewhere, simply because we offered them 0%. That difference comes out of our own families. We give clients time. We do not give them free money.

7. Ownership & Accountability

OwnerResponsibility
Hector / intake closersEnforce the $500 floor, maximum down, and card on file at the point of sale. Approve terms of 7 to 12 payments before the contract is signed. Help the client find the money and complete outside financing applications.
Collections team memberRun the 30 / 60 / 90 cadence. Trigger and prepare disengagement at 90 days. Keep the AR dashboard current.
Gilda McDowell, Attorney of RecordFinal authority on the policy. Approves the fee-agreement language for the financing fee and the 3% charge. Approves and signs disengagement letters.
Dan DeLeon, COOOwns the policy, trains the team, and monitors the AR dashboard for compliance.

Standard of Success

  • Zero payment plans written below the $500 floor.
  • Zero plans written past 12 payments.
  • Every plan of 7 to 12 payments carries Hector’s documented approval.
  • 100% of financed files have a signed card authorization on file.
  • No file ages past 90 days without a disengagement decision.
  • Average down payment as a percentage of case value trends up month over month. This is the number that tells us whether “maximum down” is real or whether it quietly became “whatever they offered.”
  • Average plan term is watched monthly. If it drifts toward 12 across the board, the flexibility is being used as a shortcut and the policy gets tightened.

8. Team Scripts (Bilingual)

8.1 — Presenting the Terms at Close

Closer to client

EN  Here is how we work. You can pay in full, or we can set up a plan. Whatever you can put down today, put down, because it lowers everything after it. From there we split the balance into monthly payments of at least five hundred dollars, up to twelve months. There is a two hundred ninety-nine dollar financing fee added to the balance, and card processing adds three percent to each charge. We keep a card on file. That is the structure for everyone.

ES  Así trabajamos. Puede pagar el total, o podemos hacer un plan. Lo que pueda dar hoy de enganche, démelo, porque baja todo lo demás. De ahí dividimos el saldo en pagos mensuales de por lo menos quinientos dólares, hasta doce meses. Hay un cargo de financiamiento de doscientos noventa y nueve dólares que se agrega al saldo, y el procesamiento de tarjeta agrega tres por ciento a cada cobro. Dejamos una tarjeta registrada. Esta es la estructura para todos.

8.2 — Asking for the Down Payment (Ask Twice)

Closer to client

EN  What can you put down today? … Okay. And if you needed to, could you get to a little more, from savings, from family, from anyone in your life who wants to see this handled? I ask because every dollar you put down today is a dollar you are not paying us with interest somewhere else, and it shortens this whole thing.

ES  ¿Cuánto puede dar hoy de enganche? … Está bien. Y si fuera necesario, ¿podría llegar a un poco más, de ahorros, de familia, de alguien en su vida que quiera ver esto resuelto? Se lo pregunto porque cada dólar que da hoy es un dólar que no va a pagar con intereses en otro lado, y acorta todo este proceso.

8.3 — When the Client Asks for Less Than $500 a Month

Closer to client

EN  I hear you, and I want to get this done for you. Five hundred a month is our floor. Below that we are not a law firm any more, we are a finance company, and that is not what we do. So let us solve it a different way. Either we get more down today so the payments land where they need to, or I help you apply with one of our financing partners right here in the office. Which one do you want to try first?

ES  Lo entiendo, y quiero resolverlo para usted. Quinientos al mes es nuestro mínimo. Por debajo de eso ya no somos un bufete de abogados, somos una financiera, y eso no es lo que hacemos. Así que resolvámoslo de otra manera. O conseguimos más de enganche hoy para que los pagos queden donde deben quedar, o le ayudo a aplicar con una de nuestras compañías de financiamiento aquí mismo en la oficina. ¿Cuál quiere intentar primero?

8.4 — Explaining the 3% Without Apologizing for It

Closer to client

EN  One thing so nothing surprises you later: when we run a card, the processing company charges a fee, and that three percent is what it costs us. It is on the down payment and on each monthly payment, and it is written into your agreement so you can see it. If you would rather avoid it, we can look at other ways to pay.

ES  Una cosa para que nada le sorprenda después: cuando cobramos con tarjeta, la compañía procesadora cobra una comisión, y ese tres por ciento es lo que nos cuesta. Aplica al enganche y a cada pago mensual, y está escrito en su acuerdo para que usted lo pueda ver. Si prefiere evitarlo, podemos ver otras formas de pago.

8.5 — Collections Urgency (30 / 60 Day)

Collections to client

EN  I am reaching out because your account is past due. I want to keep your case moving and avoid any interruption. To protect your case we need to bring the balance current. If the account is not brought up to date, the firm will have to withdraw from your case. Can we run your card on file today?

ES  Le contacto porque su cuenta está vencida. Quiero mantener su caso en marcha y evitar cualquier interrupción. Para proteger su caso necesitamos poner el saldo al día. Si la cuenta no se pone al corriente, el bufete tendrá que retirarse de su caso. ¿Podemos cobrar su tarjeta registrada hoy?

9. Before the 3% Goes Live — For Gilda

This section is an implementation checklist, not legal advice. The 3% charge is a regulated practice with federal, card-network, and professional-responsibility dimensions. Gilda has final say, and the processor has to confirm the mechanics.

  • Debit cards cannot be surcharged. Federal law prohibits it regardless of state law, and a large share of our clients pay with debit. Confirm with the processor that the system distinguishes debit from credit automatically, or the charge gets applied where it must not be.
  • Card-network registration and notice. Visa and Mastercard require advance notice to the acquirer and the networks before surcharging begins, cap the amount, and require disclosure at the point of entry and on the receipt.
  • Texas. The state’s anti-surcharge statute was enjoined in federal court, which is why this is available to us. Confirm current status before launch.
  • Fee agreement language. The $299 financing fee and the 3% charge must appear in the signed engagement agreement, not only in this SOP. A charge the client did not agree to in writing is a problem regardless of what the policy says.
  • Trust accounting. Confirm how the surcharge is handled on any funds that pass through trust, and that the fee is recorded so the ledger stays clean.
Sequencing
The term changes, the $500 floor, the maximum-down rule, and the $299 financing fee take effect immediately. The 3% card charge takes effect only after Gilda approves the fee-agreement language and the processor confirms registration and debit handling. Do not let the 3% hold up the rest.

Approved for implementation. Version 2.0 supersedes Version 1.0 in full. Active payment plans written under Version 1.0 keep their existing terms; this policy governs new engagements from the effective date.

Owner: Dan DeLeon, COO  ·  Final Authority: Gilda McDowell, Attorney of Record

Procedimiento Operativo Estándar · 💰 Dinero y Cobranza

Política de Planes de Pago y Cobranza

Oficina Legal de Gilda McDowell · Lubbock, Texas
VERSIÓN 2.0 · ESPAÑOL Ver en inglés →
PolíticaPolítica de Planes de Pago y Cobranza
PropósitoCerrar más casos atendiendo al cliente donde está, sin que el bufete vuelva a convertirse en una financiera gratuita. Flexibilidad en el plazo, disciplina en los mínimos.
Dueño (Política)Dan DeLeon, Director de Operaciones
Dueño (Ventas / Punto de Venta)Héctor y los cerradores de intake (los Dragones)
Dueño (Cobranza)Encargado de cobranza
Autoridad FinalGilda McDowell, Abogada de Registro
Versión2.0
Fecha de Vigencia15/09/26
Aplica ATodos los contratos nuevos. Los planes activos conservan sus términos actuales.
Cambios en la 2.0Plazo extendido a 12 pagos máximo · pago mínimo de $500 · cargo fijo de financiamiento de $299 reemplaza la cuota escalonada · se agrega el 3% por procesamiento de tarjeta · la regla de un tercio de enganche se reemplaza por el máximo enganche posible

1. Qué Cambió, y Por Qué

La Versión 1.0 resolvió un problema real. Estábamos financiando casos al cero por ciento, sin mínimo y sin fecha final, y el bufete cargaba una deuda que no le correspondía cargar. Tres pagos, un tercio de enganche, tarjeta registrada. Esa política hizo su trabajo.

También nos costó casos. Una estructura rígida de tres pagos le decía que no a un cliente que honestamente sí nos podía pagar en ocho meses. Ese es un caso que no tomamos, una familia a la que no ayudamos, e ingresos que no ganamos, todo para evitar un problema que podemos resolver de mejor manera.

La Versión 2.0 mueve la disciplina del plazo al mínimo. Vamos a ser flexibles en cuánto tiempo se toma el cliente. No vamos a ser flexibles en qué tan pequeño es cada pago, en conseguir dinero real de enganche, ni en que haya una tarjeta registrada. El mínimo de $500 es lo que hace seguro un plazo más largo.

El Principio
Sea flexible. La flexibilidad no es la ausencia de una regla, es una regla más amplia con un piso firme. El piso es $500 por pago, 12 pagos máximo, tarjeta registrada, y el mayor enganche que el cliente pueda dar.

2. Estructura de Pago (Punto de Venta)

Opción A — Pago Total o Dos Pagos

  • Pago total al firmar, o la mitad de enganche al firmar con el saldo restante cuando el caso esté listo para presentarse ante USCIS.
  • Si el caso queda listo en dos semanas, el saldo se vence en dos semanas.
  • El cargo de financiamiento de $299 no aplica bajo esta opción. El bufete no está cargando un saldo, así que no hay nada que cobrar.

Opción B — Plan de Pagos

Aquí es donde vive la flexibilidad. Tres números gobiernan cada plan y no son negociables.

  • Máximo enganche. Pida el enganche más grande que el cliente realmente pueda dar hoy, y luego pregúntele una vez más. Ya no hay un porcentaje fijo, y eso no es permiso para aceptar menos, es permiso para pedir más. El enganche es el mejor indicador de si un plan se va a pagar.
  • $500 mínimo por pago. Ningún pago de ningún plan baja de $500. Ni el segundo, ni el último. Este es el piso que hace que todo lo demás funcione.
  • Estire hasta 6 internamente antes de extender el plazo. Un cerrador puede escribir hasta seis pagos por su propia autoridad. Trabaje primero el enganche y el monto del pago; el plazo es lo último.
  • 12 pagos es el límite. De siete a doce requiere la aprobación de Héctor en el expediente antes de firmar el contrato. No después.

El Plazo Sale de la Matemática, No de la Negociación

El plazo no es algo que el cliente nos convenza de dar. Sale del saldo dividido entre $500, con tope de 12. Haga la cuenta enfrente del cliente y el número es simplemente lo que es.

Saldo financiadoPagos máximosAl piso de $500Quién aprueba
$1,5003$500Cerrador
$2,5005$500Cerrador
$3,0006$500Cerrador
$4,0008$500Héctor aprueba
$5,00010$500Héctor aprueba
$6,00012$500Héctor aprueba
$9,00012$750Héctor aprueba
$12,00012$1,000Héctor aprueba
Lea la tabla así
Un saldo de $3,000 no puede ser un plan de 12 meses, porque eso sería $250 al mes y $250 está por debajo del piso. Al cliente no se le está diciendo que no, se le está diciendo el plazo que produce su propio número. Si quiere más tiempo, da más enganche o lo financia por fuera.

Límites Firmes

  • $500 mínimo por pago. Sin excepciones. No existe un plan de $100 al mes en este bufete y nunca volverá a existir.
  • 12 pagos máximo. No hay 18, no hay 24, y no hay arreglos abiertos sin fecha final.
  • Los montos y las fechas se fijan al firmar. Nada de “pago $800 este mes y $300 el siguiente.”
  • Los pagos son mensuales y con fecha. Un plan sin fechas no es un plan.
  • Si el cliente no alcanza el piso de $500, la respuesta es financiamiento externo (Sección 6), no un plazo más largo. La flexibilidad de plazo no sustituye que el cliente consiga el dinero.

3. Tarjeta Registrada (Sin Cambios y No Negociable)

  • Todo caso financiado requiere una tarjeta válida registrada. Sin tarjeta, no hay financiamiento. Punto. Los plazos más largos hacen esto más importante, no menos.
  • La forma de autorización de tarjeta se firma al momento del contrato, en cada expediente, sin excepciones.
  • La tarjeta no tiene que ser del cliente. La de un familiar, un amigo o un empleador está bien. La obligación es que exista una tarjeta.
  • No hay arreglos solo en efectivo. Nada de “vengo a pagar cuando me llegue el reembolso de impuestos.” Ni Venmo ni Cash App sin tarjeta registrada.

Somos flexibles en de quién es la tarjeta. No somos flexibles en si hay una.

4. Lo Que Cuesta el Financiamiento

La Versión 1.0 ofrecía financiamiento al cero por ciento con una cuota escalonada. La Versión 2.0 mantiene la estructura honesta y simple: un cargo fijo por cargar el saldo, y el costo real de aceptar una tarjeta, trasladado al cliente.

4.1 — Cargo de Financiamiento de $299

  • $299 fijo, en cada plan de pagos, sin importar el tamaño del caso. Reemplaza la cuota escalonada anterior de $199 / $299.
  • Se agrega al saldo. No se cobra aparte al firmar, así que nunca compite con el enganche.
  • No aplica en pago total ni en dos pagos (Opción A). El cargo existe porque el bufete está cargando el saldo. Si no lo estamos cargando, no hay nada que cobrar.

4.2 — Cargo del 3% por Procesamiento de Tarjeta

  • Se agrega 3% a cada transacción con tarjeta, incluyendo el enganche y cada mensualidad que cobremos a la tarjeta registrada.
  • Se informa en el punto de venta, se escribe en el acuerdo de honorarios y se muestra en el recibo. El cliente lo escucha del cerrador antes de verlo en su estado de cuenta.
  • Es el traslado de lo que nos cuesta aceptar la tarjeta, no una ganancia. Dígalo así, porque eso es lo que es, y porque así lo exigen las redes de tarjetas.
ConceptoMontoNota
Honorario del caso$6,000El honorario legal, sin cambios
Enganche$2,000Lo máximo que el cliente pueda dar
Cargo de financiamiento+$299Se agrega al saldo
Saldo restante$4,299$6,000 + $299 − $2,000
Plazo9 pagos$4,299 ÷ $500 = 8.6, redondea a 9 · Héctor aprueba
Cada pago$477.67 + 3%$491.99 cobrados a la tarjeta
Enganche cobrado$2,000 + 3%$2,060 cobrados al firmar
Antes de que el 3% entre en vigor
El recargo por tarjeta es legal en Texas, pero está regulado por ley federal, por las reglas de las redes de tarjetas y por nuestro acuerdo de honorarios (ver Sección 9). No empiece a cobrarlo hasta que Gilda apruebe el texto del contrato y el procesador confirme el registro y la exclusión de tarjetas de débito. Ventas puede cotizar el cargo de $299 y los nuevos términos de inmediato.

5. Cadencia de Cobranza (Sin Cambios)

La cadencia no cambia, y vale la pena decir en voz alta por qué: los plazos más largos significan que el bufete carga saldos más adentro del año, así que el costo de dejar envejecer uno es más alto ahora, no más bajo. Un cliente con tres pagos atrasados en un plan de 12 meses es el mismo problema que uno con tres pagos atrasados en un plan de 3 meses. Actuamos con el mismo reloj.

DisparadorAcción / Responsable
30 días de atrasoContacto de cobranza con urgencia. Se dice la consecuencia con claridad: una cuenta sin pagar lleva a la renuncia del caso. (Encargado de cobranza)
60 días de atrasoÚltima urgencia y aviso formal por escrito de que el bufete se retirará si la cuenta no se pone al corriente. (Encargado de cobranza)
90 días de atrasoSe envía la carta de terminación y el bufete se retira como abogada de registro. El cliente debe quedar desvinculado para cuando se cumplan los 90 días. (Cobranza redacta; Gilda McDowell aprueba y firma)

Las excusas no cambian la cadencia. Como los términos se informan al firmar, al cliente ya se le dijo exactamente qué pasa.

6. Financiamiento Externo

Cerrar no es el problema. El trabajo es cerrar al cliente y luego ayudarle a conseguir el dinero. La urgencia de financiar el caso le pertenece al cliente.

  • Use nuestras compañías de financiamiento aprobadas: la financiera de servicios legales, y la opción para clientes sin número de Seguro Social.
  • El cerrador acompaña al cliente en la solicitud dentro de la oficina cuando no se siente cómodo con las formas. No le damos un enlace y esperamos.
  • El financiamiento externo es la respuesta cuando el cliente no alcanza el piso de $500. No es algo que se menciona una vez, es el camino, y el cerrador es responsable de acompañarlo por él.
Para el equipo
Un cliente pondrá $10,000 en una tarjeta de crédito al 30% antes de buscar en otro lado, simplemente porque nosotros le ofrecimos 0%. Esa diferencia sale de nuestras propias familias. Le damos tiempo al cliente. No le damos dinero gratis.

7. Responsabilidad y Rendición de Cuentas

ResponsableResponsabilidad
Héctor / cerradores de intakeHacer cumplir el piso de $500, el máximo enganche y la tarjeta registrada en el punto de venta. Aprobar plazos de 7 a 12 pagos antes de que se firme el contrato. Ayudar al cliente a conseguir el dinero y completar solicitudes de financiamiento externo.
Encargado de cobranzaEjecutar la cadencia de 30 / 60 / 90. Activar y preparar la terminación a los 90 días. Mantener al día el tablero de cuentas por cobrar.
Gilda McDowell, Abogada de RegistroAutoridad final sobre la política. Aprueba el texto del acuerdo de honorarios para el cargo de financiamiento y el 3%. Aprueba y firma las cartas de terminación.
Dan DeLeon, Director de OperacionesEs dueño de la política, capacita al equipo y vigila el tablero de cuentas por cobrar para asegurar el cumplimiento.

Estándar de Éxito

  • Cero planes de pago escritos por debajo del piso de $500.
  • Cero planes escritos a más de 12 pagos.
  • Todo plan de 7 a 12 pagos lleva la aprobación documentada de Héctor.
  • 100% de los expedientes financiados tienen autorización de tarjeta firmada.
  • Ningún expediente pasa de 90 días sin una decisión de terminación.
  • El enganche promedio como porcentaje del valor del caso sube mes con mes. Este es el número que nos dice si el “máximo enganche” es real o si calladamente se convirtió en “lo que el cliente ofreció.”
  • El plazo promedio se revisa cada mes. Si se corre hacia 12 en todos los casos, la flexibilidad se está usando como atajo y la política se aprieta.

8. Guiones para el Equipo (Bilingüe)

8.1 — Presentando los Términos al Cerrar

Cerrador al cliente

ES  Así trabajamos. Puede pagar el total, o podemos hacer un plan. Lo que pueda dar hoy de enganche, démelo, porque baja todo lo demás. De ahí dividimos el saldo en pagos mensuales de por lo menos quinientos dólares, hasta doce meses. Hay un cargo de financiamiento de doscientos noventa y nueve dólares que se agrega al saldo, y el procesamiento de tarjeta agrega tres por ciento a cada cobro. Dejamos una tarjeta registrada. Esta es la estructura para todos.

EN  Here is how we work. You can pay in full, or we can set up a plan. Whatever you can put down today, put down, because it lowers everything after it. From there we split the balance into monthly payments of at least five hundred dollars, up to twelve months. There is a two hundred ninety-nine dollar financing fee added to the balance, and card processing adds three percent to each charge. We keep a card on file. That is the structure for everyone.

8.2 — Pidiendo el Enganche (Pregunte Dos Veces)

Cerrador al cliente

ES  ¿Cuánto puede dar hoy de enganche? … Está bien. Y si fuera necesario, ¿podría llegar a un poco más, de ahorros, de familia, de alguien en su vida que quiera ver esto resuelto? Se lo pregunto porque cada dólar que da hoy es un dólar que no va a pagar con intereses en otro lado, y acorta todo este proceso.

EN  What can you put down today? … Okay. And if you needed to, could you get to a little more, from savings, from family, from anyone in your life who wants to see this handled? I ask because every dollar you put down today is a dollar you are not paying us with interest somewhere else, and it shortens this whole thing.

8.3 — Cuando el Cliente Pide Menos de $500 al Mes

Cerrador al cliente

ES  Lo entiendo, y quiero resolverlo para usted. Quinientos al mes es nuestro mínimo. Por debajo de eso ya no somos un bufete de abogados, somos una financiera, y eso no es lo que hacemos. Así que resolvámoslo de otra manera. O conseguimos más de enganche hoy para que los pagos queden donde deben quedar, o le ayudo a aplicar con una de nuestras compañías de financiamiento aquí mismo en la oficina. ¿Cuál quiere intentar primero?

EN  I hear you, and I want to get this done for you. Five hundred a month is our floor. Below that we are not a law firm any more, we are a finance company, and that is not what we do. So let us solve it a different way. Either we get more down today so the payments land where they need to, or I help you apply with one of our financing partners right here in the office. Which one do you want to try first?

8.4 — Explicando el 3% Sin Pedir Disculpas

Cerrador al cliente

ES  Una cosa para que nada le sorprenda después: cuando cobramos con tarjeta, la compañía procesadora cobra una comisión, y ese tres por ciento es lo que nos cuesta. Aplica al enganche y a cada pago mensual, y está escrito en su acuerdo para que usted lo pueda ver. Si prefiere evitarlo, podemos ver otras formas de pago.

EN  One thing so nothing surprises you later: when we run a card, the processing company charges a fee, and that three percent is what it costs us. It is on the down payment and on each monthly payment, and it is written into your agreement so you can see it. If you would rather avoid it, we can look at other ways to pay.

8.5 — Urgencia de Cobranza (30 / 60 Días)

Cobranza al cliente

ES  Le contacto porque su cuenta está vencida. Quiero mantener su caso en marcha y evitar cualquier interrupción. Para proteger su caso necesitamos poner el saldo al día. Si la cuenta no se pone al corriente, el bufete tendrá que retirarse de su caso. ¿Podemos cobrar su tarjeta registrada hoy?

EN  I am reaching out because your account is past due. I want to keep your case moving and avoid any interruption. To protect your case we need to bring the balance current. If the account is not brought up to date, the firm will have to withdraw from your case. Can we run your card on file today?

9. Antes de Que el 3% Entre en Vigor — Para Gilda

Esta sección es una lista de verificación para implementar, no asesoría legal. El cargo del 3% es una práctica regulada con dimensiones federales, de redes de tarjetas y de responsabilidad profesional. Gilda tiene la última palabra, y el procesador debe confirmar la mecánica.

  • No se puede cobrar recargo a tarjetas de débito. La ley federal lo prohíbe sin importar la ley estatal, y buena parte de nuestros clientes paga con débito. Confirme con el procesador que el sistema distingue débito de crédito automáticamente, o el cargo se aplicará donde no debe.
  • Registro y aviso ante las redes de tarjetas. Visa y Mastercard exigen aviso anticipado al banco adquirente y a las redes antes de empezar a cobrar recargo, limitan el monto, y exigen que se informe al inicio de la transacción y en el recibo.
  • Texas. La ley estatal que prohibía el recargo fue suspendida por una corte federal, y por eso esto está disponible para nosotros. Confirme el estado actual antes de arrancar.
  • Texto del acuerdo de honorarios. El cargo de financiamiento de $299 y el 3% deben aparecer en el acuerdo de representación firmado, no solo en este documento. Un cargo que el cliente no aceptó por escrito es un problema sin importar lo que diga la política.
  • Contabilidad de fideicomiso. Confirme cómo se maneja el recargo sobre fondos que pasan por la cuenta de fideicomiso, y que el cargo quede registrado para que el libro mayor se mantenga limpio.
Orden de implementación
Los cambios de plazo, el piso de $500, la regla de máximo enganche y el cargo de financiamiento de $299 entran en vigor de inmediato. El cargo del 3% entra en vigor solo después de que Gilda apruebe el texto del acuerdo de honorarios y el procesador confirme el registro y el manejo de débito. No deje que el 3% detenga lo demás.

Aprobado para implementación. La Versión 2.0 reemplaza por completo a la Versión 1.0. Los planes de pago activos escritos bajo la Versión 1.0 conservan sus términos; esta política rige los contratos nuevos a partir de la fecha de vigencia.

Dueño: Dan DeLeon, Director de Operaciones  ·  Autoridad Final: Gilda McDowell, Abogada de Registro

Documento original en inglés. En caso de discrepancia entre versiones, la versión en inglés es la que rige.

Standard Operating Procedure · 🔒 Compliance & Confidentiality

Client Privilege & Confidentiality

Law Office of Gilda McDowell · Lubbock, Texas
FirmLaw Office of Gilda McDowell — Lubbock, Texas
OwnerGilda McDowell, Esq. (final legal authority) / Dan DeLeon, COO (enforcement)
Version1.0
Effective DateJuly 6, 2026
Applies ToEvery team member: attorney, staff, contractors, interns, vendors with case access
Review CycleAnnually, or immediately after any breach or new system rollout

1. Purpose

This SOP exists to protect the single asset our clients cannot get back once it is gone: their trust. Our clients are immigrant families whose safety, employment, and future in this country depend on their immigration status staying private. A confidentiality failure here is not a paperwork problem. It can put a real family at real risk.

This policy governs how every person at this firm handles client information: what it is, who can see it, how it moves, and what happens if it is mishandled. It applies whether you are on the phone, in the office, at home, or posting on social media.

2. What Counts as Confidential

Everything about a client's case is confidential unless the client has given written authorization to share it. This is broader than most people assume. Confidential information includes:

  • Immigration status and case type (even the fact that someone is a client of this firm)
  • Names, addresses, phone numbers, and any identifying documents (passports, birth certificates, IDs)
  • Case history, strategy, filings, and attorney notes
  • Financial information: fees paid, payment plans, income documentation
  • Family relationships, marital history, and any personal details shared during intake or consultation
  • Anything overheard in the office, waiting room, or on a call, even if you weren't the one handling the case
Standard
If you are not sure whether something is confidential, treat it as confidential. Silence is always the safe default.

3. Attorney-Client Privilege, In Plain Language

Attorney-client privilege is a legal protection that belongs to the client, not to the firm. It means communications between the client and Attorney McDowell (or the team acting on her behalf, under her supervision) cannot be forced into disclosure by a court, an opposing party, or a government agency, with narrow legal exceptions.

Two things every team member must understand:

  • Privilege only protects communication made for the purpose of getting legal advice. A hallway conversation about someone's case is not automatically privileged just because it happened at the office.
  • Privilege can be broken by carelessness. If confidential information is shared with someone outside the firm who does not need it, the protection can be lost, and it cannot be undone.

Only Attorney McDowell determines what is privileged in a legal dispute. If anyone (a subpoena, a process server, a government official, opposing counsel, a reporter) requests case information, the answer is always: "I am not able to discuss that. I will connect you with Attorney McDowell." No exceptions, no judgment calls in the moment.

4. The Family Member Trap

This is the single most common confidentiality mistake in immigration law, and it happens because families are close and well-meaning. A spouse, parent, adult child, or petitioner will call or walk in assuming they have full access to "their" case. Often they do not, legally, unless the client has authorized it in writing.

Standard for every team member:

  • Check the file for a signed release or authorization before discussing case details with anyone other than the client
  • If no authorization exists, say: "I understand you're involved and I want to help. I'm not able to share case details without [client name]'s written permission. Let's get that on file today."
  • Never confirm or deny that someone is a client to a person not listed as authorized, including other family members, employers, or landlords
  • Petition-based cases (fiancé visa, marriage-based adjustment of status, VAWA) carry extra sensitivity. In VAWA matters specifically, never disclose a client's status, location, or case existence to an abuser or their contacts under any circumstance
Red Flag
The client is whoever signed the engagement letter, not whoever is paying, not whoever is most involved, and not whoever calls first. Verify authorization before discussing anything, every time, even with immediate family.

5. Communication Standards

In the Office

  • No case discussions in the waiting room, hallway, parking lot, or anywhere a non-authorized person could overhear
  • Screens locked (Windows key + L) any time you step away from your desk
  • Client files, printed documents, or notepads with case details are never left visible on a desk when a visitor is present

Phone, Text, and WhatsApp

  • Verify identity before discussing case specifics on an inbound call. Do not assume the caller is who they say they are
  • Case details go through firm systems (GHL, firm phone lines, firm WhatsApp) only, never personal cell phones or personal social media
  • Never text or WhatsApp sensitive documents (passports, IDs, financial records) unless through an approved, encrypted firm channel

Email

  • Use the client's verified email on file. Do not CC or forward to unverified addresses, even if a family member requests it
  • Double-check the "To" field before sending anything with attachments. A misdirected email with a client's immigration documents is a reportable incident

Social Media and Personal Accounts

  • Never post, screenshot, or share anything from a client file, even with names removed, without written client consent and Dan's or Gilda's sign-off
  • Never discuss a case, even in general terms ("we won a big one today"), on personal social media

6. Digital and Physical File Security

AreaStandard
Case management system (GHL)Access limited to role-based permissions. No sharing of logins. Access is revoked same-day on any team member's exit.
Physical filesStored in locked file storage after hours. No case file leaves the office without Dan's or Gilda's approval.
Shared drives / cloud storageClient folders restricted to case team only. No downloading client documents to personal devices or personal cloud accounts (personal Google Drive, Dropbox, iCloud).
Printing / scanningPrinted client documents are picked up immediately, never left in a shared printer tray.
PasswordsUnique per system, never shared, never written on a sticky note at a desk.
DevicesFirm laptops and phones are password or biometric locked. No client data stored locally outside approved systems.

7. Marketing and Content Use

The firm actively markets through video, social media, blog posts, and testimonials. This makes confidentiality a marketing responsibility too, not just an intake responsibility.

  • No client story, testimonial, photo, or video is used in any marketing material (website, social media, HeyGen scripts, ads, blog posts) without a signed, written release from the client
  • Case studies and avatars used for internal training or content (Rosa Martinez, Carlos Rodriguez, etc.) are composite or anonymized personas, not real client identities, unless a real client has explicitly consented to be featured
  • Before/after case outcomes used in marketing must be generalized. Never publish specific dates, A-numbers, or details specific enough to identify a real matter without consent
  • Any team member producing content pulls from approved, de-identified templates. When in doubt, route through Dan before publishing

8. Third-Party and Referral Disclosures

Co-counsel, referring attorneys, translators, and outside agencies sometimes need case information to help a client. This is allowed only under these conditions:

  • A signed release or engagement authorization is on file naming the third party
  • The disclosure is limited to what that third party actually needs, not the full file
  • Gilda or Dan has confirmed the referral relationship is legitimate before information is sent

9. Breach Protocol

If confidential information is disclosed to the wrong person, sent to the wrong address, lost, or otherwise exposed, act immediately. Speed limits the damage.

  • Report it to Gilda and Dan the same day it is discovered. Do not wait, do not try to fix it quietly first.
  • Do not attempt to "undo" the disclosure yourself (do not call the recipient asking them to delete something without Gilda's direction on how that call should go)
  • Document what happened: what was disclosed, to whom, when, and how it was discovered
  • Gilda determines whether client notification, a corrective filing, or a bar reporting obligation applies. This is always her call, not a staff-level decision
Standard
A reported mistake, handled fast and honestly, is a fixable problem. A hidden mistake is how a fixable problem becomes a client's life-altering emergency.

10. Confidentiality After Employment Ends

Confidentiality obligations do not end when someone leaves the firm, voluntarily or otherwise. On exit:

  • All system access (GHL, email, shared drives, firm phone lines) is revoked same-day
  • All physical files and devices are returned before final pay is issued
  • The obligation to never disclose client information continues permanently, with no expiration date

11. Accountability and Enforcement

Confidentiality is not optional and is not weighted by role or seniority. Every team member signs this SOP as a condition of access to client information.

ViolationResponse
Accidental, low-risk disclosure (caught and reported immediately)Documented coaching conversation with Dan. Retraining on the relevant section.
Careless handling with client risk (unreported, or discovered rather than disclosed)Formal written warning. Immediate retraining. Gilda notified.
Willful or repeated violation, or any disclosure that endangers a clientGrounds for immediate termination and potential bar or legal reporting obligations.

12. Acknowledgment

I have read and understood this Client Privilege & Confidentiality SOP. I understand that confidentiality protects real families and that violations carry serious consequences, up to and including termination.

Name (print)
Signature
Date
Law Office of Gilda McDowell · Client Privilege & Confidentiality SOP · Version 1.0 · Effective July 6, 2026 · Final authority: Gilda McDowell, Esq.