✏️Prompts

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