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.
