All templates

Automated Poster Delivery Sales Reconciliation

Every morning, WebRun opens Poster, splits yesterday's sales into dine in, takeaway, and delivery channels, logs the breakdown to a Google Sheet, and checks Xero to flag any channel whose payout does not match.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 Poster split sales by channel
2 Google Sheets log the channel breakdown
3 Xero check channel payouts match
In short

How do I reconcile delivery channel sales against Poster?

Every morning, WebRun opens Poster and splits yesterday's sales into dine in, takeaway, and delivery channels, logging the breakdown to a Google Sheet. It then checks Xero to flag any channel whose recorded payout doesn't match Poster's sales, so a missing deposit gets caught within a day.

  • Every sales channel is broken out daily, not just at month end
  • Missing delivery payouts are caught within a day, not next quarter
  • One Sheet shows dine in, takeaway, and delivery side by side

Built for cafe owners · multi-channel restaurant operators · delivery-heavy cafes · hospitality bookkeepers

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens joinposter.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Poster - split sales by channel
    joinposter.com
    WebRun in Poster: split sales by channel
    WebRun opens Poster to split sales by channel.
    • Open Poster's Sales report for yesterday
    • Split total sales into dine in, takeaway, and delivery by service type
    • Note the order count and revenue for each channel

    Done when Yesterday's sales are split by channel with revenue and order count.

  3. 2
    Google Sheets - log the channel breakdown
    google.com
    WebRun in Google Sheets: log the channel breakdown
    WebRun opens Google Sheets to log the channel breakdown.
    • Open the channel sales log
    • Add yesterday's revenue and order count for each channel
    • Update the running share of sales by channel

    Done when Yesterday's channel breakdown is logged with the updated running totals.

  4. 3
    Xero - check channel payouts match
    xero.com
    WebRun in Xero: check channel payouts match
    WebRun opens Xero to check channel payouts match.
    • Open Xero and find the recorded payout for each delivery channel
    • Compare it to the delivery revenue Poster reported
    • Flag any channel where the two don't match

    Done when Every channel's Xero payout has been checked against Poster's reported sales.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
joinposter.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Channel sales reconciliation · Google Sheets
OutputWhat each run produces - A breakdown of sales by channel with the matching Xero payout for each, flagged where they don't match.
Table
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it move money between accounts?

No. WebRun only reads sales from Poster and payout records from Xero to compare them. It never moves money or edits a transaction.

What channels does it split out?

Whatever service types you use in Poster, typically dine in, takeaway, and delivery, so you can see each channel's share of the day's sales.

What happens when a channel total doesn't match?

It's logged to the Sheet with both figures side by side, so you can check the delivery platform's payout report before the gap is forgotten.

Keep going

Related templates

Automated Poster ABC Inventory Analysis
Every week, WebRun pulls Poster's ABC inventory analysis, breaks out which ingredients drive most of your cost and usage, and emails you a clear action report.
Poster›Google Sheets›Gmail
Automated Poster Bar Pour Cost Variance Flags
WebRun compares each bar recipe's theoretical pour cost in Poster against actual liquor invoices in Xero every week, logs the results to a Sheet, and flags in Slack any drink whose cost has crept up.
Poster›Xero›Google Sheets›Slack
Automated Poster Cafe Sales Digest
Every night, WebRun pulls the day's sales, covers, and average ticket from Poster, logs the totals to a Sheet, and sends you a short Slack digest so you start tomorrow already caught up.
Poster›Google Sheets›Slack

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.

Deploy this workflow Talk to us