cancel
Showing results for 
Search instead for 
Did you mean: 
lmancini220
Level 3

Merge duplicate transactions?

Hi - 

 

I have an unreconciled transaction from 2019 that I am trying to deal with without having to un-reconcile and re-reconcile everything and I am wondering if I can merge it with another duplicate transaction that is reconciled. 

 

What happened is:

1) Client got a check for a service

2) Client marked her invoice as paid via check and into undeposited funds

3) Client deposited check into bank account

 4) Client saw deposit in bank feed, and added the income to the account

5) Client reconciled the account to the bank statements - bank statement had the deposit and so did QB, all good. 

6) Client THEN marked the undeposited funds as being deposited into the income account. 

 

Step 6 created a duplicate transaction for the same income. Client should have done step 6 before step 4, and matched the transaction instead of adding it. 

 

This was almost a year ago - I am cleaning up the books and this is the last lingering thing. I would love to delete the unreconciled transaction from the account but it will mark that invoice as unpaid since that is the transaction she used to mark the invoice. Then I would be in the same position, with a reconciled payment for an invoice that isn't tied to that invoice from a year ago.  

 

Is there a way to fix this with out having to undo the transaction and re do the reconciliation? Can I tie a matched and reconciled transaction to an unpaid invoice? 

 

Side note about something weird - when the deposit was added to the account, the correct customer was selected, but I do not see a duplicate payment for this customer when I am viewing the customer. Only when I am in the account. 

 

Any insight is appreciated! Thanks!

 

Thanks!

 

Solved
Best answer July 15, 2020

Best Answers
Steve_C
QuickBooks Team

Merge duplicate transactions?

Hi lmancini220. I believe the easiest way for you to handle this would be to unreconcile the single transaction that was already reconciled from the chart of accounts. After that, you should be able to match the transactions and simply mark the matched transactions as reconciled again. To do so just follow these steps:

  1. Select Accounting then Chart of Accounts from the left-hand menu Now, find the transaction 
  2. Once you find it, double click the transaction first and then click the R until it turns into a C.
  3. After that, simply return to the bank feeds to properly match the transaction. 
  4. Last, after you've matched the transaction return to the chart of accounts to replace the with an R

Doing it this way won't affect the completed reconciliation as long as the matched transactions are truly an exact match. If you need help with anything else, just leave a reply below. I'll be happy to further assist. Have a great day. 

View solution in original post

3 Comments 3
Steve_C
QuickBooks Team

Merge duplicate transactions?

Hi lmancini220. I believe the easiest way for you to handle this would be to unreconcile the single transaction that was already reconciled from the chart of accounts. After that, you should be able to match the transactions and simply mark the matched transactions as reconciled again. To do so just follow these steps:

  1. Select Accounting then Chart of Accounts from the left-hand menu Now, find the transaction 
  2. Once you find it, double click the transaction first and then click the R until it turns into a C.
  3. After that, simply return to the bank feeds to properly match the transaction. 
  4. Last, after you've matched the transaction return to the chart of accounts to replace the with an R

Doing it this way won't affect the completed reconciliation as long as the matched transactions are truly an exact match. If you need help with anything else, just leave a reply below. I'll be happy to further assist. Have a great day. 

View solution in original post

lmancini220
Level 3

Merge duplicate transactions?

Followed your instructions and all went well - though now when I look at that account's reconciliation history, it says I deleted that transaction and it is showing me the difference of that amount....it is showing the correct beginning and ending balance but it says I have "changed" the reconciliation - the report only shows that I deleted the transaction, not that I added it back in...which is not totally accurate...If I had only deleted it and not added it back in, would the ending balance be different? 

 

MaryLurleenM
Moderator

Merge duplicate transactions?

You're right, lmancini220.

 

The ending balance will be different since there are changes made on the reconciled transactions. You can undo the entire reconciliation to correct this.

 

To undo a reconciliation:

  1. In QuickBooks Online Accountant, select the client from the drop-down list on the Toolbelt to open the client's company file.
  2. Select the Gear icon on the Toolbar.

  3. Under Tools, select Reconcile.

  4. On the Reconcile an account page, select History by account.
  5. On the History by account page, select the Account and Report period to locate the reconciliation to undo.
  6. From the Action column drop-down list, select Undo.
  7. When prompted to confirm, select Yes.
  8. In the final confirmation window, select Undo.
  9. Select Ok.

Check this article for more information: Reconcile an account in QuickBooks Online.

 

Let me know if you have additional questions.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up