Automated Lavu POS End-of-Day Reconciliation
Every night after close, WebRun opens Lavu, reads the end-of-day totals for cash, card, and other tender types, logs them to a running Google Sheet, and posts a Slack alert if any tender type is out of balance.
How do I automatically reconcile my Lavu POS end-of-day close?
WebRun reads your Lavu end-of-day close report every night, captures cash and card tender totals, logs them to a Google Sheet, and posts a Slack summary to your manager channel. Any cash variance above your threshold is flagged immediately so the team can investigate before the next morning's open.
- Cash and card discrepancies caught the same night, not the next morning
- Running reconciliation log built automatically in Google Sheets
- Manager alerted via Slack before the next shift opens
Built for restaurant managers · bar owners · multi-location restaurant operators · hospitality finance 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
lavu.comin a real browser with your saved login - no setup, no API keys. -
1
Lavu - read end-of-day close totals
lavu.com
WebRun opens Lavu to read end-of-day close totals. - Open Lavu and navigate to the End of Day report for today's date
- Capture cash expected, cash counted, and any variance
- Capture card totals by payment type (Visa, Mastercard, Amex, gift card)
- Note total sales, total payments, and any unresolved open checks
Done when All tender totals and any variances for the current business day are captured.
-
2
Google Sheets - log tender totals to running sheet
google.com
WebRun opens Google Sheets to log tender totals to running sheet. - Open the designated reconciliation Google Sheet
- Append a new row with today's date, tender totals, and variance amounts
- Highlight any row where cash variance exceeds the agreed threshold
Done when Today's close totals are logged to the reconciliation sheet.
-
3
Slack - post reconciliation summary and flag discrepancies
slack.com
WebRun opens Slack to post reconciliation summary and flag discrepancies. - Post a summary of today's close: sales total, tender breakdown, and variance
- If any discrepancy is above threshold, flag it with a clear note for the manager
- Include a link to the Google Sheet for the full detail
Done when The reconciliation summary is posted to Slack and any discrepancies 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 it contact staff or guests about the discrepancy?
No. It posts an internal Slack alert to the manager channel only. No messages are sent to guests or non-management staff.
What counts as a discrepancy worth flagging?
You set the threshold during setup, for example any cash variance over $5. WebRun applies your rule each night and flags only the runs that exceed it.
Where are the historical reconciliation records stored?
Each night's totals are appended as a new row in your designated Google Sheet, giving you a continuous log you can filter and audit at any time.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.