Build a Budget From Actual Bank Outflows
Start from actual bank transactions, without idealized amounts, then sort them into fixed, variable and discretionary spending.
Published 2026-07-21
Budgets fail in series for a structural reason: they describe an ideal person rather than the real one. The reverse method starts from statements: three months of transactions exported without rounding or flattering, sorted into three families — fixed, necessary variable, discretionary. The portrait always surprises — forgotten subscriptions, groceries underestimated by more than a hundred dollars — and those surprises are precisely the missing information. Annual expenses convert into monthly provisions so they stop wrecking their arrival months, and the final budget reflects real life, minus two or three chosen corrections. Maintenance takes fifteen minutes a month: compare planned with actual, explain gaps first, correct second, no trial. A budget that survives is one adjusted several times — never perfect on the first try. This article guides the export, the sorting, the high-yield corrections and the monthly routine that keeps the whole thing alive.
Export the real, without rounding
The budget that holds starts with an act of renunciation: describing what is, not what should be. Exporting three months of transactions, account and cards, supplies the raw material, every line at its real amount, without rounding or prior sorting, the chosen months being ordinary rather than exemplary. That unretouched photograph is what the previous attempts lacked: budgets built on estimates inherit their optimism, and the gap between estimated and real — a hundred and fifty dollars of groceries a month in many households — explains years of budget failures on its own. The exported real, however uncomfortable, is the only foundation that bears weight.
Sort into three telling families
The transaction sort follows three families with distinct behaviours. The fixed — rent, insurance, telecom, subscriptions: stable amounts, rare but powerful levers, renegotiation or cancellation. The necessary variables — groceries, gas, pharmacy: compressible at the margin, never removable. The discretionary — restaurants, outings, spontaneous purchases: the territory of real choices. That sorting, one evening's work, produces the discoveries that change behaviour: the forgotten subscriptions totalling an electricity bill's worth, meal delivery become a disguised fixed item, the discretionary category twice intuition's size. The budget is then built on these three families, each with its own strategy, rather than on theoretical categories.
Convert the annual into monthly provisions
Annual and seasonal expenses are monthly budgets' silent killers: registration, insurance, gifts, back-to-school, tires — each wrecking its arrival month before vanishing from memory. The structural fix: every irregular expense, identified in the export or the year's list, is divided out to its due date and becomes a monthly provision, transferred automatically into a reserved account from which the bills are paid as they arrive. Six hundred dollars of insurance in July becomes fifty dollars a month all year, and July stops being a crisis month. That conversion, applied to the whole list, smooths the budget until the months finally resemble one another — a quiet but essential condition of any durable discipline.
Maintain through explanation, not trial
The budget lives through its monthly review, fifteen minutes at the month's start: planned against actual, category by category. The method before the gaps: explain first, correct second, no trial. A one-time overrun gets absorbed; a recurring one signals a miscalibrated category, to be adjusted toward the real rather than defended through willpower, the budget having to describe a livable life. The chosen corrections stay rare and targeted, two or three per cycle, total reform being the recipe for abandonment. Within a few months, the gaps tighten naturally, awareness of the numbers doing part of the work. A budget that survives is a budget adjusted several times: initial perfection does not exist — patient convergence does.
Quebec scenario: compare before confirming
After three abandoned budget attempts, an administrative agent in La Tuque changes method: instead of writing what she ought to spend, she starts from what she does spend. She exports three months of transactions from her account and her two cards, without rounding or flattering anything, and sorts every line into three families: fixed — rent, insurance, telecom; necessary variable — groceries, gas, pharmacy; discretionary — restaurants, subscriptions, impulse buys. The portrait surprises her twice. Her subscriptions total $94 a month, two of them forgotten. And her real grocery spending runs $160 above the figure she would have sworn to. The annual expenses — registration, holiday gifts, back-to-school — get converted into monthly provisions so they stop wrecking the months they land in. Her final budget is nothing like ideal: it reflects her life, minus two subscriptions and with a realistic restaurant ceiling. At the start of each month, fifteen minutes is enough to compare planned with actual; a gap gets explained first, corrected second, with no trial. After six months, the average gap sits under 4%, and the budget has survived — precisely because it was built from statements rather than from resolutions.
Checklist
- Export three months of transactions without rounding
- Sort into fixed, variable and discretionary
- Name the surprises found
- Convert annual expenses into provisions
- Build the budget on real life
- Choose two or three targeted corrections
- Compare planned and actual at each month's start
- Explain the gaps before correcting them
- Adjust miscalibrated categories without a trial
Frequently asked questions
Why start from statements rather than an ideal budget?
Because the ideal budget describes a person who does not exist: yours starts from what you actually spend, exported without rounding or flattering. The surprises — forgotten subscriptions, underestimated groceries — are precisely the information the previous attempts lacked.
How do annual expenses fit a monthly budget?
As provisions: every annual bill divided by twelve becomes a monthly line, transferred into a dedicated reserve. Registration, gifts and back-to-school stop wrecking the months they land in. It is the most profitable fix for a budget that always bursts on the same dates.
What should happen with gaps between planned and actual?
Explain them first, correct them second, no trial: a recurring gap signals a miscalibrated category, not a character failure. Fifteen minutes at the start of each month suffices. A budget that survives is one adjusted several times — never one perfect on the first try.