Automated Ekos Keg Deposit Reconciliation
Every Monday, WebRun opens Ekos, totals keg deposits owed by each account based on kegs currently out, cross checks those figures against deposit payments recorded in QuickBooks, flags any account where the two do not match, and posts a reconciliation summary to Slack for your accounting team.
How do I automatically reconcile keg deposits between Ekos and QuickBooks?
WebRun totals keg deposits owed by account in Ekos every Monday, checks those figures against the deposit payments actually recorded in QuickBooks, and posts a Slack summary flagging any account where the two disagree, so your accounting team can chase down a real gap instead of hunting through two systems by hand.
- Mismatched keg deposits surface every Monday instead of at year end
- Accounting sees matched and flagged accounts in one Slack summary
- Outstanding kegs with unpaid deposits are sized in dollars, not guesswork
Built for craft breweries · brewery accountants · operations managers · distribution managers
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.goekos.comin a real browser with your saved login - no setup, no API keys. -
1
Ekos - total keg deposits owed by account
goekos.com
WebRun opens Ekos to total keg deposits owed by account. - Open Ekos and pull the current keg tracking report
- Total kegs out and the deposit amount owed for each distributor or account
- Note how long each keg has been outstanding
Done when Every account with kegs out has a total deposit amount owed.
-
2
QuickBooks - check deposits actually recorded
- Open QuickBooks and pull deposit payments and credits recorded for the same accounts
- Match each account's recorded deposit balance against the Ekos total
- Flag any account where the two figures differ
Done when Every account's Ekos deposit total has been checked against its QuickBooks balance.
-
3
Slack - flag mismatches for accounting
slack.com
WebRun opens Slack to flag mismatches for accounting. - Post the reconciliation summary to your accounting or finance channel
- List accounts with matching balances first, then flag mismatches with both figures side by side
- Sort flagged accounts by dollar amount so the largest gaps get looked at first
Done when Accounting has a Monday summary of matched and mismatched keg deposit balances.
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 fix mismatched deposit balances on its own?
No. WebRun only flags where Ekos and QuickBooks disagree. Your accounting team decides whether it is a timing gap, a missed entry, or a keg that needs chasing down.
How far back does it check?
It compares the live keg tracking report in Ekos against the current QuickBooks balance each Monday, so it catches any deposit that has drifted out of sync since the prior run.
Will it contact distributors about unpaid deposits?
No. It only posts an internal Slack summary. Reaching out to an account about a deposit stays a decision your team makes.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.