visit tracker on tumblr
21 Days To Rock Your Finances: Day 3- Track Every Penny Because Every Dollar Has A Job

21 Days To Rock Your Finances: Day 3- Track Every Penny Because Every Dollar Has A Job

We’re now on Day 3 of Rock Your Finances.  By now you should have

  1. Created A 1 Year Financial Plan
  2. Identified Your Financial Weaknesses

Today we’ll be discussing how to track every penny that comes in and out of your account.  This is the only way that you’ll gain some insight on where your money has been and what it’s been up to.  What’s even better is that you’ll see how your spending habits have caused you to miss out on saving more or paying down debt.

Track Every Penny.  Every Dollar Has A Job

Yodlee or Mint

My favorite way to do this is to aggregate all of my financial accounts into Yodlee or Mint.  Once everything has been uploaded, I’m able to see all of my income and expenses broken down in a pie chart with each section containing the related expenses.  Here’s a breakdown from Moneycrashers:

Creating a Yodlee account is extremely simple and straightforward. You will need to select a user name and password, answer a few personal questions for security purposes, and you’re off!

 

Yodlee MoneyCenter allows you to upload accounts of any and every variety: checking, savings, investments, loans, 401k, pensions, credit cards, and any other account type you may have. You will need to enter your previously-existing online user name and password at each institution to properly add those accounts to your Yodlee account. As long as you can access your information online, you should have no issue adding your existing accounts.

 

Budgeting Tools
The budgeting tools at Yodlee include a monthly budget goal tracker where you can see how much you spend in different categories and set up long-term financial goals for those budget categories. There’s also a specific goal savings tool, a cash flow analysis, and a credit card utilization chart. If all of these are used in conjunction with one another, they add up to one heck of a budget tracking program.

With all of this information at your disposal for free, you should have no reason to avoid putting your finances in order any longer.

Spreadsheets Are Your Friend

If you’d prefer a spreadsheet there are several out there that will enable you to do this, however you’ll need to track your spending closely with this method.   I have friends that truly track every penny using a spreadsheet so it can be done.  Here are a few of my favorites:

In Donnie’s post, Budgeting with Google Docs, I found this awesome and well designed spreadsheet which breaks everything down by pay period.  The best part about this spreadsheet is that it calculates what’s left over as you load your expenses.  This is key information for those who need to know how much money they can blow once all bills are paid.  This helps you avoid nasty bank overdraft fees or that embarrassing trip to the restaurant where the waiter returns your card because it’s been declined.

Grab a copy here!

 

Myexceltemplates.com created this personal bi-weekly budget template lets you keep track of your bi-weekly income and expense according to your pay schedule.  I personally use a hacked version of this spreadsheet in addition to Yodlee which helps me track all expenses, income and any monies left over without a job or purpose.

http://www.myexceltemplates.com/wp-content/uploads/2009/12/Bi-weekly-Budget.jpg

 

Budgets Are Sexy, as always has a great resource of several budgeting templates, one of which I’m sure will suit your needs:

 


“Financial Snapshot & Budget” @ Budgets Are Sexy
Google Doc | Excel | Example (filled in) | More details

A colorful and easy way to track your budget and overall Financial Snapshot! Room to budget per paycheck, detail your net worth (if you want), credit card balances, savings funds, total income, and an extra budget just in case.

What’s Next?

Once you’ve reviewed the options above, set aside some time today to load your income and expenses over the last 30 days.

  1. Choose a month that doesn’t have random expenses as with Thanksgiving or Christmas (extra high grocery bills anyone?  Christmas gifts much?).
  2. Review the transactions and categorize them accordingly
  3. Review your splurges and think about how best to use that money during the next pay period
  4. Set up your budget within realistic limits and expectations.  If you’ve been spending $600 per month eating out then you may need to ramp that down to $300 this month and then $150 next month.  Going cold turkey rarely teaches discipline.

Be patient during this process.  It’ll be challenging to look at where your money has been over the last few months but you’ll have a sense of relief because now you know better and you can start all over now.

 

What’s your favorite budgeting tool?  Spreadsheets or an account aggregation system?

 

About the Author

GingerGirls Just Wanna Have Funds is a personal finance website dedicated to educating and empowering women in the area of personal finance. Our articles center on money management: making it, saving it and growing it which supports our theme: Breaking Financial Ceilings One Stiletto At A Time. We have been featured in Business Insider (contributor), Lifehacker, Consumerist, MSNBC, Essence, Wall Street Journal, Good Morning America and MSN Project Engage Web Series. I believe in a future where women can have financial freedom and choose the life they want to live by taking control of their finances. You only need to want it hard enough while letting go of limiting beliefs around money. Join me as I share tips that will help you light up your financial life and take control.View all posts by Ginger →

  • EmptyNestExpat

    I use Quicken.  Love it!

  • Anonymous

    Ok this is a really weird coincidence.  I use yodlee and google documents to track all my expenses..   Hmm… seems like we have a lot in common

    • Anonymous

      LOL! You’re right. I don’t know anyone else that uses Yodlee and a spreadsheet. Seems like overkill for some but the spreadsheet give me what Yodlee doesnt and Yodlee gives me the drilled down detail that the spreadsheet can’t.

      • Anonymous

        Yodlee gives me the transaction data I need.  The spreadsheet is just so easy to manipulate and easy to use.  I never liked yodlee or mint’s budgeting function

        • Anonymous

          Same here. Doesn’t click or make sense for me.

  • Ellex

    I downloaded J. Money’s template and, well…I love it.  I made a few changes/updates (such as resolve a compatibility issue (I have Excel 2010 and the template is Excel 97-2003), change colors, add additional sections and formulas) and I am thrilled!!!!  I am almost finished with updating with my information.Thanks so much for sharing.  Here’s to living well in Twenty-twelve!!!

  • http://www.newlywedsonabudget.com/ Newlyweds on a Budget

    I created my own spreadsheet based on pay cycles. Best decision ever!

  • http://www.moneytrail.net Pam at MoneyTrail

    I use a combination of Quicken and an excel spreadsheet.  I like the examples you gave.  I might have to look into some of the spreadsheet templates.

  • http://www.myexceltemplates.com Z Miller

    Excellent article & blog!

More in Financial Planning, Money Management (19 of 44 articles)


Today we continue our series: 21 Days To Rock Your Finances with identifying your financial weaknesses.  This is day 2 of our series - Did you create your financial plan?  If so, then let's move on to identifying your financial weaknesses.  Think of creating your financial plan and identifying ...