Calculating Work in Process: A Plain-English Guide for Service Businesses and Makers

You are sitting at your desk past midnight, surrounded by half-finished spreadsheets, a half-assembled batch of custom cabinets, or a pipeline of consulting deliverables that are only sixty percent done. Your accountant asked for your "Work in Process" number for the end-of-quarter balance sheet, and you are staring at a blank cell.

If you run a manufacturing shop, a custom fabrication studio, or even a specialized agency, you already know the feeling. You spent real money on raw materials and paid your team to start building something, but the final product isn’t sitting on a shelf ready to sell yet. It’s trapped in the middle.

When you don't know how to track this value, your financial statements lie to you. Your monthly profit looks wildly distorted—either artificially low because you expensed all the materials at once, or artificially high because you haven't accounted for labor costs sitting on your floor.

Let's demystify calculating work in process once and for all. We will walk through how it works, look at a real-world example, and show you how to turn a confusing accounting chore into a clear picture of your business health.

What Work in Process Actually Means (Without the Jargon)

Let’s strip away the dense textbook definitions. Work in Process (often called WIP, or Work in Progress in service settings) is simply the financial value of everything your business has started building, creating, or servicing, but hasn't finished yet.

Imagine you run a custom bicycle frame shop. On any given Tuesday, your workshop looks like this:

• Three shelves of raw steel tubing waiting to be cut (Raw Materials).
• Five frames welded together and hanging on hooks, waiting for paint and hardware (Work in Process).
• Two shiny, finished bikes boxed up by the front door, ready for delivery (Finished Goods).

That middle category—those five welded frames—represents cash you have already spent. You bought the tubing. Your welder spent hours cutting and joining them. But you haven't shipped them to a customer, and you haven't sent an invoice.

If you close your accounting books for the month and pretend those half-built frames have zero value, your balance sheet is understating your assets. Worse, your income statement will show a massive spike in expenses this month (when you bought the materials), followed by a massive spike in revenue next month (when you sell them), making your business look like a chaotic rollercoaster when it is actually growing steadily.

The Three Pillars of WIP: Materials, Labor, and Overhead

To get an accurate number when calculating work in process, you can’t just guess the weight of the metal or the hours spent. You have to capture three specific cost components. Think of them as the three ingredients in your WIP recipe.

1. Direct Materials

This is the raw stuff that goes directly into the product. If you're building furniture, it’s the wood, screws, and glue. If you're writing custom software, it might be specialized API licenses purchased for that specific client project.

2. Direct Labor

This is the wages and benefits paid to the people physically working on the product. If your fabricator spent four hours welding frame #42, their hourly rate for those four hours goes straight into the WIP bucket for that specific job.

3. Manufacturing Overhead

This is the hidden cost of running the space where the work happens. It includes factory rent, electricity to run the welding machines, depreciation on your tools, and workshop supervision. Because you can't easily tie an electric bill directly to a single bicycle frame, accountants allocate a portion of these overhead costs to every hour of production.

Here is what trips most small business owners up: they try to track overhead by feel. They guess a percentage and add it on. But without a consistent formula, your WIP valuation becomes a moving target that your accountant (or the tax office) will question.

The Core Formula You Need

The formula for calculating work in process isn't actually complicated once you see it laid out. It looks like this:

$$\text{Ending WIP} = \text{Beginning WIP} + \text{Manufacturing Costs Added} - \text{Cost of Goods Manufactured (COGM)}$$

Let's break down those four pieces so they actually make sense in the real world:

• Beginning WIP: What your unfinished inventory was worth at the end of the last accounting period (carried over).
• Manufacturing Costs Added: Everything you spent this period on direct materials, direct labor, and overhead for jobs still in progress.
• Cost of Goods Manufactured (COGM): The total cost of the jobs that you actually finished and moved out of WIP into "Finished Goods" during this period.

If you are a service business rather than a manufacturer, the principle is identical, even if the terms change slightly. Your "raw materials" might be research subscriptions, your "direct labor" is billable team hours, and your "cost of goods manufactured" is the value of the completed client deliverable signed off this month.

A Step-by-Step Example: Meet Maya's Custom Millwork

Let's follow Maya, who runs a custom millwork shop in Chicago. It’s the end of the month, and she needs to report her WIP value for her monthly management meeting.

Step 1: Check Last Month's Books

Maya looks at her balance sheet from the end of last month. Her accountant left her with a Beginning WIP balance of $12,500. This represents three custom reception desks that were half-built when the calendar turned.

Step 2: Total Up This Month's Production Costs

During the current month, Maya buys more lumber, veneer, and hardware. She also pays her two master carpenters and a share of her workshop rent and utility bills.

• Direct Materials added to active jobs: $18,000
• Direct Labor paid for active jobs: $9,500
• Applied Overhead (rent, power, tool wear): $4,000

Maya adds these up: $18,000 + $9,500 + $4,000 = $31,500 in Manufacturing Costs Added this month.

Step 3: Calculate Total Work to Account For

Now, Maya combines what she started with and what she added: $$$12,500 \text{ (Beginning WIP)} + $31,500 \text{ (Added Costs)} = $44,000$$

This $44,000 represents the total pool of value that moved through her workshop floor over the course of the month.

Step 4: Subtract What Was Finished (COGM)

During the month, Maya's team successfully completed two of those reception desks and a large conference table. They packed them up and shipped them out to clients.

Maya looks at the job cost sheets for those completed pieces. She tallies up the exact materials, labor, and overhead that went into building just those finished items. The total cost to build those completed pieces comes out to $29,000. That is her Cost of Goods Manufactured (COGM).

Step 5: Arrive at Ending WIP

Now, Maya plugs her numbers into the final equation:

$$\text{Ending WIP} = $44,000 - $29,000 = $15,000$$

Her ending work in process value is $15,000. She writes this number down on her balance sheet as a current asset. The remaining unfinished pieces in her shop—the ones half-sanded and waiting for next month—are officially valued on paper at $15,000.

When you run numbers like this for your own business, having a reliable way to project cash flow and track business investments helps keep everything steady. If you are ever managing business loans or equipment financing to expand your shop floor, tools like a loan calculator can help you model how monthly repayments fit into these exact production cycles.

Common Mistakes That Trip Business Owners Up

Even with a clear formula, calculating work in process leaves plenty of room for silent errors that slowly drain your profit margins. Here is what trips people up most often:

1. Mixing Up "Billed" With "Finished"

If you run an agency or a consulting firm, it is dangerously easy to confuse billing a client with finishing the work. You might send an invoice for a milestone payment, but the underlying work is only half done, or your team has to rewrite half of it next week. WIP accounting tracks physical or operational completion, not what invoices have gone out the door.

2. Forgetting to Include Overhead

Many small makers calculate their WIP using only materials and direct labor. They forget that the rent on their workshop, the insurance on their machinery, and the electricity keeping the lights on are also consumed while building that product. Leaving overhead out makes your inventory look cheaper than it really is, which distorts your tax reporting and your gross margins.

3. Letting "Zombie" WIP Sit Forever

Every shop has that one project. A client ordered a custom counter, paid a deposit, and then went silent for six months. Their half-built counter is still sitting in the corner, taking up space and inflating your WIP asset number. If a project is dead, you need to write it off as a loss rather than pretending it is a valuable asset sitting on your balance sheet.

Why Getting This Right Changes Everything

It is easy to view WIP calculations as a tedious compliance chore designed by accountants who have never swung a hammer or written a line of client code. But when you get comfortable with the numbers, it gives you a superpower: visibility.

When your WIP is accurate, you know instantly whether your pricing covers your true overhead. You can spot if your carpenters are taking twice as long on a custom build as your estimates predicted. You stop guessing whether your business is profitable this month and start reading the actual story your operations are telling.

Take a breath. You don’t need a complicated enterprise resource planning (ERP) software suite to start tracking this. A clean spreadsheet listing your active jobs, your direct costs, and your completion percentages is all it takes to get clear, steady, and in control of your numbers.

---

Disclaimer: The information provided here is for general educational and informational purposes only and does not constitute financial or accounting advice. Every business has unique tax and compliance obligations; consult a qualified accountant or financial professional for guidance specific to your situation.

If you want to run calculations on the go, check out the free Finlaa app to manage your business and personal finance numbers anywhere.