SCF Deep Analysis — SKILL.md

What This Skill Does

Runs a controller-level Statement of Cash Flows deep analysis for a QBO-connected client. Extends the SCF Quick Compare with:

• - CF Quality Ratio: Operating CF ÷ Net Income (>1.0 = cash-backed quality earnings)
• Free Cash Flow: Operating CF − CapEx (pulled from investing section)
• Working Capital Movement: AR, AP, Inventory, Prepaid — which WC components drove operating CF changes
• 3-Month Rolling Averages: Per-account and per-section CF trend baseline
• GL Drill-Down: Vendor-level transaction detail for every flagged CF account
• Controller Findings: Plain-English narratives with urgency — "Operating CF decreased 15% because AR increased $8K (collections lagging) while AP decreased $4K (paying faster)"
• Action Proposals: Specific, actionable recommendations (HIGH / MEDIUM / LOW urgency)
• CDC: Tracks what changed in CF since last run

Output: Excel workbook with 7 tabs:
INLINECODE0

When To Use

• - Monthly close: controller-level CF review beyond the Quick Compare
• Client with CF concerns (declining operating CF, negative FCF, low CF quality)
• Board prep: need to explain why cash changed this period
• Internal review: identify AR collection problems, AP timing, capex overruns

When NOT To Use

• - Quick period-over-period CF snapshot → use scf-quick-compare.py instead
• P&L variance analysis → use INLINECODE2
• Budget vs. actual → use budget-vs-actual skill
• Non-QBO clients (no integration) → use bank-reconciliation skill

Prerequisites

• - QBO client connected for the slug
• QBO auth token configured
• INLINECODE5 installed: INLINECODE6
• Node.js available on PATH

Script Location

CODEBLOCK0

Usage

CODEBLOCK1

Arguments

*Required unless --ytd is used.

Pipeline Steps (8 Steps)

1. 1. Pull CF — current + prior period CF from QBO via INLINECODE18
2. Pull P&L — current + prior period P&L for Net Income extraction (CF quality ratio)
3. Rolling Averages — pull 3 prior months of CF; compute per-account and per-section averages
4. CDC — compare current flat map vs. INLINECODE19
5. CF Quality + FCF — compute ratio + extract CapEx from investing section
6. Working Capital Movement — classify AR / AP / Inventory / Prepaid from operating section
7. Variance + Flags + GL — flag material variances (≥10% or ≥$2,500); pull GL for flagged accounts
8. Controller Findings — generate narrative findings with urgency and action proposals

Output: Excel Workbook (7 Tabs)

Tab 1: Summary

• - Section totals: Operating / Investing / Financing / Net Change / Beginning / Ending Cash
• vs. prior period + 3-month rolling average
• CF Quality Ratio block (with color coding)
• Free Cash Flow calculation
• Controller Findings summary (top 8 findings, HIGH in red)

Tab 2: Detail

• - Every CF line item with prior period, current period, $ variance, % variance, rolling avg
• Section-grouped with color bands (Operating = blue, Investing = yellow, Financing = purple)
• F/U column (Favorable = more cash, Unfavorable = less cash)

Tab 3: ⚠ Flags

• - Material variances only: ≥10% change OR ≥$2,500 absolute delta
• Includes rolling avg comparison
• Sorted by absolute dollar variance

Tab 4: GL Drill-Down

• - Vendor-level transaction detail for every flagged account
• Top 3 vendor contributors shown in sub-header per account
• Max 50 transactions per account
• Skipped if --skip-gl flag used

Tab 5: Working Capital Movement

• - AR, AP, Inventory, Prepaid, Other WC — current vs. prior vs. delta
• Cash Impact column (Source / Use)
• Plain-English analysis note per component (e.g., "AR increased $8K — collections lagging sales")
• Total WC impact row

Tab 6: Controller Findings

• - Full narrative findings sorted HIGH → MEDIUM → LOW
• Detail / GL attribution per finding
• Specific recommended action per finding
• $ Impact column

Tab 7: CDC Log

• - All accounts/line items that changed vs. last cached run
• Prior value, current value, $ delta, % change, note (New / Changed / Removed)
• Color coded: green = cash increased, red = cash decreased

Cache

CODEBLOCK2

Stored after each run. Contains:

• - flat_map — all CF line items and amounts
• INLINECODE22 — section totals (operating, investing, financing, netchange, endingcash)
• INLINECODE23 — CF quality label
• INLINECODE24 — Free Cash Flow amount
• INLINECODE25 — Net Income for the period
• INLINECODE26 — ISO date of last run

Key Metrics Explained

CF Quality Ratio

Operating CF / Net Income

Free Cash Flow

FCF = Operating CF + CapEx (CapEx is negative outflow, so this subtracts it)

Working Capital Movement (in Operating section)

• - AR change (negative = AR grew = cash used; positive = AR shrank = cash released)
• AP change (positive = AP grew = cash deferred; negative = AP shrank = cash paid out)
• Inventory change (negative = inventory built = cash used; positive = inventory drawn = cash released)
• Prepaid change (negative = more prepaid = cash used; positive = prepaid expensed = cash released)

Materiality Thresholds

• - Percent threshold: ≥10% change in any CF line item
• Absolute threshold: ≥$2,500 absolute variance
• Both thresholds checked — either triggers a flag

Safety Rules

• - Read-only: No writes to QBO — only pulls reports
• All Decimal math: No floating-point for financial calculations
• Disclaimer footer: Controller Findings tab includes audit disclaimer
• Cache separation: Uses .cache/scf-deep-analysis/ — separate from scf-quick-compare cache

Related Pipelines