cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable
Solved

Invoice paid & deposited but is not showing up on the bank register. Create invoice > Receive payment to the invoice> make deposit. Not showing up on the bank register

Invoice has a green check mark that it's been paid, and I thought I correctly deposited it.

I do use undeposited funds account as holding ground until I make deposit because we deposit multiple invoice payments on one bank deposit. In the u/f account it lists increase to accounts receivable from customer and decrease for bank deposit which I assume means that both steps are accounted for. So why is it not on my bank register then when I go to reconcile?
Best answer 12-10-2018 08:56 PM

Accepted Solutions
Community Contributor *

Open the deposit and check to make sure it was deposited...

Open the deposit and check to make sure it was deposited to the proper bank account.  Also check the date in the Make Deposit window to make sure you used the correct date and not some date later than the end date of your bank statement.

Andrea
20 Comments
Community Contributor *

Open the deposit and check to make sure it was deposited...

Open the deposit and check to make sure it was deposited to the proper bank account.  Also check the date in the Make Deposit window to make sure you used the correct date and not some date later than the end date of your bank statement.

Andrea
Not applicable

I am having the same problem. I checked the Make Deposit...

I am having the same problem. I checked the Make Deposit window and the date and account are correct. But the deposit does not show up in the check register or, of course, the reconcile screen.  I recently reinstalled QB because I have a new computer. Do you think there could have been some glitch in the install?  This is the only problem I have had and I am baffled because this is the same procedure I have used for many years with no such issue.   Thank you for any advice.
Not applicable

I have had this problem constantly since install QB Pro 2015

I have had this problem constantly since install QB Pro 2015
Active Member

Re: Open the deposit and check to make sure it was deposited...

I have checked date and account and both correct -- how do i fix this?

 

QuickBooks Team

Re: Open the deposit and check to make sure it was deposited...

I can help you get around with your concern, Michoro, Bobmeng, and WFlintstone.

 

We will isolate this issue. Open a sample company file, then check if the same thing happens. Open QuickBooks, click Open a sample file, then choose a file.

 

If there are no issues in the sample file, this unexpected behavior is due to data or file corruption. To fix this, we will run the verify/rebuild utility. Here's how:

  1. Click the File menu.
  2. Go to Utilities, then choose Verify Data
  3. If QuickBooks detected no problems, there's no further action needed. If you receive a message, "Your data has lost integrity", the file is damaged. Just continue to Rebuild Data to correct the problem.
  4. When you Rebuild Data, you'll receive a message to back up your company file, just click OK. The utility starts as soon as the back up is finished.
  5. Click OK when you get the message "Rebuild has completed".
  6. Run Verify Data again to check for remaining data damage.

After running the utilities, try to check your register. 

 

You can keep me updated by tagging me. I will get back to all of you as soon as I can. 

Established Member

Re: Open the deposit and check to make sure it was deposited...

customer payment not showing in make deposits window

 

Customer payment received, appears in Un-deposited Funds account register, but will not show up in Make Deposits window. Also shows correctly in customer's a/r account as a payment going to un-deposited funds. Have tried deleting payment and re-entering, it worked one time; but then to test again--deleted the selected deposit; deleted the payment, then re-entered and it wasn't there again.

Community Manager

Re: Open the deposit and check to make sure it was deposited...

Hi segun,

 

I'm here to help you. 

 

How many Undeposited Funds account do you have in your Chart of Accounts? When you receive a payment, do you need still need to choose the undeposited funds account in the Deposit to field or it pre-fills to a bank account? 

 

Thanks in advance for your response. 

 

 

Established Member

Re: Open the deposit and check to make sure it was deposited...

thanks for quick response.

 

i only click on received payment and automatically go to undeposited funds.

 

i only have one undeposited funds

QuickBooks Team

Re: Open the deposit and check to make sure it was deposited...

Hello there, @segun.

 

Allow me to help you ensure your payments are recorded properly on your end.

 

With QuickBooks Desktop, you have the ability to set up your preferences on where your payments will be deposited. Often, payments will be deposited to "Undeposited Funds" as the default account. To review your account's set-up, here's how:

  1. Go to Edit.
  2. Choose Preferences.
  3. Select Payments.
  4. Under Company Preferences, mark all of the following below or choose one:
    • Automatically apply payments.
    • Automatically calculate payments.
    • Use Undeposited Funds as a default deposit to account.
  5. Click Ok.

On the other hand, here is the correct workflow to record your Account's receivables in QuickBooks Desktop.

  1. Create an invoice
  2. Record a payment
  3. Deposit customer payments

To help you check review the account's where your payments where recorded or deposited, you can pull up Transactions List by Customer report. You can filter this report to show payments you've receive per customer and where it was deposited. Please refer to the screenshot below:

 

U.gif

 

 

That should do it! Feel free to let me know if you have other questions about recording your payments. I'm always here to help.

Active Member

Re: Open the deposit and check to make sure it was deposited...

The problem is, when a deposit consists of two or more payments from other customers, it does not reflect on the Bank Account for, let's say, a specific customer.

QuickBooks Team

Re: Open the deposit and check to make sure it was deposited...

Hello there, @Ruben.

 

Thank you for joining this thread. Allow me to chime in and share some insights about deposit in QuickBooks.

 

You need to manually match your deposit if there are multiple transactions from different customers. After matching them, what reflects on the Bank account is the specific customer on the transaction.

 

I advise checking the Add and match Bank Feed transactions article for detailed instruction.

 

Let me know if there's anything else I can do for you. Just leave a comment or mention my name. Have a good weekend!

Frequent Explorer *

Re: Open the deposit and check to make sure it was deposited...

Hello, 
How do you verify it is the correct bank account? I am using QB Desktop. The payment was applied to 3 invoices using the "Receive Payments" module and the deposit was recorded under the "Record Deposit" module. I can see that the correct date was used, but it's not in the reconciliation. Please help!
Thank you

QuickBooks Team

Re: Open the deposit and check to make sure it was deposited...

Thanks for joining the thread, stressedbyQ-B.

 

I'm here to provide additional clarification regarding the missing deposit.

 

One method to verify the bank account is correct is to open the deposit as mkandi7856 suggested. A quick and easy way to do this is to use the Find tool especially if you have more than one bank account created in QuickBooks. Here's how you can do it:

  1. From the Edit menu, select Find.
  2. Go to the Advanced tab.
  3. In the Filter section, search and select the TransactionType option.
  4. From the TransactionType drop-down menu, choose Deposit.
  5. Click Find.
  6. In the Results section, identify the right deposit and double-click it.
  7. Once the transaction is open, check the account in the Deposit To field. Change it as necessary.
  8. Click Save & Close.

When you're done, try to reconcile your bank account again and check if you can complete the reconciliation.

 

Let me know how it goes, I'm determined to get this fixed for you. Thanks again for dropping by, I'll be standing by for your response.

Frequent Explorer *

Re: Open the deposit and check to make sure it was deposited...

Hello, 

Sorry to sound so ignorant, but DEPOSIT is not an option in my drop down menu under FIND. Could it be my QB version? I am using Desktop, Contractor. 

 

Thanks!

Frequent Explorer *

Re: Open the deposit and check to make sure it was deposited...

Hello, 

Sorry to sound so ignorant, but DEPOSIT is not an option in my drop down menu under FIND. Could it be my QB version? I am using Desktop Contractor. 

 

Under my drop down menu for FIND, I have 2 tabs; Simple and Advanced. Neither one has DEPOSIT as an option. 

 

Thanks!

Moderator

Re: Open the deposit and check to make sure it was deposited...

Thanks for getting back to us, stressedbyQ-B.

 

I'll join this conversation to help you use the Find Tool.

 

You're on the right track with finding the deposit transaction. You'll just have to select Transaction Type under Filter, then choose Deposit as mentioned by my colleague above.

 

Please follow the steps above from my colleague and refer to this screenshot for your visual point of reference.

 

image.png

 

That should help you locate the deposit transactions. Should you have any questions about this or anything else, please let me know. Have a good one.

Frequent Explorer *

Re: Open the deposit and check to make sure it was deposited...

I see it now! Thanks!!

Established Member

Re: Open the deposit and check to make sure it was deposited...

Hi Kristine, I am hoping you can help me Smiley Wink I am using a late 2013 iMac with El Capitan (for whatever reason the hardware won't let me upgrade to a newer OS). I have Quickbooks for Mac 2016 R33. 

 

QB has been running just fine on my computer for months.

 

Yesterday I tried to update the OS to Mojave. Long story short, lots of problems, apple support, apple store visit, put El Capitan back on, and computer was "back to normal" the way it was in the morning. (We did NOT have to do drive format, and I have not had to reinstall any software.)

 

SO.... Today in Quickbooks, everything looks just normal, but I went to "receive payment" and I log it toward an open invoice just as before, and it will not accept the funds. I can click save, and I hear the money sound effect, but the deposit does not show in my cash account, or any other account. And it also does not reduce the balance owed by the client. So it's like the payment never happened.

 

I've verified the data file. There were issues, so I did a rebuild. And I verified again, then it all check out. But still will not take the payment for the client.

 

Advice? Thank you.

 

 

Established Member

Re: Open the deposit and check to make sure it was deposited...

Kristine, interesting update here...

 

So, I kind of made it work, but there's a bug. Maybe you can help.

 

The client has 7 open invoices that each range from $150 to $3000, but total approx 6500.

 

The client also had 62 cents of un-deposited funds from sometime before (as if they had overpaid an invoice in the past.)

 

Today the client made a payment to me of $1750.

 

Earlier, when I tried to manually apply the $1750.62 to a variety of invoices, the deposit was not working and would not go into my cash account. 

 

But moments ago I ignored the 62 cents and clicked Auto Apply with the $1750 payment (not what I really want, but it was a test) and it worked. The $1750 shows in my cash account, and the client's balance is reduced.

 

So the Auto Apply worked, but manual apply (with also using up the 62 cents) did NOT work.

 

Thoughts?

 

 

QuickBooks Team

Re: Open the deposit and check to make sure it was deposited...

Hello there, @jack thomas

 

I appreciate you verifying and rebuilding your data file to help receive your client's payments. 

 

Let's perform some troubleshooting steps so you'll be able to take all the payments from your clients. 

 

We haven't received any reported issues why the manual apply didn't work. As an alternative, you can use the auto apply since it's working for you. 

 

Then, let's use the Clean Install process. This way, it will help fix program-related errors.

 

You can first uninstall the QuickBooks Mac Desktop. Please make sure to have your QuickBooks Desktop download file and your license numbers handy before uninstalling the software. Here's how: 

 

  1. Close the program. 
  2. From the Finder menu, select Go
  3. Select Applications
  4. Choose the QuickBooks icon and drag it to the Trash

 

Next step is to remove the installation files behind. This will revert all the preferences back to its default settings, which could cause the product to be unregistered. Here's how to remove the User and System PLIST

 

  1. From the Finder menu while on your desktop, choose Go
  2. Hold down the Option key, then select Library
  3. Go to the Preferences Folder. 
  4. Find the PLIST files (User and System) and your version in the name, then drag them to the Trash
  5. Delete everything containing "com.intuit.QuickBooks20xx."
  6. Empty the Trash

 

After that, you can restart your computer. Lastly, you'll have to reinstall Quickbooks

 

For more information, please go through this helpful article: Clean Install Process

 

The steps above will help you successfully receive your payments, @jack thomas

 

I'll be around to help if you have further concerns. Have a good day.