Reconciliation errors in QBO

Good day, and thank you for sharing those details, JackieY.

Let's work together and fix your reconciliation issues in QuickBooks Online.

Based on the information you shared, it is possible that someone made some changes to a reconciled transactions. 

With that, you can use the discrepancy report by clicking We can help you fix it link to review which transaction was changed and how to make those corrections. But before editing anything, talk to the one who made the changes. This changes might be intentional.

Once you know what needs corrections, check each transaction one at a time. 

Like this:

1. Select View to see the history of changes to the transaction.
2. Review the Change type column.
3. Make necessary changes based on the message in the Change Type:

• Amount changed - It means someone edited a reconciled transaction or moved it to another account. To fix it:
  a. Click the transaction to expand the view.
  b. Hit Edit to open the form.
  c. Adjust the total or change the account as needed.
  d. Select Save and close.
  
  

• Unreconciled in register - it means someone unreconciled the transaction. To reconcile it again:
  a. Click the transaction to expand the view.
  b. Tick the box in the checkmark column until you see an R. This manually reconciles the transaction.
  c. Then hit Save.
  
  

• Reconciled in error - it means the transaction was accidentally reconciled by someone. To remove it and add it to your next reconciliation:
  a. Select the transaction to expand the view.
  b. Click the box in the checkmark column until it's blank or you see a C. This removes the transaction from the reconciliation.
  c. Then hit Save.
  
  

• Deleted - This means someone deleted the transaction. If this was an accident, recreate the transaction exactly as it appears on your discrepancy report.

Once you review everything on the discrepancy report, the Total Discrepancy Difference on the report should be $0.00. For more details, you can check out this link: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

I've also added this article for the complete reconciliation guide: Learn the reconcile workflow in QuickBooks.

Let me know if you have additional questions about this or anything else. I'm always here ready to assist. Stay safe.

Hi Archie_B,

Thank you for the detailed steps to correct my reconciliation issues.  While I feel like I had done these steps before posting this issue, when following your steps 1 by 1 for each of the items in question, I was able to find duplicate transactions and invoices that needed correction.

Thank you so much!