Vanguard UK Portfolio Tracker: See Your Vanguard Funds Alongside Everything Else

Vanguard's UK platform is deliberately simple: you can only hold Vanguard's own funds and ETFs, the account page shows what they are worth, and the cost is low. For a lot of investors that is the whole point. The gap appears when Vanguard is not your only account. A LifeStrategy fund in a Vanguard SIPP, a global tracker ETF in a Vanguard ISA, plus individual shares at another broker, is a very common UK portfolio, and nothing on the Vanguard site shows it as one thing. A Vanguard UK portfolio tracker is really a question of getting your Vanguard data out and combining it with everything else. This guide covers the export, its one quirk, and what the combined view tells you.

What the Vanguard Account Page Leaves Out

• Only Vanguard. By design, the platform shows Vanguard holdings and nothing else. If half your wealth is in individual shares elsewhere, your true asset allocation is invisible.
• No benchmark for your mix. Each fund tracks its index, but the account page does not tell you how your particular combination of funds has performed against a single simple alternative.
• Income as transactions. Distributions from income units and ETFs appear as cash events, not as an income history by month.
• No look-through. A global tracker and a US tracker overlap heavily. The account page cannot tell you how much of your portfolio is really in US large-cap technology once the funds are added up.

How to Export Your Vanguard UK Transaction History

Vanguard has no API, and the export is a download from the website.

• Log in at vanguardinvestor.co.uk.
• Go to My Portfolio, then Transaction History.
• Set the date range to cover all of your purchases and choose the account (ISA, SIPP, general account or Junior ISA).
• Choose Download as Excel.
• Open the file and, if the tool you are using wants a CSV, save it as CSV. Openbook reads the Excel file (.xlsx) directly, so no conversion is needed there.

The file lists each transaction with the date, the fund or ETF name, the quantity of units or shares, the price and the amount. Vanguard prices are in pounds, so there is no pence conversion to worry about, unlike most UK share-dealing platforms.

Skip the spreadsheet

Import your Vanguard export straight into Openbook

Upload the Excel file as it downloaded. Openbook works out which column is which, keeps prices in pounds, matches each fund or ETF by name with a picker to confirm, and shows you what it read before anything is saved.

Import your portfolio →

The One Quirk: Matching Funds by Name

Vanguard ETFs such as the FTSE All-World (VWRL), FTSE 100 (VUKE) and S&P 500 (VUSA) have tickers and match cleanly. Vanguard's OEIC funds, including the LifeStrategy range and the index funds, do not carry a ticker in the export. They have to be matched by name, and because most of them exist in income and accumulation versions, the name is the thing to check: "Vanguard LifeStrategy 80% Equity Fund Accumulation" is a different holding from the income version, with a different price. Any tool you use should let you confirm the match rather than guess. In Openbook the preview shows the name it read and the fund it matched, with a search to correct it before anything is saved.

Building a Vanguard Spreadsheet

For a Vanguard-only portfolio, a spreadsheet is genuinely manageable: a handful of funds, prices in pounds, and no ticker conversions. Paste the export, enter sells as negative quantities, sum units by fund with a pivot table, and add a price lookup for current value. Distribution rows pivoted by month give an income history for income units.

The limit is not the Vanguard data; it is everything else. As soon as you want the Vanguard funds alongside shares held at Hargreaves Lansdown or AJ Bell, with a single benchmark and a single view of concentration, the spreadsheet becomes a second job. Our guide to portfolio trackers for UK investors is honest about where that line falls.

What the Combined View Shows That Vanguard Cannot

• Your whole portfolio in one place. Vanguard funds next to individual shares and ETFs from other brokers, with one total and one allocation.
• Performance against a single benchmark for the whole thing, so you know whether adding individual shares to a fund core has helped or hurt.
• Income by month and by holding, with yield on cost. Our dividend tracker guide covers the income side in detail.
• Concentration by sector, country and company once fund holdings are looked through, so overlapping trackers stop hiding how much of the portfolio is in the same few names.
• Reward and Risk on the shares you hold elsewhere. Openbook scores UK and US-listed companies on Growth, Momentum, Profitability and Valuation for Reward, and Volatility, Financial Solvency, Operational Quality and Size for Risk, which is the check that tells you whether the individual holdings you have added around a Vanguard core deserve their place. The methodology explains each factor.

No card required

Set the whole picture up once

Create a free Openbook account, import your Vanguard accounts and your other brokers' exports, and see everything you own as one portfolio. Re-import when you deal and it updates.

Create a free account →

Fund Overlap: Why Look-Through Matters

The most common Vanguard UK portfolio is not one fund but three or four that overlap heavily: a global all-cap tracker, an S&P 500 ETF, a LifeStrategy fund, perhaps a FTSE 100 ETF. On the account page these look like four diversified holdings. Looked through to the companies they hold, the picture is different. A global tracker is already well over half US shares, and its largest positions are the same handful of US technology companies that dominate the S&P 500 ETF sitting next to it. Add a LifeStrategy fund, which holds Vanguard's own US and global trackers inside it, and the same companies appear a third time. The result is a portfolio that is far more concentrated in US large-cap technology than its owner intended, with a FTSE 100 ETF doing less to balance it than it appears.

None of this makes any of the funds a bad choice. It means the allocation you actually have is not the one the account page shows, and the only way to see it is a look-through of the funds to their holdings, added up across accounts. That is a screen in a tracker and a research project in a spreadsheet.

Regular Monthly Investing and Average Cost

Most Vanguard UK investors buy monthly by direct debit, and the export shows it: one purchase row per fund per month, at that month's price, for as long as you have been investing. A file with several hundred rows is normal. It is also exactly what a true average cost needs. A tracker nets the lots into one position per fund with the average price you actually paid, and shows your gain against that rather than against the latest purchase. There is nothing to tidy before importing; the long file is the good version.

Common Problems with Vanguard Exports

• The file is .xlsx and the tool wants .csv. Open it in Excel and save as CSV; Openbook takes the .xlsx directly. The older .xls format is not supported by most tools, so re-save as .xlsx or .csv if you have one.
• A fund matched to the wrong version. Check income versus accumulation in the preview.
• Regular monthly purchases make a long file. That is fine. Each row is a lot, and the tracker nets them into one position per fund with your true average cost.
• Several accounts. Export each and import them one after another; they combine in the portfolio view.

Taking Your Vanguard Analysis Further

The point of getting Vanguard data out is to see the portfolio you actually have, not the slice of it that one platform can show. Whether your individual shares have added anything over a plain global tracker, how much overlap your funds carry, and how much of your income depends on a few payers become quick checks once everything is in one place. If you hold accounts elsewhere, the same import takes Hargreaves Lansdown, AJ Bell, interactive investor and Trading 212 files. Our guide on tracking investment performance covers the measures worth watching once it is there.

Next step

See your Vanguard funds alongside everything else

One portfolio, one benchmark, income by holding and a Reward and Risk score on every share you hold outside Vanguard. Bring the export; the rest is done for you.

Open your portfolio →

You can Compare VWRL, VUKE, VUSA side by side on Openbook, or find stocks with the screener.