Centralizing investment information in one location

Hi everyone!

Quick question: how do you keep track of your investments if they're done on different platforms and asset classes?

I currenlty have a portfolio of cash, ETFs, realestate, and P2P loans, and I'm finding it difficult to have the whole thing on one dashboard where I can see the overall progression, % of distribution, etc.

I am trying to add data from several data sources (mostly CSV files exported from banks, P2P services) and import them into selfhosted applications (ghostfolio, maybe budget, actual) but the results are lackluster: all CSV files have to be cleant before import (e.g. movements on files from P2P services have to be analyzed and categorized one-by-one to ensure nomenclature consistency accross services, etc) and this is very time consuming.

How do you yourselves solve this problem? How do you centralize this data in the least work-intensive way possible?