Stocktakes Online
User manual · Australia
Open the portal

Reports and variance

What you counted, and how it compares.

Reports

One stocktake at a time, totalled by bin, by site, by company and by operator, with a bar graph comparing operators and the raw counts in the order they happened. Everything is on screen, printable and exportable to CSV.

The Reports tab: a stocktake picker, a report picker, and Refresh, Print, Export CSV and For Excel buttons above a totals table.
Two pickers and four buttons. Print and Export CSV sit beside every report rather than being hidden on one — whatever is on screen is what you get.

The one worth reading first is what was missed: parts never scanned by anybody, bins nobody visited, and bins marked empty. A bin nobody reached and a bin checked and found empty are different answers, and they are reported differently.

Withdrawn counts are out of every total. The row stays, so you can see that a figure was taken back.

The company totals report headed INCOMPLETE, naming the two sites still counting, above the per-part totals.
It says INCOMPLETE before it says anything else. Both sites are still open, so the total underneath is a running figure rather than an answer, and the report names which sites rather than leaving you to work it out.

Variance

Only if you loaded an accounting file. Five answers, and all five matter:

HeadingMeans
Agreecounted, and the accounts say the same
Shortfewer on the shelf than the accounts say — stock that has gone somewhere
Overmore on the shelf than the accounts say
Never countedin the file, never scanned by anybody
Not in the filecounted, and your accounts do not carry it
The variance summary: ten agree, three short, three over, two never counted, one not in the file, zero not in the catalogue, above the short list.
The whole count in one line, with the file named underneath and Net −2, 56 counted either way — two figures that stop a small net difference being read as a small problem.

Agreeing at zero is still agreeing, and being over from an expected zero is a real finding — the count found stock your accounts do not know about. Both are reported rather than hidden.

The variance sections: short, over, and in the file never counted, each listing parts with expected, counted and variance columns.
Each answer gets its own section and its own sentence. In the file, never counted carries no counted figure at all — a dash, not a zero, because nobody looked, and zero would be a claim that somebody did.

Over a warehouse move these answers are worded differently — arrived, short on arrival, not arrived and the rest — because the expected side is another one of your counts rather than your accounts. The comparison is the same one. See phase 7 of Moving a warehouse.

All sites, or one

Pick All sites to read the company answer. The portal takes the latest count at each site, which is the same rule the company-wide report uses, so the two can never disagree about what the company is.

Per-site answers are offered only when the file you loaded can honestly produce one. If your export had no site column, a per-site figure would be short by everything the other warehouses hold, so it is not offered at all rather than offered with a caveat.

Parts your catalogue does not have

Kept and reported, never thrown away. It is stock the count could never have found, and it usually means the part list and the accounts have drifted apart — which is worth knowing before next year.