SpotOn End-of-Day Reconciliation Automation
Every night after close, WebRun opens SpotOn's end-of-day report, pulls totals by tender type, checks each figure against your QuickBooks expected receipts, and sends a reconciliation summary to your Telegram so you know before you leave whether the drawer balances.
How do I automatically reconcile SpotOn end-of-day totals with QuickBooks?
WebRun opens SpotOn's end-of-day report every night after close, pulls totals for each tender type, and compares them to QuickBooks expected receipts. Any variance above your configured threshold is flagged and the full reconciliation summary is sent to your Telegram so you can sign off without sitting at a spreadsheet.
- Drawer variances spotted the same night, not the next morning
- Tender-type totals matched to QuickBooks without manual data entry
- Open tabs and unpaid checks flagged before anyone leaves for the night
Built for restaurant managers · bar owners · retail store managers · hospitality 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
spoton.comin a real browser with your saved login - no setup, no API keys. -
1
SpotOn - pull end-of-day payment totals by tender
spoton.com
WebRun opens SpotOn to pull end-of-day payment totals by tender. - Open SpotOn and navigate to the end-of-day closing report
- Capture totals for each tender type: cash, credit, debit, gift card, and house account
- Note total tips collected and any open tabs left unpaid
Done when End-of-day totals by tender type are captured from SpotOn.
-
2
QuickBooks - match against expected receipts
- Open QuickBooks and locate today's expected deposit and sales receipt entries
- Compare SpotOn totals by tender type to the QuickBooks figures
- Flag any line where the variance exceeds your configured tolerance (default: $5)
Done when Each tender type has been matched and variances above the threshold are flagged.
-
3
Telegram - send nightly reconciliation summary
telegram.org
WebRun opens Telegram to send nightly reconciliation summary. - Compose a short reconciliation summary: totals matched, any variance lines, and open tabs
- Send the summary to your private manager Telegram chat
- If a variance exceeds the threshold, prepend a clear flag so it stands out
Done when The nightly reconciliation summary is in your Telegram, ready for sign-off.
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 actually change anything in QuickBooks?
No. WebRun reads QuickBooks figures for comparison only. It never creates, edits, or deletes any QuickBooks entry during the reconciliation check.
What counts as a variance worth flagging?
By default, any tender-type line where SpotOn and QuickBooks differ by more than $5 is flagged. You can adjust this threshold when you set up the workflow.
What if SpotOn's end-of-day report is not ready when the run starts?
WebRun waits up to 30 minutes and retries if the report is not yet available, then sends a warning via Telegram if the report still cannot be found.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.