How to clear accounts receivables from prior years in QB Desktop
- January 25, 2023
- 2 replies
- 0 views
I have a new client and the database has a problem with the Accounts Receivables. The Balance Sheet and the AR Summary do not tie. There are entries going back as far as 2008 that should not be on the books. Several of these are caused by CC Refunds however those are showing up as if the customers have unpaid invoices rather than credits. The account that was selected in the CC Refund screen was Undeposited Funds and the AR Account is Accounts Receivable. What I would have expected to happen was this to generate a credit in the system that was then applied to an outstanding invoice. That should have cleared the account however the Credit Card Refund was created and a Credit Memo on the same day for the exact same amount. I can not figure out how the AR Aging show that this customer still owes money rather than a credit balance? Furthermore, not only do they not owe these funds I need to get it cleared off the ledger without causing issues in the present day. I am attaching one example of the AR Summary Balance line, then I selected the entry that is the second part of the PDF and the last part is the Customer transaction page so you can see what I am seeing. I have been on the phone with the accountants hotline and they are at a loss as well. Anyone come across this and figure out how to fix this issue?
