LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Conrad99
Level 1

unexplained payments

As I have done for  years, I generate invoices, send them to customers, receive payments against the invoices and deposit the undeposited funds.  Suddenly, with the last three such deposits, QB pro desktop 2020 has created a matching payment in the check book.  Why?  How can I fix it?

 

3 Comments 3
Archie_B
QuickBooks Team

unexplained payments

Hello there, Conrad99

 

Allow me to share some information to ensure that your bank deposits are correctly recorded in QuickBooks Desktop.

 

QuickBooks lets you manually record a bank deposit and combine payments so they matches your real-life bank deposits. You can run a report to review past deposits and transactions you combined.

 

Here's how:

 

  1. Go to Reports menu, then Report Center.
  2. Click the Banking section.
  3. Find the Deposit Detail report, then select the Run icon.

 

This report lists all of your recorded bank deposits. You can get more information about individual deposits by selecting them.

 

On the other hand, if you have QuickBooks Payments, you can enable automatic matching and allow QuickBooks to deposit and record customer payments for you. Once QuickBooks records the bank deposits, you can review and compare it with your bank statement to make sure it matches correctly.

 

Like this:

 

  1. Go to the Banking menu, then choose Record Merchant Service Deposits.
  2. Go to the Recorded tab.
  3. Review the first bank deposit on the list. Just click the small arrow icon ▼next to the deposit to see more details.

 

If payments in QuickBooks doesn't match your bank statement, you can check out this article to learn how to handle them: Automatically record QuickBooks Payments bank deposits in QuickBooks Desktop.

 

I'm also adding this link for FAQs about recording QuickBooks Payments bank deposits.

 

Please let me know if you have any further questions about payments and bank deposits. I'll be around if you need me. Have a wonderful week!

Conrad99
Level 1

unexplained payments

This does not address my problem.  The banking deposit report shows the deposits.  No surprise.

The banking checking report does not show numbers to match the deposits.

The check register, however, shows a payment to accounts receivable on a date prior to the deposits from undeposited funds.  How did that happen?

AileneA
Moderator

unexplained payments

Hello, Conrad99.

 

Let's do a couple of solutions to help us fix the problem. 

 

A data integrity issue can cause data damage to your company file. We can use the Verify and Rebuild utility to fix the issue. Before doing the Verify rebuild, as an initial step, updating the QuickBooks Desktop release version is a good start when it comes to fixing issues like you've encountered. 

 

Then we can proceed to Verify and Rebuild utility. Here's how: 

 

  1. Go to File, then hover on Utilities
  2. Pick Verify Data.
  3. Follow the prompts to proceed with the data verification process.
  4. When it's done, go to the Utilities menu again.
  5. Select Rebuild Data, then follow the prompts. 

 

An overview about the Verify and Rebuild process is found here: Verify and Rebuild Data in QuickBooks Desktop.  

 

After doing the rebuild process, let's go ahead and check the report if its still showing multiple line item credits on invoices.  

 

Another solution is to run and use QuickBooks Tool Hub and then QuickBooks File Doctor to resolve the issue. This program is a collection of tools that can help resolve major issues that a user might face while working on the QuickBooks Desktop. For the best experience, we recommend using this on Windows 10, 64-bit. Please follow the steps in this article: Fix common problems and errors with the QuickBooks Desktop Tool Hub

 

Keep me updated on how these steps help you. I want to make sure you can get the information you need. Have a great day!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us