A parts inventory spreadsheet is a sheet that tracks what parts you have, how many, and when to reorder.
A parts inventory spreadsheet is what separates the shop that knows exactly what’s on the shelf from the shop that finds out a part is gone right when the car’s already on the lift. If you run a shop, you know the feeling: a job stalls because the part you were sure you had ran out last week, and now you’re paying rush shipping or running to the parts store while the customer waits.
To make this easier, we put together a free parts inventory spreadsheet for auto repair shops, ready to download in Excel. It’s free, downloads instantly, and no email required. The columns are already set up for you: part number, supplier, quantity on hand, minimum stock, cost, and status.
📥 Parts Inventory Excel Template for Auto Repair Shops
Free, instant download, no email needed. Download the spreadsheet »
The short version
- A parts inventory spreadsheet tracks what you have, how much, and when to reorder.
- The columns that matter: part number, supplier, quantity on hand, minimum stock, cost and price, status.
- The real win is setting a minimum stock (reorder point) for each part so you order before you run out, not after.
- A spreadsheet is a great start. Once deducting parts by hand on every job gets old, a shop management system with built-in inventory does it for you automatically.
Why track auto repair shop inventory
Inventory control comes down to one thing: knowing at any moment what you have, how much, and when to restock. Every part on the shelf is cash that left your register (the same money logic behind your auto repair shop expense spreadsheet), and every part that goes out on a job needs to come off the count. Lose track of that and you get bitten from both sides.
On one side is the shortage: a job stops because the part you thought you had is gone, so you buy it in a hurry, pay more, lose margin, and blow the timeline. On the other side is the overstock: parts bought on impulse or “just to be safe” that sit for months, tying up cash you could have used elsewhere.
A shop that tracks its parts avoids both. You buy what you actually move, you catch a low part before it runs out, and you stop guessing.
What’s in the spreadsheet
The free spreadsheet is ready to fill in. Each part is one row, and the columns cover everything you need to keep your auto parts inventory straight:
- Part number: an ID for the part (the supplier’s or your own) so you can find it fast and not mix up similar items.
- Part and supplier: what the item is and who you buy it from, so restocking doesn’t turn into a scavenger hunt for a phone number.
- Quantity on hand: how many units are on the shelf right now.
- Minimum stock: the level that, once you hit it, is your signal to reorder.
- Cost and price: what you paid and what you charge, so you can see the margin on every part.
- Status: shows at a glance whether the part is OK or has hit its minimum and needs a reorder.
Once that’s filled in, one look at the sheet answers the question that costs the most in a shop: “Do I have this part, or do I need to order it?”
How do you calculate minimum stock (reorder point)?
The secret to never getting caught short isn’t stocking a ton of parts. It’s setting the right minimum stock for each item. Minimum stock is the quantity you never want to drop below. When you hit that number, it becomes your reorder point, the moment to place the order.
How do you set it? Look at two things: how fast you move that part, and how long your supplier takes to deliver. A fast-moving part from a slow supplier needs a higher minimum. A part you rarely touch that shows up next day can run a lower minimum.
Here’s an easy way to set it:
1. Estimate how many of that part you use per week, on average.
2. Check how many days your supplier takes to deliver after you order.
3. Your minimum stock is roughly what you’ll use during that delivery window, plus a little cushion for a busy week.
4. When quantity on hand hits the minimum, order. Don’t wait for zero.
5. Revisit your minimums now and then. A part that’s been sitting can drop to a lower minimum, and a part you ran out of needs a higher one.
In the spreadsheet, the Status column flags a part the moment it hits its minimum. That’s what turns inventory from guesswork into a decision.
Inventory mistakes that cost real money
1. Not deducting a part when it goes out
A part installed on a car but never taken off the sheet is stock that exists on paper but not on the shelf. The moment you trust that number, it’s wrong. Deduct the part the second it goes out.
2. Buying “just to be safe” without checking turnover
Overbuying out of fear of running short locks your shop’s cash into parts that don’t move. Every item sitting still is money that isn’t working. Buy based on your minimum and how fast the part actually moves, not on impulse.
3. Not setting a minimum stock
With no minimum set, you only find out a part is gone when the job needs it. The minimum is what buys you time to restock before the shortage. Set one for every part you actually move.
4. Trusting your memory instead of the sheet
“I think we still have one” is the phrase that stalls the most jobs. What counts is the number on the sheet, kept current. Log every part in and out, and trust the record, not your head.
Spreadsheet or software: which should you use?
A spreadsheet solves the problem today, and it beats nothing. It starts free and gets your parts organized. But as the shop grows, deducting every part by hand gets old, the number on the sheet stops matching the shelf, and it gets hard to tie a part to the repair order it went out on. At that point you’re really after auto parts inventory management, not just a sheet.
That’s where a shop management system with built-in inventory takes over. In Garage, parts come off the count automatically the moment you add them to a repair order, so your stock always matches reality. You see low-stock parts at a glance, tie every part to the job and the customer, and pull it all up from your phone or computer. If your shop is past the point where a spreadsheet keeps up, that’s the upgrade.
Frequently asked questions
Is the parts inventory spreadsheet really free?
Yes. Download it in Excel, with no email or signup required. It’s yours to keep and edit.
Do I need Excel to use it?
It’s an Excel file, but it also opens in Google Sheets for free if you don’t have Excel.
How is this different from the Garage app?
The spreadsheet is a manual starting point. The Garage app deducts parts automatically as you use them on repair orders, flags low stock, and keeps your inventory tied to jobs and customers, so you’re not updating a sheet by hand.
How many parts can I track?
As many rows as you want. For a handful of common parts it’s plenty. Once you’re managing hundreds of SKUs across a team, a system will save you the manual work.
Bottom line
A parts inventory spreadsheet turns “I think we have it” into a number you can trust. Download the free Excel template », set a minimum stock for the parts you move, and you’ll stop losing jobs (and margin) to a part that ran out when you weren’t looking. Pair it with our free auto repair shop forms kit to round out your shop paperwork, and when the manual updates start eating your time, start a free trial of Garage and let it pick up the counting for you.
