Job cost sheet: 3 cost lines to total on every job

• Assign parts and time to a specific job.
• Apply an overhead rate consistently.
• Check finished costs against the price charged.

Most owners and team leads know what a job brought in. The invoice shows the price, and the payment shows the cash. What many shops never see is what the job cost them to deliver. Without that number, a busy month can hide a bad job, and a slow month can hide a good one.

A job cost sheet is the simplest fix. It is one record for one job. Every cost that goes into the job gets written on it, and when the work is done, the total at the bottom is the real cost of that job. Set it next to the price and you know the margin on that job instead of guessing.

Accounting textbooks have taught this method for a long time. The OpenStax managerial accounting book has a section on computing the cost of a job using job order costing, and it shows a sample job cost sheet for a single job (OpenStax, section 4.5). The same method works for a small shop on a clipboard or in a spreadsheet.

Paperwork gaps also cost money. Workiz, in a blog post about appliance repair job tracking, says field service operations lose 5–15% of annual revenue purely due to administrative errors and manual tracking gaps (Workiz). That is a vendor's claim, so use it as a reason to check your own records, not as a number to plan around.

Three lines cover most of what a repair or service job consumes. Materials are what the job used up. Labor is what the people on it were paid for their time. Overhead is the share of the business that the job helped use. Together they give a fuller picture of what delivering the work cost.

Some shops also pay subcontractors, rent equipment or buy permits for a single job. Those costs are real, and they belong on the job too. You can give each one its own line, or group them under a clear heading such as other direct costs. Pick the approach once, use it on every sheet, and the totals will stay comparable from job to job. For software setup, see the job costing setup guide.

Direct materials are the parts, fittings, consumables and other items you can tie to one job. Pipe for one repair, a replacement motor for one unit, or the sealant used on one roof belongs on that job's sheet. Shop supplies that feed every job, such as tape or fasteners kept in a bin, are often treated as overhead instead. Pick a rule for where the line falls and write it down, so every sheet is handled the same way.

The OpenStax text shows how costs flow through a company's records. Its Figure 4.19 shows the flow of costs from raw materials inventory to cost of goods sold (OpenStax, section 4.5). For a shop, the practical version is simple: material leaves your stock, gets assigned to a job number, and stays on that job's sheet until the job closes.

In the OpenStax example, the company began the month with a beginning raw materials inventory balance of $2,500. It bought another $10,500, giving it a total of $13,000 in raw materials available for use in production (OpenStax, section 4.5). Materials on hand are a pool, and each piece used has to move out of that pool and onto a specific job. If you buy in bulk and never assign the parts, your job sheets will run low and your stock count will look wrong too.

The example also shows a job that was already underway. The text labels it POR 143. It was the only work in process inventory at the beginning of the current month, with $1,000 in direct material costs and $0 of direct labor already allocated. During the month, $200 of additional direct materials were added to it, so its materials line grew in two steps and the sheet had to carry both amounts (OpenStax, section 4.5).

A few habits keep this line accurate:

• Write the job number on every supplier bill the day it arrives.
• Keep a parts list on each job, even a rough one.
• Record returns and credits on the sheet, so it reflects what was used, not what was bought.

Direct labor is the pay for the people who did the work on that job. In a repair shop, that is usually the technician's hours on the ticket, multiplied by the rate you use for them. Two habits keep this line honest. Track time against the job, not against the shift. And use the same rate method every time, so one job is not carrying a different labor cost than the next.

The OpenStax example builds labor the same way it builds materials. In the POR 143 example, the text says: "During the current month, additional direct materials of $200 and direct labor of $150 were added to POR143" (OpenStax, section 4.5).

Habits that make this line reliable:

• Have technicians log start and stop times for each job, even short calls.
• Note travel time separately, so it does not disappear into the day.
• Compare the labor on your sheets with the hours you paid for, once a week. Gaps show up quickly.

Use the time approval checklist when reviewing those records.

Overhead is everything that keeps the business open but does not belong to one job alone. That includes shop rent, insurance, office software, phone lines, vehicle upkeep, tools that wear out over time, and the time owners and managers spend running the place. None of these costs happens because of one job, so none of them shows up on a single job's supplier bill. They still have to be spread across the work, or the jobs will look cheaper than they are.

The usual way to spread them is an overhead rate. Choose a base that tracks how the work uses the business, such as labor dollars. Set the rate before the period starts, and apply it to each job as the work goes on. The OpenStax text uses this approach. It applies $375 in overhead to POR143 using a predetermined rate of $2.50 for each direct labor dollar (OpenStax, section 4.5).

Check the arithmetic by hand. Direct labor on that job was $150, and $150 at $2.50 for each labor dollar comes to $375, which matches the amount applied. Check your own rate against your overhead costs before using it.

A second example in the same section shows the pattern again. During the month, one job incurred $700 in direct materials costs, $66 in direct labor, and $165 of overhead applied to it before it was transferred to finished goods upon completion (OpenStax, section 4.5). The $165 works out to $2.50 for each labor dollar, the same rate used above. Each of the three lines lands on the sheet, so the job's total cost is simply their sum.

A few practical points:

• Total a year of overhead and divide by the base you expect to use, such as labor dollars. That gives a starting rate you can test.
• Revisit the rate when a big cost changes, such as a new lease or an insurance renewal.
• Do not skip overhead on small jobs. Small jobs add up across a month, and they are easy to underprice.

The entries for POR 143 can be grouped on a sheet as follows (OpenStax, section 4.5):

Add the entries under their three cost lines and the sheet shows the job's total cost. Compare that total with the price charged and you can see the margin on that job. The sheet also grew in steps rather than all at once. Give each entry its own date and supporting document, so anyone checking the sheet later can see how the total was built. That traceability is the point of a job cost sheet.

For an illustrative job, materials cost $700, direct labor costs $150 and allocated overhead is $150. Add $700 + $150 + $150 to get a total job cost of $1000. These amounts are illustrative; use your own materials records, time records and overhead rate for an actual job.

Every line on the sheet should point back to a source document. Materials point to supplier bills or parts slips. Labor points to time records. Overhead points to the rate and the period it covers. When a number cannot be traced, it is a guess, and guesses should be marked as guesses so they can be checked later.

This matters most at year end and when a customer disputes a bill. A sheet built from supplier bills and time records can answer the question. A sheet built from memory cannot. Keep the source documents with the sheet, either as scanned copies in the job file or as paper clipped to the printout, so nothing has to be rebuilt from scratch.

A useful sheet fits on one page and reads from top to bottom. Figure 4.20 shows the job cost sheet for Job MAC001 (OpenStax, section 4.5). Your version can be simpler, but it should keep the fields below.

• Job number, customer, and the dates the job opened and closed
• Materials: each item, quantity, cost, and the supplier bill it came from
• Labor: technician, hours, rate, and total
• Overhead: the rate used and the amount applied
• Total cost of the job, with the three lines above it
• Price charged and the margin left after cost

Keep the total in one place where anyone on the team can read it. A sheet that only the owner can interpret does not help the technician who quotes the next job. Put the three cost lines at the bottom in the same order every time, so a glance tells you where the money went.

A sheet is only as good as the habits behind it, so decide early who owns each line. The person who buys parts can record materials. The technician on the job can record hours. Someone in the office can apply overhead and close the sheet. When one person tries to do all three in the evening, the entries get rushed or skipped. Splitting the work this way also gives you a built-in check, because the people entering costs are not the only ones looking at them.

Set a simple routine. Each day, the technician's hours and the parts used get written on the job sheet before the truck leaves the site. Each week, the sheet is compared with supplier bills and the time records. Each month, the overhead rate is checked against the bills for rent, insurance and software. The routine does not have to be fancy. It has to happen on a schedule, or the sheets drift out of date.

Most sheets go wrong in the same few ways. Watch for these.

1. Recording only the big parts. Small items add up. A box of connectors, a can of sealant and a few feet of wire are all costs, and each belongs on the job if you can tie it to the work.
2. Booking labor from memory. Time you cannot tie to a job tends to disappear, and the sheet then shows less work than was done.
3. Closing the job before bills arrive. Suppliers often bill after the work is finished. Keep the sheet open until the bills are in, or add a late-cost line, so the total does not drift.
4. Setting an overhead rate once and forgetting it. A rate set years ago may no longer cover rent, insurance or software.
5. Mixing general spending into job costs. Office supplies and the company truck's routine upkeep belong in overhead unless you can tie them to one job.
6. Ignoring returns and warranty work. A job that comes back costs labor and materials again. If the second visit is not on the original job's sheet, the first job looks more profitable than it was.

Once you have several finished sheets, you can quote from evidence instead of memory. Look at jobs of the same type and see what their materials, labor and overhead added up to. That history is a reference point. If a new quote falls below the recorded cost of similar work, you know the job will probably lose money. If it sits above that cost, you can decide how much margin to keep.

Be careful with averages. Two jobs of the same type can differ a lot in materials or labor, and an average can hide the one that cost far more than the rest. Look at the individual sheets as well as the totals. When a job runs over, the sheet tells you which line caused it, and that is where the next conversation with a customer or supplier should start.

Once the sheets are complete, compare them. Group jobs by type, such as a simple diagnostic, a full replacement or a repeat service call. Look at which types cover their cost with margin to spare and which do not. A type of work you assumed was profitable may be carrying materials or labor the price never covered.

Then check the overhead rate against reality. If the overhead applied to your sheets is well below what you actually pay each month, check whether your prices cover the business. If it is well above, the rate may be pushing good jobs out of your quotes.

Share the results with the people who do the work. Technicians who can see how a repeat visit affected a job's margin have a clear reason to log hours and parts accurately. Numbers that feel like someone else's report are easy to ignore. Numbers that tie back to the job they came from are much easier to act on.

You do not need new software to begin. Pick one open job and follow these steps:

1. Write a sheet for that job, with the three cost lines.
2. From today, put the job number on every supplier bill.
3. Start a time log for technicians on that job.
4. Write down last month's overhead costs and pick a simple starting rate.
5. When the job closes, compare the finished total with the price.

Keep the first sheets simple. A spreadsheet with one row for each cost is enough to start, and you can add columns later as you learn what matters for your work.

Is the invoice enough to show job cost?

No, the invoice shows the price charged rather than the cost of delivering the work.

Do I need software to begin?

No, you can start with paper or a spreadsheet.