Insights template net worth calculation

Google Sheets
1

The Assets and Liabilities in the Insight template are different than they are in the Net Worth and Net Worth Snapshot templates.

2

Hi @bill:

My totals appear to be consistent across these templates in my sheet. Can you be more specific about what you’re seeing?

3

The asset cell (H11) has the following formula:

=sumif(T4:T,“Asset”,U4:U)

The problem with that is that Column U does not contain all of my asset (or liability) accounts, so the Asset total is incorrect, as is the Net Worth calculation.

I’m not sure how Column U gets populated in the first place, as it’s a hidden column.

Bill