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

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 10-15-2018

Accepted Solutions
Highlighted
Established Community Backer ***

Overdue is the total of the original unpaid invoice regar...

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
24 Comments
Established Community Backer ***

Where do you see the term "overdue"?  I see "Open Balance...

Where do you see the term "overdue"?  I see "Open Balance" on the AR reports. Never mind. I see it on the money bar.
Highlighted
Established Community Backer ***

Overdue is the total of the original unpaid invoice regar...

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
Established Community Backer ***

This does not sound right. It's the other way around, if...

This does not sound right. It's the other way around, if anything
Established Community Backer ***

I have a $3600 vendor bill from 1/11 that I paid $1800 on...

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
Established Community Backer ***

That's not how QBO works

That's not how QBO works
Established Community Backer ***

Did you mark my answer as unhelpful?

Did you mark my answer as unhelpful?
Established Community Backer ***

I marked your answer as unhelpful because it is not how Q...

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.
Established Community Backer ***

youu wrote "Overdue is the total of the original unpaid i...

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)
Established Community Backer ***

Apologies It was the the poster who marked my answer as u...

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.
Established Community Backer ***

Open includes all invoices even those that are not yet du...

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





Established Community Backer ***

Would the person who marked my answer as unhelpful please...

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.
Established Community Backer ***

Wasn't me. Open Invoices and Open Balance are separate vi...

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.
Not applicable

I did not mean to be insulting, just marking which commen...

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!
Established Community Backer ***

He is actually incorrect but anyhow, as long as you think...

He is actually incorrect but anyhow, as long as you think it works for you.
Not applicable

I am going purely based on the numbers and will look into...

I am going purely based on the numbers and will look into it more deeply. However, thank you again for your help
Not applicable

Thank you! That makes perfect sense now.  Total overdue i...

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.  

Established Community Backer ***

"Total overdue is the total amount billed" not correct. I...

"Total overdue is the total amount billed" not correct. Its the amount due
Not applicable

yes, sorry. To be more specific, the total overdue is the...

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.
Established Community Backer ***

The overdue can be greater if there are credit memos

The overdue can be greater if there are credit memos
Frequent Explorer **

Re: The overdue can be greater if there are credit memos

How do you zero it out?

QuickBooks Team

Re: The overdue can be greater if there are credit memos

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!

Established Community Backer ***

Re: The overdue can be greater if there are credit memos


@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
Established Member

Re: Wasn't me. Open Invoices and Open Balance are separate vi...

open balance is 0 and over due is 14k.

do I always look at over due?

QuickBooks Team

Re: Wasn't me. Open Invoices and Open Balance are separate vi...

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.