Reconcile Stock Movement Before Calling a Gap Shrinkage — Free
A missing unit is not automatically theft. Compare a movement-adjusted expected balance with the physical count, then price the signed difference to prioritize reconciliation.
The proof surface
Stock-cover checks ask when to reorder. This asks whether the physical count agrees with recorded stock movements at one cut-off time.
Why the flat version breaks
Skipping stock movements
Comparing opening stock directly with the count makes legitimate sales look like loss.
Netting away a surplus
An unexpected surplus can reveal the same recording problems as a shortage.
Mixing different item costs
Use separate runs when a shared unit cost is not appropriate.
How to work the stocktake variance packet
Outside the tool, add receipts and returns to opening stock, then subtract recorded sales, write-offs and transfers. Use the same cut-off for every source.
Include agreed locations and segregate damaged or quarantined units consistently. Enter one distinct item per row; only group items with the same cost assumption.
Cost variance = (expected minus counted) × unit cost. Three missing mugs at 8 cost 24; two extra bowls offset that by −16. The sample net is 8, but both rows still need review.
Any nonzero difference is flagged, including a surplus. Check receipts, transfers and timing errors before adjusting accounts. The net summary must not hide opposite row discrepancies.
What the stocktake variance packet replaces
| Question | Before | Visible working |
|---|---|---|
| Skipping stock movements | Comparing opening stock directly with the count makes legitimate sales look like loss. | Count physical stock independently |
| Netting away a surplus | An unexpected surplus can reveal the same recording problems as a shortage. | Price the signed discrepancy |
| Mixing different item costs | Use separate runs when a shared unit cost is not appropriate. | Investigate before booking a loss |
A local arithmetic aid replaces hand calculation, not expert review. No paid AI service is needed.
Run it on the samples, right here
FIRST-LOAD
Research prototype — checkout unavailable. Input is processed locally and a draft is saved automatically in this browser profile when storage is available. Reset to sample clears that draft; Pro history has its own clear button. A state link encodes your inputs in its URL: share only non-sensitive rows. Browser history, clipboard and anyone receiving the link may retain it. Optional AI use below leaves this device; it is not required.
Reconciliation arithmetic only, not accounting, tax, legal or fraud advice. Validate records with the responsible bookkeeper before posting adjustments or making allegations.
Data note: Everything runs in this browser tab on the stocktake variance packet: your item | expected closing units | counted closing units stays on this device, nothing is uploaded, and the reading is rebuilt only when you press run.
Go deeper: the companion app files the same reading as a stapled evidence packet
The article demo above runs without limits. The companion app keeps a local history, exports the rows as CSV, prints the stocktake variance packet reading, and holds your drafts on this device — one complete free run; the proposed $4 one-time filing layer is not currently for sale.
The stocktake variance packet reading is complete for free. The optional $4 layer adds print, row CSV and the last five local reading summaries; it does not add hidden answers. Checkout is not configured yet; the article demo remains unlimited.
Open the reconcile stock movement before calling a gap shrinkage companionBoundary
Reconciliation arithmetic only, not accounting, tax, legal or fraud advice. Validate records with the responsible bookkeeper before posting adjustments or making allegations.
What this is built on
- Method: Cost variance = (expected minus counted) × unit cost. Three missing mugs at 8 cost 24; two extra bowls offset that by −16. The sample net is 8, but both rows still need review.
- All sample records are invented examples. The app does not fetch measurements, policies, files or personal records.
- Google’s official pricing page, fetched 2026-09-29, lists free-tier access including AI Studio. Optional formatting only; limits and availability can change. Free-tier content may be used to improve products. Never paste private records there.
Before: Comparing opening stock directly with the count makes legitimate sales look like loss. After: the stocktake variance packet shows the working beside each named row so the reader can change the assumption and inspect the consequence.
Optional AI formatting, not calculation
For this stocktake variance packet, use the free AI Studio interface only if available to you, with no paid API key. Manual entry completes the same workflow for free. Supply only fictional or non-sensitive notes. Review its output against the source; never paste unresolved questions into the numeric rows.
Format my non-sensitive notes for a stocktake variance packet. Return plain rows only: item | expected closing units | counted closing units. Preserve supplied quantities exactly. Do not guess missing values; list questions separately. Do not calculate or add advice. I will check every row before pasting into the local tool.
Accepted schema: item | expected closing units | counted closing units. No AI response is executed as code.