Why does account lose correct balance when filter for Current Year?

Question

I've filtered all my accounts to be Current Year. They've always worked until now. All of them are working except one ... the balance on it is completely wrong. Any idea how to fix this?

Donnette · Answer

Had some illness in family so didn't look at this until now.  I did what I believe you suggested. I did a 60 day view. The ending balance is not correct. I found the balance after the 1st transaction of this view, and it is also not correct. I then did a 90 day view, and the ending balance is correct, and I found the same transaction that was the 1st one in the 60 day view, and it is also correct in this view.

lhossus · Answer

So what happens if ...

For the oldest transaction on the Last 60 days filter view (i. e. a transaction on Nov 6th or thereafter). This would be approximately the starting balance for the 60 day period.

Compare that transaction's running BALANCE value in the Last 60 days view to that same transaction's BALANCE value in the Last 90 days view.
Do they match?

Since the ending (today's) balance differs depending on the filter view, I expect the starting balance to be different as well. Can you see what happened in the interval between 90 days ago and 60 days ago that messes up the balance at 60 days ago?

PS: be SURE the register is sorted by the DATE column. All bets are off if it is sorted otherwise.

Donnette · Answer

There is only 1 opening balance, and there are no Bal Adjustments. It is a very simple account - it is my Cash account so there are no downloaded transactions.  The complicated accounts are all working perfectly, which is why this makes no sense.