Need help clearing AR issue
I've been unable to get a problem fixed for a client. They do construction jobs and often have credit amounts going in and out of AR related to retainage and DOT withholding. Normally these things will clear out to zero once the job finalizes but we've had one get stuck and nothing I do fixes it.
Currently the way things are showing in QB is:
A/R Aging shows -23,484.12
Total A/R Aging balance is 995,638.36
A/R Ledger and TB balance is 1,019,122.48
Balance on job in customer center is currently zero
Detail on the A/R Aging shows a mix of 3 unapplied payments and 2 credit memos. If I go to fix unapplied customer payments and credits, I can see all 5 of those but the amounts in this module do not agree with the A/R detail - in particular one credit memo is way off. Aging shows -11,742.06 for that memo. The fix unapplied payments module shows 3,446.85 available to apply for a difference of 8,295.21. But the credit memo itself was only issued for 1,495.44.
Ultimately, this job is closed so the zero balance in the customer center is correct. Total A/R on the GL/TB is also correct. It's the aging report that's haywire but everything I do that fixes the A/R report (like creating an invoice to apply everything to) ends up creating an open balance in the customer center and increases my A/R in the ledger.
This is driving me and my client nuts trying to get this balance out of there. Any thoughts?