Inventory Count and Stock Accuracy Audit
Compare physical counts with records and find reasons for differences.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Audit stock accuracy. A table of items with system quantity, counted quantity, unit cost, and notes: [STOCK_COUNT]. Recent deliveries, returns, damages and transfers: [MOVEMENTS]. Calculate the variance for each item (counted minus system), the value of the variance, the percentage accuracy by line and overall, with the arithmetic. Identify items with large variances and categorise possible causes (receiving errors, unrecorded sales, damage, theft, miscount, unit of measure). Make a table with Item, Variance, Value, Likely cause, and Check. Propose a cycle count schedule (high-value items more often), a process for adjustments with approval, and controls for receiving and returns. Use only my numbers. Do not accuse anyone. Mark accounting treatments of write-offs for confirmation by an accountant [VERIFY]. Add a worked variance: item A system 120, counted 112, variance -8 at 6.50 is -52; item B system 40, counted 44, +4 at 12 is +48; item C system 300, counted 300; overall accuracy by line 1 of 3 exact, and value variance net -4. Explain causes to check for A and B, such as unrecorded returns or receiving into the wrong code.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.