Here are some hints and tips about Bank Reconciliation that will make it easier for you to perform and understand Bank Reconciliation in Sage 500:

• The ‘Book Balance’ is the balance in Cash Management Module. It is not the General Ledger balance in General Ledger.
• How is the Bank Balance (Book Balance) calculated in Reconcile Bank Statements: The Book Balance is the sum of any beginning balance entry made in Cash Management (CM), plus the outstanding transactions sourced from Accounts Payable (AP) checks, Accounts Receivable (AR) deposits, and CM transactions, including adjustments in the current batch.)
• GL does not write to CM. Any adjusting transactions that must affect GL and CM must be entered in CM Process Bank Transaction’s task.
• The Bank Reconciliation should be reconciled in sequential date order 
  • It does not have any type of reversal method once the batch is posted.
  • Check the Bank Account Statements  Explore task to see the order (by date) of the reconciliation’s performed
  • Be aware of the Reconciliation date since it cannot be changed once the batch is posted.
  • The Reconciliation Date can only be used once. The Reconciliation Date defaults in increments of 1 month, so if you change the date to the 1/15, the next batch will default by 1 month to 2/15.
• Cash Management Module uses Transaction date of the transaction while all the other modules reports normally use the Post Date of the batch.
• The deposit date from the batch header in AR Cash Receipts is used in CM Bank Reconciliation and CM inquiries as the Tran date but in AR and GL the tran date is payment date. 
• The Cash Management Beginning Balance transaction does not post to GL. Once you have entered a beginning balance transaction the transaction type is no longer available in Process Bank Transactions.
• Our on-line knowledge base has multiple articles on Bank Reconciliation troubleshooting including KB 19716 'How to reconcile bank statements'

Cheers!