Why Portfolio Reviews Still Take Hours for Independent Financial Advisers

Published 21 October 2026 by Borderfolio

An independent financial adviser rarely spends the longest part of a portfolio review on judgement. The hours go on preparation: gathering statements, retyping them, putting several brokers and currencies onto one page, and formatting a report the client can read. This article follows a review step by step, shows where the time goes, and separates what can safely be automated from what should stay with the adviser.

Where the hours go

Take a typical client of an independent adviser: a pension account with one provider, a brokerage account with another, perhaps an account opened years ago abroad. Each review of that client goes through the same stages, and each stage has its own way of absorbing time.

1. Collecting statements in different formats

Every broker exports differently. One sends a PDF, another a CSV with its own column names, a third an XLSX with several sheets, and some clients simply forward a screenshot. Before any analysis can start, someone has to work out what each file contains and which period it covers.

2. Retyping and reconciling

Most of that data ends up retyped into a spreadsheet. Every manual entry is a chance to drop a position, double-count a transfer between accounts or misread a ticker. Checking the result against the statements takes almost as long as typing it.

3. Putting several currencies on one page

Holdings arrive in euros, pounds, dollars and francs. To report one total, every position has to be converted at a stated rate on a stated date. Done by hand, the rates and dates are rarely recorded, and the next review starts from scratch.

4. Missing prices

A delisted share, an unlisted fund or a bond without a recent quote leaves a gap. Spreadsheets tend to treat that gap as zero, which quietly understates the portfolio. Finding and explaining the gap takes time, and leaving it unexplained costs trust.

5. Combined performance

Each broker reports its own return. Averaging those percentages gives a number that is simply wrong whenever accounts differ in size or receive deposits and withdrawals at different times. A correct combined return has to be calculated from the cash flows across all accounts, which is tedious in a spreadsheet.

6. Cross-border questions

For a client who lives in one country and invests through funds domiciled in another, the review also has to cover where each fund is domiciled, how much US dividend withholding applies at the client's residence, and whether US-situs holdings approach the non-resident estate-tax threshold. Each of these means looking something up and writing down the assumption.

7. Formatting the report, and doing it again next quarter

Finally the figures go into a document under the firm's name, with charts, the adviser's commentary and the caveats. Three months later the whole sequence starts again, and a report already sent must still say what it said, even though prices have moved.

What can be automated, and what should not be

Most of the stages above are mechanical, and they are where software helps. Two lines matter. First, automation should never let unconfirmed data reach a client's record: extracted statements are a draft until the adviser has checked them. Second, automation should prepare the review, not write the advice. The observations and proposed changes are the adviser's, and the client should be able to tell them apart from the system's figures.

How Borderfolio for Advisors shortens each stage

• Statements in, without retyping. The import accepts PDF, CSV, XLSX and image statements, up to five files at a time. Exports from thirteen brokers are read directly, and other statements go through an extraction model. Nothing reaches the client's holdings until the adviser has reviewed and confirmed it, and duplicate imports are detected. Consolidating client portfolios across brokers covers this in detail.
• One base currency, with the rates shown. Each client is valued in their base currency, and every conversion names its rate.
• Unknown stays unknown. When a holding has no price, the total is withheld and the reason is shown instead of a quietly understated figure.
• Returns that are computed, not averaged. Time-weighted and money-weighted returns are calculated across the combined accounts. When the history is too short, the return is shown as unavailable, with the reason.
• A cross-border screen with its assumptions. Fund domicile is read from the ISIN, US dividend withholding is estimated at the residence's treaty rate, and US-situs holdings are compared with the non-resident estate-tax threshold. Each estimate states what it assumes. Portfolio reviews for internationally mobile clients goes through each one.
• Current against proposed, without touching the real portfolio. A scenario lets the adviser try replacement securities and weights and compare allocation, currency, domicile, fees and withholding side by side. The client's actual holdings are never changed.
• A report that stays the same. The PDF is generated from a stored snapshot under the firm's name. The adviser's commentary is printed in its own section, labelled as adviser-authored, and a report sent last quarter still reads the same today. White-label portfolio reports explains what carries the firm's name on each plan.

A quick test for your current process

If the answer to any of these is "no" or "not sure", that is probably where the hours go:

• Can you add a new broker's statement without retyping it?
• Does every currency conversion in the last review name its rate and date?
• When a price is missing, does the total say so, or does it fall silently?
• Is the combined return calculated from cash flows rather than averaged?
• Could you reproduce last quarter's report exactly, today?
• Can the client see which words are yours and which figures are the system's?

Frequently asked questions

Why does a client portfolio review take so long?

Most of the time goes on preparation rather than judgement: collecting statements from several brokers, retyping or cleaning them, converting currencies, chasing missing prices, working out combined returns and formatting the report. The analysis itself is the shorter part.

Which parts of a portfolio review can be automated safely?

Reading statements, consolidating holdings, valuing them in one base currency, computing returns from cash flows and rendering the report can be automated, provided extracted data is confirmed by the adviser before it is used and unknown values stay visible as unknown. Judgement and recommendations stay with the adviser.

Does Borderfolio for Advisors write the recommendation?

No. It prepares the consolidated figures, the cross-border screen and the report. The adviser writes their own observations, which the report prints in a section labelled as adviser-authored, apart from the system analysis. It never recommends buying or selling.