As a Singaporean living and working in Denmark, having bank accounts, savings and expenses both in Denmark and Singapore have made tracking my finances somewhat complicated.
Money gets transferred across geographies… I earn, save and spend across different accounts… and waters get even muddier when I no longer just keep cash in the bank, but also invest in stocks and bonds.
What are people saying?
I knew I had to keep a close eye on my finances. Quick Googling suggests these for emergency funds and holding cash:
- Emergency fund: Keep 3 to 6 months’ worth of essential living expenses in a liquid savings account.
- Portfolio cash: Limit general cash or cash equivalents to roughly 2% to 10% of your total investment portfolio unless you have a major purchase planned within 12 to 24 months.
CNBC also recommends retirement benchmarks by decades:
- Age 30: 1x your annual salary
- Age 40: 3x your annual salary
- Age 50: 6x your annual salary
- Age 60: 8x your annual salary
- Age 67: 10x your annual salary
But my numbers were everywhere in different accounts, different currencies, and they fluctuate depending on market conditions. I usually only had a hunch of how much I made and how much I spent, but nothing precise about my net-worth.
How do I get an overview of everything?
I started with a simple Excel file that slowly got more complicated. And I’m sharing a simple version of my Excel file in this post.
I’ve used it over a few years. It has kept me on my toes all this while, and I get to do extra shopping 🛍 or have a couple extra takeouts 🥡 without guilt when I can see that I (or mostly the market) have made a good month of savings.
In adult (and boring) terms, I could also start having clearer ideas and projections about when a home or big-ticket purchases become plausible, with such an overview.
The Excel file looks like this:
And it’s available ✨ here ✨
What are we looking at?
From left to right, I track my finances at the start of every month, so 12 repetitions of the same set of cells for a whole year.
From top to bottom, I start with a quick glance of all my money across my 3 accounts (2 in Denmark, 1 in Singapore), before diving into the breakdown across all these accounts.
Month-on-month savings show the savings (or losses) made from the current month to the previous month. Untouchables is money I have in my Danish pension that is not immediately available, hence the name.
I have accounts in 2 currencies, hence the SGD and DKK columns, and I eventually sum them up in DKK, since I’m financially more active in Denmark.
The Quick Overview
Each row is just the amount of money I have in each of my bank account. The green cells are where I input amounts of money, either in SGD or DKK, and they get summed up automatically in DKK in the subtotal rows.
Asset Breakdown
The breakdown gets a bit more interesting. This depends on brokerages, but the brokerage that I’m using lets me see values in different sub-accounts I have with them, differentiated by cash and positions held.
Each row represents the type of asset I have in each sub-account and the value of them. A slight complication here: I need to know the breakdown across my cash, stocks and bonds, but my brokerage doesn’t explicitly show the breakdown between the values of stocks and bonds I own.
I’ve therefore chosen to record whatever I see from my brokerage app under cash and position –where position is the sum of both stock and bond values — and then record my bonds’ value in a different row to separate them out from the stocks in the next calculations.
I then calculate the percentage breakdown of my assets for the month. From this I get to see if I’m holding too much cash based on the 3-6 months of expenses recommendation or owning too many shares for my own risk appetite.
The Rest
Month-on-month savings shows how much value in each account changed from the current month to the last month.
Untouchables describe the amount of money I have in my pension in Denmark. If I do choose to permanently leave Denmark before retirement age, I receive the money after paying taxes, hence the before and after tax rows. The last row describes the total amount of money that is mine (but also not really mine yet).
Add-ons
This file is the simplest version for how I keep an overview of all my money across different accounts and currencies. It’s a fairly simple exercise to add more rows if you have more accounts, and more columns if you deal with more currencies.
In my own copy, I’ve also tried gamifying the process. I added quarterly goals at the start of each quarter and reminders for myself how much “work” needs to be done in the next months to hit my targets.
Caveats
I’ve seen other content creators deciding to exclude unrealised gains and losses as part of their tracking. That exercise however is too cumbersome and less meaningful to me, as I still use the month-on-month movements to decide how much or less to invest.
I currently also have no debts, so I have not accounted for any.
An even better overview?
My process is still a highly manual one, and I would ideally love to have an app that can automatically tap into my bank accounts and give me a customised view of my assets. In fact, it sounds like Singapore already has one (OCBC OneView):
And it sounds amazing, with overviews not just on net-worth based on cash and stock market positions, but also insurance policies, home loans, taxes…
For the Singaporeans using the financial OneView, how is that going for you?
Is there a Danish version?
I’ve heard about the Panorama tool by Danske Bank, and it reads like it’s a financial advisory tool for them to recommend optimising asset allocation, loan structuring, future planning etc., more than a financial tracking tool just for keeping an overview.
Thoughts if you’ve used it? 🧐
In sum
I’ve been tracking my finances, the process works for me, but it could be so much better. If you’re new to the process, feel free to use the Excel file shared above. If not, I’d love to hear what your process is and if there’s something I’m missing out on, especially in the Danish context, I’d love to hear your thoughts. 🤩
bohsupremo 