One of the most common causes of reports not matching the Trial Balance is due to a GL entry having a branch_id of 1. Since the Trial Balance report ignores the N/A branch that amount will not factor into balance even if it shows up on other reports. This script comes from the larger GL issues script, but it is more efficient on larger databases to use the smaller portions.
Select 'Bad Branch' As 'Problem', * From GL_Register glr Where Register_ID <> 1 and Amount <> 0 And
(Branch_Id = 1 or Branch_Id is Null or Not Exists (Select Branch_Id from AR_Branch Where Branch_Id = glr.Branch_Id))
