cancel
Showing results for 
Search instead for 
Did you mean: 
M1Jones1
Level 1

Since my customer's invoice is paid, why does the deposit line show "overdue" with a balance?

Customer A was invoiced $100. In the customer screen, the line items read, in pertinent part: balance $0, total $100, Paid. For the corresponding deposit from Customer A, however, reads: Balance -$100, Total -$100, Overdue. What am I doing wrong?
7 Comments 7
SashaMC
Moderator

Since my customer's invoice is paid, why does the deposit line show "overdue" with a balance?

Thank you for reaching out to the Quickbooks Community, M1Jones1. Could you verify if the payment is linked to the invoice? If not, the invoice would have an open balance, but the customer balance would be $0. The reason being, the payment would still offset the invoice in the account receivable for the customer. Another thing I would check is to make sure there aren't two payments. You can run the Transaction List by Customer report to view this. Here's how:

 

  1. Go to the Report tab and use the search engine to type the Transaction List by Customer.
  2. Select the Customize report button.
  3. Add the reporting date under Report Date Range and additional information if necessary.
  4. Use the Filter tab and select Transaction Type.
  5. From the pop-up window, select Payment then clicks OK.
  6. Once completed, select OK again.

Also, I've attached a couple of articles here for the detailed steps of recording invoice payments:

I will be looking forward to your response. Simply respond below. The Community and I will be here to help you. Until then, take care.

M1Jones1
Level 1

Since my customer's invoice is paid, why does the deposit line show "overdue" with a balance?

Thank you.  I followed those steps to verify the deposit is linked to the invoice, but it seems I'm still missing something.

 

When I double click the invoice, the payment status shows as paid, and below it indicates "1 payment made ($100)".  When I click on the "1 payment made" link, it takes me to a "receive payment" screen.  In the Outstanding Transactions field, the correct invoice is checked. 

 

Scrolling down to the Credits section, nothing is checked.  I can see that the $100 deposit is there (though unchecked), but in the Original Payment column it shows $80, and next in the Open Balance column it shows $20 (numbers fictionalized for ease of understanding).

 

What does any of this mean? 

ReyJohn_D
Moderator

Since my customer's invoice is paid, why does the deposit line show "overdue" with a balance?

Let's ensure to deposit the invoice payments amount, @M1Jones1.

 

If you created a bank deposit and added the said amount to Accounts Receivable (A/R), then your customer will have a negative balance. This entails an overpayment.

d272.PNG

 

If this is the case, let's open the deposit amount linked to the paid invoice. Here's how:

 

  1. Go to the Sales menu, and then select Customers.
  2. Choose the customer name associated with the invoice, and then open the invoice payment link.
  3. Hover down to the Credits section, and then click it to open.
  4. Check the payments made, and then double-check as well the Add funds to this deposit section.
  5. If it's deposited to A/R, then you can delete it.
  6. Click Save and Close.

    d273.PNG

With regards to the $80 amount on the Original Amount column, this could be the money entered on the Add funds to this deposit column (A/R). Thus, leaving only $20 on the Open Balance column.

 

If you want to link the deposit to an invoice, please take note of the following:

 

  • There's an invoice for the customer.
  • Payment hasn't been entered and linked to the invoice.
  • The payment was entered through Bank Deposit instead of Receive Payment.

Then, you can follow the steps in this article: How to link a deposit to an invoice.

 

You'll want to pull up the Invoices and Received Payments report to keep track of all your invoices and the payments that go with them. Simply go to the Reports menu, and then choose the said report from the Who owes you section.

d274.PNG

 

You can count on me if you have more questions about managing your invoices in QuickBooks Online. Keep safe,@M1Jones1.

vikingboatfiberglas
Level 1

Since my customer's invoice is paid, why does the deposit line show "overdue" with a balance?

i cant seem to get this fixed. i show an invoice as paid, under same customer payment for the invoice amount and then a overdue negative deposit for the invoice amount. How can i fix this? i cant find any information anywhere

JasroV
QuickBooks Team

Since my customer's invoice is paid, why does the deposit line show "overdue" with a balance?

Nice to have you joined this thread, @vikingboatfiberglas.

 

A possible reason for this is that the invoice payment was not applied to an invoice. To get around this issue, you’ll want to link the payment to the invoice. Let me guide you how in your QuickBooks Online (QBO) account.

 

Here’s how:

 

  1. Go to the Sales menu.
  2. Select Customers tab.
  3. Locate and select your preferred customer.
  4. Go to the Transaction List tab.
  5. Locate the overdue invoice.
  6. Click the Receive payment link to link the payment to the invoice.

 

Let me also share with you this article that you can read for your future reference:

 

 

Know that I’m always around to help whenever you have other questions or concerns in managing your invoices or with your account. It’s always my pleasure to help you. Have a good one and more success in your business!

Antique-inc
Level 1

Since my customer's invoice is paid, why does the deposit line show "overdue" with a balance?

Afternoon,

 

Piggybacking off the above questions.

 

Our client paid back on June 15th, 2021. The account shows as updeposited funds. If I deposit the funds, the client isn't getting charged again, correct? As in, they have already paid and the money left their acount when they paid last year, but we just didn't deposit it correctly from quickbooks. Is this accurate? Thank you for your assistance! 

 

Just want to make sure they won't randomly see money pulled from their bank account nearly a year after the work was completed, and that when they paid, the money was already taken from their account.

Kurt_M
QuickBooks Team

Since my customer's invoice is paid, why does the deposit line show "overdue" with a balance?

Thanks for joining us here in the thread, @Antique-inc.

 

Yes, you're right. Once you move money from the Undeposited funds, It'll not charge your customer again. If you're unsure how to proceed, consult your accountant for assistance. This way, they can provide you with other options to do it.

 

Additionally, I've got you these articles to help you in the future:

 

 

Please know you that you are always welcome to post here in the Community if you need help with your QuickBooks-related concerns. Rest assured, I'll be here to assist you once again. Keep safe and stay hydrated! 

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

Need to get in touch?

Contact us