Job Costing and Gross Margins on Invoices

Adam Graetz
Adam Graetz
  • Updated

Using ServiceTrade's job item costing and gross margins feature, you can track the gross margin percentage on any job as you create its invoice. This lets you manage the profitability of each job, and spot potential trouble areas (shrinkage, incorrectly entered item costs, etc), before your customer receives their invoice.

A job item's cost is the amount that you pay for that item. For instance, you might set your labor item's standard cost to be the loaded cost for an hour of your technician's labor, including their salary, commissions, benefits, equipment costs, etc.

Only users who have been granted the View and Edit Job Item Costs activity can see and edit job item costs.

 

Job Item Costs

You can enter the unit cost of any job item on the job page by clicking the Pencil Icon under the Parts | Labor | Items accordion.

 

The Total Cost of the job is the sum of all the job items' costs, multiplied by their quantities.

You can add a standard cost to any item in your items list, which will be prefilled whenever you use that item. You can read more about creating and managing items in this article.

 

Setting the Standard Cost for an Item.

  1. Go to My Account.
  2. Click on Item List.
  3. Click on the description of the item that you want to edit.
    ST-Office_Items_List.png
  4. Enter the Standard Cost for the item.
    ST-Office_Item_Cost.png
  5. Click the Save button.

 

Technician-Specific Labor Costs

You may have different costs for the same labor item for different technicians.  For instance, a senior technician may have a larger compensation package (and therefore a higher hourly cost) than a junior technician when performing the same labor.

  1. You can assign costs to a specific technician by editing their profile and assigning costs to each of your labor items.
  2. Clicking the Labor Costs accordion opens a Labor Costs Menu that allows you to set Tech-specific Hourly Cost for Labor Items. The Labor Costs Menu will list every Item with the "Labor" Item Type in your Item List.
  3. Enter the Hourly Cost for each Labor Item here:
    ST-Office_Users_Labor_Costs.png

Note: When Labor Items are added to a Job, Invoice or Quote with this Technician as the source, the cost for the item you specify here will be applied to that Item.

Labor Items that do not have a specified cost for this Technician will get that item's default cost instead.

ST-Office_Tech-Specific_Hourly_Cost.gif

 

Gross Margins

The gross margin percentage of any job is calculated as:

(Total job revenue - Total job cost) / Total job revenue

In other words, the gross margin on a job is the percentage of your job's profit relative to the total revenue of the job.

Total Job Cost is the sum of all the job items' costs, multiplied by their quantities. It is calculated by pulling costs from the Job Items, not from Invoice items.

Total Job Revenue is the sum of all invoices for a job, regardless if the invoice has been paid or not.

Gross Margin is calculated using the invoice subtotal (pre-tax) and the total cost of job items. You should never take sales tax into account when calculating gross margin because sales tax is neither revenue nor cost.

You can see the total job cost and gross margin percentage on any invoice (not on the job itself):

ST-Office_JobCost_GrossMargin.png

As you make changes to pricing on the invoice, it will update the gross margin in real-time.

Note: Job items represent your costs (that is, what you actually used), while invoice items represent your revenue (what you are charging the customer). This gives you the flexibility to be able to charge your customers for different types or quantities of items than what you actually consumed on a job, while keeping both your revenues and costs represented accurately.

 

Is sales tax included in the gross margin calculation?

No. The gross margin is calculated using the invoice subtotal (pre-tax). You should never take sales tax into account when calculating gross margin because sales tax is neither revenue nor cost.

 

Can my technicians see my item costs?

Only if you let them. Only users with the "View and Edit Job Item Costs" activity can see and edit item costs. If you do not want to let your technicians see item costs, make sure that none of the roles that they are granted include this activity.

The default "Account Tech" role in ServiceTrade does not include the "View and Edit Job Item Costs" activity -- so any technicians assigned only this role will not be able to see or edit job item costs.

 

I am working on a job's invoice. How do I change the job's cost (what I see in the TOTAL JOB COST section)?

To change the total cost for a job, go back to the job page (there's a link back to the job near the top of the invoice page), open the Job Items section, and click "Manage Job Items".

 

I want to edit my job items' costs from the invoice page. Why is there a difference between job items and invoice items? 

Because your job items might not match your invoice items (though they usually do). Remember those job items represent your costs, but invoice items represent your revenue. In most situations, there's a direct match between the costs that you incurred when delivering a job and the revenue that you achieve by charging your customer for delivering that work -- but not always.

Example: Whenever you use a 5-pack of Shiny Widgets, you charge your customer for the entire 5-pack. However, on a particular job, you may only use 3 of the Shiny Widgets, and the other two may become truck stock, or go back into inventory in your warehouse. So, you have 5 Shiny Widgets' worth of revenue, but only 3 Shiny Widgets' worth of cost.

Your job item entry would look like this:

And your total cost would be 3 x $4.50 = $13.50.

But your invoice item entry would look like this:

And your total revenue would be 5 x $8.00 = $40.00.

You may have other scenarios where you need to invoice your customer for more/fewer, or altogether different, items than what you actually used on a given job

 

Do job costs transfer to QuickBooks or Intacct?

No. Job items will not necessarily correspond one-to-one with invoice items, and job items are the place where costs live (in ServiceTrade).

 

Does my customer see gross margins or costs?

No. These are private to you and are not shared on printed or emailed invoices.

 

Why aren't my labor items appearing in the 'Labor Items' section of my technician's profile pages?

Only items with a type of 'Labor' will appear there.  Items with other types ('Service', 'Part', etc) cannot have technician-specific labor costs assigned.  The missing items probably have a name that includes the word 'labor', but the item's type is not actually 'Labor'.  To fix this, edit the missing item and change its type to 'Labor'.

 

Why didn't my technician's labor cost get assigned to all the labor job items on a job they were assigned to?

Technician-specific labor costs are applied ONLY to job labor items with a technician source.  To assign your technician's labor cost to his job's labor items, edit each of those items, choose an item source type of 'Technician', and then choose the technician's name in the technician list that appears.

Was this article helpful?

/

Comments

0 comments

Please sign in to leave a comment.