SKU Stocktake Quantity & Confirmed Cost Calculator
Reconcile book and physical stock, with shortage and surplus costs shown separately.
Identify unknown items and prioritize a recount. Amounts use KRW.
Check inventory variance by SKU before looking at a net total
A small difference in total stock can conceal a shortage of one item and a surplus of another.
Different colors, sizes or specifications may not substitute for each other, and their unit costs can differ.
This stocktake calculator compares adjusted book quantity with counted quantity for each SKU and keeps shortages and surpluses separate.
It helps shop, online retail and warehouse teams prepare a recount list after a physical inventory check.
Enter a unit cost confirmed from your records to obtain a quantity-variance reference amount.
The amount supports investigation priorities; it does not establish an inventory valuation or a recognized loss.
Missing entries remain different from explicitly confirmed zeros, so you can review a partially completed count without disguising uncertainty.
The arithmetic is country independent, while all monetary inputs and outputs in this version use KRW.
Align the cutoff, location and ownership scope first
Same cutoff
Compare records and physical stock at the same point in time.
Movements after the count must not be entered as earlier unposted movements.
If operations continue during counting, keep a separate movement log so both quantities can be reconciled to the common cutoff.
Same location
A whole-warehouse book balance cannot be compared directly with only a shop display count.
Check how goods in transit, external storage and return holding areas are included.
One calculation set assumes a common location scope.
Same ownership scope
Identify consigned goods and stock owned by another business.
Use consistent treatment for damaged, quarantined and returned items in the book and physical quantities.
Contractual ownership and accounting attribution require your separate review.
You can inspect provisional row calculations before confirming the common scope.
The complete net adjustment reference remains withheld until that confirmation is checked, even if every cost and recount is complete.
Select the confirmation only after checking the underlying records.
Keep each SKU and its quantity unit consistent
Use a recognizable internal item code rather than an ambiguous product description.
Duplicate codes can double-count an item, so the calculator trims surrounding whitespace, normalizes letter case and withholds both duplicate SKU rows.
For the same product in separate locations, use separate calculation sets or consolidate quantities within a verified common scope first.
A code may contain up to 80 characters, and one set supports up to 20 rows.
Units, boxes, kg, L and m are not added together
Book quantity, count, movements and unit cost within a row must all use the selected unit.
Do not compare book boxes with counted pieces or enter a price per box as a cost per piece.
Changing the unit selector does not convert the numbers automatically.
Prepare the data using a confirmed pack size or conversion factor where needed.
Even two SKUs labeled as units are not necessarily interchangeable, so quantities are reported per row rather than summed into one shortage quantity.
Only reference costs in the common currency are aggregated.
What book quantity and counted quantity mean
Book quantity
Enter the balance from the records you are checking, before the unposted-movement corrections entered here.
A balance already overwritten with the physical count cannot reveal the original discrepancy.
Keep the record extraction time and any prior adjustment history with your working papers.
Counted quantity
Enter the quantity physically counted within the same scope and unit.
Leave an uncounted item blank; enter 0 only when you have confirmed that no stock is present.
A count below the book balance does not by itself establish theft or loss.
Each quantity field accepts values from 0 to 1,000,000 with up to three decimal places.
Weight- and length-based stock can be checked within that precision.
Valid three-digit comma grouping is accepted, but negative values, exponent notation, letters and values beyond the range or precision are invalid.
If your source data use greater precision, establish an appropriate reporting unit and rounding policy before preparing the inputs.
Correct unposted receipts, shipments and returns once
An unposted movement must have actually occurred by the count cutoff and still be absent from the entered book balance.
Exclude purchase orders not yet received and shipments occurring after the count.
Customer returns are goods actually received back, and supplier returns are goods actually sent out.
Entering movements already present in the book balance would apply the same correction twice.
- Unknown: movement status has not been verified.
Quantity variance remains withheld even when book and counted quantities are present. - No unposted movements: you have checked that no receipt, shipment or return is missing from the records.
Only this selection treats all four movement quantities as zero. - Enter details: provide unposted receipts, shipments, customer-return receipts and supplier-return shipments separately.
All four fields are required; enter 0 for a movement that did not occur.
If customer returns are already included in receipts, do not enter them a second time.
This differs from replenishment planning, which may consider future receipts and unshipped commitments.
Here the corrections cover actual stock movements up to the physical-count cutoff only.
Resolve inconsistencies between movement documents, return approvals and physical receipts with the responsible person before entering them.
Adjusted book quantity, shortage and surplus formulas
Adjusted book B = book + unposted receipts + customer-return receipts − unposted shipments − supplier-return shipments
Variance Δ = counted quantity − adjusted book B
Shortage quantity = max(0, −Δ)
Surplus quantity = max(0, Δ)
Shortage or surplus reference cost = corresponding quantity × confirmed unit cost
A negative variance indicates a shortage relative to the adjusted book balance; a positive variance indicates a surplus.
Zero variance means the quantities agree, not that unit cost or ownership is appropriate.
A negative adjusted book balance withholds that row’s quantity and cost results so you can check duplicate shipments, return entries, the record cutoff and units.
The correction formula is this tool’s explicit arithmetic model, not a journal-entry formula prescribed by an accounting standard or inventory application.
Confirmed unit cost and rounding to whole KRW
Use an actual unit cost confirmed from your records or the responsible person, expressed per selected quantity unit.
Selling price, expected resale value and the latest purchase quotation are not automatically the same as recorded unit cost.
This version uses KRW only and does not combine currencies or apply exchange rates.
Unit cost accepts 0 to KRW 10,000,000 with up to two decimal places.
The tool does not add or remove taxes or freight; verify what the supplied unit cost includes.
Round each absolute row amount half up
Multiply the quantity variance by confirmed unit cost, then round each shortage or surplus amount to whole KRW, with 0.5 rounded up.
For example, a difference of 0.001kg at KRW 500 per kg produces KRW 0.5 and is displayed as KRW 1.
The same absolute-amount rule applies to both directions.
Totals add the rounded row amounts, which may differ from rounding the sum of all unrounded products once.
The net adjustment reference equals surplus reference cost minus shortage reference cost.
A negative amount means the shortage reference subtotal is larger in these inputs; it does not establish an expense or tax deduction.
A small or zero net amount does not eliminate discrepancies in different products, so always review both subtotals.
Distinguish missing values, partial subtotals and a withheld total
Quantity known, cost unknown
A valid quantity variance can be shown while a missing unit cost leaves that row’s monetary amount withheld.
A blank cost is not included as zero.
Enter 0 only when zero is the actual confirmed unit cost.
Confirmed-cost partial subtotals
Only rows with valid SKU, quantity and cost inputs contribute to shortage and surplus cost subtotals.
Rows awaiting recount can still contribute to this provisional arithmetic, so read the missing-input and pending-recount counts alongside it.
Do not present a partial subtotal as the confirmed loss of the entire inventory.
The complete net adjustment reference appears only when every row has valid SKU, quantity and unit cost inputs, every recount is confirmed, and the common scope is confirmed.
Duplicate SKUs, invalid numbers and blank detailed movement fields also prevent completion.
A zero-variance row follows the same completion rule and still requires cost and recount confirmation.
Known row quantities and partial subtotals remain available to guide the next check while the complete total is withheld.
Step-by-step workflow from count sheet to review list
- Align the book extract and count sheet to a common cutoff, location and ownership scope.
Confirm that scope after checking it. - Enter the first SKU and unit, then book quantity, counted quantity and confirmed unit cost.
Do not invent a value for a missing document. - Verify that no unposted movements exist, or enter all four detailed movement quantities.
Check that the adjusted book balance matches your intended correction. - Add further SKUs and repeat the process.
Switching SKU tabs preserves your drafts, and a result-row edit action takes you back to the corresponding input. - Complete unknown inputs, recount discrepancy items and mark each recount as confirmed.
Compare large discrepancies with movement and return records as well. - Save the TXT report containing the current inputs and reasons for withholding results, then review it with the responsible person.
Restore your own inputs after using the example before saving an operational report.
Worked example with three SKUs
This illustrative example uses individual units for all three products.
For A, book quantity is 100 and the physical count is 95, with unposted receipts of 10, shipments of 5, customer-return receipts of 2 and supplier-return shipments of 1.
Adjusted book quantity is 100 + 10 + 2 − 5 − 1 = 106, giving a shortage of 11 units.
At KRW 2,000 per unit, the shortage reference cost is KRW 22,000.
| SKU | Adjusted book | Counted | Shortage | Surplus | Reference cost |
|---|---|---|---|---|---|
| A | 106 | 95 | 11 | 0 | Shortage KRW 22,000 |
| B | 50 | 54 | 0 | 4 | Surplus KRW 12,000 |
| C | 20 | 18 | 2 | 0 | Unit cost unknown |
B and C have confirmed no unposted movements.
B’s unit cost is KRW 3,000, so its surplus reference cost is 4 × 3,000 = KRW 12,000.
C has a known shortage of 2 units but no cost, leaving its amount withheld.
Confirmed-cost partial subtotals are therefore KRW 22,000 shortage and KRW 12,000 surplus, while the complete net amount remains withheld.
After C’s cost and every confirmation are completed
Entering C’s confirmed unit cost of KRW 1,000 adds KRW 2,000 to the shortage reference amount.
The shortage subtotal becomes KRW 24,000 and the surplus subtotal remains KRW 12,000.
After the common scope and every recount are confirmed, the complete net adjustment reference is 12,000 − 24,000 = −12,000 KRW.
A’s shortage and B’s surplus still require their own investigation.
Review priority is more than a descending cost list
Rows with unknown or invalid quantities come first, followed by unknown unit costs and pending recounts.
Within the same confirmation status, larger absolute cost discrepancies take priority; ties retain input order.
This prevents an unverified item from being treated as normal merely because no monetary amount is available.
Once every confirmation is complete, items with a nonzero quantity difference remain movement-history review targets.
Return to the item you need to edit
Use the item edit action to revisit its unit cost or movement quantities.
Check that partial subtotals and the complete-total status update with the current inputs.
Example mode is identified, and restoring your inputs returns to the drafts and selected SKU you had before loading the example.
Do not mix illustrative numbers into an actual inventory report.
Practical scenarios and limits
Store and online retail stocktakes
Separate color and size codes to see whether shortages and surpluses appear together.
The list can help you investigate swapped shipments or incorrect barcode mappings.
The calculation alone does not prove the cause of a picking error.
Returns and missed transfers
Distinguish a return request from goods physically received back.
Goods awaiting a supplier return are not yet a shipment if they remain in the warehouse.
Location transfers require both records and physical locations to be checked at the same cutoff.
- Delayed postings, unit mismatches, ownership-scope differences and counting errors can all produce discrepancies.
Do not infer responsibility for loss or compensation from a numerical difference alone. - The calculator does not perform FIFO, weighted-average or net realizable value valuation, tax deductions, VAT calculations or journal entries.
Decide record adjustments with appropriate evidence, authorization and professional review. - The TXT report summarizes inputs and reference results.
There is no ERP posting, stock-transfer or order-transmission function; check the confidentiality of internal item codes and costs before sharing the file.
Frequently asked questions
If shortages and surpluses match, is there no discrepancy?
Different SKUs cannot cancel each other operationally.
A zero net reference cost still leaves item-level quantity differences to investigate.
Equal quantities can also have different monetary effects when unit costs differ.
Can I enter zero when I do not know the unit cost?
Leave an unknown cost blank.
Its row amount and the complete result remain withheld.
Enter 0 only when zero is the actual confirmed unit cost.
What should I enter for an item that has not been counted?
Leave the counted quantity blank and perform the count.
Zero means you have confirmed that no stock is present.
A blank count is not treated as a shortage of the entire book balance.
Do detailed movements require zeros for absent categories?
All four movement fields must be confirmed before quantity variance is calculated.
Enter 0 where a movement did not occur.
If none of the four categories has any unposted movement, use the no-unposted-movements selection.
Does selecting boxes convert the quantities automatically?
The unit selector defines the label and comparison basis only.
Align book quantity, count, all four movement quantities and unit cost to boxes yourself.
Confirm the actual pack size from the product specification.
Why is the complete net amount still withheld after entering numbers?
Every row needs valid SKU, quantity and cost inputs, plus recount confirmation and the common scope confirmation.
Check for duplicate SKUs, negative adjusted book balances and unknown movement status.
A partial subtotal is not a complete confirmed amount.
Can rounding make this differ from my record total?
Each absolute row amount is rounded to whole KRW, with 0.5 rounded up, before summation.
Your records may retain decimals or round only the final total.
Compare results using the same rounding basis.
Can I recognize the amount immediately as a loss or tax deduction?
No such determination is made.
The result is a quantity-variance reference based on confirmed unit cost; valuation and loss recognition require separate review.
Check evidence, causes, ownership, approval and the applicable accounting and tax treatment.
Official references and review date
References were checked on November 20, 2026.
Odoo 18.0 documentation informs the distinction between recorded and counted stock and the need to review movement history.
The IFRS Foundation’s IAS 2 overview provides context for treating inventory cost determination and valuation as a separate accounting task.
Input limits, rounding and withholding rules are this product’s checking design, not statutory valuation formulas.
- Odoo 18.0 Inventory adjustments · Alternative official documentation path
- Odoo Locations dashboard
- IFRS Foundation — IAS 2 Inventories
Recheck the actual cutoff, units, ownership scope, unposted movements, confirmed unit costs and recount evidence for each new review.
The calculator does not automatically determine the effect of a change in company valuation policy or adjustment procedures.
Resolve count differences before the next inventory decision
Start with the first SKU’s book and counted quantities, then verify its unposted-movement status.
You can leave unknown costs blank, save the recount list and compare evidence with the responsible person.
After reconciling stock, use the appropriate separate calculator for replenishment planning or a system-investment decision.
- Inventory Reorder Point, Safety Stock and Pack Order Calculator — review replenishment quantities using sales and lead time
- Warehouse WMS Picking ROI Calculator — compare assumed system costs and benefits
Related calculators
- Inventory Reorder Point, Safety Stock and Pack Order CalculatorUse daily sales and fixed lead time to calculate reorder points, MOQ and pack quantities, with a saleable-life check.
- Inventory & WMS Picking ROI CalculatorCompare current warehouse picking with a WMS target state using pick time, order errors, inventory loss, implementation cost, recurring cost, NPV, ROI, and payback.
- 3PL vs In-House Fulfillment Break-Even CalculatorCompare third-party logistics quotes with in-house warehouse, labor, systems, error, setup, and exit costs using operating break-even, present-value TCO, and sensitivity scenarios.
- Margin Rate CalculatorCalculate profit margin, markup, selling price, cost, and gross profit for products or services.
- Cash Runway CalculatorEstimate how long available cash can support a business under current revenue and expense assumptions.