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;"
robert shumake
Knight Science Journalism Tracker » Blog Archive » Science <b>News</b>: A <b>...</b>
Science News's enterprising reporter Ron Cowen got it after he looked through the program and abstracts of the Amer. Astronomical Assoc's Division of Planetary Sciences meeting underway in Pasadena. He saw a session devoted to the birth ...
Apple Store <b>news</b>: Openings in Chicago and Edinburgh
It's all about software ergonomics � Pulse News Reader for iPad 2.0: More sources, better organization � TUAW Giveaway: Win a subscription to Slacker Radio Plus for Austin City Limits Music Festival � Nation rejoices as Consumer Reports ...
Bill & Melinda Gates Sponsoring ABC <b>News</b> Health Coverage
NEW YORK — ABC News is announcing a yearlong project to focus attention on the diseases and health conditions that afflict the world's poorest people. The series, "Be the Change: Save a Life," will begin in December and continue through ...
robert shumake
Knight Science Journalism Tracker » Blog Archive » Science <b>News</b>: A <b>...</b>
Science News's enterprising reporter Ron Cowen got it after he looked through the program and abstracts of the Amer. Astronomical Assoc's Division of Planetary Sciences meeting underway in Pasadena. He saw a session devoted to the birth ...
Apple Store <b>news</b>: Openings in Chicago and Edinburgh
It's all about software ergonomics � Pulse News Reader for iPad 2.0: More sources, better organization � TUAW Giveaway: Win a subscription to Slacker Radio Plus for Austin City Limits Music Festival � Nation rejoices as Consumer Reports ...
Bill & Melinda Gates Sponsoring ABC <b>News</b> Health Coverage
NEW YORK — ABC News is announcing a yearlong project to focus attention on the diseases and health conditions that afflict the world's poorest people. The series, "Be the Change: Save a Life," will begin in December and continue through ...
robert shumake
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;"
robert shumake
Knight Science Journalism Tracker » Blog Archive » Science <b>News</b>: A <b>...</b>
Science News's enterprising reporter Ron Cowen got it after he looked through the program and abstracts of the Amer. Astronomical Assoc's Division of Planetary Sciences meeting underway in Pasadena. He saw a session devoted to the birth ...
Apple Store <b>news</b>: Openings in Chicago and Edinburgh
It's all about software ergonomics � Pulse News Reader for iPad 2.0: More sources, better organization � TUAW Giveaway: Win a subscription to Slacker Radio Plus for Austin City Limits Music Festival � Nation rejoices as Consumer Reports ...
Bill & Melinda Gates Sponsoring ABC <b>News</b> Health Coverage
NEW YORK — ABC News is announcing a yearlong project to focus attention on the diseases and health conditions that afflict the world's poorest people. The series, "Be the Change: Save a Life," will begin in December and continue through ...
No comments:
Post a Comment