Straight into the service manual page
WrenchQuarry
More

Price parts by unit and set stock counts: 3 steps

WrenchQuarry Editorial Team · Published · 13 min read · How these guides are written

Pick one unit for each part, set one price for each unit, and keep a stock count that moves with every delivery and job. A parts list only works when every line means the same thing on every job. If one job bills a gasket by the piece, another bills it by the box, and the shelf count lives in someone's notebook, the numbers stop matching within a few weeks. Owners see margins that do not add up. Dispatchers send the wrong quantity to the bay, and nobody can say which figure was right.

This post covers three steps. First, choose one unit of measure for each part. Second, set one price for each unit. Third, start a stock count that changes with every delivery and every job. None of these steps needs special software. A spreadsheet with one row for each part is enough to start. Software tools follow the same logic, so the steps carry over if you switch later.

Step 1: Pick one unit of measure for each part

Start by deciding how each part is counted. Many parts have an obvious unit: one filter, one pump, one belt. Others are awkward. Brake fluid comes in bottles and is often bought by the liter. Fasteners arrive in boxes but are installed one at a time. Hose may be bought by the meter and cut to length on the job.

The rule is simple. Pick one unit of measure for each part, write it down, and use it everywhere. The stock count, the purchase price, the sale price, and the job line should all refer to that same unit. If you buy in one unit and sell in another, the conversion has to be written in the record. Relying on memory is how errors creep in.

The Frappe documentation on item prices gives a clear example of this problem. It describes rice sold in 1 kg and in 500-gram packets, and explains that the unit of measure can be attached to the price so the correct price applies based on the unit chosen on the transaction (Frappe, "Item Price"). The lesson for a shop is that a price should always be tied to a unit. A unit can be a pack, a box, or a single piece, as long as the record says which one applies.

The same page notes that a conversion can use a non-whole number, such as 1.5 kg of oats for one packing unit (Frappe, "Item Price"). Shops meet this all the time. A bulk cleaner might come in a large drum but get poured into smaller bottles for technicians. If the drum and the bottle are both in your list, the conversion between them needs a number you can check, not a guess made at the bench.

Write the unit into the part record, not into the job. A dispatcher who sees "oil filter" with no unit has to guess, and guessed units are where most errors start. Put the unit next to the part name and make it a short, fixed choice: each, pair, box, liter, meter. Avoid free text such as "a bit" or "small tin," because two people will read those words two different ways.

Check the unit against the supplier's invoice, not only against the label on the box. Suppliers sometimes describe a pack one way on the price list and another way on the delivery note. When the two disagree, the invoice is what you paid for, so its unit should win in your record. If the mismatch keeps happening with one supplier, note it on that supplier's part lines so the next person checks in the same way.

Bulk items need one more decision. Choose a base unit for the stock count, usually the smallest unit a technician actually pulls off the shelf. If the part arrives and leaves only in full packs, the pack is the base unit, and you should say so in the record. Counting in the base unit keeps the arithmetic simple. You record a number of bottles on the shelf, not a mix of bottles, cups, and partial containers.

Finally, put a one-line rule in the header of your parts sheet so new staff apply it the same way. Something like "Price and count each part in the unit shown in column B" is enough. The header is the first thing a new dispatcher reads, and it prevents most of the confusion that comes later.

Step 2: Set one price for each unit

Once each part has one unit, give it one price for each unit. Keep that price in one place, usually the parts list, and let every quote and job pull from that place. Do not type the price fresh on each invoice. Every retyped price is another chance for the number to drift.

Zoho Books describes the same idea in its item setup. It explains that items are the goods or services a business deals with, and that the rate entered on an item is reflected on sales transactions such as invoices and sales orders (Zoho Books, "Items"). That is the behavior you want. One rate lives on the item. When the rate changes, you change it once. For the job side of the same figures, see job cost sheet.

Be clear about what each price means. A parts list usually has at least two prices: what you pay the supplier for each unit, and what you charge the customer for each unit. Label them separately. Put the supplier price in a purchase column and the customer price in a sale column, with the unit printed in the header or beside each value. A figure with no label is a figure someone will misread during a busy week.

Some shops add a markup on top of the purchase cost. That works if the markup is written down and applied the same way to every part. The trouble starts when one line says "cost plus a set percentage," another says "cost plus a flat amount," and a third is typed in by hand because it looked right. Pick one rule and apply it to the whole list. Changing the rule should be a deliberate act you can date and explain later.

The federal acquisition rules give a useful principle, even though they govern a much narrower setting. In the cost rules for government contracts, the material costs provision says that when material is issued from stores, any generally recognized method of pricing that material is acceptable if the method is consistently applied and the results are equitable (Federal Acquisition Regulatory Council, "31.205-26 Material costs"). That standard applies to federal contracts, not to a repair shop's price list. The principle still carries over: choose a recognized method, apply it every time, and check that the results are fair. The phrase "consistently applied" is the part to check first.

For a shop, a recognized method might be average cost, the most recent purchase cost, or the cost of the oldest stock on the shelf. Pick one, write it down, and use it for every part. Average cost smooths out price swings but takes a little more work when prices move. Latest cost is quick, but one unusual purchase can shift every quote that follows. Either method can work. Switching between them from job to job cannot.

Write each price as a figure for one unit. If a box holds several pieces and you bought the box, convert the box price to a cost for one piece before you set the sale price. Do not leave one line in box terms and the next in piece terms, because a dispatcher who reads both will eventually multiply one of them wrong. The conversion is a single calculation, done once, and recorded.

Decide how to round before you start, and apply the same rounding everywhere. A converted cost for one piece often lands on a figure with more decimal places than a sale price can show. Choose whether to round up, round down, or round to the nearest unit of currency, write that choice on the rule page, and apply it to every line. Rounding that changes from one line to the next can make two identical parts show two different prices on the same invoice.

Review prices on a schedule rather than only when a supplier bill arrives. Pick a day each month or each quarter, check supplier changes, update the purchase price, and let the sale price follow the rule you set. Note the date of each change beside the price. When a customer questions an old job, the record should show which price applied on that day.

Treat a zero price with suspicion. A zero on a line should be read as an unentered price until someone confirms the part was really free. A job can otherwise go out with a part that was never priced. Scan the list for zeros once a month.

Step 3: Set the stock count and keep it moving

Now the count. Set an opening stock figure for each part, in its chosen unit. This is the number on the shelf on the day you start tracking. Count it once, carefully, and write the date beside it. A rough opening figure makes every later figure rough too, so it is worth doing slowly.

Zoho Books uses this same sequence in its item guide. In its example, the opening stock for an item is entered as 100. The business then makes an invoice that sells 70 units, which leaves 30 on hand. Then it buys 100 units from a vendor and records the bill for that purchase (Zoho Books, "Items"). The lesson is the order of the records. Start with the opening count, then write down every movement as it happens, one at a time. The current count is always the opening count plus what came in, minus what went out.

Stock moves in two directions. Deliveries add to the count, and jobs take it away. Record a delivery when the part comes off the truck and onto the shelf, not when the invoice arrives days later. Record a job issue when the part leaves the shelf for a vehicle, not when the job is closed out at the end of the day. If you wait, the count drifts away from the shelf, and nobody can say when the gap opened.

Dispatchers need a rule for partial use and returns. If a technician takes a part and brings it back unused, record a return, not a second withdrawal. Recording a fresh withdrawal would make the count look lower than it is, and the shelf would not match. If a part was issued to a job that was later cancelled, record the reversal against that job. Each movement should carry a short reason: delivery, job issue, return, adjustment, or scrap. A count with reasons is far easier to audit than a count with only numbers.

Set a reorder point for each part. This is the stock level at which you place the next order. Choose it from two facts: how fast the part moves through jobs, and how long the supplier takes to deliver. Write the reorder point in the same unit as the count so the comparison is direct. A reorder point in boxes against a count in pieces is a common way to order too late or too early. For the reorder side of van stock, see reorder rule fields for van parts.

Count the shelf on a schedule. Pick a few parts each week, count them physically, and compare the result to the record. When they differ, write an adjustment with a reason, and then look for the cause. The usual causes are a missed delivery, a job issue entered twice, or a part put back in the wrong bin. Fixing the cause matters more than fixing the number. An adjustment without a cause just hides the next error.

Avoid negative counts. A negative stock figure means a movement was recorded out of order, or a delivery was missed. Treat it as an error to fix right away, not as a number to live with. A negative count also makes the reorder point unreliable: it fires on a wrong figure, so the order goes out at the wrong time or for the wrong quantity.

Kits need their own line. If a set of parts is sold together, such as a service kit that includes a filter, a gasket, and a seal, decide whether the kit is counted as one item or as its parts. Tracking the kit as a single item is simpler on the sales side. Tracking the parts is more accurate on the shelf. Whichever you choose, the rule should match the way the kit is actually assembled and issued, and the stock count should follow that rule every time.

Value the stock with the same method you chose in Step 2. If it is latest cost, the stock value should follow the most recent purchase price. Mixing methods between the parts list and the stock report makes profit look different depending on which report you open.

Keeping the list the same on every job

Bring the three steps together in one check that runs on every job. Before a job line is written, confirm three things. The part is listed with one unit. The price is the current price for that unit. The stock count reflects the last delivery and the last issue. If any one of these is missing, fix the part record first, then write the job.

Give the check a place in the workflow. Put it on the job sheet or in the dispatch screen so the dispatcher sees it each time a part goes on a job. A list that is correct on the day it is built will drift within months, because prices change, staff change, and new parts appear. A short check at the point of use catches the drift while it is still small. For the dispatch side, see Field Service Work Order Checklist for Dispatch Handoffs.

Treat a new part as a new record, not as a note on an old one. When a supplier introduces a part that looks like an existing one, create the record with its own unit, price, and count. Do not overwrite an old line, because the history of the old part, its price changes and its issues, would be lost. A short, clear name and the supplier's part number are enough to tell the two apart later.

Write the rules down on one page. The page should state the unit rule, the price rule, and the count rule, with the date of the last change. When someone asks why a part costs what it does, you can point to the rule and the record rather than to memory. Memory is the first thing to fail when a shop grows or a senior technician leaves.

Share the page with everyone who writes jobs. Owners and dispatchers should read the same version. If you change a rule, tell both groups at the same time and mark the date on the page. A rule that one person follows and another person does not is the same as having no rule at all, and the disagreement usually shows up on a customer's invoice.

One unit for each part, one price for each unit, and one stock count that moves with every delivery and every job give you a list that behaves the same way on every job. Start with the parts you use most often, set them up by these rules, and extend the list once the routine is working. The first few weeks feel slow. After that, the numbers start to agree with each other, and the arguments about them mostly stop.

Related guides: Van parts: 6 stock rules to set before labeling · Flat-rate pricebook price: 3 parts to build in · Set 8 price book fields for field service billing.

Sources

More field guides