The 5 KPIs Every Solopreneur Should Track (And How to Automate Them)
You don't have a metrics problem. You have a focus problem. Most solopreneurs either track nothing (flying blind) or track everything (drowning in dashboards they never act on). This is the definitive guide to KPI tracking for solopreneurs.
Five numbers. That's all you need to know whether your business is growing, stalling, or dying. Everything else is a vanity metric until you're past $20,000/month in revenue.
Here are the five, why they matter, and exactly how to automate each one so you spend zero time pulling reports.
The 5 KPIs
- Monthly Recurring Revenue (MRR) or Monthly Revenue
- Lead-to-Customer Conversion Rate
- Customer Acquisition Cost (CAC)
- Cash Runway (Months)
- Revenue Per Hour Worked
That's it. Let me explain why these five and not the 47 metrics your project management tool wants you to track.
KPI 1: Monthly Revenue (or MRR)
What it is: Total revenue collected in a calendar month. If you have subscriptions, this is your MRR. If you're project-based, it's total invoiced and collected revenue.
Why it matters: Revenue is the only metric that keeps your business alive. Followers, page views, and email subscribers are inputs. Revenue is the output.
What to watch for:
- Trend over 3 months. Single months fluctuate. Three-month trends tell the truth. If the 3-month average is declining, something is wrong regardless of how good last week felt.
- Revenue concentration. If one client is more than 40% of your revenue, you don't have a business — you have a job with extra steps. Track client diversification alongside total revenue.
How to automate it:
- If you use Stripe: Stripe Dashboard shows MRR natively. Set up a weekly email summary in Stripe settings.
- If you invoice manually: Wave or QuickBooks tracks revenue automatically when you mark invoices as paid. Set a Monday morning calendar reminder to check the dashboard — takes 30 seconds.
- Automation option: Connect Stripe or your invoicing tool to a Google Sheet via Make.com or Zapier. Create a simple formula that calculates monthly totals and 3-month rolling average. Total setup: 30 minutes.
Target: Positive month-over-month growth. Even 5% monthly growth compounds to 80% annual growth.
KPI 2: Lead-to-Customer Conversion Rate
What it is: The percentage of qualified leads (people who express interest) that become paying customers.
Formula: (New customers in period / New qualified leads in period) x 100
Why it matters: This tells you whether your sales process works. A business with 100 leads and 2% conversion is performing very differently than one with 20 leads and 15% conversion — even if they get the same number of customers.
What qualifies as a "lead":
- Someone who fills out your contact form
- Someone who replies to your outreach
- Someone who books a discovery call
- Someone who requests a proposal
Don't count newsletter subscribers or social media followers. Those are audience, not leads.
Benchmarks:
- Service businesses (consulting, agencies): 15-30% is healthy
- SaaS free trial to paid: 3-8% is typical
- E-commerce: 1-3% of site visitors purchasing is normal
How to automate it:
- CRM approach: HubSpot Free tracks leads through pipeline stages. Set up a deal pipeline with stages: Lead → Qualified → Proposal → Won/Lost. The built-in reports calculate conversion automatically.
- Spreadsheet approach: A simple Google Sheet with columns for lead name, date, source, status, and close date. Filter by status to calculate conversion rate. Less elegant, equally effective.
- Automation: If your leads come through a form (Typeform, contact form, etc.), use Make.com to automatically create a HubSpot contact or add a row to your sheet.
Target: Know your current number, then work to improve it by 2-3 percentage points per quarter.
KPI 3: Customer Acquisition Cost (CAC)
What it is: How much you spend to get one new customer.
Formula: Total sales and marketing spend in period / Number of new customers in period
Include everything: ad spend, software tools used for marketing, your time spent on sales (value it at your hourly rate), contractor costs for content or outreach.
Why it matters: If it costs you $500 to acquire a customer who pays you $400, you're losing money on every sale. Obvious when you say it. Surprisingly common when you don't track it.
What to include in "spend":
- Paid advertising (Google Ads, LinkedIn Ads, etc.)
- Marketing software (email platform, SEO tools, social scheduling)
- Content creation costs (if you hire writers or designers)
- Your time on sales activities, valued at your effective hourly rate
- Networking costs (events, memberships) that directly generate leads
How to automate it:
- Track marketing spend: Tag all marketing expenses in Wave or QuickBooks with a "Marketing" category. Monthly total is automatic.
- Track new customers: Your CRM or invoicing tool already knows this.
- Calculate: Monthly marketing spend / monthly new customers. Add this as a formula in your tracking sheet.
- Semi-automated: Set a monthly reminder to review. The underlying data is already captured by your accounting and CRM tools. You just need to divide two numbers.
Target: CAC should be less than 1/3 of the lifetime value of a customer. If a client pays you $3,000 over their lifetime, your CAC should be under $1,000.
KPI 4: Cash Runway (Months)
What it is: How many months you can operate at current burn rate with the cash you have.
Formula: Current cash balance / Monthly operating expenses (including your salary)
Why it matters: This is your survival metric. Businesses don't die from bad products or weak marketing. They die from running out of cash. Knowing your runway lets you make decisions with clear eyes — when to invest, when to cut, when to take on a project you'd rather not.
What counts as "operating expenses":
- Software subscriptions and hosting
- Contractor payments
- Marketing spend
- Your personal draw or salary
- Taxes set aside (estimate 25-30% of gross revenue for self-employment tax + income tax)
- Insurance, legal, accounting fees
How to automate it:
- Banking API approach: Plaid or your bank's API can feed your balance into a spreadsheet. Most banks offer CSV export at minimum.
- Simple approach: Check your business bank balance on the 1st of each month. Divide by your known monthly expenses. Write it down. This takes 60 seconds.
- Spreadsheet automation: Build a sheet that pulls your bank balance (manually updated monthly) and your expense total from Wave/QuickBooks. One division formula gives you runway.
Target: Minimum 3 months. Comfortable at 6 months. Below 2 months is a crisis that demands immediate action — cut expenses, accelerate invoicing, or take on cash-generating work.
KPI 5: Revenue Per Hour Worked
What it is: Your effective hourly rate across all business activities.
Formula: Monthly revenue / Total hours worked in the month (including admin, marketing, sales — everything)
Why it matters: This is the metric that tells you if you're building a business or just working a bad job. If you're making $10,000/month but working 250 hours, your effective rate is $40/hour. You could make more with less stress as a full-time employee somewhere.
Be honest about hours: Track everything. Client work, admin, email, marketing, bookkeeping, learning, tool setup. All of it counts.
How to automate it:
- Time tracking: Toggl's free tier tracks unlimited projects. Start a timer when you start working. Stop when you stop. It takes 5 seconds per work session and gives you accurate monthly totals.
- If you refuse to track time: Block-estimate it. "I work roughly 8 hours/day, 5 days/week, so ~170 hours/month." Less accurate but better than nothing.
- Calculation: Monthly revenue (from KPI 1) divided by monthly hours (from Toggl). Add this to your monthly tracking sheet.
Target: Your effective rate should be at least 2x what you'd earn as an employee doing similar work. If it's not, you're subsidizing your business with your labor. Either raise prices, reduce non-billable hours, or automate more.
The Automated Dashboard Setup
Here's how to wire everything together in under 2 hours:
Option A: Free (Google Sheets + Manual Updates)
- Create a Google Sheet with 12 monthly columns
- Rows: Revenue, New Leads, New Customers, Marketing Spend, Bank Balance, Monthly Expenses, Hours Worked
- Calculated rows: Conversion Rate, CAC, Cash Runway, Revenue/Hour
- Update on the 1st of each month. Total time: 15 minutes/month
Option B: Semi-Automated ($30-50/month)
- Revenue: Stripe or Wave connected to Google Sheets via Make.com
- Leads/Customers: HubSpot Free (manual pipeline tracking, auto-calculated conversion)
- Marketing Spend: Auto-categorized in Wave
- Cash: Monthly manual bank balance check
- Hours: Toggl free tier
- Dashboard: Google Sheet with formulas, or a simple Notion dashboard
Option C: Fully Automated (Custom, $3,000-6,000 one-time build)
If you want a real-time dashboard that pulls from all sources automatically — Stripe, bank accounts via Plaid, CRM, time tracking — that's a custom build. Worth it if you're past $10,000/month and want to free up even the 15 minutes/month of manual work.
Common Mistakes
- Tracking too many metrics. If you can't name your 5 KPIs from memory, you have too many.
- Checking metrics daily. Monthly is the right cadence for strategic KPIs. Daily checking leads to reactive decisions based on noise.
- Not including your own time in CAC. Your time has value. If you spend 20 hours/month on sales, that's a real cost.
- Ignoring cash runway because revenue is growing. Growing businesses can still run out of cash if expenses grow faster than collections.
- Comparing to benchmarks instead of your own trends. Your conversion rate going from 8% to 12% matters more than whether the "industry average" is 15%.
Start This Week
Don't overthink it. Open a spreadsheet. Enter last month's numbers for all five KPIs. Set a calendar reminder for the 1st of next month to do it again.
After 3 months of data, you'll know more about your business health than 90% of solopreneurs who rely on gut feel. After 6 months, you'll start seeing patterns that change how you make decisions.
Five numbers. Fifteen minutes a month. That's the entire system.