Retail Physical Inventory Best Practices
The
following are our teams’ best practices for taking a Retail physical inventory
gathered over hundreds of implementations.
Following these guidelines will ensure your team has the most successful
time completing your inventory.
Foundational Decisions and Approach
Before you
do your first physical, your business need to determine and decide how to
handle the following:
- Establish
a culture of seriousness around physicals.
You have 100K+ of money on the floor.
- You
are Asset Managers – not buyers
- Frequency
– how often will you take inventory (weekly, monthly,
quarterly) - Monthly is recommended
- Day of the week you will take
inventory - pick the least stressful day, change as needed - consider
deliveries, sales, etc.
- Time of Day – Recommended that
you start once the business is closed or before open.
- Time
Deadline – Done that end of day or by x the next day
- Establish
your Physical Approach
o
Kick
Off Meeting
o
Locations
and Assignment
o
Scan
Each Tag or Scan and enter qty?
o
Problem
Items – How to handle/notate, where do you take those items, who
resolves?
- Determine
your Thresholds
o
Depends
on your ownership/accounting team
o When will you recount and what is the
criteria?
o Does the time spent investigating a variance provide return?
o
What
is your acceptable variance – 3%, 2%?
- To
UPC or Not UPC – Will you add UPC codes to items and allow them to be scanned?
- Handhelds
– Get them. 1 Per Person. They cost justify in 1 to 4 months
- Cycle
Counts
o
Adjust
frequency to your high variances – High = Monthly, Low = Quarterly, (don’t go a
long time without resolving variances – the bigger they are, the harder they
are to figure out)
o
Create
schedule of when to cycle count and what to count
- Labels
- Get the right labels for all products
o
Small
products are the easiest to mis-ring so ensure you have good labels for these
- Open
Items – Create a policy of when and why to use the open item button.
o
Determine
how to correct these.
§
Suggestion: If item does not ring up, put second same
item in “problem” bucket and resolve latter when you have time
- Reporting
- What are the reports that need be generated after each physical
Physical Inventory Checklist:
·
We have included a Physical
Inventory Checklist that we recommend be included in your process. Completing
this checklist with every inventory, will guarantee your team has an efficient
and productive inventory.
Physical Inventory
Checklist
Outlet (s) _____________________________ Last Months Ending: __________
Staff Member: ____________________________ This Month Actual Revenue __________
This
Month Variance Budget Amount/% _______/___
Physical EOM _________________________ This
Month Actual Variance Amount/% ______/____
Pre-Physical Checklist
- Set time to start physically counting outside of business
hours
o
Date: ________ Time: ________
- Confirmed all invoices/receipts entered in Yellow Dog
(Committed)
- Confirmed AP has also entered all of these in AP (3-Way
match of Vendor Invoice stapled to YD Invoice stapled to AP Invoice)
- All damages/shrinkage adjustments entered at least one day
BEFORE your do physical
- Handheld prep
o
Ensure units, and any backup
batteries are fully charged
§ Ensure Count XL application has latest version installed
o
If 520s, or Docked version are being
used confirm pre count sync happened
- Printed negative on-hand report day BEFORE physical.
Resolve negatives before taking physical.
- Straighten up/tidy up inventory areas. Move product to where
it should be.
Physical Checklist
- Setup problem item table (or process to deal with items that
won’t scan)
- Printed Count Sheets, assigned to staff
- Assigned Data Collectors
Review of Physical (Before Committing)
- Print POS Sales Report for month to help audit
- Have last month’s ending inventory and this month’s budget
COGS amounts to validate actual COGS for this month before committing.
- All counts added to Physical
- Sort by “Variance Cost (Descending), Item”, review and recount
as needed
- Review and recount as needed all “zero counted” items
- Sort by “Variance Quantity, Item. Review and fix any positives
- Once you’re within your threshold for Variance, commit
physical.
Post Physical Checklist
- Print Detailed by Select Physical Report
- Print COGS By Department Report
- Hand in this sheet (per outlet and the above 2 reports) to
your supervisor