Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
T B F
New Member
July 11, 2025
Question

Accounts Receivable Detail Aging from invoice date instead of due date.

  • July 11, 2025
  • 7 replies
  • 212 views

I see that this report has been a topic at least back to 2018.  Has this issue been resolved and if so, can someone tell me how to run this very commonly needed report?

7 replies

Rainflurry
Rainflurry
Level 11
July 11, 2025

@T B F 

 

What is there to be resolved?  When you run an A/R Aging Detail Report, "Current" indicates invoices that are not past due.  The past-due invoices are categorized as 1-30, 31-60, 61-90, and 91+ days past due.  This is how QuickBooks has always worked.  

T B FAuthor
New Member
July 11, 2025

Understood.  However, it will not age the open invoices from invoice date as opposed to due date.  I see there has been much past discussion about this issue and wanted to know if it had been resolved.  In Quickbooks Desktop, there was the option to change universally in the company preferences to age from invoice date or from due date, QBO does not have this option. Many banking institutions require this aging when looking at your business reports. Since I migrated to QBO from QB Desktop in April 2024, I have exhausted a lot of extra time creating the reports in the necessary format.  I was just wondering if QB had resolved this issue.  

    RheaMaeHQuickBooks Team
    QuickBooks Team
    July 11, 2025

    Generating the Accounts Receivable Detail Aging report by invoice date is valuable for managing your business. However, QuickBooks Online currently doesn't have this option, TBF.

     

    The report defaults to aging invoices based on the due date, as this aligns with payment terms and tracks when invoices become overdue. This ensures accurate reporting of outstanding balances.

     

    I understand that aging by invoice date would be helpful for your business. Since this option isn’t available, I recommend sharing your feedback with our product development team. Your input will help us better understand your needs and enhance your overall experience.

     

    To submit feedback:

     

    1. Go to Settings.
    2. Select Feedback.
    3. Enter your product suggestions in the designated box.
    4. Click Next to submit.

     

    As a workaround, you can export your report to Excel and manually calculate aging based on the invoice date or customize the data further to suit your needs.

     

    You can revisit this thread if you have additional questions.

    robert5
    September 3, 2025

    Hi, I had the same problem and I have used 'Invoice List' under the 'Who Owes You' heading.  This lists all invoices by invoice date together with the open balance.

    It's not perfect but I've sent it to the factoring company, so fingers crossed.

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement