Reconciliation error

Hello there, @julie39.

It's great to see you posting here in the Community space. I'd be glad to provide details to help you fix the bank reconciliation error you've encountered.

I suggest double-checking if all of your transactions match your bank statements. You'll want to start by reviewing the original opening balance. Simply go to your Chart of Accounts and make changes from there if necessary. Here's how:

1. Go to the Gear icon at the right top.
2. Select Chart of Accounts under Your Company.
3. Locate the account, then click Account history under Action.
   
   
4. Find the opening balance.
   
5. Edit the date, then the amount if needed. Just click Edit to make your changes. 
6. Select Save and close.

Moreover, you'll get a message before you start reconciling if anyone makes a change that affects your beginning balance.

1. Click We can help you fix it link to open your discrepancy report.
   
   
2. Review the discrepancy report. 
3. Before editing anything, talk with whoever made the changes.
4. Select View to see the history of changes to the transaction.
5. See the Change Type column as it tells you what changed.  
   
   
6. Make edits based on the message in the Change Type column: Amount changed, Unreconciled in register, Reconciled in error, Deleted.

For the steps you need to take regarding the specific message, simply go to Step 4 in this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

Furthermore, I'd recommend seeking assistance from your accountant to ensure that your books are accurate and to avoid messing up the data. They'll be able to help and provide more expert ways of dealing with this situation.

I've also added these references as your guide to view various guidelines that will guide you in reconciling the transactions:

• Fix issues at the end of a reconciliation in QuickBooks Online
• Learn the reconcile workflow in QuickBooks

Please keep us updated on how it goes or if you have other questions in mind, don't hesitate to reach back out. I'll be here to lend a hand. Keep safe!

Mary Jane at Quickbooks advised me how to synchronise the opening balance in Reconciliation with the displayed balance in the Banking Register.  This works if the register balance is correct and the reconciliation balance is wrong.

Open the Reconciliation window and enter the date of the day immediately following the one offered to you with the incorrect balance. 

Ensure that there are no entries in the Banking Register.  If there are redate them one day following the selected day so that that day is empty. 

Then hit the Reconcile button and follow the instructions that QB gives you to the bitter end regardless of what it shows.

Don't approve any data entries which the program shows you. Ignore them and close the window.

Reopen Reconciliation to reconcile the next period which will start on the day after your imposed date with the correct opening balance.

Without the advice I'd never have thought of this trick which makes a period of the single day without any activity except importing the closing balance from the Banking Register to use as the opening balance of the next period. TahDah!