cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
userjyim
Level 1

AR report balance not match, why there is differences between Trial Balance and AR Aging summary,On my A/R Ageing report I want to match the Open Balance to MY TB

why AR report does not match TB, even their support agent said it is normal, their software had this problem, do you find this problem ?
1 Comment 1
Rasa-LilaM
QuickBooks Team

AR report balance not match, why there is differences between Trial Balance and AR Aging summary,On my A/R Ageing report I want to match the Open Balance to MY TB

We'll have to select the Report date for the Aging method on your Accounts Receivable (A/R) Aging report and then compare it with your Trial Balance to address any discrepancies, userjyim. I'll gladly walk you through the steps so you can complete this task on time.

 

When your Balance Sheet, Trial Balance, and Accounts Receivable Aging Reports don't match, it's due to the Aging Report defaulting to Current. Let's switch the Aging Method to Report Date to include invoices paid after a specific date.

 

Here's how:

 

  1. Open your A/R Aging Summary report, click the Report period drop-down, and select the date range from the list.
  2. Tap the Customize button to open the Customize report screen.
  3. In the Aging section, mark the Report date box and enter a specific number in the Days per aging period field.
  4. Press the Run report button to apply the changes.

Next, open your Trial Balance report, and make sure the reporting method is set to the Accrual basis. Once done, compare it with the A/R Aging Summary report.

 

If you continue to get the same result, perform the troubleshooting steps outlined in this article: Get your Ageing Reports to match in QuickBooks Online. From there, proceed directly to the Need more help? section.

 

Moreover, take a look at each link below to determine the balances of your ledger accounts and gain insight into your business's financial standing:

For guidance on how to refine the data or layout of your financial statements and links to various reports, browse each resource for complete details:

 

Keep in touch if you have other QuickBooks concerns or additional questions about the balances in your financial reports. The Community is always ready to provide the assistance you need.