Help with creating a Liquid Cash Tracker


Excel novice here. I love tiller and have been really enjoying using it. I just have 1 use case that I would really like to solve for myself that I need some help thinking through and need some advice on how to get started.

What I’m trying to do is make a chart of my liquid cash. A graph that has one line which represent the sum of my checking account, a savings account and credit debt. I really like the net worth sheet and I want something similar but doesn’t include investments, retirement or other assets.

I’m sure I will need to create another worksheet and set it up like the net worth tracker by only displaying the accounts that I want. Then have a row that adds all of the accounts together but the more I look at the net worth tracker and try and deconstruct it, the more I feel like I’m in over my head.

Again, I’m an excel novice so most of functions, formulas, and error handling I’m inexperienced with. Maybe there is a way to add a “liquid cash” line to the net worth tracker that only includes the accounts that I want and can make a chart from just that line. The more I think about it, the more I think adding to the Net Worth worksheet is the way to go.

Things I think I have to do but don’t know how to:

  • Reference cells from Balance History sheet that only takes the most recent entry of the specific account
  • Create a table that generates a new month when the current month changes

Anyways, I’m lost. Please help!

Thank you!!

You are on the right track. If you really want only the liquid accounts you mentioned, I’d create a separate sheet linked to Tiller and select only those accounts you want to track.

Personally I have a net worth worksheet that includes all my accounts. Within that, I have a category for my liquid accounts. That way I can always see that cash balance. Only downside is the line graphs include all accounts, not just the cash.

Thanks for the reply.

Did you create your own net worth tracker or is it the same one in this thread?

Same one on that thread.

Okay I got it figured out. The complexity of the sheet was stressing me out and I didn’t think it was gonna be as simple as adding a line for Liquid Cash then adding together the cells of each account I wanted. Included that data in the chart and voila, I now have a chart showing my liquid cash which changes with the date range selected.

Thanks for the guidance!

Glad to hear you were able to build the solution you wanted, @henderson.shay.

1 Like

@randy Thank you for the excellent sheet to work from!