Multi-broker portfolio consolidation for advisers

Most clients hold their investments at more than one provider, in more than one currency. Borderfolio brings those accounts together from the client’s own statements into one portfolio you have checked: valued on one basis, with combined exposure, returns, costs and income, and nothing counted twice.

Start a 30-day free trial Review a portfolio together

The trial is on the Founding Adviser plan, with no card to start. Prefer to look first? Open a sample firm, read-only, with fictional clients and real prices.

What gets in the way

Every provider reports differently. Column names, date formats, currencies and the way dividends and fees are booked all vary, and some statements omit the closing cash balance.
Statements overlap. A quarterly and an annual statement repeat the same trades; a re-sent export repeats everything.
The same exposure hides in different places. One fund held at two brokers, or two funds tracking the same index, look like diversification until they are put side by side.
Performance does not add up. Averaging each account’s percentage return gives a figure that describes nothing.

How statements come in

Create one account per brokerage relationship, then import its statements: PDF, CSV, XLSX or images. Exports from Freedom24, Trading 212, Interactive Brokers (Flex), DEGIRO, eToro, Revolut, Trade Republic, Freetrade, XTB, Saxo, Schwab, Swissquote, Avanza, InvestEngine and Vanguard Investor UK are read by format-specific parsers. Statements from other providers go through an extraction model, and the import says which path it took.

Each import opens for review. Positions and transactions are confirmed separately; a row that cannot be matched to an instrument is listed with the reason rather than dropped; transactions already in the ledger are counted as duplicates and not added again. A later import never silently overwrites what you confirmed. See importing statements.

Accounts at Interactive Brokers and Freedom24 can instead be connected through the broker’s read-only API and synced daily. See Interactive Brokers portfolio reporting.

One valuation, stated rules

One currency. Every holding is valued in the client’s base currency at ECB reference rates, and each conversion names its rate.
No partial totals. If any holding cannot be priced, the consolidated value is withheld and the unpriced holdings are named.
Cash as reported. Included when the statement reports a closing balance, reconstructed from confirmed transactions and labelled as such when it does not, and otherwise left out with a note.
Exposure merged, cost kept per account. Across all accounts the same instrument is one exposure line; its cost basis stays with the account that holds it.

The rules, and the reasons a figure is sometimes withheld, are set out in consolidation and performance.

What the consolidated view shows

Allocation by fund domicile, read from the ISIN, and by currency, both by listing and by looking through catalogued funds to the currencies they hold.
Performance across the combined accounts from the confirmed cash flows: a time-weighted return for the investments and a money-weighted return (XIRR) for the client’s own timing. Days on which an account has no valuation are skipped, never filled in.
Costs on one schedule: fund charges, adviser and platform fees and transaction costs, with the cumulative effect over one, five and ten years at today’s value and no growth assumed.
Income expected over the next twelve months from trailing distributions, before and after withholding.
Households. Partners and family members stay separate clients; a household view adds their figures together in one currency, with joint, trust and company accounts labelled by ownership so nothing is counted twice.

Reporting on the whole

The consolidated portfolio feeds the cross-border findings, proposal scenarios and the client report. A report is generated once from a stored snapshot, so it does not change when the next statement arrives. See portfolio review software.

For a step-by-step account of reconciling several brokers by hand and where it goes wrong, read consolidating client portfolios across brokers.

Where it stops

No connection to adviser back-office systems or platforms; client data arrives through statements, hand entry or the two broker connections.
A statement layout without a parser goes through the extraction model and always needs your review.
Returns need the transaction history: a single holdings snapshot gives a valuation, not a return.

Last updated 2 November 2026. Describes the product as built; figures are screening estimates for professional review, not tax, legal or investment advice.