Net Worth tab values do not match Net Worth Snapshot

I noticed the values in the Net Worth tab do not match those found in Net Worth Snapshot. For example if I look at Net Worth for Jan 31, 2021 in the Net Worth tab, it is different from what I see in the Net Worth Snapshot for the same Jan 31, 2021 date. I see the Net Worth tab is pulling some balances for an account which have already been moved way before Jan 31, 2021, but somehow are still showing up which is causing this discrepancy.

Any ideas what might be going on?



I did some debugging, it appears that the Net Worth tab is picking up in correct balances. I noticed that some manually updated balances in the Balance History Date appear later in the list, even if they were entered more recently. This makes the Net Worth sheet lookup fail somewhere and pick-up incorrect values. I moved a row in Balance History up for one of the accounts and only then the sheet was picking up correct balance.