department · finance role · Financial Analyst
Financial dashboard
Driver-based forward model auto-derived from your books + payments + CRM. Every monthly refresh runs the Tier-3 cross-family supervised drift narrative.
Auto-send progress. 2 of 6 narratives approved without material edits. After 6 clean approvals, narratives will ship automatically (revocable any time).
Runway
14 months
P50 · base scenario
Monthly revenue
$150,000.00
Monthly burn
$172,000.00
Cash @ horizon
$48,000.00
Month 12
Business type
The model auto-detects your business shape from your books to pick the right drivers, headline and narrative. Override it here if the detection is wrong — the override is used on the next monthly refresh.
in effect saas_subscription — auto-detected
AR & AP aging
Full accrual snapshot from QuickBooks — current / 31-60 / 61-90 / 91+ days, with DSO and DPO. Drives the cash-from-operations bridge that replaces the V0 cash-basis path.
| Bucket | Amount |
|---|---|
| Current (0-30d) | $62,400.00 |
| 31-60 days | $18,200.00 |
| 61-90 days | $7,800.00 |
| 91+ days | $19,100.00 |
| Bucket | Amount |
|---|---|
| Current (0-30d) | $61,000.00 |
| 31-60 days | $9,400.00 |
| 61-90 days | $1,200.00 |
| 91+ days | $0 |
DSO & DPO trend — current + 3 prior
| Period | DSO | DPO | DIO | Deferred |
|---|---|---|---|---|
| 2026-04-30 | 42d | 31d | — | $188,000.00 |
| 2026-01-31 | 39d | 29d | — | $171,500.00 |
| 2025-10-31 | 36d | 28d | — | $162,800.00 |
| 2025-07-31 | 34d | 27d | — | $149,200.00 |
Recent narratives
Drift between assumptions and actuals. Every claim cites a source GL transaction or macro snapshot.
Net revenue retention slipped to 96% in April from 104% in March — the Helix Robotics account downgraded from Pro to Starter ($1,400/mo) and two Build-tier accounts churned ($890/mo combined). Reviewing whether to flag this in the May board update.
stripe:sub_helix_robotics_q1 · hubspot:deal_buildtier_q1_churn · gl:tx_2026_04_revenue_recognition
Gross margin held at 78% vs the 76% Q1 plan — the Snowflake credits renegotiation closed at a lower annual contract value than budgeted, saving ~$4,200/mo in cost of revenue.
gl:tx_2026_04_snowflake_credits · quickbooks:vendor_snowflake_2026_04
Sales magic number dropped to 0.6 in April from 0.9 in March — new ARR added ($24K) is below the run-rate $40K/mo target the Series A pitch assumed. Supervisor disagreed on whether this is a one-off (April had two stage-3 deals slip) or a trend; tiebreaker called it trend-leaning. Worth a board flag.
hubspot:pipeline_q2_stage3_slipped · stripe:new_arr_2026_04 · gl:tx_2026_04_sales_loaded_cost