Thank you both for the advice. Unfortunately, this is a different issue that actually involves only close periods/years. I'll attach balance sheets from a closed year as an example. One is a correct balance sheet before the creation of this expense account and one out of balance from just after the creation of the account. No individual accounts are off balance, it's simply as if Retained Earnings magically gained $3,364.64 when the account was created, but gained that over five years before the account was created.
Also attached is a screnshot of the bottom line of the Trial Balance report. Every year from 2015 on shows this beginning balance and ending balance of $3,364.64 in a sort of phantom bottom line.
An accountant asked if xTuple has a utility to check for errors, but it doesn't right? Is there something I could try directly within the database?Balance sheet noon good.pdf (56.8 KB)
Balance sheet 2pm bad.pdf (56.8 KB)