Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowMy 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.
Solved! Go to Solution.
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'.
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?
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'.
That did it! Thank you so much @Rainflurry!! I knew there had to be a box checked somewhere that shouldn't have been...
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