Invoice prep for billable hours
At the end of each billing period, an agent turns approved time entries into draft invoices with clear line items, checks them against rates and retainer terms, and queues them for the billing lead to approve.
The use case
Turning hours into invoices is a monthly chore at agencies and firms: export time, group it by client and project, apply the right rates, account for retainers and caps, and write line items a client will understand. Mistakes delay payment and damage trust. This agent reads approved time entries from Harvest or Toggl, applies the rates and terms recorded for each client, and groups entries into clear line items. It checks against retainer balances, not-to-exceed caps, and any write-offs the project lead has noted, and flags anything that does not add up. It creates draft invoices in QuickBooks Online or Harvest but never sends them. The billing lead reviews each draft, confirms rates and adjustments with the project lead, and sends the invoices.
Example workflow
- After the time-entry cleanup is complete, the agent pulls approved billable entries for the period from Harvest or Toggl.
- It reads each client's rates, retainer terms, caps, and noted write-offs from the billing sheet.
- It groups entries into clear line items by project and role and calculates totals using the recorded rates.
- It flags invoices that exceed a cap, use a rate that differs from the sheet, or include entries on closed projects.
- It creates draft invoices in QuickBooks Online or Harvest with a summary of each flag for the billing lead.
- The billing lead reviews each draft, confirms any adjustments with the project lead, and sends approved invoices.
Tools
- Harvest
- Toggl Track
- QuickBooks Online
- Google Sheets
- Claude
- Zapier or Make
Risks and guardrails
- A wrong rate or missed cap could overbill a client — guardrail: every draft lists rates used and cap checks, and the billing lead approves each invoice.
- Retainer balances could be applied incorrectly — guardrail: the agent shows the starting and ending retainer balance on each draft for review.
- Invoices could go out before review — guardrail: the agent creates drafts only and cannot send or finalize invoices.
- Line item wording could reveal internal notes — guardrail: line items use the cleaned descriptions, and the billing lead checks wording before sending.
Related recipe
B2B Invoice AR Reminder Agent with Approval Gate: An agent reads open invoices from QuickBooks or Xero, skips blocked accounts, and drafts tiered payment reminders in Gmail that a person approves one by one before anything is sent.
Want it set up for you? Request a quote.
Sources
Written by Agents Lookup. Credits and official pages for the tools this use case names:
- QuickBooks Online MCP server (official page): github.com/intuit/quickbooks-online-mcp-server (checked 2026-11-09)
- Claude (official page): claude.ai (checked 2026-11-09)
- Zapier MCP (official page): zapier.com/mcp (checked 2026-11-09)
- Make MCP server (official page): developers.make.com/mcp-server (checked 2026-11-09)