Surface delinquency risk in your portfolio before accounts roll
Every Monday, WebRun opens Odessa and analyses payment history, aging buckets, and contract status across your portfolio to build a delinquency risk score for each account, ranks them by risk, posts the top accounts to your risk team via Telegram, and logs the full scored list in Google Sheets for trend tracking.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I identify delinquency risk in my equipment lease portfolio before accounts roll?
WebRun pulls your Odessa payment aging report every Monday, scores each active lease contract for delinquency risk based on aging bucket, missed payment history, and balance, and sends the top-risk accounts to your team via Telegram. The full scored list is logged in Google Sheets for week-over-week trend tracking.
- Early-stage delinquent accounts are flagged before they roll to a worse aging bucket
- Risk team gets a scored worklist every Monday morning via Telegram
- Week-over-week trend data in Google Sheets shows portfolio health at a glance
Built for equipment finance risk teams · credit risk managers · portfolio analysts · commercial lenders
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.odessainc.comin a real browser with your saved login - no setup, no API keys. -
1
Odessa - analyse payment history and aging buckets
odessainc.com How to Automate Odessa
WebRun opens Odessa to analyse payment history and aging buckets. - Open Odessa and pull the portfolio aging report
- For each active contract, record the current bucket (current, 1 to 30, 31 to 60, 61 to 90, 90+), payment frequency, and any recent missed payments
- Score each account based on aging bucket, number of missed payments in the past 6 months, and outstanding balance
- Rank accounts from highest to lowest risk score
Done when Every active contract has a risk score and the list is sorted highest risk first.
-
2
Telegram - send ranked risk worklist to risk team
telegram.org How to Automate Telegram
WebRun opens Telegram to send ranked risk worklist to risk team. - Send a Telegram message to the risk team channel with the top 20 highest-risk accounts
- Include lessee name, contract number, current aging bucket, and risk score for each
- Note any account that has rolled to a worse bucket since last week
Done when The risk team has received this week's top-risk accounts via Telegram.
-
3
Google Sheets - log full scored portfolio for trend tracking
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log full scored portfolio for trend tracking. - Open the portfolio risk Google Sheet and add this week's scores as a new dated column
- Highlight accounts whose score worsened by more than 10 points week over week
- Keep prior weeks' scores for trend analysis
Done when The Google Sheet contains today's full scored portfolio with historical trend data.
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 it contact lessees about their delinquency risk?
No. WebRun posts the risk worklist internally to your team via Telegram and Sheets only. No communication is sent to lessees.
How is the risk score calculated?
The score weights aging bucket most heavily, then number of missed payments in the last six months, and outstanding balance. You can adjust the weights to match your credit policy.
Can it track if a high-risk account is resolved the following week?
Yes. The Google Sheets log retains prior-week scores, so the team can see week-over-week movement and confirm that resolved accounts have dropped off the risk list.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.