Reading:
Make a Cash Log With Google Forms and Google Sheets
Image

Make a Cash Log With Google Forms and Google Sheets

Heather Phillips
January 13, 2017

While traveling in Nicaragua, where it’s primarily a cash based system, I’ve experienced the challenges of getting my cash spending into my Tiller budget spreadsheet.

I’ve grown to make tracking my spending a daily practice, and it’s important for me to capture these transactions.

Initially, I’d just write a note in the Notes app on my iPhone to indicate where money was spent. Then once a week I’d go through it, enter it into a separate sheet, convert the Nicaraguan Cordobas to U.S. Dollars, then add those lines to my Transactions sheet.

Once there, I could continue with my normal categorization process.

After two or three weeks I began to realize this was tedious, and I asked the Tiller team if they had any advice on how to get my cash spending more quickly into my Tiller Sheet.

They shared a quick and easy method with me, which I’ll be sharing with you in this post. I’ve excluded the step of converting the currencies for simplicity in this example.

It starts with a simple Google Form

First, create a Google Form. You can easily do this with your Tiller Sheet open by clicking File > New > Google Form. A new browser tab will open where you can create the form. In this example I’ve titled my form “Cash” and given it a short description.

Step 1 is creating the Google Form Step 1 is creating the Google Form

Next, we’ll need to create the data fields that we want to capture. In the most simple example I’m only creating two fields: Description and Amount.

I configure both of these as “short text” fields. If you wanted you could set up a “Category” field in between the Description and Amount inputs to go ahead and categorize your cash transactions as you enter them.

If you want to do this step as well, I recommend you create a list that mimics the one in your Category Setup sheet in your Tiller Sheet.

Once the form is ready the next step is to choose where the data will go when the form is submitted.

Click the ellipsis in the top right of the form and choose the “Select Response Destination” to open a dialog where you can select your existing Tiller Sheet. The form will indicate that it’s linking to the spreadsheet and give a confirmation when it’s ready.

Now I can navigate back to my Tiller Sheet and see the new tab along the bottom for this Cash Sheet. I can also update the title of the sheet by double clicking the tab and typing the new title “Cash.”

Test out the form from mobile

Google Forms work really well on any smartphone. To test it out on my phone, I click the “send” button in the form and email it to myself.

I open the email and click the link to open the form in my phone’s browser. I’ll enter in the cash I spent on some Chinese takeout that I bought here.

After I submit, I see that it enters the transaction into my new Cash sheet on my Tiller spreadsheet.

To make sure that it’s easy to copy the transactions from the Cash sheet to the Transactions sheet, I’ll create a “Category” column in the Cash sheet and then move it in between the Description and the Amount column.

Now the column order matches my Transactions sheet. In this example I also reformat the date column to use a standard date format rather than the full date with timestamp.

I can copy/paste this transaction into my Transactions sheet and categorize from there.

Step 3 is formatting the data to go into the Transactions sheet Step 3 is formatting the data to go into the Transactions sheet

Create an icon on your phone home page

I can save more time and make it even simpler by saving the Google Form bookmark to the home screen on my phone so I have easy access anytime I spend cash.

This process has made it so much easier to track my cash! Do you track your cash too?


Related Stories

March 16, 2018

A Primer to Getting Started With Pivot Tables in Google Sheets

With a little explanation, you will come to appreciate the utility of pivot tables in Google Sheets. With just a few clicks, you can turn dull data into a tool for deeper understanding and faster decision making.

May 2, 2016

How to Quickly Categorize Transactions in Your Finance Worksheet

Have a large group of historical transactions that need to be categorized? Perhaps all those times you got gas over the past several months that Tiller pulls in when you first create a Tiller Sheet? We've got an quick and easy way to categorize that lump of transactions using the built in features of Google Sheets.

Budget Sheet Sample Data for Google Sheets and Excel
October 29, 2018

Budget Sheet Sample Data for Google Sheets and Excel

Budget sheet sample data for anyone who needs example financial transactions for their app, spreadsheet model, or reports.

Arrow-up