All templates

Automated ZipBooks Billable Hours Scorecard

Every week, WebRun totals tracked hours in ZipBooks against what's actually been invoiced, creates a Trello card for unbilled time, and messages you the scorecard on WhatsApp.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 ZipBooks total this week's tracked hours against what's been invoiced
2 Trello create a Trello card for unbilled time
3 WhatsApp message you on WhatsApp
In short

How do I catch unbilled tracked hours in ZipBooks every week?

WebRun totals last week's ZipBooks tracked billable hours by client every Monday, compares them against what's actually been invoiced, and messages you a WhatsApp scorecard with the gap. Any client with unbilled tracked time gets a Trello card assigned to whoever prepares invoices, so billable hours stop quietly going uninvoiced.

  • Unbilled tracked hours get caught weekly instead of at year end
  • Each client with a gap gets an assigned Trello card
  • The scorecard shows the exact gap between tracked and invoiced time

Built for freelancers · consultants · small agencies · service businesses

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.zipbooks.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    ZipBooks - total this week's tracked hours against what's been invoiced
    zipbooks.com
    WebRun in ZipBooks: total this week's tracked hours against what's been invoiced
    WebRun opens ZipBooks to total this week's tracked hours against what's been invoiced.
    • Open ZipBooks and total last week's tracked billable hours by client
    • Check how many of those hours have been included on an invoice
    • Flag any client with tracked hours not yet invoiced

    Done when Last week's tracked hours are totaled and compared against invoiced hours.

  3. 2
    Trello - create a Trello card for unbilled time
    trello.com
    WebRun in Trello: create a Trello card for unbilled time
    WebRun opens Trello to create a Trello card for unbilled time.
    • Create a card for each client with unbilled tracked hours
    • Include the client and the number of hours not yet invoiced
    • Assign the card to whoever prepares invoices

    Done when Every client with unbilled hours has an assigned Trello card.

  4. 3
    WhatsApp - message you on WhatsApp
    whatsapp.com
    WebRun in WhatsApp: message you on WhatsApp
    WebRun opens WhatsApp to message you on WhatsApp.
    • Message you the total tracked hours, total invoiced, and the gap
    • Name the client with the most unbilled hours
    • Keep the message short

    Done when You have this week's billable hours scorecard on WhatsApp.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.zipbooks.com
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Billable hours scorecard · WhatsApp
OutputWhat each run produces - A weekly WhatsApp scorecard of tracked versus invoiced hours, with a Trello card for each client with unbilled time.
Scorecard + task
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it create the invoice for the unbilled hours?

No. It only flags which clients have unbilled tracked time and hands it off as a Trello card. Creating and sending the invoice is still done inside ZipBooks.

How does it know hours are unbilled?

It compares tracked time entries in ZipBooks against what's already appeared on a sent invoice for that client.

What if all hours are already invoiced?

Then no Trello card is created and the WhatsApp scorecard simply shows a zero gap for the week.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.