Net worth in the reports significantly differs from Net worth in Accounts

Indeed, I had never thought to click there. When selecting all accounts / dates / type / transactions, I get a total of 31204, significantly less than what my grep found. I'm not sure if this is relevant to the problem I reported in my OP. I was just trying to get a count to show why I wasn't going to start fresh.

Also, I'm using R57.12 .

So, I investigated this with an account with less history, that was also showing the wrong balance in the net worth report.

• In the register, it started at $0 on 4/8//2020, and closed at $0 on 6/21/2021 .I
• I opened the net worth report, clicked the green bar, and double-clicked on the account in question.
• It showed a final balance of -$20,000 on 6/21/2021 . At least it got the date right.
• II then used the "save" button to "Export to Excel workbook". I then opened the document in Excel.
• I used a "SUM" formula to add up all the transactions listed. They added up to -$20,000.
• I added a "running cash balance" column
  
• I then closed the net worth report report, and opened the closed account register, under Investments / More accounts.
• I started comparing the transactions in the Excel spreadsheet (exported from the report) with the ones in the register.
• Immediately, I could see a difference, at the second transaction.
• Here is what it looks like in the data from the report :
  
  
• Here is what it looks like in the register for the same account :
  
  
  
  
• Notice that the 4/15/2020 transaction is very different between the two. It's for $5,000 in the report, and $25,000 in the register. The report clearly has the wrong amount.
• The 4/20/2020 running cash balance is only $5,000 in the net worth data, which is incorrect. The balance in the register is correctly $30,000 .
• Notice that one transaction is an "Xin", while the other is a "Deposit". I'm not quite certain why. It may be that one was downloaded, and the other entered manually.
• If I double-click the "Deposit" 4/17/2020 transaction in the register, it shows :
  
  
• It is actually a transfer, with the source account linked in [ ] brackets. The cash is coming from the same account as in the 4/9/2020.
• The first transaction is being counted in the net worth report, but the second transaction is not. Seems like a bug to me.
• If I modify the 4/15/2020 transaction and change it from a Dep to an Xin, and re-run the net worth report, the account correctly shows with a $0 final balance.
• Unfortunately, it then shows as +$20,000 in the register, even though there is no cash or securities in it. The "holdings" button shows this :
  
  

It's as if there is "phantom" security in the account, worth $20,000.

I then ran "validate and repair" again, and it fixed that particular issue - now the register and the report both agree that the final balance on this account is $0.

However, with 168 accounts, who knows how many "Dep" transactions I have that are actually transfers ?

It's a bit odd to have 2 ways of registering the exact same transaction - Xin or Dep. The reports should be treating them identically, though, just like the register does.

Unfortunately, that is not the only cause of discrepancies. I found one account with about 1,500 transactions, which is off by 3 cents between the register and report, and no "Dep" transactions. Probably not the top priority to fix that one, but it still looks odd.

The Fidelity account also has 5,867 transactions, but not a single one is a "Dep" transaction. So, it looks like there is still another problem.

Been investigating the Fidelity account. The register and reports final balances agree for 2010 and 2011. They diverge in 2012.

I compared monthly balances, and identified that the change happened at the end of October, on 10/30/2012.

It came from a split transaction from a paycheck. I bothered to enter every single line of every paystub into Quicken as split transactions the last 17 years. Don't ask why. Anyway, on that particular date, line 25, the last line of the split transaction, had nothing listed in the "Category", "Tag" or "Memo" column. Only an amount of $925.75 . In the register, that amount disappears - it is not added to the cash balance. of the Fidelity account. It just vanishes, apparently.

In the report, however, it does appear, and gets counted in the Fidelity account balance. The error affects all subsequent dates. And of course, this is the only such transaction I found with the problem. There are likely many hours.

I'm scratching my head as to where that $925.75 went. I looked at the previous paycheck on 10/12/2012. . Lines 1-24 are identical with 10/30/2012. Line 25 was for the company ESPP, but for a different amount, $675.75 .

Even stranger, the ESPP account shows deposits of $675.75 for both dates. And they are listed as transfers from the Fidelity account. The 10/12 deposit is from the split transaction, and can't be changed.

The 10/30 ESPP account deposit, for $675.75, can however be edited (date, amount). It claims to be transfer from the Fidelity account. But that transfer never appears in the Fidelity account register ! Seems like it would be an obvious thing for the "validate and repair" process to check - whether transfers have proper cross-references or not. But apparently not.

I still don't know exactly what to do with this hidden amount. I know I balanced the split transactions at the time I entered them. I am sure the amount was transferred somewhere. Just can't see where at the moment. It seems to affect every paycheck for that employer through 1/2017, at which point I changed the direct deposit to my credit union, and those split transactions are fully balanced. They can't directly be compared with the previous pay stubs for various reasons, new means new tax tables, higher benefit costs, 401k deductions starting again, etc.

It looks like some transfer data from split transactions got lost somehow.

Another issue I found was related to a short sale transaction - specifically, writing option contracts. listed.
There was no share count. This did not pose a problem as far as the register balance was concerned.
But it very much did for the net worth report.

The fix was to :
a) set a share count . In this case, it was 4 contracts, so it had to be 400
b) set a share price . It was $0.01, per my brokerage statement
c) set the commission in the transaction - it was $2.06
d) create a balancing transaction to buy back these 400 shares for $0 (since the options expired)
After that, the closed account with $37.94 no longer showed up in the net worth report.
Sigh.