İç Ekiplere ve Kurumsal Müşterilere Chargeback Raporlama: PDF, CSV, Invoice Generation

Raporun Kime Gittiği Önemli#

CFO için Aylık PDF Raporu#

Sayfa 1: Özet#

• Aylık total cost
• M-o-M değişim
• Y-o-Y değişim
• Hedefin (varsa) yüzdesi

Sayfa 2: Provider breakdown#

• OpenAI: $X
• Anthropic: $Y
• Gemini: $Z
• Self-hosted: $W

Sayfa 3: Top 10 features#

• Smart Search: $4.200
• AI Summary: $3.100
• Agent Workflow: $2.700
• ...

Sayfa 4: Trends & alerts#

• Cache hit ratio trend
• Anormal artışlar (>%30 günlük)
• Budget aşımları

PDF üretimi#

from weasyprint import HTML
from jinja2 import Template

def generate_monthly_report(month: str, data: dict):
    template = Template(open("templates/monthly.html").read())
    html_content = template.render(month=month, data=data)
    HTML(string=html_content).write_pdf(f"reports/{month}-llm-cost.pdf")

Engineering için Slack Weekly Digest#

🤖 Haftalık LLM Cost Digest (Hafta 18, 2026)

💰 Toplam harcama: $4.230 (-%8 önceki haftaya göre ✅)

🏆 Top 5 features:
  1. Smart Search        $1.100
  2. AI Summary           $890
  3. Agent Workflow       $620
  4. Code Assistant       $450
  5. Email Draft          $310

⚠️ Bu hafta dikkat:
  • Smart Search'te cache hit oranı %72 → %58 düştü (anomali)
  • o3 thinking token kullanımı %40 arttı (planlandı mı?)

📊 Detaylı dashboard: [link]

Slack post otomasyonu#

from slack_sdk import WebClient

def post_weekly_digest():
    data = fetch_weekly_metrics()
    blocks = build_slack_blocks(data)
    client = WebClient(token=SLACK_BOT_TOKEN)
    client.chat_postMessage(
        channel="#ai-cost-watch",
        blocks=blocks,
    )

# Cron: Her Pazartesi 09:00 TR saati

Kurumsal Müşteri Invoice'u#

Invoice yapısı#

ACME CORP — AI Usage Invoice
Period: 2026-04-01 to 2026-04-30
Invoice #: AI-2026-04-ACME

──────────────────────────────────────────
LINE ITEMS:
──────────────────────────────────────────

Smart Search Feature
  Requests:  142,300
  Total tokens: 12.4M
  Unit price (per 1K tokens): $0.008
  Subtotal: $99.20

AI Summary Feature
  Requests: 8,200
  Total tokens: 5.1M
  Unit price: $0.012
  Subtotal: $61.20

Agent Workflow
  Sessions: 1,420
  Total tokens: 18.6M
  Unit price: $0.020
  Subtotal: $372.00

──────────────────────────────────────────
SUBTOTAL: $532.40
KDV (20%): $106.48
TOTAL: $638.88
──────────────────────────────────────────

Note: Pricing based on actual token usage with
20% margin over our wholesale LLM cost.

Pricing modeli#

Auditor için CSV Export#

SELECT
    ts,
    request_id,
    tenant_id,
    user_id,
    feature,
    model,
    provider,
    input_tokens,
    cached_input_tokens,
    output_tokens,
    cost_total_usd,
    latency_ms,
    status_code
FROM llm_telemetry.requests
WHERE
    tenant_id = '{tenant_id}'
    AND ts BETWEEN '{start}' AND '{end}'
ORDER BY ts
INTO OUTFILE '/exports/audit-{tenant}-{month}.csv'
FORMAT CSVWithNames

Audit-friendly fields#

• request_id (idempotency)
• timestamp (exact)
• user_id + tenant_id (attribution)
• model + provider (reproducibility)
• token breakdown (verifiability)
• cost (financial)
• status (compliance)

Privacy considerations#

Automation Stack — Tam Otomasyon#

[ClickHouse] ── Daily cron ──→ [Aggregation views]
                                       ↓
                              [Report generator]
                                       ↓
                ┌──────────────────────┼──────────────────────┐
                ↓                       ↓                       ↓
       [Slack digest]            [PDF generator]       [Invoice creator]
        (weekly)                  (monthly)             (monthly)
                                       ↓                       ↓
                                  [S3 archive]           [Stripe API]
                                       ↓                       ↓
                                  [Email sender]         [Customer email]

Cron schedules#