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.
Personal finance blogger Girl with the Red Balloon put together a list of 11 ways she saves money at grocery stores.
The key to many of her tips is to restrict your exposure to impulse-buy opportunities. An excerpt:
5) Learn where your food is in the store and only visit those aisles. In my formative years of living on my own, I dated a man who walked down each and every aisle while grocery shopping. It would drive me crazy, mostly because it wasted so much time. I've learned now that I buy a lot more when I go down every aisle. Now, I look at the signs at the end of each aisle and only walk down the ones that have something I need.6) Get over your loyalty to big brands. Before I met D, I was the world's worst for paying for the most expensive brand of milk in the store. “It's what my parents used when I was growing up! It's just better,” I'd pathetically try to rationalize. I've since accepted that store brand milk tastes just the same. And guess what? I spend 50% less buying the store brand of milk instead of the name brand. The savings aren't quite as much on other products, like shredded cheese, but it's still there. The only thing I've not bought store brand yet is cheese squares for my grilled cheese sandwiches, but I've also not needed to buy cheese singles for two months because I didn't use them all the last two trips.
Question your loyalty to these name brands. Why do we think they're better? Is it because you've tasted both brands and know the store bought brand tastes considerably worse? Then, fine. Buy the name brand. But if it's just because it's what you're used to, give it up for one trip to the store. Try the generic store brand one time and see how you feel.
What do you do to cut your grocery store expenditures?
Take that, grocery store! 11 tips to help you save [Girl with the Red Balloon]
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 house quick
MrSun tracks the sun's position | iLounge <b>News</b>
If you have a comment, <b>news</b> tip, advertising inquiry, or coverage request, a question about iPods or accessories, or if you sell or market iPod products or services, read iLounge's Comments + Questions policies before posting, …
'Ghostbusters 3' <b>News</b>: Murray Confirms Rumors, Possible Villain <b>…</b>
As the writers slave over another draft of the Ghostbusters 3 script — with production hopefully beginning later this year — some more <b>news</b> regarding the film's storyline has slipped out across these internets, with one aspect being …
Brad Pitt Angelina Jolie Suing <b>News</b> Of The World Over Split Rumors
Hollywood power couple Brad Pitt and Angelina Jolie have filed suit against a British tabloid that published a report claiming the pair recently called it.



Leave a Reply