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
What it does
The task
Open the payroll preview for this month on my payroll site payroll url. Compare the gross pay, hours, bonus and deductions of each employee with last month's payroll. List the new employees, the leavers, and the pay changes above threshold percent percent. Compare each change with the approved changes in the Google Sheet changes sheet, and mark each change that is not in it. Do not approve or change the payroll.
- It works in any admin panel and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- As a routine it runs on the 20th of each month at 9:00 (cron
0 9 20 * *).
What you give it
| Blank | What to give | Example |
|---|---|---|
| payroll url | The link to your payroll site | https://payroll.northpeak.example/runs/next |
| threshold percent | The smallest pay change to show, in percent | 5 |
| changes sheet | The Google Sheet with approved hires, leavers and pay changes | https://docs.google.com/spreadsheets/d/1HRChanges |
What you get back
An example run with the example values above. Your run uses your own data.
November payroll preview: 42 employees, gross 238,410 EUR (+3.1%)
New: Sam Ito (start 2 Nov), Marta Silva (start 16 Nov, half month)
Left: Daniel Kerr (last day 31 Oct), not in this payroll
Changes above 5%
- Nadia Haddad: +12% gross, promotion. Approved
- Kofi Mensah: bonus 900 EUR. Approved
- Leo Brandt: +18% gross, 22 overtime hours. Not in the sheet
To check: 1 change that is not approved.
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 payroll url, threshold percent and changes sheet. Tab moves to the next blank.
- 03
Run it, then repeat it
Run sends it once. To run it on the 20th of each month at 9:00, make a routine on cuiar.com/routines or with the CLI below.
As a routine, from the terminal
cuiar routines create "Check payroll changes before it runs" --schedule "0 9 20 * *" --time-zone Europe/Berlin \
"Open the payroll preview for this month on my payroll site https://payroll.northpeak.example/runs/next. Compare the gross pay, hours, bonus and deductions of each employee with last month's payroll. List the new employees, the leavers, and the pay changes above 5 percent. Compare each change with the approved changes in the Google Sheet https://docs.google.com/spreadsheets/d/1HRChanges, and mark each change that is not in it. Do not approve or change the payroll."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 "Check payroll changes before it runs" template with payroll url = https://payroll.northpeak.example/runs/next; threshold percent = 5; changes sheet = https://docs.google.com/spreadsheets/d/1HRChanges.Setup for other agents: AI agents.
The tool call
{
"name": "create_routine",
"arguments": {
"name": "Check payroll changes before it runs",
"task": "Open the payroll preview for this month on my payroll site https://payroll.northpeak.example/runs/next. Compare the gross pay, hours, bonus and deductions of each employee with last month's payroll. List the new employees, the leavers, and the pay changes above 5 percent. Compare each change with the approved changes in the Google Sheet https://docs.google.com/spreadsheets/d/1HRChanges, and mark each change that is not in it. Do not approve or change the payroll.",
"schedule": "0 9 20 * *",
"time_zone": "Europe/Berlin"
}
}Related templates
All finance templatesFinanceAsks first
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- Google Sheets
- Xero
Finance
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 numbers for your investor update
Revenue, growth, burn, runway and customer count for the month, each with its source.
On a schedule: On the 3rd of each month at 9:00- Stripe
- Any bank site
- Google Sheets
Finance
Find card payments that have no receipt
Each card payment matched to a receipt from your inbox or folder, with the missing ones listed first.
You start it: When you start it- Any bank site
- Gmail
- Google Drive
- +1 more: Google Sheets
Finance
Match Stripe payouts to your bank deposits
Each payout matched to a deposit, with fees and refunds, and the payouts that did not arrive.
You start it: When you start it- Stripe
- Any bank site
- 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