How to Reconcile Revolut and ActivoBank in One Accurate View

Matching transactions between Revolut and ActivoBank manually takes most people 3 or more hours a month — and still produces a figure that’s wrong.

If you run money across both accounts — Revolut for day-to-day spending, ActivoBank for savings or investments — you already know the problem. Every transfer between the two shows up as spending in one account and income in the other. Count both sides, and your monthly outgoings look double what they are. Fixing that distortion is the core challenge of reconciling the two accounts into a single, honest picture.

Why This Distortion Matters More Than You Think

The moment you move €500 from ActivoBank to Revolut to cover a trip, that transfer appears as an expense in ActivoBank’s export and as a top-up in Revolut’s. If you add both figures into a spending total, you’ve inflated your costs by €500 before you’ve bought a single flight ticket.

This matters because Portuguese household financial data is published by Banco de Portugal, and inter-account transfers are the most common source of reconciliation error in multi-bank households. The error leads to real decisions: underestimating savings capacity, overestimating spending, and misjudging how much you can actually put into your PPR each month.

What Revolut and ActivoBank Each Export — and Where They Clash

Revolut exports transactions in CSV with columns for date, amount, currency, description, and balance. ActivoBank’s internet banking exports in CSV or OFX, with different column names and date formats — DD-MM-YYYY versus Revolut’s YYYY-MM-DD in most export settings.

That format mismatch alone breaks most manual reconciliations on the first attempt. You normalise the dates and align the columns. Then you still have to match every internal transfer by amount and approximate date — because neither bank labels them with a shared reference code.

PSD2 — enforced in Portugal by Banco de Portugal and in Spain by Banco de España — requires that banks provide structured transaction data to licensed aggregators, allowing tools to pull both feeds automatically and tag transfers consistently. Manual CSV work bypasses that entirely.

The Calculation That Actually Works

The goal is one clean spending number for the period. Here is the arithmetic:

Take total outflows from Revolut. Take total outflows from ActivoBank. Subtract every transfer that moved money between the two accounts — both the debit leg and the credit leg. What remains is real external spending.

Example: Revolut outflows €1,800, ActivoBank outflows €2,100, inter-account transfers €500 (one transfer, two legs). Real spending = (€1,800 + €2,100) − (€500 × 2) = €2,900.

If you skip that subtraction, your spending reads €3,900. That €1,000 error is enough to make a 28% savings rate look like 18% — and those two numbers lead to different retirement timelines.

”Just Use Revolut’s Built-in Analytics”

Revolut’s spending breakdown is clean and well-designed — for transactions that stay inside Revolut. It has no visibility into your ActivoBank account. So when you pull €800 out to cover a direct debit that only works via Portuguese IBAN, that €800 shows as a Revolut outflow with no corresponding category on the ActivoBank side.

The result: Revolut tells you your spending is €800 higher than it is, and ActivoBank’s record shows an unexplained debit. Combined without adjustment, they are both useless.

So What Should You Actually Do?

If you want to stop losing hours to this every month, MyCFO reconciles both accounts automatically — stripping internal transfers before they distort your totals.

“A single misclassified €500 transfer inflates your apparent spending by €1,000 and shrinks your savings rate by up to 10 percentage points.”

If you are doing this manually, follow these steps exactly:

Export Revolut CSV and ActivoBank CSV for the same calendar month.
Standardise date formats to DD-MM-YYYY across both files before any matching.
Flag every row where the description contains “ActivoBank” (in Revolut) or “Revolut” (in ActivoBank) — these are your transfer pairs.
Remove all flagged rows from both files before summing outflows.
Sum remaining outflows across both files to get real external spending for the month.

Cross-account reconciliation is a two-step problem: format alignment first, transfer removal second.

Done right, the number you arrive at is the one worth tracking — and worth comparing month to month. Start there, then decide whether your savings rate or PPR contributions need adjusting.

Frequently Asked Questions

How do I identify which transactions are inter-account transfers when reconciling Revolut and ActivoBank?

In Revolut’s CSV export, transfers to ActivoBank typically appear with a description referencing your IBAN. In ActivoBank’s export, look for outflows matching Revolut’s IBAN or MB Way references. Match them by amount and date — within one to two business days, accounting for processing time. Flag every matched pair and exclude both legs before calculating total spending.

Does the reconciliation process change if I have more than two accounts — for example, adding ING Spain or a brokerage account?

Yes, and the complexity scales fast. Each additional account adds more potential transfer pairs. With three accounts, you can have transfers flowing in three directions, each generating a debit leg and a credit leg. You must identify and strip every pair, not just Revolut-to-ActivoBank. With four or more accounts, manual matching becomes genuinely unreliable. A single missed pair is enough to distort your monthly spending figure by hundreds of euros.

Should I include Revolut savings vaults or ActivoBank term deposits in my monthly spending total?

No. Moves into Revolut savings vaults or ActivoBank term deposits are savings allocations, not spending. Treat them the same way you treat inter-account transfers — flag and exclude them from your outflow total. Only count money that left your combined financial perimeter entirely: merchant payments, utility direct debits, subscriptions, ATM withdrawals used for external purchases.

Reconciling Revolut and ActivoBank by hand means two different CSV formats, mismatched date columns, and transfer pairs that inflate your spending if you miss even one. MyCFO connects both accounts and strips internal transfers automatically, so the number you see reflects what you actually spent. Get your accurate monthly total →