15-Minute Weekly POS Audit to Spot Slow Sellers and Overstock Risk

Run a 15-minute weekly POS audit

Busy managers and chefs need a fast routine that converts data into actions. This audit uses three quick filters in your POS or reporting tool to find items to delist, items to promote, and SKUs that need repricing or transfer. Run it the same day each week and assign one team member to own follow up.

What to look for

• Declining sellers: steady sales drop over multiple weeks.
• Profitable add-ons: high attach rate and margin opportunity.
• Overstocked SKUs: slow turnover tying up cash and shelf space.

Five-step 15-minute checklist

• Open POS report: set date range to last 4 to 8 weeks and sort by weekly trend.
• Flag bottom performers: filter SKUs with negative week-over-week sales and low units.
• Find add-ons: sort modifiers and sides by attach rate and margin contribution.
• Identify overstock: cross-check inventory days on hand against weekly sales.
• Assign actions: mark SKUs to delist, promote, or reprice and add tasks to the worklist.

Declining sellers: exact criteria and actions

Criteria to flag: 4-week downward trend with average weekly units less than 5, or a 20 percent or greater drop month over month. For coffee shops use units per labor hour as a secondary check.

Concrete actions:

Delist candidates after two confirmations. Before delisting run a simple test: put the item on a 48-hour promo at 10 to 15 percent off or pair it as a free add-on. If sales do not improve by at least 30 percent in the test window, remove it from the daypart menu and reassign inventory lines.

Profitable add-ons: how to spot and scale them

Criteria to flag: attach rate above 25 to 30 percent and gross margin contribution greater than 60 percent. Look for modifiers, side dishes, and signature toppings that customers already accept at checkout.

Concrete actions:

Promote by creating POS prompts at upsell points: add an automatic suggestion on the tablet for specific menu items, insert visual cues on the floor, and train staff with a scripted one-line prompt. Track lift by comparing attach rate week over week. If attach rate grows, add the pairing to menu combos and print collateral for service staff.

Overstocked SKUs: thresholds and corrective moves

Criteria to flag: inventory days on hand greater than 21 days with weekly sales under 2 units, or a stock value exceeding two weeks of forecasted sales. Perishables should use a shorter threshold, for example 7 to 10 days.

Concrete actions:

Reprice fast-moving slow sellers downward in small increments, for example 10 to 20 percent, and measure margin impact. Move items into higher visibility promotions, bundle them as limited-time specials, or transfer to catering and staff meals to reduce carrying cost. Update par levels to prevent repeat overstock.

How to run the filters in common POS systems

Most systems let you export a sales-by-SKU report. Use these quick filters:

Set date ranges to 4 and 8 weeks, calculate week-over-week percent change, and add columns for units sold, attach rate, and inventory days. If your system supports calculated fields, create a score that weights trend and margin to prioritize the top 10 items for review.

Example playbook for a single audit session

Minute 0 to 2: open report and set filters. Minute 3 to 7: scan and tag items into the three categories. Minute 8 to 12: assign actions in your task system and set promos in POS. Minute 13 to 15: send a 30-second update to the team with concrete next steps and owners.

Metrics to track weekly

Focus on these KPIs and update them each audit: weekly units per item, attach rate for top modifiers, inventory days on hand, and margin impact from any price changes. Keep a rolling 12-week log so you can validate decisions and spot seasonal effects.

Run this audit weekly for eight weeks and you will reduce slow sellers, increase add-on revenue, and cut tied-up inventory. Assign one person to own the routine and record each decision so delist and repricing actions can be reversed if needed.

If you want a printable one-page checklist and sample POS filters formatted for your system, email your POS name and I will send a tailored copy. Use the routine this week and schedule a 15-minute review with your shift leads to embed the habit.

Frequently Asked Questions

How often should I run the 15-minute POS audit?

Run it once per week on a consistent day and time. Align the audit with ordering or receiving days so follow-up actions like repricing or transfers can be executed immediately.

What thresholds should I use to flag a declining item?

Flag items with a 4-week downward trend plus average weekly units below 5, or a month-over-month drop greater than 20 percent. Adjust these thresholds for low-volume menus.

How do I measure attach rate for add-ons?

Divide modifier uses by the number of base item sales over the same period. An attach rate above 25 to 30 percent often indicates a strong promotion candidate.

What quick actions reduce overstock carrying costs?

Reduce price in small steps, bundle items into specials, reassign stock to catering or staff meals, and lower par levels going forward to avoid repeat overstock.