Reconcile your Lightspeed till and flag discrepancies every evening
Every evening, WebRun opens Lightspeed, pulls the end-of-day Z-report totals for cash, card, and other payment types, compares them against expected takings, logs the reconciliation in Google Sheets, and posts a summary with any discrepancies flagged to Slack.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically reconcile my Lightspeed POS end-of-day totals?
WebRun pulls your Lightspeed end-of-day Z-report every evening, compares cash and card totals against expected amounts, logs the full reconciliation in Google Sheets, and posts a Slack summary with any discrepancies flagged. Your books stay accurate without a manual nightly comparison.
- Discrepancies caught every evening rather than discovered at month-end
- Running reconciliation log in Google Sheets covers every trading day
- Multi-register and multi-location Z-reports consolidated automatically
Built for retail store owners · restaurant managers · retail accountants · multi-location operators
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
retail.lightspeedhq.comin a real browser with your saved login - no setup, no API keys. -
1
Lightspeed - pull end-of-day Z-report totals
lightspeedhq.com How to Automate Lightspeed
WebRun opens Lightspeed to pull end-of-day Z-report totals. - Open Lightspeed and navigate to the end-of-day Z-report for today
- Capture gross sales, net sales, tax collected, and totals by payment type
- Record cash expected versus cash counted and note any variance
- Pull void and refund totals for the day
Done when All end-of-day figures including payment-type breakdown and variances are captured.
-
2
Google Sheets - log reconciliation data
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log reconciliation data. - Append today's figures as a new row in the reconciliation log sheet
- Include date, gross sales, net sales, cash variance, card total, and refunds
- Calculate a running discrepancy total and flag rows where variance exceeds your threshold
Done when Today's reconciliation data is logged as a new row in Google Sheets.
-
3
Slack - post summary and flag discrepancies
slack.com How to Automate Slack
WebRun opens Slack to post summary and flag discrepancies. - Post a concise reconciliation summary to the designated Slack channel
- Highlight any payment-type variance that exceeds the accepted threshold
- Include a link to the Google Sheets log for full detail
Done when The reconciliation summary and any discrepancy flags are posted in Slack.
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
What counts as a discrepancy worth flagging?
You set the variance threshold, such as more than 5 dollars difference between expected and counted cash. WebRun flags any day where any payment type exceeds that threshold.
Does it replace my manual Z-report close-out?
It automates the logging and comparison step after your staff have closed the register in Lightspeed. The physical till count still happens at the register before WebRun runs.
Can it cover multiple tills or locations?
Yes. If your Lightspeed account has multiple registers or locations, WebRun can pull each one's Z-report and log them as separate rows in Google Sheets.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.