We are have extreme issues reconciling and finding the variances between the adjusted bank balance and the general ledger.  Our system shows a variance, but it can't be tied back with the recommended reporting.

We also show bank deposits that have been reconciled but are showing open as if they were never deposited?  

How can we clear this up and move forward in our system?  New bank accounts?  Does that mean we are needing to re-enter all the information?  How can we get a functional, working balance with no variances?