Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
VPG2
Level 1

accounts receivable on balance sheet does not balance to a/r aging

Does anyone know how to correct the AR aging report.  The B/S and COA are correct but the aging is out of balance.  If I post an J/E to try and correct, it throws the other reports out of balance.

 

 

2 Comments 2
Rainflurry
Level 15

accounts receivable on balance sheet does not balance to a/r aging

Aldren18
QuickBooks Team

accounts receivable on balance sheet does not balance to a/r aging

I’m here to partner with you in addressing this issue, VPG2. Let’s explore your AR aging report together to pinpoint the root cause of the imbalance while ensuring the integrity of your other reports remains intact.

 

To get started, I recommend carefully reviewing your A/R Aging report. It's essential to double-check all entries to ensure they are accurate and up-to-date. Discrepancies occur due to differences in the configuration of reports. Please ensure that both reports are using the same accounting method.

 

For detailed steps on updating report settings, here's how:

 

  1. Navigate to the Reports menu and hit on Customers & Receivables.
  2. Choose A/R Aging Detail.
  3. Set the Dates to All.
  4. Click on the Customize Report.
  5. Under the Display tab, select the Advanced button, then Report Date.

 

If discrepancies remain after these, I suggest re-sorting your Primary NamesChart of Accounts, and Item List. For detailed instructions, refer to Re-sort lists in QuickBooks Desktop.

 

Additionally, check for rebuilt names to prevent future errors that affect your financial statements and overall business operations.

 

Here's how:

 

  1. From the Lists menu, select Other Names List.
  2. If a number is followed by [Rebuilt], it designates a rebuilt name. To determine its type, run a QuickReport.
  3. Move the name to the appropriate list. Open QuickBooks Help, and type changing name type in the search field.

 

If issues persist after these steps, please refer to additional solutions outlined in our support articles regarding A/R balances not matching across reports.

 

Additionally, I’d like to share some valuable articles that will help you explore the various reports available in QBDT and how to customize them to meet your specific business needs:

 

 

I’ll be actively monitoring this thread and ready to assist you with your reports in QBDT or other concerns you might have. Your experience matters, and I’m committed to offering the support you need to navigate these challenges effectively. Let’s collaborate to ensure everything aligns perfectly for your business.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us