How a Spreadsheet Helps Save Me Big Bucks

What's Hot

2 Types of Black Marks Might Vanish From Your Credit File SoonBorrow

6 Ways the Obamacare Overhaul Might Impact Your WalletInsurance

7 Dumb and Costly Moves Homebuyers MakeBorrow

This Free Software Brings Old Laptops Back to LifeMore

Obamacare Replacement Plan Gets ‘F’ Rating from Consumer ReportsFamily

Beware These 12 Common Money MistakesCredit & Debt

21 Restaurants Offering Free Food Right NowSaving Money

17 Ways to Have More Fun for Less MoneySave

House Hunters: Beware of These 6 Mortgage MistakesBorrow

30 Household Uses for Baby OilSave

25 Ways to Spend Less on FoodMore

Nearly Half of Heart-Related Deaths Linked to These 10 Foods and IngredientsFamily

5 Surprising Benefits of Exercising Outdoors in WinterFamily

10 Ways to Save When You’re Making Minimum WageSave

Boost Your Credit Score Fast With These 7 MovesCredit & Debt

7 Painless Ways to Pay Off Your Mortgage Years EarlierBorrow

The Most Sinful City in the U.S. Is … (Hint: It’s Not Vegas)Family

The True Cost of Bad CreditCredit & Debt

10 Companies With the Best 401(k) PlansGrow

This Scam Now Tops ID Theft as the No. 2 Consumer ComplaintFamily

6 Stores With Awesome Reward ProgramsFamily

6 Ways to Save More at Lowe’s and The Home DepotSave

6 Healthful Treats for Your DogFamily

New Study Ranks the Best States in the U.S.Family

Thousands of Millionaires Moving to 1 Country — and Leaving AnotherGrow

Strapped for College Costs? How to Get the Most From FAFSABorrow

6 Overlooked Ways to Save at Chick-fil-AFamily

Ask Stacy: What’s the Fastest Way to Pay Off My Mortgage?Borrow

Where to Sell Your Stuff for Top DollarAround The House

8 Ways to Get a Good Price on a Shiny New AutoCars

Ask Stacy: How Do I Start Over?Credit & Debt

Secret Cell Plans: Savings Verizon, AT&T, T-Mobile and Sprint Don’t Want You to Know AboutFamily

30 Awesome Things to Do in RetirementCollege

14 Super Smart Ways to Save on TravelSave

The Rich Prefer Modest Cars — Should You Join Them?Cars

You’ll Soon Pay More to Shop at CostcoSave

10 Ways to Save When Your Teen Starts DrivingFamily

Technology has made it easy to track all your expenses. Here's why that's a bad thing.

The following post comes from Len Penzo at partner site

I’ve been diligently managing my personal finances and tracking household expenses for more than 20 years.

How diligent, you ask?

Well, I can tell you that my cable bill in February 1998 was $8.03, and that I spent $141.16 in 2006 for an annual subscription to the Los Angeles Times.

I can also verify with total certainty that 7 percent of my income in 2007 went toward groceries, and vouch that I spent $88.95 at my local K-Mart in August 2001. Just don’t ask me what for, because I’m not that thorough with my record keeping.

Why tracking expenses is important

Taking the time to track and analyze your income and where it’s going is a crucial element of managing your personal finances. That’s because doing so uncovers hidden money leaks that help you better allocate your resources, thereby ensuring you always get the most out your paycheck.

It makes it easier to set financial goals too.

Of course, prior to tracking your expenses, you have to record them.

While not impossible, trying to track all your cash purchases can be extremely tedious and time-consuming. On the other hand, everything purchased on your credit and debit cards is automatically recorded and available for review online or as part of your monthly billing statements – which is why I use credit cards for as much as I possibly can.

As for keeping tabs on how you spend your money, there are a panoply of options available.

Now, I realize many people are initially attracted to sites like MintOneBudgetAdaptu, and MyBudget-Online because their automation features essentially make the job of tracking your money almost effortless. The trouble is, in the world of personal finance I believe too much automation can be a curse. That’s because when money-management tools become too user-friendly, a lot of folks have very little incentive to understand the data being made available to them.

For the financially undisciplined, over time that’s a surefire recipe for failure.

The big advantage of spreadsheets

For me, the more old-school, hands-on approach is the only way to go. I use my own custom-designed Excel spreadsheet because it forces me to actively manage my personal finances. It also gives me more control than using a Web-based site like Mint.

In fact, every January I give my readers a peek at some of that spreadsheet’s top-level graphs and financial breakdowns in my annual State of the Household post.

True, a spreadsheet is not as sexy as automated money-tracking Web-based applications. But it’s the same tried-and-true method I’ve been successfully using to track my income, net worth, and expenses for more than 15 years now.

Here’s just a small portion of the Excel worksheet for my household expenses in 1999…

Although the custom Excel spreadsheet I developed was quite simple in the beginning, it has grown in detail and complexity over the years, with pie charts and graphs that clearly show the results of our household spending and current trending patterns.

Today, my spreadsheet breaks out our household expenses into 13 major categories and 50 subcategories. The major categories include:

  • Loans
  • Utilities
  • Medical and dental
  • Automobile expenses
  • Groceries
  • House expenses (excluding the mortgage)
  • Entertainment
  • Taxes
  • ATM withdrawals

And a few more quick tips…

  • If you’re just starting out, it’s important to make sure you set aside about an hour or so at least once per month for reviewing your checkbook, receipts, and/or credit card statements and recording your expenses in your spreadsheet.
  • By frequently updating your financial spreadsheet, you’ll not only be able to quickly catch any potential errors on your billing statements, but you’ll also keep from falling hopelessly behind on your record-keeping duties.
  • If you’re not an expert in Excel, there’s no need for despair. Microsoft has scores of budgeting worksheet templates for you to download and modify to suit your needs. In fact, their “personal budget worksheet” template has been downloaded more than 3.6 million times.
  • If you’ve never used a spreadsheet, don’t be intimidated – they’re not hard to use! Yes, spreadsheets are extremely powerful tools for those who know how to take advantage of all they have to offer. But for most folks, the basics needed to properly track expenses can be learned in less than 30 minutes.
  • If you don’t want to spend money on a spreadsheet application such as Microsoft Excel, you can try the free equivalent from OpenOffice. I’ve used OpenOffice before and it’s an extremely capable alternative. You can also take advantage of the free personal finance templates provided by Google Docs.
  • Once you’ve effectively disciplined yourself to always spend less than you earn, tracking expenses becomes a viable alternative to budgeting that allows you to focus on optimizing your finances in order to get the most bang for your buck.
  • And last but not least, remember this: In the end, it doesn’t really matter what tool you use. What is important is your commitment to actively manage your finances.

Stacy Johnson

It's not the usual blah, blah, blah

I know... every site you visit wants you to subscribe to their newsletter. But our news and advice is actually worth reading! For 25 years, I've been making people richer without making their eyes glaze over. You'll be glad you did. I guarantee it!


Read Next: Ask Stacy: What’s the Best Way to Borrow?

Check Out Our Hottest Deals!

We're always adding new deals and coupons that'll save you big bucks. See the deals to the right and hundreds more in our Deals section.

Click here to explore 2,060 more deals!