Liquor Shrinkage Review

• Store Name/Number

• Conducted on

  Date

• Prepared by

• Location
  Address

• Consulted with

Total Adjustment Figures YTD

• Internal Adjustments

• Dumps

• Theft

• Cyclic or Full Stocktake

• Total Adjustment Percentage

Stock Control

Negative SOH

• Print the current days negative SOH report and randomly check 50% to ensure timely corrective action has occurred

  Low

  Medium

  High

  N/A

• Review the administration folder. Are the negative SOH reports actioned and signed?

  Low

  Medium

  High

  N/A

• Check the Business Alerts (traffic lights) in ISIS. Are all alerts actioned? If not, why not?

  Low

  Medium

  High

  N/A

Cyclic Counts

• Review the cyclic count roster for the previous 2 weeks. Has it been completed?

  Low

  Medium

  High

  N/A

Stock Rotation

• Check a sample of high risk dated lines. Example, chips, tap king, cask wine.<br>Have these lines been entered in the 5,5,5 report?

  Low

  Medium

  High

  N/A

• Has markdown action been taken on lines approaching use by date?

  Low

  Medium

  High

  N/A

Dump Adjustments

• Visually investigate the industrial bin. Has the stock been recorded?

  Yes

  No

  N/A

• Is the ullage area being managed appropriately

  Low

  Medium

  High

  N/A

• Review the administration folder. Have all dumps been investigated?

  Low

  Medium

  High

  N/A

• How many staff are completing dumps?

  Low

  Medium

  High

  N/A

• Is the dump sheet being utilised and recorded on a weekly basis?

  Low

  Medium

  High

  N/A

• Is recovered stock actioned correctly? <br>Placed back on show or in stock reserve

  Yes

  No

  N/A

• Check under gondolas for stock.<br>What dollar value was recovered?

  Yes

  No

  N/A

SOH Internal Adjustments

• List the last four weeks total internal adjustments<br>Review the internal adjustments and investigate any excessive entries or unusual activity.<br>Detail findings and what action was taken?<br>

  Low

  Medium

  High

  N/A

• Week 1

• Week 2

• Week 3

• Week 4

• How many staff are completing adjustments?

  Low

  Medium

  High

  N/A

• Are parent codes being adjusted?

  Yes

  No

  N/A

• Print the gap scan report for the current day and visually check lines that have been scanned are action

  Low

  Medium

  High

  N/A

• Print and review the previous weeks markdown report. Have reasons for markdowns been explained and documented?

  Low

  Medium

  High

  N/A

• Print and review orders by expected date. Are all orders within 2 weeks?

  Yes

  No

  N/A

Price Integrity

• Using the RF unit perform a price check on 10 lines displayed in the store. <br>Does the scan price match the ticket?

  Low

  Medium

  High

  N/A

Initial Counts

• Review the initial counts in the system.<br>Detail the findings

  Low

  Medium

  High

  N/A

WBS - Stand alones.

• Check that the store funds in code 7080 on the WBS is reconciled to the ALH custodian to ensure the correct funds are held in the store

  Yes

  No

  N/A

• Print and review previous weeks WBS and check the following<br>Does code 60 = code 911?

  Yes

  No

  N/A

• Print and review previous weeks WBS and check the following<br>Does code 10 = code 165?

  Yes

  No

  N/A

• Print and review previous weeks WBS and check the following<br>Does code 718 appear if store safe did not balance?

  Yes

  No

  N/A

Registers

• Review the stores register Variance report for the previous week. <br>BWS - Have all register variances of $10 or more been investigated and resolved?<br>DAN MURPHYS - Have all register variances of $50 or more been investigated and resolved?

  Yes

  No

  N/A

• Review register over/shorts report for the previous to ensure the required spot checks are completed.<br>2 times per day

  Yes

  No

  N/A

• Were individual pick ups completed below $200 in BWS or $1500 DAN MURPHYS?<br>How many pick ups exceeded the limit and who was reasonable?

  Yes

  No

  N/A

• Print and review the un recalled saved transaction report for the previous 2 weeks. <br>Have all transactions appearing on the report been investigated?

  Yes

  No

  N/A

• Print and review the operator void report. Were there reasons to justify voids?

  Yes

  No

  N/A

• Re print the previous weeks refunds with reason report. Were any anomalies investigate?

  Yes

  No

  N/A

• Have all no sales have a reason? View dockets to verify.

  Yes

  No

  N/A

• Pull each register draw apart. <br>What was the total dollar amount recovered?

  Yes

  No

  N/A

Intellisafe

• Reconcile the store funds held in the intellisafe to the previous weeks closing weekly balancing value.<br>What was the variance?

  Low

  Medium

  High

  N/A

• Re print the daily journal and check the pick ups do not exceed the $200 or $1500 limit.

  Yes

  No

  N/A

Safe

• Print and review the cash office audit report for the previous week. Have all required safe checks (one per day) completed?

  Yes

  No

  N/A

Security

• Are the EAS gate fully operational?

  Yes

  No

  N/A

• Are door/drive buzzers operational?

  Yes

  No

  N/A

• Are locks on cabinets lockable or are they damaged?

  Yes

  No

  N/A

• Does the store require more dummy cameras and/or mirrors?

  Yes

  No

  N/A

• When was the last time the safe combination/s were changed

  Low

  Medium

  High

  N/A

• Are systems free from team members who have been terminated or transferred?<br>Check ISIS, Back office.

  Yes

  No

  N/A

CCTV

• Is the monitor at the FOS working?

  Yes

  No

  N/A

• Are all CCTV cameras operational?

  Yes

  No

  N/A

• Do cameras cover high risk area?

  Yes

  No

  N/A

Alarm Panel

• Review the alarm panel. Are current users up to date?

  Yes

  No

  N/A

• Are there any alarms isolated?

  Yes

  No

  N/A

• Does the current key holder information held at the store match the information sent to CMS?<br>Are the key holders up to date?

  Yes

  No

  N/A

Hold Up Alarm

• When was the Hold Up alarm last tested? Contact CMS to verify

  Yes

  No

  N/A

• Ask a staff member to locate the Hold Up alarm and ask the staff member to explain its correct use.

  Low

  Medium

  High

  N/A

Behaviours

• Are all security rooms kept locked when not in use?

  Yes

  No

  N/A

• Randomly check 10 lines for tagging disciplines. <br>Is there consistency with tagging?

  Low

  Medium

  High

  N/A

• What is the standard of the stockroom/reserve area?

  Low

  Medium

  High

  N/A

• Check stockrooms. Detail the stock levels

  Low

  Medium

  High

  N/A

• Do team members ensure the store is locked prior to cashing up?<br>View CCTV footage for the prior night?

  Yes

  No

  N/A

• Can team member recite the 5 C's?

  Select CALM COOPERATE CONSERVE COMMUNICATE COMPLETE

  • CALM
  • COOPERATE
  • CONSERVE
  • COMMUNICATE
  • COMPLETE

General Observations