Skip to main content
M
michellewarburton96
January 12, 2022
Question

QB Online Fixing Deleted Transactions in Reconciliations

  • January 12, 2022
  • 1 reply
  • 0 views

I deleted 7 reconciled transactions to correct some other double check issues and now I'm getting the message saying I can't reconcile this month until I fix the 7 transactions I deleted.  I recreated the transactions and manually marked them as reconciled.  After do that and I go to reconcile the account it has now created 7 new discrepancy items matching the Check transactions I entered with change type of "Reconciled in Register".  These are not we transactions.  I made sure to date them their original date and have confirmed the dates in the register match the dates cleared on the bank statement.  The 7 original Change Type of "Deleted" are still there as well.  When I recreated the 7 transactions I made sure I matched them exactly to the transactions deleted based on the Audit Trail.  When I review the Reconciliation Report for each of these transactions and their time periods they still show up on the reports as "deleted" even though I have recreated them and marked them as R in the register.  Here is the other wierd thing.  My original  TOTAL DISCREPANCY DIFFERENCE was $4216.02. The balance did reduce by the amount of the checks I recreated which was $3833.95. Even after recreating each of the 7 checks I still have a TOTAL DISCREPANCY DIFFERENCE in the amount of $382.07.  I have no clue where this amount comes from since there were no other discrepancy messages.  Any help you can give me is greatly appreciated.

1 reply

JenoP
JenoP
January 13, 2022

Thanks for sharing details and what steps you took to resolve the issue, CZtigergirl.

 

There are times that too much cache stored in your browser would lead to unexpected results when doing something in QBO. We have some basic steps to share to check if that's the case.

 

First, use an incognito/private browsing session or switch to a different browser. Let me share these keyboard shortcuts to open an incognito session: 

 

  • Ctrl + Shift + N  for Google Chrome
  • Ctrl + Shift + P for Firefox
  • Control + Option +P if you're using Safari
  • Ctrl + Shift + P for Microsoft Edge

 
Second, proceed to the Reconcile window and check if discrepancy is no longer there. If the numbers are looking fine, go back to the regular browsing session and delete your browsing history. Here's an article as a guide: Clear Cache And Cookies To Fix Issues When Using QuickBooks Online. 

 

Feel free to check out or save these reconciliation-related articles in case you need additional references:

 

 

Don't hesitate to reach out again and visit us again if you need anything else. We're always here to answer all your QuickBooks-related questions and inquiries

B
BethPeoples
August 29, 2023

I tried the advice above and it did not work for my session.

 

I had deleted many duplicate checks after unreconciling them in the register, but they are still showing on the discrepancy report. I cannot proceed until they are fixed. Help please!

KlentB
KlentB
August 29, 2023

Resolving this issue is crucial for maintaining accurate books, and I'm here to assist you in finding a solution, BethPeoples.

 

When you unreconcile and delete a duplicate check, particularly one that was previously part of a reconciliation, it can disrupt the balance between your QuickBooks records and bank statements. This misalignment can lead to a persistent variance, and despite the transactions being deleted, they might still appear on the discrepancy report.

To properly fix this, we'll have to undo and redo the reconciliation of the affected period. To minimize the effect of the changes, we can only do it one at a time. Here's how:

 

  1. Go to Bookkeeping.
  2. Choose Chart of accounts.
  3. Open your bank register, then locate the appropriate transactions.
  4. Select them to expand the view and review the Check column.
  5. Keep clicking the checkbox until it becomes blank.
  6. Hit Save to confirm the action.

 

After that, let's reconcile your account again. Remember to be cautious and thorough during these procedures. 

 

If you're uncertain about any step, consider seeking guidance from an accountant. You also have the option to invite them to your company so they can restart the entire reconciliation.

 

Additionally, here are some resources that will help you resolve common reconciliation errors or problems:

 

 

Keep in touch with me if you need further assistance in accomplishing your other bookkeeping tasks and managing your financial reports. I'll get back to ensure you're taken care of.

Terms & ConditionsAccessibility statement