← Back to articles

From Model to Board Report: Keeping the Spreadsheet Alive Post-Raise



Author: Yanni Papoutsi - Fractional VP of Finance and Strategy for early-stage startups - Author, Raise Ready Reading time: ~10 min

The Shift That Has to Happen

The fundraising model and the operating model serve different masters and different timelines.

This transition should happen within 30 days of round close. The capital is in the bank. The plan that was funded now becomes the baseline against which all future performance is measured. Every month that passes without actuals being tracked against that plan is a month where variance accumulates without visibility.

Building the Actuals Layer

The first operational update to the fundraising model is adding the actuals layer. For every period that has passed since the model was built, create four columns alongside the existing forecast. Plan: the original projection from the fundraising model. Do not change this retrospectively. The plan is the plan. Its value comes from being a fixed reference point. Actual: what actually happened, pulled directly from the accounting system. For revenue, this is recognised revenue per the accounts, not cash collected. For costs, this is the expense per the profit and loss account. Variance (absolute): actual minus plan. Positive variance on revenue is good. Positive variance on costs means overspend. Variance (percentage): absolute variance divided by plan. Variances above 10% in either direction should be explained. The actuals come from the accounting system. If the company is using Xero, QuickBooks, or another cloud accounting tool, the P&L and cash flow data exports to Excel in a format that can be mapped to the model categories. Setting up this mapping correctly once makes every subsequent monthly import a 20-minute exercise rather than a three-hour one. The key prerequisite is a chart of accounts in the accounting system that maps directly to the categories in the financial model. If the model has a "Customer Success" line but the accounting system has all payroll in a single "Salaries" account, the mapping is impossible without a manual allocation. Align the chart of accounts to the model structure before the accounting system has too many historical transactions to reclassify.

The Monthly Update Cadence

The operational model runs on a monthly cycle. The target is to have the prior month fully updated and a revised forward forecast ready within ten business days of month end. Week 1 of the new month: Close the prior month's books. The finance lead or CFO exports the P&L, balance sheet, and cash flow statement from the accounting system. Actuals are imported into the model. Week 1 to 2: Variances are calculated. For every line item more than 10% off plan, a variance note is written. The note should have two components: what caused the variance, and what the expected trajectory is. "Revenue GBP 180k vs. GBP 220k plan: two enterprise deals slipped to April due to extended procurement timelines; pipeline coverage for April is strong" is a variance note. "Revenue below plan" is not. Week 2: The forward forecast is updated if material assumptions have changed. If Q2 is looking weaker than planned based on pipeline data, update the forecast. Do not maintain an obviously outdated projection just to avoid a difficult conversation at the board meeting. Week 3 (pre-board): The board report is compiled. This is not the full model. It is the output of the model: headline metrics versus plan, P&L summary, cash and runway update, variance analysis, and updated forward forecast. Reviewed with the finance lead or CEO before distribution to the board.

The Board Report Structure That Works

Board members receive a lot of information. A board report that runs to 40 pages will not be read in full. A board report that runs to 8 to 12 pages on the right topics will be read completely and will drive a productive meeting. Section 1: Headline Metrics vs. Plan (1 page)

The most important KPIs shown as actuals versus plan. For a SaaS business this typically includes: MRR or ARR, net new MRR, churn rate, CAC, LTV, gross margin, and cash runway. Present each as a number, a plan number, and a variance indicator. Green for at or above plan. Amber for 5 to 10% below plan. Red for more than 10% below plan. No narrative in this section. Just the numbers. This section should be the first thing the board sees. Starting a board meeting with 20 minutes of strategic discussion before revealing that revenue is 25% below plan is a structurally poor approach to governance. Put the numbers first. Section 2: P&L Summary (1 to 2 pages)

Revenue, COGS, gross profit, each major OpEx category, EBITDA, net income. Three columns: current period actuals, current period plan, prior period actuals. The comparison to prior period is as useful as the comparison to plan because it shows trajectory. A company that was 15% below plan last month and is 8% below plan this month is improving, even if it is still behind. A company that was 5% below plan and is now 20% below plan is deteriorating. Section 3: Cash and Runway Update (half page)

Current cash balance. Current monthly burn (from the cash flow statement, not the P&L). Forward runway at current burn. Runway at revised forecast burn. Any material change from the last board meeting and its explanation. This section should never be a surprise. Board members who discover unexpected cash deterioration at the board meeting, rather than in a proactive update between meetings, lose confidence in management's ability to manage the business. Material runway changes should be communicated between board meetings, not at them. Section 4: Variance Analysis (1 to 2 pages)

For every variance more than 10% off plan, one to two sentences: the cause and the expected resolution. Organized by P&L category. Not a narrative essay. Specific, factual, forward-looking. The most important discipline in variance analysis is honesty about whether a variance is temporary or structural. A one-month slip in enterprise deals is likely temporary. A persistent 15% CAC overrun across four months is structural and needs to change the forward forecast. Section 5: Forward Forecast (1 page)

The next three to six months, updated for current actuals and near-term plan changes. This is where the operational model's forward-looking capability demonstrates its value. A board that has only historical actuals is looking backward. A board that has actuals plus a current forecast can have a useful forward-looking conversation.

What Happens When the Model Goes Stale

Founders who close a round and then stop maintaining the model experience a predictable pattern. Board meetings become narrative-only. Without current numbers, there is no analytical foundation for the discussion. Variances are described verbally and approximately rather than quantified precisely. The board loses confidence in management's ability to forecast. Runway surprises emerge. Cash is a lagging indicator. By the time the bank balance is worryingly low, the model should have been signalling the problem for three to four months. A stale model means that signal is absent. The next fundraise is harder. At the next round, investors will ask to see actuals versus the plan from the previous raise. A founder who can present a clean track record of actuals against forecast, including honest variance analysis, is in a materially stronger position than one who cannot. The ability to say "here is what we said we would do, here is what we actually did, and here is what we learned" is one of the strongest credibility signals in a Series A process. Investor relationships deteriorate. Board members who funded the raise based on a financial model expect to see progress tracked against it. A company that reports only qualitative updates signals that the quantitative discipline is not there.

Building the Finance Function Around the Model

Post-raise, most companies are adding their first finance hire or contracting with a fractional CFO or finance partner. The operational model should be the core output that this function maintains. The finance function's responsibilities relative to the model are: importing actuals monthly, calculating variances, writing variance notes in collaboration with the CEO and functional leads, updating the forward forecast, and compiling the board report. This takes approximately 8 to 12 hours per month for an early-stage company with a straightforward business model. It takes 15 to 20 hours for a company with multiple revenue lines, international operations, or complex cost structures. If you are not yet at the point where you have a finance hire or a fractional CFO, the model maintenance is the CEO's responsibility. The eight to twelve hours per month is not optional. It is the cost of running the business in a way that surfaces problems before they become crises and demonstrates to investors that their capital is being managed with discipline.