Cycle Counts in QuickBooks Advanced Inventory: Limits and Workflow

Cycle counting in QuickBooks Enterprise Advanced Inventory is a staged process with two built-in limits that catch new users off guard. A single count holds at most 5,000 tasks. Large selections are also split automatically into groups of 200 lines, so one request can return several count documents. We have walked through the full sequence below, from selecting items to locking the finished count.

Building the count from the Inventory menu

Open the Inventory menu, choose Cycle Count, and create a new count. Select a site first if your company counts by location. Then open Find & Select Items and search for what you need. Custom fields work as filters here, which matters when dozens of items qualify. Tick the checkbox beside each item and choose Add Selected Items, and the count form appears.

Every line on that form is one item in one bin. A part kept in three bins appears three times, once per location, and each line is counted on its own. You can also assign the whole document to a named warehouse person before it goes out the door.

Why does one selection become several counts?

The software will not build one oversized worksheet. On creation, it divides your lines into groups of 200 automatically. Pick 400 item-and-bin combinations and two counts come back instead of one, which surprises people the first time.

There is also a hard ceiling of 5,000 tasks per count. If a selection runs over, trim items until you sit at or under the limit, then handle the remainder in a second count. Both behaviors appear aimed at the handheld experience: short lists are easier to scan without losing your place.

Two ways to run the physical count

The electronic path sends the list to a scanning device. Choose Send to device, confirm the success message, and the warehouse worker walks each item and bin, scanning until every line is finished. Sending the results back to QuickBooks puts them on the dashboard, though a refresh is sometimes needed to see current figures.

Paper works in the other direction. Send to Excel creates a spreadsheet you can print, and the worker writes counted totals on the sheet by hand. A tablet serves just as well, since the same sheet works electronically. Nothing else about the count changes between the two paths.

Getting the totals onto the dashboard

Paper counts have to come back in somehow. The dashboard offers Import from Excel for the finished sheet, with prompts to guide you, or you can type each figure manually and save. Device counts skip this step because their totals arrive on their own.

Statuses tell you where each count stands

Open means the count is in process. Complete is assigned automatically when the counted quantities match the QuickBooks quantities, so clean counts finish themselves. Pending Review appears in the opposite case: the shelf and the books disagree. That status is your cue to decide which side is right before anything changes.

Resolving the discrepancies

Pending Review counts are settled through Batch Actions on the dashboard. Choose Adjust Quantity/Value on Hand, acknowledge the information pop-up, and an adjustment window opens listing every mismatch found. Review the lines, then use Save & Close to accept all of them at once. The same menu also holds Export to Excel and Mark as Closed, the three tools you will reach for most.

Closing locks the count

Finish by selecting the completed lines and choosing Mark as Closed. Treat that as a lock on the file. No edits are possible after closing, so every adjustment must be posted first. Counts left unclosed simply keep sitting as open work.

A little arithmetic before you build the count prevents most surprises. Multiply items by their bin locations to estimate the task total, and you will know how many documents to expect and whether the 5,000-task ceiling is in play. Post every adjustment before you close anything, and the exercise stays clean from shelf to ledger.