Media Channel 2.0 — Blog — personal finance budgeting

personal finance budgeting

The other week on MakeUseOf, we showed you how to ungoogle your life – if you so desire. I’ve decided to do the opposite. Since I’m a self-avowed Google fan, and am in this deep, I may as well give my entire life over to them, including managing my budget and expenses.

I’ve tried out a whole slew of web and phone apps with the sole purpose of managing my expenses, but nothing seemed to suit my personal needs. Each application was either too complex, or left out factors that were essential to me. So I decided an Excel sheet, saved on Google Documents, would be the best way to keep track of both the balance in my bank account, and my spending habits.

Depending on what your personal needs are, there are a variety of templates specifically for managing your budget, available on Google Documents, or if you need something more detailed, there’s Ryan’s guide to putting together your own personal budget on Excel, which you can then upload to your Google Documents.

When it comes to tracking my spending, there have always been two essential factors I need to consider. First, my modes of spending money are varied, whether I’m using one of my credit cards, my debit card, or cash. When I withdraw money from the ATM, I want that to be reflected in my expenses and bank balance, but I also want to keep track of what that money is being spent on.

My solution to this using Google budgeting tools was simple. Using Google Documents Checkbook Register template, I duplicated the first sheet, listing my bank balance and transactions taking place directly from my bank account – deposits, ATM withdrawals and credit card payments.

I used the second sheet to list the amount of cash I withdraw each month, and keep a record of transactions each time I spend money. That way I know what is being spent, where and how.

The template is very simple to use – enter your bank balance at the top of the balance column, and each time you add a new entry to the withdrawal or deposit columns, it will automatically calculate your new balance.

The second factor to consider was that some payments I make don’t clear until the end of the month. I decided to keep those transactions at the bottom of the spreadsheet, and to highlight them until the transaction cleared. That way, just by glancing at the balance above the highlighted transactions – I can see what my current balance is, and at the bottom, what it will be at the end of the month.

Spreadsheet formulas can be finicky, so there are a few things you need to keep in mind. You cannot leave a blank row in the spreadsheet, otherwise the formula will no longer work. Sometimes, when inserting a new transaction above the payments that have yet to clear, it can ruin the sequence of calculations. Don’t panic – simple copy the cell with the bank balance that is accurate, and paste it into all of the cells below it, and that will automatically repopulate the cells using the formula.

A word of warning when it comes to using Google Document templates. When you save a Google template to your documents, sharing is automatically set to public. Your personal budget is obviously not something you want to share with the rest of the world, so to remedy this, click on the share button in the top right hand corner. Under ‘See who has access,’ click on ‘People can view this item without signing in,’ and choose ‘Always require sign in.’

Next, click on the ‘Advanced Permissions’ tab and make sure all options are unchecked. Save your changes, and the document will now be private.

Now that I knew which Google budgeting tools I would be using to keep track of my monthly spending, I needed a way to keep track of my daily spending, so that at the end of each day, or week, I could enter the transactions into my spreadsheet.

Keeping it in the family, I decided to use Google Calendar. I wanted something I could easily access at my computer or on the go, which would also keep track of the exact dates these transactions were made.

I created a new calendar called ‘Expenses’ and each time I spend money, I immediately make an entry to that Google Calendar with a note of the amount, and what the money is being spent on.

I personally have my iPhone calendar synced to my Google Calendar. Google Sync works with the iPhone, Windows Mobile, Blackberry and Nokia S60 phones.

If you’ve already set up your iPhone to sync with Google Calendar, be sure to go back into your iPhone sync settings and add your ‘Expenses’ calendar to the list of calendars that are in sync. You could also put Google’s mobile apps to good use for this purpose.

There are lots of little tips and tricks for entering transactions to your Google Calendar easier. You can use Twitter to add entries to Google Calendar. The downside to using Twitter to add your expenses is that it will add any entries to your primary Google Calendar, and of course you’re sending your spending habits to a third party.

For those of you living in the US, you can also send in your entries from your phone via SMS, but again, this option only works with your primary calendar.

There are various ways you can then access the information on Google Calendar to later input into your spreadsheet. I find the Agenda tab the most convenient to use in this instance, as it displays it all in one continuous list.

Do you have any tips on how to use Google budgeting tools to manage your expenses? Let us know in the comments.

I did it!

I finally finished the manuscript for Your Money: The Missing Manual; I e-mailed the last chapter to my editor at 9:10 this morning.

This book was a lot of work. I started writing it on 23 September 2009 at 12:27 p.m. Over the next 115 days, I gained fifteen pounds. (I actually gained eighteen, but I’ve lost three since the start of the year.) The final manuscript contains 125,244 words and 269 pages in Microsoft Word, which would be about 400 printed pages. That’s too long, so we’ll spend the next month whittling it down to something more manageable.

During the past few months, I’ve been a virtual hermit, cloistered in my office (”deep in the word mines”, as I like to say), working 8-10 hours every day — and sometimes many more. Now that the book is nearly finished (aside from editing and printing), I calculate that my hourly wage for this project is…drumroll please…less than minimum wage!

Still, I’m not doing this for the money. I’m doing it because I want to help people turn their financial lives around. I’m doing it because I wish I’d had a book like this twenty years ago. If Your Money: The Missing Manual sells enough copies to earn back its advance, that’s great. But if it helps even a handful of people get out of debt and start saving for the future, I’ve done my job.

Chock full of goodness
What’s in the book? Plenty of the stuff you see at Get Rich Slowly — but also lots of new topics, too. Here’s a chapter-by-chapter breakdown:

Introduction — I give a brief summary of my background and share the fourteen tenets of Get Rich Slowly. (2304 words, 5 pages, completed 09 January 2010)
Chapter 1: Happiness — I survey current happiness research. I explain how money is important but it isn’t everything. I also discuss the notion of lifestyle inflation (though we’re calling it “the hedonic treadmill” for the book). (6800 words, 15 pages, completed 05 October 2009)
Chapter 2: Goals — I discuss the importance of setting goals. Without goals, you have no reason to save. (6090 words, 13 pages, completed 12 October 2009)
Chapter 3: Budgeting — If goals are your destination, then a budget’s your map. But as most of you know, I’m not a fan of detailed budgets. Instead, I focus on looking at the Big Picture (including my favorite, the balanced money formula), suggesting readers can add detail as needed. (6975 words, 15 pages, completed 19 October 2009)
Chapter 4: Debt — I lived with debt for fifteen years. This chapter shares a bit about how I overcame my own debt, and then shares some of my favorite resources. My goal is to give readers the tools they need to kick debt to the curb. (7163 words, 16 pages, completed 16 October 2009)
Chapter 5: Frugality — This chapter got out of control! How can you compress this topic into just 25 pages? You can’t. I know some folks think frugality is pointless, but I’m not one of them. I sing its praises here. (11676 words, 26 pages, completed 04 November 2009)
Chapter 6: Income — The most overlooked topic in personal finance: how to make more money. You guys know I’m a passionate believer in boosting your income in whatever way you can. This chapter suggests some ways to do it. (11081 words, 24 pages, 10 November 2009)
Chapter 7: Banking — Banking’s not a very sexy topic, but there’s still some important stuff to cover, like how to find the best checking and savings accounts. (7836 words, 18 pages, completed 17 November 2009)
Chapter 8: Credit — Credit can be dangerous…but it doesn’t have to be. Here I go over credit scores and credit reports and offer some tips for using credit cards responsibly. (6350 words, 14 pages, completed 25 November 2009)
Chapter 9: Big Stuff — As great as it is to save money through frugality, it’s even more important to save on big things, such as cars, furniture, and vacations. This chapter tells you how. (13085 words, 26 pages, completed 03 December 2009)
Chapter 10: Housing — Yikes, this chapter was tough to write. I’m not sure why, but it got away from me. I had so much I wanted to say! In the end, I had to cut the info on “cost of living”, and I may have even had to cut the stuff on selling a house. There’s still plenty of meat here, though. (9906 words, 20 pages, completed 22 December 2009)
Chapter 11: Death and Taxes — When I started writing, I told my editor this chapter would suck. I didn’t feel confident about the subject. In the end, it was fun to write — and it turned out well. It’s tough to make taxes, insurance, and estate planning interesting, but I did my best. (10000 words, 21 pages, completed 16 December 2009)
Chapter 12: Investing — I outline the basics of investing, including some of the psychological pitfalls investors face. I encourage readers to look at index funds, but point them to good resources for other strategies if they simply must try to beat the market. (10684 words, 24 pages, 05 January 2010)
Chapter 13: Retirement — The chapter I completed this morning! I talk about the power of compounding and the importance of saving early. I also go on a rant about how much I hate retirement planning based around “replacement income”. (It’s so stupid!) (7872 words, 17 pages, completed 15 January 2010)
Chapter 14: Relationships — I close the book with a look at how money affects our relationships with family and friends. (The book is dedicated to my friend Sparky, who died a year ago today.) I also spend a little time exploring the notion of social capital, which is something I haven’t written about much here, but that I think is very very important. (7422 words, 15 pages, completed 11 January 2010)

buy mutual funds, buy mutual funds, buy mutual funds, buy mutual funds, internet marketing, yahoo, google, Online advertising, http://www.prlog.org/10512637-franchisesforsalecom-launch-heralds-the-next-wave-in-franchisee-lead-generation.html, http://www.prlog.org/10512639-restaurant-franchise-opportunities-providing-new-job-opportunities.html, http://www.emailwire.com/release/30658-New-Lead-Site-FranchisesforsaleCom-Goes-Live.html, http://www.emailwire.com/release/31568-New-Franchise-Opportunities-for-2010-Online-Tools-and-Resources-for-Buying-a-Franchise.html, http://www.ideamarketers.com/?New_Franchise_Opportunities_for_2010_%E2%80%93_Online_Tools_and_Resources_for_Buying_a_&articleid=883071, http://www.earthtimes.org/articles/show/new-franchise-opportunities-for-2010,1100822.shtml, http://www.newsalbum.com/Read/473435-New-Franchise-Opportunities-with-Successful-Franchise-Companies-Putting-People-Back-to-Work/, http://www.transworldnews.com/NewsStory.aspx?id=164465&cat=9, http://www.zimbio.com/Housing+Bubble+News/articles/7/Dr+Robert+S+Shumake, http://mortgagefraudreportmichigan.blogspot.com/2009/12/robert-shumake-fraud-report-tax.html, http://personals.szczecin.pl/index.php?topic=2.0, http://tweetmeme.com/story/339636355/surface-encounters-in-wixom-going-green-with-marble-granite-countertop-production, http://finance.bnet.com/bnet/?GUID=11076222&Page=MediaViewer&ChannelID=6526, http://www.ideamarketers.com/?Surface_Encounters_Ohio,_LLC_Celebrates_100_Years_of_Experience_with_Columbus_S&articleid=880865, http://viralvideochart.unrulymedia.com/youtube/surface_encounters_macomb_mi__counter_tops?id=VGJx3FcNE50, http://www.veoh.com/browse/morelike/v19614992esMzfMCZ#, http://deals.yahoo.com/local-store-coupons/mer-surface-encounters–dept-home-garden, http://www.bignews.biz/?id=835928&keys=Shopping-counter-surface-Granite, http://www.businessweek.com/bios/Bill_Bartmann.htm, http://www.businessweek.com/archives/1998/b3603113.arc.htm, http://www.businessweek.com/smallbiz/content/apr2009/sb20090421_494148.htm?chan=smallbiz_smallbiz%20index%20page_top%20small%20business%20stories sell my home fast

personal finance budgeting

<b>News</b> Corp. Got $12.5 Million In Flixster Stock For Rotten Tomatoes <b>…</b>

Apple already considering iPad price reductions? | iLounge <b>News</b>

The Big Dig…Fox <b>News</b> Shovels out its Live Shot position… « Row 2 <b>…</b>

Leave a Reply