https://imgur.com/gallery/xJle22e
My personal finance dashboard I made in excel. I track every penny I spend and have automated the process using simple VBA code and macros.
Its very informational for me and helps me plan/budget quite effectively.
Just wanted to share, think its something everybody should do.
Edit!
thought i should ad some extra description.
the buttons on the right perform specific functions.
Adjust screen - adjusted the screen to fit the dashboard to whatever computer you happen to be viewing on.
Backup Data - creates a backup copy of the file and stores it in a separate location on my personal computer (would like to have this store externally also).
Insert Spend - opens a template where i can insert an amount i have spent on a specific item from a specific category (https://imgur.com/gallery/9dGKN9l)
Insert Grinds - i give private math tuition and i keep track of this by inserting the income here.
This is the database the spending macro insert information into (https://imgur.com/gallery/ET8l2Ao)
I also work as an engineer since i finished college a few months ago and my salary income cannot be seen on the dashboard, there is a separate sheet where i manage cashflow.
Submitted October 12, 2018 at 11:38AM by jamiee_w https://ift.tt/2yhb6sr
