Automated Equipment Lease Residual Value Reporting
Every Monday, WebRun opens Odessa and pulls the book residual values for all open-end and operating leases, aggregates the exposure by equipment category, and logs the full residual report in Google Sheets for the risk team. A summary of the top exposures is posted to Slack so the team can prioritise which residual positions to review first.
How do I track residual value exposure across my equipment lease portfolio automatically?
WebRun opens Odessa every Monday and pulls the book residual values on all open-end and operating leases. It aggregates exposure by equipment category, logs the full contract-level report in Google Sheets with week-over-week trend highlights, and posts a top-exposures summary to the risk team in Slack so residual risk is reviewed every week without manual reporting.
- Residual exposure by equipment category is reviewed every Monday without manual reporting
- Risk team sees which categories grew more than 10% week over week at a glance
- A dated Google Sheets history gives leadership a full residual trend record
Built for equipment finance risk teams · lease portfolio managers · credit officers · remarketing teams
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 - pull residual values from open-end and operating leases
odessainc.com
WebRun opens Odessa to pull residual values from open-end and operating leases. - Open Odessa and filter the portfolio for open-end and operating lease contracts
- For each contract, capture the equipment description, equipment category, book residual value, residual as a percentage of original cost, and maturity date
- Aggregate total residual exposure by equipment category (e.g. construction equipment, vehicles, medical devices)
Done when Residual value data for every qualifying contract is captured and aggregated by category.
-
2
Google Sheets - log residual exposure report
google.com
WebRun opens Google Sheets to log residual exposure report. - Open the residual value report Google Sheet
- Add this week's data as a new dated tab with the full contract-level list and the category summary
- Highlight any category where total residual exposure increased by more than 10% versus last week
Done when The Google Sheet contains this week's residual report with category summaries and trend highlights.
-
3
Slack - post top exposure summary to risk team
slack.com
WebRun opens Slack to post top exposure summary to risk team. - Post a residual exposure summary to the risk team Slack channel
- List the top 5 equipment categories by total residual exposure and any categories that moved more than 10% week over week
- Include a link to the full Google Sheets report
Done when Risk team has this week's top residual exposure summary in Slack.
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
Does it change residual values in Odessa?
No. WebRun reads residual values from Odessa and reports on them. It does not modify any contract data in the system.
Which lease types are included in the report?
It covers open-end and operating leases where the lessor retains residual risk. Closed-end finance leases where the lessee bears the residual risk are excluded by default, but you can include them if needed.
Can it compare book residuals to external market data?
The current version reports the book residuals from Odessa and tracks week-over-week changes. Adding external market benchmark data requires a connection to a valuation source your team configures.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.