[See what's new in the\
\
Kick Changelog](/content/changelog/index.html)

For the complete documentation index, see [llms.txt](https://docs.kick.co/llms.txt). This page is also available as [Markdown](https://docs.kick.co/ai/cli/cli-use-case-library/data-analysis.md).

## Top expense categories for a quarter

To see where spend concentrated last quarter, pull transactions and group negative amounts by category.

### The Script

```bash
#!/bin/bash
# top-expense-categories.sh

WORKSPACE_ID="<workspace-id>"
SINCE="2026-01-01"
UNTIL="2026-03-31"

echo "Top expense categories: $SINCE to $UNTIL"
echo ""

kick --workspace "$WORKSPACE_ID" transactions find \
  --since "$SINCE" \
  --until "$UNTIL" \
  --fields amount,category \
  --output json | \
jq -r '\
  [.[] | select(.amount < 0)] |\
  group_by(.category) |\
  map({\
    category: (.[0].category // "Uncategorized"),\
    total: (map(.amount) | add),\
    count: length\
  }) |\
  sort_by(.total) |\
  .[] |\
  "\(.category): $\(.total | fabs) (\(.count) transactions)"\
'
```

### How to Customize

- Filter to one entity's activity in Kick before exporting, or narrow dates per client

- Group by counterparty instead: `group_by(.counterparty)`

- Add a percentage of total with an extra `jq` pass

### What It Outputs

```plaintext
Cloud Infrastructure: $12500.00 (36 transactions)
Payroll: $75000.00 (3 transactions)
```

## Cash flow statement by month

To analyze operating, investing, and financing totals by month, use the cash flow statement report instead of rolling up raw transactions.

### The Script

```bash
#!/bin/bash
# cash-flow-by-month.sh

WORKSPACE_ID="<workspace-id>"
ENTITY_ID=123
START_DATE="2026-01-01"
END_DATE="2026-03-31"

ledger_id=$(kick --workspace "$WORKSPACE_ID" accounting ledgers get --entity-id "$ENTITY_ID" --output json | jq -r '.ledgers[0].id')

kick --workspace "$WORKSPACE_ID" reports cash-flow-statement \
  --entity "$ENTITY_ID" \
  --ledger-id "$ledger_id" \
  --start-date "$START_DATE" \
  --end-date "$END_DATE" \
  --cycle month \
  --output json | jq .
```

### How to Customize

- Add `--comparison previous_year` for year-over-year context

- Export vendor-level detail with `kick reports expenses-by-vendor` for the same entity and dates

### What It Outputs

- JSON cash flow statement with monthly columns for the entity and period

[PreviousReconciliation and Cleanup](https://docs.kick.co/ai/cli/cli-use-case-library/reconciliation-and-cleanup) [NextIntegration Scripts](https://docs.kick.co/ai/cli/cli-use-case-library/integration-scripts)

Last updated 10 days ago

Was this helpful?