Skip to main content
E
EThomasHIHAF
March 22, 2019
Solved

Undeposited Funds - AR Payments Not Showing Up

  • March 22, 2019
  • 1 reply
  • 0 views

As I was reconciling our grants and our bank statements, I discovered some deposits that had not been entered correctly. To correct the A/R receipts I had to delete a couple of the deposits. But this did not restore the amounts to the Undeposited Funds. I also had an A/R receipt that just did not show up in the Undeposited Funds. So these three deposits do not appear in our bank account in QuickBooks and I can't find a way to get them into the bank account. Can you please tell me how to get these deposits into the bank accounts? I have reconciled the Accounts Receivable and Grant Income accounts and they are correct. It's just the bank accounts that are missing the deposits. 

Best answer by EThomasHIHAF

Hello there, EThomasHIHAF.

 

Thanks for providing additional information. I want to make sure this is taken care of. 

 

If you wish to get those funds to the correct bank, you can create a deposit using the Make Deposit option in QuickBooks Desktop.

 

Here's how:

  1. Go to the Banking menu.
  2. Select Make Deposits.
  3. In the Payments to Deposit window, click to select the payments you wish to deposit.
  4. Click Ok.
  5. In the Make Deposits window, click the Deposit To drop-down and select the first bank account.
  6. Enter a line then click the From Account drop-down and choose the second bank account.
  7. In the Amount column, enter a negative amount equal to the amount you want to deposit to the second account.
  8. Click Save & Close.

I've got you an article to know more about how bank deposit works in QuickBooks Desktop: Make Deposit.

 

That should do it. Don't hesitate to visit us again if you have additional questions with making deposits. I'm always here to help.


Each of these receipts are the same amount. I downloaded all of the deposits and payments from the Undeposited Funds to Excel with this amount and the total is 0. But when I look at this fiscal year, it does not balance. So this means that some of the deposits have been posted to the previous fiscal year even though the actual receipts came in this fiscal year. (Did I mention that I'm doing clean up of the books?)  So I think I just need to change the dates on 2 of the deposits to this fiscal year.  Thank you for your replies. I appreciate it. 

1 reply

john-pero
john-pero
March 22, 2019

Deleting a deposit only returns to Undeposited Funds those items that came from Undeposited Funds to begin with.  Manual entries in a deposit or added from a bank feed will disappear.

 

Since the items did not return to UF when you deleted the deposit that means they were not there to start. Unless you are dealing with just cash your bank website and local branch will have pictures of all checks in a deposit

E
EThomasHIHAFAuthor
March 22, 2019

I had to delete the deposit from Undeposited Funds before I could change the AR Payments, so I know they had been cleared from Undeposited Funds. I now need a way to get these funds to the bank account. 

C
Charies_M
March 22, 2019

Hello there, EThomasHIHAF.

 

Thanks for providing additional information. I want to make sure this is taken care of. 

 

If you wish to get those funds to the correct bank, you can create a deposit using the Make Deposit option in QuickBooks Desktop.

 

Here's how:

  1. Go to the Banking menu.
  2. Select Make Deposits.
  3. In the Payments to Deposit window, click to select the payments you wish to deposit.
  4. Click Ok.
  5. In the Make Deposits window, click the Deposit To drop-down and select the first bank account.
  6. Enter a line then click the From Account drop-down and choose the second bank account.
  7. In the Amount column, enter a negative amount equal to the amount you want to deposit to the second account.
  8. Click Save & Close.

I've got you an article to know more about how bank deposit works in QuickBooks Desktop: Make Deposit.

 

That should do it. Don't hesitate to visit us again if you have additional questions with making deposits. I'm always here to help.

Terms & ConditionsAccessibility statement