The spreadsheet did one thing: it held numbers. It had three columns — label, amount, balance. No macros. No automation beyond basic SUM formulas. It looked like something a first-year accountant would build as a training exercise.
In 2023, this spreadsheet ran a monthly rhythm that eliminated credit debt in five months. Not because the spreadsheet was clever. Because the habit underneath it ran without willpower.
The details below are what I found.
The Setup
There was income coming in and a credit balance sitting there. The standard response to debt is to attack it directly — throw every spare amount at it, cut lifestyle, make sacrifices. That approach works until it doesn’t. It runs on willpower. Willpower depletes.
What I built instead was a progressive allocation system. Every time income arrived, it moved through three containers: necessities, debt repayment, and everything else. The containers were not bank accounts. They were labels in a spreadsheet — categories with percentages assigned to each one.
The allocation percentages never changed. The debt container received the same percentage of every incoming payment from month one. The spreadsheet had no intelligence. It did not optimize for debt payoff speed. It simply executed the same allocation on every cycle.
Month one: the debt received its allocation and sat there. Month two: same. Month three: the balance started moving. Month four: it accelerated. Month five: the debt was gone.
The tool was not the point. The allocation behavior was.
How It Actually Worked
The system did not require daily attention. Income arrived, numbers went into the spreadsheet, the allocation percentages did their work. No decisions to make. No willpower to spend. The same three-step process, every single time.
The spreadsheet tracked what was happening. That was all. It gave the behavior a place to live and a way to see progress. The debt column shrinking month by month was the feedback loop — not gamification, not notifications, just a number moving in the right direction.
By the fifth month, the debt balance read zero. No extra payments. No lifestyle overhaul. No clever financial engineering. The allocation percentages were the same in month five as they were in month one. The system simply ran long enough to eliminate the problem.
What This Reveals
The spreadsheet was a vessel, not a solution. The debt disappeared because the allocation behavior ran on a monthly cycle without requiring me to push it. The spreadsheet held the shape of the behavior. The behavior carried the weight.
This is the pattern I started noticing everywhere: the gap between executing a behavior and the tool that enables it. The tool is what you see. The system is what makes it work.
Most finance apps try to be better tools. Better interfaces, smarter categorization, fancier dashboards. They are solving the wrong problem. The problem is not how to make money management more elegant. The problem is how to make money management run without the user having to think about it.
The spreadsheet worked because it encoded a behavior I had already proven could run on its own. An app would have failed in the same way most apps fail — it would have asked me to start something instead of amplifying something already running.
The Principle
Build the habit first. Prove it runs without willpower. Then scale it.
If you productize before the habit exists, you are building a tool for a problem you have not yet solved. The spreadsheet worked because the allocation behavior was already proven. The tool held a shape that had already been filled with something real.
This applies to invoicing. To product building. To content. The principle is the same: products encode habits. When the habit comes first, the product amplifies it. When the product comes first, it holds a shape with nothing inside.
The next piece will be about what this looks like when the pattern moves from personal finance into building products.