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.
I have the same issue where I need to correct the AR balance in General Ledger to match AR aging. Just to be clear, I print the GL TB and AR aging reports as of 12/31/2099. If i assign a fictitious customer, then my GL is correct and my Aging is wrong. QB has to allow ADJUSTING JOURNAL ENTRIES to Balance Sheets accounts WITHOUT affecting Income Statement. SAGE and other ERP allow it!!!
I'm here to ensure your Accounts Receivable A/R accounts balance is in sync with your AR aging balance.
Just to make sure we're on the same page here. Have you tried pulling up the reports as suggested by my colleague Maybelle_S above? If not, I recommend performing the steps provided.
If you have, and the issue persists, I propose contacting our support team. There, one of our agents can securely look into your account and investigate the cause of this discrepancy. Let me guide you on how to reach out to them:
Go to the (?) Help icon in your QuickBooks Online (QBO) account.
Select the Search tab.
Click Contact Us.
Enter a brief discussion of your concern and click Continue.
Select either Chat with us (if you preferred messaging) or Give us a call.
You can also see this article for more details and ensure to review their support hours to know when agents are available: QuickBooks Online Support.
Let me also share these articles that you can utilize for future use. These can walk you through the steps on how to modify your reports base on your preference and reconcile your account flawlessly:
If you have any follow-up queries about your trial balance report, make sure to tag me in your response. I'm always here ready to help you anytime. Keep safe and always stay healthy!
I have a commission due from a vendor at year end. I would like to set up a Miscellaneous Receivable because it does not involve a customer. Where do I put it if not in receivables.
Still don't see answer to question: How do I post a journal entry to AR (or AP) without specifying a customer (vendor) name? We have same problem - somehow Aging Rpt has different balance than Balance Sheet. Want to adj Balance Sheet without adjusting aging. What is the work around????
Hello there, rchidester. I understand your frustration with this issue.
When creating journal entries in QuickBooks Desktop (QBDT), Accounts Receivable (AR) or Accounts Payable (AP) requires a customer or vendor name assignment.
Additionally, the A/P aging report shows aging bills as of the report date, while the balance sheet A/P counts open bills on an accrual basis, regardless of payment status. As a result, both reports can show different A/P amounts for a given period.
To learn more about running reports in QBDT, you may check this article: Understand reports.
Let me know if you have other questions about adjusting the balance sheet in QuickBooks. I'm always here to help.
I am having the same issue several people above have, and its really concerning that QBO does not seem to have a solution for this. The aging reports do not tie to the G/L and its very difficult to pinpoint why or fix the problem. I don't even have a significant amount of time that I would need to sift through, but even if i found it now, it does not seem like there is a good solution here.
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.