Reconcile salt usage against what you billed
Every Monday, WebRun opens Yeti Software, totals the salt and ice melt each crew logged per site for the past week, pulls what QuickBooks shows was billed for those same sites, and writes every variance to a Google Sheet.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I reconcile salt and ice melt usage against what I billed?
Every Monday, WebRun totals the salt and ice melt each crew logged per site in Yeti Software for the week, then pulls what QuickBooks shows was actually billed for the same sites. It writes every variance to a Google Sheet, so overused or undercharged sites surface before your margins quietly slip.
- Overused sites surface before they erode your margin
- Undercharged sites get caught before the season ends
- One weekly sheet replaces a manual pull from two systems
Built for snow removal contractors · operations managers · snow and ice management companies · seasonal contract operators
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.yetisoftware.com/loginin a real browser with your saved login - no setup, no API keys. -
1
Yeti Software - total material logged per site
yetisoftware.com How to Automate Yeti Software
WebRun opens Yeti Software to total material logged per site. - Open Yeti Software and pull material usage logged per site for the past week
- Total salt and ice melt quantity by site
- Note any site with an unusually high or low total versus its size
Done when Every site has a total material quantity logged for the week.
-
2
QuickBooks - pull what was billed per site
- Open QuickBooks and pull the material quantity billed for each site over the same week
- Match each site to its Yeti Software record
Done when Every site has its billed material quantity pulled for the same week.
-
3
Google Sheets - write the variance report
google.com How to Automate Google Sheets
WebRun opens Google Sheets to write the variance report. - Write each site's logged quantity, billed quantity, and the variance between them
- Sort the largest variances to the top
Done when Every site's variance between used and billed material is written to the sheet.
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 anything in QuickBooks?
No. It only reads billed quantities from QuickBooks. It never edits an invoice or a bill on its own.
What counts as a variance worth flagging?
Any site where logged material and billed material differ by more than the threshold you set, so small rounding differences do not clutter the sheet.
Can I use this to catch undercharged sites?
Yes. A site using more material than billed shows up as a variance too, so you can true up the invoice before it goes out.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.