I am an accountant trying to to help a friend with Quickbooks. Her BS A/R balance is zero, but aging and register show a balance and activity? What is wrong?

Hi there, donomccormack.

One of the reasons your Account List AR doesn't match on the Balance Sheet A/R balance is that the period date and the accounting method are not the same.

I suggest opening both reports and choosing the same accounting method and period. You'll also have the option to customize these two statements so you can easily differentiate the balances.

Here's how:

1. Click the Reports at the left panel.
2. Go to the search icon and type either the Account list or Balance Sheet.
3. Select the drop-down arrow under the Report period and choose the specific date.
4. Choose between Accrual or Cash as the accounting method.
5. Hit the Customize button.
6. From the Rows/Columns section, choose which rows and columns appear in the report.
7. Go to the Filter drop-down arrow. Then, select which accounts appear on your report.
8. In the Header/Footer section, decide what appears in the header and footer.
9. Hit the Run button report.

For additional information, you can click this article: Customize reports in QuickBooks Online. This also provides information on how to manage and share custom reports.

Please check this article to see which reports are available for your version of QuickBooks Online: Reports included in your QuickBooks Online subscription.

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

Thank you.  I ran out of room, but the BS A/R balance is zero and the Aging and the register for A/R (they do tie) are over $804M.  So it is more than a classification error and not sure what to do.  I am semi dangerous with QB, so any other ideas?  Thanks again!

Hi there, @donomccormack.

The aging report displays the number of unpaid invoices that are outstanding and how many days they have been outstanding. However, you can perform basic troubleshooting on your browser to check if it's a browser issue or not. Please access your QuickBooks Online account via an incognito/private browser.

To use a private browser, here’s how:

• Google Chrome: Ctrl + Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Internet Explorer: Ctrl + Shift + P
• Safari: Command + Shift + N

Once done, you can clear the cache on your browser to remove the outdated file that causes a small problem.

If the issue persists, I recommend contacting our QuickBooks Support so that they can assist you to check your account since they'll be able to pull up your account in a secure environment and help you navigate using one of their tools.

Fill me in if you need more help by leaving a comment below. I'll be around in the Community to help. Take care and have a great day!

Unfortunately I don’t think my discrepancy is a browser issue either.  I am viewing, using Google Chrome.  I bet there is an obvious solution I am missing since the difference is zero on Balance Sheet and today the AR balance is over $1mm.  Thank you all!

It’s nice to see you in the Community, donomccormack.

Thanks for following the troubleshooting shared by my peers and sharing with us the result.

Since AR balance is over $1million, we’ll have to access the company file and review the transactions. The security of your account always comes first, so I recommend you get in touch with our QBO Care Team.

They have tools like screen-sharing to determine what’s causing the discrepancy. Once identified, our specialists will walk you through the steps on how to apply the permanent solution.

The most up to date contact details can be found below.

1. Tap the Help menu in the upper right hand to open the Search window.
2. From there, scroll down to click the Contact us link.
   
3. Type the issue/topic in the field box and then hit the Let’s talk button.
   
4. Select how you want to reach out to our support team: Start messaging or Get a callback.
   

Let me also share the following guide. It contains tips on how to match the amount of your Balance Sheet to the A/R Aging Summary: What is a Balance Sheet report?

If you have any clarifications or questions about QBO, post a comment below. I’ll get back to answer them for you. Enjoy the rest of the day.