You use the Aged Trial Balance with the "Calculate as of" option to get the number tha should tie back to the GL. It won't tie back if anyone has made journal entries driectly to this account in Ledger. You can find out if this has happened by creating a source journal or drilling into the transactions and seeing if any of them have a source coude that doesn't start with "AR".