Reconciling Physical Inventory

Print a count sheet, walk the storeroom, then enter your counted quantities. DREAM writes adjustments only for rows that changed.

Quick Answer

Click Audit on the Inventory screen. Pick a location, print the audit sheet, count, and then start the reconcile to enter what you found.

Reconciling inventory is a two-phase workflow: walk the location with a printed count sheet, then update DREAM with what you actually found. Discrepancies are recorded as adjustments with mandatory notes — every change leaves an audit trail.

Step 1 — Print the audit sheet

Click Audit on the C&I → Inventory screen and pick a location. Click Print audit sheet. The printable sheet lists every stock variant at that location with a blank "Counted" column.

Walk the storeroom and fill in the counted quantities on paper.

Step 2 — Reconcile

Come back to the Audit modal and click Start reconcile. You'll see the same variants on screen, this time with an editable Counted column.

Type what you actually counted for each row. The Adjustment column updates in real time — emerald for positive (more than expected), red for negative (less). Rows you don't change stay at zero adjustment.

If any row has a non-zero adjustment, a Notes field becomes required — explain the discrepancy.

What gets written

Only changed rows are written. Each adjustment lands as a separate transaction in the Inventory Ledger, tagged with an audit session ID so all rows from one reconcile session can be grouped later.

⚠️ Important: Reconciles are one-way — you can't "undo" a reconcile, only run another one. Take your time with the count and notes before submitting.