Reconciliation

You have a similar situation as I do. I had this one transaction that reconciled normally back in July of 2020. I went on through reconciling to the end of the year. Everything balanced and all was good for the end of year P&L report to the cpa tax person.

Start 2021 reconciling. January went smoothly but somewhere along the way after that point, this July 2020 transaction pops up as unreconciled. Now how did that happen I wonder? Several changes later and it's still there and unreconciled. The QB support suggestions were great and all but I had done all that was suggested and nothing has worked. Only one thing remains that I am not sure if I tried or not, a 'reconciliation adjustment'. I think I tried that but somehow I could not get it to post correctly and it caused an out of balance error in the account. I'm going to try this again and see what happens just to be sure. The last thing I may have to do is schedule an appointment with my cpa tax person and see if he can help me out.

Good luck to you and I hope you get it figure out soon!

Thanks for visiting the Community today. I'm here to help ensure you're able to fix your reconciled transactions with QuickBooks, JKrener.

I'd suggest you recreate the transactions under the same account where it was previously reconciled and you'll have to manually tag them as reconciled so you won't have any issues next time you do a reconciliation.

1. After recreating the transaction, click Accounting on the left menu.
2. Go to the Chart of Accounts tab.
3. Click View register and look for the recreated transaction.
4. Under the Reconcile (✓) column, click on the blank field to mark the transactions as reconciled (R).
5. Click Save and select Yes to confirm the action.

For more insights, I'm adding the article I recommend on this to scroll down to Manually clear, unclear, reconcile or unreconciled individual transactions:  How to unreconciled a transaction or undo a reconciliation.

Here are some articles that can guide you more on how to resolve reconciliation discrepancies: 

• Fix issues for accounts you've reconciled in the past in QuickBooks Online.
• Fix issues the first time you reconcile an account in QuickBooks Online
• Fix issues at the end of reconciliation in QuickBooks Online

Reach out to me if you have any other QuickBooks or reconciliation questions. I'm a post away to help. Have a good day!

You say to 'recreate' them. I currently have this transaction standing uncleared, unreconciled, unchecked at the moment. Are you saying to check it as reconciled? Won't this affect the beginning balance of the next reconcile period? I think I have gone round and round with doing this. Even deleting the transaction and adding it back and changing from one thing to the other. I'm left scratching my head again with this and cannot move forward.

Thanks for coming back here, Pstreicher.

I'd like to clear things out. 

The steps shared by my colleague TirzahC is to manually reconcile the transaction if someone accidentally unreconciled it. This process will correct the beginning balance for that specific period. If you're unsure of the steps and have other questions, I recommend consulting with your accountant. They can help get back on track.

In the meantime, here are the possible causes why you have an incorrect beginning balance: 

• Someone entered an incorrect opening balance when they created the account in QuickBooks.
• Someone added transactions that are older than the opening balance, but didn't edit the original opening balance entry to reflect the change.
• Someone edited, deleted, moved, or unreconciled an already reconciled transaction. This changes the ending balance of your last reconciliation, which impacts the beginning balance of the next one.
• Someone manually reconciled a transaction, so it didn't show up on the next reconciliation.

To view the changes, you'll want to run the Reconciliation Reports by following these steps:

1. Go to Reports on the left panel.
2. Type Reconciliation Reports in the search field.
3. Select the Account and Report period from the drop-down menus.
4. Click the drop-down arrow under the Action column and select the View report link.
5. Review the changes under Reconciliation Change Report section.

If you want to see the user who made the change, you can open the Audit log from the settings menu. 

For reference on the steps above, you can read these articles: 

• Fix issues for accounts you've reconciled in the past in QuickBooks Online
• How do I view, print, or export a reconciliation report?
• Use the audit log in QuickBooks Online

Please feel free to leave a reply below if you have any follow-up questions about your reconciliation or other concerns. I'd be glad to answer them. Take care and stay safe.

Do you know how to delete my bank reconciliations. I need to start fresh from last year. How can I delete my reconciliations.

Please help.

Frankie J