Skip to main content
Financial Management

Financial Dashboard for Solo Attorneys: Revenue, AR, and Profitability at a Glance

Most solo attorneys track finances by checking their bank balance. Here's how to build a financial dashboard that shows revenue, AR, and profitability in real time.

ModernLawOfficeMarch 15, 202613 min read

Ask most solo attorneys how their practice is doing financially and you'll get one of two answers: a glance at their bank balance, or a vague sense that things are "okay" based on how busy they feel. Neither is a financial strategy. Being busy doesn't mean you're profitable. A healthy bank balance today doesn't mean you can cover next quarter's expenses.

A financial dashboard changes this by putting the numbers that actually matter in one place, updated in real time, so you can make decisions based on data instead of instinct. You don't need an MBA or a CFO to read a dashboard. You need five or six key numbers, presented clearly, reviewed regularly. This guide covers what those numbers are, how to track them, and how to use them to make better decisions about your practice.


Why Attorneys Avoid Financial Tracking

Before building the dashboard, it's worth understanding why most solo attorneys don't track their finances systematically. The barriers are predictable:

They didn't learn it in law school. Law school teaches legal analysis, not business management. Most attorneys graduate with no training in financial management, accounting, or business metrics. The result is a knowledge gap that feels embarrassing to acknowledge and overwhelming to fill.

The numbers feel scary. When you don't look at your finances regularly, looking at them becomes an anxiety-producing event. You avoid it because you're afraid of what you'll see. This creates a feedback loop: the less you look, the more anxious you feel, and the less you look.

The tools feel complex. QuickBooks, Xero, and practice management financial modules all have learning curves. When you're already stretched thin, learning new software feels like a luxury you can't afford. So you default to checking your bank balance and hoping for the best.

It feels like "business stuff," not "lawyer stuff." Many attorneys identify primarily as practitioners, not business owners. Financial tracking feels like it belongs in someone else's job description. But if you're a solo practitioner, there is no one else.

The dashboard approach solves most of these problems by reducing financial management to a single view with a handful of numbers. You don't need to become an accountant. You need to know five things and check them weekly.


The Five Numbers Every Solo Attorney Must Track

A useful financial dashboard for a solo practice focuses on these five core metrics. Everything else is useful context, but these five are non-negotiable.

1. Revenue Collected (Not Billed)

What it is: The actual money that has landed in your operating account in a given period (month, quarter, year).

Why it matters: Revenue billed is theoretical. Revenue collected is real. The gap between the two — your collection rate — tells you whether your billing and payment systems are working. Many attorneys track what they've billed and feel good about the number without noticing that 15% of it never converts to cash.

How to track it: Your accounting software (QuickBooks, Xero, or even a well-maintained spreadsheet) should show total deposits to your operating account by period. Exclude trust account deposits — those aren't your money yet.

What to look for: Trends over time are more useful than any single month's number. Is revenue collected growing, flat, or declining? Seasonal patterns are normal (many practice areas have predictable slow periods), but a sustained decline requires investigation.

2. Accounts Receivable Aging

What it is: The total amount of invoices outstanding, broken into aging buckets: 0-30 days, 31-60 days, 61-90 days, and over 90 days.

Why it matters: AR aging tells you whether your collection process is working and flags problem accounts before they become write-offs. A growing AR balance — especially in the 60+ day buckets — means you're doing work but not getting paid for it.

How to track it: Most practice management systems generate AR aging reports. If yours doesn't, your accounting software will. Pull this report weekly.

What to look for: The ratio of current AR (0-30 days) to aged AR (60+ days) should be heavily weighted toward current. If more than 20% of your AR is in the 60+ day buckets, your collection process needs immediate attention.

Tip

Set a calendar reminder to review your AR aging report every Monday morning. It takes five minutes and it's the single most impactful financial habit a solo attorney can build. Problems that are visible early are fixable. Problems discovered at 90+ days are often write-offs.

3. Effective Hourly Rate

What it is: Your total revenue collected divided by your total hours worked (all hours, not just billable hours).

Why it matters: This is the number that tells you what your time is actually worth — including the time you spend on administration, marketing, billing, and everything else that doesn't generate a direct bill. It's almost always lower than your hourly rate, sometimes shockingly so.

How to track it: Total revenue collected in a period / Total hours worked in that period. Be honest about the hours — include evenings and weekends if you're working them.

What to look for: If your billing rate is $300/hour and your effective hourly rate is $120/hour, you're spending 60% of your time on non-billable activities. That's not unusual for a solo practitioner, but it highlights the value of delegating administrative tasks, automating workflows, or restructuring your fee arrangements.

For flat-fee practitioners, effective hourly rate is even more critical. It tells you whether your flat fees are priced correctly. If your effective hourly rate on flat-fee matters consistently comes in below your target, your fees need to increase.

4. Monthly Overhead (Fixed Costs)

What it is: The total monthly cost of running your practice regardless of revenue: rent, software subscriptions, insurance, bar dues (amortized monthly), phone, internet, and any regular payments.

Why it matters: Your overhead is your breakeven threshold. You need to collect at least this amount each month before you earn a dollar of profit. Knowing this number precisely removes the anxiety of "am I making enough?" and replaces it with a clear target.

How to track it: List every recurring expense. Include annual expenses divided by 12 (malpractice insurance, bar dues, CLE). Include estimated taxes if you want a true all-in picture. Update the list quarterly to catch new subscriptions or price increases.

What to look for: Your overhead-to-revenue ratio. If your monthly overhead is $5,000 and your average monthly collected revenue is $15,000, your overhead ratio is 33% — meaning 33 cents of every dollar goes to keeping the lights on. For a solo practice, keeping this under 40% is a reasonable target. Under 30% is strong.

5. Cash Runway

What it is: The number of months you could continue operating your practice with zero new revenue, based on your current operating account balance and monthly overhead.

Why it matters: Cash runway is your safety margin. It determines how much risk you can absorb — a slow month, a client who doesn't pay, an unexpected expense, or a period where you need to step away from the practice.

How to track it: Operating account balance / Monthly overhead = Months of runway.

What to look for: A minimum of three months' runway is a reasonable baseline for a solo practice. Six months is comfortable. Less than two months means you're operating with essentially no safety margin, and any disruption — illness, a lost client, a bar complaint — could create a cash crisis.

Warning

Do not count trust account funds in your cash runway calculation. Trust funds are your clients' money, not yours. Using IOLTA funds to cover operating expenses is an ethics violation that can result in suspension or disbarment.


Building Your Dashboard: Tools and Setup

You don't need specialized dashboard software. You need a single place where these five numbers are visible at a glance.

Option 1: Spreadsheet Dashboard

A Google Sheet or Excel workbook with a summary tab works for many solo practitioners. Create a single sheet with:

  • Current month revenue collected (updated as deposits clear)
  • AR aging buckets (updated weekly from your billing system)
  • Effective hourly rate (calculated monthly)
  • Monthly overhead total (updated quarterly)
  • Cash runway (calculated from current bank balance)

Add a simple chart showing monthly revenue collected over the past 12 months. Trend lines are more useful than individual data points.

Pros: Free, fully customizable, no learning curve. Cons: Manual data entry, risk of falling behind on updates.

Option 2: Practice Management Reports

If your practice management software includes financial reporting — and most modern platforms do — use its built-in dashboards. Configure the home screen or reports section to show your five key metrics.

Pros: Data is automatically pulled from your billing and time tracking. No manual entry. Cons: May require configuration. May not show all five metrics in one view.

Option 3: Accounting Software Dashboard

QuickBooks and Xero both offer dashboard views that show revenue, expenses, and cash position. Combined with AR aging reports from your billing system, this gives you most of what you need.

Pros: Accurate financial data, automatic bank feed integration. Cons: Doesn't include effective hourly rate or billable hours data without integration.

Option 4: Dedicated Dashboard Tool

Tools like Google Looker Studio (free) or similar can pull data from multiple sources and create a unified dashboard. This is the most powerful option but requires initial setup time.

Pros: Can combine data from practice management, accounting, and time tracking into a single view. Cons: Setup time. May require connecting APIs or exporting data.

For most solo attorneys, Option 1 (spreadsheet) or Option 2 (practice management reports) is the right starting point. Don't let the pursuit of a perfect dashboard prevent you from tracking these numbers at all.


Reading Your Dashboard: What the Numbers Tell You

Having the numbers is step one. Knowing what to do with them is step two.

Revenue Is Flat But You're Busier Than Ever

This usually means one of three things: your effective hourly rate is declining (you're doing more work for the same money), your collection rate is dropping (you're billing more but collecting less), or you're spending more time on non-billable work. Your dashboard will show which one by comparing effective hourly rate and AR aging trends alongside revenue.

AR Is Growing Faster Than Revenue

If your AR balance is increasing while revenue collected is flat or declining, your collection process is failing. You're doing work and not getting paid. Immediate actions: review all invoices over 60 days, implement systematic follow-up, and consider requiring retainers for new matters.

Overhead Is Creeping Up

Software subscriptions, incremental service upgrades, and "small" monthly expenses compound over time. Review your overhead line items quarterly and cancel anything that isn't delivering clear value. A common pattern: attorneys subscribe to tools during a promotional period, stop using them, and continue paying for months or years.

Cash Runway Is Shrinking

If your runway is declining even though revenue looks stable, your expenses are growing faster than your collections. This is a warning sign that requires immediate attention — either increase revenue (raise rates, take on additional matters, improve collection rate) or reduce expenses.

Revenue Is Seasonal

Many practice areas have predictable patterns. Tax attorneys are busy in spring. Family law attorneys see spikes around January and September. Knowing your seasonal pattern lets you plan for lean months instead of panicking through them. Build reserves during peak months to smooth out the valleys.


The Weekly Financial Review

A dashboard only works if you look at it. Schedule a 15-minute weekly review — the same day and time each week — and make it a non-negotiable appointment.

Monday morning works well. Before you dive into the week's work, spend 15 minutes reviewing your numbers:

  1. Check revenue collected this month vs. target. Are you on pace?
  2. Review AR aging. Any new invoices moving into the 60+ day bucket? Take action on those today.
  3. Glance at cash runway. Any changes that need attention?
  4. Note anything unusual. A large payment received, a large new AR balance, an unexpected expense.

That's it. Fifteen minutes. The goal isn't deep analysis — it's awareness. When you know your numbers weekly, problems are small and fixable. When you check quarterly, problems are large and stressful.


Advanced Metrics (When You're Ready)

Once you're consistently tracking the five core metrics, consider adding these for deeper insight:

Revenue by practice area. If you practice in multiple areas, knowing which ones generate the most revenue (and which have the best collection rates) helps you make strategic decisions about where to focus.

Revenue by client. Client concentration risk is real. If one client represents more than 25% of your revenue, losing that client would be devastating. Diversification is a strategic priority.

Realization rate. The percentage of your worked time at standard rates that you actually bill. Low realization means you're doing work you're not billing for — either intentionally (write-downs before invoicing) or unintentionally (not tracking time accurately).

Cost of client acquisition. If you spend money on marketing (advertising, directories, networking events), knowing what each new client costs to acquire helps you evaluate which channels are worth the investment.

Profit margin. Revenue collected minus all expenses (including a reasonable salary for yourself) divided by revenue collected. This tells you whether your practice is truly profitable or whether you're just paying yourself from revenue without building any business value.


Common Mistakes

Tracking too many metrics. A dashboard with 20 numbers is a spreadsheet, not a dashboard. Start with five. Add more only when you're consistently using the first five to make decisions.

Confusing revenue billed with revenue collected. These are different numbers with different implications. Revenue billed is a promise. Revenue collected is reality. Always build your financial picture on collections, not billings.

Ignoring the numbers when they're bad. The whole point of a dashboard is early warning. A declining metric is not a reason to stop looking — it's a reason to take action. The numbers aren't the problem. The underlying business issue is the problem. The numbers are just telling you about it.

Not sharing with your accountant. Your accountant should see your dashboard at your quarterly check-in. They can spot issues you might miss and provide context for trends you're seeing. A dashboard shared with your accountant also makes tax time significantly easier.


Getting Started Today

You can build a functional financial dashboard in under an hour. Here's the minimum viable version:

  1. Open a new spreadsheet. Create five rows: Revenue Collected (MTD), AR Total, Effective Hourly Rate, Monthly Overhead, Cash Runway.
  2. Fill in current numbers. Check your bank account, pull your AR report, estimate your hours for the month, list your recurring expenses.
  3. Set a Monday morning calendar reminder: "15-min financial review."
  4. Update the numbers weekly.

That's it. No software to buy, no system to learn, no consultant to hire. Five numbers, reviewed weekly, will give you more financial clarity than most solo attorneys have ever had. The bar for improvement is low because the starting point for most solo practices is "I check my bank balance and hope for the best."

You're running a business. These are your business's vital signs. Check them.

Early Access

Join the Waitlist

Be first to access ModernLawOffice when we launch — built for solo attorneys and small firms.