Friday, September 24, 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;"



  • CEDIA: LG, JVC and Sony debut LCoS-based 3D front projectors



  • BMW ActiveE electric car - Consumer field trials to begin next summer



  • Five insider shopping tips for Gordon Gekko



  • Daily Dispatch: Google NEW lists updates of all its products; Survey reveals people prefer colonoscopies to computer maintenance



  • 2010 Distracted Driving Summit: What’s next for combating driver distractions?



  • What's the deal with car tire pricing?



  • Q&A: Short on salt



  • Daily electronics deals



  • 6 painless ways to cut your grocery bill



  • Go green for school supplies






big white booty iowa

<b>News</b> - Lindsay Lohan &quot;Demure and Quiet&quot; as She Arrived at Jail <b>...</b>

Like her previous stints in the slammer, she'll be kept away from other inmates in a 12x9 cell.

Diane Sawyer: ABC World <b>News</b> Goes Home: Looking for What Works in <b>...</b>

We at ABC's World News are heading out to search for innovative ideas that are helping turn the economy around. Real change is often born out of a simple act. And one ripple can lead to a powerful transformation.

Tax The Rich! (9pm Saturday on Fox <b>News</b> Channel) « John Stossel

In my weekend special, The Battle for the Future -- it airs Saturday at 9pm and Sunday at 8 PM and.


<b>News</b> - Lindsay Lohan &quot;Demure and Quiet&quot; as She Arrived at Jail <b>...</b>

Like her previous stints in the slammer, she'll be kept away from other inmates in a 12x9 cell.

Diane Sawyer: ABC World <b>News</b> Goes Home: Looking for What Works in <b>...</b>

We at ABC's World News are heading out to search for innovative ideas that are helping turn the economy around. Real change is often born out of a simple act. And one ripple can lead to a powerful transformation.

Tax The Rich! (9pm Saturday on Fox <b>News</b> Channel) « John Stossel

In my weekend special, The Battle for the Future -- it airs Saturday at 9pm and Sunday at 8 PM and.


big white booty

<b>News</b> - Lindsay Lohan &quot;Demure and Quiet&quot; as She Arrived at Jail <b>...</b>

Like her previous stints in the slammer, she'll be kept away from other inmates in a 12x9 cell.

Diane Sawyer: ABC World <b>News</b> Goes Home: Looking for What Works in <b>...</b>

We at ABC's World News are heading out to search for innovative ideas that are helping turn the economy around. Real change is often born out of a simple act. And one ripple can lead to a powerful transformation.

Tax The Rich! (9pm Saturday on Fox <b>News</b> Channel) « John Stossel

In my weekend special, The Battle for the Future -- it airs Saturday at 9pm and Sunday at 8 PM and.



Quizzle is going green - sign up to find out how green you are and get a free credit report! by QuizzleTown







Quizzle is going green - sign up to find out how green you are and get a free credit report! by QuizzleTown






























No comments:

Post a Comment