cost-report_skill

Overview

This skill tracks OpenClaw usage costs and produces clear, date- and model-specific reports suitable for Discord and other messaging channels. It parses OpenClaw session logs to extract accurate cost data and offers daily, weekly, and monthly summaries. Reports include totals, model breakdowns, and simple comparisons to prior periods.

How this skill works

The skill reads OpenClaw session JSONL files and uses jq to extract the message.usage.cost.total field for each API call. It aggregates costs by date and model, deduplicates entries so each call is counted once, and formats results into human-friendly summaries for messaging channels. Outputs support today/yesterday, week, month, and custom date ranges.

When to use it

• Monitor daily spending and compare to yesterday.
• Generate weekly summaries for finance or ops reviews.
• Produce monthly reports for budgeting and chargebacks.
• Send cost reports to Discord or team channels automatically.
• Audit model-specific usage and spot cost spikes.

Best practices

• Ensure jq is installed and the script has read access to ~/.openclaw/agents/*/sessions/*.jsonl.
• Run reports from a scheduled job for consistent historical tracking.
• Use custom date ranges to reconcile invoices or unusual billing periods.
• Validate that log rotation or archival policies keep needed session files.
• Compare model-level trends to optimize model selection and limits.

Example use cases

• Daily Discord message showing today's total cost and model breakdown for on-call engineers.
• Weekly cost comparison sent to finance to highlight percentage change vs prior week.
• Monthly export for budget owners that shows month-over-month growth by model.
• Ad-hoc date-range report to investigate a sudden spike in costs from a specific model.
• Archive of historical costs for audit or chargeback purposes.