Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

A/R or A/P Aging Report displays incorrect amounts

The A/R or A/P Aging Report does not display correct amounts (or the amount is different than the amounts displayed in Unpaid Bills or the Accounts Payable account on Balance Sheet or in register).

Why this is happening

The as of report date setting in the Advanced Options of a report enables you run a report to show customer balances as of a selected date. Payments received after the ending date of the report are not reflected in the open balances shown on the report. Without this setting, payments after the report date would be reflected in the customer's balance.

For example: A customer has an invoice dated March 15th with a payment in full on April 10th, if you run the aging report for March 31st without selecting as of report date you would see a balance of 0 (the April 10th payment would be reflected in the report). If you change the setting to As of report Date the balance should be $500 (the actual balance on March 31st.)

There are other reasons this issue can be encountered, including damage in your data file.

 

If this solution does not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free. You can contact an agent for additional guidance. Fees may apply.

KB ID# SLN42302
10/20/2014 2:10:48 PM
PPRDQSSWS404 9102 Pro 2013 58e262