Since 2013, I have started tracking my financials. It has been 8 years now and I must congratulate myself for being quite discipline doing so regularly.
My “Finance Management Excel file” includes monthly data of income, expenses, stocks bought/sold, realised profits/losses, assets owned, insurances, my total portfolio, and ultimately my net worth yoy.
In the following article, you will find screenshots of excel sheets (tabs) as my personal accountant. I have intentionally hide the $value. Still, you will be able to see the overall format and structure. Hopefully it is helpful for readers.
MONTHLY INCOME / EXPENSES
“IE21” tab shows my monthly income and expenses for year 2021, and IE20 year 2020, so on and so forth. There will be fixed income (e.g. salary) or fixed expenses (e.g. your monthly mortgage, netflix charges, hair cut etc.).
The variable expenses or income are captured daily using “Notes App” in my mobile phone not...