Automated CFO Cash Flow Data Entry From Client Emails
When a client emails cash balance updates, payroll figures, or bank statement summaries, WebRun reads the key figures from the email, logs them into your Google Sheet cash flow tracker, updates the actual figures in the relevant Fathom forecast model, and posts a confirmation to Slack so your team knows the data is in.
How can I automatically extract cash flow actuals from client emails and update my Fathom forecast?
When a client emails cash balance updates or bank statement summaries, WebRun reads the key figures, logs the actuals in your Google Sheet cash flow tracker, updates the Fathom forecast model with the new data, and posts a Slack confirmation with the closing balance and variance. Manual data entry from client emails is eliminated.
- Cash actuals from client emails are in the tracker and Fathom forecast within minutes
- Manual copy-paste data entry from client emails is eliminated entirely
- Forecast variance is visible in Slack the moment actuals arrive
Built for fractional CFOs · outsourced finance teams · CFO advisory practices · management accountants
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
mail.google.comin a real browser with your saved login - no setup, no API keys. -
1
Gmail - read cash flow figures from client email
gmail.com
WebRun opens Gmail to read cash flow figures from client email. - Open the incoming client email flagged with the cash update or statement label
- Read the key figures: opening balance, receipts, payments, and closing cash balance
- Note the period the figures relate to and the client name from the email thread
Done when The cash flow figures and period are extracted from the client email.
-
2
Google Sheets - log actuals in cash flow tracker
google.com
WebRun opens Google Sheets to log actuals in cash flow tracker. - Open the client's cash flow tracker sheet
- Find the correct row for the reporting period and enter the actuals extracted from the email
- Flag the row as Updated Today so the team can see what changed
Done when The actuals are logged in the Google Sheet tracker for the correct client and period.
-
3
Fathom - update forecast with new actuals
fathomhq.com
WebRun opens Fathom to update forecast with new actuals. - Open the client's Fathom organisation and navigate to the cash flow forecast model
- Update the actual closing cash balance and any period figures that differ from the forecast
- Note the variance between actuals and the forecast for this period
Done when The Fathom forecast reflects the latest actuals and the variance is noted.
-
4
Slack - confirm data is logged and ready
slack.com
WebRun opens Slack to confirm data is logged and ready. - Post a confirmation to the data-updates Slack channel noting the client, period, and closing cash balance
- Include the variance versus the Fathom forecast so the team can assess impact
- Tag the responsible CFO so they can review the updated forecast if needed
Done when The team has a Slack confirmation that the cash actuals are logged and the forecast is updated.
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
How does it know which emails to process?
It monitors a specific Gmail label or folder you designate for client cash updates. Only emails in that label are processed, so unrelated client emails are not touched.
Will it make changes in Fathom without my review?
It updates the actuals in the Fathom forecast model, but the CFO receives a Slack confirmation with the variance so they can review and adjust the forecast narrative before the next client report.
What if the email format varies between clients?
You configure a simple extraction template for each client during setup, defining which figures to capture and where they appear. WebRun applies each client's template on every run.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.