Monthly Spend Report Template¶
Owner: Ernst (CFO agent). Scope: read-only financial visibility. Envelope: $1,000/month.
Template¶
Reporting period: <YYYY-MM>
Prepared: <YYYY-MM-DD> by Ernst (CFO)
Sources: vendor dashboards, invoices, exports, and vendor-spend.md estimates.
| Vendor | Actual this month | Estimate if actual unavailable | Budget line | Confidence | Delta / anomaly | Source to close |
|---|---|---|---|---|---|---|
<vendor> |
$actual or UNKNOWN |
$estimate |
<line> |
Known / estimate / unknown | <change or risk> |
<dashboard/export owner> |
AI / Agent platform block:
| Vendor | Actual this month | Estimate if actual unavailable | Billing model | Confidence | Delta / anomaly | Source to close |
|---|---|---|---|---|---|---|
| Anthropic (Claude) | UNKNOWN |
UNKNOWN |
Subscription and/or API usage | Unknown | Director + backend AI spend | Anthropic Console Usage/Cost and Billing |
| OpenAI (Codex) | UNKNOWN |
UNKNOWN |
Subscription and/or API usage | Unknown | Primary executor-agent spend | ChatGPT account/workspace billing and OpenAI Platform Organization/Project Usage/Billing |
| Google (Antigravity) | UNKNOWN |
UNKNOWN |
TBD | Unknown | Wired third executor option; usage TBD | Google/Antigravity account and any linked GCP billing |
Running total:
- Dashboard-backed actual total:
$... - Estimate-backed subtotal:
$... - Unknown/unmeasured exposure:
$..., led by AI / Agent platforms until measured. - Remaining envelope:
$1,000 - known/estimated total
Monthly action list:
- Confirm dashboard actuals for every unknown line.
- Explain material deltas from the prior month.
- Flag projected envelope breach risk at $800 and urgent breach at $1,000.
- Record renewal/lapse risks from
renewal-calendar.md. - Record director/CEO actions separately from CFO visibility work.
First Report: June 2026¶
Prepared 2026-06-28. This is a seeded first report, not a closed invoice report. No vendor account login was attempted. Figures marked estimate need dashboard actuals before month-close reliance.
AI / Agent Platforms¶
This is the #1 measurement priority for June. All three AI/agent vendors are currently unmeasured, and total spend is not knowable until this block is filled from billing consoles.
| Vendor | Actual this month | Estimate if actual unavailable | Billing model | Confidence | Delta / anomaly | Source to close |
|---|---|---|---|---|---|---|
| Anthropic (Claude) | UNKNOWN | UNKNOWN | Claude subscription and/or API usage | Unknown | Director/Otto plus backend Claude API spend; previously the only AI line tracked | Anthropic Console -> Usage and Cost CSV for June; Console Settings -> Billing; Director/Claude account owner or Billing/Admin/Developer role |
| OpenAI (Codex) | UNKNOWN | UNKNOWN | ChatGPT/Codex subscription and/or OpenAI API usage | Unknown | Active primary executor-agent spend for Codex-built PRs; was missing from the register before PR-2 | ChatGPT account/workspace billing plus OpenAI Platform -> Organization/Project -> Usage/Billing; OpenAI account/workspace owner |
| Google (Antigravity) | UNKNOWN | UNKNOWN | Billing model TBD; may be $0, unused, preview-tier, subscription, or usage | Unknown | Wired third executor option (agy); actual usage/billing TBD |
Google/Antigravity account for agy OAuth login; any linked GCP Billing account/project; account holder |
Other Vendors¶
| Vendor | Actual this month | Estimate if actual unavailable | Budget line | Confidence | Delta / anomaly | Source to close |
|---|---|---|---|---|---|---|
| Google Cloud | UNKNOWN | $100-160 | Core backend, DB, Redis, Cloud Run, build, artifacts | Estimate from register | Budget exists at $1k; SQL Enterprise edition and personal billing account remain watch items | GCP Billing -> Reports/Transactions for account 018CC1-43D4A6-862538; director billing admin / CEO payment profile |
| Twilio | UNKNOWN | $1-2 | WhatsApp/SMS and US number | Estimate | US number rental plus message pennies; production WhatsApp sender still separate | Twilio Console -> Billing, Usage, Invoices, Active Numbers; CEO/Twilio account owner |
| Apple Developer Program | UNKNOWN | $8.25 amortized ($99/year) | iOS signing/distribution | Public list price; renewal date unknown | Critical path if annual membership expires | Apple Developer account -> Membership details; account holder/CEO |
| AirLabs | $0 per register | $0 | Primary flight-data provider | Known from current decision; quota needs dashboard | Replaced AeroDataBox at no cost | AirLabs dashboard under CEO personal email for Free plan and quota reset |
| api.market / AeroDataBox | $0 per decision | $0 unless re-enabled | Flight-data fallback | Known current decision | Lapsed provider kept fallback-only; not renewed | API.market dashboard only if director chooses to re-enable |
| Cloudflare | UNKNOWN | $0-5 | Worker proxy, Access, email routing/token | Estimate | Confirm Free vs paid Workers resources | Cloudflare Dashboard -> Billing and Workers usage; account owner or delegated billing reader |
| GitHub | UNKNOWN | UNKNOWN | Repo and Actions, especially iOS/macOS builds | Unknown | macOS runner usage can spike; public standard macOS rate is $0.062/min over included quota | GitHub Billing and licensing -> Usage -> Actions minutes/storage |
| Sentry | UNKNOWN | $0 likely | Error tracking/dSYM | Estimate | Confirm no paid trial/upgrade | Sentry Subscription/Billing; org owner or billing admin |
| Expo / EAS | $0 per cancellation | $0 | Retired RN build service | Known from digest | Cancelled 2026-06-28; should stay off books | Optional Expo billing check for post-cancel invoice |
| $0 | $0 | OAuth login | Known no-spend | No paid product in use | LinkedIn Developer Portal | |
| Grafana | Included in GCP | $0 separate | Observability | Known no separate vendor | Self-hosted on Cloud Run, so cost is in GCP | GCP Cloud Run service cost under GCP billing |
June Running Total¶
- Estimate-backed subtotal excluding AI / Agent platforms and GitHub Actions actuals: $109.25-$175.25.
- Formula: GCP
$100-160+ Twilio$1-2+ Apple amortized$8.25+ Cloudflare$0-5. - Known $0/current no-charge lines: AirLabs, AeroDataBox not renewed, Expo/EAS, LinkedIn, Grafana as separate vendor; Sentry is assumed free until dashboard confirms.
- Remaining envelope before unmeasured AI / Agent platforms and GitHub Actions: $824.75-$890.75.
- True June position is not knowable yet because Anthropic, OpenAI/Codex, Google/Antigravity, and GitHub Actions actuals are missing.
- The largest exposure is now the AI / Agent platform category, not just Anthropic.
June Deltas / Anomalies¶
- Flight data cost improved: AirLabs is primary at $0; AeroDataBox was not renewed after the lapse.
- Expo/EAS was cancelled after the native-only pivot, removing a retired build service from the books.
- GCP remains on the CEO personal billing account until incorporation; this is an accepted, deferred billing-entity issue, not a new action to relitigate.
- AI / Agent platform spend is the biggest financial blind spot: Anthropic, OpenAI/Codex, and Google/Antigravity need billing-console exports before June spend can be trusted.
- Apple Developer renewal date is unknown and critical-path.
- GitHub Actions macOS runner minutes need monitoring because iOS device builds can create usage-based charges.
June Action List¶
- Pull GCP month-to-date actuals and forecast from Cloud Billing.
- Pull Anthropic June usage/cost CSV, subscription status, invoices, and spend limits from Claude Console.
- Pull OpenAI/Codex June subscription/API usage, invoices, renewal date, and spend limits from ChatGPT account/workspace billing and OpenAI Platform Organization/Project Usage/Billing.
- Confirm whether Google/Antigravity has active usage or billing, and record the billing model if any.
- Pull GitHub Actions minutes/storage usage for June.
- Confirm Apple Developer Program expiration date and set 60/30/7 day alerts.
- Confirm Cloudflare, Twilio, and Sentry actuals/plan status.
- Replace every
UNKNOWNinrenewal-calendar.mdwith exact dates as dashboard evidence arrives.