Skip to main content

Which jobs do I do most, and am I billing the hours? The Service Types report

Reports > Service Types in EasyTruckShop shows every job type you performed, how many, hours clocked vs hours billed vs estimated, and what you charged.

Written by Vladimir

What the Service Types report tells you

The Service Types report in EasyTruckShop shows the work your shop actually performed over a period, grouped by job type — PM Service, Oil Change, DOT Inspection, Tire Replacement, and every other service type you have set up.

For each job type it shows how many you did, how many hours were clocked on them, how many hours were billed, how many were estimated, and the total charged. That combination is what makes this report useful: it is the one place you can see whether the hours you sell match the hours you work.

PM means preventive maintenance. DOT means Department of Transportation, the roadworthiness inspection.

Where the Service Types report is

Reports is not in the top menu bar. It lives under your profile icon, which is the most common reason people cannot find it.

  1. Click your profile icon — your initials in the circle at the top right of the screen.

  2. Choose Reports from the menu. The menu also holds Settings, TimeSheets, and My Profile.

  3. Click the Service Types tab. It sits between Orders and Payments.

In the screenshot below: 1 is the profile icon at the top right, and 2 is Reports in the menu that opens.

The EasyTruckShop profile icon menu open at the top right, with Reports listed beside Settings, TimeSheets and My Profile.

The four cards at the top are SERVICE ITEMS, HOURS CLOCKED, HOURS BILLED, and CHARGED.

The image below shows the Service Types tab: 1 is the filter row with the date range, Shop, Customer, and Customer Group, and 2 is the four summary cards.

The EasyTruckShop Service Types report showing the date range, Shop, Customer and Customer Group filters and the SERVICE ITEMS, HOURS CLOCKED, HOURS BILLED and CHARGED cards.

What permission you need

You need permission to view Reports. If Reports does not appear in your profile icon menu, ask your shop owner or administrator to grant it.

What each column means

The table below the cards has one row per service type. Here is what each column is actually counting.

Column

What it means

NAME

The service type, as named in your service settings

QUANTITY

How many times that service was performed in the period

TIME SPENT

Hours a technician actually clocked onto that service item

TIME BILLED

Hours you charged the customer for

ESTIMATED

Hours the estimate said the job would take

TOTAL CHARGED

Labor revenue for that service type in the period

In the screenshot below: 1 is the column headings NAME, QUANTITY, TIME SPENT, TIME BILLED, ESTIMATED and TOTAL CHARGED, and 2 is the time columns filled in per row.

The Service Types table in EasyTruckShop with the NAME, QUANTITY, TIME SPENT, TIME BILLED, ESTIMATED and TOTAL CHARGED columns filled in for each service type.

Why Hours Clocked is much lower than Hours Billed

On most shops' reports HOURS CLOCKED is far smaller than HOURS BILLED. That is almost always because technicians are not using the clock feature on every job, not because you are overbilling. TIME SPENT only fills in when a tech actually clocks on and off the service item.

So read the two columns like this:

  • TIME BILLED vs ESTIMATED — a fair comparison. It tells you whether your estimates match what you end up charging. This is the comparison to trust if your techs do not clock in.

  • TIME SPENT vs TIME BILLED — only meaningful for jobs your technicians actually clocked. If a row shows 0:00 clocked, the tech did not clock on; it does not mean the job took no time.

If you want a proper worked-hours comparison, use Reports > TimeSheets > Efficiency, which states its own formula: Invoiced Hours ÷ Worked Hours.

Filtering to one customer or one fleet

The Service Types report has Customer and Customer Group filters next to the Shop filter.

  • Customer — answers "what work did I do for this company this year".

  • Customer Group — answers the same question for a whole fleet at once.

Pick from the list and click Filter. Both cards and the table redraw.

Setting the period

The date button on the far left opens on This Month. Click it for a month, quarter, year, or custom range.

Exporting the Service Types report

Click Export at the top right. EasyTruckShop downloads service-type-report.xlsx, with these columns:

  • Name

  • Quantity

  • Time Spent (min)

  • Time Billed (min)

  • Estimated (min)

  • Total Charged

The three time columns are in minutes in the file, not in hours and minutes as on screen. A row showing 14:00 Hours on screen is 840 in the file. Divide by 60 if you want hours. This is actually easier to work with in a spreadsheet, but it catches people out when the numbers look enormous.

What the Service Types report does not do

  • It does not show labor cost or labor profit. EasyTruckShop tracks labor revenue and labor hours, not what the hours cost you in wages. There is no labor cost report, so the charged figure is revenue, not margin.

  • It does not include parts. TOTAL CHARGED is the labor and service charge only. For parts, use the Part Revenue report.

  • It does not have a Basis filter. There is no Cash or Accrual switch on this tab.

  • It does not show which technician did the work. For that, use Reports > TimeSheets.

  • It does not show individual jobs. Rows are service types, not service orders. To see the jobs themselves, use Reports > Sales > Export > Product List, which has one row per line item with the description and labor type.

Accounting and shop words, and what they are called in EasyTruckShop

What people say

What EasyTruckShop calls it

Labor revenue / service income

TOTAL CHARGED here, and the LABOR card on the Sales report

Billed hours / sold hours

TIME BILLED

Worked hours / clocked hours / actual hours

TIME SPENT, and Worked Hours on the TimeSheets Efficiency tab

Estimated hours / book time

ESTIMATED

Job mix / service mix

The rows of the Service Types table, sorted by TOTAL CHARGED

Efficiency / productivity

Reports > TimeSheets > Efficiency, which is Invoiced Hours ÷ Worked Hours

Labor cost / gross margin on labor

Not available anywhere in EasyTruckShop

Other ways shops ask this question

  • "What work do I do the most?" — profile icon > Reports > Service Types, sort by QUANTITY.

  • "Which service makes me the most money?" — sort by TOTAL CHARGED.

  • "Are my estimates accurate?" — compare TIME BILLED against ESTIMATED row by row.

  • "How many PMs did I do this year?" — set the date to the year, read QUANTITY on the PM Service row.

  • "How many DOT inspections did I do for this fleet?" — set the Customer Group filter, then read the DOT Inspection row.

  • "How many hours did I sell?" — the HOURS BILLED card.

  • "What does it cost me to do an oil change?" — EasyTruckShop cannot answer this. There is no labor cost figure; you would need your payroll numbers alongside the hours from this report.

Working with the exported file

service-type-report.xlsx is small — one row per service type. To turn the minute columns into hours, add a column dividing by 60. To compare estimate accuracy across the whole file at once, you can upload it to ChatGPT or another AI assistant and ask something like "add a column for billed minutes divided by estimated minutes and tell me which service types I am consistently under-estimating".

If the numbers look wrong

  • HOURS CLOCKED is zero or almost zero — your technicians are not clocking onto service items. That is a workflow issue, not a report fault.

  • A service type is missing — check the date range and whether a Customer or Customer Group filter is still applied.

  • The charged total does not match the Sales report — they are measuring different things. Service Types is labor and service charges only; Sales includes parts, fees, and discounts.

  • The numbers do not match your other location — check the Shop filter, which defaults to the shop you are currently in.

Did this answer your question?