What financial metrics should an electrical company track on a dashboard?

The core metrics for an electrical financial dashboard are revenue month-to-date versus goal (by department or job type), gross margin percentage, labor percentage of revenue, accounts receivable aging by bucket, expense pacing against budget, and maintenance agreement revenue. For electrical companies specifically, separating gross margin by job type (service, install, commercial) matters because panel upgrades, service calls, and commercial electrical work have very different material and labor profiles that a single blended number will hide.

What data sources does an electrical financial dashboard connect to?

The two primary sources are your CRM (ServiceTitan, Housecall Pro, Workiz, or similar) for revenue, completed jobs, job cost, and average ticket by job type, and QuickBooks for COGS, expense categories, AR aging, and payroll. Joined together, these two systems let you calculate gross margin by job type and labor percentage in near real time rather than waiting for the monthly books to close. The connection process is set up during the dashboard build, not configured by hand each month.

How is an electrical financial dashboard different from a QuickBooks P&L report?

A QuickBooks P&L shows you the final result after the month closes. An electrical financial dashboard shows revenue, margin, labor percentage, and AR aging as they develop, so you can act while the month is still open. The dashboard also joins CRM data (which jobs were completed, which job types drove which revenue) with QuickBooks data (what those jobs cost in materials and labor), giving you the cross-system view that neither tool provides on its own.

How should an electrical company track labor percentage on a dashboard?

Labor percentage is total labor cost divided by total revenue, expressed as a percentage. For a real-time dashboard view, labor cost typically comes from QuickBooks payroll or job-costing entries, and revenue comes from completed jobs in the CRM. The challenge in electrical is that install crews are paid differently from service technicians, so a labor percentage that blends both can look fine while one department is over budget. Tracking labor percentage by department or job type is the more actionable version of this metric.

When should an electrical company build a financial dashboard?

The inflection point for most electrical companies is when the owner or controller is spending more than a few hours a week building financial summaries from exported reports, or when they find out about a margin problem at month-end instead of mid-month. If your financial data lives in QuickBooks and your job data lives in a CRM and nobody is joining them until the books close, a financial dashboard will reclaim that time and move the decision window from 30 days after the fact to the same week the data is created.

Should the sales team see the financial dashboard?

The financial dashboard is primarily for the owner, controller, and department managers who act on financial data. Sales reps and CSRs typically get a different view: their booking rates, average tickets, and revenue contribution. Giving the sales team full P&L visibility may not serve a useful purpose and can create noise. Custom dashboards let you configure role-specific access so each person sees the financial metrics tied to a decision they own, without exposing company-wide profitability to roles that do not need it.

How does an electrical company track accounts receivable aging in a dashboard?

Accounts receivable aging data typically comes from QuickBooks, which buckets outstanding invoices into current, 30-day, 60-day, and 90-day-plus categories. A financial dashboard pulls those buckets into a live view so the controller can see the AR position without running a QuickBooks report manually. For electrical companies with commercial clients on net-30 or net-60 terms, separating residential and commercial AR aging is worth the setup effort, because the acceptable balance in each bucket is different and blending them distorts the picture.

Can an electrical financial dashboard work for a multi-location company?

Yes, and multi-location operators often get the most value from a financial dashboard because comparing revenue, margin, and labor percentage across branches in one view is otherwise extremely time-consuming. A financial dashboard can be configured to show company-wide rollups alongside branch-level breakdowns, so an owner running three electrical locations can see at a glance which branch is hitting margin targets and which is running labor over budget, without pulling separate QuickBooks files for each.

Dashboards & reporting

Electrical financial dashboard examples that actually work

Most electrical owners know their revenue figure. Fewer know their gross margin by job type, their labor percentage against target, or whether accounts receivable from last month has aged past 60 days. An electrical financial dashboard puts those numbers in one view, updated through the day, so the owner or controller does not wait until the books close to find out how the month actually went.

By Datacube content engineAutogenerated

Without a live financial view, the typical electrical owner operates like this: the month closes, the bookkeeper reconciles QuickBooks five to ten business days later, and the owner gets a P&L on the 10th or 12th of the following month. By then, a labor-percentage problem that developed in week two has already cost 30 days of margin. The jobs that drove it are dispersed across hundreds of line items. There is nothing actionable left to do except note the number and move on.

With a live electrical financial dashboard, the picture is different. The owner or controller opens the board mid-month and sees gross margin trending three points below target, labor percentage climbing, and accounts receivable aging into the 60-day bucket. The problem is still solvable: dispatch can prioritize higher-margin install jobs, the operations lead can review job costing on last week's service calls, and the AR team can send statements before the balance grows. That is the shift from reactive to real-time financial management that electrical financial dashboard examples are designed to illustrate.

This page walks through what an electrical financial dashboard tracks, how the metrics connect to decisions owners and controllers actually need to make, and what the board looks like in practice. If you want to go deeper on the calculation methodology for cost-of-goods and labor, the COGS and labor percentage guide for contractors covers the formulas in detail.

What an electrical financial dashboard should surface at a glance

Revenue month-to-date against goal, broken down by department (service, install, maintenance agreements) so the owner sees which segment is pulling weight and which is lagging.
Gross margin percentage by job type, not blended across the company, because panel upgrades and service calls have very different material and labor profiles.
Labor percentage against a target range, updated as jobs are completed and hours are logged, so a drift toward overstaffing is visible before the month closes.
Accounts receivable aging by bucket (current, 30-day, 60-day, 90-plus), so the controller can act on collections while balances are still recoverable.
Expense pacing against budget, so the owner can see whether overhead is running ahead of the revenue line and adjust before it compresses net income.

Financial metrics on an electrical dashboard, and the decisions they drive

Financial metric	Where it comes from	Decision it drives	What to watch in electrical
Revenue MTD vs. goal	CRM (booked and completed revenue)	Decide whether to push marketing spend or pull dispatch toward higher-value jobs	Electrical demand spikes in summer (AC tie-ins, generators) and can mask weak service revenue if only the total is tracked
Gross margin by job type	CRM job cost + QuickBooks materials	Identify which job types to prioritize and where pricing or scope creep is eroding margin	Panel upgrades often have higher material costs; service calls have lower material but more variable labor; blending them hides the difference
Labor percentage	QuickBooks payroll + CRM completed hours	Adjust crew sizing, overtime authorization, or tech capacity before the cost is locked in	Electrical installs are labor-intensive; a week of under-booked install crews can push labor percentage well above target
Accounts receivable aging	QuickBooks AR aging report	Prioritize collections before balances roll into the 60-day bucket, which is when recovery rates drop	Commercial electrical jobs often have longer payment terms; surfacing aging buckets separately from residential keeps the view accurate
Expense pacing vs. budget	QuickBooks expense categories	Approve or delay discretionary spend based on whether revenue is tracking to budget	Vehicle fleet and tools represent a larger overhead proportion for electrical companies than for many trades
Maintenance agreement revenue	CRM membership module	Assess whether recurring revenue is growing, flat, or declining month over month	Electrical maintenance agreements are less common than HVAC but growing; tracking them separately shows whether the recurring revenue base is building

Warning

Common mistake: treating blended gross margin as a reliable signal

Many electrical owners look at one gross margin number for the whole company and assume they know how profitable the business is. But an electrical company that runs a mix of service calls, panel upgrades, and commercial electrical work can have wildly different margins across those job types. A week that is heavy on commercial work may look like a strong margin month while service is quietly losing money on callbacks and warranty labor. Separating gross margin by job category on a financial dashboard is not extra work; it is the only way to know which part of the business is actually profitable and which is subsidizing another.

What healthy financial metrics look like for an electrical company

These ranges are reference points, not universal benchmarks. Targets vary by trade mix, market, crew size, and business model. Use them as a starting point for setting your own goals, then track your actual performance against those targets monthly.

Gross margin percentageVaries significantly by job type: service calls typically run higher than install
Good
Current
48%
Target
45–55%
Labor percentage of revenueInstall-heavy months push labor higher; watch for overtime creep
Good
Current
32%
Target
28–35%
Accounts receivable 60-day-plus bucketCommercial net-30 terms inflate this bucket; separate commercial from residential AR
Poor
Current
18%
Target
Under 10%
Revenue MTD vs. monthly goalSlightly behind; evaluate whether dispatch is filling the right job types
Watch
Current
91%
Target
On pace by mid-month
Expense pacing vs. budgetVehicle maintenance costs spiked this month; review before approving discretionary spend
Watch
Current
104%
Target
95–105%
Maintenance agreement renewal rateRecurring revenue base is stable; track new agreements sold separately
Good
Current
82%
Target
80%+

Metric	Current	Target	Status
Gross margin percentageVaries significantly by job type: service calls typically run higher than install	48%	45–55%	Good
Labor percentage of revenueInstall-heavy months push labor higher; watch for overtime creep	32%	28–35%	Good
Accounts receivable 60-day-plus bucketCommercial net-30 terms inflate this bucket; separate commercial from residential AR	18%	Under 10%	Poor
Revenue MTD vs. monthly goalSlightly behind; evaluate whether dispatch is filling the right job types	91%	On pace by mid-month	Watch
Expense pacing vs. budgetVehicle maintenance costs spiked this month; review before approving discretionary spend	104%	95–105%	Watch
Maintenance agreement renewal rateRecurring revenue base is stable; track new agreements sold separately	82%	80%+	Good

What an electrical financial dashboard looks like on mobile

An owner checking the business from the road might pull up a mobile view like this mid-month. The board consolidates CRM revenue data and QuickBooks financials into one live view. Figures below are illustrative.

Dashboard preview

Figures are illustrative. A live datacube financial board reflects your own connected QuickBooks and CRM data.

Info

Quick example: what a 3-point margin drift costs an electrical company

Consider a hypothetical electrical company running $600,000 in monthly revenue. A gross margin of 50 percent produces $300,000 to cover overhead, owner pay, and net income. If margin drifts to 47 percent mid-month because install labor ran over on two large panel jobs, that is $18,000 less contribution margin for the month. Catch it on day 15 and there are two weeks to adjust: tighten estimates on the remaining install pipeline, accelerate a few higher-margin service calls, or hold discretionary spend. Catch it on day 31 and it is already written into the books. The math here is hypothetical and varies by trade mix, market, and business model, but the direction is the point.

What data sources feed an electrical financial dashboard

Two systems do most of the work for an electrical company's financial dashboard. The CRM (ServiceTitan, Housecall Pro, or Workiz) provides revenue by job type, completed jobs, job cost, and average ticket. QuickBooks provides COGS, expense categories, AR aging, and payroll data for labor percentage. Separately these two systems are useful. Joined into one financial board, they answer questions neither can answer alone.

For example: QuickBooks knows what you paid for materials last month, but it does not know which job type consumed them. The CRM knows which jobs were completed but often does not have COGS broken out by category. A financial dashboard joins those fields, so gross margin by job type becomes calculable in real time rather than a month-end exercise. The QuickBooks financial dashboard page covers the specific metrics that can be configured from a connected QuickBooks account.

Who should have access to an electrical financial board

The owner and controller are the primary users of a financial dashboard, but operations leaders often need a version filtered to job cost and labor percentage rather than full P&L. A service manager watching labor percentage on their department does not need to see company-wide expense pacing; a controller reviewing AR aging does not need the leaderboard view that a sales manager uses. Custom dashboards let you give each role the financial slice they actually act on, without exposing information to people who do not need it.

For a deeper look at what a dedicated finance department board includes across all departments (not just electrical), the finance dashboard solution page covers the full module set.

Building a financial review cadence around the dashboard

A financial dashboard without a review cadence is just a screen. The value comes from anchoring it to recurring decisions: a weekly owner check on revenue pacing and margin, a bi-weekly controller review of AR aging and expense tracking, a monthly ops meeting comparing job cost targets to actuals by department. When those conversations happen off the live board instead of off a spreadsheet, the lag between data and decision shrinks from weeks to days.

If you are also thinking about what a broader executive view should include beyond financials (marketing, service performance, goal tracking), the contractor executive dashboard guide covers the full cross-department view owners and GMs typically need.

Electrical financial dashboard FAQs

See what your electrical financial board could show

Datacube builds custom financial dashboards for electrical companies, connecting your QuickBooks and CRM data into one live view that shows revenue pacing, gross margin, labor percentage, and AR aging without a month-end wait. Book a demo to see an example built for electrical operators.

Schedule a live demo Self-guided demo