Your bookkeeper gives you a P&L every month. You look at it. You nod. You have no idea what it means.
Sound familiar?
You see revenue went up; that seems good. Expenses went up too; that seems less good? Net income is positive; probably fine? Then you go back to running your business and hope everything works out.
This isn't financial visibility. It's financial guessing.
The P&L tells you what happened last month. That's useful for taxes and historical records, but it's useless for running a business. By the time you see it, the decisions that shaped those numbers are weeks behind you.
What you actually need: Dashboards that show you what's happening right now and what's about to happen next.
I've worked with practice owners across construction, dental, medical, and legal for over a decade. The ones who thrive don't necessarily work harder or have better luck: they have better visibility. They make decisions based on data, not gut feel.
Here are the five dashboards that give you that visibility, plus exactly how to build them.
Key Takeaways
- Your P&L tells you what happened. Dashboards tell you what's happening now and what's about to happen next. That's the difference between reacting and planning.
- Start with the Cash Flow Dashboard. A 13-week rolling forecast is the single most valuable financial tool you can build. Everything else builds on it.
- Not all revenue is equal. The Profitability Dashboard shows which service lines actually make money — you might be losing cash on your busiest offerings.
- KPIs predict the future. Revenue per employee, LTV:CAC ratio, and utilization rates are early warning systems that spot problems 3-6 months before they hit your P&L.
- Structural health matters. Current ratio, debt-to-equity, and DSO reveal whether your business can survive a slow period or land a big contract.
- You don't need all five immediately. Start with Cash Flow. Add Profitability after a month. In 90 days, you'll have visibility that puts you ahead of 95% of business owners.
Table of Contents
The Cost of Flying Blind
Before we get into the dashboards, let's talk about what happens when you don't have them.
- You miss opportunities. A contractor I worked with had $150K sitting in AR that was technically overdue but nobody was tracking. That cash could have funded equipment purchases, taken on a new crew, or reduced line of credit interest. Instead, it just sat there.
- You make decisions based on feelings. "We're busy" isn't the same as "we're profitable." A dental practice I met was booking patients 6 weeks out and assumed everything was great. Turns out, two of their service lines were running at negative margins. They were losing money faster the busier they got.
- You react instead of plan. Without visibility, every financial surprise is a crisis. Payroll gets tight. Cash runs short. You scramble to fix things that shouldn't have been problems in the first place.
I documented one of the worst cases I've seen in Why Profitable Businesses Fail: Understanding the Cash Flow Gap. Busy company. Full schedule. Bleeding cash anyway. The issue wasn't revenue: it was visibility.
The fix isn't complicated. It's five dashboards that take the numbers you already have and turn them into decisions you can actually make.
Dashboard #1: Cash Flow Dashboard
Start here. If you only build one dashboard, this is the one.
What It Shows
A 13-week rolling forecast of cash in and cash out. Every week, you see:
- Beginning cash balance
- Expected inflows (customer payments, scheduled receivables, other income)
- Expected outflows (payroll, rent, loan payments, AP coming due, one-time expenses)
- Ending cash balance
- Runway (how many weeks you can operate at current burn rate)
The 13-week window matters because it gives you a full quarter of visibility: enough to see problems before they become crises.
Why It Matters
Cash is oxygen. Most businesses that fail don't fail because they're unprofitable: they fail because they run out of cash.
Your P&L might show profit, but if that profit is tied up in receivables while your bills are due now, you've got a problem. The cash flow dashboard shows you that problem 6-8 weeks before it hits.
- Minimum 4 weeks runway at all times (8+ weeks is better)
- No surprise cash crunches (you see dips coming and plan for them)
- Seasonal patterns visible so you can prepare for slow periods
Real Example: Dental Practice
Dr. Martinez ran a 6-chair practice billing $1.8M annually. Profitable on paper. But every March and September, she was scrambling for payroll.
The cash flow dashboard revealed the pattern: insurance reimbursements lagged 45-60 days, but her biggest equipment lease payments hit March and September. She was profitable, just cash-timed poorly.
The fix: We restructured the lease payment schedule and implemented same-day patient payment collection for copays. No more cash crunches.
How to Build It
In Google Sheets or Excel: Create 13 columns (one per week). Rows for: beginning cash, expected inflows (customer payments), outflows (payroll, rent, AP, loan payments), net cash flow, and ending balance.
Key formula: Ending cash in Week 1 becomes Beginning cash in Week 2. Link the cells so it cascades.
Update weekly: Every Monday, shift forward one week and refine projections. This is the most valuable 30 minutes you'll spend on finances each week.
Dashboard #2: Profitability Dashboard
Cash flow tells you if you can pay the bills. Profitability tells you if you should be paying the bills.
What It Shows
- Gross margin by service/product line (or by job, for contractors)
- Net margin trends over time
- Revenue vs. cost breakdown for each segment of your business
- Contribution margin (what each service actually adds to overhead coverage)
Why It Matters
Not all revenue is created equal. A $50K job at 8% margin contributes $4K to your business. A $30K job at 25% margin contributes $7.5K. The second job is worth nearly twice as much despite being 40% smaller.
Without this dashboard, you're flying blind on which parts of your business actually make money. You might be working harder on your least profitable services while neglecting your cash cows.
- Service businesses: 35-50% gross margin
- Construction: 20-35% gross margin
- Professional services: 50-70% gross margin
Real Example: Construction Company
A commercial HVAC contractor was bidding every project at 25% margin and winning plenty of work. The dashboard showed actual margins:
| Project Type | Bid Margin | Actual Margin |
|---|---|---|
| New construction | 25% | 31% |
| Retrofit residential | 25% | 18% |
| Emergency repairs | 25% | 42% |
| Maintenance contracts | 25% | 35% |
He was underpricing emergency repairs (where customers would have paid more) and losing money on residential retrofits (where access issues and homeowner change-orders ate margins).
The fix: Raised emergency repair rates 20%. Stopped bidding residential retrofits under $15K. Same crew hours, way more profit.
How to Build It
In Google Sheets or Excel: List your service lines as rows (5-10 max). Columns: Revenue, Direct Costs, Gross Profit, Gross Margin %. Color-code: green above target, yellow marginal, red below breakeven.
Data source: Your accounting software should track revenue by service line. If it doesn't, start tagging transactions now.
Dashboard #3: KPI Dashboard
This is where you move from financial statements to business intelligence.
What It Shows
Key Performance Indicators that predict future performance:
- Revenue per employee (productivity measure)
- Client acquisition cost (CAC) — what you spend to get a new customer
- Client lifetime value (LTV) — what a customer is worth over time
- LTV:CAC ratio — are you acquiring customers profitably?
- Utilization rate (for service businesses, billable hours vs. available hours)
Why It Matters
Financial statements are lagging indicators: they tell you what already happened. KPIs are leading indicators: they tell you what's about to happen.
If revenue per employee is declining, you've got a productivity problem that will show up in margins within 3-6 months. If your LTV:CAC ratio drops below 3:1, you're spending too much to acquire customers you can't retain.
These are early warning systems.
- Revenue per employee: $150K-$250K for most service businesses (higher for specialized)
- LTV:CAC ratio: 3:1 minimum, 5:1 is excellent
- Utilization rate: 70-85% billable (higher burns people out, lower bleeds money)
Real Example: Medical Practice
An orthopedic practice with 3 physicians and 12 staff was struggling despite strong patient volume. The KPI dashboard revealed revenue per employee at $142K (below the $175K benchmark) while LTV:CAC looked fine at 5.5:1.
The problem was productivity, not acquisition. Too many staff for the patient volume.
The fix: Better scheduling cut no-shows 15%. Added high-value services. Revenue per employee jumped to $189K without adding staff.
How to Build It
Key formulas:
- Revenue per employee: Total revenue ÷ Number of employees
- CAC: (Marketing + Sales costs) ÷ New clients acquired
- LTV: Average transaction × Transactions/year × Average years as customer
- Utilization: Billable hours ÷ Available hours × 100
Display current value plus 3-month trend arrow and comparison to benchmark.
For more on when your business needs this level of strategic insight, see our Complete Guide to CFO Services.
Dashboard #4: Growth Dashboard
Profitability tells you if you're healthy today. Growth tells you if you'll be healthy tomorrow.
What It Shows
- Revenue trends: Month-over-month (MoM), Year-over-year (YoY)
- Pipeline: Work sold but not yet started
- Backlog: Work in progress, expected to complete
- New client acquisition rate
- Client retention/churn rate
Why It Matters
A flat revenue number hides a lot of information. Are you growing with new clients or milking existing ones? Is your pipeline full or empty? Are you building for the future or coasting on past momentum?
The growth dashboard reveals trajectory, not just position.
- YoY revenue growth: 10-20% for established businesses, 30%+ for growth-mode
- Pipeline coverage: 3-6 months of work sold or highly probable
- Client retention: 80%+ annual retention (varies by industry)
- Churn offset: New client revenue > lost client revenue
Real Example: Legal Practice
A 4-partner law firm billing $2.8M felt "fine." The growth dashboard told a different story: new matters down 14%, retention down to 72%, pipeline at $220K vs. $340K last year, YoY revenue growth at -4%.
They weren't fine: they were slowly declining. Partners were busy, so they felt successful, but they were working existing relationships without developing new business.
The fix: Referral program, quarterly BD events, required relationship development. Pipeline rebuilt within 9 months.
How to Build It
Track revenue MoM and YoY. For pipeline: list all signed/probable work with confidence levels (signed = 100%, proposal out = 25%) and calculate weighted pipeline. Track client retention as (Active - Lost) ÷ Active.
A simple bar chart with a trend line reveals more than tables of numbers.
Dashboard #5: Health Dashboard
This is the "check engine light" dashboard. It tells you if something is structurally wrong with your business.
What It Shows
- Current ratio: Current assets ÷ Current liabilities (can you pay short-term obligations?)
- Debt-to-equity ratio: Total debt ÷ Owner's equity (how leveraged are you?)
- Days Sales Outstanding (DSO): How long it takes to collect receivables
- Days Payables Outstanding (DPO): How long you take to pay bills
- Cash conversion cycle: DSO - DPO (net timing gap)
Why It Matters
These ratios reveal structural health. You can have great revenue and strong margins but still be fragile if:
- Your current ratio is below 1.0 (can't cover short-term debts)
- Your DSO is 60+ days (capital tied up in slow receivables)
- Your debt-to-equity is over 2:1 (overleveraged)
These issues don't show up on a P&L. They show up when you try to get a loan, take on a big project, or weather a slow period.
- Current ratio: 1.5-3.0 (below 1.2 is concerning, below 1.0 is urgent)
- Debt-to-equity: Below 2:1 for most businesses (lower is generally safer)
- DSO: 30-45 days for most industries (construction can run longer)
- Cash conversion cycle: As short as possible — negative is ideal (you collect before you pay)
Real Example: Construction Company
A general contractor was growing fast: $3.5M in revenue, up 40% from the prior year. But the health dashboard flashed warnings:
| Metric | Actual | Target |
|---|---|---|
| Current ratio | 0.95 | 1.5+ |
| Debt-to-equity | 3.2:1 | 2:1 |
| DSO | 67 days | 45 days |
He was growing into bankruptcy. Fast revenue growth funded by debt, with cash tied up in slow-paying receivables. One delayed payment from a major client would have triggered a crisis.
The fix: Tightened payment terms on new contracts. Implemented progress billing milestones. Paid down highest-interest debt from retained earnings. Current ratio hit 1.4 within 18 months.
For construction companies especially, this kind of financial visibility is critical — see why profitable businesses fail from cash flow gaps.
How to Build It
Pull from your balance sheet: current assets, current liabilities, total liabilities, owner's equity. Calculate: Current ratio (Current assets ÷ Current liabilities), Debt-to-equity (Total liabilities ÷ Equity), DSO ((AR ÷ Revenue) × Days in period).
Use traffic light formatting: green within target, yellow approaching concern, red needs attention. Update monthly — weekly if you're in turnaround mode.
"This Sounds Like a Lot of Work"
Here's the reality: You don't need all five immediately.
Start with the Cash Flow Dashboard. Just that one. After a month, add Profitability. Then KPI. In 90 days, you'll have visibility that puts you ahead of 95% of business owners.
The time investment: 2-4 hours setup per dashboard. 30-60 minutes weekly maintenance for all five. Compare that to the time you spend dealing with cash crises and making uninformed decisions.
The dashboards pay for themselves in avoided problems and better decisions.
When to Get Help
Some business owners build these dashboards themselves. Others realize they need help: the data isn't clean, they're not sure what to measure, or they want someone to interpret the numbers.
That's where a fractional CFO comes in: not for bookkeeping, but to build visibility systems and translate numbers into decisions.
Frequently Asked Questions
Tom Woolley, MBA
Every business needs five core dashboards: (1) Cash Flow Dashboard — a 13-week rolling forecast of cash in and out, showing your runway. (2) Profitability Dashboard — gross margin by service or product line so you know which parts of your business actually make money. (3) KPI Dashboard — leading indicators like revenue per employee, client acquisition cost, lifetime value, and utilization rate. (4) Growth Dashboard — revenue trends, pipeline, backlog, and client retention rates. (5) Health Dashboard — structural ratios like current ratio, debt-to-equity, DSO, and cash conversion cycle.
Today CFO
Each dashboard takes 2-4 hours to set up initially in Google Sheets or Excel. Weekly maintenance for all five dashboards combined is 30-60 minutes. You don't need all five at once — start with the Cash Flow Dashboard, add Profitability after a month, then KPI. In 90 days you'll have visibility that puts you ahead of 95% of business owners.
What financial dashboards does a small business need?
The most important KPIs for service businesses are: Revenue per employee ($150K-$250K is the benchmark for most service businesses), Client Acquisition Cost (CAC), Client Lifetime Value (LTV), LTV:CAC ratio (3:1 minimum, 5:1 is excellent), and Utilization rate (70-85% billable hours). These are leading indicators — they predict future performance rather than reporting what already happened.
How long does it take to build financial dashboards?
A healthy current ratio (current assets ÷ current liabilities) is between 1.5 and 3.0. Below 1.2 is concerning because you're getting close to not being able to cover short-term obligations. Below 1.0 is urgent — it means your short-term debts exceed your short-term assets. For construction companies and businesses with seasonal revenue, maintaining a higher current ratio provides a safety buffer during slow periods.
What KPIs should a service business track?
Many business owners build these dashboards themselves using Google Sheets or Excel. The formulas are straightforward, and the data comes from your accounting software. However, if your data isn't clean, you're not sure what to measure, or you want someone to interpret the numbers and translate them into decisions, a fractional CFO can help. The value isn't just in building the dashboards — it's in knowing what the numbers mean and what to do about them.
Your Bookkeeper Tells You Where You've Been. Dashboards Tell You Where You're Going.
Start with cash flow. Add the others over time. Within 90 days, you'll make decisions differently: faster, more confidently, with data backing you up. The businesses that thrive aren't the ones working the hardest. They're the ones who can see what's coming.
About the Author
Tom Woolley, MBA
Tom Woolley is a fractional CFO who has spent 11+ years helping business owners build financial visibility. He works with contractors, dentists, medical practices, and professional service firms to turn P&L confusion into dashboard-driven decisions.
Connect on LinkedInWant Help Building Your Financial Dashboards?
Get a free consultation to see which dashboards will have the biggest impact on your business — and how to build them with the data you already have.
Schedule Your Free Assessment