I don't find it confusing because each report has a specific purpose. An invoice is due when the invoice date + net days due is reached. If the invoice date is Mar 31 and it is Net 15 days, then it should be paid by Apr 15. On Apr 16, it is over due.

On the Customer Aged report on Apr 16, the invoice will show in the Current column if your current column is 30 days as in your example because the report date of Apr 16 - Invoice date of Mar 31 is 16 which is less than 30.

On the Customer Overdue Aged report you will see the invoice in the 1-30 days overdue column because it is one day overdue on Apr 16 (should have been paid by Apr 15).

Your invoice #636 is overdue as of Mar 18 but is less than 30 days overdue by Apr 7 in your report.

On Apr 15, invoice 649 will move to the 1-30 days overdue column but will be in the 31-60 days column on the Customer Aged Detail because it is that old.

You can have invoice 636 with a Net 60 days and invoice 646 with the Net 30 your currently have. On that report, you will legitimately see 636 in the Total Current Column but 646 in the 1-30 days overdue even though the first invoice is older.

Which report you give the owners is the one they ask for. If they don't know, then you need to explain they have the option of an aging report and a collections aged report, show them both and let them decide, or give them both.

Hi Richard, thanks for your reply.

I think I saw in a 2007 post you mentioned that the overdue report was intended for collections(?) That is helpful to know as it gives me some perspective on the evolution of the software and why things are the way they are.

The gist of your message is essentially for me to pay closer attention on what these two reports mean and how they differ, that is, just because I see 31-60 I shouldn't flippantly jump to conclusions they are meaning the same thing; rather, I need to slow down, take note, and to remember to view things in the context of the report!

Best,
Kristine