Labor Analysis
Calculated directly from the invoices, time entries and shop settings
17hats line categories
Checks every imported 17hats invoice line and re-tags the ones tagged Labor that aren't labor — by their description. Preview first; nothing is written until you apply.
Labor Analysis · 2026-01-01 to 2026-11-17
The headline numbers for the dates and source you picked. Service revenue is what the shop billed for its time; billable % is how much of the paid shop time ended up on an invoice; labor gross margin is what's left of labor revenue after paying the shop staff. Look for: red tiles — they're below the targets you set in Shop targets. The small gray line under each number says how it's worked out.
Service Revenue
Not enough data
No invoice lines in this date range
Labor — + diagnostic & service jobs $0.00
Trip / Delivery Revenue
Not enough data
No trip/delivery lines in this range
Trip charges & delivery fees
Billed Labor Hours
Not enough data
No billed labor hours in this range
Hourly labor lines only
Effective Labor Rate
Not enough data
No billed labor hours in this range
Labor $ ÷ billed hours (after discounts)
Billable %
Not enough data
No shop staff set up in Shop Settings
Billed ÷ paid shop hours (—) · Target 45%
Shop Labor Cost
Not enough data
No shop staff set up in Shop Settings
Loaded pay × shop share
Cost per Billed Hour
Not enough data
No shop staff set up in Shop Settings
Shop pay + overhead ÷ billed hours — the same as break-even
Labor Gross Margin %
Not enough data
No shop staff set up in Shop Settings
Labor lines vs tech pay only (no overhead) · Target 65% · Incl. diagnostic & service jobs: —
Delivery/Rental Labor Cost
Not enough data
No shop staff set up in Shop Settings
Loaded pay × delivery + rental share
Parts Margin %
Not enough data
No parts sales in this range
Same figure as the Parts section below
Should we charge more?
Whether your labor rate covers what the shop costs to run. Every tile is a rate per billed hour. The two break-even boxes work from all of the shop's costs — tech pay plus overhead — because they answer "do I cover everything". The margin box works from tech pay only, the standard way shops measure labor gross margin. Green means what you actually collect per hour covers it, red means it doesn't. Raise the hours slider to see every box at a higher volume — the shop's cost doesn't move, so the rate each hour must carry does. Look for: red tiles. If your effective rate is under break-even, each billed hour loses money. Then use the sliders to compare charging more against billing more hours.
Shop overhead isn't set, so break-even only covers tech pay — not rent, insurance, tools or the truck. Add your costs on the Shop Budget page.
Current Rate
Not enough data — Set it on the Shop Budget page
What you post and quote
The price you charge per hour before any discount.
Effective Rate
Not enough data — No billed labor hours in this range
labor sold — ÷ —
What you actually collected per billed labor hour, after discounts.
Break-even (labor lines only)
Not enough data — No shop staff set up in Shop Settings
(shop pay — + overhead $0) ÷ —
Every billed hour has to bring in this much to pay shop techs and overhead, counting nothing from diagnostic or job fees.
Break-even after fees
Not enough data — No shop staff set up in Shop Settings
(shop pay + overhead − $0.00 diagnostic & job fees) ÷ —
Diagnostic fees and flat-rate jobs already paid for that tech time, so labor only has to cover what's left.
Rate for 65% labor margin
Not enough data — No shop staff set up in Shop Settings
tech pay — ÷ — = —/hr tech cost; ÷ (1 − 65%)
Standard shop measure: only technician wages plus payroll taxes and benefits for shop time — not overhead. 35¢ of each labor dollar pays the techs, 65¢ is margin. Overhead is covered by the two break-even boxes.
Rate change: +$10.00/hr
Extra revenue year to date at the hours you billed (—)
Not enough data — no billed hours
Almost all profit — same work, higher price. Assumes no customers leave.
Added billed hours: +0 hrs year to date— total
Shop capacity year to date: 2977 hrs (2 techs × 6.5 hrs/day × 229 workdays). Already at capacity.
Extra revenue year to date at the current rate (—)
Not enough data — current rate not set
Move the slider to see the effect of billing more of the hours you already pay for.
Internal Labor Cost by Department
What shop time spent on your own carts costs you — prepping carts for sale, fixing rental carts, shop upkeep. It never shows on a customer invoice, so it's easy to forget. Look for: departments where this is large. Add it to the cost of cart sales or rentals when you judge whether they make money.
Not enough data. No time logged on internal work orders in this range.
Service Department P&L
Did the service department make money in these dates? Everything it billed for labor, fees and trips, plus the profit on parts, minus what you paid the shop staff. Look for: a red bottom line, or a thin one — this is before rent, insurance and other overhead, so it needs to be comfortably positive.
Trip / delivery revenue is shown before delivery-driver pay (see Delivery/Rental Labor Cost).
Parts
How much you make on the parts you sell. Margin is the share of the sale price you keep (a $100 part that cost $60 is 40% margin). Markup is how much you added on top of cost (the same part is a 67% markup). 17hats history has no part costs, so those are estimated from the assumed markup at the bottom of this section. Look for: margin dropping below about 30–35% overall, and a low % Revenue on Actual Cost — that means most figures here are estimates, not real costs.
Parts Sales
Not enough data
No parts sales in this range
Parts Cost
Not enough data
No parts sales in this range
Actual + estimated
Parts Gross Profit
Not enough data
No parts sales in this range
Margin % (GP ÷ sales)
Not enough data
No parts sales in this range
Markup % (GP ÷ cost)
Not enough data
No parts sales in this range
% Revenue on Actual Cost
Not enough data
No parts sales in this range
Rest is estimated
Battery parts
Parts Sales
Not enough data
No parts sales in this range
Parts Cost
Not enough data
No parts sales in this range
Actual + estimated
Parts Gross Profit
Not enough data
No parts sales in this range
Margin % (GP ÷ sales)
Not enough data
No parts sales in this range
Markup % (GP ÷ cost)
Not enough data
No parts sales in this range
% Revenue on Actual Cost
Not enough data
No parts sales in this range
Rest is estimated
General parts
Parts Sales
Not enough data
No parts sales in this range
Parts Cost
Not enough data
No parts sales in this range
Actual + estimated
Parts Gross Profit
Not enough data
No parts sales in this range
Margin % (GP ÷ sales)
Not enough data
No parts sales in this range
Markup % (GP ÷ cost)
Not enough data
No parts sales in this range
% Revenue on Actual Cost
Not enough data
No parts sales in this range
Rest is estimated
How much you keep on each type of part over the past 12 months (this one ignores the date range above). Uses real cost where it's recorded, otherwise an estimate. Look for: short bars on part types you sell a lot of — that's where a price check pays off. The % actual cost tells you how much to trust each bar.
Not enough data
Top 20 Parts by Revenue
Your 20 biggest-selling parts by dollars. Estimated means there's no real cost on file, so the margin is a guess. Look for: estimated rows near the top — check those against your supplier's current price first, because they move the most money.
No parts sales in this range.
Low-Margin Alert
Parts sold for less than 20% margin where the real cost is known — these are probably priced too low or were sold at cost. Look for: the same part showing up repeatedly; it likely needs a new price in the catalog.
No low-margin lines with actual cost.
Assumed Markup (for estimated costs)
Only used to guess the cost of parts that have no cost recorded (most 17hats history). Set it to your typical markup for each group. Look for: keep these close to reality — if they're too high, every estimated margin above looks better than it is.
Where Shop Hours Go
Every hour you paid shop staff for, split four ways: billed to a customer, clocked on a job but never billed, spent on your own carts (internal), and not tracked at all. Look for: a big gray Untracked slice — that's paid time nobody can account for, usually because techs aren't clocking in. Green is the only part that earns money.
Paid shop hours: 0.0 hrs
Not enough data. Set staff hours per week in Shop Settings.
Billed Hours & Effective Rate
Blue bars are labor hours billed each month; the orange line is the average you actually collected per hour. Look for: busy months vs. slow ones (plan staffing and promotions around them), and a dropping orange line — that means more discounts or half-rate work crept in.
Not enough data — no billed hours in this range
Revenue by Category
Where each month's money came from: labor, diagnostic fees, flat-rate service jobs, trip fees, parts, rentals and cart sales. Look for: how much of the business is service versus parts and sales. Parts and cart sales bring in big dollars but keep less of each dollar than labor does.
Not enough data — no revenue in this range
Per-Technician Breakdown
How each tech's paid time turns into billed time. Productivity = share of paid hours clocked on jobs. Efficiency = billed hours ÷ clocked hours (over 100% means they beat the time you charged). Cost includes payroll taxes and benefits. 17hats history has no tech names, so it shows as Unassigned. Look for: low productivity (time not on jobs) versus low efficiency (time on jobs that didn't get billed) — they need different fixes. Needs techs clocking in on FleetCare work orders.
Cost and profit per tech are visible to the owner only.
Not enough data. Add staff with a shop tech share in Shop Settings.
Labor by Customer
Who you do the most labor for, and the average rate each one really pays. Click a column to sort. Look for: big customers with an Avg Rate under your posted rate — they're getting discounts or half-rate hours, which is worth knowing before you renew or quote them.
Not enough data — no labor lines in this range
Discounted Labor
Every labor line billed below your current rate, and what that cost you compared with full price. Look for: discounts you didn't mean to give. Deliberate deals are fine; the same customer showing up again and again is worth a conversation.
Not enough data — Current labor rate not set (Shop Budget & Targets page)
Unbilled Time
Jobs where techs clocked more hours than ended up on the invoice, biggest gap first. That's time you paid for and didn't charge. Look for: the top few rows — either the job was quoted too low or hours were left off the invoice. Only works once techs clock in on FleetCare work orders.
Not enough data — no time entries yet
AI Summary (optional)
A few sentences reading this page back to you in plain English. Written only from the numbers on this page — it can't see anything else.