Track how much utility cost you're actually recovering
After each billing cycle closes, WebRun opens Conservice, pulls the total provider utility cost and the total resident billback for every property, calculates each property's cost recovery ratio, logs it to a running Google Sheet, and posts a ranked Slack report so you can see which properties are under target before the next cycle starts.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I track my utility cost recovery ratio across properties?
After each billing cycle closes, WebRun pulls every property's total provider utility cost and total resident billback from Conservice, calculates the cost recovery ratio for each, and logs it to Google Sheets alongside the prior period. A ranked Slack report then shows which properties are under target, so a slipping recovery ratio gets caught early.
- Under recovering properties surface right after the cycle closes, not next quarter
- Every property's ratio is tracked period over period automatically
- Finance gets a ranked report instead of building one from raw exports
Built for multifamily asset managers · property accountants · utility billing teams · regional property managers
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.conservice.comin a real browser with your saved login - no setup, no API keys. -
1
Conservice - pull cost and billback totals
conservice.com How to Automate Conservice
WebRun opens Conservice to pull cost and billback totals. - Open Conservice once the billing cycle closes for the period
- Pull each property's total provider utility cost across water, electric, and gas
- Pull each property's total resident billback for the same period
Done when Every property has a captured provider cost total and resident billback total for the period.
-
2
Google Sheets - log each property's recovery ratio
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log each property's recovery ratio. - Open the cost recovery tracking sheet
- Calculate each property's recovery ratio as billback divided by provider cost
- Add the period's row and keep the prior period's ratio for comparison
Done when Every property's recovery ratio for the period is logged with its prior period for comparison.
-
3
Slack - report the ranked results
slack.com How to Automate Slack
WebRun opens Slack to report the ranked results. - Post the ranked recovery ratio report to the finance or ops channel
- Put properties below your target ratio at the top
- Note which properties moved the most from the prior period
Done when Your team has this period's ranked recovery ratio report 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
How is the recovery ratio calculated?
It divides each property's total resident billback by its total provider utility cost for the period, so a ratio under 100 percent means the property recovered less than it paid.
Will it change billing rates to fix a low ratio?
No. WebRun only reports the ratio. Any change to billing rates or allocation methods is a decision your team makes and enters separately.
Can I see how a property trended over time?
Yes. Each period's ratio is added as a new row in Google Sheets alongside the prior period, so a running trend builds automatically.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.