Parts inventory valuation: 5 inputs for each part's cost

• Record the invoice price and pack size.
• Allocate freight consistently.
• Match credits to invoices.
• Check your costing method before applying markup.

If you run an HVAC, plumbing, electrical, appliance or auto repair shop, you probably carry a number in your head for almost every part on the shelf. Capacitors, filters, valves, belts, fuses, fittings. That number is usually the last invoice price you remember, or the quote a supplier gave you last season. The trouble is that one invoice price is only part of what a part costs you. If you apply markup to a number that leaves out freight, a pack-size mismatch, or a credit you never wrote down, the margin you think you have on a job is not the margin you earn.

Inventory valuation is the accounting term for putting a dollar value on what you hold. For a parts business, it matters at quote time, because you need to know what a part costs before you promise a price. An accounting textbook chapter on inventory costing works through this problem using a starting unit cost so that different methods can be compared. Your shop faces the same problem every month. A part's cost is not one fixed figure. It moves with each delivery.

This post walks through five inputs to pin down for each stocked part. Work through them in order and write each one on the part's record. Then the cost you see when you build a quote is one you can explain if a customer or your bookkeeper asks where it came from.

This is general guidance for running a shop, not accounting or tax advice. If you have an accountant, show them how you value parts and ask whether the method fits your books.

Start with the price you actually paid for each unit, taken from the supplier invoice. Not the catalog price, and not the figure on the quote you requested before ordering. Write the invoice date and invoice number beside it, so you can find the original document if a price looks wrong later.

The Odoo example records quantity and unit cost. A documentation example on average prices for returned goods starts with a plain entry: "In the first warehouse operation, 8 tables are received at $10 each." Your part record needs that same kind of figure, a unit cost that comes from the bill rather than from memory.

Watch for price differences. The same example books a gap on its own line: "Debit Stock Input an additional $2 to account for the Price Difference." Your shop does not need that exact bookkeeping, but it needs the habit behind it. If the invoice price differs from what you agreed to, record the invoice price as the cost and note the difference. Then the part is not costed off the number you hoped to pay.

A few habits make this input reliable:

• Enter the cost from the invoice, not from the order or the catalog.
• If the invoice shows a discount, record the net price after the discount.
• If you buy the same part from two suppliers, keep their costs on separate lines so you can see which is cheaper and by how much.
• Date every cost. A price with no date is hard to trust later.

A supplier sells a box of fuses, a reel of wire, a case of oil, or a pack of filters. You install one fuse, one foot of wire, one quart, or one filter at a time. If you use the pack cost as the cost of one piece, you overstate that piece's cost by the pack quantity.

An item manual illustrates units with 1 kilo of biscuits or a pack containing 10 biscuits. The pack and the single item are different units, and the record has to say how they relate. The buying unit and the selling unit are not always the same.

For each part, write down three things:

1. The buying unit, such as a box, reel, case, or pack.
2. The selling unit, such as each, foot, quart, or piece.
3. How many selling units fit in one buying unit.

Then divide the invoice cost for the buying unit by the number of selling units in it. The result is the cost of one selling unit. Write it on the part record and use that figure in every quote.

Two details matter. Keep more decimal places in the record than you show the customer, because a cost rounded early can drift when it is multiplied across a long run, such as a length of wire. And recheck the pack size whenever packaging changes. If a supplier changes how many pieces come in a box, your cost for each piece has changed, even if the box price stayed the same.

The invoice price is often not the full cost of a part. Shipping, delivery fees and hazardous-material handling charges can add to the cost of bringing a part to your shelf. Each shop decides how far to go. What matters most is picking one rule and applying it the same way to every part.

Microsoft Learn describes forwarding cost changes to the items they affect. The design notes on cost adjustment say that the main purpose of cost adjustment is to forward cost changes to the items they affect, which provides "correct inventory valuation." In practice, a cost change should reach every item it touches, and the costing method decides how it lands. Freight on a delivery works the same way. It belongs on the parts in that delivery, not in a general expense line nobody checks against the shelf.

A practical way to handle it: take the total freight and handling for a delivery, spread that total across the units in the same delivery using a simple method you write down, and add the result to the invoice cost for each selling unit from Input 2. The sum is your landed cost. Some shops spread freight evenly across units, while others weight it by line value. Either can work. Consistency matters more than the choice.

Parts go back. A wrong item gets returned, a supplier issues a credit, a price moves after you order, or a warranty part comes back with a note. Each of these changes what the part on your shelf is worth. Ignore them, and your records drift away from what is actually in the bin.

The Odoo example records $80 owed to the vendor in Stock Input. That amount is later used "to pay the bill." This is an amount owed to the vendor, rather than a supplier credit owed to the shop. Track supplier credits separately and match them to the invoices they correct. The documentation on average price valuation walks through the full sequence.

For a parts counter, a simple routine covers most cases:

• When a part goes back to the supplier, reduce the count on the part record and note the expected credit, with the return date and the original invoice number.
• When a credit memo arrives, match it to the invoice it corrects and record the amount, so the cost reflects what you actually paid.
• When a returned part comes back into stock, decide whether it returns to the shelf at its original cost. A damaged or unsold part may belong at a lower value, or not on the shelf at all. Write the decision down.
• When a supplier raises a price between order and delivery, record the invoice price and keep a note of the difference so you can raise it later.

The last input is how you assign cost when the same part was bought at different prices over time. The textbook examples below compare specific identification and first in, first out. The method changes two things at once: the value of what you still have, and the cost of what you have already used. Your quote depends on both.

A textbook worked example on the periodic method makes the point with identical goods. It holds the starting cost fixed, so the differences come only from which purchase prices get assigned to the units still on hand. Under specific identification, ending inventory is valued this way: "Ending inventory was made up of 10 units at $21 each, 65 units at $27 each, and 210 units at $33 each, for a total specific identification ending inventory value of $8,895." Under first in, first out, the same goods come out differently: "Following that logic, ending inventory included 210 units purchased at $33 and 75 units purchased at $27 each, for a total FIFO periodic ending inventory value of $8,955."

The example then finishes the arithmetic: "Subtracting this ending inventory from the $16,155 total of goods available for sale leaves $7,200 in cost of goods sold this period." The same purchases produce one value for the stock still held and another cost for the stock used. That is why the method needs to be chosen on purpose.

What does this mean for your shop? Pick one method for each part family and stick with it. If supplier prices move up and down, a method that values stock at recent prices gives a different cost than one that uses older prices, and your quotes move with it. Others track the cost of each lot. Either can be correct. Which one fits, and how it fits your tax and bookkeeping, is a conversation to have with your accountant before you change anything.

For quoting, the rule is this: the cost on the part record should be what your chosen method says you paid for the units you will sell next. If your method assigns lot costs, record the assigned lot's cost; for average costing, use the calculated average.

Each stocked part should have a short record:

1. Invoice cost for each buying unit, with the supplier name and invoice date.
2. Selling units in each buying unit, so the pack size is explicit.
3. Invoice cost for each selling unit, which is the first figure divided by the second.
4. Added freight and handling for each selling unit, plus any credits or returns that apply to this lot.
5. The costing method used to value stock and to cost what you sell.

The quote cost is the invoice cost for each selling unit, plus the added costs your rule assigns, minus any credit that changes what you actually paid. Only after that figure is settled do you apply markup. If you add freight after markup, the real margin shrinks more than you expect.

Write the record once for each part. For a larger shop, group parts into families, such as filters, fittings and electrical components, and apply one rule to each family. The work is tedious the first time and quicker after that. Use the parts pricing spreadsheet guide to carry the cost into your quote record.

Illustratively, a pack costs $20 and contains 10 pieces. Dividing gives $2 each. Adding $1 in allocated freight gives a $3 cost for each piece before markup.

A parts cost is only useful while it is current. Prices, pack sizes, freight rates and credits all change, and the record has to change with them. The easiest way to keep it current is to tie updates to events you already have: a new invoice arrives, a supplier announces a price change, a return posts, or a credit memo comes in.

The design notes on cost adjustment describe a detection step that comes first. The software must work out which sources have changed in cost and where those costs should go, because, as the notes put it, "to be able to forward costs, the detection mechanism determines which sources have changed in costs." Unless your software does that for you, the job falls to you. The same notes say inventory costs must be adjusted before reconciliation with the general accounts. Before you trust month-end numbers or set a price from a part's cost, make sure that cost reflects every change that touched it. Stale costs quietly erode margin.

Set a simple rhythm. Each new invoice is a chance to ask two questions: did any cost change, and which parts does the change touch? When a delivery arrives, update the affected records. Periodically, check a sample of parts against their latest invoices. If a part has had no cost change for a long time, ask whether the price really held or whether nobody has been checking. See the supplier price changes guide for related quote checks.

Check these costing habits in your own process.

• Pricing from memory. A number you remember from last season is not a cost. Use the latest invoice, or the cost your method currently assigns.
• Mixing up pack and piece. Using a box cost for one item overstates the part-cost component by the pack quantity.
• Leaving freight out. Freight that is never recorded never reaches a quote, so the margin on that job looks better than it is.
• Forgetting credits. An unrecorded credit keeps the cost too high, which can overprice a job and lose it.
• Changing methods midstream. Switching how you value a part changes its cost and its stock value. If you change, do it on purpose, record the date, and tell whoever prices the jobs.
• Rounding too early. Round for display, not for storage. Early rounding compounds across many pieces.

Use this list when you are about to build a quote that includes stocked parts.

• Is the invoice cost on the record from the latest delivery?
• Is the pack size correct, and is the cost for each selling unit calculated from it?
• Have freight and handling been added according to your rule?
• Have any returns or credits for this part been recorded?
• Does the cost match your chosen costing method, whether an average or an assigned lot cost?
• Is markup applied last, to a cost you have confirmed?

If any answer is no, fix the record before you quote. A few minutes spent here is cheaper than a job that loses money because the cost came from a number that was no longer true.

Today, choose a most-used part and check its five inputs against the invoice before your next quote. Your markup means more when it sits on a cost you can defend.

Is the invoice price enough?

The invoice price alone leaves out allocated freight and any credits that change the cost.

Which cost should an average-cost record use?

Use the calculated average rather than selecting a lot's cost.