Track inventory shrinkage variances in Lightspeed every week
Every Monday, WebRun opens Lightspeed Retail, reads current inventory levels against the most recent physical count or system-expected quantities, calculates variance by item and category, and writes a shrinkage report to Google Sheets so your manager can spot loss patterns and act before shrinkage compounds.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically track inventory shrinkage variances in Lightspeed Retail?
WebRun opens Lightspeed Retail every Monday, compares current inventory to the most recent physical count, calculates shrinkage by item and category, and writes the variance report to Google Sheets with a running monthly total. High-loss categories are highlighted so your manager can investigate and act on the biggest sources of stock loss.
- Weekly shrinkage variances are logged automatically without pulling manual reports
- High-loss categories are highlighted so managers know where to investigate first
- Running monthly total shows whether shrinkage is improving or worsening over time
Built for retail loss prevention managers · retail store owners · inventory managers · multi-location retailers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
retail.lightspeedhq.comin a real browser with your saved login - no setup, no API keys. -
1
Lightspeed - read inventory levels and recent count data
lightspeedhq.com How to Automate Lightspeed
WebRun opens Lightspeed to read inventory levels and recent count data. - Open Lightspeed Retail and navigate to Inventory then Inventory Counts
- Compare the most recently completed physical count to current system-on-hand quantities
- Capture items where actual count is less than expected, noting item name, SKU, expected quantity, actual quantity, and variance
- Group variances by product category to identify which department has the highest loss
- Calculate total estimated shrinkage value using the item's cost price
Done when All inventory variances from the latest count are captured with item details, category grouping, and estimated cost value.
-
2
Google Sheets - log shrinkage variances by item and category
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log shrinkage variances by item and category. - Append this week's variance data to the Shrinkage Tracker sheet with a date stamp
- Calculate the total shrinkage value and add it to a running monthly total
- Highlight categories where shrinkage exceeds your set dollar or percentage threshold
- Add a notes column for your manager to record investigation outcomes
Done when This week's shrinkage variances are logged in Google Sheets with category summaries and highlighted high-loss departments.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does WebRun adjust inventory counts in Lightspeed automatically?
No. WebRun reads and reports only. Any inventory adjustment in Lightspeed requires a manager to review the variance data and manually approve a correction inside the POS.
How often does it need a physical count to be accurate?
WebRun works with whatever count data exists in Lightspeed. The more frequently you complete physical or cycle counts, the more accurate the variance report. Even monthly counts give useful weekly trend data.
Can it distinguish between theft and data entry errors?
WebRun flags the variance and the category but cannot determine the cause. The manager column in Google Sheets is where your team records the root cause after investigating each flagged item.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.