/company-cfo — Monthly company CFO workflow
The standing analysis leadership uses to make distribution / cuts / hiring / runway decisions. Primary cadence is monthly (run on the 1st for the closed prior month). Weekly and scenario modes cover the in-between.
Anonymized team-scope sibling to
(households). Same discipline (transaction-sum EOM, categorization traps, scenario modeling) applied to company books.
Step 0 — Load company config + prior run
Before starting work, read these in order:
${COMPANY_CFO_ROOT:-$HOME/code/company-cfo}/CLAUDE.md
— your company's specific methodology, data source map, categorization rules, distribution mechanics. This is the source of truth for HOW your company computes things. Don't invent your own methodology.
- The most recent report in
${COMPANY_CFO_ROOT}/reports/monthly/
— last month's snapshot. Tells you what leadership decided + what was open.
- The most recent in that folder (if one exists) — supplementary decisions, scenario analysis.
- Any relevant memory notes in — running context: known anomalies, leadership constraints, current churn state.
- in — what's shipped since the last run.
If the
dir doesn't exist yet: first-run walkthrough asks the user to
it, seed a
from
references/company-config-template.md
, and set the env var.
Step 1 — Parse mode
| Invocation | Mode | Cadence |
|---|
| (default) | monthly | Once per month on the 1st for the closed prior month |
| weekly | Thin cash pulse — current cash + next 2 weeks of expected flows |
/company-cfo scenario <question>
| scenario | Ad-hoc modeling in the projector |
| pickup | Resume where the prior run left off (checks git log + last report + open items) |
Below sections walk through monthly in detail. Weekly + scenario are summarized at the end.
Monthly workflow
Ask the user: Which month are we reporting on? (Default: prior calendar month.)
Then walk through these phases. Pause and confirm before moving to the next.
Phase 1 — Pull raw data
For the target month, pull raw data from each source. Standard source categories (each company's actual tools live in their
):
| Source category | What it gives | Common tools |
|---|
| Bank / cash accounts | Cash truth, internal vs external transfers, distribution recipients | Mercury CLI, Plaid, direct bank export |
| Payment processor | Revenue, subscriptions, churn, payout timing | Stripe API, Paddle, LemonSqueezy |
| Payroll / contractors | W-2 payroll, contractor pay | Plane, Deel, Gusto, Rippling |
| Expense management | Reimbursements, corporate cards | Ramp, Brex, Divvy |
| Alternative revenue | Non-primary billing sources | Direct invoice tools, alternative payment platforms |
Save all pulls to
${COMPANY_CFO_ROOT}/data/YYYY-MM/<source>-*.json[l]
(gitignored — raw data doesn't get committed).
Also pull the current cash balance from the bank source for the "today" starting-cash figure.
If a source isn't wired yet: use
to wire it up before running the CFO workflow. First-time integration is a one-time cost.
Phase 2 — Categorize and reconcile
Bucket all cash-account outflows into the categories your company uses. See
references/categorization.md
for a starter category set and the discipline of maintaining categorization.
Universal traps to check (see
for full list):
- Cash-vs-credit double-count — if the bank shows a "credit card autopay" outflow AND the credit card account shows individual charges, don't count both. Filter to cash accounts only OR treat the CC as a debt account.
- Internal transfers — Checking ↔ Savings transfers net to zero. Exclude them (usually via a filter or account-pair match).
- Currency mismatches — contractor payment tools often return in the worker's payout currency. Always use (or equivalent) for USD/base-currency cost analysis.
- Distribution counting — if leadership has N partners who should get a monthly distribution, verify N distributions exist. If N-1, flag the missing partner — often one is deferring their draw to balance cash.
Cross-checks before writing the report:
- Total payroll debits in bank ≈ payroll-tool API total + fees (within a small residual for held deductions)
- Payment processor payouts arriving in the month ≈ bank inflows from that processor (within timing lag)
- Expense-management outflows in bank ≈ approved expenses in expense-mgmt tool (with cash-basis lag)
Phase 3 — Compute EOM cash (the transaction-sum method)
Use transaction sums, not the walkback-from-current-balance method. Walkback has bitten CFO workflows repeatedly — a bank API balance snapshot at pull time can be off by tens of thousands, and that error propagates into every historical EOM value.
Correct method (see
references/eom-cash-methodology.md
for the full recipe):
python
# 1. Pull ALL transactions for each cash account (Checking + Savings + any other cash-holding):
# <bank-tool> transactions list --account-id <id> --format jsonl --max-items 100000
# 2. Sum the amount field across all transactions in each account.
# 3. The sum should equal that account's CURRENT available_balance exactly.
# (Sanity check — if not, missing data or a pre-history baseline deposit exists.)
# 4. For any past date T: balance_at_T = sum of all transactions posted on or before T
# (plus any pre-history baseline, which should be ~$0 if the sanity check passes).
Cross-check EOM: last month's EOM + this month's net cash change should equal this month's EOM, to the dollar.
If transaction sums don't reconcile with current balance, do not proceed with walkback as fallback. Investigate the gap first — missing pulls (timeout, paging), an unknown account, or a legitimate pre-history baseline.
Phase 4 — Update the scenario projector
Most CFO workflows benefit from a scenario projector — an interactive forecast that projects EOM cash forward N months under adjustable assumptions (revenue growth, expense scenarios, hiring plans, distribution changes).
Common structure (see
references/scenario-projector.md
for the reference implementation):
- HISTORICAL (trailing 3 closed months) — provides context before TODAY
- TODAY — actual current cash balance (calendar-positioned within current month)
- Mo 1 — current calendar month EOM (partial — remaining-month activity)
- Mo 2-7 — next 6 full calendar month EOMs (scenario settings apply from here)
Each month:
starting + revenue − expenses = profit → ending
Intramonth cycle low (for weekly cash pulse relevance): most CFO systems care about the
low point of the month (when you might hit a cash floor), not just the high (EOM). Formula depends on payout cadence — see
references/scenario-projector.md
.
Update the projector each monthly run:
- Append the just-closed month to HISTORICAL with all category fields; drop the oldest.
- Update to today's actual bank balance.
- Update expense baselines for any category that materially shifted.
- Update (net of processing fees).
- Verify presets still make sense (scenarios may need updating if comp structure or hiring plans changed).
Phase 5 — Write the snapshot report
Create
${COMPANY_CFO_ROOT}/reports/monthly/YYYY-MM.md
following the template in
references/report-template.md
. Sections (adapt as needed):
- TL;DR — headline + status table (net cash, ending balance, current MRR, trailing-N-month, recommendation)
- Cash In — by source (payment processor, alt revenue, one-times)
- Cash Out — by category (matches the projector's category structure)
- Payroll breakdown — verified contractor + W-2 split
- Distributions — who got paid, who didn't (flag anomalies)
- Revenue metrics — active subs, MRR delta, recent cancels with $ and customer
- Forward projection — 1-3 scenarios from the projector (link the projector state)
- Recommended actions — concrete for leadership to decide on
- Open items — questions to resolve next month
Write the why-paragraph in plain English: what happened and why. Reference the previous month if there's continuity ("Vendor X churn from last month finished hitting June payouts").
Phase 6 — Update memory
Update
~/.claude/memory/company_cfo_<company-slug>.md
(or wherever your memory system lives) if any of:
- Distribution/comp structure changed
- Active sub count or MRR shifted materially
- New revenue stream (new billing platform)
- New partner / contractor decision
- New cash floor or distribution constraint
Don't bloat the note. Replace stale facts; don't append indefinitely.
Phase 7 — Review and ship
Follow your company's git workflow:
Before the first-ever run, verify
at the repo root excludes raw exports — Phase 1 dumps sensitive bank / payroll / payment-processor data to
and that MUST NOT be committed. If missing, seed it:
bash
cd ${COMPANY_CFO_ROOT}
# Verify .gitignore excludes raw data + secrets
if ! grep -q '^data/' .gitignore 2>/dev/null; then
cat >> .gitignore <<'GITIGNORE'
# Raw financial data — never commit
data/
*.jsonl
*.env
*.env.local
.mcp.json
GITIGNORE
git add .gitignore
git commit -m "Seed .gitignore for raw financial data"
fi
Then ship the report + projector changes ONLY (never
in this repo — targeted adds only, so a stray
file can't slip in):
bash
cd ${COMPANY_CFO_ROOT}
git checkout -b feature/YYYY-MM-snapshot
git add reports/monthly/YYYY-MM.md scenarios/index.html CLAUDE.md # targeted
git status --short # verify no data/ or .env files staged
git commit -m "YYYY-MM monthly snapshot"
git push -u origin feature/YYYY-MM-snapshot
gh pr create --base main --title "YYYY-MM monthly snapshot"
Never in . A silent
file leak would push bank transaction history + partner distribution ACHs to a git remote. Targeted adds only.
Before merging: run a code review (if applicable) or manually review the diff. Then merge + delete branch.
Weekly cash pulse mode
Thin — designed to fit into a 15-minute weekly sync.
- Pull current cash balance (bank API )
- Pull last 7 days of transactions + next 7 days of scheduled outflows (payroll, known bills)
- Compute: current cash, next-payroll date + amount, next-Stripe-payout date + amount
- Flag if cash < next 2 weeks of outflows (below cash floor)
- One-line status:
Cash $X | Next payroll $Y on <date> | Next inflow $Z on <date> | Floor status: OK|WATCH|BREACH
Save to
${COMPANY_CFO_ROOT}/reports/weekly/YYYY-WW.md
.
Pair with
to schedule the weekly run (typically Monday 9am).
Scenario mode
Ad-hoc — for "what if we hire a $150K/yr engineer in September" or "what if churn ticks up 2%".
Open the scenario projector, adjust the relevant knobs, screenshot or export the resulting cash projection. Save the analysis to
${COMPANY_CFO_ROOT}/reports/scenarios/YYYY-MM-DD-<question-slug>.md
.
If the scenario decision is material (new hire, distribution change, big expense), also run
to formalize.
Pickup mode
Resume from the prior run. Surface:
- Most recent monthly report (
ls -t ${COMPANY_CFO_ROOT}/reports/monthly/*.md | head -1
)
- Most recent weekly pulse
- Latest on (what's shipped since last snapshot)
- Memory note for current narrative
- Open items from the last report's §9
Don't assume continuity from training data. Always check the reports + memory + git log first.
Composes with
- — sibling. Personal-cfo handles household finances (house math, monthly cash flow, big purchases). Same discipline (transaction-sum method, scenario modeling) applied to different scope.
- — the CFO reports get stored + wiki-indexed there. in the company brain accumulates monthly reports; wiki pages compile trends across months.
- — wire company-specific data sources (Mercury API, Stripe, Plane, Ramp, or equivalents). First-run integration setup.
- — schedule the monthly run (1st of month) + weekly cash pulse (Monday 9am).
- — for material decisions surfaced by the report (distribution changes, hiring, cash floor breach response). Formalize with the 37signals framework.
- — for benchmark questions ("what's a typical SaaS marketing budget as % of ARR?") that inform scenario inputs.
Notes on quality
- Never invent methodology. Every company computes cash differently — trust the company's in . If it's not documented, ask; don't guess.
- Transaction-sum method is non-negotiable. Walkback from a balance snapshot has burned CFO workflows repeatedly. Use raw transaction sums, verify against current balance.
- Categorization discipline matters more than accuracy. Same categories every month = trend-readable. Changing categories mid-year = trends become noise.
- Baseline expenses to actuals, not to "safe" estimates. A software line modeled at $8K when actuals run $12K creates optimistic projections that break the model.
- Revenue is net of processing fees, not gross. ~3% Stripe/similar processor fees materially change monthly cash inflow.
- The intramonth cycle low matters more than EOM. With monthly payout cadences, cash dips deep mid-month. Cash floor applies to the LOW, not the EOM HIGH.
- Weekly payouts smooth the cycle dramatically — if your payment processor supports it, switching from monthly to weekly payouts is one of the highest-leverage cash-management moves available. See
references/eom-cash-methodology.md
.
- When numbers don't reconcile, stop. Don't ship a report with unexplained gaps. Investigate first — a $42K reconciliation gap once propagated silently for weeks before being caught.
When NOT to use this skill
- Ad-hoc single-number lookups ("what's our current cash?") — just query the bank source directly, don't run the full workflow.
- Tax / accounting questions — out of scope; refer to your CPA.
- Personal finance — use instead.
- Investor pitch financials — different discipline (multi-year projections, unit economics deep dives). This skill covers operational CFO cadence, not fundraising narrative.