In some situations it may be impossible to reconcile an account without creating a large adjustment for the discrepancy. This could be the case if reconciled transactions have been deleted in prior periods, if reconciliation's have been performed using amounts other than the ending balances from bank statements, or if there are just too many errors to track down otherwise.
Before proceeding with the steps below, try to troubleshoot reconciliation discrepancies using one or more of the following KBs:
What to expect:
At the end of these steps you will have a new Bank account in your Chart of Accounts with an accurate Reconciled balance.
Important: Before following the steps below, back up your company file.
Edit the name of the original bank account.
You will now have a Bank account in QuickBooks Desktop with an accurate reconciled balance for future reconciliation. The new account will also have the outstanding transactions that have not yet been reconciled, and the historical detail will be in the register of the old Bank account. If there is a remaining balance in the old Bank account discuss with your Accountant how this balance can be adjusted to zero.