Showing results for 
Search instead for 
Did you mean: 
Level 1

A/R Aging Clean-up



I have a new-ish client with a 12+ page A/R aging report. Their books were converted from another software months ago and they have two customer accounts - the one the customer gets billed through and the one that kept track of their retainer amount. The issue is that there are a substantial amount of credit memos created under the retainer account customer creating the large A/R report with negative balances.


How would you go about cleaning up all of the credit memos? I do not want to delete them since we do need the retainer balance from somewhere and they can be very old (I've seen older than 2013) but I need to get rid of the negative balances under each customer so that only the true A/R balances are showing so that the aging report can be useful again. I have tried to journal entry them away and posting a $0 payment but it caused a massive negative million dollar plus balance under the Unapplied Cash Payment Income account. I also tried creating a dummy invoice to absorb the credit and the customer still ended up on the Unapplied Cash Payment Income account. I'm super lost at this point and only have 2 months worth of experience using QB at this point so any help will be appreciated!


Thank you!

1 Comment 1
Level 4

A/R Aging Clean-up



Do you still need help on this?  I have some answers.  If needed, please reply to this post or send me a private message and I can walk you through this.  It sounds like a lot of cleanup, but is doable.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us