The stock count changed while the team was still counting

Record the counting window before comparing numbers

Write down when counting started and when it ended, who counted, the location, and the exact product or variant identifier. Then write the second pair of facts people usually skip: the quantity physically observed and the time the system figure was read. A count finished at noon compared with a figure read at three in the afternoon is not yet a discrepancy; it is two observations separated by a window in which stock may have moved.

Preserve the original count sheet or entry exactly as it was made. If the team recounts, the new number is a new observation with its own time, not a correction to the first. Two different counts at two different times can both be accurate, and treating one as the truth by preference is how real shortages get hidden.

Pull every movement recorded inside the window

On Shopify, the inventory adjustment history records the time of each change, the activity, the staff member, app or channel responsible, and the quantity change, with reasons that include counts, corrections, receipts, returns, damage, loss and donations. The history can contain both automatic and manual changes, so a figure that moved while the team counted may show exactly which sale, receipt or correction moved it and who or what made the entry. Filter that record to the affected identifier and the window you wrote down.

That history is Shopify's record; another platform's audit trail must be read from its own documentation, and the availability and retention of history varies by view. Remember also that not every movement reaches a system promptly. A paper pick list, a transfer between shelves or a return placed directly into sellable stock can move units with no same-day record. Those movements are not disproved by their absence from the history; they are unresolved until their owner documents them.

Reconcile in order, and keep the arithmetic visible

Pick one comparison timestamp and hold to it. The natural target is the moment the item was actually observed: a count spans an interval, but each item was seen at one point inside it, which may differ from the count's start or end. Then move the recorded figure to that same observation moment before comparing. If the system snapshot you have is earlier than the observation, roll it forward: add each documented receipt and subtract each documented pick or other removal that occurred between the snapshot and the observation. If the snapshot is later than the observation, roll it backward: subtract each receipt and add back each pick or other removal from the interval between the observation and that later snapshot. Every movement is applied exactly once, in the direction that moves the snapshot toward the observation moment — never both directions, and never twice. Compare the resulting observation-time estimate with the physically observed count. If the documented movements account for the difference, the discrepancy was timing. What remains unexplained after every movement is applied, in the correct direction, is the variance — and if the observation moment within the counting interval is itself uncertain, keep that uncertainty in the finding rather than resolving it by preference.

List movements individually rather than netting them. A receipt of twenty and picks of seventeen are two events with two owners, and collapsing them into plus three destroys the trail you would need if one of them turns out to be wrong. A later system number by itself proves nothing about whether the counter was wrong; the unsupported claim to avoid is that a quiet window or a later figure settles the question without the movement records.

Escalate what the records cannot settle

The remaining variance belongs to the authorized inventory owner, not to the counting team. Record the unexplained quantity, the movements already ruled out, the person approving any adjustment, the reason they accepted and the date. That approval is a decision made on evidence, and it stays attached to the evidence. An adjustment entered to make the sheet tidy, with no movement record and no approver, is exactly the invented balancing figure this process exists to prevent.

If the disagreement involves how the store displays stock or how a connected feed times its writes, that is a website and systems question as well as a counting one. A Prism storefront consultation can discuss that concern within an agreed scope; confirm responsibilities, fees and terms before any work begins.

Count-time and intervening-movement worksheet

Use one sheet per affected product or variant and per counting event. Fill every row from genuine records; write unknown where a record does not exist. The worksheet reconciles timing against movement; it never authorizes an adjustment by itself.

Worksheet entries are not submitted by Prism’s worksheet and are not saved by the site. Use record types, availability, anonymized observations, or match/mismatch results. Do not enter government identifiers, customer names or addresses, customer messages, receipt-access links, card or bank details, passwords, or keys. Send sensitive documents only through the provider’s verified secure channel.

These are temporary notes. Leaving or reloading this page may clear them. Worksheet entries are not sent automatically. If you copy notes into the consultation message and submit the form, Prism receives them as part of your request.