How To Export Bank Transactions To A Spreadsheet

Manually exporting transactions from 3 or more bank accounts and reconciling them in a single spreadsheet costs most people 2–3 hours a month — and still produces inaccurate spending figures.

If you have accounts at ActivoBank, Revolut, and a Spanish broker like Openbank, getting a clean picture of your finances is not simple. It means downloading separate CSV or OFX files from each institution, stripping out inter-account transfers, and merging everything without double-counting. Most people either give up and pick one account, or run numbers that are quietly wrong.

Why the manual export process breaks at scale

Portuguese and Spanish banks all support transaction exports — usually CSV, sometimes OFX or XLSX — but the format varies by institution. Column headers differ. Date formats differ. Some banks export gross amounts; others net fees inline.

PSD2 — the EU directive that lets an aggregator pull your account data directly — changed what is technically possible. In Portugal, PSD2 is enforced by Banco de Portugal; in Spain, by Banco de España.

The regulation means your bank must share transaction data with authorised third parties. It does not mean the raw export files they give you are standardised.

Inconsistent formats break at two accounts. They collapse at five.

The core problem: transfers you cannot see

The spreadsheet approach fails almost everyone with financial complexity. A transfer from your Millennium BCP current account to your ActivoBank savings account shows up as an outgoing transaction in the first export and an incoming transaction in the second. If you total both files without filtering, you have just counted that money twice — once as spending, once as income.

The same problem appears with credit card repayments, inter-broker sweeps, and PPR contributions funded from a current account.

Most people do not catch this. Their “total expenses” figure is inflated, their “savings” figure is wrong, and every month-on-month comparison is noise.

Transfers distort every number that follows.

The steps that actually work

If you are going to do this manually, the process has to be deliberate.

Download the transaction file from each bank using its native export — CSV is the most portable format across Portuguese and Spanish institutions.
Open each file and add a column labelled “Account” so you know which institution each row belongs to after you merge.
Identify every transfer between your own accounts — mark these rows with a “Transfer” tag before combining anything.
Merge all files into one master sheet and filter out every row tagged “Transfer” before running any totals.
Build your expense categories and income totals only from the filtered dataset.

If you want to skip the monthly reconciliation across three bank exports, MyCFO pulls all your accounts into one accurate view — transfers excluded automatically.

Manually reconciling three bank exports without filtering transfers inflates your recorded expenses by a measurable margin every month.

Step 4 is the one most spreadsheet guides skip entirely. Skipping it is why the numbers feel wrong even after hours of work.

The counterargument: spreadsheets give you full control

The strongest case for manual exports is customisation. A spreadsheet does exactly what you tell it. You can build any category logic you want, match your Portuguese IRS reporting categories, and export clean data for your accountant without depending on any third-party app’s classification engine.

Quarterly one-off exports make sense because the reconciliation cost is paid once and the output is a fixed deliverable — a tax filing, an accountant’s report. Monthly reconciliation has no such endpoint, so the cost compounds while the control benefit stays flat.

So what — how to make this sustainable

The goal is one accurate number for income, one for spending, and one for savings — every month, without a two-hour reconciliation session.

“PSD2 — the EU directive that lets an aggregator pull your account data directly — changed what is technically possible.”

If your accounts are limited to one or two institutions, manual exports with the five steps above are workable. If you have three or more accounts, manual reconciliation will introduce errors faster than you can catch them. That includes any mix of current, savings, investment, and daily-spending accounts.

Set a threshold for yourself: if monthly reconciliation takes more than 45 minutes, the manual process is costing you time it cannot justify.

Frequently Asked Questions

How do I export bank transactions from Portuguese banks like Millennium BCP or ActivoBank?

Log into your online banking portal and look for “Movimentos” or “Extrato.” Most Portuguese banks let you export the last 90 days as CSV or XLSX directly from the account statement page. The exact path varies — Millennium BCP exports from the account detail view; ActivoBank offers it under account history. Always select the longest available date range in one download to reduce the number of files you need to merge.

How does the export and reconciliation process change when I have accounts at multiple banks?

Each bank produces a differently formatted file. When you merge them, transfers between your own accounts appear twice — once as outgoing, once as incoming. With 2 accounts this is manageable; with 4 or more it becomes the main source of error. Tag every inter-account transfer before you merge. Filter that tag out before calculating totals, and treat the filtered dataset as your only source of truth.

Can I automate transaction imports into a spreadsheet without manual CSV downloads?

Yes — PSD2-authorised aggregators can pull transaction data from multiple banks automatically and push it into a structured format. This removes the download step and the format-standardisation problem. The tradeoff is that you are relying on the aggregator’s category logic, which may not match your own. Review the category mappings in the first month and adjust; after that, the automation holds.

Exporting bank transactions manually works until you have more than two accounts — then the transfer-doubling problem quietly corrupts every figure. MyCFO connects to your Portuguese and Spanish accounts directly and strips inter-account transfers before calculating any total. See your accurate spending figure →