Automated QuickBooks Time Weekly Hours Scorecard
Every Monday, WebRun opens QuickBooks Time, pulls last week's tracked hours by project and employee, saves a report to Google Drive, and posts a scorecard to Slack highlighting which projects ran over budgeted hours.
How do I get a weekly QuickBooks Time hours scorecard by project?
WebRun pulls last week's tracked hours by project and employee from QuickBooks Time every Monday, saves the report to Google Drive, and posts a scorecard to Slack leading with any project that ran over its budgeted hours. The team starts the week with a clear read on where time actually went, without pulling the report by hand.
- Project overages get flagged the same week they happen
- A weekly hours report builds up automatically in Drive
- Teams start the week already knowing where time went
Built for Project managers · operations managers · field service businesses · agencies
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
qbtime.comin a real browser with your saved login - no setup, no API keys. -
1
QuickBooks Time - pull last week's tracked hours
qbtime.com
WebRun opens QuickBooks Time to pull last week's tracked hours. - Open QuickBooks Time and pull last week's timesheets
- Total hours by project and by employee
- Flag any project over its budgeted hours
Done when Last week's hours are totaled by project and employee.
-
2
Google Drive - save the hours report
drive.google.com
WebRun opens Google Drive to save the hours report. - Save the hours report to the weekly reporting folder
- List totals by project with any flagged overage
- Keep prior weeks for comparison
Done when This week's hours report is saved in Drive.
-
3
Slack - post the weekly scorecard
slack.com
WebRun opens Slack to post the weekly scorecard. - Post the scorecard to the project management channel
- Lead with any project over budgeted hours
- Include total hours logged for the week
Done when The team has this week's hours scorecard 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
Does it edit or approve timesheets?
No. WebRun only reads and reports tracked hours. Editing an entry or approving a timesheet stays with your team in QuickBooks Time.
What counts as over budget?
Whatever hours budget you set per project. Any project over it is listed first in the Slack scorecard.
Does it single out individual employees?
The scorecard reports totals by project and by employee, using the same hours data already visible in QuickBooks Time, nothing beyond what your team already tracks.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.