Aging reports that do not match Balance Sheet

Thank you for getting back to us here on the Community page, MHJ17

You'll want to run the Transaction List by Customer report and customize it from there. It will show the dates of your invoice payments in QuickBooks Desktop.

Here's how:

1. Go to the Reports tab at the top menu bar.
2. Select Customers and Receivables.
3. Choose Transaction List by Customer.
4. Click the Customize button.
5. Tap the Display and Filters button for the columns and account type.
6. Hit the OK button.

Also, if you'll want to see the related payments of your invoices. You'll have to click the invoice on the right side click the Transaction button to see the related transactions.

To learn more about running reports in QBDT, you may check this article: Understand reports.

If there’s anything else I can help you with, please post a comment below. I’ll be happy to assist you further. Have a good one.

This did nothing to help. Maybe you misunderstood my issue...The balance sheet, trial balance and customer balance are all correctly showing zero balances. The AR aging report (both summary & detail) shows the same customers with open invoices, but they do not show up in the customer record or any other reports. There are no open invoices or JE's showing in the customer record under Balance Details filtered by OPEN with ALL dates. The only place that shows these customers with a balance due is on the AR AGING REPORT. 

I appreciate you getting back here in the thread, @MHJ17. It'd be great to help you with your concern.

The Aging reports did not match the balance sheet, and the open invoices could be the result of one of the following:

• Different settings in the report/s and on the COA.
• Rebuilt names
• Damaged links or data
• Transactions with no Customer: Job name

To fix the issue you may have to update the report settings, here's how:

1. Run the A/R Aging Detail report:
   1. On the Reports menu, choose Customers & Receivables, then click A/R Aging Detail.
   2. Set the Dates to All.
   3. Select Customize Report, and under the Display tab, click the Advanced button, then Report Date.

For detailed information about the steps, utilize this article: AR balance on the Chart of Accounts does not match AR balance on reports.

You can visit this article to know how the chart of accounts works in QBDT: Work with the chart of accounts in QuickBooks Desktop.

Know that the Community is always here to back you up. Have a great day ahead.

I have tried the solutions recommended several times, with no change. I tried 

• Different settings in the report/s and on the COA.
  Rebuilt names
  Damaged links or data
  Transactions with no Customer:Job name

I even tried Verify & Rebuild data and QBs found no errors or issues. Since I keep getting the same suggestions for this issue, I'm guessing that there is no real solution and I need to stop trying to fix it and just start over from scratch. In the long run, it would have taken less time to just start a new company than to keep trying these suggestions that never seem to resolve the problem we've had since we started using QBs. I appreciate the effort, but this is probably a coding issue within QBs and neither a date nor data issue. I've seen other posts regarding this issue, so it's not just me. None of those posts show that the solutions actually worked either, but I also tried them if they differed from the ones I received. If there are any users that have figured out how to resolve this issue, please reach out. Thanks in advance!

Thanks for the update, @MHJ17.

Let me route you to the best support who can further check what's causing the data mismatch between your financial reports, like the balance sheets and aging reports in QuickBooks Desktop (QBDT).

Since your aging reports continue to mismatch your financial reports, like balance sheets and trial balances, even after performing the solutions in this thread, I encourage you to reach out to our Technical Support team. They can create a case to trigger an investigation and get the issue fixed in no time. Here's how:

1. Go to Help, then select QuickBooks Desktop Help.
2. Select the Contact Us button.
3. Enter a brief description of your concern in the What can we help you with? field and click Continue.
4. Choose a way to connect (Chat or Callback).

Once everything is all set, you may also want to check out one of our Help pages as your reference to guide you in managing your business growth and transactions using QBDT: QuickBooks Learn and Support. It includes help articles, Community discussions with other users, and video tutorials, to name a few.

Please feel free to let me know if you have other reporting concerns or questions about managing income transactions in QBDT. I'm always ready to help. Take care, and I wish you continued success, @MHJ17.