Ask Owlbert

iPhone trick - use it in real time to keep track of business expenses with Google Docs

Money.

It’s a good thing.
Please click here to continue your search.

Getting it back at tax time is even better.

Alas, therein lies the rub - you have to keep track of all your business expenses in order to achieve this nirvana. Filling your car up with gas, taking your customers out to lunch, buying that super-cool-Wii cutting-edge business entertainment software…keeping track of all those receipts is my personal view of Just a Little Bit of Hell.

But now you may fear not, gentle readers! For it was just reported at MacOSXhints that you can use your iPhone to enter in such crucial mind-numbing data into personalized spreadsheets created by, of course, Google Docs. To wit:

… To get started, go to Google Docs (sign-up if necessary), create a new spreadsheet. If you want, you can add a few columns with a header row to make things a little easier in the next step. Then, go to Share and invite yourself with the ‘to fill out a form’ option. You’ll then be able to configure your form. Here you can add or delete fields, re-order them, and set each field to ‘text,’ ‘paragraph-text,’ ‘multiple-choice,’ ‘checkboxes,’ or ‘choose from a list’ (with the choices, where applicable). You can also set defaults in some cases, and add simple instructions.

You’ll receive an email with the form embedded, but there’s also a link to a web page version of the same form. On your iPhone, click this link from your email (or import this link via Safari). Once it is open in Safari, scale it to fit better on the screen, then press the + at the bottom of the screen and add the page to your home screen.

Now, whenever I fill my tank or make a business expense, I simply press the button on my iPhone, then fill in the form, and press Submit. All results appear in my spreadsheet. It appends a new row for each submission. I’ve also set up the spreadsheet to automatically take averages, or compute other figures from the submitted data….MORE…

Here’s some more resources about Google Docs:

Thus, now you can keep track of critical information in real time. What more could you want (except possibly an iPhone that contains a Mercedes)? :)

ThankYouVeryMuch!

Owlbert

ps - looking for:

Please click here to continue your search.

No Comments, Comment or Ping

Reply to “iPhone trick - use it in real time to keep track of business expenses with Google Docs”

Subscribe!

Subscribe

Sponsored Ads

Going so soon? May these links be a guide to web enlightenment. Schwing!

Please click here to continue your search.