why would my A/R Aging Summary Report not match my Balance Sheet for the same period?

Hello Trevor,

I have reviewed the solution you’ve shared and it's correct and accurate. Thank you for sharing your inputs to help address the issue.

We love to see members supporting one another! Have a great day. 

I'm having this issue as well but I have QuickBooks Desktop Enterprise. 

The difference between my A/R Aging Summary and my balance sheet is $88,289.13 exactly and it is understated on my A/R report. When I posted a JE to debit A/R and credit Retained Earnings (and vice versa), both reports move in the same direction (plus or minus) without any resolve. 

I don't recall this error before so I'm not sure if it's a QuickBooks error or glitch or if I need to look at something else and if so, what do I need to look at? I've confirmed all my reports are being run as directed in this post.

Thank you for joining the conversation, LisaX.

I don't see anything wrong with your procedure. As you checked, the journal entry have properly recorded both the debit and credit entries, which is a standard practice when making a journal entry.

We will now look into another aspect, which is a possible data integrity issue, causing the mismatch on the reports you mentioned. To find it out, we can follow the steps for running the Verify and Rebuild data utilities. Run the Verify utility first to diagnose a data issue. QuickBooks will then prompt you to back up your file and run the Rebuild utility if an issue is detected. Please don't skip the backup process before running the Rebuild utility.

Let me know if you have questions about the instructions or anything about the QuickBooks. I'm just around to continue assisting you. Take care!

Hi JessT. I completed that yesterday and it's still showing the same thing. 

Could it be the timing of when a credit was applied to an invoice? So say it's an invoice from 12/31/22 and the credit was dated 12/31/22 but did not get applied to open invoices until 3/31/23. Could that be the reason for the discrepancy? 

Thanks for coming back with more details, LisaX.

Yes, the timing and accounting method used in both reports can affect the differences, as pointed out by your colleagues above.

To ensure consistent results, it's important that both reports have the same Report Period and Accounting Method. To better explain this, I suggest learning more about how the Cash and Accrual basis methods can impact your reports.

I'm just right here if you have more questions in mind. Have a good one!

That did not resolve anything for me.

Hi there, @LisaX.

I understand that the previous response may not have fully addressed your needs. You can be confident that I'm here to provide guidance and direct you to the appropriate support.

Since the issue persists despite the information provided, I suggest contacting QuickBooks Support directly. Our team of experts is well-equipped to handle and further investigate the discrepancy between your A/R Aging Summary and balance sheet reports. They can provide you with the necessary assistance to identify and resolve the underlying cause of the issue.

Here's a step-by-step guide on how to reach them:

1. Open QuickBooks.
2. Navigate to Help, then select QuickBooks Desktop Help/Contact Us.
3. Click Contact Us.
4. Give a brief description of your issue, then choose Continue.
5. Sign in to your Intuit account.
6. Select Continue and then Continue with my account.
7. Click to Chat with us or Have us call you.

Moreover, I'll be sharing these articles to help tailor your reports to meet your specific business needs and save them to generate the same statement in the future: 

• Customize reports in QuickBooks Desktop
• Create, access, and modify memorized reports.

If you have additional queries about handling your financial reports in QuickBooks Desktop, don't hesitate to tag my name. I appreciate you taking the time to connect with us and wish you all the best.

There was an update that was released from when I posted to today. It seemed to have resolved the issue.

Hi, i am curious how you managed to migrate qb desktop to qbo, i always get an errror that intuit does not support some browsers and i should update the browsers, after which nothing happens

Hello there, @maryk3 .

I see you are trying to migrate from QuickBooks Desktop to QuickBooks Online. To migrate successfully, you'll need to use compatible and updated browsers for QuickBooks Online to run efficiently. Using unsupported browsers will cause some functions not to work.

Here are the supported browsers for QuickBooks Online:

• Google Chrome: version 78 or newer
• Mozilla Firefox: version 76 or newer. You'll also need the Firefox PDF plugin to preview and print forms on Mac OS.
• Microsoft Edge: version 79 or newer
• Safari: version 12 or newer (Mac only)
• Opera: version 68 or newer
• Samsung: version 10 or newer

After successfully migrating, here's what you can do after converting from QuickBooks Desktop for Windows or Mac to QuickBooks Online.

If you have further questions about migrating from QuickBooks Desktop to QuickBooks Online, please feel free to reply to this post. I'm always available to assist you.