As I have access to evaluation tools with the biggest database in Switzerland (Wüest & Partner) I could potentially make new evaluation every month. Then subtract the current mortgage of it and get the new value.
The issue is: We paid 110k less than the current market value (880k). I see 2 options:
Track it as it is and increase my net worth directly by the current gain.
Set the buying price as the base (770k) and change it relative (%) to the further increase. So if it goes from 880k to 920k (+4.55%), then increase the value from 770k to 805k.
Personally, I only consider liquid assets (cash, investments, 3a, crypto, etc), and leave out anything that has a “negotiations” value (car, watches, real estate, etc).
If I were to take into account the value of my real estate, I would calculate:
Value at appraisal (at the conclusion of the mortgage) - Mortgage = current value.
However, I would re-evaluate the value of the property every year according to the appreciation/depreciation. I don’t see the need to keep the value of a property up to date, I can live with an annual revaluation (my opinion).
In your case, I will take into account the market value.
I don’t track the market value as long as there is no intention to sell. I just add the amount of the Erneuerungsfond to be a bit less conservative.
If I would consider the market value, I would then deduct or add a separate line for the
Grundstückgewinnsteuer (real estate gain tax), as it will anyway be due. Amount to be updated every year
Excel sheets or Google sheets.
YNAB is a good (but paid) alternative.
I tried Toshl, don’t like the way credit card are tracked.
Spendee seems to be a good alternative and a little cheaper than YNAB.
I can highly recommend Portfolio Performance, it’s free and you can configure automatic price feed from Yahoo Finance and other sources.
There’s only one security for which I update the price manually once a month.
If you use VIAC, there’s a built-in import tool that can consume the PDF statements from VIAC and automatically generates the transactions. Works perfectly fine for me with 4 VIAC accounts, which would be a nightmare if I had to do it manually.
I use a custom Python script which gets stock prices and currency conversion rates from yahoo finance. It initially started as a list containing the value of my assets in CHF and grew over the years.
I can confirm that Portfolio Performance (PP) is very useful. It has a steep learning curve and requires an initial investment to set it up. But then it’s fantastic to track all kinds of assets.
You can import bank and buy/sell statements from many banks automatically. A list of covered institutions is available in the PP forum.
Bear in mind that the creator of PP and most of the user base are German, so most institutions are relevant for German investors. But many banks and brokers that are important for Swiss investors are covered, as well, e. g. Swissquote, UBS, and Postfinance.
For other accounts, e. g. current accounts, I’ve created VBA scripts to convert the bank statement (available as csv file) into something that PP can import. I’m not really good at script writing, so anyone familiar with VBA should be able to do it. If anyone is interested how that works, please send me a private message.
Factors that may be more or less important to you:
Free, can be used for private and commercial purposes
Good and active support by the creator and a forum, also in English
Data is on your own computer only (good if you’re apprehensive about sensitive data in the cloud)
Standalone program for Windows, Mac and Linus, but no mobile app and not accessible via web interface
Parqet is a relatively new competitor and has a free but restricted and two paid pro versions for ~90/330 EUR per year. I’ve just played around with a time limited premium membership and find it very interesting: Nice interface, drag and drop import of documents, good breakdown of your assets, mobile app available. To the best of my knowledge, the program is only available in German. I’m not tempted to switch from PP.
The same seems to apply to Rentablo, but I haven’t tried this one yet.
You can run Portfolio Performance in a Docker container and then access it through a browser. You can even expose it to the Internet and access ot from anywhere. I had this setup running in the past, but realized that I don’t really need it.
It is also possible to store the PP data files in a cloud e.g. Onedrive and then you can access them from every computer with PP running on it (not via smartphone - there is no mobile app). Whether you want to store your financial information online is up to you though…
I use an antique program named Quicken for managing all our assets. I’d love to upgrade to something more current but really want it off the internet to avoid data fraud. That said, the old Quicken program is not intuitive but it does a good job.
By reading and partipating to this forum, you confirm you have read and agree with the disclaimer presented on http://www.mustachianpost.com/
En lisant et participant à ce forum, tu confirmes avoir lu et être d'accord avec l'avis de dégagement de responsabilité présenté sur http://www.mustachianpost.com/fr/
Durch das Lesen und die Teilnahme an diesem Forum bestätigst du, dass du den auf http://www.mustachianpost.com/de/ dargestellten Haftungsausschluss gelesen hast und damit einverstanden bist.
More info as usual on my blog: