Guide
Warehouse Inventory Tracking:Perpetual and Periodic Methods, Bin Locations, Barcodes and Cycle Counts for a Parts Warehouse
Warehouse inventory tracking for a service company parts room: perpetual and periodic records, bin locations, barcodes, cycle counts and record accuracy.
Warehouse inventory tracking records what sits on each shelf by one of two methods. A perpetual record changes with every receipt, issue and return and shows stock at any moment; a periodic method knows stock only when someone counts it. A parts warehouse adds bin locations, barcodes and cycle counts that test the record.
A service company's parts room shows its tracking method at the worst moment: a technician drives to the shop for a part the system lists, finds an empty bin, and drives on to the supply house. The count was wrong for weeks before anyone looked, because nothing in the method compared the record with the shelf. This guide is one of the guides for service business owners. It compares perpetual and periodic tracking, then covers bin location codes, barcode types and scanners, cycle counts and the accuracy measure that grades them, and works through a sample year in a parts warehouse before a checklist and the software record.
Four terms carry the method. A SKU, or stock keeping unit, is one item the warehouse stocks, such as a 45/5 microfarad run capacitor. A bin location is the fixed address of a SKU on a shelf. The book quantity is what the record says is on hand; the counted quantity is what is there. A hit is a count within tolerance of the book quantity, and a miss is one outside it.
Perpetual and periodic inventory tracking compared
The two methods differ in when the warehouse knows its stock. The IRS allows the cost of goods on hand to be figured "by either a perpetual or book inventory if inventory is kept by following sound accounting practices", requires the accounts to be charged with the actual cost of goods purchased and credited with the value of goods used, transferred or sold, and requires a physical inventory "at reasonable intervals" with the book amount "adjusted to agree with the actual inventory" (IRS Publication 538, revised January 2022, checked November 12, 2026).
| Question | Perpetual | Periodic |
|---|---|---|
| What is recorded | Every receipt, issue, return, transfer and adjustment, as it happens | Purchases as they happen; stock only at each count |
| When stock on hand is known | At any moment, from the record | On the count date |
| How cost of goods used is found | Summed from the issues | Beginning stock plus purchases, less ending stock |
| Where a missing part shows up | As a difference between book and count, reported on its own | Inside cost of goods used, with the parts fitted on jobs |
| What it needs | A record at every movement, by every person who moves stock | A full count at each period end |
The periodic calculation is the one on a sole proprietor's tax return. Schedule C's cost of goods sold section runs from inventory at the beginning of the year through purchases, labor, materials and supplies and other costs, less inventory at the end of the year, to cost of goods sold on line 42 (IRS Publication 334, 2025). A business can file that return from a periodic method and still have no idea which parts disappeared.
The perpetual record is only as good as its weakest movement. Receiving, checkout to a technician or job, returns, transfers between the warehouse and the vans, and adjustments after a count each change the book quantity, and the controls for each are set out in the guide to warehouse inventory. A perpetual record that misses checkouts is a periodic method with extra typing.
Bin location codes for a parts warehouse
A bin location turns "somewhere in the back" into an address a new hire can walk to. The code reads from the largest unit to the smallest, and every character has one meaning.
- Zone: a letter for the area, such as A for electrical parts and B for refrigeration fittings.
- Aisle or rack: a two-digit number, so that rack 03 sorts before rack 12.
- Shelf: a letter or number counted from the floor up.
- Bin: a position along the shelf, counted from the aisle end.
The code A-03-C-04 is zone A, rack 03, shelf C, bin 04. Three rules keep it usable. Each SKU has one home bin, and any overflow carries its own code recorded against the same SKU. The label on the shelf edge carries the code and the SKU number together. The record holds the location as a field, so a count sheet or a pick list can be sorted in walking order.
Location also separates the warehouse from the vans. A van is a location with its own code in the same scheme, so a transfer from A-03-C-04 to a van is a recorded movement between two addresses rather than a part that left the building.
Barcodes, labels and scanners for warehouse inventory tracking
A barcode removes the typed part number, one of the places a perpetual record picks up errors. GS1 US describes the main symbols (GS1 US, barcode types, checked November 12, 2026):
- UPC-A is "occasionally used for distribution like cases and pallets; however their main use is at retail point of sale".
- GS1-128 is "commonly used in support of cases involving general distribution and logistics applications", and can carry attribute data such as "best-before date, batch/lot number, quantity, weight".
- ITF-14 is used on cases and cartons not scanned at the point of sale, and suits direct printing on corrugated material.
- QR Code is used by consumers to link to information on the web, and a Data Matrix symbol "can encode up to 2,335 characters in a relatively small space".
Two labels serve a parts room. The manufacturer's barcode on the box identifies the product as sold, and it may identify the same capacitor differently from two suppliers. The warehouse's own label on the bin carries the company's part number, so that every scan resolves to one SKU and one location whichever supplier shipped the box. A scan at receiving reads the box; a scan at checkout reads the bin.
Scanners come in two classes. A phone camera reads printed codes at close range and needs no extra hardware; a dedicated scanner is built for scanning all day and costs money per unit. A parts room with one person issuing parts at the counter and technicians collecting their own in the early morning is a phone-camera room, because the scanner has to be in the hand of whoever takes the part.
Cycle counts and inventory record accuracy
A cycle count tests a slice of the record each day instead of all of it once a year. Oracle's inventory documentation describes one design: an ABC analysis ranks items by a chosen valuation, and the classes drive the count, so that items of high value are counted "very frequently, items of lower value less frequently, and items of lowest value very infrequently" (Oracle Inventory, ABC analysis). Each class is given a number of counts per year.
Accuracy is measured on the first count. Oracle's hit/miss tolerance is "the percentage variances of count quantity to on-hand quantity beyond which Inventory considers a count entry a miss for hit/miss reporting", based on the first count of an item, not recounts; a separate approval tolerance holds adjustments above a quantity percentage or value for approval before they post (Oracle Inventory User's Guide, defining cycle count classes, Release 12.1). The share of first counts that are hits is the record accuracy, and it is the number that says whether the perpetual record can be trusted to dispatch from.
Three practices protect the measure. The counter does not see the book quantity, so the count cannot drift toward it. A miss is recounted by a second person before any adjustment posts. Each adjustment carries a reason, which turns a run of misses on one shelf into a finding about receiving or checkout rather than a correction that hides it.
Sample year in a 600-SKU parts warehouse
The sample is a hypothetical HVAC service company's parts warehouse with 600 SKUs. All stock values, the class sizes, the minutes per count and the miss count are sample inputs; the calculation rules are the IRS and Oracle sources above, and the wage is the Bureau of Labor Statistics median.
The first table runs the same year through both methods. The periodic method finds cost of goods sold as the residual, as Schedule C does; the perpetual method sums the parts issued to jobs at cost.
| Line | Periodic | Perpetual |
|---|---|---|
| Stock at January 1, counted | $42,000 | $42,000 |
| Purchases in the year | $186,000 | $186,000 |
| Parts issued to jobs, from the record | Not recorded | $179,300 |
| Expected stock at December 31 | Not known | $48,700 |
| Stock at December 31, counted | $45,500 | $45,500 |
| Cost of goods sold | $182,500 | $179,300 |
| Unexplained difference | Inside cost of goods sold | $3,200, reported as an adjustment |
Both methods report the same ending stock, because both count it. The perpetual method also reports $3,200 of parts that left the shelf without reaching a job record, 1.75 percent of the periodic cost of goods sold. The periodic method carries the same $3,200 inside cost of goods sold, where it looks like parts fitted on jobs and never appears on an invoice.
The second table costs a cycle count program for the same 600 SKUs.
| Line | Figure | Basis |
|---|---|---|
| A items, counted 12 times a year | 60 SKUs, 720 counts | Sample input |
| B items, counted 4 times a year | 180 SKUs, 720 counts | Sample input |
| C items, counted once a year | 360 SKUs, 360 counts | Sample input |
| Counts in the year | 1,800 | Sum |
| Counts per working day, 250 days | 7.2 | 1,800 ÷ 250 |
| Minutes per count | 3 | Sample input |
| Counting hours in the year | 90 | 1,800 × 3 ÷ 60 |
| Hourly cost of a stock clerk | $17.95 | $37,330 median annual pay for stockers and order fillers, May 2025 ([BLS](https://www.bls.gov/ooh/transportation-and-material-moving/hand-laborers-and-material-movers.htm)), ÷ 2,080 hours |
| Labor cost of the program | $1,615.50 | 90 × $17.95 |
| First counts outside a ±2% tolerance | 54 | Sample input |
| Record accuracy | 97.0% | (1,800 − 54) ÷ 1,800 |
A single wall-to-wall count of the same 600 SKUs at the same rate takes 30 hours, or $538.50, and tests each item once. The cycle program costs $1,077 more in labor and tests each A item twelve times, which locates a recurring miss on a shelf in the month it starts rather than at year end. The blank layout for a sheet-based version of these records is the warehouse inventory tracking spreadsheet.
Warehouse inventory tracking for a service business and a warehouse management system
A warehouse management system directs work inside a building: receiving docks, putaway rules, pick paths, wave picking and shipping. A service business's parts warehouse needs less of that and more of something a WMS does not center on, which is the link from each part to the job and technician that used it. The software options at the warehouse end of that range, with their plan prices, are compared in the guide to the best warehouse inventory management software.
Warehouse inventory tracking checklist
- Decide the method: perpetual where parts are issued to jobs daily, periodic only where stock moves too little to justify a record at every movement.
- Give every SKU one home bin with a zone-rack-shelf-bin code, and put the code and SKU on the shelf label.
- Label bins with the company's own part numbers, and scan at receiving and at checkout.
- Treat each van as a location with its own code, and record every transfer between locations.
- Rank SKUs by annual value into A, B and C classes, and set counts per year for each class.
- Count blind, recount every miss with a second person, and post each adjustment with a reason.
- Set a hit/miss tolerance and an approval tolerance before the first count.
- Verify the method monthly: calculate record accuracy from first counts, and compare the year's adjustments with cost of goods sold.
Warehouse checkout and low-stock warnings in FieldRanger
FieldRanger is not a warehouse management system; it records parts at the points where a service business loses them, as set out on the warehouse inventory management software page. Technicians check parts and materials out of a specific warehouse, so stock is counted where it actually sits. Parts and materials used on each job are logged against that job for job costing, which is the perpetual record's issue line tied to a work order. Low-stock warnings and reorder reminders flag a SKU before its bin is empty.
The job side runs on HubSpot records. A won HubSpot deal becomes a job with its context carried over, the invoice is generated from the completed work order with the materials on it, invoices and payments sync with QuickBooks, and revenue reports show job revenue and margin by customer or service type. Plans and the 14-day Start free trial, with no card, are on pricing.
Frequently asked questions
What is warehouse inventory tracking?
It is the record of what is on each shelf, by item, quantity and location. A perpetual method updates the record at every receipt, issue and return; a periodic method establishes stock only when it is counted.
What is the difference between perpetual and periodic inventory tracking?
Perpetual tracking records every movement, so stock on hand is known at any moment and missing parts show up as count differences. Periodic tracking counts stock at period end and finds cost of goods sold as beginning stock plus purchases less ending stock, which hides missing parts inside that cost.
How to set up bin locations in a parts warehouse?
Give each SKU one home bin with a code read from largest to smallest unit, such as zone, rack, shelf and bin (A-03-C-04), print the code with the SKU on the shelf label, and store the location in the inventory record.
What barcode should a parts warehouse use?
The warehouse's own label on each bin, carrying the company part number, in a symbology its scanners read. Manufacturer UPC barcodes identify the product as sold; GS1-128 and ITF-14 appear on cases in distribution.
How is inventory accuracy measured?
As the share of first cycle counts that fall within a set tolerance of the book quantity. In the sample above, 54 misses in 1,800 counts gives 97.0 percent record accuracy.
How frequently should warehouse inventory be counted?
The IRS requires a physical inventory at reasonable intervals for a business keeping book inventory. A cycle count by ABC class meets that, with high-value items counted monthly and low-value items once a year in the sample program.
Parts worth $3,200 left the sample shelves without a job number; the periodic method books that sum as cost of goods sold, and 1,800 blind counts at $1,615.50 of clerk time show which shelves it left from. The other records a growing company keeps sit under guides for service business owners.
Run field service on HubSpot with FieldRanger
Estimates with e-signature, scheduling and dispatch, a technician mobile app and invoicing, synced to the HubSpot deals and contacts the business already keeps.
Book a demo