Streamtime Automated Project Profitability Report
On the 1st of every month, WebRun opens Streamtime, pulls the budgeted and actual hours logged against every project closed last month, checks what was actually invoiced and paid in QuickBooks, and writes a ranked profitability report to a Google Sheet showing which projects made money and which ran over.
How do I see which design projects are actually profitable?
On the 1st of every month, WebRun pulls budgeted versus actual hours for every project closed last month from Streamtime, checks what was actually invoiced and paid in QuickBooks, and writes a ranked profitability report to a Google Sheet. It never edits either system, it only reads the numbers so you can see which projects made money and which ran over budget.
- See which projects made money and which ran over, without opening two systems by hand
- Hours variance is calculated the same way every month
- Underpriced project types show up in the data before they repeat
Built for design studio owners · web design agencies · creative agency finance · studio operations managers
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
streamtime.netin a real browser with your saved login - no setup, no API keys. -
1
Streamtime - pull budgeted versus actual hours per project
streamtime.net
WebRun opens Streamtime to pull budgeted versus actual hours per project. - Open Streamtime and list every project closed in the last calendar month
- Pull the budgeted hours and the actual hours logged for each
- Calculate the hours variance as a percentage over or under budget
Done when Every project closed last month has its budget versus actual hours listed.
-
2
QuickBooks - check what was actually invoiced and paid
- Look up the total invoiced and total paid amount for each closed project
- Note any invoice still outstanding at month end
- Match the paid amount to the project in Streamtime
Done when Every closed project has its invoiced and paid amount confirmed.
-
3
Google Sheets - write the ranked profitability report
google.com
WebRun opens Google Sheets to write the ranked profitability report. - Write one row per project with budgeted hours, actual hours, and hours variance
- Add the invoiced and paid amount alongside an estimated margin
- Sort the sheet from most to least profitable
Done when Last month's ranked profitability report 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 any numbers in QuickBooks or Streamtime?
No. WebRun only reads hours from Streamtime and invoice data from QuickBooks, it never edits an entry in either. The report is a read-only summary, all source numbers stay exactly as your team entered them.
How is profitability calculated?
It compares budgeted hours to actual hours logged in Streamtime to find the variance, then lines that up against what was actually invoiced and paid in QuickBooks for an estimated margin per project.
What if a project isn't fully paid yet at month end?
It still shows on the report with its invoiced and paid amounts as they stand, and any outstanding balance is noted so a partly paid project isn't mistaken for a loss.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.