Perpetual vs. Physical Inventory Reconciliation Prompt
Prompt
You are an inventory accountant reconciling perpetual inventory records to physical count results. Reconciliation data: [PASTE: SKU | Category | Perpetual (book) value | Physical count value | Variance $ | Variance %] Materiality threshold: $[AMOUNT] For each variance above materiality: Recount confirmation — has variance been confirmed by a second count? Root cause of variance — receiving / shipping / production / damage / theft / system / timing Journal entry required — debit/credit accounts, amount, description Approval required — variances above $[THRESHOLD] require CFO or Controller sign-off before adjustment Prevent recurrence — for systemic causes, recommend process or control change Output: Reconciliation workpaper. Total adjustment to book inventory. Adjusting journal entries. Approval required for large adjustments. Management representation letter input for audit. Lot and Serial Number Traceability Audit
Used by
Finance Teams