TouchBistro Automated End-of-Day Reconciliation
Every night, WebRun opens TouchBistro, captures the closing sales and payment totals, compares them against your QuickBooks transaction records, and logs the reconciliation result with any variance to Google Sheets so your bookkeeper has a clean audit trail in the morning.
How do I automatically reconcile TouchBistro end-of-day totals with QuickBooks?
WebRun opens TouchBistro every night, pulls the end-of-day sales and payment totals, compares them against QuickBooks transaction records, and logs the result with any variance to Google Sheets. Your bookkeeper starts the morning with a clean reconciliation row already flagged for exceptions.
- Nightly reconciliation log is ready before the bookkeeper arrives
- Variances are flagged automatically without anyone doing manual math
- Clean audit trail in Sheets makes month-end close faster
Built for restaurant owners · bookkeepers · restaurant accountants · 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
app.touchbistro.comin a real browser with your saved login - no setup, no API keys. -
1
TouchBistro - pull closing sales and payment totals
touchbistro.com
WebRun opens TouchBistro to pull closing sales and payment totals. - Open TouchBistro Reporting and navigate to the End-of-Day Report for today
- Capture total net sales, payment method breakdown (cash, card, third-party), and tip totals
- Note any open checks or pending settlements still unresolved
Done when Closing totals are captured with payment method detail.
-
2
QuickBooks - match against transaction records
- Open QuickBooks and find today's deposited and pending transactions for the restaurant account
- Sum card settlements and cash deposits for the same calendar day
- Calculate the variance between TouchBistro's net sales and QuickBooks totals
Done when Variance between POS and accounting records is calculated.
-
3
Google Sheets - log reconciliation result and any variance
google.com
WebRun opens Google Sheets to log reconciliation result and any variance. - Append a new row to the reconciliation log with date, TouchBistro total, QuickBooks total, and variance
- Flag rows where the variance exceeds your threshold in red for bookkeeper review
- Leave the sheet open for your team to add notes or corrections
Done when Tonight's reconciliation row is logged with variance flagged if needed.
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 variance worth flagging?
You set the threshold during setup. Any difference between TouchBistro's net sales and QuickBooks totals above that amount gets a red flag in the sheet for your bookkeeper to review.
Does it make any changes in QuickBooks?
No. WebRun reads QuickBooks totals for comparison only. It writes only to the Google Sheets log and never modifies your accounting records.
What about cash drawers that close late?
WebRun runs at your chosen closing time. If you close after midnight, adjust the schedule to match so it always pulls a complete day's data.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.