Build a Simple Dashboard-Style View of Your Finances

Do you need help managing your finances and getting organized? Take a look at PT's dashboard view of his finances. It's a quick easy way to keep track of everything going on with income, bills, outstanding debt, and all online accounts

Last week I took the one-step challenge to organize my finances.

To meet the challenge, I decided to build a one-sheet, dashboard-style view of our finances. I determined it should have our personal income statement and balance sheet, as well as the account IDs and passwords associated with those accounts.

The dashboard will also provide any details about any automatic transfers or payments that I have in place. Lastly, at the bottom of the page I’d place our main financial goals. Here’s what it looks like:

one-sheet-image

This “dashboard” will allow me to see a quick view of our net worth, budget, log-in credentials for each account, and goals we’re striving for. Not only will it help me manage my finances better, it will provide a cheat sheet for Mrs. PT in the event something were to happen to me.

It’s a good idea to print out a copy and throw it in the safe.

My One Step is The First Step

Getting the big picture of your finances in front of you like this is the first step anyone should take in organizing their finances. Just like in my 10 Things series, where my first step is to “track your regular monthly expenses”. You don’t have to have your financial act together to complete this exercise. This could be your first step. Knowing where you stand is a good starting point for turning things around.

Build Your Own Financial Dashboard

While I’m not going to share my exact dashboard, I’ve built a template for you to use. It’s nothing fancy. Still, feel free to grab it, fill it with your own information, then stash it somewhere safe and secure. Share the template with your friends too. The login credential area is shaded grey so it’s a bit harder to read for someone standing over your shoulder.

one-sheet-image

Download Copy of Financial Dashboard (.xls)

Download Copy of Financial Dashboard (.ods)

Of course, life changes all the time, so your financial statements will only be accurate for a short time. Consider adding the dashboard to your jump/flash drive or your Google Documents account so you can periodically update them.

Good luck and let me know if you have any questions on editing your dashboard.

Avatar About Philip Taylor, CPA

Philip Taylor, aka "PT", is a CPA, blogger, podcaster, husband, and father of three. PT is also the founder and CEO of the personal finance industry conference and trade show, FinCon.

He created Part-Time Money® back in 2007 to share his advice on money, hold himself accountable (while paying off over $75k in debt), and to meet others passionate about moving toward financial independence.

Comments

    Speak Your Mind

    *

  1. Hi, I just found your site. I just found a website that does this for you the other day called mint.com. It works like Microsoft Money or one of those types of programs in that it will show your balances in all your banking accounts, retirement accounts, etc. It ever helps you keep track of your net worth by adding in the value of things like your home and vehicles and taking away debts such as credit cards. As long as you feel comfortable using a third-party website to watch all your bank accounts (they use bank level encryption to keep your passwords and account numbers safe), it’s a great thing because it’s free! They’ll even give you month by month budget advice.
    Phew, sorry for that long first post. I’d never heard of mint.com before last week but it’s been easy to use so far, and no trouble with my accounts yet.

  2. @Mary – Widen the column and you’ll see that “tic?” becomes “Automatic?”. The column just needs to be widened. 😉

    Oh, and by automatic, I mean, is the bill being paid automatically each month without me doing anything.

  3. I’m really late in finding this spreadsheet so I hope you’re still taking comments. What does the “tic?” mean to you?

    Otherwise, I LOVE this. I’ve been resolving to do something for years, but this makes it simple. Thanks for sharing.