Skip to main content
November 6, 2023
Question

QB AR aging summary changing value

  • November 6, 2023
  • 1 reply
  • 0 views

Does anyone find that their QB AR aging summary for a date in time (say if you run it for 9/1/23 anytime after 10/1/23) changes after you run the report? As if payments and late fees are being included in a historical report and changing the value outstanding as you run the report? I'm seeing different value each week I run a historical report.

 

Thx

1 reply

BigRedConsulting
November 6, 2023

If you customize the report, under Aging is "Report date" selected?  If so, in my testing future payments seem to be excluded from the report.

November 6, 2023

Hi there, jestrauss03.

 

Welcome to the Community. I can provide a more detailed explanation of why the values in QuickBooks Online's AR aging summary might change.  

 

The QuickBooks AR Aging Summary report shows who owes you money, how much they owe, whether or not they have outstanding invoices, and how late those invoices are. The report displays the past 30 days in 30-day intervals by default, but you can change the number of days and the interval amounts for this report. 
 

If you notice that the value of the AR Aging Summary report is changing, it could be due to a few reasons. One possible explanation is that the report is customized to show a different date range or aging method. 
 

Another reason for a change in the AR aging summary is the addition or modification of invoices or payments. For example, if a new invoice is added to the system, the balance for that customer will increase, and the overall balance of the report will change accordingly. Similarly, if a payment is received and posted against an outstanding invoice, the balance for that customer will decrease, leading to a change in the report's total balance.  
 

Also, the possible reason for changes in the AR aging summary is any adjustments made to the accounts receivable or customer balances. For instance, if an incorrect invoice was created and later adjusted or a refund was issued to a customer, the balances for those customers would be affected, leading to changes in the report. Furthermore, changes in payment terms or credit limits for customers can also affect the aging summary. 
 

Lastly, there could be unapplied transactions that are affecting the report. To fix the issue, you can try the following solutions:

 

  1. Check the date range and aging method of the report to ensure that it is showing the correct information.
  2. Double-click on the Total of a name that shows 0 under Total to see what is unapplied against each other.
  3. Decrease the number of interval days and then export the AR Aging Summary report to remove zero data.
  4. Use the Customer Balance Detail report and add an Aging column to see the past due balances of your customers.

 

It's essential to review the report and the underlying data carefully to identify and correct any errors that might have contributed to changes in the AR aging summary report, which may vary depending on your situation. By reviewing the data regularly, you can identify any discrepancies and correct them promptly, ensuring that your financial records are accurate and up to date.
 

If you want to learn more about the process of customizing reports, kindly refer to this article: Customize reports. Then, if you want to memorize the customized report, feel free to check out this article for the detailed steps and information: Memorizing reports.

 

Keep me posted if you still have questions or concerns about managing your reports in QBO. I'll be here to lend a helping hand. Have a great day ahead!

November 8, 2023

thanks for the reply - your comment here, 'Also, the possible reason for changes in the AR aging summary is any adjustments made to the accounts receivable or customer balances. For instance, if an incorrect invoice was created and later adjusted or a refund was issued to a customer, the balances for those customers would be affected, leading to changes in the report. Furthermore, changes in payment terms or credit limits for customers can also affect the aging summary. ' i think is close.

 

Let's say I run the report for 10/1/23 and the aging method is based on the report date. I'm assuming that late fees or payments on those invoices will cause the balance to fluctuate from week to week?