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

How do I fix understated "Cust. Inv. A/R" and overstated "Undep Funds"? I have dup pending deposits.Invoice balances are ok. GJ? Delete deposits and mess up my invoices?

It may be an issue from transferring from my Quicken files in,   Older invoices with multiple payments had an issue with unapplied balances,  I was trying to fix and now have this problem
Solved
Best answer November 17, 2019

Best Answers
KhimG
QuickBooks Team

How do I fix understated "Cust. Inv. A/R" and overstated "Undep Funds"? I have dup pending deposits.Invoice balances are ok. GJ? Delete deposits and mess up my invoices?

It’s nice to see you again in the Community, @mikey007.


Deleting the duplicate entries and depositing the rest can help fix the issue. Make sure to link them to your customers’ invoices to avoid having unapplied balances.


Let’s first create a backup for the company file to avoid any accidental data loss. Then, run the Deposit Detail report to delete the duplicate entries.

 

Here’s how:

  1. From the Reports menu, choose Report Center.
  2. Pick Banking under the Contributed tab.
  3. Look for the Deposit Detail Report, then click Run.
  4. Find every duplicate deposits and open them one at a time.
  5. In the Make Deposits screen, right-click anywhere and choose Delete Deposit.
  6. Hit OK to save the changes.

Deposit 1.PNGDeposit 2.PNGDeposit 3.PNGDeposit 4.PNG

Once done, deposit the remaining payments. Follow these steps:

  1. Click Make Deposits on the Homepage.
  2. Pick all the payments you want to deposit in the Payments to Deposit screen, then select OK.
  3. Choose your Deposit to account in the Make Deposits window.
  4. Review the deposit total and payments to make sure they match. 
  5. Select a date for the deposit.
  6. Hit Save & Close.

Check out this article for the details and screenshots of entering a bank deposit: Record and make Bank Deposits in QuickBooks Desktop.


Reach out to me if you have additional concerns, or need further assistance performing the steps above. It's always a pleasure to help. Have a good one!

View solution in original post

2 Comments 2
KhimG
QuickBooks Team

How do I fix understated "Cust. Inv. A/R" and overstated "Undep Funds"? I have dup pending deposits.Invoice balances are ok. GJ? Delete deposits and mess up my invoices?

It’s nice to see you again in the Community, @mikey007.


Deleting the duplicate entries and depositing the rest can help fix the issue. Make sure to link them to your customers’ invoices to avoid having unapplied balances.


Let’s first create a backup for the company file to avoid any accidental data loss. Then, run the Deposit Detail report to delete the duplicate entries.

 

Here’s how:

  1. From the Reports menu, choose Report Center.
  2. Pick Banking under the Contributed tab.
  3. Look for the Deposit Detail Report, then click Run.
  4. Find every duplicate deposits and open them one at a time.
  5. In the Make Deposits screen, right-click anywhere and choose Delete Deposit.
  6. Hit OK to save the changes.

Deposit 1.PNGDeposit 2.PNGDeposit 3.PNGDeposit 4.PNG

Once done, deposit the remaining payments. Follow these steps:

  1. Click Make Deposits on the Homepage.
  2. Pick all the payments you want to deposit in the Payments to Deposit screen, then select OK.
  3. Choose your Deposit to account in the Make Deposits window.
  4. Review the deposit total and payments to make sure they match. 
  5. Select a date for the deposit.
  6. Hit Save & Close.

Check out this article for the details and screenshots of entering a bank deposit: Record and make Bank Deposits in QuickBooks Desktop.


Reach out to me if you have additional concerns, or need further assistance performing the steps above. It's always a pleasure to help. Have a good one!

mikey007
Level 3

How do I fix understated "Cust. Inv. A/R" and overstated "Undep Funds"? I have dup pending deposits.Invoice balances are ok. GJ? Delete deposits and mess up my invoices?

Thanks, this solution looks to be what I need!  Thanks for the help.  

Mike

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

Need to get in touch?

Contact us