A/R Aging different than G/L
US QuickBooks Enterprise Solutions : 10.0: Manufacturing and Wholesale
How do you correct the accounts receivable in the general ledger which is more than the accounts receivable aging?
1
60
a8PCfs8zer35ZHacfA8pyY
11/16/10 6:55am PST
Viewed by asker 11/09/11 6:52pm PST
Viewed by asker 11/09/11 6:52pm PST
3 Replies
11/17/10 12:28pm PST
First step is to locate the period where the difference is.
Suggest - run a balance sheet - check on if cash basis or accrual - this impacts the balance on the report. Then run the aging.
Start with Beginning of year - go year by year back if it does not match.
Then run monthly reports. Then reveiw the monthly transactions. May have a transaction that debit AR without a customer name.
Another thing to look at. Any opening or beginning balance. QuickBooks AR is a customer and specific transactions. (ie invoices, credit memos)
11/18/10 10:21pm PST
We've done all of this. Every single transaction has a customer name. So we're trying the data rebuild first because maybe something is corrupt because of the one sided difference.
If anyone has been able to fix this one sided entry problem, we would like to know how. How do you change the general ledger accounts receivable account balance without affecting the customer accounts?
qbteachmt
Questions asked: 107
Questions answered: 43424
Points earned: 106555
Questions answered: 43424
Points earned: 106555
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Advisory council of community power users.
Intuit Moderator
Mod/Co-mod
11/19/10 2:34pm PST
Latest post
There is no such thing as a one-sided error or a one-sided entry. Also, there is no way to affect AR without a customer name. However, many people make a mess of the AR balance by attempting to do so. They use journal entries and or they use a generic customer name. All of which is the wrong workflow and can cause havoc with the data when viewed using a report that lists actual customer info.
I agree with John: I would try running side-by-side reports until you hit the period where this discrepancy arises. Then, look at the details of the AR account to see what transaction created the problem.
For diagnosing AR, always run the balance sheet on accrual basis.
If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.
If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
