Why doesn't the "quickbooks balance" for my fixed assets match my balance sheet for fixed assets?

In other words, why is it doubled?

@john-pero Thanks for the reply but just so we're not wasting anyone's time here:

• I never have - and never will - reconcile my bank account through QBO. It is not necessary and can cause a lot of headaches. I manually reconcile my accounts every morning. I have done this for three years. To the penny. There are no issues there.
• I know how to set up a fixed asset account.
• I know what parent and sub accounts are.
• I know what account summing is.
• I know that the sum of a given Fixed Asset account (as I said in my post) should be Original Cost minus Accumulated Depreciation.
• I do not have any "extra transactions."
• I know how to track improvements made to fixed assets and I how to depreciate them.
• My balance sheet is accurate.
• The registers for the fixed asset accounts are accurate.

I should probably have been a little clear in my post: Next to "Ending Balance" QuickBooks is DOUBLING the actual balance of the fixed asset register, which, itself appears to change depending on how I sort it by date.

Please see attached screenshots. In the first screenshot (sorted by date descending), note the "Balance" in the right hand column next to the journal entry "04/27/21" journal entry. It says "124,872.78." This number matches the number under "Ending Balance" at the top. But both are wrong - they are exactly DOUBLE the accurate balance.

In the second screenshot (sorted by date ascending) note the note the "Balance" in the right hand column next to the same journal entry "04/27/21" journal entry. It now says "62,436.39." This is the SAME journal entry as above. This balance is correct and does not match the number under "Ending Balance" at the top.

Also see my redacted balance sheet for the same fixed asset account. It is summing its sub accounts correctly and reporting the correct number.

Here's another example. Notice how the actual sum of the sub accounts is half of what QBO says it is...

@john-pero No problem at all; I was just trying to be more clear, which I should have been in my original post.

I did end up calling QBO support and the guy was actually helpful. He basically said it had bugged out.

So we just created new parent accounts and moved the sub accounts into them as appropriate. They are summing correctly. We then deleted the old parent accounts, which still showed a balance even though they were empty and their registers were empty.

When we deleted them, QBO did not make any adjusting transactions so it looks like all is well at this point.

Thanks for your help.