Automated Junk Removal Weekly Revenue Report
Every Monday morning, WebRun opens Jobber and reads all completed jobs and collected payments from the previous week, calculates total revenue broken down by crew, job type, and service area, appends the weekly summary to a running Google Sheet for trend tracking, and posts a concise Slack report to your ops channel so you start Monday knowing last week's numbers before your first coffee.
How do I automatically generate a weekly revenue report for my junk-removal business?
Every Monday, WebRun reads all completed jobs and payments from the previous week in Jobber, calculates total revenue broken down by crew, job type, and service area, logs the weekly figures to a running Google Sheet, and posts your team a concise Slack summary with a week-over-week comparison so you start the week knowing exactly how the business performed.
- Owner sees last week's revenue summary in Slack before the work week begins
- Crew and job-type breakdowns reveal where revenue is coming from each week
- Running Google Sheet builds a year-long revenue trend with no manual entry
Built for junk removal business owners · hauling company managers · junk-removal operations leads · field service finance owners
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.getjobber.comin a real browser with your saved login - no setup, no API keys. -
1
Jobber - read last week's completed jobs and payments
getjobber.com
WebRun opens Jobber to read last week's completed jobs and payments. - Open Jobber and filter completed jobs for the previous calendar week (Monday to Sunday)
- Read total revenue collected, job count, and average job value for the week
- Break down revenue by crew, job type (residential vs. commercial, full-home cleanout vs. single-item pickup), and service area
Done when Last week's revenue figures are captured by crew, job type, and area from Jobber.
-
2
Google Sheets - log weekly revenue breakdown
google.com
WebRun opens Google Sheets to log weekly revenue breakdown. - Open the weekly revenue tracking Google Sheet
- Append a new row for the week with total revenue, job count, average job value, and each breakdown category
- Update the running year-to-date totals and any rolling four-week trend formulas in the sheet
Done when Last week's revenue is logged in Google Sheets with year-to-date and trend figures updated.
-
3
Slack - post weekly revenue summary to ops channel
slack.com
WebRun opens Slack to post weekly revenue summary to ops channel. - Post a concise revenue summary to your ops or owner Slack channel
- Include total revenue, job count, best-performing crew, and top job type for the week
- Show a simple week-over-week comparison so the trend is immediately visible
Done when Owner has last week's revenue summary with week-over-week comparison in Slack by Monday morning.
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 the report share any data outside the business?
No. The revenue report is posted only to your internal Slack channel and logged to your own Google Sheet. No financial data leaves your accounts or goes to external parties.
Does it include jobs that were invoiced but not yet paid?
By default it reports on payments collected, not invoices issued. You can configure it to show outstanding invoices alongside collected revenue if you want to see both in one view.
Can I see a breakdown by individual crew member performance?
Yes. It breaks down revenue and job count by the crew member assigned in Jobber so you can see each team member's contribution to last week's total.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.