Create client invoices from your tracked hours
One draft invoice per client from your hours sheet, with rates and dates, sent after you approve it.
- On a schedule: On the 1st of each month at 10:00
- Asks you first
What it does
The task
Read last month's hours in the Google Sheet hours sheet. Add up the billable hours per client and per project, and multiply them by the rates in the tab rates tab. In Xero, create one draft invoice per client with one line per project, the hours, the rate and the period. Use the payment terms terms. Ask me before you approve and send each invoice.
- It works in Google Sheets and Xero, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- As a routine it runs on the 1st of each month at 10:00 (cron
0 10 1 * *). - It stops for your approval before it sends, posts, pays, books or changes a record.
What you give it
| Blank | What to give | Example |
|---|---|---|
| hours sheet | The Google Sheet where you track hours | https://docs.google.com/spreadsheets/d/1Hours2026 |
| rates tab | The tab with the rate for each client or project | Rates |
| terms | Your payment terms | 30 days |
What you get back
An example run with the example values above. Your run uses your own data.
October 2026: 4 draft invoices, 18,940.00 EUR
| Client | Projects | Hours | Total |
|---|---|---|---|
| Halden Group | Atlas migration, Support | 62.5 | 9,375.00 EUR |
| Kestrel Data | Dashboard redesign | 38.0 | 5,320.00 EUR |
| Brightleaf | Workshop | 12.0 | 1,920.00 EUR |
| Northpeak | Advisory | 15.0 | 2,325.00 EUR |
Terms: 30 days, due 30 Nov 2026
Waiting for your approval to send 4 invoices.
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in 3 blanks
Type hours sheet, rates tab and terms. Tab moves to the next blank.
- 03
Run it, then repeat it
Run sends it once. To run it on the 1st of each month at 10:00, make a routine on cuiar.com/routines or with the CLI below.
As a routine, from the terminal
cuiar routines create "Create client invoices from your tracked hours" --schedule "0 10 1 * *" --time-zone Europe/Berlin \
"Read last month's hours in the Google Sheet https://docs.google.com/spreadsheets/d/1Hours2026. Add up the billable hours per client and per project, and multiply them by the rates in the tab Rates. In Xero, create one draft invoice per client with one line per project, the hours, the rate and the period. Use the payment terms 30 days. Ask me before you approve and send each invoice."Run it from your AI agent
Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call create_routine yourself.
1. Add Cuiar to Claude Code
claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp2. Ask your agent
Use the Cuiar tool create_routine to run my "Create client invoices from your tracked hours" template with hours sheet = https://docs.google.com/spreadsheets/d/1Hours2026; rates tab = Rates; terms = 30 days.Setup for other agents: AI agents.
The tool call
{
"name": "create_routine",
"arguments": {
"name": "Create client invoices from your tracked hours",
"task": "Read last month's hours in the Google Sheet https://docs.google.com/spreadsheets/d/1Hours2026. Add up the billable hours per client and per project, and multiply them by the rates in the tab Rates. In Xero, create one draft invoice per client with one line per project, the hours, the rate and the period. Use the payment terms 30 days. Ask me before you approve and send each invoice.",
"schedule": "0 10 1 * *",
"time_zone": "Europe/Berlin"
}
}Related templates
All finance templatesFinance
Compare your budget with actual spending
Budget against actual for each account, the largest differences first, with the transactions behind them.
On a schedule: On the 5th of each month at 9:00- Xero
- Google Sheets
Finance
Prepare the figures for your VAT return
Sales and input VAT by rate for the period, checked against your sales platforms, with the box values.
You start it: When you start it- Xero
- Shopify
- Stripe
- +1 more: Google Sheets
Finance
Build a 13-week cash flow forecast
Weekly cash in and out from your bank, open invoices and bills, with the weeks below your minimum marked.
You start it: When you start it- Any bank site
- Xero
- Google Sheets
Finance
Check supplier invoices against purchase orders
Each invoice matched to its PO and delivery note, with price, quantity and duplicate problems marked.
You start it: When you start it- Google Drive
- Google Sheets
- Xero
FinanceAsks first
Pay approved supplier bills from your bank
A payment for each bill due this week, checked against your records, sent only after you approve it.
On a schedule: Every Thursday at 10:00- Xero
- Any bank site
Finance
Check payroll changes before it runs
Each change against last month, with new staff, leavers, pay changes and bonuses, and the ones not approved.
On a schedule: On the 20th of each month at 9:00- Any admin panel
- Google Sheets