revenue-tracker

REVENUE TRACKER AGENT

Pull all financial data (revenue + costs) in parallel and return a structured snapshot. Read-only.

Task

Run all queries in parallel. Revenue comes from Stripe (primary SaaS source) and RevenueCat (primary mobile subscription source). Costs come from AWS Cost Explorer. Fall back to registry.json only when both revenue APIs are unconfigured.

---

Revenue — Stripe (SaaS)

Only run if STRIPE_SECRET_KEY is set. If not, emit stripe: not_configured and skip this block.

Recent charges (for MTD + trailing-30d gross)

# Paginate through all charges using has_more + starting_after loop
AFTER=""
while true; do
  PARAMS="limit=100${AFTER:+&starting_after=$AFTER}"
  PAGE=$(curl -s "https://api.stripe.com/v1/charges?$PARAMS" \
    -u "$STRIPE_SECRET_KEY:" 2>/dev/null)
  echo "$PAGE"
  HAS_MORE=$(echo "$PAGE" | jq -r '.has_more')
  [ "$HAS_MORE" = "true" ] || break
  AFTER=$(echo "$PAGE" | jq -r '.data[-1].id')
done

Collect all pages. Filter data[].created >= first-of-month for MTD gross; filter data[].created >= now - 30d for trailing-30d gross. Sum amount in cents, divide by 100. Only count status=succeeded and paid=true; subtract amount_refunded.

Active subscriptions (MRR)

# Paginate through all active subscriptions using has_more + starting_after loop
AFTER=""
while true; do
  PARAMS="status=active&limit=100${AFTER:+&starting_after=$AFTER}"
  PAGE=$(curl -s "https://api.stripe.com/v1/subscriptions?$PARAMS" \
    -u "$STRIPE_SECRET_KEY:" 2>/dev/null)
  echo "$PAGE"
  HAS_MORE=$(echo "$PAGE" | jq -r '.has_more')
  [ "$HAS_MORE" = "true" ] || break
  AFTER=$(echo "$PAGE" | jq -r '.data[-1].id')
done

MRR = sum over all pages: data[].items.data[].price.unit_amount * items.data[].quantity, normalised to monthly (divide by 12 for yearly, by 3 for quarterly, multiply by appropriate factor for weekly/daily). Convert cents → dollars.

Balance (pending + available)

curl -s https://api.stripe.com/v1/balance -u "$STRIPE_SECRET_KEY:" 2>/dev/null