Skip to main content
A
Alexandra16
February 24, 2022
Solved

I reconciled an acct but saw I had 7 duplicate transactions. I deleted the 7 dup's so acct register is now correct. How to redo reconciliations? I don't have an acctant.

  • February 24, 2022
  • 1 reply
  • 0 views
My understanding is your accountant has to undo a reconciliation for you. This is an expensive option for me and I do not want to do it. I also do not want to pay QB for a bookkeeper to make the fix for me. Again as above, the error was there were 7 duplicates (put in by QB for credit card payment transactions, frustrating) that I did not catch until I completed my reconciliations. Now that they are complete, I do not see a way to undo. I removed the "r" on the transactions but that did not help me refresh the reports, so I went ahead and deleted the duplicate transactions. At this point my account register is perfect, it is just the reconciliation reports that are off. Going forward into 2022, they will continue to be off unfortunately. The error is -$5386.90 in "uncleared" transactions (the duplicate payments). If I can somehow add a transaction in to cover this and fix my reconciliation, that would be fine too. Would be grateful for any help here -- so frustrating I cannot just go undo reconciliations myself. Thanks!
Best answer by Pete_Mc

Thank you for this. I am attaching a screenshot -- is this what you mean about me "redoing" my statement ending in 1/27/22? You'll see none of the transactions show up as they did when I initially reconciled. However it does zero out, which is perhaps what was intended? Please let me know; I'll wait on your response before I click "finish".


Yes!

 

I can't tell from the screen shot, but if you entered in the Date Jan 27, 2022) and the Statement Balance, then just hit the Finish Now.

 

Everything is now in Balance and you've removed all of your Duplicates.  So *hopefully* this will clear out your Report issue.  QBs does not always do what we expect, but I'm hoping it will.

 

Last case scenario which I believe we discussed very early on was that an Accountant can reverse the Reconciliation.  But I don't think that was a path you wanted to go down. 

1 reply

P
Pete_Mc
February 24, 2022

Not being able to unreconcile is one of the big flaws with QB Online.  But for your issue, I'm a little unclear...  

 

If they were duplicate and not real entries, then they should have been left UNChecked when you Reconciled.  If you needed to check them to match the Statement, then they should have been left in your Register and should have been marked off when you Reconciled. 

 

Before you deleted them, did the Reconciliation have a $0 Balance?

 

And were these entries really "duplicates" or were they incorrect entries where the bank later put in a Credit? 

 

If they are truly DUPLICATES and not real entries (not incorrect transactions, but transactions not on the Statement) then just Delete them.  BE CAREFUL not to delete the Real Transaction that is associated with an Expense. 

 

If this was last month.  When you have cleaned up the Duplicates.  Reconcile again and enter the closing date from the Statement and the Closing Balance.  In theory there should be nothing to check off and you should have a $0 Balance.  Finish the Reconciliation and then check your reports.

 

Otherwise, give us a little more info of the actual steps you've gone through so far.

 

A
Alexandra16Author
February 24, 2022

Thanks so much for this speedy reply!

 

Yes, when I reconciled, all the months had a $0 balance for the reconciliation. It was just that the "Uncleared transactions as of 01/27/2022" (last statement ending date) had a negative number (-5,386.90 for the most recent statement) and the register balance was negative (-4192.63). The register balance should have been the ending balance for the card ($1194.27) but instead was added to the negative balance accrued by the duplicate credit card payment transactions. To clarify more, the top part of each reconciliation report is correct -- the part that is the error is the "uncleared payments and credits" section which includes these duplicate payments.

 

And per your points, yes, that is correct, the transactions I deleted were duplicates and were not checked off in the reconciliation (not real transactions tied to an expense). I know because a couple of times I chose the wrong one to delete, and a warning message appeared saying that it was tied to an imported transaction -- so I knew to cancel and chose the other one.

 

With the new month, it looks like it will also come to $0 balance when I reconcile. I had hoped there was some way to refresh past reconciliation reports to reflect the deletions but sounds like there is not. I will have to see whether the new month's report will be refreshed and not contain the erroneous "uncleared transactions"... or whether it is based on the data already submitted for reconciliation from prior months.

 

Let me know if this sounds right, thanks very much again.

RenjolynC
RenjolynC
February 24, 2022

Hello, Alexandra16.

 

Let me add some additional info about the transactions.

 

You'll want to review everything on the discrepancy report. The Total Discrepancy Difference on the report should be $0.00. Then, check the beginning balance in QuickBooks. It should match the beginning balance on your bank statement.

 

Also, if you need to undo a past reconciliation, you have an option to do it manually.

 

Here's how: 

 

  1. Go to Accounting > Chart of accounts.
  2. Find the account that has the reconciled transaction. Then click the View register link.
  3. Select the transaction to expand the view, and in the Reconcile Status column (indicated by a checkmark ✔ column.) you’ll see an “R”.
  4. In the checkmark ✔ column, select the box with the “R” until the box is blank. This removes the transaction from the reconciliation.
  5. Hit Save.
  6. Close the account register.

To help manage your past and present reconciliations, please feel free to read these articles:

 

You're always welcome to reply on this thread if you have any additional questions or other concerns. We're available to help you out some more. Take care and stay safe!

    Terms & ConditionsAccessibility statement