cancel
Showing results for 
Search instead for 
Did you mean: 
Bill136
Level 1

AR Aging Write Off - Old Balances No Customer

Here'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.

2 Comments 2
Charies_M
Moderator

AR Aging Write Off - Old Balances No Customer

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. Thusall 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.

  1. Go to Reports and enter the Accounts Receivable Aging Summary report in the search field.
  2. Click Customize at the top-left of the report.
  3. Under the section for Aging Method, click Report Date.
  4. Click Run 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!

Charies_M
Moderator

AR Aging Write Off - Old Balances No Customer

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!

Need to get in touch?

Contact us