Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHere's my problem. We just upgraded from QBD 2013 to 2021 QBO. This was a long process but it has been completed. I have issues with the balances in AR and AP (the problem is the same). The AR Aging Report and customer balances are correct, however, the balance sheet doesn't match the AR Aging or Customer Balances. I want to do a year end journal entry for 12-30-21 to clean things up. If I use a Misc AR customer it shows on the AR Aging. How do I correct the balance sheet without using a customer name? Please don't tell me it can't be done. There must be a way that an accountant can fix this problem. Thanks.
It's my pleasure to assist you today, Bill136.
The AR Aging Report and the Balance Sheet don't normally match. This is because the A/R Aging Report defaults to Current. Thus, all A/R transactions are showing the current status (as of today) for the report’s date range. This report excludes all payments received from the A/R total.
The Balance Sheet, on the other hand, excludes only the amounts of payments received on or before the date of the report.
If you need these reports to match, customize the Accounts Receivable Aging Summary report.
Here's an article that provides further details on why Balance Sheet and Accounts Receivable Aging reports don't match and how to handle it: How to get your Aging Reports to match.
I also have some additional articles about managing a wide range of reports in QBO:
Get back to me if you need further questions while managing reports. I'll be around and ready to help. Enjoy the rest of the day!
Hi, Bill136.
Hope you’re doing great. I wanted to see how everything is going about the difference with AR Aging and Balance Sheet reports. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.
Looking forward to your reply. Have a pleasant day ahead!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.