cancel
Showing results for 
Search instead for 
Did you mean: 
Alexandra16
Level 2

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.

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!
Solved
Best answer February 26, 2022

Best Answers
Pete_Mc
Community Champion

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.

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. 

View solution in original post

17 Comments 17
Pete_Mc
Community Champion

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.

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.

 

Alexandra16
Level 2

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.

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
QuickBooks Team

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.

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!

Pete_Mc
Community Champion

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.

If you haven't, go through the process to Reconcile last month again.  Use the Statement Date (e.g. 01/31/22) and use the Statement Balance.  Hide the Future Dates or Additional Information.  In theory you should see the $0 Balance.  If not, make sure you have not deleted a real transaction.

 

Before you Save this, which I believe will update your January Report, confirm there are no other Duplicates.  There may be some outstanding transactions that are not on the January, but just look to see if there are any transactions you still need to remove.  Make a quick list of those items and then Save.

 

If there are items you still need to Delete, @RenjolynC  has given you the details on where to go to make those Deletions.

 

Alexandra16
Level 2

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.

Thanks very much, all! I will try reconciling the new month when the statement comes in and see where we are. Much appreciated your help.

Pete_Mc
Community Champion

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.

Yes...   But redo LAST month again.

 

Enter last months Date and Closing Balance.  Then if you have a $0 Balance and nothing to check off as I expect, just Save it.  This may clean up your old Reconcile Report.

 

If you don't have a $0 Balance, that is what you may want to figure out before you Reconcile this month.  Otherwise the problem will just keep going forward.

Alexandra16
Level 2

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.

I don't see a way to redo last month's reconciliation again (statement ending 1/27/22). When I go into the page, it wants me to begin reconciling this month's statement...

RoseJillB
QuickBooks Team

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.

Thank you for getting back to us, @Alexandra16. I’ll help you with reconciling your account in QuickBooks Online (QBO).

 

You’ll have to go back to the bank register and select the account you want to redo. This way, the option to redo the reconciliation will be available on your end. 

 

Once done, you can follow the steps provided by my colleague above, RenjolynC. Make sure in the Reconcile Status column that the box is blank for the transaction to be removed from the reconciliation. Then, click Save.

 

Furthermore, to learn more about reconciling your account and how to fix issues for accounts you've reconciled in the past in QuickBooks Online, you can check out the following articles:

 

 

Let me know in the comments if you have further questions in mind regarding reconciliation. I’m just one post away from assisting you. Have a great day!

Alexandra16
Level 2

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.

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".

MariaSoledadG
QuickBooks Team

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.

Allow me to join you on this thread, Alexandra16.

 

Once you've already reconciled your transactions, you won't be able to see them on your reconciliation page. Normally, you'll have to manually undo them on your chart of accounts by selecting the correct account. After that, click the one highlighted in yellow until it appears blank. That means it's already unreconciled and you can now do any changes to your transaction. I've attached a screenshot for your visual guide:

Anyhow, since transactions are already zeroed out, you're good to go now and you can click Finish. Congratulations on your successful reconciliation.

 

Additionally, QuickBooks provides dozens of reports that tell you the different aspects of your business. Learn how to filter them to get the information you need. Learn from this article for your guide: Customize Reports In QuickBooks Online.

 

Drop a comment below if you need anything else about reconciliation. I'll be here to help.

Pete_Mc
Community Champion

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.

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. 

Alexandra16
Level 2

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.

Thanks very much, all, that worked! Just reconciled the January statement and it's clean as a whistle. Thanks again!

Pete_Mc
Community Champion

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.

Excellent!  

Congratz!

BPack
Level 1

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.

I have had the same or similar situation. I had 3 duplicate transactions.  I deleted those while doing a previous reconciliation that has been saved.  Now I go into do a new reconciliation and I have that amount as a descrepancy.  My registry is all correct with ending balance, all transactions are accurate.  The tutorial that I watched says to add the transactions back in.  If I do that, then my bank registry will be wrong.  ????

Rose-A
Moderator

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.

Let's get this sorted out, BPack.

 

Below are a few causes of the reconciliation discrepancies in QuickBooks Online:

 

  • This error can occur due to the adjustments made to the reconciliation.
  • The arrangement of the reconciliation may be causing it.
  • There may be a change in a former reconciled transaction or it may have been deleted.

 

To ensure your reconciliation is accurate, we can review the previous reconciliation and check if there are changes or deleted transactions. Or, it's possible that some of the missing transactions were manually reconciled. See the sample screenshot below on how to generate the report:

 

Additionally, I'd suggest filtering the reconciliation page to All to ensure all transactions are showing when reconciling the account:


 

We can take a look at these resources to help us in fixing discrepancy issues as well as steps on how to generate the discrepancy report in QuickBooks Online:

 

Reconcile an account in QuickBooks Online.

Fix issues when you're reconciling accounts in QuickBooks Online.

 

Please know that I'm here anytime you have other reconciliation concerns. Just leave a reply below and I'll get back to you. Have a good one, BPack.

MyFormals-Lisa
Level 1

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.

would you be able to help me as well?  I was reconciling my bank statements and had finished 10/31/22, then when I started into 11/30/22 bank statement, there were some issues with credit card payments. so I started to reconcile all the credit card statements. I got most of them done and went back to reconcile my bank statement, and it showed a huge discrepancy. It was 4 different credit card payments that had been duplicated in my bank statement, I had deleted the ones that I didn't clear/reconcile and now those are throwing everything off. I'm really not sure how to fix this and neither does our accountant....and I need to get my year end financials done ASAP. I'm desperate for help!!!

JamesAndrewM
QuickBooks Team

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.

Warm welcome, and great to have you as part of the Community! Let's work together to get things fixed and help you complete your year-end financials quickly, Lisa. 

 

To start, let's undo the reconciliation. Please follow the steps below:

 

  1. Go to the Gear icon at the top and pick Reconcile under the Tools column.
  2. On the Reconcile an account page, select History by account.
  3. On the History by account page, click the Account and Report period to locate the reconciliation to undo.
  4. Choose Undo on the Action column, then Yes.
  5. In the final confirmation window, pick Undo and OK.

 

If you don't see this option, it's possible that you're not using QBOA. To undo the reconciliation, you must manually edit each transaction. Here's how to do it:

 

  1. On to the Gear icon at the top, then pick Chart of Accounts under Your Company column.
  2. Locate the appropriate account for the transaction and select View Register in the Action column.
  3. Identify the transaction to edit.
  4. In the reconcile status column (indicated by a checkmark), repeatedly click the top line of the transaction to change the status, then Save.

 

  • - Cleared.
  • - Reconciled.
  • Blank - Not cleared or reconciled.

 

For detailed information, refer to this article: Undo or remove transactions from reconciliations in QuickBooks Online.

 

Doing so allows you to double-check your banking transactions for duplicates. Note the Date, Description, Payee, and amount spent or received. If those transactions are duplicates, you'll want to exclude and delete them. Here's how:

 

  1. Go to Banking, select Transactions, then select Bank accounts.
  2. Choose the bank account, then in the For Review tab, tick the duplicate transactions.
  3. A black box will appear at the top of all transactions, showing how many are selected. Choose Exclude.

 

Some transactions will automatically match, while others will not. We'll have to use the Find Match tool to manually locate transactions that didn't match directly. These are the steps you may take:

 

  1. Go to the Banking menu, and select For review tab.
  2. Click the transaction and click Find match.
  3. Look for the match transactions and put a check in their boxes.
  4. Select Save.

 

You may add the transaction that wasn't added in your QuickBooks you may then reconcile your account flawlessly:

 

 

Never hesitate to return here. We are always available to help you, especially with reconciliation issues. Keep yourself safe.

Need to get in touch?

Contact us