Simple Spreadsheet Templates to Track Shop Expenses (DIY Fix)
When I first started taking on paid metalwork, I did what most people do: I guessed. I would look at a project, think about how long it might take, and add a bit for the steel. Usually, I ended up working for about five dollars an hour once the dust settled. It took me years of running a manufacturing shop to realize that profit isn’t what is left over—it is what you plan for.
Managing a small workshop requires more than just a steady hand with a TIG torch. You need a clear view of where every cent goes. Many side-hustlers feel anxious when quoting a job because they lack a data-backed foundation. They worry they are charging too much, or worse, they realize too late they charged far too little. By using basic digital ledgers to log your spending, you can move from guessing to knowing.
Establishing Your True Shop Hourly Rate
A shop hourly rate is the total cost of keeping your doors open for sixty minutes, regardless of the specific job. This includes your rent or mortgage, electricity, heat, and your own desired take-home pay. It acts as the baseline for every quote you send to a customer.
Before you can price a single weld, you must understand your overhead. Many hobbyists moving into professional work forget that their garage or basement isn’t “free.” Even if you aren’t paying extra rent, the lights are on, the compressor is drawing power, and you are using space that could be used for something else. I recommend creating a simple column in a digital sheet to list every monthly fixed cost. Total these up and divide them by the number of hours you actually spend working in the shop each month.
If your monthly shop costs are $400 and you work 40 hours a month on side projects, your base overhead is $10 per hour. If you want to earn $40 an hour for your labor, your starting shop rate is $50. However, this doesn’t account for the “non-billable” time spent cleaning, quoting, or picking up material. Most successful small shops find their actual billable rate needs to be 20% to 30% higher to cover those “lost” hours.
| Expense Category | Monthly Cost | Billable Hours | Hourly Burden |
|---|---|---|---|
| Utilities (Power/Heat) | $120 | 40 | $3.00 |
| Shop Rent/Space Value | $200 | 40 | $5.00 |
| Basic Maintenance | $50 | 40 | $1.25 |
| Total Base Burden | $370 | 40 | $9.25 |
Calculating Machine Amortization for Side-Hustle Metalworking
Machine amortization is the process of spreading the cost of a tool over its expected lifespan. Instead of seeing a $2,000 welder as a one-time loss, you treat it as a per-hour cost that the customer pays back over time. This ensures you have the funds to replace the machine when it eventually wears out.
When I bought my first industrial cold saw, I didn’t just look at the price tag. I looked at how many cuts it would make before it needed a rebuild. To track this in a basic ledger, list the tool’s purchase price and estimate how many hours it will run over five years. If a $3,000 plasma cutter lasts 1,000 hours, it costs you $3 every hour it’s triggered.
Adding this “tool wear” fee to your shop rate prevents you from being surprised by a massive bill when a piece of equipment fails. It turns a scary capital expense into a manageable operating cost. You aren’t just charging for your time; you are charging for the wear and tear on the investments that make the work possible.
- Estimate the lifespan of major tools in hours (usually 500 to 2,000 for hobby-grade gear).
- Divide the purchase price by those hours.
- Add that amount to your hourly rate for jobs requiring that specific machine.
- Log these values in a separate tab of your spreadsheet for quick reference.
Why Hidden Consumables Bleed Small Shop Profits
Consumables are the items you use up during a job, such as welding gas, grinding discs, drill bits, and sandpaper. Because these items are small, many fabricators fail to track them, leading to a “death by a thousand cuts” where profits vanish into the scrap bin.
In my experience, the average small shop underestimates consumable costs by nearly 50%. A single 4.5-inch flap disc might cost $4, but if you use three of them on a small bracket project, that is $12 off your bottom line. If you didn’t account for that in your quote, you just paid the customer to work for them.
I suggest keeping a simple “restock log” in your digital ledger. Every time you buy a box of MIG wire or a bottle of argon, enter the price and the date. Over a few months, you will see a pattern. You can then calculate a “consumable burden factor.” This is usually a percentage added to the total material cost, often ranging from 10% to 15%, to cover these invisible expenses.
- Welding Gas: Track how many projects a single tank lasts.
- Abrasives: Note how many discs you use per foot of weld cleanup.
- Safety Gear: Include the cost of gloves and respirator filters.
- Cleaners: Don’t forget acetone, rags, and degreasers.
Developing a Manual Entry System for Material Sourcing
Material sourcing involves finding, buying, and transporting the raw metal needed for a project. The cost of the metal is only one part of the equation; the time spent driving to the local steel yard and the fuel used are also real expenses.
When you use a basic spreadsheet to track metal business ROI, you should have a dedicated sheet for material inventory. Every time you buy steel, aluminum, or hardware, log the price per foot or per pound. Metal prices fluctuate wildly based on the market. If you quoted a job based on last year’s steel prices, you might find yourself losing money before you even strike an arc.
A common mistake is charging the customer exactly what you paid for the metal. In the professional world, we apply a “material markup.” This covers the time it took to source the material, the storage space it occupies, and the risk of a mistake during cutting. For small shops, a markup of 20% to 50% is standard. If a length of tubing costs you $100, you should be billing the customer at least $120 to $150 for that material.
- Log the date of purchase and the supplier.
- Record the total cost including any delivery fees.
- Calculate the “unit price” (e.g., price per inch or per pound).
- Apply your standard markup percentage in a final column.
Building a Basic Fabrication Job Costing Ledger
A job costing ledger is a simple table where you combine labor, materials, and overhead to create a final price. This is where the math of your shop rate meets the reality of a customer’s project. It serves as both a quoting tool and a historical record of your work.
To build this, create a row for every major task in a project. For example, “Cutting,” “Fitting,” “Welding,” and “Finishing.” Assign an estimated time to each. Then, list the materials and consumables required. The spreadsheet should use basic addition to sum these parts and then multiply the labor hours by your shop rate.
The beauty of this manual entry method is that it forces you to think through the project step-by-step. You will often realize that “just a quick weld” actually involves thirty minutes of prep and twenty minutes of cleanup. Seeing these numbers on a screen helps you stand firm on your pricing when a customer asks for a discount.
| Task Description | Estimated Hours | Shop Rate | Subtotal |
|---|---|---|---|
| Material Prep/Cutting | 1.5 | $65 | $97.50 |
| Assembly/Welding | 3.0 | $65 | $195.00 |
| Grinding/Finishing | 1.0 | $65 | $65.00 |
| Labor Total | 5.5 | $357.50 |
Reconciling Estimates with Reality
Post-job reconciliation is the act of comparing what you thought a job would cost with what it actually cost. This is the most important step for any side-hustler looking to improve their financial efficiency. It turns every project into a lesson.
After you finish a project, go back to your digital ledger. Create a new column next to your estimate and enter the actual hours spent and the actual materials used. If you estimated two hours for welding but it took four, don’t ignore it. Ask yourself why. Did you run out of gas? Was the fit-up poor? Did the machine break down?
Over time, this data will show you where your “leaks” are. You might find that you are consistently underestimating finishing time or that you are using more abrasives than you thought. By adjusting your future quotes based on this real-world data, you ensure that your shop remains profitable and your side-hustle stays sustainable.
- Always record the “Actual Time” immediately after finishing a job.
- Note any unexpected material waste or broken tools.
- Calculate the “Variance” (the difference between estimate and actual).
- Use the variance to pad future quotes for similar work.
FAQ: Common Questions on Workshop Expense Tracking
How do I track electricity if my shop is in my home garage? The simplest way is to look at your utility bill from a month when you didn’t use the shop versus a month when you did. Alternatively, you can use a basic “plug-in” meter on your larger tools for a few days to see their average draw. Most small shops find that a flat hourly “power fee” of $2 to $5 covers their needs without complex math.
What is a realistic material markup for a part-time shop? For most small-scale fabrication, a markup of 30% to 50% is standard. This covers your time spent driving to the supplier, the fuel for your truck, and the cost of storing leftovers. If you are buying very small amounts of specialty metal, the markup should be higher to account for the “hassle factor.”
Should I include my “learning time” in a customer’s quote? Generally, no. If a job takes you five hours because you are learning a new technique, but a pro would do it in two, you should probably only bill for three. However, you should still log all five hours in your internal tracker so you know your “true” hourly earn for that project.
How do I account for scrap metal? Scrap is a cost. If you have to buy a 20-foot stick of tubing for a 12-foot project, the customer pays for the whole 20 feet unless you are certain you can use the remainder for another paying job soon. Your spreadsheet should always reflect the “purchased amount” rather than just the “finished amount.”
How often should I update my shop rate? I recommend reviewing your costs every six months. If your electricity rates go up or the price of welding gas rises, your shop rate needs to reflect that. Small, incremental changes are easier for customers to accept than a massive price jump once every three years.
What if my spreadsheet says I should charge more than the local market allows? This is a common realization. If your calculated rate is $100/hr but others charge $60, you have two choices: find ways to reduce your overhead (like buying in bulk) or increase your efficiency (better tools, faster jigs). The spreadsheet isn’t wrong; it’s telling you the reality of your current business model.
Do I need to track every single nut and bolt? Not individually. For small hardware, it is easier to have a “Shop Supplies” category. You can add a flat $5 or $10 “hardware fee” to every job to cover the bin of bolts, washers, and zip ties you keep on hand.
How do I handle “friend and family” discounts using these sheets? The best way is to show them the full price first. Use your spreadsheet to generate a “real” quote. Then, apply a “discount” line at the bottom. This ensures they see the value of your work and realize that you are effectively giving them cash out of your own pocket.
What is the best way to track “non-billable” hours? Keep a simple log of how much time you spend on shop maintenance, cleaning, and quoting. At the end of the month, compare this to your billable hours. If you spend 20 hours cleaning for every 20 hours of welding, your shop rate needs to be high enough to cover that “lost” time.
How do I track tool ROI if I bought the tool used? Use the price you paid, not the new price. If you bought a used bandsaw for $400, and you think it will last another 200 hours, your tool cost is $2 per hour. The goal is to make sure that by the time that saw dies, you have $400 in the bank to buy another one.
Is it worth tracking consumables on very small jobs? Yes, because those small jobs are often where profit disappears. If you do five small jobs a week and lose $10 in consumables on each, that is $2,600 a year you just threw away. Using a standard “consumable percentage” in your spreadsheet makes this tracking effortless.
Managing the finances of a small metal shop doesn’t require an accounting degree. It requires the discipline to write down what you spend and the courage to look at what you are actually earning. By using these simple digital ledger methods, you can turn your hobby into a professional side-hustle that actually pays for itself—and then some.
(This article was written by one of our staff writers, Michael Hargrove. Visit our Meet the Team page to learn more about the author and their expertise.)
