How to Update the A/R Aging Report Summary Interval Days in QuickBooks Desktop

As a small business owner getting paid is extremely important. But it can be difficult to keep track of who owes you money and when that money’s due. 

That’s where the A/R Aging Summary report comes in.

This report will show you who owes you money, how much they owe, whether or not they have outstanding invoices, and how late those invoices are.

When you view this report it will show you the past 30 days in 30-day intervals. In this blog post I’m going to show you how to change the number of days and the interval amounts for this report.

Quick Instructions:

  1. Click Reports in the top menu
  2. Click Customers & Receivables -> A/R Aging Summary
  3. In the Dates row towards the top of the screen click the Through (days past due) number to update the number of days it shows through
  4. Change the Interval (days) number to change the number of days for the intervals

Keep reading for a complete walkthrough with screenshots:

Find the A/R Aging Summary Report

To get to the A/R Aging Summary Reports click Reports in the main menu across the top of the screen. In the drop-down select Customers & Receivables -> A/R Aging Summary.

Navigating to the A/R Aging Summary report in QBDT.

When you open the report it’ll show you the past 90 days in intervals of 30 days.

AR Aging Summary Report in QBDT.

Change Date Range and Interval

Above the report, you’ll see a row where you can change:

  • Dates
  • Invertal (days)
  • Through (days past due)
  • Sort By

Updating the Through (days past due) will show you the past X (where X is the number you enter) worth of days. 

Updating the Interval (days) will change the length of the interval it shows for those days.

Here’s an example where I’ve updated it to the past 360 days with intervals of 90 days:

Updating the interval days for the A/R Aging Summary report in QBDT.

You now know how to update the interval days for the A/R Aging Summary report in QuickBooks Desktop. Scroll down for a video if you’d like to watch a walkthrough.

☕ If you found this helpful you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

If you have questions about the A/R Aging Summary report click the green button below to schedule a free consultation.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

Testing SupaClerk Bank Statement Conversion to CSV for QuickBooks Online Import

Learn how to convert a PDF bank statement into a CSV and then import it into QuickBooks Online.

How to Upload Checks for Printing in QuickBooks Online Using SaasAnt

Learn how to use Saasant to upload multiple checks to QuickBooks Online for printing.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.