Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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!
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
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:
The following articles are good references:
For account discussion, you can reach out to our QuickBooks Desktop Support.
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.
worked like a charm, thanks RoseMarjorieA!
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here