CeSaw - I cannot express sufficiently how helpful it was that you were able to divine such a solution to this error.  In my case, the glitch has been frustrating one of my client's books since mid 2020.  Clearly the order of entry for the Accounts was the culprit here, just as in your case.  I hope you have a wonderful holiday season, and please know that you have saved me countless more hours trying to correct what had become a multiyear discrepancy issue. 

All the best,

Ryan W