AR aging report

Thanks for posting in the Community, @natulkaf0rd. I'd be glad to help you match the two reports.

To get started, let's make sure that the date range of the two reports match since the A/R Aging Report defaults to Current, showing the current status (as of today) of all A/R transactions for the report’s date range. I suggest opening both reports and choosing the same accounting method and period.  

Here's how:

1. Run the Balance Sheet Standard report on Accrual Basis.
2. Select the Customize Report button.
3. From the Dates drop-down, choose All.
4. Change the Display Columns by drop-down field to Year in the Columns section.
5. Go to the Header/Footer tab, then edit the Report Title to Balance Sheet by Year.
6. Choose the OK button.
7. Select the Memorize button at the top of the report, then choose the OK. (You may need this report again later.)
8. Note the ending balance for Accounts Receivable for each year.
9. Open the A/R Aging Summary report and change its date to the first year ending date of the Balance Sheet by Year report.
10. Compare the total from the A/R Aging Summary report to the Balance Sheet to determine if the discrepancy started that year. 

For more details, see this article: AR balance on the Chart of Accounts does not match AR balance on reports. If the issue persists, please proceed to Step 2 of the said article.

Also, be sure you’re comparing the correct numbers. On your A/R Aging report, you want to match Open Balance to your Balance Sheet / Trial Balance amount for Accounts Receivable.

Here's an article that you can read to help streamline the reporting process and get the most out of QuickBooks’ financial reporting capabilities: 

• Customize Reports.
• Understand reports

Additionally, here's also an article you can read to learn more about the Account Receivable (A/R) workflows in QBDT: Get started with customer transaction workflows in QuickBooks Desktop.

Don't hesitate to post again if you have additional concerns about running reports or any questions with QuickBooks. I'm always here to assist. Have a good one!

Hi, Joesem! I have compared two reports and find out that in December 2017 additional discount has been made and applied to the invoice, even the invoice was fully paid. Since is an overpayment, the AR should show a negative balance on my understanding. Instead, AR aging report has shown a positive balance. The posting is in the year 2017. Is there any way to fix it?

Thanks for updating us with this reporting concern, @natulkaf0rd.

Allow me to share some insights about the report in QuickBooks. Every report in the program displays the information depending on its type. The aging report for Accounts Receivables displays unpaid invoices for each customer, grouped by days past due. This means that it excludes any other transactions besides invoices, or any credits applied to them.

Any overpayments made will always reflect the Accounts Receivable balance in the Balance Sheet, not on the aging report. If you're still seeing 2017 invoices in the Aging Detail report, it's possible that the payment is not linked properly to the transaction. To check this, open the payment and see if it is correctly applied to the sales entry.

Successful payments should display a Paid watermark on the invoice. If you see this yet still shows unpaid, refresh the payment by removing the check mark beside the Invoice Number and Credit, then add it again before saving.

Deleting and recreating the payment will also work. This option is available if the invoice is paid manually, not online.

Now, if you recorded the income manually as a bank deposit, this process will only affect the register but remove the Accounts Receivables balance. You must use the Receive Payment option to tie the transactions and offset the outstanding amount.

If you need further help with the reports in QuickBooks, just post here again. I'll be more than happy to share some more insights if you need it. Have a nice day!