Why Financial Spreadsheets Fail For Multi-Account Finances

Spreadsheets break at 3 or more accounts — inter-account transfers double-count as income and inflate every total you rely on.

If you have accounts at two or three banks — say, Millennium BCP for salary, ActivoBank for savings, and Revolut for day-to-day spending — a single spreadsheet stops being a tool and becomes a liability. Every transfer you make between those accounts looks like new money coming in. Your income figure swells. Your savings rate lies to you. And you probably don’t notice until the numbers stop making sense.

The Multi-Account Problem Is Structural, Not a User Error

Portuguese households routinely hold accounts at more than one institution. No single bank has consistently led on savings rate, card rewards, and investment access at the same time. Splitting across providers is the rational response to a fragmented market.

Spreadsheets were built for a single ledger. When you add a second or third account, you are not extending the same system — you are running parallel ledgers that need reconciliation. Every transfer between them creates a phantom transaction that manual entry routinely miscounts. That distortion compounds with every account you add.

Why Transfers Destroy Your Numbers

A €500 transfer from your Millennium BCP current account to your ActivoBank savings account is not income. It is not spending. It is a reclassification of money you already owned. But in a spreadsheet, it enters as a debit on one sheet and a credit on another. If both sheets feed a summary tab, you have just inflated gross income by €500 and gross outflows by €500.

Run that error across twelve months of regular savings transfers and your annual income figure could be off by €6,000 or more. Your apparent savings rate is fictional. Decisions made on that number — whether you can afford a PPR top-up before the December deadline — are made on bad data. That is not a rounding error.

Keeping It Current Is a Job In Itself

Even if you solve the transfer problem, spreadsheets require manual updates. Portuguese banks do not export in a consistent format. Millennium BCP, Caixa Geral de Depósitos, and ActivoBank each produce different CSV structures — different date formats, different column orders, different transaction descriptions. Reconciling three exports into one sheet takes time every month, and that friction is the reason most people abandon the habit.

The sheet that was supposed to give you visibility becomes the thing you dread opening. Stale data is worse than no data, because it gives you false confidence.

”I Use Formulas to Flag Transfers” Is Not a Fix

The strongest objection is a fair one: a well-built spreadsheet with a dedicated transfer category eliminates the double-counting problem. Building it takes real skill, and maintaining it — especially when bank export formats change — is an ongoing task.

The real question is whether the median person with three accounts and a full-time job will build and maintain one correctly, indefinitely. In my experience, they do not. The margin for error on a manual system is too high for something you make financial decisions from.

So What Should You Actually Do

If your savings rate is below 20% of net income — you need an accurate baseline before you can fix anything. Portuguese household savings data from INE Portugal and euro area benchmarks tracked by Eurostat both point to the same gap: most households underestimate spending and overestimate their savings rate precisely because their tracking method is broken. A spreadsheet that miscounts transfers does not give you that baseline.

If you want to know your real rate without manually reconciling three bank exports, MyCFO calculates it automatically — transfers excluded, across all connected accounts.

“Across 3 accounts with monthly transfers, your spreadsheet income figure can be off by €6,000 a year.”

List every account you hold — current, savings, investment, credit — and note which institution issues it.
Identify every recurring inter-account transfer and confirm it appears in your current tracking as a transfer, not income or spending.
Verify your net income figure matches your actual payslips for the same period — any gap is a miscategorisation.
Check your savings rate: divide (net income minus total spending) by net income.

The Argument Holds

Spreadsheets fail multi-account finances not because users are incompetent, but because the format was never designed for parallel ledgers. Persisting with one anyway is not frugality — it is accepting bad data as the basis for real financial decisions. Fix the data source first; everything else follows.

Frequently Asked Questions

Why does having more bank accounts make spreadsheets less reliable?

Each additional account introduces a new category of inter-account transfers. Every transfer between your own accounts — moving money from a current account to a savings account — appears as both income and spending unless manually flagged. Topping up a Revolut does the same thing. With 3 or more accounts, the number of transfers grows quickly. At that volume, miscategorisation in any given month is not a risk — it is the default outcome. The error is structural, not occasional.

How do I calculate my real savings rate when I have accounts at multiple banks?

Sum all net income deposits across every account for a calendar month, then remove any amounts that originated from another one of your own accounts. Do the same for outflows — strip transfers to your own accounts. What remains is true income and true spending. Divide the difference by true income and multiply by 100. Anything below 20% of net income signals a gap worth closing before year-end. PSD2 — enforced by Banco de Portugal in Portugal and Banco de España in Spain — governs how banks must classify and report transactions, which is why connected-account tools can strip inter-account transfers automatically in ways a spreadsheet cannot.

Does a spreadsheet work if I only have two bank accounts?

Two accounts is workable with discipline. The transfer problem is limited to one recurring transfer type, and a SUMIF formula that excludes a “transfer” category handles it adequately. The system starts breaking down at three or more accounts. The problem is sharpest when one is an investment account. Capital movements are neither income nor spending, and most spreadsheet templates have no treatment for them.

Managing multi-account finances with a spreadsheet means your totals depend entirely on correctly categorising every inter-account transfer, every month, forever. MyCFO connects to your Portuguese and Spanish accounts and strips transfers automatically. Your income, spending, and savings figures then reflect reality. See your real number →