QB Issue Resolution:

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:

Reconcile beginning balance does not match the previous ending balance
Opening balance in the Reconcile Account window is wrong
Beginning and ending balances on a reconciliation report are incorrect

How to fix it

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.

Press Ctrl + A on your keyboard to bring up the Chart of Accounts.
Right-click the original bank account and select Edit Account.
Add the word OLD to the Bank account name.
Click Save & Close.

Create a new bank account.
Press Ctrl + N when you have the Chart of Accounts open.
Select Bank in the Choose Account Type window; click Continue.
Enter the name of the original Bank account in the Account Name field.
Entering other details about the account are optional, DO NOT enter an Opening Balance.
Click Save & Close.

Transfer funds from original bank account to the new bank account.
Go to the Banking menu, select Transfer Funds.
Enter the date from your last bank statement in the Date field.
Select the OLD Bank account in the Transfer Funds From field.
Select the NEW Bank account in the Transfer Funds To field.
Enter the Ending Balance amount from your last bank statement in the Transfer Amount field.
Click Save & Close.

Reconcile the new bank account.
Go to the Banking menu, select Reconcile.
Select the new Bank account from the drop down.
Enter the statement ending date from your last bank statement.
Enter the ending balance from your last bank statement.
Enter any Service Charges or Interest Earned if applicable.
Click Continue.
Check off the transaction created in Step 3, verify that the Difference in the bottom right shows 0.00.
Click Reconcile Now and print reconciliation reports.

Move outstanding transactions (transactions in transit) from the old Bank account to the new Bank account.
Open the Register for the old bank account.
Open each transaction that is dated after the last statement date and other transactions that have not cleared.
Edit the Bank account on these transactions and change to the new Bank account.
Click Record in the Register for the old bank account and close it.

You will now have a Bank account in QuickBooks 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.

Resolution for Issue 'Create a new bank account to resolve reconciliation discrepancies.' available: Yes (Solved).
Source: Intuit Community forum.

Create a new bank account to resolve reconciliation discrepancies.: this issue or error code is a known issue in Quickbooks Online (QBO) and/or Quickbooks. Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Quickbooks issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If it is a complex issue or you are unable to solve the issue, you may contact us by clicking here or by using other support options.

Support for Bank Reconciliation
Quickbooks Repair Pro will resolve it efficiently and affordably. Guaranteed resolution of your issue, or you pay nothing!

Error Recovery for Bank Reconciliation [Canada]
E-Tech is the #1 Quickbooks data migration and Conversion service provider.

Get 50% off Quickbooks Online

Click Here for 50% off!

Additional Support Options: