Skip to content

Auto Repair Shop Inventory: Shelf Parts and Fluids

An auto repair shop inventory list: the fast parts and fluids kept on the shelf, reorder levels, battery date codes, shop supplies, the count, a free file.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

A repair shop that orders most parts for the car on the lift keeps very little of what it sells. What it does keep is the stuff it can't wait for: filters, oil, fluids, pads for the common cars, wipers, bulbs, batteries, and the shop supplies that go into every job and onto no invoice. That's a short list, and it's the one worth keeping, because every item on it is a bay standing idle when it runs out. An auto repair shop inventory list has a row for each of those, with on hand, a reorder level, what it cost and where it is. Below is a list for a made-up two-bay shop, how to set levels, what to do about job parts and cores, and the file.

The short version

  • List what you keep on the shelf: the fast parts, fluids and shop supplies.
  • Parts ordered for one job go on that job's ticket, not on this list.
  • Reorder level = what you use while waiting for the next delivery, plus a cushion.
  • Sell batteries by date code, oldest first.
  • Count shop supplies. They cost money and nobody bills them.
  • Count on the same day each week.
  • TaroStack keeps the shelf current and suggests what to reorder. More below.

An example list

Counted on a Saturday afternoon.

Item Unit On hand Reorder at Unit cost Value Status
Oil filter, common spin-on each 28 24 $4.10 $114.80 OK
Engine air filter, common size each 9 12 $8.60 $77.40 REORDER
Motor oil, 5W-30 synthetic qt 140 120 $5.25 $735.00 OK
Coolant, 50/50 gal 14 10 $9.80 $137.20 OK
Brake fluid, DOT 3 qt 10 12 $6.40 $64.00 REORDER
Brake pads, front, common fitment set 6 6 $31.00 $186.00 REORDER

Ten rows in all, $1,863.40 at cost, with five to reorder: air filters, brake fluid, brake pads, batteries and brake cleaner. Oil is the biggest line, $735.00.

Setting a level

Oil filter, common spin-on
Oil changes a day that take it 2
Days from order to delivery 2
Used while waiting 4
Cushion: a busy week, a wrong box 20
Reorder at 24

This shop's distributor delivers in two days, so the "used while waiting" part of its level is small. The cushion is the bigger part, and it's a judgment: this shop would rather keep two weeks of a four-dollar filter in reserve than have a car wait once. A $96 battery gets a level of four. The sum is in reorder point example.

What makes a part worth a row at all? This shop's test is whether it fits three or more cars a month. Below that, it's ordered for the job.

Job parts, and cores

Parts for one job aren't shelf stock. They arrive, go on the car and go on the ticket. If the job is cancelled, the part goes back to the distributor that week, or it becomes a row on the list with a note. The boxes that pile up on the top shelf are returns nobody sent.

Cores. This shop's suppliers add a core charge to a battery, an alternator or a caliper, and refund it when the old part goes back. A core sitting in the corner is money owed to the shop. This shop keeps a short list: part, date, core charge, sent back or not.

Dates and codes

Received Item Lot or date code Quantity Note
Nov 4 Battery, group 35 Date code K26 4 Sell the oldest date code first
Oct 20 Brake fluid, DOT 3 Lot 26-2931 12 qt Opened bottles aren't put back on the shelf
Nov 10 Motor oil, 5W-30 synthetic Drum 4471 220 qt

The batteries this shop buys carry a date code, and it sells the oldest code first so that none sits for a year. Write the code at receiving and put new stock behind old. The lot on a drum of oil or a case of fluid is what a supplier's notice will name, if one ever comes.

Shop supplies

Brake cleaner, gloves, rags, thread locker, zip ties. None of it is on an invoice, and all of it is on a statement at the end of the month. Count it like anything else and you'll see what a month uses. Whether to bill it as a line is a pricing question. Knowing the number comes first. Tools are a different list: see tool inventory list.

Get the list

Download the auto repair shop inventory. Four sheets: inventory with value and REORDER, deliveries with lots and date codes, a count sheet that works out each difference and what it's worth, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. A count plan is in cycle count form.

Where this stops working

A technician takes two quarts of brake fluid and a can of cleaner off the shelf for the car in bay one. Nothing on the list changes. By Friday the list says ten quarts and the shelf has four, and the Saturday count is the only moment the two agree. In between, the list can't tell anyone what to order.

How TaroStack does it

TaroStack keeps the shelf current between counts.

Receiving adds stock as it arrives, with or without a purchase order, at what you paid, with a lot or date code where there is one.

Counting works on a phone, shelf by shelf. A count shows what each difference is worth.

Every adjustment carries a reason: used on a job, damaged, returned.

A reorder list in days of cover, with each supplier's lead time and minimum, and reorder points suggested from how stock actually moves.

Barcodes by phone camera or scanner for counting and receiving.

The job Spreadsheet In TaroStack
What's on the shelf As of Saturday Kept current
What to order from the distributor Rows that look low A reorder list by supplier
Which battery is oldest Read the stickers Stock by lot
What shop supplies cost this month The statement Adjustments by reason

TaroStack doesn't write repair orders or take payments. Stock, counts, receiving and reordering are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

What inventory should an auto repair shop keep?

The parts and fluids it can't wait for: filters, oil, coolant, brake fluid, pads for common cars, wipers, bulbs, a few batteries, and shop supplies. Parts for a single job are ordered for that job.

How do you track parts in a repair shop?

Keep a row for each shelf item with the count, a reorder level and the cost. Put job parts on the job's ticket. Count the shelf on the same day each week.

How many of each part should a shop stock?

Enough to cover use while a delivery comes, plus a cushion sized to what running out costs. In the example a $4 filter has a two-week cushion and a $96 battery has a level of four.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.