Issue with reconciliation numbers not matching

Let’s sort this out, @ibexie.

Most balance issues are caused by an incorrect opening balance, voided, deleted, or modified amount of a previously cleared transaction.

To resolve this, review the opening and beginning balances. Make sure you've entered the correct amount. You can use your actual bank statement to compare the figures. I’m glad to show you the steps:

1. Sign in to your bank's website, or find your bank statement.
2. Check the account's balance for the same day as the opening balance in QuickBooks.
3. Compare the two balances.

If they're accurate, check the ending balance you entered. Here’s how:

1. In the Reconciliation window, select Edit info.
2. Review the Ending balance and Ending date.
3. Make edits if needed.
4. When you're done, select Save.

You can also review your account register to ensure everything’s correct and intact. Check out these resources to learn what causes balance issues and how to fix them:

• Fix issues the first time you reconcile an account in QuickBooks Online
• Fix issues at the end of reconciliation in QuickBooks Online

If you need to make changes for your completed reconciliation, you can use this article as a reference: Learn the reconcile workflow in QuickBooks. Instructions are located on the bottom part of the page.

Please let me know if you have any other questions or concerns besides reconciliation. I’ll be here to help. Keep safe always!

Thanks for your reply.

I've followed your steps, and I'm still having trouble. The opening balance is correct. But I can't find an "Edit info" button in the Reconciliation Window. When I click "Fix the Issue" in the reconciliation window it takes me a new screen that asks me to correct the transactions above, but there are no transactions above.

The fundamental issue is that the closing balance from last month's reconcile (according to the reconcile report) is a different number than the "Beginning Balance" in the Reconcile Window when I try to reconcile this month's statement. What would cause that to happen?

I found the problem! It was a flavor of what you said the in first sentence of your reply, basically some "voided transactions" in the past.

Your post got me thinking so I started scrolling the register to see if anything stood out and sure enough, about 12 (not synchronous!) transactions had been marked from reconciled (R) and changed to simply categorized (C). These were transactions from over a year and a half ago. Kinda unsettling as I have no idea how that happened, but as least it's fixed.

Thanks for your help!

You're welcome, ibexie.

We're glad that you're able to fix your reconciliation issue.

Please feel free to visit us here if you have other concerns. We're always here to help. Have a great day!

Hello there. I have more or less the same issue, but only with the investment account. I have tracked all transactions that are in, and I have done monthly reconciliation. I noticed that after reconciling one month and checking the opening balance for the new month, when I reconcile again there is still a gap. I have seen this from January to September. Now that we are in October, I am observing that the difference is increasing slowly, making it show more in the bank and less in QuickBooks every day. The amount shown in QuickBooks as bank balance matches well with what I have in the bank system. But the one in QuickBooks is getting smaller day after day. Any way to help?

Hello there. I have more or less the same issue, but only with the investment account. I have tracked all transactions that are in, and I have done monthly reconciliation. I noticed that after reconciling one month and checking the opening balance for the new month, when I reconcile again there is still a gap. I have seen this from January to September. Now that we are in October, I am observing that the difference is increasing slowly, making it show more in the bank and less in QuickBooks every day. But the one in QuickBooks is getting smaller day after day. Any way to help?

Hey , @JPRU. 

Thanks for chiming in on this thread. 

Let's review these actions listed on this guide to help narrow down the cause of the problem: Fix issues when reconciling. 

If none of the information listed helps, I recommend contacting our Customer Support Team so they can review your account with you. Here's how: 

1. Go to the Help icon in the top right-hand corner. 
2. Press the Contact Us button. 
3. Enter your question and hit Let's talk. 
4. Scroll down and choose to Get a callback. 

Please let us know how it goes. Have a wonderful day!