RE: Balance Sheet Out of Balance
By a lot or a little? Could be something that has been going on a while so it’s bad setup or it’s a one off posting. Initial thing to do would extract the general ledger entries, just search for the page. Depending on your chart of accounts numbering you will already know but you want to locate postings that use a balancing account from the same section of the CoA. In excel I think this is easier as you can do multiple column sorting.
Once you locate the entries you will want to reverse them and then make correction postings. If there is a lot I would check where the troublesome accounts are used in setup or the source code of the transaction and batch name to see who is doing it.