Auto parts inventory management for a year-end count

A year-end count in an auto parts warehouse is easy arithmetic and hard control. The risk is not adding wrong. The risk is losing track of which item was counted and where it was found.

You are the warehouse manager or controller at an auto parts distributor. Your books are on QuickBooks Online, you have no warehouse management system, and you do one full physical count at year end. If you need to explain to the owner or the accountant why a full count is worth the effort, read why physical counts still matter.

Set five controls before count day

The same item in more than one location

Fast movers are stocked at the counter and again in the back, and a pallet of the same item may be in receiving on count day. Count by location, so each counter owns a set of locations and nobody counts one twice. Add the locations together before you compare the item with the books, or the counter bin and the back bin each look like a shortage.

The location counts stay as the evidence behind the total. The guide to QuickBooks Online inventory limitations shows the sum with the demo company's numbers and writes out the hand procedure in full: sum by item, compare with the books, recount, then adjust.

Keep look-alike part numbers straight

A counter may see an old label, an interchange number or a barcode that differs from the number the office uses. If one physical item is recorded under two records, the count shows an overage on one item and an equal shortage on another, and both look real until someone puts them side by side.

1. Choose the item record that receives the physical quantity, and put that identifier on the count sheet.
2. Write down valid aliases, superseded numbers and barcodes before the count, not during it.
3. When an identifier matches no QuickBooks item, set the item aside with its quantity, location and label rather than guessing or creating a duplicate.
4. Review opposite-sign variances on similar part numbers together; they usually describe one identification error.

In InventoryWare Count, an item can carry aliases and multiple barcodes as identifiers. The mobile counting app scans eight barcode formats with the phone camera, including Code 128, Code 39 and QR. Scan a sample of your labels before count day instead of assuming every printed barcode reads.

Counter sales and receiving during the count

Pause movement during the count if you can. If the counter has to stay open or a delivery is due, set a cutoff time and keep a movement log: each sale, receipt or transfer after a location was counted gets written down, so reconciliation can put the units on the right side of the cutoff.

Name one person to settle timing questions. A counter should not have to decide whether the box that just arrived belongs in the completed count.

Investigate and approve variances before adjusting QuickBooks

QuickBooks quantity on hand is the book total for an item, with no location behind it. Your count is the sum across the locations in scope. Any difference is the variance, and quantity on hand in QuickBooks covers the book side.

For each variance worth explaining, keep the location counts, the recount, the explanation, the accepted quantity and the manager's approval together. When staffing allows, the person who counted is not the person who approves. That record is what the accountant asks for when the adjustment is questioned.

If your company shows an "Inventory counts" option under Products and services, Intuit's instructions have you enter one New Quantity per product and finalize, which creates the adjustment. The location work above happens before that screen, the same as it happens before the adjustment form.

How InventoryWare Count fits an auto parts distributor

In Count, every counted quantity is recorded against a location, and an item's counted total is summed across the plan's locations. Locations can be imported from CSV, XML or Excel files and exported the same way, so the list you keep today is the starting point. Companies not on QuickBooks Online can import items as well as locations from CSV or Excel and export the variance report to Excel or PDF.

Count connects to QuickBooks Online and imports items with their QuickBooks quantity on hand; the adjustment compares each counted total with that QuickBooks quantity. An item nobody counted is never adjusted automatically. An item that QuickBooks shows in stock and nobody counted is listed as a possible missing item, and it is sent as zero only after a manager approves it as zero.

Nothing posts to QuickBooks until the count plan is complete, and then only the lines a manager has approved post. Only a count manager or the company owner can approve a discrepancy. A manager can reopen a location for recount from the plan audit screen.

Variance and count reports can be exported to Excel and PDF, so the accountant sees the same numbers you did.

Count is built for one complete physical count; posting adjustments to QuickBooks from a partial count is not available. It is not a parts-management system or a WMS, and a parts counter that wants rolling weekly counts posted to its books is not who it is for. Item limits are 2,500 on Essentials and 10,000 on Growth.

Test the controls on ten items first

Pick ten items across your zones and run a sample count before the whole warehouse. Include an item stored in two places, a core or a return, and a label that needs an alias. If the team can prove coverage and explain the accepted result on ten items, it is ready for the whole warehouse.