Tracking finances via spreadsheet

Ask your investment, budget, and other money related questions here
Post Reply
User avatar
m741
Posts: 1117
Joined: Tue Jan 18, 2011 3:31 am
Location: NYC
Contact:

Post by m741 » Wed Jul 04, 2012 5:13 am

I thought it might be useful to show how I track my finances, so I put together a blog post explaining what I do. It's a modified version of the tracking spreadsheet that akratic put together some time ago.
Comprehensive Guide to Tracking Your Finances
Here's some of the questions this spreadsheet will help you answer (lifted shamelessly from blog post):
What investment returns would you need if you wanted to retire today? What dividend stocks have posted consistent returns annually? How much did you spend last month on food? How much did you earn in dividends? At current rates, how long do you have to wait to retire? If you’re laid off, how long will you last without a job? What percent of your income have you saved each month? Is your savings rate better than last year? If you want to travel, what type of hotel costs the same as staying at home? Exactly how much do you have saved in checking accounts, safety deposits, investment accounts, your 401k? What were your big expenses two months ago?
Let me know if you have questions or suggestions. How do you track your finances?


bluepearl
Posts: 80
Joined: Sat Sep 10, 2011 6:54 pm

Post by bluepearl » Wed Jul 04, 2012 5:24 am

wow m741! thank you

I use excel to track my finances but I suspect my formulae aren't ere approved, plus my files are lacking in the visual department.
Will take a *very* detailed look this week when I take breaks at work this week... teehehe.


Christopherjart
Posts: 191
Joined: Sun Apr 29, 2012 2:03 am
Contact:

Post by Christopherjart » Wed Jul 04, 2012 3:23 pm

Thanks for the Google spreadsheet. I'm not quite ready to do extreme tracking. When I have enough to open a brokerage account, I'll definitely copy the stocks tab into my own Google spreadsheet.
Perhaps I'll understand the formulas enough to fix my own to show ERE calculations one day :-) Right now my savings = money I put in my bank account or my AFORE voluntary contributions sub account.


Fred Tracy
Posts: 106
Joined: Wed Jan 25, 2012 10:09 pm
Contact:

Post by Fred Tracy » Wed Jul 04, 2012 9:49 pm

Hmm can I change or edit categories in the FI- and itemized expenses tabs? I'm trying to add some new ones but they don't show up in the summary.


User avatar
m741
Posts: 1117
Joined: Tue Jan 18, 2011 3:31 am
Location: NYC
Contact:

Post by m741 » Sat Jul 07, 2012 12:39 pm

Sure, you can change the categories. Should be as easy as adding the category in the -FI tab and adding a row in the summary. Once you have an expense with that category on itemized expenses it should show up in the summary.
One thing to make sure of is that the greyed-out columns reflect your new category.


bluepearl
Posts: 80
Joined: Sat Sep 10, 2011 6:54 pm

Post by bluepearl » Tue Aug 21, 2012 12:47 am

hi m741
just want to say thanks about putting up the excel workbook again.
I changed the format of mine after studying yours. I used to use pivot tables (manual udpates after making any changes)
now I use sumifs statements. all updates are automated teehehe. I even changed some of my work related excel work from pivot to sumifs.
thanks.


User avatar
m741
Posts: 1117
Joined: Tue Jan 18, 2011 3:31 am
Location: NYC
Contact:

Post by m741 » Tue Aug 21, 2012 3:34 am

Glad it was helpful. Credit goes to akratic - I wasn't aware of sumifs either :).


Post Reply