Tools & integrations

Which QuickBooks dashboard metrics contractors should actually review every month

QuickBooks holds more financial signal than most contractors ever surface. The reports default view shows revenue and expenses, but the numbers that drive profitable decisions, gross margin by job type, labor percentage trend, net operating income versus plan, are buried two or three clicks deep. This guide identifies the eight metrics worth pulling monthly, explains what each one tells you, and shows how a live financial dashboard removes the friction of finding them.

By Datacube content engineAutogenerated

Most contractor accounting lives in QuickBooks. Revenue by customer, expenses by vendor, payroll, subcontractors, materials. The data is there. The problem is that QuickBooks was built for your accountant, not your operations team, so the numbers that matter most at month-end are scattered across Profit and Loss, Balance Sheet, Job Profitability Summary, and several custom reports you may or may not have set up.

The result: most owners review top-line revenue, glance at cash, and move on. Gross margin by trade, labor percentage as a share of revenue, net operating income versus last year: these stay invisible until the bookkeeper closes the month, sometimes weeks after the decisions that caused the problem.

This article names the eight QuickBooks metrics worth reviewing every month, explains what each one actually tells you about the business, and describes the monthly cadence for acting on what you find.

What this article covers

  • The eight QuickBooks financial metrics that matter most for home-service and contractor businesses.
  • What each metric signals and what to do when it moves in the wrong direction.
  • A monthly review cadence: which numbers to check first, second, and third.
  • Why the standard QuickBooks P&L view hides the signals operators actually need.
  • How to connect QuickBooks data to a live financial dashboard so you stop waiting for the books to close.

Why the default QuickBooks view is not enough

QuickBooks organizes financials by transaction type, not by operational question. The Profit and Loss statement mixes HVAC installation revenue with plumbing service revenue, labor costs with subcontractor costs, and overhead with direct job costs unless someone has carefully set up classes, locations, or custom items. For a single-trade, single-location shop that is manageable. For a company running service, install, and maintenance across two or three trades, the default P&L is close to unreadable as a management tool.

The eight metrics below are the ones that give operators genuine decision leverage, and most of them require either a specific QuickBooks report setting or a calculation that the standard P&L does not surface directly.

The eight QuickBooks metrics contractors should review every month

1. Total revenue by service line

Not revenue as a single number, but split by trade or service type: HVAC service versus install, plumbing repair versus drain, electrical residential versus commercial. This requires QuickBooks classes or locations to be set up correctly. The split tells you which part of the business is growing and which is flat, so you know where to add capacity or pull back marketing spend.

2. Cost of goods sold (COGS) and gross profit

COGS for home-service businesses is direct job labor, subcontractors, and materials. Gross profit is revenue minus COGS. Gross profit margin, expressed as a percentage, is the share of each revenue dollar left after covering the cost of doing the actual work. This number needs to be compared month over month and year over year, not just glanced at once. A month where revenue is up but gross margin has dropped is a warning: the company took on work at worse margins, had more warranty callbacks, or direct labor costs climbed.

3. Labor percentage of revenue

Labor as a share of total revenue is one of the most watched numbers in home services because it is the cost that responds fastest to inefficiency. If booking rate drops and techs sit idle, the hourly labor bill does not drop with it, so labor percentage climbs. If you added new techs mid-month and revenue did not scale with them yet, same result. A jump of more than two or three percentage points month over month deserves a direct explanation before you move on.

4. Net operating income (NOI) versus plan

Net operating income is gross profit minus overhead: office payroll, rent, insurance, marketing, software, and the rest. It is the closest number in QuickBooks to "what the business actually made this month." Tracking NOI against a monthly plan or the same month last year shows whether overhead growth is outpacing revenue growth. A business that is growing at 20 percent revenue but flat on NOI is spending its growth away.

5. Expense pacing by category

Rather than reviewing a single expense total, segment by category: marketing spend, vehicle and fuel, insurance, software subscriptions, and office overhead. Pacing means comparing month-to-date spend against what you budgeted for the full month. A marketing budget spent 80 percent through by the 15th is a pacing problem, not a year-end problem. This is easier to spot with a category-by-category view than with a single overhead line.

6. Accounts receivable aging

AR aging shows which invoices are past due and by how long: 0-30 days, 31-60 days, 61-90 days, and over 90 days. For residential contractors this bucket tends to be small because jobs close quickly, but commercial and maintenance-agreement work can build up. A month where the 61-plus-day column grows without an explanation means someone's collection process has a gap.

7. Cash flow from operations

A contractor can show a profitable P&L and still run out of cash in a growth month when payroll outpaces collections. The Statement of Cash Flows in QuickBooks separates operating cash from financing (loan draws) and investing (equipment purchases). Operating cash flow showing negative while the P&L looks fine is a common trap in seasonal businesses. It usually means revenue is booked but not yet collected, or the company is funding growth out of its credit line without realizing it.

8. Job profitability by type or technician

QuickBooks has a Job Profitability Summary report that compares estimated versus actual costs per job, project, or customer. For contractors using job costing this is the report that shows which work type, which technician class, or which market segment is carrying its weight. A drain-cleaning call closed at a strong ticket but with high revisit labor might still be losing money on the job. This report is underused because it requires job-cost setup, but it is the one that directly answers "which work is worth taking?"

Warning

Data visibility gap: the lag between the job and the books

In most contractor businesses there is a 10-to-20-day gap between when a job closes in the CRM and when the revenue appears in QuickBooks. Work is completed, invoiced in the field software, and then a bookkeeper or admin reconciles it into QuickBooks, sometimes after payroll runs. That lag means your QuickBooks dashboard, if it only refreshes when the books are updated, can show you October financials in mid-November. For real month-to-date visibility you need a layer that pulls from both your field CRM and your accounting system simultaneously.

Monthly review cadence: when to check each metric and what to do

MetricWhen to check in the monthWhat you are looking forAction if it is off
Revenue by service line1st of the month (prior month close)Which trade or service type grew or shrankAdjust marketing or capacity by line
Gross profit margin1st–5th (once COGS is posted)Margin drop of more than 2 pts month over monthInvestigate callbacks, discount patterns, subcontractor cost
Labor percentage of revenue1st–5th (after payroll is posted)Labor % above your target rangeReview tech utilization, idle time, and booking rate
Net operating income vs. plan5th–10th (once overhead is fully posted)NOI below budget or below same month last yearIdentify which overhead category outpaced plan
Expense pacing by categoryMid-month (15th) and at closeAny category more than 60% spent by the 15thPause or shift spend; adjust budget for next month
AR aging (61+ day bucket)1st and 15thGrowth in the 61-90 or 90+ day columnAssign follow-up calls; review collection process
Cash flow from operations5th–10th (at month close)Negative operating cash while P&L is profitableSpeed up collections; review credit-line dependency
Job profitability by type or tech10th–15th (after all job costs post)Job types or techs with estimated vs. actual gapsRetrain, re-price, or stop taking unprofitable work types

What good looks like: rough signal ranges for home-service financials

These ranges vary by trade, company size, market, and business model. Use them as a starting point for your own targets, not as universal benchmarks. The goal is to know your numbers and trend them month over month.

  • Gross profit marginVaries significantly by trade; install-heavy businesses run lower
    Poor
    Current
    Below 40%
    Target
    40%–60% depending on trade
  • Labor as % of revenueHigh labor % often signals low booking rate or idle tech time
    Watch
    Current
    Above 35%
    Target
    Varies by trade and model
  • NOI vs. prior year same monthRevenue growth masking overhead creep is the most common trap
    Poor
    Current
    Down year over year
    Target
    Flat to growing
  • AR 61+ days as % of total ARResidential businesses should rarely see significant 60+ day balances
    Watch
    Current
    Above 15%
    Target
    Under 10%
  • Operating cash flow signSignals uncollected revenue or collection lag; investigate immediately
    Poor
    Current
    Negative in a profitable month
    Target
    Positive
  • Actual vs. estimated cost varianceLarge variances often trace to material waste, callbacks, or underpricing
    Watch
    Current
    More than 15% over on major job types
    Target
    Within 10%

Info

Dashboard idea: a live QuickBooks financial board for your morning review

For teams using QuickBooks alongside a CRM like ServiceTitan or Housecall Pro, a financial dashboard can pull from both sources simultaneously: revenue from the CRM as jobs close, and COGS, labor, and overhead from QuickBooks as expenses post. The result is a board showing month-to-date gross profit, labor percentage, and expense pacing that updates through the day rather than waiting for the books to close. Owners who use this kind of view report catching margin slippage mid-month rather than discovering it on the 5th of the following month.

How to run your monthly QuickBooks financial review

The review is most useful when it follows a consistent order. Start with the numbers that tell you whether the month was profitable (revenue, gross margin, NOI), then move to the numbers that explain why it was or was not (labor percentage, job profitability), then close with the forward-looking indicators (cash flow, AR aging, expense pacing). This order means you know the headline before you start diagnosing the detail.

Set up QuickBooks for contractor visibility

To get the most from these eight metrics you need three things set up correctly in QuickBooks: classes or locations enabled (so revenue can be split by trade or department), job costing turned on (so the Job Profitability report works), and your chart of accounts organized to separate direct costs from overhead cleanly. Without these in place the P&L is a single mass of numbers and you cannot distinguish service labor from install labor or marketing spend from office overhead.

Build a standing monthly finance meeting

A monthly review works better as a 30-minute owner-and-controller meeting than as a solo owner activity. The controller brings the pulled reports, the owner asks the hard questions: why is labor percentage up, where did the AR aging move, and which job type missed its margin target. Without a standing meeting this review tends to get skipped in busy months, which is exactly when the signals matter most.

Connect your QuickBooks data to a live financial dashboard

The limitation of running this review only from QuickBooks is that you are always looking backward. A live financial dashboard that connects QuickBooks financial data with your CRM job data can show gross margin, labor percentage, and expense pacing in near-real time through the month, so the monthly review becomes a confirmation of what you already saw trending rather than a discovery of a problem that is already a month old. See how datacube consolidates QuickBooks and field data into one financial dashboard for more on how this works.

QuickBooks dashboard metrics for contractors: common questions

See your QuickBooks financials in a live contractor dashboard

Book a demo to see how datacube consolidates QuickBooks revenue, COGS, gross profit, and expense data alongside your CRM job and call data into one real-time financial view. You will see what the monthly metrics look like when they update through the month, not after the books close.