Plan an inventory count and book the count adjustments
Sets up count procedures, then analyzes book-to-physical differences and proposes adjustment entries with explanations.
The prompt
Help me plan a physical inventory count and handle the results.
Business and inventory type: [e.g. "distributor, 1,200 SKUs, one warehouse", "restaurant food and beverage"]
Locations: [warehouses, stores, consigned or in-transit stock]
Costing method: [FIFO / weighted average / standard cost]
Count date and staff available: [DETAILS]
Count results vs. book (if done): [PASTE - SKU, book qty, counted qty, unit cost]
Part 1 - Count plan:
- Cut-off procedures for receiving and shipping on count day.
- Count teams, tagging or sheet controls, blind counts, and recount rules (e.g. recount any variance over [X] units or $[Y]).
- How to handle damaged, obsolete, consigned, and in-transit items.
Part 2 - Results (if I've pasted them):
1. Calculate quantity and dollar variances per SKU and in total.
2. Rank the largest variances and suggest likely causes (cut-off errors, unit-of-measure mix-ups, mis-picks, unrecorded receipts, shrinkage).
3. Identify slow-moving or obsolete stock that may need a write-down.
4. Draft the adjustment journal entry and a variance summary for management.
Return the count plan as a checklist, and results as a table: SKU | Book | Count | Variance qty | Variance $ | Likely cause | Action.
Recount large variances before booking adjustments. Write-downs follow your framework's rules (lower of cost and net realizable value) - mark estimates [CONFIRM].
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Finance & Accounting prompts
What to fill in
- warehouses, stores, consigned or in-transit stock
- FIFO / weighted average / standard cost
- DETAILS
- PASTE - SKU, book qty, counted qty, unit cost
- CONFIRM
How this prompt is built
This prompt follows the Few-Shot structure (Few-shot prompting). A few-shot prompt includes one or more worked examples of the input and the output you want, so the model can copy the pattern instead of guessing it.
Related prompts
- Prepare a progress billing pay application with retainageA schedule of values and monthly pay application that matches work in place, handles retainage and stored materials, and avoids rejection.
- Write a credit memo for a commercial loan requestA structured credit memo covering the borrower, repayment capacity, collateral, risks, and a clear recommendation for the credit committee.
- Cost and price a multi-day tour packageA tour costing sheet with fixed and per-person costs, break-even group size, markup, and a sellable inclusions list.
- Check whether a design project will finish within its feeA fee-burn check comparing fee spent with percent complete by phase, with an estimate at completion and recovery options.