Help with creating a Liquid Cash Tracker

Microsoft Excel
, ,
1

Hello!

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!!

2

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.

3

Thanks for the reply.

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

4

Same one on that thread.

5

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!

6

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

1 Like
7

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

1 Like