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

Incorrect aging dates

A customers aging dates keep showing up incorrect. Invoices that are over 30 days show in 1-30 and if they are over 60 days they show 31-60. How to fix this?

5 Comments 5
FritzF
Moderator

Incorrect aging dates

Hi there, @RhondaWalker.

 

I see this is your first question so let me take the time to welcome you here to the Intuit Community. I'm here to share some information about incorrect customer aging dates in QuickBooks Desktop (QBDT).

 

Just to confirm, are you referring to the A/R Aging Detail report? If so, this report is base on the Due Date, not the Invoice Date. For example, if you created an invoice dated 01/01/2019 that has a Net 30 term, then the due date became 01/31/2019. Now, this invoice will be placed on 1-30 on the report.

 

I also attached a sample screenshot below.

 

 

That should answer your concern for today. Just in case, you can also check out this article for future reference: Understand reports.

 

I hope this response finds you with a smile. Please let me know if you're referring to something else in the comment section. I'm always here to help. Take care and have a great day!

KarlaFlex
Level 2

Incorrect aging dates

I, too, am having trouble with my A/R Aging reports.  As you can see by the screenshot, even though I specified "Sort By:  Due Date" at the top, the aging is calculated from the Invoice Date and therefore is showing all invoices I entered within the last 30 days as aged 1-30, regardless of the Due Date.

 

In response to another issue I posted, I was advised to Rebuild my data, which I've done, and this report is still calculating by Invoice Date.  

 

The problem is with both the "Detail" and "Summary" reports.

 

tyia for any advice you can give

 

 

QB forum pic 2 - ar aging detail.PNG

Rose-A
Moderator

Incorrect aging dates

Sending good vibes to you, KarlaFlex.

I'm here to lend a hand in correcting your aging report in QuickBooks Desktop. Let's get started.

 

You may want to check you reports preferences if it's set to Age from due date. This way your report will show the correct aging dates.

 

Here's how:

 

  1. Click Edit at the top and choose Preferences.
  2. Select Reports & Graphs.
  3. Go to the Company Preferences.
  4. Under Aging Reports, select Age from due date.
  5. Hit OK.

z.PNG

 

The following articles are good references:

 

For account discussion, you can reach out to our QuickBooks Desktop Support.

 

  1. Within your QuickBooks Desktop, click Help at the top menu bar.
  2. Enter a brief description of your concern then click Contact us.
  3. To route you to the correct support expert, we need to know what type of question you have. Give a brief description of your issue and click Continue.
  4. We’ll provide you a few options. You choose which one is best for you.

That's it! Let me know if you still need help with your A/R Aging report in QuickBooks. I'll stick around to help you out. Have a great rest of your day.

KarlaFlex
Level 2

Incorrect aging dates

 

worked like a charm, thanks RoseMarjorieA!

Rose-A
Moderator

Incorrect aging dates

I'm glad to hear this worked for you,KarlaFlex.


You know where to find me if you ever need help again in the future.

 

In case you want to know some "How do I" steps in QuickBooks Desktop, you can always visit our Help Articles page for reference.

 

The Community is always in your corner. Take care. 

Need to get in touch?

Contact us