Tuesday, October 19, 2010

personal finance and budgeting





It's hard to beat an excel spreadsheet for quickly shifting between a granular and top-level view of your personal finance situation. Here's reader Lauren's account balance spreadsheet she made to keep track of her expenditures, past, present, and future, and itemize her budget.



Download Lauren's Budgeter (XLS)



1. Scroll to the current month.

2. Enter your current balance in the "Starting Balance" box at the top left.

3. Enter your credits and debits on the appropriate dates they will hit your account. Use positive numbers for money getting added credits, and negative numbers for when it's getting taken away.

4. The green "Total" will change to reflect your total overall balance.



Use it as is, compare it to your own, or mod to fit your own needs.



Lauren says it's "quite nifty," and also uses it as a calendar.



Here's the excel code for the totaler for those who like to look under the hood:



TODAY();_8_10)

+SUMIF(_9_10d;"



It's hard to beat an excel spreadsheet for quickly shifting between a granular and top-level view of your personal finance situation. Here's reader Lauren's account balance spreadsheet she made to keep track of her expenditures, past, present, and future, and itemize her budget.



Download Lauren's Budgeter (XLS)



1. Scroll to the current month.

2. Enter your current balance in the "Starting Balance" box at the top left.

3. Enter your credits and debits on the appropriate dates they will hit your account. Use positive numbers for money getting added credits, and negative numbers for when it's getting taken away.

4. The green "Total" will change to reflect your total overall balance.



Use it as is, compare it to your own, or mod to fit your own needs.



Lauren says it's "quite nifty," and also uses it as a calendar.



Here's the excel code for the totaler for those who like to look under the hood:



TODAY();_8_10)

+SUMIF(_9_10d;"
internet reputation management

Dallas Morning <b>News</b> Makes Case for Rick Perry While Endorsing Bill <b>...</b>

Did you know that of Texas' budget of approximately $180 billion, over one third is sent by Texans to Washington in the form of federal taxes and.

ABC <b>News</b> Exclusive: Tea Party Candidate in Nevada Senate May Tip <b>...</b>

Scott Ashjian calls himself the “Tea Party of Nevada” candidate for US Senate, but he tells ABC News that he would be “at peace” knowing he helped re-elect Harry Reid by siphoning votes away from Sharron Angle. The Note, authored by ABC ...

Bing Exciting <b>News</b> From Bing and Yahoo! - Search Blog - Site Blogs <b>...</b>

Exciting News From Bing and Yahoo! Bing. 24 Aug 2010 9:00 AM. Comments (20). In our last update we shared that we had begun testing Bing results in Yahoo! search as we move forward with our transition. Today I am happy to share that ...



EasyFinancialPlanning.net Detail Budget by EasyFinancialPlanning.net

No comments:

Post a Comment