ROI Calculator

This spreadsheet quantifies the cash impact of fixing your billing and collections process. Input three numbers - your current AR aging, average invoice value, and collection rate - and get a dollar figure for how much working capital you're leaving on the table.

Most professional services firms operate with 45-60 day DSO (Days Sales Outstanding) and 85-90% collection rates. Tightening this to 30-35 days and 95%+ collection unlocks immediate cash without landing new clients or raising rates.

Days Sales Outstanding (DSO)
How long it takes to convert a completed project into cash in your bank account. Calculate it: (Accounts Receivable ÷ Total Credit Sales) × Number of Days.

If your AR balance is $500K and you bill $2M annually, your DSO is ($500K ÷ $2M) × 365 = 91 days. That's three months of working capital tied up in unpaid invoices.

Average Invoice Value
Your typical invoice amount. Pull this from your practice management system (Clio, QuickBooks, or similar). If you bill hourly, multiply your average hourly rate by typical project hours. For fixed-fee work, use your standard engagement size.

Collection Rate
Percentage of invoiced dollars you actually collect within 90 days. Not what clients promise to pay - what hits your account. Calculate it: (Cash Collected in 90 Days ÷ Total Invoices Issued 90 Days Ago) × 100.

A 90% collection rate means you write off or delay 10% of every dollar you bill. On $2M in annual billings, that's $200K in lost revenue.

Step 1: Pull Your Current Numbers

Open your accounting system and extract these figures for the last 90 days:

• Total accounts receivable balance (aging report)
• Total credit sales for the period
• Total cash collected from invoices issued 90 days ago
• Number of invoices issued
• Total dollar value of those invoices

Calculate your current DSO, average invoice value, and collection rate using the formulas above.

Step 2: Input Baseline Metrics

Enter your current performance in the calculator:

• Current DSO: [Your calculated number]
• Average Invoice Value: [Your calculated number]
• Current Collection Rate: [Your calculated percentage]
• Annual Billing Volume: [Total credit sales × 4 for quarterly data, or your actual annual figure]

Step 3: Set Realistic Improvement Targets

Conservative targets for most firms:

• DSO Reduction: Cut 15-20 days in 90 days by implementing automated invoice delivery and weekly AR review meetings
• Collection Rate Improvement: Increase 5-7 percentage points by adding payment links to invoices and calling on day 31 instead of day 60
• Invoice Value Optimization: Increase 10-15% by bundling services, moving to value-based pricing, or eliminating scope creep

Enter your target metrics:

• Target DSO: [Current DSO minus 15-20 days]
• Target Collection Rate: [Current rate plus 5-7 points]
• Target Invoice Value: [Current value × 1.10 to 1.15]

Step 4: Analyze the Output

The calculator displays:

• Current Annual Cash Flow: Working capital available under current performance
• Optimized Annual Cash Flow: Projected working capital after improvements
• Net Cash Flow Improvement: Additional dollars available for operations, hiring, or growth
• Payback Period: How long it takes for process improvements to pay for themselves

Midwest IP law firm, 12 attorneys, $4.2M annual billings:

Current State:

• DSO: 67 days
• Average Invoice: $8,500
• Collection Rate: 87%
• Annual Cash Flow Impact: $3.65M

90-Day Improvement Plan:

• Switched from monthly to bi-weekly invoicing (reduced DSO to 48 days)
• Added Stripe payment links to all invoices (increased collection rate to 94%)
• Implemented value-based pricing for trademark portfolios (increased average invoice to $9,800)

Results After 90 Days:

• DSO: 48 days (19-day improvement)
• Average Invoice: $9,800 (15% increase)
• Collection Rate: 94% (7-point improvement)
• Annual Cash Flow Impact: $4.87M

Net Improvement: $1.22M in additional working capital

This firm used $400K of that improvement to hire two associates and invest in practice management software. The remaining $820K reduced their line of credit balance, saving $65K annually in interest expense.

DSO Below 35 Days
You have a tight billing and collections process. Clients pay quickly, invoices go out immediately after work completion, and follow-up is systematic.

DSO 35-50 Days
Industry average for professional services. Room for improvement, but not a crisis. Focus on automating invoice delivery and adding payment options.

DSO Above 50 Days
You're operating a bank for your clients. Every day above 50 represents cash you've earned but can't use. Priority fix: implement weekly AR aging reviews and assign collection responsibility.

Collection Rate Above 95%
Excellent. You have clear engagement letters, regular client communication, and systematic follow-up on overdue invoices.

Collection Rate 90-95%
Acceptable but improvable. Likely losing revenue to scope creep, unclear billing terms, or delayed follow-up on aging invoices.

Collection Rate Below 90%
Significant revenue leakage. Common causes: poor engagement letters, surprise invoices, weak collections process, or taking on clients with payment issues.

Use these specific actions to hit your target metrics:

To Reduce DSO:

• [ ] Invoice within 24 hours of work completion (not end of month)
• [ ] Send invoices via email with PDF attachment and payment link
• [ ] Set up automated reminders at 7, 14, and 21 days past due
• [ ] Assign one person to review AR aging every Monday morning
• [ ] Call clients with invoices 30+ days outstanding (don't just email)

To Improve Collection Rate:

• [ ] Add Stripe, LawPay, or similar payment processor to invoices
• [ ] Require 50% retainer before starting work on engagements over $10K
• [ ] Include payment terms in engagement letter (not just on invoice)
• [ ] Stop work immediately when retainer balance hits $500
• [ ] Review client payment history before accepting new matters

To Increase Average Invoice Value:

• [ ] Bundle related services into fixed-fee packages
• [ ] Eliminate scope creep with clear change order process
• [ ] Move top 20% of clients to value-based pricing
• [ ] Increase hourly rates 8-12% annually
• [ ] Add project management fee (10-15% of professional fees)

Mistake 1: Using Accrual Accounting Numbers
The calculator needs cash basis figures. If you bill $100K but only collect $85K, your collection rate is 85%, not 100%.

Mistake 2: Setting Unrealistic Targets
Cutting DSO from 60 to 20 days requires fundamental business model changes (retainers, subscriptions, or prepayment). Set 90-day targets you can actually hit with process improvements.

Mistake 3: Ignoring Implementation Costs
Improving collections requires time investment. Budget 5-8 hours per week for the first 90 days: AR review meetings, client calls, process documentation, and system setup.

Mistake 4: Calculating ROI Without Action Plan
The calculator shows potential improvement. You need a specific implementation plan with assigned owners and weekly check-ins to realize that potential.

Once you improve cash flow, deploy it strategically:

Option 1: Reduce Debt
Pay down lines of credit or term loans. Every dollar of debt reduction saves 6-12% annually in interest expense.

Option 2: Build Cash Reserves
Target 3-6 months of operating expenses in reserves. This eliminates the need for emergency borrowing and provides flexibility for opportunistic investments.

Option 3: Invest in Growth
Hire additional fee earners, upgrade technology, or expand service offerings. Calculate payback period before committing capital.

Option 4: Improve Compensation
Increase associate salaries, add performance bonuses, or enhance benefits. Retention of top performers typically delivers 3-5x ROI compared to recruiting replacements.

Access the spreadsheet template with pre-built formulas and example scenarios at workforceplaybook.ai/resources/roi-calculator.

The template includes three tabs:

• Input Sheet: Enter your current and target metrics
• Results Dashboard: Visual display of cash flow improvement
• Implementation Tracker: 90-day action plan with weekly milestones

Customize the formulas for your specific billing model, client mix, and practice area economics.