The Lemon Fool

Vanguard has published the Excess Reportable Income numbers for this financial year, but they have made it especially hard this time. Here is the tax information page:

https://www.vanguardinvestor.co.uk/inve ... nformation

For the current financial year (FY 2021-22) we need: VF Plc Excess Reportable Income: 30 June 2022.

That downloads as a mysterious file named: Vanguard_Funds_Plc_ERI_30_06_22.xlsx

Double clicking it opened a horribly confusing window. It turned out that .xlsx is a nasty Microsoft spreadsheet format, which had opened in LibreOffice Calc. The relevant information for VFEM was way out to the right, with Page 4 written over it in huge letters. (I do not know how to fix that.)

Thanks very much Vanguard. Please can we have a legible pdf again next time. Ideally one that Google can find.

It turned out that .xlsx is a nasty Microsoft spreadsheet format, which had opened in LibreOffice Calc.

To be fair xlsx is the current file format for Excel spreadsheets, the most common, easily readable format, you can open it with Excel, Libre office, Apple's Numbers program or many others including Googles Sheets.

There is a free Excel viewer program from Microsoft, in Excel if you switch to page layout view the large "Page Number" overwriting vanishes.

I suspect the ubiquitous nature of the XLSX format is seen as easy as PDF and it would be sensible option, but having the data in Excel format does allow you to use the data in your own fashion, if you wanted to scrape data for example.

There is no page layout view in LibreOffice Calc, but if I select Normal in place of Page Break at the top of the View menu, the page numbers go away and the spreadsheet becomes much more readable.

If I'm reading this correctly, there is no ERI in VEVE (ISIN IE00BKX55T58) above the dividend distributions?

DrFfybes wrote:If I'm reading this correctly, there is no ERI in VEVE (ISIN IE00BKX55T58) above the dividend distributions?

That is right. A lot of them have got off Scot free this time.