How do you calculate pick accuracy?

Divide the audited picks without an error by the picks audited. 247 of 250 is 98.8%, 3.8 points above a 95% target, the Pick Accuracy calculator's own example.

Why show errors per 1,000 picks as well?

Accuracy near 100% hides differences: 99.0% and 99.5% look close but one has twice the errors of the other. Errors per 1,000 (10 against 5) shows the size of the problem and charts better.

What counts as a pick error?

A wrong item, a wrong quantity, a line missed or short-picked, or a damaged item sent. Count each wrong pick once, under its main cause, so the causes add up to the errors.

How many picks should I audit?

Enough that one error does not swing the figure: at 250 picks one error moves accuracy by 0.4 points. Audit a random sample across pickers and shifts rather than the easiest orders.

What does Near target mean here?

Accuracy below the target by no more than the near band on Setup, in percentage points (0.3 in the example). Further below is Below target.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test audits and shows Self-check: PASS.

Packaging and Warehouse

Pick Accuracy Tracker Excel Template

Pick accuracy = picks without error ÷ picks audited. Log every week's pick audit in every zone with the errors found by cause, and see accuracy against your target, the gap in points, errors per 1,000 picks, each zone over the period and the whole site week by week.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This pick accuracy tracker is a working Excel workbook for warehouse and distribution managers, inventory control and quality leads, and fulfilment supervisors. Each zone has a row each week with the picks audited before shipping and the errors found, split into wrong item, wrong quantity, missed and damaged. The workbook gives each zone's accuracy and gap to your target in percentage points, errors per 1,000 picks and a status, then totals every zone over the period and the whole site week by week. It ships with eight weeks of audits in five zones at a fictional distribution centre, so every tile and chart is filled in when you open it.

In the example the site audited 16,400 picks and found 75 errors: 99.54% against a 99.5% target. Pick zone B was re-slotted in week 4 and its wrong-item and wrong-quantity errors more than doubled until the slot labels were corrected in week 7; over the eight weeks it ran at 99.13%, below target. The cold room missed picks every week, 10 of its 18 errors, and sits near target at 99.25%. The site went from 3.4 errors per 1,000 picks to 6.3 and back.

Accuracy is for the audited sample; small samples swing widely from week to week. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your site, the pick accuracy target and near band, and the zones
Audits table, one row per zone per week: picks audited and errors by cause (wrong item, wrong quantity, missed, damaged), with a Check column
Per row: errors, picks without error, accuracy, gap to target in points, errors per 1,000 picks and a status in words
Dashboard with four tiles (picks audited, errors, pick accuracy against target, zones below target), errors per 1,000 picks by week against the target's equivalent, errors by cause in each zone, and the zone and eight-week tables
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Pick Accuracy calculator (Self-check: PASS)
CSV with live formulas for the Audits table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it for a weekly warehouse quality review, to find the zone and the error type that pull accuracy down, or to check whether a slotting or process change made picks better or worse.

How to use it

On Setup, type your site, the accuracy target and near band, and list your zones.
On Audits, give each zone a row each week: picks audited and the errors found by cause.
Fix anything the Check column names.
Open the Dashboard: errors per 1,000 picks by week, and errors by cause in each zone.

Frequently Asked Questions

How do you calculate pick accuracy?: Divide the audited picks without an error by the picks audited. 247 of 250 is 98.8%, 3.8 points above a 95% target, the Pick Accuracy calculator's own example.
Why show errors per 1,000 picks as well?: Accuracy near 100% hides differences: 99.0% and 99.5% look close but one has twice the errors of the other. Errors per 1,000 (10 against 5) shows the size of the problem and charts better.
What counts as a pick error?: A wrong item, a wrong quantity, a line missed or short-picked, or a damaged item sent. Count each wrong pick once, under its main cause, so the causes add up to the errors.
How many picks should I audit?: Enough that one error does not swing the figure: at 250 picks one error moves accuracy by 0.4 points. Audit a random sample across pickers and shifts rather than the easiest orders.
What does Near target mean here?: Accuracy below the target by no more than the near band on Setup, in percentage points (0.3 in the example). Further below is Below target.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test audits and shows Self-check: PASS.