Reconcile your Lightspeed end-of-day totals without the manual work
Every evening, WebRun opens Lightspeed Retail, reads the end-of-day close totals for each payment method, compares them to the expected amounts, and logs any cash or card variances to a Google Sheets reconciliation log for your manager to review and sign off.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically reconcile Lightspeed end-of-day totals each night?
WebRun opens Lightspeed Retail every evening after close, reads end-of-day totals for each payment type, and logs them to a Google Sheets reconciliation file with variances calculated. Discrepancies above your set threshold are highlighted so your manager can review and sign off each morning without manual data entry.
- Nightly reconciliation log is ready for manager review every morning
- Variances above your threshold are highlighted automatically so nothing slips through
- Manual data entry for end-of-day close is eliminated entirely
Built for retail managers · store owners · retail operations teams · multi-register retailers
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 - read end-of-day close totals by payment type
lightspeedhq.com How to Automate Lightspeed
WebRun opens Lightspeed to read end-of-day close totals by payment type. - Open Lightspeed Retail and navigate to the End of Day report for today
- Capture totals for each payment method: cash, card, gift card, and account
- Note the number of transactions, total refunds, and net revenue for the day
- Record the opening float and closing cash count if available
Done when All end-of-day totals by payment type are captured for today.
-
2
Google Sheets - log totals and flag variances
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log totals and flag variances. - Append today's totals to the running reconciliation sheet with a date stamp
- Calculate variance for each payment type against the Lightspeed expected total
- Highlight rows where variance exceeds the tolerance threshold you have set
- Leave a notes column blank for your manager to add comments during review
Done when Today's totals are logged in Google Sheets with variances calculated and large discrepancies highlighted.
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 close the till or process any transactions in Lightspeed?
No. WebRun reads the end-of-day report data only. Closing the till and approving the day's totals remains a human step your manager performs directly in Lightspeed.
What counts as a variance worth flagging?
You set the tolerance, for example flag anything more than $5 off. WebRun highlights rows above that threshold in Google Sheets so your manager focuses only on meaningful discrepancies.
Can it run for multiple registers or locations?
Yes. WebRun can capture end-of-day totals per register or per location in Lightspeed and log each as a separate section in the Google Sheets reconciliation file.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.