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

Reconciling With Duplicate Transactions

As I am reconciling I have come across something new.

 

We cut a check to a vendor on the 16th, and it cleared on the 26th. The check was entered in Quickbooks when it was cut, and then the bank connection automatically pulled in the transaction once it cleared and I matched the bank transaction in Quickbooks to the check that was entered.

 

However, when I go to reconcile I see two transactions for the check - one of which doesn't have a cleared date - and I'm not sure how to proceed. In the past, matching transactions with the bank feed has meant I only see one transaction line when reconciling and now I'm quite stuck.

 

Any direction on how to make sure things are correctly recorded and reconciled?

3 Comments
Highlighted
Intuit

Reconciling With Duplicate Transactions

Hello,

 

I would recommend taking a close look at both transactions and making sure they are indeed representing the same real life check.  If they are, double check to make sure that you did in fact MATCH the downloaded one and you didn't click ADD.  You can tell this by looking at the online banking transactions linked. (picture attached)  If it says manually matched, you matched it, if it says manually added, then you actually added a new transaction instead of matching to existing one.

 

If you research this and find you DID add it instead of matching, you can undo the bank add and select match instead.

 

If you did match it already but there is still a duplicate entry for this check, make sure it hasnt been entered twice and cleared your bank account twice.  If it only shows up once, then just delete the one that isn't marked as "C"

Highlighted
Level 1

Reconciling With Duplicate Transactions

I have a similar situation. A deposit was matched that had multiple payments from customers. It was also added to the register manually as Sales not payments. When reconciling the account, the manual deposit was checked, not the matched one. Several future months have been reconciled after. The deposit is showing in the outstanding deposits and is still in the check register. If I change the wrong deposit from r to a c and change the right deposit from c to r will I have to reconcile all the other months after or will it automatically see it balanced?

Highlighted
Level 10

Reconciling With Duplicate Transactions


@SS118 wrote:

If I change the wrong deposit from r to a c and change the right deposit from c to r will I have to reconcile all the other months after or will it automatically see it balanced?


No you won't have to reconcile all the other months after. There should be no change in the reconciliation, if the amounts are the same. But you should delete the wrong deposit, not leave it even with a c, if it's showing as outstanding. It's sounds like its duplicating the sales

Need to get in touch?

Contact us