Skip to main content
March 22, 2023
Question

how can I run an AR aging detail report to show the due date by customer terms not the due date does not reflect the terms

  • March 22, 2023
  • 1 reply
  • 0 views

How can I run an AR aging detail report to show the due date by our customer terms and not the 1-30, 31-60, 61-90, or over 90 dates that the report sorts by.  For example, we have a customer that pays a net 60 but the A/R Aging Detail sorts by the invoice date, not the actual due date.as determined by the terms.

1 reply

JoesemM
March 22, 2023

Thanks for joining the Community space, @SprayDry. Let me help you with your accounts receivable aging summary report.

 

The A/R Aging detail report will show the past due balances of each transaction. This report will show you all outstanding invoices and sort them by the due date. Depending on the payment terms you have set for your customers, you will see those due in 0-30 days, 30-60 days, 60-90 days, and over 90 days past due.

 

To determine by terms of your A/R Aging Detail report, you can follow the steps below:

 

  1. Go to the Reports menu.
  2. Select Customers & Receivables, and A/R Aging Detail.
  3. Click the Customize Report button to customize the report's data.
  4. In the Display column, put a checkmark behind the DateTerms, and Due Dates.
  5. Click OK.

 

Also, you can export it to an Excel file so you can modify and add other details on the report. You'll just select Excel on the toolbar and choose the Create New Worksheet option to create a new Excel workbook

 

Once everything is all set, you may also want to check out this article as your reference to guide you on how QuickBooks generates reports and see the complete list of available ones in QBDT: Understand reports.

 

Please let me know if you need anything else. The Community and I will be here to help you. Take good care.

December 20, 2023

Would it be possible to run a report that filters the invoices down to ONLY those that are already PAST DUE based upon the Terms? Or, is it only possible to sort by exporting to an Excel file?

Rainflurry
December 20, 2023

@DanBu 

 

Yes.  Run an A/R Aging Detail report.  Click 'Customize Report'.  Go to the Filters tab.  Under 'FILTER', select 'Aging'.  Under 'Aging' click on the ">=" radio button and enter 0 in the box.  Click OK.  That will show invoices that are either due today or are past due.  If you enter 1 in the box, it will show invoices that are 1 day past due or more.