All templates

Daily Cash Position Report

Every morning, WebRun opens Xero, reads your current bank balances and outstanding payables and receivables, logs the numbers to your cash-flow sheet, and posts a one-paragraph plain-English summary to Slack before 8 AM.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 Xero read balances and ledger
2 Google Sheets log today's position
3 Slack post the daily summary
In short

How can I automatically get a daily cash position report from Xero?

Every morning, WebRun opens Xero, reads your current bank balances along with outstanding payables and receivables, logs the numbers to your cash-flow Google Sheet, and posts a plain-English cash position summary to Slack before you start your day.

  • Know your cash position before the day starts, every day
  • Payables and receivables tracked automatically in one place
  • Plain-English summary - no accountant needed to interpret it

Built for business owners · CFOs · finance managers · startup founders

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 go.xero.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Xero - read balances and ledger
    xero.com
    WebRun in Xero: read balances and ledger
    WebRun opens Xero to read balances and ledger.
    • Open Xero Dashboard and read the current balance for each bank account
    • Open Accounts Receivable Aged Summary and capture total overdue and due this week
    • Open Accounts Payable Aged Summary and capture total due this week
    • Calculate net cash position: balances plus receivables due minus payables due

    Done when Today's cash position figure and breakdown are captured.

  3. 2
    Google Sheets - log today's position
    google.com
    WebRun in Google Sheets: log today's position
    WebRun opens Google Sheets to log today's position.
    • Open the cash-flow tracking sheet
    • Append a new row with today's date, each bank balance, AR total, AP total, and net position
    • Confirm the row is saved before moving on

    Done when Today's figures are logged as a new row in the sheet.

  4. 3
    Slack - post the daily summary
    slack.com
    WebRun in Slack: post the daily summary
    WebRun opens Slack to post the daily summary.
    • Post a short summary: net cash, key balances, biggest AR and AP items due this week
    • Flag any balance that has dropped below a threshold you set

    Done when The daily cash summary is visible in your Slack channel.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
go.xero.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Cash report · Slack
OutputWhat each run produces - A daily cash position summary with bank balances, AR/AP totals, and net position - also logged to your spreadsheet.
Text
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 any money?

No - it only reads your Xero data and reports. No transfers, payments, or ledger changes are made.

How up to date is the data?

It reads your live Xero bank feed and ledger each morning, so the numbers reflect whatever cleared overnight.

Can I set a low-cash alert threshold?

Yes. Tell WebRun a minimum balance and it will highlight in the Slack message whenever you drop below it.

Keep going

Related templates

Chase Overdue Invoices Automatically
WebRun finds every past-due invoice, drafts a polite reminder for each customer, and gives you a clear picture of who still owes you money.
QuickBooks›Gmail›Slack
Flag Duplicate & Unusual Expenses
WebRun scans your expense feed for duplicate charges and out-of-pattern spending, then surfaces the suspicious ones for your review before they hit the books.
Ramp›Google Sheets›Slack
Run a Payroll Pre-Check Before Pay Day
Before payroll is processed, WebRun verifies headcount, hours, and deductions in Gusto and flags any discrepancy for you to fix - so no one is overpaid, underpaid, or missed.
Gusto›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