How to report Net Worth correctly IF I have two separate Foundation Google sheets?

Ask Anything
1

Newbie here.
Finding that one “uber large” mix of credit & bank transactions mixed with investment transactions is a mess. So,

  1. How / where does Net worth get calculated if two templates are used?
  2. Given I’ve got everything in one sheet now, how do I unwind that?

Thanks,
Paul

2

Hi Paul,
The way I like to set it up is using two separate Foundation Sheets.

  1. Feed all accounts into one and hide all but the Balances and Accounts tabs. Configure these two tabs and ignore everything else in this sheet. The only purpose of this one is to calculate Net Worth.
  2. Feed only your credit card and bank account transactions into a second sheet and hide the Balances and Accounts tabs here. Configure the Transactions, AutoCat, Categories, etc. in this sheet and ignore the balances. The only purpose of this sheet is to track income and expenses.

To unwind it – I think it depends how far along you are. Probably the easiest is to take your existing sheet where I imagine you have likely spent the most time configuring Categories, Transactions, and AutoCat, and disconnect the investment accounts from this sheet. Then go into the Transactions tab and sort by account, and then filter to select anything that is associated with the investment accounts you just disconnected, and delete those transactions. Then go set up your second sheet feeding in all your accounts including the investment accounts (see #1 above).

2 Likes