Automated SpotOn Reservation No-Show Report
Every morning, WebRun opens SpotOn's reservation and seating data for the prior night, finds every confirmed reservation with no corresponding covers turned, logs the party name, size, and time in your Google Sheet, and calculates the estimated revenue missed based on your average spend per cover.
How do I automatically track reservation no-shows and their revenue impact at my bar?
WebRun reviews SpotOn reservations every morning for the prior night, identifies every confirmed booking where no check was opened, and logs the party name, size, card-on-file status, and estimated revenue missed into your Google Sheet. Monthly no-show totals update automatically so you can see whether policy changes are reducing losses.
- Monthly no-show revenue impact is tracked automatically, not estimated at year end
- Card-on-file status is flagged for each no-show so managers can act on the same morning
- No-show patterns by time slot and party size surface over time to inform policy changes
Built for bar managers · nightclub operators · upscale bar owners · event venue managers
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
www.spoton.comin a real browser with your saved login - no setup, no API keys. -
1
SpotOn - find confirmed reservations with no covers checked in
spoton.com
WebRun opens SpotOn to find confirmed reservations with no covers checked in. - Open SpotOn and navigate to the Reservations section for the prior evening
- Filter confirmed reservations and check which ones have no associated check or cover count
- Capture the party name, party size, reservation time, and section for each no-show
- Note whether the reservation had a credit card hold or deposit on file
Done when All confirmed reservations from the prior night with no check activity are identified and documented.
-
2
Google Sheets - log no-shows with party size and estimated revenue impact
google.com
WebRun opens Google Sheets to log no-shows with party size and estimated revenue impact. - Open the reservation no-show tracking sheet and append a row for each no-show
- Enter the date, party name, party size, time, section, and whether a card was on file
- Multiply party size by the venue's average spend per cover and record the estimated revenue missed
- Update the running monthly no-show total and estimated revenue impact at the top of the sheet
Done when All prior-night no-shows are logged with revenue impact and the monthly total is updated.
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
Will it charge the customer's card on file for a no-show automatically?
No. Charging a card for a no-show requires your explicit decision and is never done automatically. WebRun only logs the no-show details and flags whether a card was on file so you can choose to pursue a charge through SpotOn.
What if the guest was late and checked in after the reservation time?
WebRun looks for reservations with no check activity at all. If a party arrived late and a check was opened in SpotOn, they will not be marked as a no-show, even if they came in after the original time slot.
How is the estimated revenue impact calculated?
You set your average spend per cover during setup. WebRun multiplies that figure by the no-show party size to estimate the revenue missed. You can update the average spend figure in the sheet any time to keep estimates accurate.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.