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

further-solution · ‎October 15, 2018

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.

john-pero · ‎October 15, 2018

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

Malcolm Ziman · ‎October 15, 2018

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 · ‎October 15, 2018

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 · ‎October 15, 2018

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

john-pero · ‎October 15, 2018

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 · ‎October 15, 2018

That's not how QBO works

Malcolm Ziman · ‎October 15, 2018

Did you mark my answer as unhelpful?

Malcolm Ziman · ‎October 15, 2018

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 · ‎October 15, 2018

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 · ‎October 15, 2018

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 · ‎October 15, 2018

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 · ‎October 15, 2018

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 · ‎October 15, 2018

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 · ‎October 15, 2018

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 · ‎October 15, 2018

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

further-solution · ‎October 15, 2018

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

further-solution · ‎October 15, 2018

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 · ‎October 15, 2018

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

further-solution · ‎October 15, 2018

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 · ‎October 15, 2018

The overdue can be greater if there are credit memos

JillP34 · ‎December 21, 2018

How do you zero it out?

Angelyn_T · ‎December 21, 2018

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:

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

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

Click the Plus (+) icon.
Select Receive Payment.
Select the customer's name and fill in the necessary information.
Select an invoice you wanted to pay.
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 · ‎December 21, 2018

@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 · ‎May 22, 2019

open balance is 0 and over due is 14k.

do I always look at over due?

Alessandra_B · ‎May 22, 2019

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:

Click on Reports from the left panel.
Look for Accounts Receivable Detail on the search bar.
Change the Report Period to All Dates.
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.

Topics

Training

Community

Resources

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