Catch distributor billing errors before you pay the wrong amount
Every Monday, WebRun opens City Hive to pull the week's receiving records, cross-references them against the distributor invoices your team has uploaded to Google Sheets, flags any quantity or price discrepancies, and posts the reconciliation summary to Slack for your bookkeeper to review before paying.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically reconcile distributor invoices against my liquor store receiving records?
WebRun pulls your City Hive receiving records every Monday, cross-references them against distributor invoices your team uploads to Google Sheets, and flags every quantity or price discrepancy. It posts the reconciliation summary to Slack so your bookkeeper can review and dispute any billing errors before payment is made.
- Billing errors caught before payment every week
- Total variance per distributor is visible in seconds
- No manual line-by-line comparison needed by your team
Built for liquor store bookkeepers · bottle shop owners · beverage retail finance teams · wine and spirits buyers
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.cityhive.netin a real browser with your saved login - no setup, no API keys. -
1
City Hive - pull weekly receiving records
cityhive.net
WebRun opens City Hive to pull weekly receiving records. - Open City Hive and navigate to the receiving or purchase order history
- Filter to deliveries received in the past seven days
- Capture the product, SKU, quantity received, and agreed unit cost for each line
Done when All receiving records for the past week are captured from City Hive.
-
2
Google Sheets - cross-reference against distributor invoices
google.com How to Automate Google Sheets
WebRun opens Google Sheets to cross-reference against distributor invoices. - Open the distributor invoice sheet where your team has uploaded this week's invoices
- Match each invoice line to the corresponding receiving record by SKU and delivery date
- Flag lines where the invoiced quantity differs from the received quantity
- Flag lines where the invoiced unit price differs from the agreed cost by more than your tolerance threshold
- Summarize the total dollar value of flagged discrepancies per distributor
Done when All discrepancies are flagged in Google Sheets with amounts and distributor names.
-
3
Slack - post the reconciliation summary
slack.com How to Automate Slack
WebRun opens Slack to post the reconciliation summary. - Post a reconciliation summary to the finance or buying channel: number of invoices checked, number of discrepancies found, and total dollar value flagged
- List each discrepancy with the distributor, SKU, and variance amount
- Include a link to the Google Sheets reconciliation report
Done when Bookkeeper has the week's discrepancy summary in Slack with a link to the full report.
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 approve or dispute invoices on its own?
No. WebRun flags discrepancies and posts the report for your bookkeeper to review. Any payment approval or dispute with a distributor is handled by your team after reviewing the report.
How do I get the distributor invoices into Google Sheets for it to read?
Your team uploads or pastes the invoice data into the designated Google Sheet before Monday. WebRun reads whatever is there on each run and matches it against City Hive records.
Can I set the price tolerance threshold it uses to flag variances?
Yes. Tell WebRun the dollar or percentage tolerance you are comfortable with and it will only flag lines that exceed that threshold, keeping the report focused on real discrepancies.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.