Automated Clover Tip Reconciliation Report
Every morning, WebRun opens Clover, pulls yesterday's tip totals per employee, checks for tip adjustments or deletions, and appends a clean reconciliation row per employee to your Google Sheet so payroll always works from accurate, auditable tip records.
How do I automatically reconcile Clover tip totals by employee each day?
WebRun opens Clover every morning, reads tip totals and any adjustments for each employee from the day before, and logs a reconciliation row per person to a Google Sheet. Payroll teams work from accurate, daily tip records without manually pulling Clover reports, and any tip adjustments are flagged for review.
- Daily tip records per employee built automatically for payroll
- Tip adjustments flagged for review before they affect pay
- End-of-period tip totals calculated in seconds from the log
Built for restaurant owners · bar managers · Clover merchants · payroll and HR teams
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.clover.com/dashboardin a real browser with your saved login - no setup, no API keys. -
1
Clover - read tip totals and adjustments per employee
clover.com
WebRun opens Clover to read tip totals and adjustments per employee. - Open Clover Dashboard and navigate to Reporting
- Select the Tips report for yesterday's date
- Capture total tips collected per employee including credit card tips
- Note any tip adjustments or deletions for the period
- Flag any employee whose tip total differs significantly from their sales total
Done when Yesterday's tip totals and adjustments are collected per employee.
-
2
Google Sheets - log the daily tip reconciliation
google.com
WebRun opens Google Sheets to log the daily tip reconciliation. - Open the tip reconciliation Google Sheet
- Append one row per employee with date, employee name, total sales, total tips, tip percentage, and any adjustments
- Flag rows where tip percentage falls outside a normal range for your business
Done when Yesterday's tip reconciliation is logged and any anomalies are flagged.
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 distribute or pay out tips to employees?
No. WebRun logs and reconciles the tip data. Actual tip payouts are handled by your payroll process, so you stay in control of when and how tips are distributed.
What counts as a tip adjustment and why does it matter?
A tip adjustment is when a tip amount is changed after the transaction closes, which can happen legitimately or by mistake. Logging them daily lets you review and question any unusual adjustments before payroll runs.
Can I use this log for end-of-pay-period tip reporting?
Yes. Because the sheet logs one row per employee per day, you can sum each employee's tip column over any pay period to get accurate totals for payroll without re-pulling Clover reports.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.