Rivane

Accounting
made smart

ERP Use CasesTier 1Published May 3, 2026

Annual Physical Inventory (Wall-to-Wall Count)

Annual Physical Inventory (Wall-to-Wall Count) for US and UK finance teams: ERP requirements, controls, audit evidence, data model, APIs, state transitions, and implementation checks.

Cycle Count / Physical Inventory is where ERP discipline either begins or breaks.

Annual Physical Inventory (Wall-to-Wall Count) looks operational from far away. In a real finance team, it is a chain of assertions: the right actor started the work, the required records existed, the control policy was applied, the state change was preserved, and the outcome can be explained later without rebuilding the transaction from emails and spreadsheets.

The expected business outcome is specific: Year-end inventory balance agreed to physical count within acceptable shrinkage threshold; auditor sign-off obtained; count-to-adjustment cycle completed within 5 business days.

The control flow a finance team actually needs.

Workflow map showing control steps, exceptions, and evidence for this ERP process.Inventory Freeze...Start conditionFreeze/Unfreeze ...Required checksCount Sheets Gen...Owner and SLAFirst Count, Sec...System updateVariance Report ...Exception handlingAudit packetEvidence trailException loopCycle Count / Physical Inventory should preserve every override and rejection.
Workflow map for this ERP process, including exception handling and audit evidence.

Step 1

Inventory Freeze Flag Blocks All In/Out...

Step 2

Freeze/Unfreeze Requires Manager...

Step 3

Count Sheets Generated By Location With...

Step 4

First Count, Second Count, And Recount...

Step 5

Variance Report Sortable By Value And...

The ERP surface involved.

Module

Cycle Count / Physical Inventory

Actors

Inventory Manager, All Warehouse Staff, External Auditors, GL Accountant

Tier

Tier 1

Finance area

Inventory & Warehouse Management

Region lens

US and UK finance teams

Publication date

May 3, 2026

Inventory freeze flag blocks all in/out transactions during the window; freeze/unfreeze requires manager authorization; count sheets generated by location with item/expected-qty hidden for blind counting; support first count, second count, and recount tiers; variance report sortable by value and percentage; adjustment journal posts all variances in a single balanced batch; freeze period snapshot preserved read-only for audit access; duration limit: freeze window must not exceed 72 hours for business continuity; rollback plan if system goes down mid-count.

US and UK teams have different compliance hooks, but the same control problem.

US teams usually care about clean evidence for audit support, vendor records, payment controls, tax reporting, and management review. UK teams usually care about VAT-ready records, approval evidence, digital-record discipline, and traceable postings. The country-specific details differ, but the operating pattern is the same: the ERP needs controlled records, explicit ownership, defensible state changes, and evidence that survives beyond the person who completed the task.

The control matrix.

Control areaRequirementAcceptance proof
Control 1Inventory freeze flag blocks all in/out transactions during the windowGiven an inventory freeze initiated by manager
Control 2freeze/unfreeze requires manager authorizationwhen count teams submit first and second counts with discrepancies triggering recounts
Control 3count sheets generated by location with item/expected-qty hidden for blind countingthen a variance report is produced, management signs off, adjustment journals post all net variances in a single balanced batch, freeze is lifted, and the snapshot is preserved read-only
Control 4support first count, second count, and recount tiersnegative) when any transaction is attempted against a frozen location then 422 LOCATION_FROZEN.
Control 5variance report sortable by value and percentageYear-end inventory balance agreed to physical count within acceptable shrinkage threshold; auditor sign-off obtained; count-to-adjustment cycle completed within 5 business days.
Control 6adjustment journal posts all variances in a single balanced batchYear-end inventory balance agreed to physical count within acceptable shrinkage threshold; auditor sign-off obtained; count-to-adjustment cycle completed within 5 business days.

Audit evidence is a chain, not a folder.

Evidence layerWhat should be preserved
Business eventInventory manager initiates a full physical inventory freeze, halting all inventory transactions (receipts, shipments, transfers) for the count window. The system generates count sheets for every active bin location. Teams perform a first and second count; discrepancies trigger recounts. Final counts are entered, system quantities are reconciled, and a variance report is produced. After management sign-off, adjustment journals are posted for all net variances, the freeze is lifted, and normal operations resume. Auditors can access the freeze-period snapshot for verification.
Control rulesInventory freeze flag blocks all in/out transactions during the window; freeze/unfreeze requires manager authorization; count sheets generated by location with item/expected-qty hidden for blind counting; support first count, second count, and recount tiers; variance report sortable by value and percentage; adjustment journal posts all variances in a single balanced batch; freeze period snapshot preserved read-only for audit access; duration limit: freeze window must not exceed 72 hours for business continuity; rollback plan if system goes down mid-count.
Acceptance proofGiven an inventory freeze initiated by manager; when count teams submit first and second counts with discrepancies triggering recounts; then a variance report is produced, management signs off, adjustment journals post all net variances in a single balanced batch, freeze is lifted, and the snapshot is preserved read-only; (negative) when any transaction is attempted against a frozen location then 422 LOCATION_FROZEN.
Data record
physical_inventory_freeze { id: string, entity_id: string, warehouse_id: string, initiated_by: string, started_at: timestamp, lifted_at: timestamp, status: enum(ACTIVE,LIFTED) };
physical_count_sheet { id: string, freeze_id: string, location_id: string, item_id: string, first_count_qty: int, second_count_qty: int, final_qty: int, system_qty: int, variance_qty: int };
freeze_snapshot { freeze_id, item_id, location_id, system_qty, captured_at: timestamp, immutable: bool };
(reference, product may differ).
System event
POST /v1/physical-inventory-freezes { warehouse_id, external_id } -> 201 { id, status: ACTIVE };
POST /v1/physical-inventory-freezes/{id}/submit-counts { counts:[{location_id, item_id, qty, count_tier}] } -> 200;
POST /v1/physical-inventory-freezes/{id}/post-adjustments -> 200 { gl_batch_journal_id };
POST /v1/physical-inventory-freezes/{id}/lift -> 200 { status: LIFTED };
emits inventory.freeze_lifted event.
Lifecycle state
ACTIVE -> ADJUSTMENTS_POSTED -> LIFTED;
guard: freeze duration must not exceed 72 h;
lift blocked until all variance sign-offs complete;
snapshot immutable after ADJUSTMENTS_POSTED.

The useful version of this workflow is not only fast. It is inspectable. A controller, auditor, or operator should be able to move from source event to system record to state transition to final business outcome without guessing.

Implementation contracts.

Reference data model

`physical_inventory_freeze` { id: string, entity_id: string, warehouse_id: string, initiated_by: string, started_at: timestamp, lifted_at: timestamp, status: enum(ACTIVE,LIFTED) }; `physical_count_sheet` { id: string, freeze_id: string, location_id: string, item_id: string, first_count_qty: int, second_count_qty: int, final_qty: int, system_qty: int, variance_qty: int }; `freeze_snapshot` { freeze_id, item_id, location_id, system_qty, captured_at: timestamp, immutable: bool }; (reference, product may differ).

API and events

`POST /v1/physical-inventory-freezes` { warehouse_id, external_id } -> 201 { id, status: ACTIVE }; `POST /v1/physical-inventory-freezes/{id}/submit-counts` { counts:[{location_id, item_id, qty, count_tier}] } -> 200; `POST /v1/physical-inventory-freezes/{id}/post-adjustments` -> 200 { gl_batch_journal_id }; `POST /v1/physical-inventory-freezes/{id}/lift` -> 200 { status: LIFTED }; emits `inventory.freeze_lifted` event.

State transitions

`ACTIVE -> ADJUSTMENTS_POSTED -> LIFTED`; guard: freeze duration must not exceed 72 h; lift blocked until all variance sign-offs complete; snapshot immutable after ADJUSTMENTS_POSTED.

Common implementation traps.

Treating the workflow as data entry

If the ERP only stores the final record, the team loses the decision trail that explains how the record became valid.

Hiding exception logic

Exceptions need owners, reason codes, and time stamps. A vague pending state is not a control.

Posting without recovery design

Retries, duplicate submissions, and partial failures must be explicit so the system does not create inconsistent records.

Skipping evidence design

A workflow that cannot produce evidence on demand will eventually push finance teams back into manual screenshots and spreadsheets.

Where Rivane fits.

Rivane is built for finance workflows where automation must stay tied to source documents, approvals, state transitions, ledger impact, reporting, and audit evidence. Use this guide as a checklist for evaluating whether an ERP workflow is merely digitized or actually controlled.

References and source basis.

These sources provide the standards, regulatory, or government context around the flow. They are included so the guide is useful to finance operators, auditors, and implementation teams, not only buyers reading software copy.

Back to ERP use cases