All templates

Automated GoTab Refund Exception Flags

Every morning, WebRun scans GoTab for all refunds processed the prior day, identifies any that exceed your dollar threshold or are missing a reason code, and logs the exceptions into a Google Sheet for your manager to review before the business day begins.

Runs on WebRun · Strict Lockdown policy
Every day at 7:00 AM WebRunorchestrates each step
1 GoTab pull and review all prior-day refunds
2 Google Sheets log refund exceptions for manager review
In short

How do I automatically catch unusual or unexplained GoTab refunds every day?

WebRun scans GoTab every morning for all refunds processed the prior day, flags any that exceed your dollar threshold or are missing a reason code, and logs the exceptions in a Google Sheet for manager review. Patterns like repeated refunds from the same server are visible before they become a larger problem.

  • Refund exceptions surface every morning before the business day starts
  • Over-threshold and missing-reason-code refunds logged separately for easy triage
  • Per-server refund frequency trends tracked weekly in Google Sheets

Built for bar managers · brewery operators · food hall managers · hospitality finance controllers

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens gotab.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    GoTab - pull and review all prior-day refunds
    gotab.com
    WebRun in GoTab: pull and review all prior-day refunds
    WebRun opens GoTab to pull and review all prior-day refunds.
    • Open GoTab Operator Portal and navigate to the Refunds report
    • Set the date filter to yesterday and pull all processed refunds
    • Flag any refund above the configured dollar threshold
    • Flag any refund missing a reason code or employee note
    • Note the server, amount, original tab, and timestamp for each flagged refund

    Done when All out-of-policy refunds are identified with server and transaction details.

  3. 2
    Google Sheets - log refund exceptions for manager review
    google.com
    WebRun in Google Sheets: log refund exceptions for manager review
    WebRun opens Google Sheets to log refund exceptions for manager review.
    • Append each flagged refund as a new row in the exceptions log sheet with date, server, amount, reason code, and flag type
    • Highlight rows with missing reason codes in a different color from over-threshold refunds
    • Update the weekly total row so the manager can track refund volume trends

    Done when All refund exceptions are logged in Google Sheets and the weekly trend row is updated.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
gotab.com
ScheduleRuns automatically on this cadence
Every day at 7:00 AM
DeliveryHow each run's result reaches you
Exception log · Google Sheets
OutputWhat each run produces - A daily log of GoTab refund exceptions including over-threshold amounts and missing reason codes, with a running weekly trend in Google Sheets.
Spreadsheet
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

How does it decide which refunds to flag?

It flags any refund exceeding the dollar threshold you configure and any refund with a blank or missing reason code, regardless of amount.

Does it take any action on the employee automatically?

No. WebRun only logs and highlights exceptions for manager review. Any follow-up with staff is a human decision made after reviewing the sheet.

Can it catch refunds issued by a specific server more than a set number of times?

Yes. Configure a per-server frequency threshold and WebRun will flag any server who has issued more than that number of refunds in the prior 7 days.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.