Advanced Scripting

Most commands support --format=json for easy parsing with jq:

Get transaction count by category:

kick transactions list --format=json | \
  jq 'group_by(.category) | map({category: .[0].category, count: length})'

Find largest transactions:

kick transactions list --format=json | \
  jq 'sort_by(.amount) | reverse | .[0:10]'

Calculate averages:

kick transactions list --format=json | \
  jq 'group_by(.counterparty) | map({counterparty: .[0].counterparty, avg: (map(.amount) | add / length)})'

Environment variables

Set defaults to avoid repeating flags:

export KICK_WORKSPACE="Client Name"
export KICK_ENTITY="ACME Corp"
export KICK_FORMAT="json"

# Commands use these defaults
kick transactions list
kick reports pl --period="2026-01"

Available variables:

• KICK_WORKSPACE — Default workspace

• KICK_ENTITY — Default entity

• KICK_FORMAT — Default output format

Configuration file

Store settings in ~/.kick/config.yaml:

workspace: Client Name
entity: ACME Corp
default_format: json

Commands automatically use these settings unless overridden with flags.

---

Scheduling Scripts

Run scripts automatically with cron (Linux/Mac):

# Edit crontab
crontab -e

# Daily at 9am: Unreconciled transaction alert
0 9 * * * /path/to/daily-recon-alert.sh

# First day of month: Generate monthly reports
0 8 1 * * /path/to/monthly-pl-reports.sh

# Every Monday: Export to warehouse
0 10 * * 1 /path/to/export-to-warehouse.sh

# Every hour: Sync to Google Sheets
0 * * * * /path/to/sync-to-sheets.sh

For Windows, use Task Scheduler.