cancel
Showing results for 
Search instead for 
Did you mean: 
further-solution
Level 2

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

I have a customer that has never paid full amounts for invoices over the past decade and has a considerable amount currently due and also significantly past due. However, the overdue amount is greater than the open invoices by almost $24k.  What does that mean?  I am trying to reconcile their account with their office and want to make sure that I am not creating additional problems by submitting my final amount due with accounting errors.

Solved
Best answer October 15, 2018

Best Answers
john-pero
Community Champion

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Overdue is the total of the original unpaid invoice regardless of remaining balance.

Example You Invoiced me $5k 90 days ago and I paid $3k. Open Invoice amount is $2k but overdue is $5k

View solution in original post

24 Comments 24
Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Where do you see the term "overdue"?  I see "Open Balance" on the AR reports. Never mind. I see it on the money bar.
john-pero
Community Champion

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Overdue is the total of the original unpaid invoice regardless of remaining balance.

Example You Invoiced me $5k 90 days ago and I paid $3k. Open Invoice amount is $2k but overdue is $5k
Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

This does not sound right. It's the other way around, if anything
john-pero
Community Champion

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

I have a $3600 vendor bill from 1/11 that I paid $1800 on. My $3600 Bill is Overdue but my Open Balance is $1800  And the vendor I owe sees an Open Balance Due of $1800 but an Overdue Invoice of $3600
Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

That's not how QBO works
Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Did you mark my answer as unhelpful?
Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

I marked your answer as unhelpful because it is not how QBO works.  Why did you mark my answer as unhelpful? Only 3 people in here.
Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

youu wrote
"Overdue is the total of the original unpaid invoice regardless of remaining balance.

Example You Invoiced me $5k 90 days ago and I paid $3k. Open Invoice amount is $2k but overdue is $5k "
That is not how QBO works (assuming <90 day terms, open and overdue both 2k)
Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Apologies It was the the poster who marked my answer as unhelpful.   But I suggest you look at how QBO works. It is not as you describe.
Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Open includes all invoices even those that are not yet due, less any payments on these invoices.  It's the balance on the account.

Overdue is just amounts that are past due.

I don't see how overdue can be greater than the Open amount.

edit: The overdue can be greater if there are unapplied credit memos





Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Would the person who marked my answer as unhelpful please leave a comment as to what it is that you found unhelpful.  This is a sharing forum and it would be useful for me to learn what the problem was with my answer.  Thanks.
john-pero
Community Champion

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Wasn't me. Open Invoices and Open Balance are separate views. And I am fairly certain that desktop and online work the same. Any invoice that is not paid in full is open. Partial payment on an invoice does not change the due date and quick books declares the original invoice as overdue.

I have renters. I charge a late fee. A tenant pays half on the first but has yet to pay balance. Posted rent is overdue but open balance is half.

It may seem backwards or upside down but that is qb.
further-solution
Level 2

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

I did not mean to be insulting, just marking which comment helped me understand my problem and which one did not.  First time on the forum and am unaware of any etiquette that I should be observing, so I apologize if I was unprofessional.  However, John's answer allowed me to balance the discrepancy that I was seeing, so I believe that he is correct in his explanation of the issue.  Thank you both for your input and willingness to help me!
Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

He is actually incorrect but anyhow, as long as you think it works for you.
further-solution
Level 2

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

I am going purely based on the numbers and will look into it more deeply. However, thank you again for your help
further-solution
Level 2

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Thank you! That makes perfect sense now.  Total overdue is the total amount billed regardless of the open amount due until the invoice is paid in full.  

Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

"Total overdue is the total amount billed" not correct. Its the amount due
further-solution
Level 2

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

yes, sorry. To be more specific, the total overdue is the total original amount of the past due invoice regardless of the amount paid, until said invoice is paid in full.
Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

The overdue can be greater if there are credit memos
JillP34
Level 2

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

How do you zero it out?

Angelyn_T
QuickBooks Team

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Welcome and thank you for joining the thread, @JillP34.

 

I'm here to help and share some ways to zeroed out the due amount on your open invoices in QuickBooks Online (QBO).

 

If you have an existing credit memo to your customer, you'll just need to apply it when creating invoices. Here's how:

 

  1. Go to the Plus (+) icon.
  2. Click on Invoice under Customers.
  3. Fill in the necessary information in the Invoice page.
  4. Click Save.
  5. Click OK when asked to apply an existing credit to the invoice.

To zeroed out the open balance, you need to create a payment.

 

  1. Click the Plus (+) icon.
  2. Select Receive Payment.
  3. Select the customer's name and fill in the necessary information.
  4. Select an invoice you wanted to pay.
  5. Click Save and close.

That would allow you to zero out the overdue amount on your open invoices. Feel free to add a comment below if you have any other invoice concerns. Have a wonderful day!

Malcolm Ziman
Level 10

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?


@JillP34 wrote:

How do you zero it out?


Create a zero Receive Payment, and check the credit against the debit. The date s/be the later date, I think.  For the future you can go to Settings and revert back to the default to automatically apply credits 

Zeb
Level 1

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

open balance is 0 and over due is 14k.

do I always look at over due?

Alessandra_B
QuickBooks Team

What does it mean when my overdue amount for a customer is greater than my open invoices for that same customer?

Greetings, @Zeb.

 

You can pull up your Accounts Receivable Aging Detail report. I can add more details about this and guide you how.

 

Your open balance is showing as 0 because you might have unapplied credit memos. Having unapplied credit memos decrease your open balance.

 

To view your balances correctly, you can pull up your Account Receivable aging Detail report.In this report, it'll show all your transactions and their balances.

 

You can follow these steps in pulling up the report:

  1. Click on Reports from the left panel.
  2. Look for Accounts Receivable Detail on the search bar.
  3. Change the Report Period to All Dates.
  4. Click on Run Report.

If you have open credit memos, you can apply them to your invoices to mark them as paid.

 

Always know that you can get back to us if you have any other concerns.

Need to get in touch?

Contact us