Why You Need Something to Track Your Woodwork
I've been doing this for years and most people just keep their project logs in their heads or on scattered scraps of paper. That stops working once you have more than three projects running at once. A Monthly Woodworking Tracker is simply a system for logging what you buy, what you build, and how much time and money each thing costs you over a rolling month. The version I use is a spreadsheet with four tabs: monthly expenses, project details, material waste log, and annual summary. I've seen people build elaborate digital dashboards with automations. That's fine if you enjoy maintaining the dashboard. It's also fine if you don't. The tracker only needs to capture data, not impress anyone.
What a Monthly Woodworking Tracker Actually Tracks
People confuse the concept with just a project list. A real tracker records lumber purchases including cost per board foot, hardware, finishes, tool maintenance, energy overhead for running the shop, and time spent on each operation. The project tab links back to the expense tab so you can trace every dollar to a specific build. Here is the structure I found that actually holds up:
- Project tab: project name, start date, estimated vs actual hours, outcome status, notes about what went wrong.
- Expenses tab: date, vendor, item category, quantity, unit cost, total, linked project ID.
- Waste log: pieces trimmed, offcuts kept, pieces ruined, reason for loss.
- Shop expenses tab: blades, sandpaper, clamps, dust collection filters, electricity estimate per month.
The linked project ID is the part everyone skips. Without it, your expense tab becomes a grocery list with no context. I use a simple code like PJ-047 and paste it into both tabs. That is how you get cost per project at the end of the month. Open a blank spreadsheet. Create the four sheets I listed above. In the expenses tab, set these columns: Date, Vendor, Category, Item, Qty, Unit_Cost, Total, Project_ID, Notes. Use a dropdown for Category with values like Lumber, Hardware, Finish, Tool_Supply, Shop_Overhead, Other. In the project tab, use these columns: Project_Name, Project_ID, Start_Date, Est_Hours, Actual_Hours, Revenue_or_Value, Gross_Profit, Status, Issues.
Get the Full Details
Add a conditional format rule that highlights rows in red when Actual_Hours exceeds Est_Hours by more than 20%. You will want that visual cue. Most beginners underestimate time by a factor of two on their first dozen projects. The red cells stop being dramatic after a while. They just become your reality check. For the waste log, track by project too. Record the board foot wasted, the reason, and whether that piece could have been cut smarter. This column is where you learn your real cutting efficiency. I used to guess I wasted about ten percent of material. The log showed I was actually wasting eighteen to twenty-two percent because I was cutting to nominal dimensions instead of adjusting for saw kerf and jointer thickness.
Monthly Woodworking Tracker Template Fields
Below is the exact set of fields I use and why each one exists. Skip the fields that feel useless, but do not skip them before you have filled a full month. You will notice patterns. Your lumber costs will spike in certain months if you buy in small quantities instead of bulk. Your time estimates will consistently miss by a predictable amount. You will find that one particular tool accounts for forty percent of your shop overhead because you use it constantly and never budget for blade replacements or belt changes. I tracked a dining table build last fall and discovered the project actually lost money when I included my own labor at even a modest rate. The board foot cost alone was fine, but the time spent on joinery and finishing blew the budget. That data changed how I price future work. It also changed how I approach builds I make for myself. I stopped doing hand-cut dovetails on furniture that had no business having them. The tracker showed me the time cost repeatedly until I accepted it.
The summary tab uses a pivot table or a simple SUMIFS formula. I prefer SUMIFS because it is transparent and does not break when you add a row in the middle of last year. The formula looks like this for total project cost: =SUMIFS(Expenses!Total, Expenses!Project_ID, PJ-047). Copy it down for each project. It takes twelve seconds and replaces an hour of manual sorting.
Where This System Breaks Down
A few honest limitations. The tracker assumes you record data the same day you spend money or complete a task. If you batch-enter six weeks of receipts on a Sunday, you will forget which project the sandpaper belonged to. The accuracy drops fast. Keep it daily or weekly. Another issue is shared tools and materials. If you buy a box of brads and use it across five projects, you need a fair allocation method. I divide by estimated usage percentage based on hardware count. It is not perfect. It is better than guessing. The biggest flaw is the time tracking itself. Most people stop logging actual hours once the novelty fades. I lost three months of clean data because I got lazy about the Actual_Hours column. I recovered by switching to a phone note that I pasted into the sheet once per evening. Even that is annoying. Some months I skip the waste log entirely and just estimate from memory. That is the worst version of this system and it shows in the numbers.
Also, this tracker does not account for skill development. Time spent practicing a new technique is a real investment that does not appear as a finished project. I handle this by adding a separate category in the expenses tab called Learning and assigning a note to each entry. The profit calculations then exclude those hours when I review cost per build.
Download Link and Setup Options
I do not host a file here. The tracker is simple enough that building it yourself is faster than downloading something that may not match your workflow. If you want a starting point, export the Google Sheets template I linked a while back. Search for Monthly Woodworking Tracker in the community drive and it should be near the top. The file is open for editing. Do not treat it as gospel. Adjust the columns to match what you actually buy and build. For people who prefer a paper system, the same structure works on printed monthly sheets. I used that before going digital and it functioned fine. The downside is that cross-referencing between sheets is painful. Digital wins on linking. Paper wins on not requiring electricity and not tempting you to tweak the spreadsheet instead of working.
Advanced Nuance Most People Miss
The thing nobody mentions is the difference between nominal and actual board foot cost. Lumber pricing is usually per board foot at nominal dimensions. Your real cost per usable board foot is higher because of drying loss, jointer cuts, and planer passes. Multiply your purchase cost by roughly 1.3 to 1.5 depending on how rough you start. I learned this the hard way when a bookcase appeared cheap on paper and expensive on the actual shelf. The second nuance is tool depreciation. If you buy a $400 table saw and use it heavily over five years, that is about $6.67 per month in depreciation. Add that to your shop overhead tab and your project costs will reflect true ownership. It sounds tedious. It changes whether a project makes financial sense. Neither of those adjustments appears in beginner guides. They appear in practice after a few years of watching numbers not add up.
Bottom Line
A Monthly Woodworking Tracker is not a magic fix. It will not make you a better craftsman. It will tell you where your money goes, how long things actually take, and which habits are costing you more than they should. The best version is the one you keep using. That means simple columns, daily entries, and formulas that do not depend on fragile macros. Anything more elaborate than that is usually a sign you are avoiding the shop.
