Automated Security Weekly Coverage and Billable Hours Report
Every Monday, WebRun opens TrackTik and pulls all completed shifts from the previous week, calculates total hours worked and billable hours by client and site, logs the breakdown to a Google Sheet, and posts a summary to your management Slack channel so leadership can track coverage performance and billable output without touching a spreadsheet.
How do I automatically generate a weekly security coverage and billable hours report?
Every Monday, WebRun pulls the previous week's completed guard shifts from TrackTik, calculates billable hours by client and site, flags any contract shortfalls, logs the breakdown to Google Sheets, and posts a concise coverage summary to your management Slack channel so leadership tracks performance without manual spreadsheet work.
- Management sees last week's billable hours by client every Monday without manual exports
- Contract shortfalls are flagged before they become client disputes
- A running Google Sheet builds a year-to-date coverage and performance record
Built for security operations managers · private security company owners · contract security firms · security billing 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.tracktik.comin a real browser with your saved login - no setup, no API keys. -
1
TrackTik - pull completed shifts and hours from the previous week
tracktik.com
WebRun opens TrackTik to pull completed shifts and hours from the previous week. - Open TrackTik and navigate to the Timesheets or Reports module
- Filter for all completed and approved shifts for the previous calendar week
- For each completed shift, capture: client name, site, officer, shift date, hours worked, and billable status
- Separate billable hours from non-billable or training hours
Done when All completed shifts from the previous week are collected with hours and billable status by client and site.
-
2
Google Sheets - calculate and log billable hours by client and site
google.com
WebRun opens Google Sheets to calculate and log billable hours by client and site. - Open the weekly coverage Google Sheet and add a new tab or rows for the week ending date
- Calculate total hours and billable hours for each client and site
- Flag any client site where actual hours fell short of contracted hours
- Update the year-to-date summary tab with the week's totals
Done when Billable hours are calculated by client and site in Google Sheets with contract shortfalls flagged.
-
3
Slack - post weekly coverage summary to management channel
slack.com
WebRun opens Slack to post weekly coverage summary to management channel. - Post a weekly coverage summary to the management Slack channel
- Include total billable hours, total sites covered, and any contract shortfalls
- Include a link to the Google Sheet for the full breakdown
Done when Management has the weekly coverage and billable hours summary in Slack with contract shortfalls highlighted.
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 send the report to clients automatically?
No. The coverage report is internal, delivered to your management Slack channel and Google Sheet only. Any client-facing reporting is a separate human decision.
How does it know the contracted hours for each site?
It reads the contracted hours from the site or post order records in TrackTik. If contracted hours are not recorded there, you can add them to the Google Sheet template so shortfalls are calculated correctly.
Can it cover multiple billing rates across different clients?
The report pulls hours by client and site as recorded in TrackTik. For billing rate calculations, your team applies the rates in the Google Sheet or in your invoicing system separately.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.