PortPro Automated Chassis Usage Report
Every Monday, WebRun opens PortPro, reads chassis assignments across all active and recently closed loads, calculates days on hire and estimated cost per unit, and writes a chassis usage report to Google Sheets so your operations team can identify idle chassis and control rental costs.
How do I automatically report chassis usage and cost from PortPro?
Every Monday, WebRun opens PortPro, reads chassis assignments across all active and recently closed loads, calculates days on hire and estimated cost per unit, and writes a Google Sheets report grouped by chassis provider so your team spots idle chassis and controls rental spend week by week.
- Chassis on hire over 7 days flagged every Monday before costs compound
- Spend visible by provider so the most expensive pool is tackled first
- One sheet replaces manual chassis tracking across multiple loads
Built for drayage carriers · port trucking operators · intermodal chassis managers · container logistics cost controllers
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.portpro.ioin a real browser with your saved login - no setup, no API keys. -
1
PortPro - read chassis assignments and days on hire
portpro.io
WebRun opens PortPro to read chassis assignments and days on hire. - Open PortPro and pull all chassis assignments on active and loads closed in the past 7 days
- Read chassis number, provider, pickup date, return date (or current date if still out), and the load it is assigned to
- Calculate days on hire and estimated rental cost using the rate on file for each chassis provider
Done when Every chassis has a days-on-hire figure and an estimated cost for the reporting period.
-
2
Google Sheets - write weekly chassis usage and cost report
google.com
WebRun opens Google Sheets to write weekly chassis usage and cost report. - Open the Chassis Usage Report sheet and create a new weekly tab
- Write each chassis row with provider, pickup date, return date, days on hire, and estimated cost
- Add a summary section with total spend by chassis provider and flag any chassis on hire over 7 days
Done when The weekly chassis report is written with a cost summary by provider and long-hire flags.
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
How does it know the chassis rental rate?
It uses the chassis rental rate recorded against each provider in PortPro. If no rate is on file, the cost column is left blank and flagged so your team can add the rate for future runs.
Can it track chassis from multiple pool providers?
Yes. The report groups usage by chassis provider so you can compare spend across DCLI, TRAC, Flexi-Van, or any other pool provider recorded in PortPro.
Will it return or release chassis on its own?
No. WebRun only produces the usage report. All chassis return decisions and communications are made by your operations team.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.