A Field Guide to the Seven Spreadsheets Every New CFO Inherits and Fears

SATIRE — On the first morning, the new CFO is issued a badge, a branded water bottle, and a folder called “Finance Source of Truth_FINAL_v18_USE THIS ONE.” Inside are seven spreadsheets. Each is said to be essential. Each has a different answer for cash. Each was created by someone who left “to spend more time with family” and remains, according to the file properties, the workbook’s sole author.

1. The Sacred Operating Model

You will recognize the Sacred Operating Model by its size: 43 tabs, 19 hidden columns, and one yellow cell that must never be touched. It contains revenue forecasts through 2037, although the company has not yet decided what it sells. Its assumptions tab is a museum of expired convictions: a 14% monthly enterprise conversion rate, a hiring plan based on “aggressive vibes,” and a line for “international expansion” beginning next Tuesday.

The model is technically owned by Strategic Finance, but the former VP of Finance built it, the CEO changes it directly, and a board member has a private copy with an extra tab called “Real Case.” Nobody agrees whether it is a budget, forecast, valuation model, or a ceremonial object intended to reassure lenders.

2. The Cash Forecast That Is Always Correct Until Thursday

This workbook contains the company’s official runway: 18 months on Monday, 11 months on Wednesday, and “plenty” during the all-hands meeting. It is maintained in a sheet named Cash Flow Final, alongside Cash Flow Final New, Cash Flow Final New 2, and Cash Flow Final Actual Actual.

The forecast has a beautifully formatted weekly cash bridge, except for the largest line item, which reads “AP timing?” It assumes every customer pays precisely on net 30, payroll happens when payroll happens, and sales tax is a philosophical question. The treasury manager will explain that the formula works perfectly if you do not look at the bank balance.

3. The Headcount Plan With Four Definitions of ‘Filled’

This is where the organization discovers that headcount is not a number but a coalition government. HR counts signed offers. Finance counts start dates. Department leaders count people they have mentioned in a planning meeting. Engineering counts a contractor in Warsaw who joined a Slack channel in 2024.

The CFO’s first task is to reconcile 612 planned heads against 487 employees, 71 open requisitions, 38 “backfills,” 22 consultants, and one mysterious row named “GTM leverage.” Do not delete the row. It may be the only thing supporting the annual plan.

4. The Board Deck Backup Schedule

The board deck is polished, concise, and full of numbers that appear with admirable confidence. This spreadsheet is where those numbers go to hide. Its tabs are named by month, quarter, board meeting, and emotional condition: Jan, Jan Revised, Jan Revised Clean, Jan Revised Clean2, Q1 Board, Q1 Board FINAL, and Please Use This.

There is no documented link between the spreadsheet and the deck. The connection is maintained by one senior analyst who has memorized which cells should be copied into PowerPoint and which should be quietly replaced after the CEO says, “Can we make the narrative more ambitious?”

5. The Revenue Reconciliation That Is Also a Crime Scene

This file began as a helpful tie-out between billing, the general ledger, and the CRM. It is now an archaeological site. One tab explains why invoice totals differ from recognized revenue. Another explains why neither matches the sales dashboard. A third, protected with a password nobody has, is called “DO NOT REFRESH.”

The new CFO will be told that the differences are timing. This is often true. It is also the corporate equivalent of hearing a noise in the basement and being told it is probably pipes.

6. The Compensation Calculator of Last Resort

No one admits this spreadsheet exists until an offer needs approval at 6:47 p.m. It calculates base salary, bonus, equity, relocation, sign-on, payroll tax, and whether the candidate’s desired title will trigger an executive-level coffee budget. It has conditional formatting in six colors, each meaning “ask Legal.”

The calculator also includes market data from an unnamed source, one anecdote from a departing recruiter, and a cell that converts restricted stock units into “approximately a lot.” The CFO is asked to approve the offer before learning whether the candidate is being hired as a Senior Manager, Director, or “Director-level Senior Manager.”

7. The Monthly Close Tracker That Has Achieved Sentience

At first glance, it is ordinary: tasks, owners, due dates, status colors. Then you notice that 146 tasks are overdue, 39 are marked complete with no support attached, and every recurring issue has been assigned to “Finance Team.” The tracker contains comments from three fiscal years, including “temporary workaround” and “will automate next quarter,” both written in the distant past.

This spreadsheet does not track the close. It tracks the company’s relationship with the idea of a close. It knows which reconciliations arrive late, which systems export malformed data, which approvals stall, and which executive will request preliminary results before the preliminary results exist.

The Official Integration Plan

For the first 90 days, the CFO should announce a finance transformation, form a steering committee, and create an eighth spreadsheet to catalogue the seven spreadsheets. This new file should have a clear owner, documented inputs, controlled access, and a refresh process that does not depend on an employee’s vacation schedule or a heroic 11:58 p.m. copy-paste.

Then, after the appropriate number of alignment sessions, the company may learn the one unsatirical fact in the room: a spreadsheet is not the problem. An important process with unclear ownership, inconsistent definitions, and no reliable source data is the problem; the spreadsheet merely has the decency to show its work.