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
BREAKING <b>NEWS</b>: Bears release Mark Anderson; sign Charles Grant <b>...</b>
BREAKING NEWS: Bears release Mark Anderson. ... Fantasy Football Breaking News Click Here � H&S Torain � NFL Fantasy Football Waiver Wire, Week 5: Ryan Torain In Line For Carries � Photo � Fantasy Football Projections Week 5: Top Five ...
Fox <b>News</b> poll: Angle by three in Nevada, Raese by five in West <b>...</b>
A new Fox News battleground state poll on the race for the seat held by the late Sen. Robert Byrd for 51 years shows Republican businessman John Raese with a 5-point lead over Democratic Gov. Joe Manchin among likely voters — 48 percent ...
UT <b>News</b> » Internet Marketing Conference set for Oct. 12
UT News » Internet Marketing Conference set for Oct. 12 Is Paying For Directory Listings a No-No? – Find friends or hook-up tonight | Find Friends or Hook Up Tonight! Says: October 5th, 2010at 10:41 am. UT News » Internet ...
robert shumake
BREAKING <b>NEWS</b>: Bears release Mark Anderson; sign Charles Grant <b>...</b>
BREAKING NEWS: Bears release Mark Anderson. ... Fantasy Football Breaking News Click Here � H&S Torain � NFL Fantasy Football Waiver Wire, Week 5: Ryan Torain In Line For Carries � Photo � Fantasy Football Projections Week 5: Top Five ...
Fox <b>News</b> poll: Angle by three in Nevada, Raese by five in West <b>...</b>
A new Fox News battleground state poll on the race for the seat held by the late Sen. Robert Byrd for 51 years shows Republican businessman John Raese with a 5-point lead over Democratic Gov. Joe Manchin among likely voters — 48 percent ...
UT <b>News</b> » Internet Marketing Conference set for Oct. 12
UT News » Internet Marketing Conference set for Oct. 12 Is Paying For Directory Listings a No-No? – Find friends or hook-up tonight | Find Friends or Hook Up Tonight! Says: October 5th, 2010at 10:41 am. UT News » Internet ...
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;"
No comments:
Post a Comment