/fin-weekly-report

name: fin-weekly-report
description: "Weekly financial report — consolidates Stripe, Omie and Evo Academy data for the week: revenue (courses, subscriptions, tickets), expenses, cash flow projection, overdue accounts, and variance analysis. Trigger when user says 'financial weekly', 'weekly financial report', or 'financial summary of the week'."

Financial Weekly — Weekly Financial Report

Weekly routine that consolidates the week's financial data: revenue, expenses, Stripe, Omie, Evo Academy, projected cash flow, and analysis.

**Always respond in English.**

Step 1 — Collect the week's revenue (silently)

1a. Stripe — revenue

Use `/int-stripe` to fetch:

• Succeeded charges for the week (Mon-Sun) → group by type/plan
• Compare with previous week
• Current MRR vs start of week
• New customers vs cancellations
• Payment failures

1b. Omie — revenue

Use `/int-omie` to fetch:

• Confirmed receipts for the week
• Invoices issued during the week

1c. Evo Academy — revenue

Call `GET /api/v1/analytics/summary?period=7d` (env: `$EVO_ACADEMY_BASE_URL`, auth: `Bearer $EVO_ACADEMY_API_KEY`):

• `revenue.total` → receita bruta da semana
• `orders.completed` → número de vendas
• `subscriptions.active` / `subscriptions.cancelled` → net change

Fetch orders da semana: `GET /api/v1/analytics/orders?status=completed&created_after=YYYY-MM-DD&per_page=100`

• Itere por cursor até `has_more=false`
• Some `amount` → receita total Evo Academy na semana
• Separe: renovações vs novos, one-time vs assinatura

Fetch assinaturas novas na semana: `GET /api/v1/analytics/subscriptions?status=active&created_after=YYYY-MM-DD&per_page=100`

• MRR adicionado = soma dos `plan.price` de assinaturas criadas na semana

Group revenue by category:

• Stripe Subscriptions
• Evo Academy — Courses & Subscriptions
• Evo Academy — One-time (tickets, packs)
• Services / Consulting
• Partnerships
• Other

Step 2 — Collect the week's expenses (silently)

2a. Omie — expenses

Use `/int-omie` to fetch:

• Payments made during the week
• Categorize: Personnel, Infrastructure, Services, Marketing, Taxes, Other

2b. Comparison

• Calculate variance vs previous week for each category
• Calculate % of total for each category

Step 3 — Detailed Stripe metrics

Consolidate the week's Stripe metrics:

• MRR and variance
• Total active subscriptions and variance
• Churn rate
• New customers
• Payment failures and at-risk amount

Step 4 — Detailed Omie metrics

Consolidate the week's Omie metrics:

• Overdue receivables (delinquency)
• Next week's payables
• Invoices pending issuance
• Invoices issued during the week
• Confirmed receipts

Step 4.5 — Detailed Evo Academy metrics

Consolidate Evo Academy's week metrics:

• MRR (sum of all active subscription `plan.price`) and variance vs prior week
• New subscriptions vs cancellations
• One-time revenue (tickets, packs, live events)
• Top-selling products of the week
• Students enrolled (`students.new_in_period`)

Step 5 — Cash flow projection (4 weeks)

Based on collected data, project:

• Expected inflows (Stripe recurring + Evo Academy subscriptions + receivables)
• Expected outflows (payables + recurring expenses)
• Balance and cumulative by week

Step 6 — Overdue accounts

List all overdue accounts (receivable and payable):

• Client/Vendor, type, amount, due date, days overdue

Step 7 — Analysis and recommendations

Write a brief analysis (3-5 bullets) covering:

• Revenue trend (growing/stable/declining)
• Out-of-pattern spending
• Delinquency status
• Cash flow (comfortable or tight)

Write recommended actions (bullets):

• Collections to make
• Invoices to issue
• Payments to expedite/postpone
• Any flags for the responsible person or finance team

Step 8 — Classify financial health

Health badge (CSS class):

• **green** "Healthy": revenue > expenses, no significant delinquency, positive cash flow
• **yellow** "Warning": tight margins, or delinquency > R$ 2,000, or projected negative cash flow
• **red** "Risk": expenses > revenue, or delinquency > R$ 10,000, or runway < 3 months

Step 9 — Generate HTML

Read the template at `.claude/templates/html/custom/financial-weekly.html` and replace ALL `{{PLACEHOLDER}}`.

For dynamic revenue/expense tables:

<tr>
  <td>Category Name</td>
  <td class="right">R$ X,XXX.XX</td>
  <td class="right">XX%</td>
  <td class="right var-positive/var-negative">+X% / -X%</td>
</tr>

For cash flow:

<tr>
  <td>Week DD/MM - DD/MM</td>
  <td class="right">R$ X,XXX</td>
  <td class="right">R$ X,XXX</td>
  <td class="right" style="color:var(--green/--red)">R$ X,XXX</td>
  <td class="right">R$ XX,XXX</td>
</tr>

Values in Brazilian format: R$ 1.234,56

Step 10 — Save

Save to:

workspace/finance/reports/weekly/[C] YYYY-WXX-financial-weekly.html

Create the directory `workspace/finance/reports/weekly/` if it does not exist.

Step 11 — Confirm

## Financial Weekly generated

**File:** workspace/finance/reports/weekly/[C] YYYY-WXX-financial-weekly.html
**Revenue:** R$ X,XXX ({var}%) | **Expenses:** R$ X,XXX ({var}%)
**MRR total:** R$ X,XXX (Stripe: R$ X,XXX | Evo Academy: R$ X,XXX) | **Projected 30d balance:** R$ XX,XXX
**Alerts:** {N} overdue accounts | {N} pending invoices