cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Unlock the full power of QuickBooks with our Training Classes - Discover more
jamesstott13@gma
Level 1

Why do I have double amounts showing against 2 invoice payments in my deposit detail report. The extra 2 amounts are throwing my balances off ?

 
Solved
Best answer July 17, 2021

Accepted Solutions
RCV
QuickBooks Team
QuickBooks Team

Why do I have double amounts showing against 2 invoice payments in my deposit detail report. The extra 2 amounts are throwing my balances off ?

Let me help you with the duplicate invoice payments showing in the report, jamesstott13@gma.

 

It's possible it's a duplicate payment and we can undo this if you've applied it from the Banking page. Here's how:

  1. Go to Banking.
  2. Under the Reviewed tab, choose the payment. 
  3. Click on Undo.

 

Once done, the applied payment will be shown back to the For Review tab, and the invoice is now open again. Let's make sure to exclude it to avoid confusion. Here's how:

  1. From the For Review tab, select the duplicate payment.
  2. Click on Batch actions.
  3. Select Exclude Selected.

From the Exclude tab, you can also delete it from there. To learn more about matching transactions, see the Add and match downloaded bank transactions article. If this is a duplicate deposit, we can delete them in the bank register, let me show you how:

  1. Go to the Accounting menu.
  2. Select Chart of Accounts.
  3. Find the bank account you put the deposit into and tap the View register.
  4. Search for the bank deposit and select it to get more details.
  5. Press Delete.

 

Then, all payments on the deposit go back to the Undeposited Funds account. You can also run the Deposit Detail report. This report shows all your deposits, with the date, customer or vendor, and amount. Then, we can delete the duplicate deposit there. Here's how:

  1. Go to Reports.
  2. In the Find report by name field, type in "Deposit Detail."
  3. Specify the reporting period.
  4. Then click Run Report.
  5. Double click the duplicate deposit transaction.
  6. Tap More.
  7. Choose Delete.
  8. Press Yes to confirm.

 

Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.

 

View solution in original post

1 REPLY 1
RCV
QuickBooks Team
QuickBooks Team

Why do I have double amounts showing against 2 invoice payments in my deposit detail report. The extra 2 amounts are throwing my balances off ?

Let me help you with the duplicate invoice payments showing in the report, jamesstott13@gma.

 

It's possible it's a duplicate payment and we can undo this if you've applied it from the Banking page. Here's how:

  1. Go to Banking.
  2. Under the Reviewed tab, choose the payment. 
  3. Click on Undo.

 

Once done, the applied payment will be shown back to the For Review tab, and the invoice is now open again. Let's make sure to exclude it to avoid confusion. Here's how:

  1. From the For Review tab, select the duplicate payment.
  2. Click on Batch actions.
  3. Select Exclude Selected.

From the Exclude tab, you can also delete it from there. To learn more about matching transactions, see the Add and match downloaded bank transactions article. If this is a duplicate deposit, we can delete them in the bank register, let me show you how:

  1. Go to the Accounting menu.
  2. Select Chart of Accounts.
  3. Find the bank account you put the deposit into and tap the View register.
  4. Search for the bank deposit and select it to get more details.
  5. Press Delete.

 

Then, all payments on the deposit go back to the Undeposited Funds account. You can also run the Deposit Detail report. This report shows all your deposits, with the date, customer or vendor, and amount. Then, we can delete the duplicate deposit there. Here's how:

  1. Go to Reports.
  2. In the Find report by name field, type in "Deposit Detail."
  3. Specify the reporting period.
  4. Then click Run Report.
  5. Double click the duplicate deposit transaction.
  6. Tap More.
  7. Choose Delete.
  8. Press Yes to confirm.

 

Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.

 

Need to get in touch?

Contact us