Automated ManageAmerica Utility Recovery Reconciliation
Every month, once utility bills land, WebRun opens ManageAmerica to total what was billed to residents for water, sewer, and trash recovery, checks it against the actual utility invoices posted in QuickBooks, and logs any variance to a Google Sheet for your billing team to review.
How do I reconcile utility cost recovery billing against actual utility invoices?
WebRun compares what ManageAmerica billed residents for water, sewer, and trash recovery against the actual utility invoices posted in QuickBooks each month, then logs the variance for every utility type to a Google Sheet. Anything over a 5 percent gap is flagged, so your billing team catches under recovery before it compounds.
- Utility under recovery is caught within one billing cycle instead of a year later
- Every utility type gets a logged variance instead of a manual spreadsheet pull
- Anything over a 5 percent gap is flagged for review automatically
Built for manufactured housing community managers · MHC billing teams · mobile home park operators · regional property accountants
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.manageamerica.comin a real browser with your saved login - no setup, no API keys. -
1
ManageAmerica - total utility recovery billed to residents
manageamerica.com
WebRun opens ManageAmerica to total utility recovery billed to residents. - Open ManageAmerica and pull the utility recovery billing summary for the period
- Total the amount billed to residents by utility type: water, sewer, and trash
- Note the community and unit count the total covers
Done when This period's full utility recovery billing total is captured by utility type.
-
2
QuickBooks - check against actual utility invoices
- Open QuickBooks and find the actual utility invoices posted for the same period
- Total the actual cost paid to the utility provider by type
- Compare the actual cost against what was billed to residents in ManageAmerica
- Calculate the variance, over recovered or under recovered, for each utility type
Done when Every utility type has a calculated variance between billed and actual cost.
-
3
Google Sheets - log the variance report
google.com
WebRun opens Google Sheets to log the variance report. - Open the Utility Recovery Reconciliation sheet
- Log this period's billed total, actual cost, and variance by utility type
- Flag any variance over 5 percent for your billing team to investigate
Done when The reconciliation sheet reflects this period's full variance report.
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 any resident's bill or post a correction?
No. WebRun only compares numbers and logs the variance to a sheet. Any correction to a resident's account is a decision your billing team makes and enters manually.
How does it flag a real problem versus normal rounding?
It flags any utility type where billed recovery and actual cost differ by more than 5 percent, so small rounding differences do not clutter the report.
What utilities does it cover?
Water, sewer, and trash recovery by default, matching the utility types tracked in ManageAmerica's billing summary. Add or remove a utility type in your run settings.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.