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:

FieldWhat to enter
Item codeAffected stock item
QuantityAdjustment quantity
Reason codeDMG, PICK, COUNT or OTHER
ApproverRequired 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

ProblemAction
StockPro shows Goods-in complete, but actual booking is uncertainTelephone Dave to verify.
Difference exceeds 2% or £500Investigate using the relevant records.
Damaged stock differenceCheck the damages log.
Suspected picking errorExamine the last five orders for that item.
Same item has gone wrong beforeDo not write off; refer to Mark in Operations.
Proposed write-off exceeds £1,000Obtain Finance Manager sign-off.
Period Lock button is greyed outCheck that all adjustments have reason codes.

6. Who to ask

ContactResponsibility
Priya ShahProcess owner and judgement calls requiring clarification
Dave to Goods-inConfirmation that deliveries are booked
Mark to OperationsRepeated stock discrepancies
Finance ManagerApproval for write-offs exceeding £1,000
Warehouse teamPreparation of cycle count sheet
Finance teamRecipient 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.