cancel
Showing results for 
Search instead for 
Did you mean: 
dLearned
Level 5

Finding deposits

I am doing an audit of customer payments.  I have a payment that was clearly misallocated.  I see it is going into Undeposited funds, but how do I find out which deposit it was put into?  The dates on the payment are incorrect (it predates the invoice date) and so it was clearly entered incorrectly, and I cannot match it to a deposit in the immediate months before and after the invoice date.  Is there a way to track the payment to the actual bank deposit?

Solved
Best answer August 12, 2021

Best Answers
LollyNino_C
QuickBooks Team

Finding deposits

Thank you for contacting us, @dLearned

 

I'll be happy to share with you the steps and make sure you'll be able to locate the deposits made by the previous user of your account.

 

Here's how:

  1. Click on the magnifying glass in the upper right of your account, then Search for the Sales receipt.
  2. On the search page, choose Sales Receipt from the drop-down.
  3. Select the transaction that you want to check.
  4. You'll see a hyperlink for 1 linked deposit that you can click on.
  5. There should be another hyperlink with the word Deposit, click on it.
  6. You should now be routed to the Bank Deposit page. 

Once done, you can memorize your report to save your customization. Please see this link for details: Memorize reports in QuickBooks Online.

 

You can also check this handy article about the popular custom reports in QuickBooks Online for your reference.

 

Keep me posted if there's anything else you need with QuickBooks. I always have your back.

View solution in original post

3 Comments 3
Maybelle_S
QuickBooks Team

Finding deposits

Hello there, @dLearned.

 

Thank you for posting here in the Community. To make sure we're on the same page, Did you create a separate deposit from PayPal to your other bank account? To ensure the balance will be settle from the undeposited fund's account, let's create a bank deposit added the sales were included on your deposit. This will reduce the balance from the account.  

  

To learn more about what's undeposited funds is, you can read through this article: What’s the Undeposited Funds Account? 

 

Additionally, Here are a few articles that tackle more about the process of Invoice Payments:

 

• Record invoice payments in QuickBooks Online.

• Deposit payments into the Undeposited Funds account in QuickBooks Online.

• Assign, categorize, edit, and add your downloaded banking transactions

 

Let me know if there's anything you need assistance with. I'm a few clicks away to help. Have a good day, and stay safe!

dLearned
Level 5

Finding deposits

Thanks for replying, but I know how to use the undeposited funds.  What has happened is a previous user made a manual bank deposit transaction from undeposited funds to a bank account (as they should have).  Whatever date they used for that deposit does not match the payment transaction that went into undeposited funds, and I need to find the deposit transaction.

 

So invoice was dated May 2017, a payment was received  (this I can see from the sales records, and see that the payment was made to my Accounts Receivable and to Undeposited Funds).  Sadly, the date entered for payment was 2011 not 2017. It is not in Undeposited funds, so must have been put into a bank deposit.  As I am reconciling from newest to oldest, I know the deposit was not made at a later date, so it must have been earlier.  I need to find the deposit to determine which bank and which date it should be to correct it and to verify its accuracy from the stub.  I figure if I know the exact full bank deposit amount, I can at least look for it on a bank statement.

 

So in a nutshell, once a transaction is made from undeposited funds into a bank deposit, how do you find the deposit in QuickBooks?

 

I have seen multiple instances of date errors that QuickBooks shouldn't allow (i.e. payments predating invoices by years) without at least a warning (my opinion)

 

 

LollyNino_C
QuickBooks Team

Finding deposits

Thank you for contacting us, @dLearned

 

I'll be happy to share with you the steps and make sure you'll be able to locate the deposits made by the previous user of your account.

 

Here's how:

  1. Click on the magnifying glass in the upper right of your account, then Search for the Sales receipt.
  2. On the search page, choose Sales Receipt from the drop-down.
  3. Select the transaction that you want to check.
  4. You'll see a hyperlink for 1 linked deposit that you can click on.
  5. There should be another hyperlink with the word Deposit, click on it.
  6. You should now be routed to the Bank Deposit page. 

Once done, you can memorize your report to save your customization. Please see this link for details: Memorize reports in QuickBooks Online.

 

You can also check this handy article about the popular custom reports in QuickBooks Online for your reference.

 

Keep me posted if there's anything else you need with QuickBooks. I always have your back.

Need to get in touch?

Contact us