cancel
Showing results for 
Search instead for 
Did you mean: 
radomira
Level 1

Reconciliation

Why on my reconciliation report I have duplicate amounts -once as deposit and once as received payment?

3 Comments 3
RoseJillB
QuickBooks Team

Reconciliation

Welcome to the Community, @radomira. Let me share some ideas with you regarding duplicate transactions in QuickBooks Online (QBO).

 

If you connect your online banking to QBO, transactions will be automatically downloaded to your account.

 

One possible reason why you have duplicate amounts is when your online bank downloaded the transaction and categorized it as a deposit. Then, you also manually recorded a payment for the same invoice.

 

Here’s what we are going to do. We will exclude the duplicate transaction that you manually recorded. To do so, kindly perform the steps below:

 

1.   Go to the Accounting menu and select the Chart of accounts tab.
2.   Find the account that has the reconciled transaction. Then select View register.
3.   Find the transaction. If the transaction is reconciled, you’ll see an “R” in the checkmark  column.
4.   Select the transaction to expand the view.
5.   In the checkmark  column, select the box with the “R” until the box is “C”. This removes the transaction from the reconciliation.
6.   Select Save.
7.   Close the account register.

 

Then, go to the Banking menu and select Categorized tab. From there, you’ll see the two duplicate transactions. On your manually recorded payment, we have to clear that payment to enable us to match the deposit from your bank to the invoice.

 

Here’s how:

 

  1. Go to the specific paid Invoice.
  2. Click Edit Invoice.
  3. From the right top corner, select payment made for that invoice and click the Date beside Amount paid.
  4. Then, select Clear Payment.

 

FINAL SS 01132022.PNG

 

Once done, let’s go to the For review tab again and look for the deposit, then hit Match. We can then reconcile the transaction back to its register.

 

Furthermore, I added this following article for your reference when reconciling your account in QuickBooks Online.

 

 
Let me know if you need further assistance with your banking transactions. The Community always has your back. Have a great day!

radomira
Level 1

Reconciliation

No, this is not the problem. The problem is that one transaction is showing once as a deposit and once as received payment.

Carneil_C
QuickBooks Team

Reconciliation

Thanks for dropping by the Community, @radomira. Let me further assist you in sorting out this issue about your transaction in QuickBooks Online.

 

If you have duplicate transactions in the Banking page, you can delete them. Ensure they're actual duplicates before you proceed, so there aren't any discrepancies. In this case, you can consult your accountant for further guidance on this matter.

 

First, undo the transaction if it’s reconciled.

 

Here’s how:

  1. Select Accounting.
  2. Select the Chart of accounts tab.
  3. Find the account that has the reconciled transaction. Then select View register.
  4. Find the transaction. If the transaction is reconciled, you’ll see an “R” in the checkmark column.
  5. Select the transaction to expand the view.
  6. In the checkmark column, select the box with the “R” until the box is blank. This removes the transaction from the reconciliation.
  7. Select Save.

 
From there, you can now delete the transaction.

 

Here’s how:

 

  1. Go to the Accounting menu. Then select Chart of Accounts.
  2. Find the account you’re reconciling and select View register.
  3. Find the transaction and select it to expand the view.
  4. Select Delete and then Yes to confirm.

 
You can check these articles for more information: 

In addition, you can also refer to this article to learn the workflow process of reconciliation within QBO: Learn the reconcile workflow in QuickBooks.

 

Get back to me here if you have further questions about your transactions in QuickBooks Online. I'd be more than happy to answer it for you. Have a nice day.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us