The Spreadsheet He Kept Refusing to Open: An Enneagram Type 7 Money Story

Across the United States, Canada, and the United Kingdom, people underestimate their own future spending by roughly $5,100 a year. That figure comes from a 2022 study in the Journal of Marketing Research by Chuck Howard and his colleagues, who ran ten experiments with more than 6,000 participants and found a consistent pattern they called the “expense prediction bias.” When we imagine next month, we picture our typical costs, the rent, the groceries, the predictable bills. We forget the dental emergency, the car repair, the wedding gift, the flight we will absolutely want to book. The future, in our minds, is always a little cheaper and a little simpler than it turns out to be.

For most people that bias is a quiet leak. For an Enneagram Type Seven, it can become a way of life.

Desmond ran three businesses in eleven years. A landscaping company that did genuinely well for two summers. A podcast studio he built out in a rented warehouse space in Calgary. And, most recently, an app idea he described to anyone who would sit still long enough, an app that was, he was certain, eight weeks from changing everything. He was forty-six, charismatic, the kind of man who could turn a coffee line into a conversation and a conversation into a plan. What he could not do, that spring, was open the spreadsheet his accountant had emailed him.

Why the Future Always Looked Funded

The Seven’s core passion, in the language Claudio Naranjo used in Character and Neurosis, is gluttony. Naranjo was careful to say this is not about food. It is a hunger for experience, for stimulation, for the next interesting thing, anything that keeps a person moving forward and away from the flat, painful feeling of being stuck. Sevens are oriented toward possibility the way plants are oriented toward light.

Money, for Desmond, was never really about money. It was about options. As long as there was a line of credit, there was a runway. As long as there was a runway, there was a next idea. And the next idea was always going to be the one that paid for all the others.

This is where the Seven’s relationship with the future does its quiet damage. Don Richard Riso and Russ Hudson, in The Wisdom of the Enneagram, name the Seven’s basic fear as the fear of being deprived and trapped in pain. The basic desire is to be satisfied, to have needs met, to stay free. A balance sheet that says “you are running out” speaks directly to that fear. So Desmond did what Sevens do under pressure: he reframed. The home equity line was “strategic.” The maxed card was “bridge financing.” The warehouse lease he could no longer cover was “a sunk cost we’re moving past.” Every number had a story, and every story pointed somewhere brighter.

Beatrice Chestnut, in The Complete Enneagram, describes this as the Seven’s gift for “rationalizing and reframing” reality so that limitation never quite lands. The avoidance is not laziness. It is a sophisticated, fast-moving intelligence working very hard to keep one feeling at bay: the feeling of having to sit inside a problem that cannot be escaped by thinking of something more fun.

Desmond’s partner of nine years finally asked the question directly one Tuesday night. “How much do we actually owe?” And Desmond, who could quote download projections and market sizes from memory, realized he did not know. He had never let himself add it up.

The Number He Finally Let Land

He opened the spreadsheet on a Thursday morning, alone, with the accountant on speakerphone.

The number was $94,000.

What surprised him was not the figure. On some level he had known it was large. What surprised him was the silence afterward, the way his mind reached for the usual exits, the reframe, the new plan, the “but if the app hits,” and how, for once, none of them carried him anywhere. He just sat with the number. It did not become a story. It stayed a number.

That stillness, uncomfortable as it was, is the doorway the Enneagram points Sevens toward. The growth path for Type Seven moves toward the healthy qualities of Type Five: focus, depth, the willingness to go all the way into a single thing rather than skating across the surface of many. A healthy Five can look at a hard reality and stay with it long enough to actually understand it. Desmond, in that quiet, was borrowing something from Five he had spent a decade avoiding. He was letting himself know what was true.

In the Head Triad, Sevens manage fear not by confronting it like a counterphobic Six or withdrawing from it like a Five, but by staying ahead of it. Keep planning, keep moving, keep the calendar full, and the fear never catches up. The cost is that the present moment, the one place where real decisions get made, becomes a blur you pass through on the way to the next thing.

Discovery calls are free and there’s no obligation — just a conversation.

What Sobriety Actually Looked Like

When Desmond and I worked together, he expected the conversation to be about discipline. Budgets, spreadsheets, willpower. Sevens often brace for someone to take their fun away, and they brace hardest right at the point where growth becomes possible.

But the Enneagram does not ask the Seven to become joyless. The virtue that balances gluttony is sobriety, and David Daniels, M.D., whose type descriptions shaped a generation of Enneagram teachers, framed it less as restraint than as fullness. Sobriety is the capacity to be so present to one real experience that you no longer need five imagined ones to feel alive. It is taking exactly what the moment offers, no more and no less, and discovering that it is enough.

For Desmond, sobriety started with something almost embarrassingly small. Every Sunday, he opened the spreadsheet. Not to fix it. Just to look. Fifteen minutes, one real number at a time. The first few weeks were physically uncomfortable; he described a restlessness in his chest, a pull to close the laptop and go book a trip or pitch an investor. He stayed anyway. That staying, that refusal to outrun the discomfort, was the entire practice.

The expense prediction bias that Howard’s team documented has a known antidote: instead of imagining a typical month, you deliberately bring to mind the atypical costs, the things that usually go forgotten. Desmond built that into his Sundays. What might be different this month? What am I not letting myself see? It is a Five’s question, asked by a Seven, and it slowly turned his planning from wishful into actual.

He did not abandon the app. He scaled it down to something one person could build in evenings while the landscaping business, the one that had actually worked, came back as his main income. He paid the $94,000 down over two years. The more interesting change was internal. Desmond stopped needing the next idea to rescue him from the current one, because he was no longer running from the current one. The healthy Seven, Riso and Hudson wrote, is not the person with the most options. It is the person who can be deeply satisfied by the life actually in front of them.

If you recognize yourself in Desmond, in the reframing, the unopened statements, the certainty that the next thing will cover the last thing, it is worth knowing that this is one of the most predictable and most workable patterns in Enneagram growth. The Seven’s restlessness around money is rarely about greed. It is about a deep, old reluctance to sit inside limitation, and limitation is exactly where a clear-eyed financial life begins. The same pattern often shows up in parenting, in grief, and in the self-preservation Seven’s particular hunger for a secure base. The work is the same in each: not less joy, but joy that can hold still long enough to be real.

Desmond keeps the spreadsheet open on his desktop now. He told me, near the end of our work together, that the number used to feel like a cage. These days it just feels like the truth, and the truth, it turns out, is something a Seven can finally afford.

Discovery calls are free and there’s no obligation — just a conversation.