Free template

Parts inventory spreadsheet.

Short answer: A parts inventory spreadsheet tracks each part number with its location and bin, quantity on hand, minimum and maximum, cost and sell price. Reorder when on hand falls to the minimum, up to the maximum.

Download CSV (Excel, Google Sheets)Get a walkthrough

Parts inventory

Part number	Description	Location / bin	On hand	Min	Max	Cost

How to use it

Give every part one home.
Set min and max from real usage.
Count a few bins each week instead of everything once a year.

Questions

What is a blind count?

Counting without seeing the expected quantity, so counters do not count to the screen. MetaFleet supports blind counts on a phone.

Is it free?

Yes. Print it, save it as PDF from the print dialog, or download the CSV where offered. No sign-up.

Parts inventory Parts markup calculator Service truck inventory

Get a walkthrough

See it on one of your own jobs

Bring a real repair order. We will run it through MetaFleet live.

Get a walkthrough Or call (838) 438-6382