Finance Ops — CFO Briefing Engine

What it does

Finance Ops reads QuickBooks exports (P&L Summary, P&L by Customer, Balance Sheet, General Ledger, Expenses by Vendor, Cash Flow Statement) and produces a single CFO-grade executive briefing. It auto-detects file types by scanning headers, parses each into structured data, and computes a full KPI set benchmarked against healthy ranges:

• Profitability: revenue, COGS, gross margin (SaaS healthy band 75–90%), net income/loss.
• Cash & runway: net burn and runway = cash ÷ net burn. The 2026 norm is an 18–24 month prudent buffer; below 12 months is "fundraising mode."
• Liquidity: current ratio (healthy 1.5–3.0) and quick ratio (1.0–2.0).
• Collections: DSO (under 35 days excellent on Net 30, over 45 warrants investigation).
• Concentration & anomalies: top-client revenue share, vendor spikes, out-of-period items.

It loads the prior period from a history/ directory to compute month-over-month variance, maps each metric to a 🟢/🟡/🔴 threshold, and rolls them into a single health score. It then runs a scenario-modeler for 12-month base / bull / bear projections (base: current trajectory; bull: new product revenue + new clients; bear: lose top clients). Output is an emoji-coded briefing suitable for Slack or email.

The second tool, Codebase Cost Estimator, estimates a codebase's development cost via hours → calendar time → full-team cost, and computes AI ROI from git-history clustering when the code was AI-assisted.

When to use it

After month-end close (typically the 10th–15th of the following month) to produce the monthly financial pulse for the board or investors; when you need a fast read on whether runway is tightening, burn is efficient, or a client/vendor risk is growing; or to present a defensible "what would this cost to build" range for a product or codebase.

Method / frameworks

Threshold-based health scoring (red/yellow/green), MoM variance analysis, runway = cash ÷ net burn, burn multiple (net burn ÷ net new ARR), gross-margin and liquidity-ratio analysis (current/quick), DSO-driven working-capital diagnosis, revenue-concentration risk, and base/bull/bear scenario modeling. Every estimate is presented as a low/avg/high range with a confidence level, and market rates are pulled with a current-year search.