Executive Summary
Cash Position & Runway
—
Cash on hand
—
Key Variance Callouts
Largest MTD drivers vs. forecastProfit & Loss: Forecast vs. Actual
Each closed month is compared to the forecast as it stood at that month's close (stored, never recalculated). Click a category, or use Expand All, to drill into sub-account and vendor-level detail. Details →
Summary P&L (Actual + Forecast)
Act through the latest close, Fcst for the rest of the year, Budget after that, with cash rows below Net IncomeCategory-level view only. See Forecast (Live) for vendor-level detail on forecast months, or Profit & Loss for vendor-level actuals.
Confidential: Individual Compensation Detail
Workforce - Baseline: Compensation Detail
Includes employee names, unlike the rest of this reportAbout this roster
- The source of truth for the Labor Expense forecast.
- Includes employee names. Only users with Workforce - Baseline access can open this tab; the database enforces it, not just the page.
Compensation & Hiring Plan
Editable: add, remove, or adjust current and forecast employees here; changes flow into the Forecast (Live) Labor Expense line automaticallyLabor Expense Build-Up
Salary, Benefits, Payroll Taxes & Bonus subtotals by month, rolling to Total Labor Expense; ties 1:1 to the Labor Expense line on Forecast (Live)Read-only rollup. Closed months from actuals; forecast months (current year and next year) from the Compensation & Hiring Plan. Details →
Confidential: Individual Compensation Detail
Employee Comp Breakdown
Per-person detail behind the Labor Expense Build-Up on Workforce - Baseline Details →Confidential: Individual Compensation Detail
Workforce - Incremental
Editable: add, remove, or adjust budgeted roles here; changes flow into the Budget, Cash Flow & Capital, and Scenario Sensitivity automaticallyThe budgeted (incremental) roles for the budget years, editable the same way as Workforce - Baseline. Details →
Confidential: Individual Compensation Detail
Employee Comp Breakdown + Incremental
Baseline totals, plus Workforce - Incremental roles layered in by fiscal yearSame baseline totals as Employee Comp Breakdown, plus each fiscal year's Workforce - Incremental roles layered in as their own section. Details →
Budget
Stored budget by category (the approved budget model plus approved exceptions); Labor shown as Baseline plus Incremental from the two workforce tabsBudget - Capital
Capital planning: cash outlay only, deliberately excluded from OpEx and Net IncomePlanning view for capital items (equipment, capitalized R&D and similar) and their monthly cash outlay. The total feeds Cash Flow & Capital as cash out; it does not run through OpEx or Net Income. Entries are for planning in this session only and are not saved.
Forecast (Live): Living Document
Plan = closed months, frozen at each close. Fcst = open months, editable. Budget = next year onward, set on the Budget; expand a category to see its baseline vendors and Incremental.Closed months show the forecast as it stood at each month's close; actuals are on Summary P&L and Profit & Loss. Open months: Labor Expense comes from Workforce - Baseline and every other line is editable. Next year onward shows the Budget, read-only here.
Only open months of the current year are editable; Labor Expense is never a manual entry. Edits save to Supabase automatically and appear on the Change Log tab. Vendor detail shows for open months. FY Total columns run current year + next year. Details →
Cash Flow & Capital
Cumulative cash: actual bank balance through the latest close (funding and balance sheet activity shown), then Net Income plus projected balance sheet activity, less Capital Spend, walked forward Details →Scenario Sensitivity
Adjust Revenue, OpEx, and Headcount to see the resulting burn, runway, and implied raise; always ties to Summary P&L's real numbers at the Steady setting. Details →Scenario Comparisons
FY Budget (Draft) vs. FY Forecast (Live), with a month-by-month variance Details →Change Log
Every saved edit to Forecast (Live) and Workforce - Baseline, newest firstRead-only audit trail, logged automatically as edits are saved. Visible to every signed-in user; Workforce - Baseline entries are hidden from anyone without payroll access. Admins can revert an individual field edit; reverting logs its own entry rather than erasing history. Details →
Cash Update
Admin-only · logs a current cash balance between closesUse this when the close is running behind and cash has moved since the last close. The most recent entry drives Cash On Hand, Runway and the cash chart on the Executive Summary, and the cash rows on Summary P&L and Cash Flow & Capital, until a close loads past its date. Then the close figure applies again on its own. Not for funding forecasts.
Past Updates
Tab Guide
What each tab shows, how it connects to the others, and how to read it: the detail behind the short notes on every tabWhich numbers each tab shows
- Act: closed months, from QuickBooks. Summary P&L, Profit & Loss, Cash Flow & Capital and the Executive Summary all show the same actuals.
- Fcst: the rest of the current year, from Forecast (Live): the stored forecast plus live edits, with Labor Expense from Workforce - Baseline.
- Budget: next year onward, from the Budget: stored lines from the approved budget model (with any approved exceptions) plus live Labor from Workforce - Baseline and Workforce - Incremental.
- Plan (Forecast (Live) only): a closed month's forecast as it stood at that month's close. Profit & Loss compares actuals to this number. It never changes after the close.
- Cash: Summary P&L's Cash Ending, the Executive Summary chart and Cash Flow & Capital read one roll-forward, so they always show the same cash for the same month.
- Labor Expense is never a manual entry anywhere; it always comes from the two workforce tabs.
Executive Summary
- One-page snapshot for the selected month: KPIs, cash runway, and the largest forecast variances.
- A starting point, not a substitute for the detail tabs below.
Reporting: Profit & Loss
- Forecast vs. Actual for all reporting categories. Forecast for a closed month is the forecast as it stood at that month's close; Actual comes from the ledger through the latest close.
- The Month/YTD/LTD scope toggle applies here.
- Click any category, or use Expand All, to drill into the chart-of-accounts detail beneath it (sub-account → vendor), sourced from actual ledger transactions. Forecast isn't tracked below the category level, so those columns show, at the sub-account/vendor rows.
- The PDF export shows category-level rows only, collapsed, to keep the export readable; the on-screen version keeps the full collapsible tree down to vendor level.
Reporting: Summary P&L (Act+Fcst)
- Act through the latest close, Fcst for the rest of the current year, Budget after that, with cash rows below Net Income.
- Category level only. Vendor detail is on Forecast (Live) for open months and on Profit & Loss for closed months.
Workforce: Workforce - Baseline
- An editable Compensation & Hiring Plan (add, edit, or remove a role: name, title, hire/term date, base salary, bonus %, benefits %, signing bonus) that drives Labor Expense for every forecast month on Forecast (Live), current year and next.
- This is the only tab that shows employee names; access requires the Workforce - Baseline permission, enforced by Supabase row-level security (a restricted user never sees this tab at all, not even its existence).
- Closed-month actuals are never changed by edits here regardless of what the hiring plan assumes going forward; a terminated employee shows via their Term Date rather than a separate ledger.
- The Labor Expense Build-Up table below blends two sources by year (closed months from actuals, forecast months from the live hiring plan), so it always ties 1:1 to what's actually driving Forecast (Live)'s Labor Expense line.
Workforce: Employee Comp Breakdown and Employee Comp Breakdown + Incremental
- Per-person detail behind Workforce - Baseline's Labor Expense Build-Up, one card per fiscal year, headers locked to the top as you scroll.
- Both tabs collapse to a category total (Salary, Bonus, Benefits & Taxes, Signing Bonus) by default; click a category row, or Expand All, to drill into the per-person detail behind it.
- Employee Comp Breakdown covers every active person; each category's Subtotal ties 1:1 to that month's Total Labor Expense on Workforce - Baseline. The plain tab shows every baseline employee; + Incremental shows the baseline total per component only, not per-person, see the plain tab for that detail.
- Employee Comp Breakdown + Incremental adds a 5th section per fiscal year listing that year's own Workforce - Incremental roles' real monthly $ (from each role's own hire/term date and Base Salary), shown per-role combined, not split into Salary/Bonus/Benefits/Signing (see the Workforce - Incremental tab for that split).
- Each fiscal year's Grand Total includes only the budgeted roles active sometime in that year: both budget years draw from the same registry of budgeted roles, filtered by each role's real dates.
Workforce: Workforce - Incremental
- The budgeted (incremental) roles only: FTEs and Planned Roles (the full live roster) stay on Workforce - Baseline.
- A full live editor, structurally and behaviorally identical to Workforce - Baseline's own Compensation & Hiring Plan: one combined, chronologically-numbered, sortable registry (#, badge, Role, Hire Date, Term Date, Base Salary, Bonus %/$, Benefits %/$, Signing Bonus $, Fully-Loaded Annual $) covering every budgeted role in both budget years.
- Every field is directly editable and saves automatically to Supabase; "+ Add Role" adds a new budgeted role the same way it does on Workforce - Baseline. This is a budget/what-if layer; edits here never touch Forecast (Live) or the live roster.
- The FTE/Headcount block and the Baseline/Incremental/Total $ summary render once for each budget year (FY and FY), each with a real Salary/Bonus/Benefits & Taxes/Signing Bonus split, tying to the same real figures used on Employee Comp Breakdown + Incremental, the Budget, and Cash Flow & Capital.
Budget & Planning: Budget
- The budget is stored, not a live feed. Every non-Labor line is loaded from the client's approved budget model, with any approved exceptions recorded in each line's source note.
- Labor Expense is live: Baseline from Workforce - Baseline plus Incremental from Workforce - Incremental. It is never a manual entry.
- Every other expense line shows its stored total, then Baseline and Incremental beneath it. Baseline is the known vendors, copied once from the December Forecast (Live) run-rate before the budget year and edited here by vendor and month; it does not follow later Forecast (Live) changes. Incremental is the stored total less Baseline and is calculated, never typed. A vendor edit moves Incremental only; the total, runway and every other tab stay put. A negative Incremental shows in red: raise the budget or reduce the baseline.
- Admins and editors can change a stored line; every change is logged on the Change Log. Forecast (Live) no longer changes this budget.
- Summary P&L, Forecast (Live), Cash Flow & Capital, the Executive Summary and Scenario Sensitivity all read these same figures for FY and FY.
Budget & Planning: Budget - Capital
- A planning view for capital items and their monthly cash outlay, one block per fiscal year.
- The total feeds Cash Flow & Capital as cash out. It does not run through OpEx or Net Income.
- Entries are for planning in the current session only and are not saved.
Budget & Planning: Forecast (Live)
- Closed months (Plan): the forecast as it stood at each month's close, stored and never recalculated. Actuals are on Summary P&L and Profit & Loss.
- Open months of the current year (Fcst): the living forecast. Every category except Labor Expense is editable, and categories with ▸ expand to sub-account and vendor detail (open months only); editing a vendor cell recalculates its category.
- Labor Expense comes from Workforce - Baseline's Compensation & Hiring Plan and is never a manual entry.
- Next year onward (Budget): the Budget, read-only here. Change it on the Budget tab.
- Edits save to Supabase automatically (admin or editor role) and show on the Change Log tab.
Budget & Planning: Cash Flow & Capital
- The chart plots cumulative cash: the actual month-end bank balance through the latest close, then Net Income plus projected balance sheet activity, less Capital Spend, walked forward month by month through FY.
- Closed months show actuals (same as Summary P&L), with Funding Received (equity and debt raised) and other balance sheet cash activity as their own rows so the walk ties to the bank balance. The rest of the current year uses Forecast (Live); FY and FY use the Budget. Projected months also carry balance sheet cash activity from the close schedules: depreciation, non-cash lease cost, prepaid expenses released and security deposits applied or refunded.
- Every cash figure here equals Summary P&L's Cash Ending and the Executive Summary chart for the same month.
- Below the chart: one monthly block per fiscal year, an Annual Summary and a Quarterized view.
Budget & Planning: Scenario Sensitivity
- A live what-if tool: adjust Revenue %, OpEx %, and a Headcount multiplier to see the resulting cash-on-hand, runway, and implied raise; always ties to Summary P&L's real numbers at the Steady setting (0%, 0%, 1.0x).
- Controls sit above the chart. Target runway (months) sets the runway the Implied Raise figure solves for; Estimated Funding is a one-time $ amount you can plug in to see the additional raise needed on top of it.
- "Reset to Steady" returns every lever to its baseline (0%, 0%, 1.0x, $0) in one click.
- The chart and KPI cards re-render live as you move a slider; nothing here is saved or written back to Supabase; it's a what-if view only.
Budget & Planning: Scenario Comparisons
- A three-part comparison: (1) FY Budget (Draft), (2) FY Forecast (Live), (3) their Variance; each with Jan-Dec monthly columns plus a Total column, same P&L structure as Profit & Loss (Revenue, Expenses, Operating Income, Non-Operating Income, Net Income).
- Scenario 1 reads the exact same Baseline + Incremental figure the Budget tab shows for FY; Scenario 2 reads Forecast (Live)'s own value; neither is a separate, re-derived copy, so this tab can't quietly disagree with either source tab.
- The Variance table pairs the two scenarios by month position (Jan vs. Jan, Feb vs. Feb, and so on) rather than calendar month, since they're different fiscal years by design; each cell shows $ amount and % variance together, colored favorable/unfavorable (green/positive always favorable, red/negative in parens always unfavorable).
- Headers and the Category column stay locked while scrolling.
Change Log
- Every saved Forecast (Live) edit (category-level and vendor-level) and every saved Workforce - Baseline edit (a role added, removed, or field changed), logged automatically by Supabase the moment it's saved, newest first.
- Visible to every signed-in user regardless of role, with one exception: Workforce - Baseline entries never reach anyone without payroll access (
can_view_payroll= false), enforced at the database level, not just hidden on screen. - Admins can revert an individual field edit, which logs its own "reverted" entry rather than deleting the original; history is never erased, only added to.
- Adding or removing a role is logged for the audit trail but isn't revertable from this tab; add or remove the role directly on Workforce - Baseline instead.
Cash Update (admin only)
- Logs a dated cash balance between closes. The newest entry drives cash until a close loads past its date, then expires on its own.
- The rest of that month's projected burn is deducted pro rata by day, so projected month-end cash is not overstated.
- Not for funding forecasts: funding counts only once it is received and closed.
Management Commentary