Reconcile Issued Stock Cost from an Exact-Cent Moving Cost Pool — Free
A rounded unit average can multiply into the wrong issued cost. Keep the carrying pool in cents and allocate each issue from the unrounded fraction before comparing it with the recorded amount.
The proof surface
Stock shrinkage counts units; this maintains purchase cost pools and reconciles issued cost using exact-cent moving averages without rounding the unit rate first.
InputMovement code | purchase or issue | whole quantity | purchase unit dollars or recorded total issue dollars; absolute issue-discrepancy review mark ($)
Rare deviceStock shrinkage counts units; this maintains purchase cost pools and reconciles issued cost using exact-cent moving averages without rounding the unit rate first.
Output artifactTotal absolute recorded-versus-modeled issue difference plus complete labeled working
Cost$0 local core · no account, card, paid key or subscription · filing proposal has no checkout
Sample, not your facts: Invented records: Cedar purchase | purchase | 10 | 8.25; Willow purchase | purchase | 5 | 10.50; Pine issue | issue | 8 | 70; Birch purchase | purchase | 3 | 12; Oak issue | issue | 5 | 49.50. Absolute issue-discrepancy review mark ($) = 1; expected Total absolute recorded-versus-modeled issue difference: 2 $ summed absolute discrepancy. These are not quotations, verified observations or personal evidence.
Before using the cost-pool movement register
This is a zero-opening-balance perpetual moving-average rehearsal, not an accounting policy selection or tax valuation certificate. Movements are processed in entered order. Purchase rows supply a unit price; issue rows supply the total cost already recorded for that issue, not a sale price. The distinction is essential. Only nonnegative two-decimal dollars and positive whole quantities are accepted. No return, credit note, negative stock, freight, tax or currency conversion is inferred. Pool and cumulative discrepancy bounds keep the calculation finite and auditable. A real inventory system may use another valid cost method or include additional costs, so ask an accountant before treating a variance as an error.
Why the flat version breaks
Rounded unit cost is multiplied back into a total
A fractional average can be rounded too early, creating extra cents when multiple units leave. This register allocates from the whole carrying pool and only then rounds the issue. The final issue releases the exact residual. That convention is declared so differences with a real system can be investigated rather than called wrongdoing.
Future purchases cover an earlier impossible issue
Movement order carries information. Issuing stock before it exists cannot be repaired by a later buy in this zero-opening model. The app stops at the impossible row, preserves the input and keeps the previous successful reading. Correct the opening convention or source order with the accountant rather than rearranging transactions until the calculation passes.
Signed discrepancies disappear by netting
A recorded issue two dollars high and another two dollars low have zero net difference but four dollars of absolute reconciliation work. The headline sums absolute issue discrepancies, with signed row notes retained. Purchase balances and ending cost are different measures. No figure is labeled unexplained theft, accounting fraud or a tax deduction; interpretation belongs to verified records and the responsible professional.
How to work the cost-pool movement register
Identify movement type and source amount
Enter a neutral movement code, the literal purchase or issue type, quantity and the correctly typed dollar field. Purchases add quantity times unit cost. Issues compare a modeled total allocated cost with the entered recorded total cost. A customer’s sale price does not belong in that issue cell. Put movements in the actual intended order and preserve the source documents separately. The model starts with no stock and cannot infer an opening quantity or value.
Keep quantity and cost as separate pools
Track current whole units and carrying cents. Adding a purchase increases both pools; an issue must not exceed available units. Quantities can be one through one million and dollar inputs at most one million, with the carrying pool and total absolute discrepancy capped at ten billion dollars. Those are implementation bounds, not accounting recommendations. The parser rejects over-limit or impossible movements instead of silently clamping the cost or allowing temporary negative stock.
Round the issue allocation, not the unit average
Allocate current carrying cents times issue quantity divided by current units, using exact integer rational arithmetic and half-up rounding once. Subtract those cents and the issued units from their pools. When an issue takes all units, the allocation is the entire remaining pool. Compare recorded minus modeled issue cents, show its sign, and add its absolute magnitude to the headline. A strict greater-than review mark flags differences; equality does not trigger it.
Reconcile movements before interpreting a variance
Check each purchase, issue allocation, recorded amount and ending pool. The headline is total absolute discrepancy, not a net profit, inventory loss or sum of running balances. Opposite signed issue differences do not cancel in that headline, because each needs separate inspection. Confirm the cost method, included costs, units and rounding policy with the responsible accountant. The optional filing layer preserves this working, but it does not turn a hypothetical cost-pool model into a compliant ledger.
What the cost-pool movement register keeps distinct
Question
Before
Check this working
Rounded unit cost is multiplied back into a total
A fractional average can be rounded too early, creating extra cents when multiple units leave. This register allocates from the whole carrying pool and only then rounds the issue. The final issue releases the exact residual. That convention is declared so differences with a real system can be investigated rather than called wrongdoing.
Keep quantity and cost as separate pools
Future purchases cover an earlier impossible issue
Movement order carries information. Issuing stock before it exists cannot be repaired by a later buy in this zero-opening model. The app stops at the impossible row, preserves the input and keeps the previous successful reading. Correct the opening convention or source order with the accountant rather than rearranging transactions until the calculation passes.
Round the issue allocation, not the unit average
Signed discrepancies disappear by netting
A recorded issue two dollars high and another two dollars low have zero net difference but four dollars of absolute reconciliation work. The headline sums absolute issue discrepancies, with signed row notes retained. Purchase balances and ending cost are different measures. No figure is labeled unexplained theft, accounting fraud or a tax deduction; interpretation belongs to verified records and the responsible professional.
Reconcile movements before interpreting a variance
The cost-pool movement register replaces this named manual reconciliation, not source verification or the responsible human's decision.
Run it on the samples, right here
FIRST-LOAD
HYPOTHESIS / PROTOTYPE — checkout unavailable. Calculation is local. A draft is saved automatically in this browser profile when storage is available; Reset to sample clears it. Optional Pro history stores only five summaries and has its own deletion control. State links encode your inputs and can remain in browser history, clipboard or recipients’ records; share only non-sensitive rows. Optional external AI formatting leaves this device. The required site analytics beacon reports page activity; shared URLs contain encoded inputs. Do not treat an encoded URL as private. The calculator has no input-collection endpoint.
Cost-method rehearsal only, not tax advice, loss attribution or accounting compliance. Verify opening balances, included costs, movement order and the actual valuation policy with a qualified accountant before adjusting records.
Data note: This cost-pool movement register calculates in the tab from Movement code | purchase or issue | whole quantity | purchase unit dollars or recorded total issue dollars. No input-collection endpoint, AI request or file upload is built into it. Drafts may be saved locally; explicit input-state links and optional external formatting can disclose the records. Use non-sensitive codes and clear the draft when finished.
Go deeper: the companion app files the same reading as a bound register page
The article demo above runs without limits. The companion app keeps a local history, exports the rows as CSV, prints the cost-pool movement register reading, and holds your drafts on this device — one complete free app run; the proposed $4 one-time filing layer is not for sale.
Keep the complete cost-pool movement register answer free; optional filing proposes its boundary-preserving print, row-and-summary CSV and five local reading summaries. The $4 one-time prototype is not for sale; another calculation remains free in the article demo.
Cost-method rehearsal only, not tax advice, loss attribution or accounting compliance. Verify opening balances, included costs, movement order and the actual valuation policy with a qualified accountant before adjusting records.
What this is built on
Declared local method: Allocate current carrying cents times issue quantity divided by current units, using exact integer rational arithmetic and half-up rounding once. Subtract those cents and the issued units from their pools. When an issue takes all units, the allocation is the entire remaining pool. Compare recorded minus modeled issue cents, show its sign, and add its absolute magnitude to the headline. A strict greater-than review mark flags differences; equality does not trigger it.
Every sample code, measurement, date, price, fingerprint and scenario is invented. Artifact checks do not verify reader data, policies, actual files, tickets, votes or health/accessibility outcomes.
Google’s official Gemini pricing page, fetched 2026-10-01, lists AI Studio access in its Free section, limited model access and free input/output tokens. Free-tier content may be used to improve products. Optional external formatting may require an account; limits/access can change. Manual local entry needs none. Do not send sensitive records.
Before: a rounded average looked like a safe unit price. After: the exact-cent pool shows issue rounding, residual cost and each recorded-cost discrepancy separately.
The first two purchases create 15 units with 135 dollars of carrying cost, or nine dollars per unit. Issuing eight allocates 72 dollars, not the entered 70; the two-dollar absolute discrepancy exceeds the one-dollar review mark. The remaining seven units carry 63 dollars. Adding three at twelve creates ten units carrying 99 dollars, so the next five-unit issue allocates 49.50 exactly. Ending stock is five units and 49.50; intermediate balances are not summed as issue costs.
Sample B — changed plan
Harbor small purchase | purchase | 3 | 0.10
Orchard small purchase | purchase | 1 | 0.20
Spruce first issue | issue | 1 | 0.13
Ash final issue | issue | 3 | 0.37
Four units carry 50 cents, so the first one-unit issue has an exact fractional allocation of 12.5 cents, rounded half-up once to 13. The three remaining units carry 37 cents; issuing all of them releases exactly that residual, leaving zero. Rounding a unit average to 13 cents first and multiplying it by three would incorrectly allocate 39 cents. The pool method exposes where the cent rounding belongs.
Sample C — boundary convention
East single purchase | purchase | 1 | 12.75
West final issue | issue | 1 | 12.75
One unit enters and leaves at the same 12.75 carrying cost. An issue consuming all remaining stock releases all remaining cents, so both quantity and cost return to zero. This exact final-issue boundary prevents a ghost cost balance. An issue before a purchase, or an issue larger than current stock, is refused rather than financed by a later purchase.
Optional AI formatting, never the calculation
Manual entry completes this cost-pool movement register for free without signup. If available to you, the free AI Studio interface linked in the sources may format fictional or non-sensitive notes; external access may require an account. No API key or AI call is built into this tool. Free-tier content may be used to improve products. Review each cell and transcribe it to the labeled row schema; do not paste the JSON object into the row box.
Format only these fictional or non-sensitive notes for a cost-pool movement register. Return strict JSON shaped as {"rows": [{"label": "string", "cells": ["string", "string", "string"]}], "setting": "string"}. The columns are Movement code | purchase or issue | whole quantity | purchase unit dollars or recorded total issue dollars; the setting is Absolute issue-discrepancy review mark ($). Keep all supplied strings and quantities exactly; do not calculate, infer missing entries, invent dates or add advice. If any required value is missing, return an empty rows array and ask me for it separately. I will verify every cell against my source and manually transcribe rows using vertical bars before running the local calculator.
An AI response is not executed, fetched or trusted as a result. Missing values remain questions; the strict local parser checks the rows you actually enter.