Find idle cash sitting in low-yield accounts and flag it for action
Every morning, WebRun opens Trovata, compares each account balance against its configured target operating level, identifies accounts with excess cash that could be swept to higher-yield vehicles, and logs the candidates in a Google Sheet with the account details and suggested sweep amount.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically find idle cash in bank accounts that could be swept to higher-yield investments?
WebRun opens Trovata every morning, compares each bank account balance against its target operating level, calculates the excess cash above the buffer for every account that qualifies, and logs each sweep candidate in a Google Sheet with the suggested amount so your treasury team can act on the best deployment opportunities the same day.
- Idle cash above target is surfaced every morning without manual review
- Treasury team has a prioritized sweep candidate list ready at the start of the day
- Excess balances are logged historically so yield-improvement trends are trackable
Built for corporate treasury teams · cash managers · CFOs · finance directors
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.trovata.ioin a real browser with your saved login - no setup, no API keys. -
1
Trovata - identify accounts with excess cash above target
trovata.io How to Automate Trovata
WebRun opens Trovata to identify accounts with excess cash above target. - Open Trovata and read the latest balances for all connected accounts
- Compare each balance against its configured target operating level
- Flag accounts where the balance exceeds the target by more than your defined buffer
- Calculate the suggested sweep amount (balance minus target minus buffer) for each flagged account
Done when All accounts with excess cash are identified and their suggested sweep amounts calculated.
-
2
Google Sheets - log sweep candidates with details and suggested amounts
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log sweep candidates with details and suggested amounts. - Open the Idle Cash Sweep Candidates spreadsheet
- Append a row for each flagged account with date, bank, account name, current balance, target, and suggested sweep amount
- Mark each row as Pending Decision for the treasury team to review
Done when All sweep candidates are logged in the Google Sheet and marked for team review.
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 WebRun actually move the money?
No. WebRun identifies and logs sweep candidates only. All transfers and investments require explicit human approval. The Google Sheet gives your team the information to act, but the action itself is always yours.
How do I set the target balance for each account?
During setup, provide WebRun with your target operating level and buffer for each account or account group in Trovata. It applies those rules on every morning run.
What if the excess is only temporary, such as a large receipt that will clear in a day?
WebRun logs the candidate with the current date so your team can see the timing and decide whether the surplus is truly idle. You can also configure a minimum number of consecutive days above target before a flag is raised.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.