AR is always By Name. The point of AR = This Company or Person owes me. And you don't use JE. You want to use Invoice = unpaid sale. That is AR.
AR is one type of asset. Perhaps you are asking about AR, but what you really need is a Loan or Other type of Asset = owed to you, not from Sales to customers. Employee Loan, for instance, or Shareholder Loan. Not AR. Not Sales.
It's an accurate question. I need to do the same thing. SOMEHOW (my predecessor) we got it to the point where we have $0.00 on the A/R aging and yet magically a miscellaneous amount (say, $0.75) remains on the Balance Sheet. So, it's a catch-22: I either have the miscellaneous amount appear on the A/R aging report or on the Balance Sheet. It's just wrong and the preference would be to clear it out of A/R on the Balance Sheet.
Was there an answer posted to this question? I have the same issue where the TB balance in the AR account does not equal the AR Aging balance. I have tried all the usual solutions, but have found no way to fix this.
Hello there, @SusanWoods.
One of the reasons your Account Receivable (A/R) doesn't match on the A/R Aging balance is that the period date and the accounting method are not the same.
I'd 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.
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.
Dop a comment below if you have other questions. I'm always here to help. Take care!
Gosh Maybelle, if the solution was that easy, I would have done it by now. I actually have more than 20 years experience with QuickBooks, so the easy stuff has already been tried.
Thanks for getting back to this thread, @SusanWoods.
Have you tried performing some basic troubleshooting steps already in QuickBooks? If not, you can run your QuickBooks Online (QBO) in a private browser and compare the TB balance in the A/R account to the A/R Aging balance.
Sometimes local internet cache files stored in the system can cause unexpected behavior in the product. Simply press the following short cut keys to access it:
However, if you already did this, I'd recommend reaching out to our QuickBooks Customer Support Team. They have the available tools that can check your account in a secure environment and help verify the issue.
If there's anything else that I can help you with, please let me know in the comment section down below. I'll get back to you as soon as I can. Keep safe.
Thanks ReymondO for again referring me back to the online help steps which I have already worked through. They did not fix my issue. I am not working in QB Online, so that was also not helpful. I guess I should infer that the answer to my question is "NO" and move on. I'm not sure how the TB and AR Aging got out of synch. I'm guessing you have no idea either. Thanks!
I have the same issue, I don't understand why you can't adjust AR or AP. Sometimes it has nothing to do with any invoice.. Accounts ask all the time to move amounts in/out of AR/AP account. Haven't been able to figure out how to do this without having a bogus AP/AR account.