ROLLER to Google Sheets Loss Prevention Log

The IntelliPaaS Integration Pack for ROLLER and Google Sheets helps teams strengthen loss prevention and financial control by automatically logging every void, refund and manual discount processed in ROLLER into a structured Google Sheets workbook. Each transaction is recorded with the amount, the type of adjustment, the staff member responsible, the timestamp and any reason provided — creating a comprehensive audit trail accessible from any device that finance and management teams can query at any time.

Voids, refunds and manual discounts are the three categories of transaction most frequently associated with revenue leakage in retail and venue environments. In isolation, each one may be entirely legitimate. In aggregate, patterns emerge — a specific staff member applying an unusually high volume of discounts, a particular session generating disproportionate refunds or a category of product with a persistent void rate. These patterns are invisible without a consolidated log, and by the time they surface in a monthly reconciliation the transactions are weeks old and difficult to investigate.

Google Sheets makes the audit log accessible to any authorised team member from any device, meaning a duty manager can review recent voids on their phone during the trading day, a finance analyst can run a weekly reconciliation from their laptop and leadership can access the full historical record without requesting an export from ROLLER. The consistent row structure across every entry makes it straightforward to filter by staff member, date range, transaction type or amount and to build charts or pivot tables on the underlying data.