Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
MHJ17
December 16, 2022
Question

Aging reports that do not match Balance Sheet

  • December 16, 2022
  • 5 replies
  • 38 views

We use QBs Enterprise Solutions 22.0, desktop version via Right Networks. The trial balance, balance sheet and customer account balances all show as zero, which is correct. However the aging reports show balances on some of these customers. We have tried every solution suggested from sorting to rebuilding data and everything in between to resolve this issue without success. Short of starting over, what can I do to get these former customers/vendors off the aging reports without messing up the balance sheet, trial balance and customer/vendor records? HELP!!

5 replies

L
LollyNino_CQuickBooks Team
QuickBooks Team
December 16, 2022

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.

M
MHJ17Author
December 16, 2022

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. 

J
JamesAndrewMModerator
Moderator
December 16, 2022

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement