Automated UOB Weekly Cash Summary
Every Monday, WebRun signs in to UOB business internet banking, records the closing balance and exports the week's transactions to a running Google Sheet, then publishes a short Notion summary with the balance and the largest inflows and outflows.
How do I get a weekly cash summary from UOB business banking?
WebRun signs in to UOB business banking every Monday, records the closing balance, and exports the week's transactions to a running Google Sheet. It then publishes a short Notion summary with the balance and the largest inflows and outflows, so your leadership team can see the week's cash position without opening internet banking.
- Leadership sees the week's cash position without logging into internet banking
- Every transaction is logged to a running sheet automatically
- Large inflows and outflows are called out, not buried in rows
Built for Singapore SMEs · finance managers · startup founders
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.uob.com.sgin a real browser with your saved login - no setup, no API keys. -
1
UOB - pull the week's balance and transactions
uob.com.sg
WebRun opens UOB to pull the week's balance and transactions. - Sign in to UOB business internet banking and open the operating account
- Record the closing balance and export the week's transactions
- Note the largest inflow and outflow of the week
Done when The week's balance and transactions are captured.
-
2
Google Sheets - log the transactions to a running sheet
google.com
WebRun logs the week's transactions to a running Google Sheet. - Append the week's transactions to the running Transactions sheet
- Update the running balance column
Done when The sheet has every transaction from the week logged.
-
3
Notion - publish the weekly cash summary
notion.so
WebRun publishes the weekly cash summary in Notion. - Publish a weekly cash summary page with the closing balance and notable movements
- Link out to the full Google Sheet for detail
Done when The leadership team has this week's cash summary in Notion.
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
Will this replace my accountant's reconciliation?
No. It gives your team a running log and a weekly summary to work from, but the final reconciliation and sign-off is still yours or your accountant's to do.
Can WebRun send a payment or move funds from UOB?
No. WebRun only reads balances and transactions and reports on them. It never initiates a transfer, payment, or withdrawal. Anything that moves money stays in UOB for you to action directly.
What if a week has an unusually large transaction?
It is called out by name and amount in the Notion summary, right alongside the closing balance, so it does not get lost in a long row of Sheet data.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.