Track Your Cash Spending With Your Tiller & Google Sheets

With automated tools, it can be difficult to account for how you spend your cash. So here are tips for tracking cash with Tiller-powered Google Sheets.

Tiller tracks the financial transactions for all of your linked accounts in a Google Sheet.

If you spend cash, it’s likely that you see the cash come out of your checking account as an ATM withdrawal.

That’s the last Tiller will likely see of that money.

Using a single category for that ATM transaction doesn’t really tell the whole story if you spend that chunk of cash in many ways over many days.

Track Cash Image 1

Simple Cash Spending Tracking

So how can you track cash spending with Tiller? The most simple method involves adding new rows into your Transactions tab when you spend cash, effectively splitting the original ATM withdrawal into multiple rows.

For example, a -$40 withdrawal could be duplicated into three rows.

The first row might be for parking for -$10 (perhaps categorized as “transportation”), the second row for lunch from a street vendor for -$12 (perhaps categorized as “eating out), and the third row some raspberries and other produce at the farmer’s market for -$18 (perhaps categorized as groceries).

Each row can be categorized differently, and the details of your cash spending is now captured in your Tiller Transactions tab.

Track Cash Image 2

For more specific advice about how to categorize your transactions read our post on “Which category should I use?

Super Tidy Cash Accounting

Most of us spend less cash and use more plastic these days. But if you’re really into the nitty gritty of cash spending, you can go further. When you see -$40 ATM withdrawal, first categorize it as a Transfer.

Then, duplicate the row on your Tiller Transactions tab and change the amount in this new row to a positive $40. Finally, change the data in the field for the “Account Name” column to “Cash” on the new row and categorize it as Transfer as well.

Next, you’ll want to do the same thing you did in the Simple Cash Spending Tracking method and create new rows for each of your cash transactions. Using the example from above, there will be a row for your -$10 parking cash transaction, one for the -$12 street food, and a final one for the $-18 farmer’s market produce.

Track Cash Image 3

Reviewing your Cash Spending

Want to drill down to focus on your Cash spending? You can quickly filter your transactions on the “Account Name” column to show only your Cash account by selecting the blue filter triangle in the column header for the Account Name column. Choose the “clear” all values. Then select only the “Cash” account value. Then click okay.

Track Cash Image 4

Curious to see if you’ve accounted for all of your cash? If you enter your cash transactions as described above, you should find that cash coming in to this “Cash account” totals the cash going out.

In the below example, we’ve withdrawn another $20 from the ATM and used $5 of it for a vending machine snack.

We’ve filtered the “Account Name” column to show only the Cash account, and we’ve selected all the values in the “Amount” column. Google Sheets does a quick Sum in the bottom of the window, which totals $15.

That’s the balance in our Cash account, which should total the money in our wallet or purse.

track cash image 5

Have a different way to track cash? Drop us a line on Facebook or Twitter to let us know.

Heather Phillips

Heather Phillips

Heather comes from a background of user experience design & customer support. She loves helping others learn, explore and discover better ways to use applications and products that improve their lives. When she’s not coaching customers on Tiller best practices, tweeting or writing blogs, she’s probably at a yoga class, out for a hike in the Blue Ridge, or off volunteering for a variety of non-profits.

One comment

  1. If I have a cash envelope for Grocery…how do I set up that category? Let’s say I’ve allocated $500 on it every month and whatever left over I have will go towards the savings fund. How to I keep track of each several cash transactions in a given month? Right now I have it under expense type, subtype = flex, rollover to
    emergency fund, savings target is blank.

Leave a Reply

Start Your Free Trial

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023