cancel
Showing results for 
Search instead for 
Did you mean: 
AChipOffTheOldBlock
Level 3

A/R Aging is not calculating correctly

My A/R aging is calculating based upon the invoice date, rather than the due date. This is causing both my aging report and my customer statements to be incorrect and show invoices as past due even though they aren't. The only items that show as current are the ones from the current day. Does anybody have any idea what might be causing this or how to fix it? I have checked my payment terms items as well as the terms assigned to the customers and they are all correct. In the attached example, the customer is set with Net 45 terms. The due dates reflect this as shown in the statement, yet the aging shows as past due.

 

 

Screenshot 2022-04-20 173303.png

 

Screenshot 2022-04-20 172926.png

 

Solved
Best answer April 20, 2022

Best Answers
Rainflurry
Level 13

A/R Aging is not calculating correctly

@AChipOffTheOldBlock 

 

Check your preferences (Edit>Preferences>Reports & Graphs>Company Preferences), under 'Aging Reports', make sure 'Age from due date' is checked and not 'Age from transaction date'. 

View solution in original post

5 Comments 5
BigRedConsulting
Community Champion

A/R Aging is not calculating correctly

It sort of looks like the numbers are off by one box, that 15,410 is current and 2,773 is 1 - 30 days late.

 

Is this statements using the Intuit Standard Statement template, or a custom template?

 

If a custom template and you edit it in the Layout Designer, and then click each of the data fields in the aging area, are the fields in the right location compared to the field titles?

Capture.JPG

Rainflurry
Level 13

A/R Aging is not calculating correctly

@AChipOffTheOldBlock 

 

Check your preferences (Edit>Preferences>Reports & Graphs>Company Preferences), under 'Aging Reports', make sure 'Age from due date' is checked and not 'Age from transaction date'. 

AChipOffTheOldBlock
Level 3

A/R Aging is not calculating correctly

That did it! Thank you so much @Rainflurry!! I knew there had to be a box checked somewhere that shouldn't have been...

Sandykaye
Level 1

A/R Aging is not calculating correctly

 My age from the due date is correctly checked.

I made an invoice for a customer today, then did a transaction report with aging checked, and it said they were 138 days past due. Is there anything else to try?

MsNorthPND18
QuickBooks Team

A/R Aging is not calculating correctly

I have some instructions that can get back on track on running a report in QuickBooks, Sandykaye.

 

I'd like to know if you've already performed the steps provided by Rainflurry above. If yes, but the issue persists, let's resolve your concern by verifying and rebuilding your data in QuickBooks Desktop (QBDT). The verify tool identifies the most common problems in a company file, and the rebuild tool fixes them.

 

To verify the data:

 

  1. Go to Window, then click Close All.
  2. Navigate to File, then Utilities.
  3. Choose Verify Data.

 

To rebuild the data:

 

  1. Go to FileUtilities, then click Rebuild Data.
  2. Follow the on-screen instructions, then select OK.
  3. Choose a location for your backup, then click OK.
  4. Type in a new name in the File name. Click Save.

 

For more details,  verify and rebuild your data in QuickBooks Desktop. Check out this article below: Verify and Rebuild Data in QuickBooks Desktop.

 

For more information on customizing report, check out this article: Customize reports in QuickBooks Desktop.

 

Please don't hesitate if you have other queries with the transaction report in QBDT.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us