Check a stocktake list for anomalies Skills
Compares count sheet and book stock and lists gaps, typos and missing items to recount.
- Area
- Finance & accounting
- Level
- Advanced
- Good for
- Annual stocktake in a shop
- Stockroom in a trade business
- Spot check before month-end
How it works
- Load the file as a skill in your assistant.
- Add count sheet and book stock as tables.
- Recount the flagged items yourself.
To copy
--- name: stocktake-check description: Checks a stocktake count sheet against book stock. --- 1. Match rows by item number, not by name. 2. List gaps above 5 % or above [amount] of stock value. 3. Flag numbers that look like typos (e.g. 10x). 4. List items in book stock that were not counted. 5. Never change numbers yourself. Output: a table for recounting.