# How to keep track of your Net worth
**URL:** https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818
**Category:** Uncategorized
**Created:** [December 1, 2020, 9:01am UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818 "2020-12-01T09:01:45Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@ddosh](https://forum.mustachianpost.com/u/ddosh)
#### Post date: [December 1, 2020, 9:01am UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/1 "2020-12-01T09:01:45Z")
Hey all
I want to keep track of my wife’s and my net worth… how do you do it? For us it would be:
- Investments on IB
- Investments on Selma (might delete this in the future)
- Investments on Swissquote (might delete this in the future)
- Several 3a Pillars (Frankly / VIAC)
- Second Pillar
- Cash
- Real Estate (our flat, if that somehow can be considered as net worth?)
Thanks!
---
### Author:  [@rolandinho](https://forum.mustachianpost.com/u/rolandinho)
#### Post date: [December 1, 2020, 9:23am UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/2 "2020-12-01T09:23:27Z")
I think you mean “my wife’s and my”, else it means something else 😉 and you could get problems with the authorities.
(Please excuse the grammar correction, it is only because the “mistake” makes it kinda funny)
To your question, I use Google Sheets, the shares are updated automatically realtime, but I only do an annual sum of everything.
---
### Author:  [@Leap](https://forum.mustachianpost.com/u/Leap)
#### Post date: [December 1, 2020, 9:28am UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/3 "2020-12-01T09:28:57Z")
I use an Excel-sheet where I record the NAV of my different platforms at the end of each month.
For the tracking of different investments over multiple platforms I use PortfolioPerformance. Not sure about real-estate, but the rest should be easily configurable.
---
### Author:  [@chca](https://forum.mustachianpost.com/u/chca)
#### Post date: [December 1, 2020, 9:35am UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/4 "2020-12-01T09:35:29Z")
Google sheets. I think this is by far the most popular choice.
For most stocks/ETFs you can have values updated near-live if you want using `=GOOGLEFINANCE()`. And you can integrate little spark charts that fill single cells, e.g.: a little unlabelled line chart of past year’s performance of VWRL on the Amsterdam exchange: `=sparkline(query(googlefinance("AMS:VWRL", "price", today()-365, today()), "select Col2 label Col2 ''", 1))`
Personally, I have a tab for each bank/broker I use + an “other” tab for simple things (pending reimbursements, rental caution, etc.). I use and update manually every month. This forces me to log into each of my accounts and stay on top of things.
---
### Author:  [@MrCheese](https://forum.mustachianpost.com/u/MrCheese)
#### Post date: [December 1, 2020, 10:31am UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/5 "2020-12-01T10:31:08Z")
I use Google sheets plus [beancount](https://forum.mustachianpost.com/t/beancount-getting-started/2701) for the expense/income/networth tracking.
---
### Author:  [@kilyn](https://forum.mustachianpost.com/u/kilyn)
#### Post date: [December 1, 2020, 11:40am UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/6 "2020-12-01T11:40:02Z")
You already have to compute and declare your net worth every year with tax declaration. Do you really need more than one data point a year? I tried gnucash then beancount but honestly it’s a lot of hassle for little extra benefit.
---
### Author:  [@Guillaume\_GVA](https://forum.mustachianpost.com/u/Guillaume_GVA)
#### Post date: [December 1, 2020, 12:02pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/7 "2020-12-01T12:02:26Z")
Hi,
I took inspiration from MrRip and created a Google Sheet that I fill in quarterly.
It includes:
- Investments
- 3a Pillars
- 2nd Pillar
- Cash
- Crypto
Assets are splitted between :
- Alternatives (Real Estate, Gold, Private Equity, Hedge Funds)
- Bonds
- Stocks
- Cash
- Crypto
I have a basic allocation between currencies. For simplication purpose, I consider the 2nd pillar and 3A as invested 100% in CHF.
---
### Author:  [@Cortana](https://forum.mustachianpost.com/u/Cortana)
#### Post date: [December 1, 2020, 12:27pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/8 "2020-12-01T12:27:08Z")
I started with Excel from Office365 but switched to Google Sheets a couple of months ago. “Live” data from all my investments, including Viac and ValuePension.
---
### Author:  [@cruzandmore](https://forum.mustachianpost.com/u/cruzandmore)
#### Post date: [December 1, 2020, 12:44pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/9 "2020-12-01T12:44:09Z")
How did you configure your Google Sheets File? Can you send me a Tutorial or something to have a look? Thanks 🙂
---
### Author:  [@Stach](https://forum.mustachianpost.com/u/Stach)
#### Post date: [December 1, 2020, 1:58pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/10 "2020-12-01T13:58:00Z")
> [@Cortana](#):
>
> “Live” data from all my investments, including Viac
Does Google offer a API to include Live Data from Viac or how do you make that work?
---
### Author:  [@Cortana](https://forum.mustachianpost.com/u/Cortana)
#### Post date: [December 1, 2020, 3:39pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/11 "2020-12-01T15:39:06Z")
I’m using the data from morningstar. You can import it with some formulas.
---
### Author:  [@ToTcH](https://forum.mustachianpost.com/u/ToTcH)
#### Post date: [December 1, 2020, 3:39pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/12 "2020-12-01T15:39:27Z")
As a general question, why do you guys update it every month? Is that because you realocate your ressources to keep a similar split between your assets year round or is it only out of curiosity?
---
### Author:  [@Patirou](https://forum.mustachianpost.com/u/Patirou)
#### Post date: [December 1, 2020, 3:42pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/13 "2020-12-01T15:42:01Z")
For me it is just data addiction 🤪
I guess it is just a way to cope with the loss of control of going to the stock market, as well as a motivational thing.
I was tempted to do it daily for a while…
---
### Author:  [@dbu](https://forum.mustachianpost.com/u/dbu)
#### Post date: [December 1, 2020, 4:09pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/14 "2020-12-01T16:09:59Z")
> [@Patirou](#):
>
> For me it is just data addiction 🤪
Same here.
I mean I even track my car’s gas fill-ups etc. 🤣
And I analyze expenses on a monthly basis, so it’s only logical to me to do the same for the rest of assets.
But it’s mostly because I enjoy it. 🙂
On the other hand I appreciate there might be serenity in yearly / quarterly views only.
---
### Author:  [@Neville](https://forum.mustachianpost.com/u/Neville)
#### Post date: [December 1, 2020, 4:27pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/15 "2020-12-01T16:27:48Z")
> [@dbu](#):
>
> I mean I even track my car’s gas fill-ups etc.
Glad to know I’m not the only one! 😬
Then I calculate to overall mileage to the second decimal place. And tell my girlfriend “hey, you know what, we have a fuel consumption of x.yz L/100km”. And she goes “uhm, ok, nice, well done”.
---
### Author:  [@Cortana](https://forum.mustachianpost.com/u/Cortana)
#### Post date: [December 1, 2020, 4:38pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/16 "2020-12-01T16:38:02Z")
Investing is boring, tracking it is fun.
---
### Author:  [@clon](https://forum.mustachianpost.com/u/clon)
#### Post date: [December 1, 2020, 4:50pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/17 "2020-12-01T16:50:55Z")
As mentioned above: [https://www.portfolio-performance.info/](https://www.portfolio-performance.info/)
---
### Author:  [@dbu](https://forum.mustachianpost.com/u/dbu)
#### Post date: [December 1, 2020, 4:58pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/18 "2020-12-01T16:58:34Z")
You can tell her you can even guess how much your consumption will be if you drive more on the motorway 😁.
Enough offtopic now from me. 🙂
---
### Author:  [@xorfish](https://forum.mustachianpost.com/u/xorfish)
#### Post date: [December 1, 2020, 5:43pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/19 "2020-12-01T17:43:10Z")
> [@clon](#):
>
> [https://www.portfolio-performance.info/](https://www.portfolio-performance.info/)
Just discovered it as well, the import feature is pretty strong, you can import activity statements from IB, pdfs from viac and the transaction csv from finpension.
It only missed the transfer from another 3a account to viac.
---
### Author:  [@xorfish](https://forum.mustachianpost.com/u/xorfish)
#### Post date: [December 1, 2020, 6:13pm UTC](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818/21 "2020-12-01T18:13:09Z")
It added the ISIN.
You can get the quotes by selecting VIAC/CS Funds in the tab historical quotes and add the feed URL:
`https://amfunds.credit-suisse.com/ch/de/institutional/fund/history/`
I did the same for my finpension funds, just be careful that you really get the right fund.
[Next page](https://forum.mustachianpost.com/t/how-to-keep-track-of-your-net-worth/4818.md?page=2)