WIP & AR Aging: The Hidden Balance Sheet in Your Law Firm (DLRI™)

Why your firm’s most important balance sheet isn’t in the GL—and how Dawgen Global’s Legal Revenue Intelligence (DLRI™) turns Work-in-Progress and Accounts Receivable into cash velocity, pricing power, and durable EBITDA.

Every law firm has two balance sheets:

1. the one your auditors sign; and

2. the hidden balance sheet made of Work-in-Progress (WIP) and Accounts Receivable (AR)—unbilled time, unpriced scope, and unpaid invoices sitting outside your cash account.

Firms obsess over hours and rack rates, yet under-manage WIP/AR aging, where margin quietly evaporates as write-downs, write-offs, discounts, and DSO creep. This article shows how to operationalize WIP and AR as living assets—measured daily, converted quickly, and governed with discipline—using Dawgen Global Legal Revenue Intelligence (DLRI™).

You’ll get a practical playbook: definitions that matter, KPIs that move cash, dashboards that surface risk, and role-based cadences that shrink aging buckets. The payoff: faster cash, higher realization, lower write-offs, and 3–4 pts of EBITDA lift—without more headcount.

1) What WIP and AR Really Are (And Why They Matter)

• WIP (Work-in-Progress): Approved, recorded time and matter costs not yet billed. WIP aging reflects billing cadence, scoping discipline, and narrative quality.

• AR (Accounts Receivable): Billed invoices not yet collected. AR aging signals pricing integrity, e-billing hygiene, dispute handling, and client credit risk.

Together, WIP + AR = the “cash-to-be” pipeline. When this pipeline ages, three things happen:

1. Realization falls (pre-bill write-downs to “make it easier”).

2. Write-offs rise (bad debt on old invoices).

3. Cash velocity slows (DSO increases)—which constrains hiring, investment, and partner draws.

DLRI™ treats WIP/AR as managed assets, not accounting afterthoughts: it tracks both at client, matter, lawyer, practice, and case type levels, with alerts and playbooks to move value forward.

2) The Aging Framework (Buckets, Definitions, and Why They’re Different)

2.1 WIP Aging Buckets

• 0–15 days: Healthy capture; aim to pre-bill/submit quickly for long matters.

• 16–30 days: Normalizing; pre-bill reviews should start here.

• 31–60 days: Warning—scope confirmation and narrative clean-up.

• 60–90 days: High risk of write-downs.

• 90+ days: Value at risk—force a decision: bill, change order, or write off.

2.2 AR Aging Buckets

• 0–30 days: “In process” per client AP cycles.

• 31–60 days: Early follow-ups; confirm approvals and documentation.

• 61–90 days: Escalate; investigate dispute codes.

• 90+ days: Bad-debt territory—activate stop-work or payment plans per terms.

Key idea: WIP and AR are different problems. WIP is a pricing & billing discipline problem. AR is a collections & client process discipline problem. Manage them with different playbooks—and connect them via DLRI.

3) The Few KPIs That Change Outcomes

• WIP Days = (Average WIP ÷ Daily RB)

• WIP >60 Days (% of WIP) — leading indicator of future write-downs

• AR Days (DSO) = Average AR ÷ (RB / Days)

• AR >60 Days (% of AR) — leading indicator of write-offs

• First-Pass Acceptance (FPA) — % invoices accepted without e-billing rejection (target ≥ 95%)

• CEI (Collection Effectiveness Index) = (Beg AR + RB − End AR − Write-offs) ÷ (Beg AR + RB − End AR)

• Realization % = RB ÷ SB (standard billings)

• Write-off % = Write-offs ÷ RB (target < 0.8%)

DLRI™ renders these as heatmaps and waterfalls:

• WIP → Draft Invoice → Submitted (FPA) → Accepted → Collected, with time-in-stage and drop-off reasons so you can fix bottlenecks, not blame people.

4) Where the Aging Comes From (Root-Cause Map)

WIP Aging Drivers

1. Late or vague time narratives → partner delays at pre-bill

2. Unpriced scope creep → matter leads hesitate to bill

3. Rate/discount uncertainty → stalled approvals

4. Missing documentation for e-billing (LEDES, POs, exhibits)

AR Aging Drivers

1. Submission errors → rejection → resubmission → weeks lost

2. Ambiguous engagement terms (cadence, dispute window, approvers)

3. Slow dispute routing (no owner, unclear code)

4. Reactive follow-up (no cadence, no PTP commitments)

5. Credit-term misfit (Tier-C clients with 45–60 day terms and no retainer)

DLRI™ pairs each driver with a detector (metric/alert) and a corrector (playbook/SLA), turning post-mortems into pre-emptive actions.

5) DLRI’s WIP Command Center (From Time to Bill)

Core views:

• WIP Aging Heatmap by practice, partner, client, matter

• Narrative Quality Score (lexical checks for specificity/forbidden filler)

• Scope Variance Alerts at 85/95/105% of budget (change-order prompts)

• Pre-Bill Queue prioritized by aging, size, and client tier

• Rate/Discount Guardrails with approval routing

Weekly actions:

1. Daily time certs by 10 a.m. next day; coach chronic late entries.

2. Pre-bill sprints for WIP >30 days; narratives cleaned; attachments ready.

3. Change-order proposals within 48 hours when variance triggers fire.

4. Bi-weekly billing on long matters to reduce WIP stack and smooth cash.

Result: WIP converts faster, with fewer write-downs, because scope and pricing are decided in-matter, not forgiven post-hoc.

6) DLRI’s AR Command Center (From Bill to Cash)

Core views:

• AR Aging Tree (0–30, 31–60, 61–90, 90+) with CEI/DSO overlays

• FPA Funnel with rejection codes (LEDES errors, missing PO, narrative gaps)

• PTP (Promise-to-Pay) Kept % by collector and client

• Dispute Queue with owner, code, and SLA timer

• Escalation Matrix by client tier and invoice age

Weekly cadence (CEI Huddle, 20–30 mins):

• Top 20 clients by RB/AR exposure

• Red items >60 days: identify code, assign owner, set next action (PTP or resubmit)

• Track FPA: who needs narrative coaching; which clients need doc templates

• Confirm bi-weekly billing for long matters; align on stop-work triggers per terms

Result: AR resolves earlier; DSO drops, CEI rises, and write-offs shrink.

7) The Policy Engine Behind the Numbers

7.1 Engagement Terms (Lock In the Win)

• Cadence (monthly/bi-weekly), dispute window (10 days), approver name/title

• E-billing/LEDES format, required attachments (POs, timesheets, deliverables)

• Credit terms by tier (A: 30 days; B: 30–45; C: deposits/retainers, milestone billing)

• Stop-work clause for invoices >X days

7.2 Discount & Change-Order Governance

• Discount guardrails (≤5% matter lead; 6–10% practice leader; >10% CFO)

• Scope triggers (85/95/105%) → CO in 48 hours with options (proceed, defer, phased)

7.3 E-Billing Clean-Room

• LEDES pre-check before client portal submission

• Narrative guide (ban filler; require outcome/result context)

• Attachment checklist; FPA tracked and coached

DLRI encodes these rules so “policy” becomes workflow, not folklore.

8) Tactical Playbooks (Copy-Ready)

8.1 Pre-Bill Email to Client (Scope Alignment)

Subject: Scope alignment prior to invoice – Matter {{ID}}
Hi {{Name}}, we’re at 95% of the agreed phase budget. Two additional workshops were requested. Options:
A) Proceed now (+{{$}} / +{{hours}}) with delivery unchanged.
B) Defer non-critical items to Phase 2 (no budget impact).
C) Compressed timeline (+{{$}}) to meet your new filing date.
Please confirm your preference today so we can keep momentum.

8.2 E-Billing Resubmission (FPA Focus)

“Resubmitting Invoice #{{ID}} with LEDES corrections and attached PO. Narratives specify outcomes per task. Please confirm receipt and approver routing.”

8.3 Collector’s Day-10 Call (PTP)

“Just confirming Invoice #{{ID}} is with {{Approver}}; any docs missing? If in the payment queue, can we log a promise-to-pay date to align staffing on your matter?”

8.4 Partner Escalation (Aging >60)

“Per terms, invoices older than 60 days pause new work. Let’s align on a payment schedule or net a partial payment to avoid disruption.”

9) AFAs and Aging—Design to Prevent Friction

• Fixed Fee + Milestones: Bill on deliverables; lower AR disputes; WIP doesn’t pile up.

• Capped Fee: Track burn; trigger change orders at 85/95/105%; avoid end-of-matter surprises.

• Retainer/Subscription: Entitlements + monthly fee; reconcile quarterly; overages at banded rates.

• Success Fee: Combine with base billing; define objective triggers; avoid retro renegotiation.

DLRI’s simulator models cash curves and aging risk for each AFA—choose the structure that protects both relationship and velocity.

10) Forecasting: Seeing Cash Before It Arrives

DLRI’s driver-based model:

1. Expected RB = Hours × Rate × Realization (pipeline + active matters)

2. Cash Timing = Client cadence + FPA probability + PTP dates

3. Forecast CC = RB × Collection % (learned per client/tier) with lag patterns

Leadership uses this to plan draws, taxes, hiring, and debt service—with fewer surprises.

11) Case Vignette (Composite)

Context: 100-lawyer firm; respectable growth but thin cash.

• WIP >60 days: 34% (heavy in litigation)

• AR >60 days: 29%

• FPA: 89%

• DSO: 59 days; CEI: 90%

• Write-offs: 1.3% of RB

DLRI Interventions:

• Turned on WIP command center with pre-bill queue and narrative scoring.

• Instituted 85/95/105% scope triggers; 48-hour change-order SLA.

• Centralized LEDES pre-check; narrative guide; FPA leaderboard.

• Launched weekly CEI huddles; set tiered credit terms; enforced stop-work at 75/90 days.

• Shifted long matters to bi-weekly billing.

Outcomes in two quarters:

• WIP >60 down to 18%; AR >60 down to 16%

• FPA +7 pts (to 96%); DSO −11 days; CEI +3 pts (to 93%)

• Write-offs −40%; EBITDA +3.3 pts

• Client feedback: clearer expectations, faster clarifications, fewer surprises.

12) 90-Day Implementation Blueprint

Days 1–15 — Define & Baseline

• Approve aging buckets, targets, and policies (cadence, dispute window, approvals).

• Baseline WIP/AR by practice/partner/client in DLRI.

• Publish discount guardrails and scope triggers.

Days 16–45 — Instrument

• Turn on WIP command center and pre-bill queue.

• Enable LEDES pre-check and narrative scoring.

• Configure CEI huddle with top 20 clients; set escalation paths.

• Load AFA library and change-order templates.

Days 46–75 — Pilot

• Pilot bi-weekly billing in two practices.

• Enforce 48-hour CO SLA; 72-hour dispute SLA.

• Track FPA, PTP kept %, WIP/AR >60 weekly.

Days 76–90 — Scale & Govern

• Roll firmwide; publish role scorecards (partner, billing, collector).

• Align incentives: tie a slice of partner/collector comp to CEI/DSO, FPA, and WIP/AR >60 reduction.

• Add cash forecasting to monthly management pack.

13) What “Great” Looks Like (Targets to Tailor)

• WIP Days: Align with cadence; strive for < 30–35 on average

• WIP >60 Days: < 15% of WIP (single digits in disciplined practices)

• DSO: ≤ 45 days (elite: high 30s)

• AR >60 Days: < 15% of AR

• FPA: ≥ 95%

• CEI: ≥ 92% firmwide; ≥ 95% Tier-A book

• Write-offs: < 0.8% of RB

These are directional; DLRI™ calibrates to your history and mix.

14) FAQs

Q: Will stricter stop-work clauses harm relationships?
A: Applied consistently and tied to clear terms, they protect relationships by avoiding silent scope creep and last-minute crises. Pair stop-work with options (partial payment plan, phased delivery) to keep goodwill.

Q: Our clients have slow approval cycles—can we really change DSO?
A: Yes. Clean submissions (FPA), earlier cadence (bi-weekly), and PTP commitments materially reduce AR days—even within fixed AP cycles.

Q: We’re unique; templates won’t fit.
A: Templates anchor the economics (hours, roles, cadence, triggers). Partners still exercise judgment—now with evidence and shared language.

Q: Isn’t this just more admin?
A: DLRI automates detection and prompts. Teams decide, not spreadsheet. Most firms reclaim admin time by avoiding rework and rejections.

Make the Hidden Balance Sheet Work for You

Your hours create potential; your hidden balance sheet turns that potential into reality—or traps it in aging buckets. When you manage WIP and AR as deliberate assets—pricing scope early, billing cleanly, collecting predictably—you gain cash velocity, pricing power, and partner confidence. DLRI™ is the operating system that makes this routine, firmwide, every week.

Next Step: Convert Your Hidden Balance Sheet to Cash

Let’s deploy DLRI™ to stand up your WIP & AR Command Centers, tighten cadences, and install the governance that keeps aging low and margins high.

Email: [email protected]
WhatsApp (Global): +1 555 795 9071

We’ll baseline your WIP/AR aging, enable pre-bill and CEI huddles, and pilot bi-weekly billing—so your pipeline moves faster, disputes shrink, and cash becomes a predictable outcome, not a monthly surprise.

About Dawgen Global