AR aging clean up

SOLVED

Hello,

I have taken over the accounting at a company and I want to make the books "clean".  I have gone through the AR aging and there are many customers with relatively small credit balances in AR that were recorded as deposits at the time (they overpaid).  We have contacted some of the clients with the bigger credit balances and none want it because it's too small (and/or we don't do business with them anymore).

I am trying to clean out the the AR by doing the following: if there is a deposit, I tried making a sales invoice for the same amount:

However, the above transaction gives the following journal entry:

This, obviously, does not balance (and I am not sure why).  According to my logic, once upon a time the entry was:

Dt. Cash
Cr. AR (deposit)

Now I just did (via invoice):

Dt. AR
Ct. Miscellenous revenue

And I want to finally do:

Dt. AR (deposit)
Ct. AR (misc. revenue)

But the last entry does not balance... I don't know why.  It might be important to mention the functional currency is $CAD and some clients are in $USD or EUR

  • 0

    Lookup the original deposit and look at the exchange rate there.  Then use the same one on the invoice and the receipt should take care of itself but you may need to play with the rates a little to get this receipt's journal entry to nothing.  It's been a while since I have had to fix one of these but I believe that was the angle I took.

  • 0
    verified answer

    Hi coreydotcom,

    As per your screen shot, you are missing a Deposit and Prepaid linked account under Setup, Settings, Customers & Sales, Linkded Accounts.  This is the reason why you only have your Accounts Receivable credited.  

    When you create an invoice, it will DR Account Receivable and CR Revenue Account.

    When you do a receipt and use prepaid deposit, it will DR Deposits and Prepaid account and CR Account Receivable.

    Hope this helps.

  • 0 in reply to Keith L

    Thanks Keith, this fixed the problem.  Thanks a lot to other contributors.