Your QuickBooks numbers, next to the jobs that made them

A contractor financial dashboard ties the dollars in QuickBooks to the jobs in your CRM, so you read gross profit, labor percentage, and cash position the day they move, not when the month-end P&L finally lands.

By Datacube content engineAutogeneratedJune 23, 2026

The four numbers that decide whether you actually made money

01

Per job, not per month

Gross profit by job

Revenue minus true material and labor cost on each ticket

02

Live, not at payroll close

Labor % of revenue

So overtime on emergency calls shows up the same week

03

After allocated overhead

Net operating income

Revenue can rise while NOI quietly falls

04

Today, not month-end

Cash and AR aging

Catch a 60-day commercial invoice before it ages to 90

The problem

Why a profitable-looking month can still lose money

A plumbing shop runs a $14,000 sewer-line replacement. On the invoice it looks like a great job. Six weeks later the material bills, the crew overtime, and the equipment rental all post, and the real gross profit was 22 percent, not the 50 the owner assumed. By then three more of those jobs are already booked. That gap between the work and the numbers is where most home-service margin disappears.

True gross profit on a job is not known until the invoice, the material bills, and the payroll all land, often weeks apart and in two different systems.
Top-line revenue looks healthy while net operating income slides, because overhead and labor burden are never allocated in real time.
Labor as a percentage of revenue is only checked at month-end, after the overtime on storm and emergency calls is already paid.
Accounts receivable ages past 60 days on commercial accounts before anyone in the office is told to chase it.
The owner, the GM, and the controller each quote a different profit number, because each pulled it from a different report on a different day.
Job costing lives in a spreadsheet that one person updates by hand, so nobody trusts it enough to act on it.

Warning

Data visibility gap

QuickBooks knows your dollars. Your CRM (ServiceTitan, Housecall Pro, Workiz) knows your jobs, departments, techs, and lead sources. Neither one alone can tell you the gross profit on the install your senior crew finished this morning. A contractor financial dashboard sits on top of both and joins them, so the money is tied to the work that produced it while you can still do something about it.

What your real-time financial board looks like

A custom datacube financial dashboard built for a home-service business, shown on the office TV and mirrored to mobile. Tiles update as invoices, payroll, and vendor bills post, so the owner, GM, and controller all read the same live numbers.

Dashboard preview

Figures are illustrative. Actual tiles, targets, and thresholds are configured to your chart of accounts and the trades, departments, and locations you run.

What a contractor financial dashboard does that static reports cannot

01

Live, not month-end

Tiles refresh as invoices, vendor bills, and payroll post, so you catch a bad-margin trend this week instead of reading about it in next month's P&L review.

02

Profit by job, department, and tech

Joins QuickBooks revenue and COGS to CRM job records so gross profit breaks down by individual job, by department such as service, install, and maintenance, by trade, and by technician.

03

True NOI with allocated overhead

Applies labor burden and overhead allocation rules so net operating income reflects reality, not a revenue number that hides a thin bottom line.

04

Labor and overtime guardrails

Labor as a percentage of revenue with watch and poor thresholds, so a payroll spike on after-hours and storm calls is visible before it eats the month.

05

Cash and AR aging in view

Cash on hand, AR aging buckets, and collections priority, so the office chases the right invoices before they age past 60 and 90 days.

06

One number, every screen

Owner, GM, and controller read the same live figures on the office TV, on mobile, and on the web, ending the three-versions-of-the-truth problem.

Which numbers come from where, and what they decide

Financial KPIWhere it comes fromDecision it drives
Revenue and average ticketQuickBooks + CRM invoicingPacing vs target, pricing reviews
Gross profit by job and departmentQuickBooks COGS + CRM job dataWhich work and which techs make money
Labor % of revenuePayroll + QuickBooks revenueStaffing, overtime, dispatch calls
Net operating incomeQuickBooks + overhead allocation rulesIs the business actually profitable
Cash on hand and AR agingQuickBooks banking + ARCollections priority, vendor timing
Cost per booked job, ROASGoogle Ads + call tracking + CRMWhere to cut or scale marketing spend

Healthy vs at-risk financial signals

Targets are company-specific and vary by trade, season, market, and business model. These are illustrative thresholds a datacube board can flag for you automatically.

  • Gross profit %Slipping below the target line
    Watch
    Current
    49%
    Target
    50%+
  • Labor % of revenueOvertime pushing it past the line
    Poor
    Current
    33%
    Target
    Under 28%
  • NOI marginIn range but trending down
    Watch
    Current
    16%
    Target
    15-20%
  • Avg gross profit per install jobMaterial cost creep this quarter
    Poor
    Current
    $1,180
    Target
    $1,400+
  • AR over 60 daysTwo commercial accounts overdue
    Poor
    Current
    $42k
    Target
    Under $15k

Info

Common mistake

Treating top-line revenue as the financial dashboard. Revenue up while gross profit and NOI slide is the most expensive blind spot in the trades. Anchor your contractor financial dashboard to margin and net income first, then revenue, so growth that costs you money shows up the day it starts.

Datacube vs static reports and spreadsheet P&Ls

FeaturedatacubeQuickBooks reports + spreadsheets
Update frequencyReal-time as data postsMonth-end, manual pulls
Gross profit by job, tech, departmentBuilt in, joined to CRM jobsHeavy manual reconciliation
NOI with overhead allocationConfigured to your accountsSpreadsheet formulas, error-prone
Marketing and CRM data alongside financeConsolidated from 50+ sourcesSeparate tools, no single view
Office TV, mobile, and web viewsAll three, same live numbersPDF or screen-share only
Replaces QuickBooksNo, it consolidates on top of itQuickBooks stays the system of record

Info

Datacube note

Datacube does not replace QuickBooks or your CRM. QuickBooks stays your book of record and ServiceTitan, Housecall Pro, or Workiz stays your operations system. Datacube is designed to consolidate those sources, when connected, into one real-time financial view so leadership stops stitching numbers together by hand.

How your financial dashboard gets built

  1. 01

    Define your numbers

    We agree on what gross profit, labor %, and NOI mean for your business, including how overhead and labor burden get allocated against your chart of accounts.

  2. 02

    Connect your sources

    QuickBooks for the dollars, your CRM for job and tech data, and marketing and call-tracking platforms for spend, configured to consolidate into one model.

  3. 03

    Design the board

    Tiles, targets, and good, watch, and poor signals built for your trades, departments, and locations, then laid out for TV, mobile, and web.

  4. 04

    Roll out and coach

    A custom build and onboarding over roughly 4 to 6 weeks, so owners, GMs, and your controller all run the company off the same live numbers.

Info

Owner takeaway

You do not need a bigger accounting team to see your money in real time. You need the dollars in QuickBooks joined to the jobs in your CRM on one screen. When gross profit, labor, and cash are live, the monthly P&L stops being a surprise and becomes a confirmation.

We built datacube because running a home-service business off month-end reports meant we were always reacting too late. Seeing the real numbers in real time changed how we ran the company.
Ismael ValdezFounder, Datacube (former CEO, NexGen)

Contractor financial dashboard FAQs

See your financials in real time

Schedule a live demo and we will show you what a contractor financial dashboard built on your QuickBooks and CRM data could surface, from job-level gross profit to live cash position.

Go deeper

Dig deeper