Reconcile hall bank deposits against vendor sales totals
Every morning, WebRun opens Hallpass, totals the prior day's sales across every stall, compares that to the deposits and card settlements recorded in QuickBooks, and writes a dated reconciliation line to your Google Sheet, flagging any stall or day where the collected money does not match the reported sales.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically reconcile food hall deposits against vendor sales totals?
Every morning, WebRun totals the prior day's stall sales in Hallpass and matches them to the deposits and card settlements recorded in QuickBooks. It writes a dated reconciliation line to your Google Sheet and flags any stall or day where collected money does not match reported sales, so shortfalls surface daily instead of at month-end.
- Cash and card gaps surface the next morning, not at month-end
- Deposits matched to sales both hall-wide and per stall
- A dated audit trail builds up automatically in one sheet
Built for food hall operators · market hall finance teams · food hall bookkeepers · multi-vendor venue owners
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
www.hallpasshq.comin a real browser with your saved login - no setup, no API keys. -
1
Hallpass - total each stall's daily sales
hallpasshq.com How to Automate Hallpass
WebRun opens Hallpass to total each stall's daily sales. - Open Hallpass and pull the prior day's recorded sales for every stall
- Sum the hall-wide gross and note each stall's contribution
- Split the totals by payment type where Hallpass provides it, such as card and cash
Done when The prior day's hall-wide and per-stall sales totals are captured from Hallpass.
-
2
QuickBooks - match to money received
- Open QuickBooks and read the deposits and card settlements posted for that date
- Match the money received against the Hallpass sales totals, hall-wide and per stall
- Identify any difference between reported sales and money actually collected
Done when Each day's deposits are matched to sales and any variance is quantified.
-
3
Google Sheets - log the reconciliation and gaps
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the reconciliation and gaps. - Append a dated row to the reconciliation Google Sheet with sales, deposits, and the variance
- Highlight any stall or day where the gap exceeds your tolerance
- This is an internal finance log, so write it straight to the sheet
Done when The reconciliation sheet has a new dated line with any gaps 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 move money or adjust any ledger entries?
No. WebRun only reads Hallpass and QuickBooks and writes a reconciliation report to your Google Sheet. It never posts, edits, or transfers anything in your books. You act on the flagged gaps.
What counts as a gap worth flagging?
Any difference between reported stall sales and money actually collected that exceeds the tolerance you set. Small rounding stays quiet, while a material shortfall or surplus is highlighted for review.
Can it break the numbers down by stall?
Yes. The report matches deposits to sales both hall-wide and per stall, so you can see exactly which vendor's takings do not tie out rather than just a single hall total.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.