Automated Per-Lot Job Margin Reports
Every Monday, WebRun opens Bitumio for last week's finished jobs, reads the material, labor, equipment, and trucking costs, pulls the invoiced revenue from QuickBooks, works out the margin per lot, and writes a scorecard to a Google Sheet.
How do I see the real profit margin on each asphalt job?
WebRun shows the true margin on every lot each Monday. It reads material, labor, equipment, and trucking costs for last week's finished jobs in Bitumio, pulls invoiced revenue from QuickBooks, computes dollar margin and margin percent per lot, and writes a scorecard to Google Sheets, so you see which work actually made money.
- True dollar and percent margin on every finished lot
- Thin-margin jobs surface at the top for review
- Uninvoiced finished work is flagged before it slips
Built for asphalt maintenance owners · sealcoating contractors · paving estimators · pavement finance teams
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.bitumio.comin a real browser with your saved login - no setup, no API keys. -
1
Bitumio - gather job costs
bitumio.com
WebRun opens Bitumio to gather job costs per lot. - Open Bitumio and list jobs completed in the last week
- Read the job-cost figures for each lot: material, labor, equipment, and trucking
- Note the estimated cost so actuals can be compared to the bid
Done when Every finished lot has its actual costs gathered from Bitumio.
-
2
QuickBooks - pull invoiced revenue
- Match each completed lot to its invoice in QuickBooks
- Read the invoiced revenue, discounts, and any change orders
- Flag any finished job that has not been invoiced yet
Done when Each finished lot is matched to its invoiced revenue in QuickBooks.
-
3
Google Sheets - write the margin scorecard
google.com
WebRun opens Google Sheets to write the margin scorecard. - Write a scorecard row per lot with revenue, total cost, dollar margin, and margin percent
- Compare actual cost to the bid and highlight lots that came in under target
- Sort so the thinnest-margin lots surface at the top for review
Done when The per-lot margin scorecard is written to the Google Sheet, thinnest margin first.
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
Is this just an internal report or does it message anyone?
It is purely internal. WebRun writes the margin scorecard to your Google Sheet only. It never emails a customer, changes an invoice, or posts anything public.
How is margin calculated?
WebRun reads actual material, labor, equipment, and trucking costs from Bitumio, pulls invoiced revenue from QuickBooks, and computes dollar margin and margin percent per lot, then compares actual cost to the original bid.
What about jobs that are not invoiced yet?
It flags any finished lot with no matching QuickBooks invoice so you can bill it, rather than reporting a false margin on revenue that has not landed.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.