If you are struggling to setup the Sage 100 ERP Bank Reconciliation for the first time here is a good set of instructions which will walk you through the initial setup including clearing out the old transactions which may have accumulated since the Bank Reconciliation was installed.
See:
http://infosource.sagesoftwareonline.com/infasp/kdb.asp?isresolutionconceptid=400480