Keeping a track of your expenses: using Google Docs

When we were away on our travels, we really had a good time, and we found that Taiwan is really a place for enjoying yourself. For better or worse, we used our credit cards to pay the hotel fees. It was just so much more convenient and we’ll earn the points.

But I failed to have a great system for recording these expenses. I read about using Google Docs to create an expense list from somewhere. So I decided to see what I could create in a few minutes. Surprisingly it was easy.

Google Docs now allows users to create forms. Sign into Google, click on Google Docs and on the right hand side you’ll see a short menu that allows you to create four types of documents. Click on the ‘New’ tab. You’ll see the first item is called ‘Forms’. When you click on that, you’ll be taken to a simple form that is populated with the first item already.

Try it out for yourself or read my full post. As you approach a major spending time, such as summer travel or Christmas, this can be a great way to monitor your spending. You’ll find the tool quite easy to use. For more, read this post on Google Docs and Forms.

Don’t forget to subscribe to the feed for this blog! Click here…

Looking for financial and economics stats about Taiwan?

I was surfing banking sites in Taiwan looking for a bank with a reasonable website that I could use, given my already limited Chinese proficiency.

I didn’t find a site yet that I can use, apart from Citibank. But I did find some statistical information courtesy of the Bank of Taiwan. Unfortunately, the website is only really functional in IE. You can find the latest stats on Bank of Taiwan’s website yourself, but you’ll need to download the files, and open them in Excel or a similar Office type program.

So I took the liberty of downloading them, and uploading them to Google Docs. I’ve also shared the documents so that you don’t need to download the stats.

I hope the bank don’t mind, but I think locking up the information inside an Excel document instead of a web page isn’t smart.

Don’t forget to subscribe to the feed for this blog! Click here…

Using Google Docs to track your expenses: Simple Step-by-Step Approach

Keeping a track of expenses is truly a nightmare especially when you’re on vacation. You have all those little bits of paper, phone numbers, receipts, credit card receipts, cash, foreign coins, etc., etc. Soon you end up with a wallet that looks similar to this. If you’re anything like me, being organized is a real challenge. I do have folders and organisation, but there are times when the whole system seizes up! You know what I’m talking about if you take a look at this wallet of mine.

Things flopping out everywhere, terrible. Well, a blog I was reading suggested using Google Docs new forms feature to create an expense list. It’s a brilliant idea if you have a mobile device, or prefer to tally your expenses at the end of the day or like to do it at work (when the boss isn’t looking). So here goes: a step-by-step guide to setting it up.

You will need:

  1. a bunch of receipts to set it up;
  2. a Google Email account so you an access Google Docs;
  3. and a little patience!

Step 1: Create a new form – look in the image to see how it’s done. Click on ‘new’, tab down to ‘form’ and release the click or click on it again.

new form image

Step 2: You will now see a screen with the form tabs and fields.

base form

A field is the area of the form that you need to type some data. So, in the Untitled form, you can enter the Form Name. In the Question area, you can write: “What is this expense for?” or similar. If you need help text, enter something useful so you know what data to enter. Then choose the question type: “Text” is most straightforward at this point. Then click ‘done’ and ‘required’ (if need be).

sample report question 1

Step 3: To add a new field, press ‘Add Question’ and repeat as necessary. Repeat this for the date, the form of payment, and the amount.

repeat operation

Step 4: I’ll show you my completed form which you can see for yourself.

sample report form

That’s pretty much the form set up. Don’t forget to hit ‘save’ so you don’t lose the changes. You can click to see the form which I have published and you can try it out!

So what happens to the data? Well, let’s take a look. The data is auto-saved in the base spreadsheet for later. You go to your Google Docs again and you’ll see the new spreadsheet sitting there. I’ve entered several of my favorite ‘sins’ and you can see the result.

basic form and results

Each item is stamped with the entry time and the fields you required. You can then perform any calculations you like using traditional spreadsheet functions. You can then email the form, embed the form in your blog or online documents, or go back and edit the form as you wish.

I’ve set my form to be published and republished as data is entered. You can take a look at it yourself, just click on the image above. Please enter some items for purchase, and you’ll see it updated dynamically. Pretty simple, I’d say. No doubt, far more complicated than it looks, under the hood!