Case 44
Turn Expert Know-how into a Procedure
Scenario
Priya has run month-end stock reconciliation at Westgate Distribution for eight years. She retires in three months, and nobody else knows all the steps.
Why this framework
Uses PIN: what it's for, the context and source of truth, and a narrow ask. Enough for most everyday work.
Example context
Interview transcript extract (Priya Shah, Westgate Distribution, 9 October 2026): 'It starts on the last working day. First I wait for goods-in to confirm every delivery is booked, usually by 4pm, but I always ring Dave on goods-in because the system says done before it is. Then I run the stock valuation report, StockPro, Reports, Month End, Valuation, and export to Excel. I compare it with the cycle count sheet the warehouse team fills in. Anything over 2% or over £500 I look at. If it's damaged stock, I check the damages log; if it's a picking error, I look at the last five orders for that item. Sometimes I write it off, sometimes I don't, it depends whether we've seen the same item go wrong before; if it's a repeat, I don't write it off, I send it to Mark in operations. Write-offs over £1,000 need the finance manager to sign. Then I post the adjustments in StockPro, Adjustments, Month End, and lock the period. I send a summary email to finance by the second working day.' Screenshots (described): 1) StockPro menu showing Reports > Month End > Valuation. 2) Adjustments screen with fields: item code, quantity, reason code (DMG, PICK, COUNT, OTHER), approver. 3) Period lock button, greyed out until all adjustments have a reason code.
Prompt
Purpose: Turn Priya's explanation of month-end stock reconciliation into a step-by-step procedure a new team member can follow.
Context: Use only the attached transcript of my interview with Priya and the screenshots from the stock system. Where she describes a judgement call, keep it as a judgement call with her reasoning, not a fixed rule.
Narrow the ask: A procedure with: purpose, when it runs, what you need before starting, numbered steps, common problems and what to do, and who to ask. Then a list of gaps where the transcript was unclear, so I can ask her.
Materials (pasted here in place of the attachments):
Interview transcript extract (Priya Shah, Westgate Distribution, 9 October 2026): 'It starts on the last working day. First I wait for goods-in to confirm every delivery is booked, usually by 4pm, but I always ring Dave on goods-in because the system says done before it is. Then I run the stock valuation report, StockPro, Reports, Month End, Valuation, and export to Excel. I compare it with the cycle count sheet the warehouse team fills in. Anything over 2% or over £500 I look at. If it's damaged stock, I check the damages log; if it's a picking error, I look at the last five orders for that item. Sometimes I write it off, sometimes I don't, it depends whether we've seen the same item go wrong before; if it's a repeat, I don't write it off, I send it to Mark in operations. Write-offs over £1,000 need the finance manager to sign. Then I post the adjustments in StockPro, Adjustments, Month End, and lock the period. I send a summary email to finance by the second working day.'
Screenshots (described): 1) StockPro menu showing Reports > Month End > Valuation. 2) Adjustments screen with fields: item code, quantity, reason code (DMG, PICK, COUNT, OTHER), approver. 3) Period lock button, greyed out until all adjustments have a reason code.Example output from ChatGPT
Month-End Stock Reconciliation Procedure
Westgate Distribution | Draft v0.1 | 2 November 2026
Source: Interview with Priya Shah, 9 October 2026, and descriptions of three StockPro screenshots.
Status: Draft for Priya's review. Unclear instructions are flagged rather than assumed.
1. Purpose
Reconcile StockPro's month-end stock valuation against warehouse cycle counts, investigate significant differences, process justified adjustments, lock the accounting period and report the outcome to Finance.
2. When to run
- Start: Last working day of each month.
- Goods-in confirmation: Usually by 4pm, but this is not a guaranteed cutoff.
- Finance summary deadline: By the second working day of the following month.
3. Before you start
Ensure you have access to:
- StockPro, including valuation reports, adjustments and period locking.
- Microsoft Excel.
- The warehouse team's completed cycle count sheet.
- The damages log and recent order history.
- Dave in Goods-in, Mark in Operations and the Finance Manager for escalations and approvals.
4. Step-by-step procedure
1
Confirm all deliveries are booked
On the last working day, wait for Goods-in to confirm that all deliveries have been booked. Call Dave directly, even if StockPro shows completion.
Reason: Priya has found that the system can show completion before Goods-in has actually finished.
2
Export the stock valuation
In StockPro, navigate to:
Reports
Month End
Valuation
Run the valuation report and export it to Excel.
3
Compare stock records
Compare the exported valuation against the warehouse cycle count sheet.
Investigate any difference that is:
- Greater than 2%, or
- Greater than £500.
These are alternative triggers. The transcript does not explain the percentage denominator or the basis for the £500 difference.
4
Investigate the difference
- Damaged stock: Check the damages log.
- Picking error: Review the last five orders for the affected item.
- Other differences: Ask Priya how these should be investigated.
Determine whether the same item has had a similar problem before.
5
Decide how to handle the difference
Use judgement, not an automatic write-off rule.
Priya considers whether the same item has previously caused problems.
- If it is a repeat issue, Priya does not write it off; she refers it to Mark in Operations.
- Otherwise, Priya may write it off or decide not to, depending on her assessment.
The transcript does not explain all the factors behind a first-time write-off decision. New staff should seek Priya's guidance rather than decide independently.
6
Obtain required approval
Write-offs over £1,000 require Finance Manager sign-off before proceeding.
The process for recording this approval and requirements for other write-offs have not been confirmed.
7
Post month-end adjustments
In StockPro, navigate to:
Adjustments
Month End
The screenshot shows these fields:
| Field | What to enter |
|---|---|
| Item code | Affected stock item |
| Quantity | Adjustment quantity |
| Reason code | DMG, PICK, COUNT or OTHER |
| Approver | Required approver; exact rules unclear |
Select the appropriate reason code. Do not guess if the code or approver is unclear.
8
Lock the month-end period
Once adjustments are posted, use the Period Lock button.
The button remains unavailable until every adjustment has a reason code. Check for missing codes if it is greyed out.
9
Send the Finance summary
Email Finance by the second working day of the following month.
The required contents, recipients and supporting attachments are not specified in the interview.
5. Common problems and what to do
| Problem | Action |
|---|---|
| StockPro shows Goods-in complete, but actual booking is uncertain | Telephone Dave to verify. |
| Difference exceeds 2% or £500 | Investigate using the relevant records. |
| Damaged stock difference | Check the damages log. |
| Suspected picking error | Examine the last five orders for that item. |
| Same item has gone wrong before | Do not write off; refer to Mark in Operations. |
| Proposed write-off exceeds £1,000 | Obtain Finance Manager sign-off. |
| Period Lock button is greyed out | Check that all adjustments have reason codes. |
6. Who to ask
| Contact | Responsibility |
|---|---|
| Priya Shah | Process owner and judgement calls requiring clarification |
| Dave to Goods-in | Confirmation that deliveries are booked |
| Mark to Operations | Repeated stock discrepancies |
| Finance Manager | Approval for write-offs exceeding £1,000 |
| Warehouse team | Preparation of cycle count sheet |
| Finance team | Recipient of month-end summary |
7. Gaps to clarify with Priya
Interview follow-up checklist
0 of 10 clarified
How do you calculate the 2% variance, and is the £500 threshold based on the absolute difference per item?
What do you do when Goods-in has not finished by 4pm or when the warehouse cycle count sheet is incomplete?
How do you match the valuation report to the cycle count sheet, and what happens if an item is missing?
What counts as a repeat problem, and how far back do you check?
For a first-time discrepancy, what factors make you choose to write off stock rather than leave it unchanged?
How should COUNT and OTHER discrepancies be investigated, and when should each reason code be used?
Who may approve write-offs of £1,000 or less, and how is approval recorded in StockPro?
What should happen to unresolved discrepancies or referrals to Mark before adjustments are posted and the period is locked?
How can you confirm that the period has locked successfully, and what happens if a correction is needed afterwards?
What must the Finance summary include, who receives it, and where should the report, evidence and approvals be saved?
Before using this as a live procedure: Have Priya validate the ten gaps, particularly the write-off judgement, approval rules and period-locking sequence. The steps above reflect her explanation; the missing details should not be turned into fixed operational rules without confirmation.
