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

BlankWhat to giveExample
payroll urlThe link to your payroll sitehttps://payroll.northpeak.example/runs/next
threshold percentThe smallest pay change to show, in percent5
changes sheetThe Google Sheet with approved hires, leavers and pay changeshttps://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

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 3 blanks

    Type payroll url, threshold percent and changes sheet. Tab moves to the next blank.

  3. 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/mcp

2. 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"
  }
}
All finance templates
  • FinanceAsks 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