Automated ClickUp Time Reconciliation
Every Monday, WebRun opens ClickUp, pulls last week's time entries, matches each one to its task, list, and assignee, checks the entries against your Google Calendar for meetings nobody logged, and drafts you a Gmail summary of billable, non-billable, and unmatched hours.
How do I reconcile tracked time against tasks before invoicing?
Every Monday, WebRun opens ClickUp, pulls last week's time entries, and matches each to its task, list, and assignee. It checks your Google Calendar for client meetings nobody logged, then drafts a Gmail summary of billable, non-billable, and unmatched hours, so the week is invoice-ready before anyone bills.
- Untagged and unmatched hours are caught before the invoice goes out
- Client meetings nobody logged are listed by person and day
- Billable totals per client are ready every Monday morning
Built for agencies · consultancies · practice managers · freelancers who bill hourly
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.clickup.comin a real browser with your saved login - no setup, no API keys. -
1
ClickUp - match time entries to tasks
clickup.com
WebRun opens ClickUp to match time entries to tasks. - Open ClickUp and pull every time entry logged in the previous week
- Group the entries by list, task, and assignee
- Total billable against non-billable hours per client list
- Flag entries with no task attached, no billable tag, or a suspiciously round duration
- Read the entries. Never edit or delete anyone's tracked time
Done when Last week's hours are grouped by client with the problem entries flagged.
-
2
Google Calendar - spot unlogged client time
calendar.google.com
WebRun opens Google Calendar to spot unlogged client time. - Read last week's calendar for client meetings and workshops
- Check each one against the ClickUp entries for the same day and person
- List client time that appears on the calendar but was never tracked
Done when Every client meeting is either matched to a time entry or listed as missing.
-
3
Gmail - draft the pre-invoice summary
gmail.com
WebRun opens Gmail to draft the pre-invoice summary. - Draft an internal summary with billable hours per client, non-billable hours, and the unmatched entries
- List the calendar time nobody logged and who it belongs to
- Leave the email as a draft for you to review. Never send an invoice or write to a client
Done when A pre-invoice summary is drafted and waiting in Gmail.
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
Will it invoice the client?
No. WebRun drafts an internal summary in Gmail and leaves it unsent. It never raises, sends, or edits an invoice, and it never writes to a client. You bill from the reviewed numbers.
Does it change anyone's tracked time?
No. WebRun reads ClickUp time entries and reports on them. Correcting an entry, adding a missing one, or retagging billable time stays with the person who logged it.
What counts as an unmatched entry?
Any time entry with no task attached, no billable or non-billable tag, or a client meeting on your Google Calendar with no matching entry that day. Each one is listed with the person's name.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.