Automated Contracts In Transit Tracking
Every morning, WebRun opens MenuMetric, reads every contract still in transit, calculates days in transit and the lender funding deadline for each, logs an aging report to Google Sheets, and sends your finance director a Telegram digest of the deals closest to falling out of funding.
How do I automatically track car deals in transit before their funding deadline?
WebRun opens MenuMetric each morning and reads every contract still in transit. It calculates days in transit and the lender funding deadline for each, logs a sorted aging report to Google Sheets, and sends your finance director a Telegram digest of the deals closest to falling out of funding, so aging contracts get chased before they die.
- No contract falls out of funding unnoticed because the aging report is rebuilt every morning
- The finance director sees total dollars outstanding and the riskiest deals in one Telegram digest
- Overdue contracts surface the day they pass the lender window so they can be chased immediately
Built for F&I managers · finance directors · dealership controllers · funding clerks
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.menumetric.comin a real browser with your saved login - no setup, no API keys. -
1
MenuMetric - read contracts still in transit
menumetric.com
WebRun opens MenuMetric to read contracts still in transit. - Open MenuMetric and list every deal with a status of in transit or pending funding
- For each, capture the buyer, vehicle, lender, amount financed, and the contract date
- Calculate days in transit from the contract date to today
- Compare that against each lender's typical funding window to find the deadline
Done when Every in transit contract has a days in transit count and a funding deadline.
-
2
Google Sheets - build the funding aging report
google.com
WebRun opens Google Sheets to build the funding aging report. - Open the Contracts In Transit sheet
- Update or append a row per unfunded deal with buyer, lender, amount, and days in transit
- Sort by funding deadline so the deals closest to falling out sit at the top
- Flag any deal past the lender's usual funding window as overdue
Done when The aging report is current and sorted with overdue contracts flagged.
-
3
Telegram - digest the deals at risk
telegram.org
WebRun opens Telegram to digest the deals at risk. - Send a Telegram digest to the finance director with the count of contracts in transit and total dollars outstanding
- List the deals closest to their funding deadline first with buyer, lender, and days in transit
- Call out any contract already past the lender's usual funding window
Done when The finance director has a Telegram digest of contracts at risk of falling out of funding.
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 contact the lender or the buyer about funding?
No. WebRun only builds an internal aging report in Google Sheets and sends your finance director a Telegram digest. It never contacts the lender or the buyer on its own.
How does it work out each contract's funding deadline?
It counts days in transit from the contract date in MenuMetric and compares that to each lender's typical funding window, so the deals closest to falling out sit at the top.
What happens when a contract funds?
It reads the live deal status in MenuMetric each morning, so any contract marked funded drops off the aging report and the digest automatically.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.