»
S
I
D
E
B
A
R
«
7 Steps to a Complete Money Management System – For Free!
May 29th, 2009 by The Practical Nerd

Photo courtesy of Betsssssy [Flickr]

Raise your hand if you like working with your checkbook. Yeah, that’s what I thought.

If you’re still using a paper checkbook, you are missing out on about 8 billion benefits to going the “digital” route, so to speak. But the most important one is this: no more math slip-ups. I used to work at a bank, and I can’t tell you how many times I had to spend 45 minutes going through someone’s paper checkbook only to find that they forgot to carry a one or just completely forgot how to do basic math. It’s mind-boggling.

And it happens to everybody. I know it did for me quite frequently. Think about it: you’re in a rush, you quickly jot down the price of something and subtract it out. It’s easy to miss something when you’re running out the door. Or even better, you do the great trick of writing in the amount so you’ll do the math later, right? What’s that? You have a calculator? Great! But guess what? All it takes is one missed button and you’re screwed!

Besides the automatic adding and subtracting, going digital also gives you a much neater checkbook to work with (for those of us with supremely awful handwriting – yup, I got a “C” in penmanship in the 7th grade!), and you can also group your transactions and analyze your spending and saving much better, what with graphs and charts and all that fun stuff. Keeping a budget is easier because you can punch in your benchmarks and see the progress as it’s happening!

“But wait!” you scream, even though I can’t hear you. “I don’t want to spend $100 on Microsoft Money or the latest version of Quicken!” Me neither. So we need to build a system that can handle our finances online. Here is what I needed my system to do:

  • Not cost a dime. I don’t have that kind of money.
  • Allow me to manually enter in transactions. Services that pull in your account information automatically are great, and there are plenty of them. But if you automate the “keeping track” part of your finances, you leave yourself open to giant mistakes. They’re not perfect on their own. You need to be able to enter in your receipts and balance the checkbook manually.
  • Be upgrade-proof. Buying Microsoft Money is a great investment – until the next version comes out. This system is free all the way through. You can’t be burned by new versions here.
  • Be accessible anywhere. If you only have a desktop PC, you need to be able to grab your account information anywhere, since you can’t carry your desktop everywhere. If you have a laptop, you have an extreme advantage.
  • Provide reporting features. The best part of having those cool, expensive programs is the way you can look at overviews of your finances and see where your money is going and how much of it. This system has it, for free.
  • No internet access needed, however. If you know you are going somewhere where you don’t have internet, you need to be able to keep updating your finances on your computer.
  • Be safe. Security is a concern with everything you do involving your money. This system does not require you to reveal any account numbers.

So, after much thought and testing, here’s what I deem to be the best and safest money management system. It’s nearly foolproof, and you can relax knowing your money is being tracked safely. So here are the 7 easy steps you need to take to set yourself up!

#1. Open your Google Docs.

If you have a Google account already, all you need to do is log in. If you don’t, sign up for one – it’s easy and it’s quick.

#2. Open up a new document from a template.

fromtemplate

#3. Click on “Personal Finance” on the left side, underneath “Narrow by category”.

category

#4. Use the “Checkbook Register” template.

checkbook

#5. Edit the template to fit your account.

register 

This is how the template looks right after you load it. Click on the title at the top and change it to the name of your account (“Checking Account”, “Mastercard Credit Card”, etc.). Then notice how the examples are laid out – you can fill in a category for each transaction, and use it just like a regular paper checkbook. The only difference is that the math is done for you already. Edit the top line of the register to match your current balance, and you can start entering in transactions immediately! It will automatically be saved.

#6. Set up your accounts with Mint.

Go to Mint and click on the “Sign Up” link at the top of the page, then follow the instructions to add your different accounts and it will pull in your information. Worried about security? First, Mint has been open and running since 2006 and there have been no complaints of any security breaches. On top of that, even if someone were to hack into your account, all they would be able to see is your transactions. You are not giving your account information (account numbers, etc.). You are only giving information to track expenses and deposits.

Setting up your accounts can take a little bit of time, especially initially as Mint pulls in your information.

#7. Enjoy Mint’s extensive reporting features.

mint1

When you log into Mint, you will see an overview of your finances. Here you can see how much money has cleared your accounts, a quick look at your budget (which you can edit to fit your needs) and how far along you are in meeting that budget (below). You can also look at your transactions and edit how an expense is categorized, if you would like.

A quick look at your budget

Click on the “Trends” tab, and you will see different ways you can look at how your money is being spent:

mint3 

As you can see, you can change the timeline to see different reporting, if you would like.

mint4

Above: you can even compare your shopping to trends in your local area.

mint5

Mint also has a “Ways To Save” tab. This is what keeps Mint a free service. Here, Mint analyzes your spending and recommends different accounts and credit cards that would be better for you – maybe a credit card with a rewards program or a savings account with a higher interest rate, for example.

Mint also has email alerts, which automatically let you know when your credit card payments are due, or if your balances are starting to get low. You can set them up however you would like. Very handy!

So how do I access this stuff from anywhere?”

Glad you asked! Google Docs and Mint are both hosted on their own servers and not on your computer. In layman’s terms, this means you can access them from anywhere with an internet connection. If you have a laptop, you can take these things wherever you want. At a hotel? Hop down to the public computer in the lobby and enter in your expenses from the day. It’s that simple.

No internet connection for the week? If you have a laptop, you can download your Google Docs checkbook as a spreadsheet and keep entering in transactions offline. Then you can upload the document back into your Google Docs account when you get home. You won’t get your reports and graphs until you get an internet connection, but if you’re on vacation, you’ve got better things to do than sit in your hotel room and look at your spending!

If you don’t like Mint, there are several other services like it that are just as free and have their own unique features, such as Thrive and Wesabe. Choose the one that’s right for you.

What do you think? Do you have your own money management system that you prefer over this one? Share it with us in the comments!

Related Articles:

Get great, practical advice sent straight to your inbox every week! For more information on The Practical Nerd Rules for Life, click here. Plus, learn how you can get a copy of my FREE ebook!

Post Footer automatically generated by Add Post Footer Plugin for wordpress.

http://www.thepracticalnerd.com/wp-content/plugins/sociofluid/images/digg_48.png http://www.thepracticalnerd.com/wp-content/plugins/sociofluid/images/reddit_48.png http://www.thepracticalnerd.com/wp-content/plugins/sociofluid/images/stumbleupon_48.png http://www.thepracticalnerd.com/wp-content/plugins/sociofluid/images/delicious_48.png http://www.thepracticalnerd.com/wp-content/plugins/sociofluid/images/technorati_48.png http://www.thepracticalnerd.com/wp-content/plugins/sociofluid/images/google_48.png http://www.thepracticalnerd.com/wp-content/plugins/sociofluid/images/myspace_48.png http://www.thepracticalnerd.com/wp-content/plugins/sociofluid/images/facebook_48.png http://www.thepracticalnerd.com/wp-content/plugins/sociofluid/images/twitter_48.png

  • Ryan
    I love your idea of using a Google Docs spreadsheet! Makes a ton of sense.

    But you said you wanted a system that allowed you to keep your account numbers safe and allowed for manual transactions. If that's the case, why are you using Mint? Mint users are forced to reveal all their account information and can't add manual transactions. I use Mint and these are two things that bug me.

    I'm trying out ClearCheckbook.com because they allow more versatility in the types of accounts you can add, you aren't forced to give up any account numbers and you track your own transactions.
  • PracticalNerd
    I understand what you mean, Ryan, and thanks for the comment!

    I don't believe Mint really has much access, because it doesn't get my
    account numbers, it just gets to view my online statements. So I don't
    believe it wields much power. The manual transactions are why I use the
    Google Doc, and Mint then is just for reporting and bill reminders.

    Although I've read that Quicken bought Mint and they are hoping to add
    manual transactions soon! Now if only ING Direct would play nice with
    them...

    Thanks again!
  • I started off keeping track of transactions in an excel sheet and then moved to Google documents to be able to access from anywhere. I only want to keep records of important transactions in there. Anything that's not, I just want to make sure it was charged properly and then the receipt is thrown away, and no permanent record exists of it except in my statements. I also have additional sheets for various purposes (one is for school loans which keeps them all mapped out, etc).

    The way I did it before was to keep my receipts until I got my statement and then check off all the receipts against the statement. I'd put a check next to the transaction on the statement and whatever didn't have a checkmark next to it after I went through all the receipts meant I had to look into it. I would check online along the way, but just held the receipt until I was able to officially mark it off on something permanent.

    But now I'm thinking forget checking against the statement, I'll check against the current online statement, but I really want to make a note to myself that the transaction checked out and everything is good. Or I want to note other important things about the transaction.

    This is why I like my Google Docs spreadsheet but it seems a waste to enter in transaction information twice if it already exists in another form. So this is where I'm torn on what to do... Do I keep just using my google docs spreadsheet and keep entering in the transaction info manually.. or can I work right out of mint.com.

    Ideally, I'd be able to go through mint.com, make notes there and select certain transactions to export into my google docs document.

    I feel what I posted is confusing...
  • PracticalNerd
    Well first, thanks for the comment!

    I think I understand what you're asking: the reason I don't just rely on
    Mint is because there's no way to manually track transactions. So when I
    write a check, or I'm waiting for something to clear, I need to make sure I
    subtract that from my records so that I don't accidentally spend that money
    again. Is that what you're asking?
  • lllex
    I'm confused, I don't see how the google doc and the Mint get used together. Also it seems I can't use Mint with my Credit union and there's no way to use it without a Bank connection. Can you help me out?
  • PracticalNerd
    Well, the Google Doc and Mint don't necessarily work "together". You use the
    Doc for recording and balancing your checkbook, and you look at Mint for the
    "big picture" stuff, like spending reports and what-not.

    As far as your credit union goes, do a Google search for your credit union's
    name and Mint. If you don't find an answer, check out
    http://www.mint.com/help/. There are some support forums you can search in
    there, or you can email Mint's customer service department and ask about it.

    Thanks for checking out this article!
  • This is great advice. About 5 years ago I set up a complete accounts system which is unlike a business accounts system in that it records personal (non tax-deductible expenses). The result of this is that over five years I can you exactly what we have spent on: pet food, gardening items, food, car expenses, insurance etc etc, and also whether we have spent less than we have made in income. It has been the most fantastic tool to use to budget. I knew exactly how much money I needed to make in my "home bliss" business, in order for us to live confortably. In the last 12 months, we have achieved the goal of being self sufficient to the point where my husband could give up paid employment and be part of the business. The next goal will be to double this income so we can save money and elinimate our debt. Thank you for a wonderful blog and good luck to everyone who is simplifying their lives!
  • The Practical Nerd
    Thanks for sharing your story, Kathy, and thanks for the kind words as well! It's really empowering to have that kind of knowledge that you can act on when you need to! Good luck with your future business aspirations and keep us all posted!
  • Nicely done, sir! Never knew about that personal finance section in Google Docs, gonna go see what else they have there too now...love google.
  • Ethan Matter
    Useful stuff, I may implement it myself..although I think I may have Microsoft Money somewhere. Oh well, looks cool anyway, I may just have to take you up on that system.
blog comments powered by Disqus
»  Substance: WordPress   »  Style: Ahren Ahimsa