If you’re running a service business and using QuickBooks, you already have more data than you realize. The problem is most of it is buried. QuickBooks isn’t set up out of the box to surface the numbers that actually matter, so a little configuration goes a long way.
Here’s how to set up basic KPI tracking so your finances start working for you.
Step 1: Define the KPIs You Actually Need
Before you touch QuickBooks, get clear on what you’re measuring. For most service businesses, the core KPIs are:
- Revenue by service line or client
- Gross profit margin
- Net profit margin
- Accounts receivable aging
- Monthly recurring revenue (if applicable)
- Overhead as a percentage of revenue
Pick three to five to start. More than that gets hard to maintain and harder to act on.
Step 2: Set Up Your Chart of Accounts to Match
Your KPIs are only as clean as your Chart of Accounts. Go to Accounting > Chart of Accounts and make sure your income and expense categories map to the numbers you want to track. If you’re billing for multiple service lines, each should have its own income account so you can see revenue by type, not just total.
Step 3: Use Classes or Locations to Segment Revenue
If you have multiple service lines, team members, or office locations, turn on Class Tracking or Location Tracking under Settings > Advanced. This lets you run profit and loss reports broken out by segment, which is where KPI tracking gets genuinely useful.
Once it’s on, assign a class or location every time you record income or expenses.
Step 4: Build a Custom Report
Go to Reports > Custom Reports and set up a Profit and Loss by Class (or by month) report that reflects your KPIs. Save it so you can pull it up consistently each month without rebuilding it.
For accounts receivable aging, the report already exists: Reports > Who Owes You > Accounts Receivable Aging Summary. Run it monthly and set a threshold for what triggers a follow-up.
Step 5: Set Targets and Compare Monthly
KPIs without targets are just numbers. Once your reports are running, set a baseline for each metric and check against it at the end of every month. Are margins holding? Is AR growing faster than revenue? That month-over-month comparison is where the insight lives.
Step 6: Schedule a Monthly Review
Block 30 minutes at the end of each month to pull your reports, compare against your targets, and note anything that moved. Consistency matters more than perfection here.
Knowing What the Numbers Are Telling You
Getting your KPIs set up is the easy part. The harder part is knowing what to do with what you find.
If your margins are compressing, overhead is creeping up, or your cash position doesn’t match your revenue, those are signals most business owners don’t catch until they’re already feeling the impact.
That’s where a Fractional CFO comes in. Rather than reviewing your numbers once a year at tax time, a Fractional CFO helps you track the right metrics, understand what they mean, and make decisions based on where your business is actually headed.
If your QuickBooks data is starting to raise more questions than it answers, let’s talk. Schedule a free consultation now.